massive price bulk for prestashop

[blasfemerd]

Hi, all

best module for massive change price in prestashop?
I have a store with 400 product with combinations with same price for all.

thanks a lot

 

[ciko3650]

400 products is not a lot... try this module, maybe it will help

v1.7-v8x - ETS Product Manager – Bulk Edit/Mass Edit/Quick Edit v1.4.0 (NEWEST 11 Jan 2024)

Product Manager – Bulk Edit/Mass Edit/Quick Edit v1.4.0 PS 1.7.4. - 8.x by ETS (prestahero) Quick edit, mass edit, bulk edit, customizable product listing, instant product filter and more! Product Manager is a PrestaShop mass edit products module that offers you the fastest and most effective...

www.nulledfrm.com

Post automatically merged: Apr 20, 2024

Here’s how you can bulk edit prices in the PrestaShop database using SQL:

1. Using phpMyAdmin:
   • Access your phpMyAdmin or any other database management tool.
   • Locate the table containing product data (usually ps_product or ps_product_shop).
   • Update the prices as needed. For example, if you want to increase prices by 5%, use an SQL command like this:
     UPDATE ps_product SET price = price * 1.05;
     
     Note that prices in the database are usually stored without tax 1.
2. Prestools Module:
   • There’s a free solution called Prestools that allows bulk editing of prices. You can search for it and install it in your PrestaShop.
   • Keep in mind that it might not handle variations directly, but it’s useful for bulk updates.
3. Mass Product Changer Tool:
   • If you prefer a user-friendly approach, consider using the Store Manager Mass Product Changer tool. It allows you to update prices, stock, and other product-related fields for multiple products at once 2.

Remember to back up your database before making any bulk changes and test them on a copy of your store.