PrestaShop: get Order Product combination attribute value

Trabla: PrestaShop: Order Product attribute value


Solving:

Orders are strored in table ps_orders
List of items (Products) of Order are stored in table ps_order_details 
(ps_orders to ps_order_details => one to many, one record in ps_orders can have one or many records in ps_order_details )
Each row in ps_order_details has field 'product_attribute_id'  reference to table
ps_attribute_combination - has only two rows "id_attribute" and "id_product_attribute"
"id_attribute" is reference to table ps_attribute


PrestaShop database schema:
http://www.daveegerton.com/assets/images/database-schema-prestashop.png

No comments:

Post a Comment