Jump to content
Luiwii

Delete specific price rules

Recommended Posts

Hi, I need help with my Prestashop, I worked with a platform that created specific price in each product of my catalog, now I need to erase all of that specific prices in order to create catalog price rules. The problem is that I have more than 5k products, I can´t erase the price one by one, i need to do it in Bulk. Please, I need an explanation for doing that. Thanks in advance.

 

 

Hola, necesito ayuda con mi Prestashop, trabajé con una plataforma que creó un precio específico en cada producto de mi catálogo, ahora necesito borrar todos esos precios específicos para crear reglas de precios de catálogo. El problema es que tengo más de 5k productos, no puedo borrar el precio uno por uno, tengo que hacerlo en masa. He intentado hacer una consulta SQL pero el CSV que se descarga está vacío. Por favor, necesito una explicación para hacerlo. Gracias por adelantado.

Share this post


Link to post
Share on other sites

You can remove all records from table ps_specific_price. Please also check if you have any record at ps_specific_price_priority, ps_specific_price_rule, ps_specific_price_rule_condition and ps_specific_price_rule_condition_group.

If you want to use a module to remove and manage specific prices, you can use this module https://addons.prestashop.com/en/price-management/39351-edit-specific-prices.html

  • Like 1

Share this post


Link to post
Share on other sites

Hi, thanks for the answer, I have a problem, I downloaded the tables but they are empty, there is any data with this tags from specific price. I need to erase specific prices from 5k products and I can´t do it manually, please, tell me if there is any other option to erase them in bulk. I atach you a picture where you can see to which specific price rules I mean.

Thanks for your help.

Captura de pantalla 2019-11-12 a las 16.11.39.png

Share this post


Link to post
Share on other sites

This information is stored at ps_specific_price table. Please check it again.

Share this post


Link to post
Share on other sites

Hi, on the screenshot number one you can see what appears when I press on the specific price table, I have to select all of the tags on the left and then save?, I did it and the csv that was created was empty (screenshot 2). I don´t know what else to do, I really need to erase all the specific prices, please, help me.

1.png

2.png

Share this post


Link to post
Share on other sites

Create a custom SQL like:

SELECT * FROM ps_specific_price LIMIT 50;

and execute it.

Share this post


Link to post
Share on other sites

Hi, excuse me but I´m new and I don´t know how to create that custom SQL and execute it, can you explain me how to do it?.

Thanks.

Share this post


Link to post
Share on other sites

Hi, I managed to download the CSV with the specific price table, tell me if the archive is correct please. Now I want to know what I have to do to delete specific price rules and how to import this in order to delete the rules on my Prestashop. I just want to delete specific price rules, anything else, please, tell me how to do the process, atached you can find the CSV.

Thanks.

request_sql_16_(2).csv

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More