Adding a price field in the order_products table

[sumeshsadau]

Hi,

I have a requirement to save another price also ( apart from products_price and final_price) to the order_products table since this price also varies.

This third price represents price from the whole sale dealer ( product_price is the actual market price and final_price will be the discounted price.

I have this price updated in the products table in the custom2 field.
When an order is placed i need to update this price also in a new field in the table order_products ( since there are no custom field for this table).

Is there a way by which i can acheive this

[ryan]

Hi,

I can't think of a workaround for what you are trying to achieve. We'll add some custom fields to the order_products table for a future release.

-Ryan