Post by ninad_jad » Sat Jan 13, 2018 3:27 pm

Hi, is there is any way to get list of Products which is not linked to any store, I have tried with SQL query, but I am not very much into SQL so i am not be getting expected results.

do you guys have any solution to find such list of products?

i want this because recently i got to know that few products are not mapped to any of the stores. so i want to find.

New member


Mon Dec 30, 2013 3:11 pm

Post by straightlight » Sat Jan 13, 2018 10:33 pm

Of course. This extension may help you greatly: ... n_id=32544 :)

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.

F. Rules:

- viewtopic.php?f=176&t=200480
- viewtopic.php?f=176&t=200804


Legendary Member


Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by labeshops » Sun Jan 14, 2018 12:33 am

I use quick product edit mod for thing like that and a ton more - ... on_id=3369

You can add the store column to your product list and then sort by store to easily find ones that are blank and add a store to it from right there in the product list.

Running Opencart v2.2 with multi-stores from which has links to all my stores.


User avatar
Expert Member


Thu Aug 04, 2011 4:41 am
Location - Florida, USA
Who is online

Users browsing this forum: edwardr and 26 guests