Is there a simple solution to finding items that may not be linked to a category?
I have reason to believe that there are products I have on my website that are not linked to a category therefore not showing up on the website at all for sale.
I would like to find those and attach those to their appropriate categories so they show up for sale...
Perhaps the easiest way is to search through database with this sql:
select product_id, name
from product_description
where product_id not in (select product_id from product_to_category);
So in product_to_category table there's the actual link between product and category
select product_id, name
from product_description
where product_id not in (select product_id from product_to_category);
So in product_to_category table there's the actual link between product and category
The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."
Who is online
Users browsing this forum: Amazon [Bot] and 36 guests
