Hi,

Hopefully you guys can help me out, tried searching with no answers.

My question is, can I add additional fields to the orders_products table that stores the information for each product of an order. What I want to achieve is from a txt box on the product page store this into a field when added to basket as you would with qty – and record this in the orders_products table once the user checks out.

The reason for doing this instead of using attributes which is an obvious solution is because I already capture attributes, but I want to be able to sort using my own report(sql) products by the additional field I will capture.

Many Thanks