Jump to content

Mass modification of product positions


PierreAlst

Recommended Posts

Hello everyone, 

I'm facing a problem. 
I have +8000 products on my Prestashop and I regularly have new collections with dozens of new products at a time. I can't find a solution to change the position of the products in mass. 

Let's say I add 50 products. I use my import file to add all of them in one time and they are automatically displayed first (because there's a rule that says that products are displayed in descending order according to the ID of my product files). 

How can I change the position of my products without requiring specific development? And if it does require specific development, how do I go about it? 

Thank you in advance for your feedback :) 

Pierre

Link to comment
Share on other sites

There is the concept of the position. You can define the position of the products in each category. 

ps_category_product is the table in which position is saved & default PrestaShop theme sorting according the that only i.e. 

 

image.png.25be7ae48e904e439c59e3a105009315.png

 

You need to change the theme code to display the sorting according to the position instead of the latest on top and need to define the position of the product. 

Position can be either defined at the time of product import OR can be defined from the admin product listing page. 

 

Go to admin -> Products -> Apply Filter by category. 

Rearrange the position of products by drag

 

 

image.thumb.png.cba9c128e24ad5025b20923b29f54ac1.png

 

Link to comment
Share on other sites

On 2/25/2025 at 10:19 PM, PierreAlst said:

Hello everyone, 

I'm facing a problem. 
I have +8000 products on my Prestashop and I regularly have new collections with dozens of new products at a time. I can't find a solution to change the position of the products in mass. 

Let's say I add 50 products. I use my import file to add all of them in one time and they are automatically displayed first (because there's a rule that says that products are displayed in descending order according to the ID of my product files). 

How can I change the position of my products without requiring specific development? And if it does require specific development, how do I go about it? 

Thank you in advance for your feedback :) 

Pierre

You can reorder products in Catalog > Products > Positions by dragging them. For automated sorting, a module like Advanced Sorting or a theme edit may be needed. https://bulkwear.us/

Edited by HarryBrok (see edit history)
  • Like 1
Link to comment
Share on other sites

Hi, 

Thanks for your feedback. 

We really need to be able to change the position of dozens of products at once. 
I think we need a .csv file with two columns: column 1: product ID; column 2: product position. 
But I don't know if it's possible to do this, and if so, how? 

Thanks again, 
Pierre 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...