Mass filter products by pasting references or ids

Mass filter products by pasting references or ids

Jan 26, 2017
Prymex wrote
Since we started using PS Manager we have been missing such a feature.

Imagine that you have a shop with 10 000+ products.
You have a list with, let's say, 300 random products and you want to filter them out at once.
Inputting couple hundred of items to filter is not a fun task :).
And it takes a lot of time too.

What if you could insert multiple ids or references to filter at once?
It would be a great time saver.

So, you have a list of items that are separated by newline/semicolon/comma.
You select what to filter on (reference, id, price, etc).
Then you paste the items in the filter builder or some other popup and voilà, you have 300 hundred random products filtered.

After that you can mass add specific prices, move them to a special discounted category, create an order, etc. sky is the limit.
1 vote
6 Answers
Avatar image
Jan 27, 2017
Alex Pryshlivskiy agent wrote
God day!
How about Custom Filter with a ``condition.
For example, you'll be able to select product ids from 1 to 100
see screenshots.
Jan 27, 2017
Prymex wrote
Nope, that's not it.
The point is to be able to select a RANDOM list of product references/ids.

We usually export them from our warehouse software.
Sometimes clients send us a list through e-mail, and so on.

But thank you for the suggestion.
Avatar image
Jan 27, 2017
Alex Pryshlivskiy agent wrote
ok. you'll be able to do a special hack for your situation.
Please create a SQL query in the file ProductFilters.dat with list of your id's

Step 1 - go this path - c:\Users\USER-NAME\AppData\Local\eMagicOne Store Manager for PrestaShop\

Step 2 - Open file - ProductFilters.dat
Add this SQL
Where 3,5,7 - list of products ids

[Filter #0]
ProdFiltersMDFilterValue=3 5 7
ProdFiltersMDFilterSQL=(T1.id_product IN (3, 5, 7))

Step 3 - Save file and Run Store Manager
Step 4 - use Filter drop-down menu to active a filter.

I hope it works for you. :-)

Jan 27, 2017
Prymex wrote
Nice, it works.
T1.reference is what we were looking for.
Thank you.
Avatar image
Jan 27, 2017
Alex Pryshlivskiy agent wrote
Thanks for a confirmation! :-)
Have a nice weekend.
Feb 01, 2017
System wrote

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team