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 :)

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

F. Rules:

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


Regards,
Straightlight


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 v2.2 with multi-stores from http://www.labeshops.com which has links to all my stores.

Image


User avatar
Expert Member

Posts

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

Users browsing this forum: No registered users and 23 guests