I'm working with Magento version 1.4.1.1, and I want to save a value in sales_flat_quote_item table (and pass it to sales_flat_order_item ). I've ...
Suppose you want to add column to some table before it gets save in Magento. Example, Magento doesn't save regular price of product when ...
... can be found here: https://stackoverflow.com/questions/17947179/how-to-add- product-specific-attribute-column-to-sales-flat-order-item-table.
The sales_order_item table ( sales_flat_order_item on M1) contains records of all ... for a specific sku is most often represented by the qty_ordered field.
Both these tables, sales_flat_order_item and sales_flat_order , serve different purposes in
entity_id', array('skus' => new Zend_Db_Expr('group_concat( sales_flat_order_item.sku SEPARATOR ", ")')));. $select-> ...
2 Answers · add your product attribute to quote item to global node in config.xml <
sales>
item_id – This column is the primary key of the sales_flat_order_item table.
new Zend_Db_Expr('group_concat(`sales_flat_order_item`.sku SEPARATOR ", ")')));.
entity_id', array('skus' => new Zend_Db_Expr('group_concat(` sales_flat_order_item`.sku SEPARATOR ", ")')));.