Capture additional product information for an order

[bigsy85]

Still trying to figure this out. Within the shopping cart class theres the add_to_cart class, I'm guessing any additional information has to be passed within that.

Also for what I'm wanting to achieve, would I first have to store any new information regarding the product in the customers basket table?

Would really appreciate any help with this.

Thanks

[Ajeh]

Where is this text box for color on the product's page coming from?

Is it in the products table? Is it an Attribute?

If in the products table what is the field name?

Do you have a matching field name in the orders_products table?

[bigsy85]

Hi Ajeh,

The value that I want to store isnt in any tables, to get this working I want a textbox which can have text written in which becomes the value that will be stored, placing this into a variable that will then be stored in the orders_products table with the relevant field name.

For example

Product Page > text box [colour] > store txt in $colour
Process Order > put $colour in orders_products [colour]

The reason for this is I can store information for each ordered product.

[bigsy85]

Having another thought about this, I can still use attributes to store the data, I was thinking I couldnt then sort orders by these BUT I could create a WHERE attributename = the attribute I want to sort orders by.

Maybe I was over complicating it the other way