Unknown column 'pack_stock_type' in 'field list'Can you find "pack_stock_type" in your prestashop database? If not, that maybe the case. Here is how you could solve the problem when you imported products from prestashop 1.6.0.9 to an updated prestashop version 1.6.014 and got that error: Getting Unknown column 'pack_stock_type' in 'field list' error
UPDATE `ps_product` SET `id_product` = '788638',`id_shop_default` = '1',`id_manufacturer` = '0',`id_supplier` = '0',`reference` = '',`supplier_reference` = '',`location` = '',`width` = '0',`height` = '0',`depth` = '0',`weight` = '0',`quantity_discount` = '0',`ean13` = '',`upc` = '',`cache_is_pack` = '0',`cache_has_attachments` = '0',`is_virtual` = '0',`id_category_default` = '2',`id_tax_rules_group` = '0',`on_sale` = '0',`online_only` = '0',`ecotax` = '0',`minimal_quantity` = '0',`price` = '0',`wholesale_price` = '0',`unity` = '',`unit_price_ratio` = '0',`additional_shipping_cost` = '0',`customizable` = '0',`text_fields` = '0',`uploadable_files` = '0',`active` = '1',`redirect_type` = '404',`id_product_redirected` = '0',`available_for_order` = '1',`available_date` = '0000-00-00',`condition` = 'new',`show_price` = '1',`indexed` = '0',`visibility` = 'both',`cache_default_attribute` = '0',`advanced_stock_management` = '0',`date_add` = '0000-00-00',`date_upd` = '2015-02-27 13:10:02',`pack_stock_type` = '3' WHERE `id_product` = 788638
1. Backup your existing prestashop database using phpmyadmin or other tools that suit you.
2. Run SQL command like bellow :
ALTER TABLE `ps_product_shop` ADD `pack_stock_type` int(11) UNSIGNED DEFAULT '3';3. Checked value of ps_stock_management in ps_configuration table and if found out the ps_stock_management field value was: 0 so updated database with this instruction.
UPDATE `ps_product_shop` SET `pack_stock_type` =0 WHERE `pack_stock_type` =34. You could do the same for table 'ps_product'