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
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
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(); ?> […]
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. […]
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 […]
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`, […]