Developer forum

Forum » Development » eCommerce - Orders doesent store productfields

eCommerce - Orders doesent store productfields

E-mail notifications

Reply
Posted on 25/08/2010 14:32:02
It looks like the table EcomOrders/EcomOrderOrderLines does not store product description and other product fields including custom product fields on an order.

I'm aware i can match up the orderline's product id to a product in the product table, however if a product has changed values since purchase the result will not be correct it will display new data and not the actualy data of the purchase,

Also if its not stored on an order, we risk changing customers receipts when changing product information if we match up like that, which is not a good idea.

Any ideas on what we can do?

Replies

 
Nicolai Høeg Pedersen
Posted on 26/08/2010 12:01:24
Reply
Only the product name is saved on the orderline.

To save the rest of the product information, create a custom orderline field, make a notification subscriber on order completed and save all product information as xml/json to the custom field. Then the data can be reused as it was later on.

BR NP.

 

You must be logged in to post in the forum