Capture additional product information for an order

[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