Prestashop: Clean Database
DELETE w FROM product_shop w LEFT JOIN product e ON w.id_product = e.id_product WHERE e.id_product IS NULL DELETE w FROM product_lang w LEFT JOIN product e ON w.id_product = e.id_product WHERE e.id_product IS NULL
Category: Prestashop
Prestashop: Debug Mode and Memory Upgrade
To turn on debug mode go to: config/defines.inc.php Set define(‘_PS_MODE_DEV_’, false); –> define(‘_PS_MODE_DEV_’, true); To upgrade PHP Memory Limit vim /etc/php5/apache2/php.ini — Go to Memory Limit. To check PHP Config create a file with the following code. <?php phpinfo(); ?> […]
ERP to Webstore Integration
Inventory is on iDempiere Script to get inventory on CSV File Script to upload CSV File from iDempiere’s server to webstore SSH to Remote Webstore to execute update Script Current Problems… Script to Export puts ” ” on the String. […]
Pretashop: Add and Update products Programmatically
I’m working on a project where I need to add products from our ERP System to a Prestashop Catalog, and need to regularly mass update (10,000 products) some information on specific product (Pricing, Stock Information etc…) Current Situation: I’ve managed to […]
Prestashop: Edit Meta Title Info
My Goal: I want the Title of the page to show, Manufacturer Name – Part Number Steps: Go to Meta.php Go to the Section getProductMetas public static function getProductMetas($id_product, $id_lang, $page_name) { $sql = ‘SELECT `name`, `meta_title`, `meta_description`, […]