adding extra info to the db

sergeh

2007-01-26 18:58

Hey guys,

does anyone know what files need to be modified so I can add extra info to the products.php ?

Right now when an item is saved, these are the fields in the db

iProduct
sName
iPrice
sDescriptionShort
iStatus
iPosition

I'd like to add 2 more values, iShip and iSold, what files need to be changed?

I already added the 2 dropdowns I need in products-form.php

thanks in advance

sergeh

2007-01-26 20:16

ok I found it, the only problem I'm having now is that the state of the dropdown isn't saved.
So let's say in my 2 dropdowns I choose no and in the db it shows $0$0 like it's supposed to but when I go to edit the product, the dropdowns still display "yes"...

in products_form.php I've added

$lang[Visible] 
<select name="iStatus">
$sStatusSelect
</select>
&nbsp;&nbsp;|&nbsp;&nbsp;
$lang[Heavy]&nbsp;
<select name="iShipp">
$sShipSelect
</select>
&nbsp;&nbsp;|&nbsp;&nbsp;
$lang[Sold]&nbsp;
<select name="iSold">
$sSoldSelect
</select>

in actions_admin/products.php I've added these right after the $sStatusSelect line

$sShipSelect = throwYesNoSelect( $aData['iShipp'] );
$sSoldSelect = throwYesNoSelect( $aData['iSold'] );

and in actions_admin/categories.php I've added the same lines right after $sStatusSelect

so what am I missing??

sergeh

2007-01-28 21:47

nevermind guys found it on my own. If someone wants a tutorial on how to display products but not let users add it to their cart let me know. Or how to show that an item has been sold out.

idaryl

2007-01-28 23:51

This is a second "yes - that would be great" for this as well

trzykas

2007-01-29 01:15

serge yes the second one is the great thing ! If you can do this for us :>

trzykas

trzykas

2007-01-29 01:18

sergeh the second solution about "sold out" is to witch version of qc i hope for 1.4 it will be great because this is the one of few function in qc what i really need.

trzykas

sergeh

2007-01-29 01:21

yup it's for 1.4 but for now my solution is manual, meaning that when you edit a product there's an option to make it sold out. Maybe when I have more time, I'll find a way to make a real stock counter

luke1

2007-01-29 09:40

Hello sergeh,

Do you have a tutorial voor adding more fields in quick cart. ?
I would like to receive it if possible, maybe you can send it to luke 'at' lenconcepts.nl

Greetings luke

trzykas

2007-01-29 23:55

sergh so if you can write this solution here :)

trzykas

sergeh

2007-01-31 06:10

I'll post a new topic in about 2 days with the tutorials :)

trzykas

2007-01-31 15:55

thx !

trzykas