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

Posts

Joined
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: https://www.opencart.com/index.php?rout ... n_id=32544 :)

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
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 - https://www.opencart.com/index.php?rout ... 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 v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.


User avatar
Expert Member

Posts

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

Users browsing this forum: Bing [Bot], JessiesBoutique, SelfSus, softmonke, systemmaker, tilly and 519 guests