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.


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: No registered users and 28 guests