CrystalPhoenix18 Posted February 26, 2017 Share Posted February 26, 2017 This is probably pretty basic, but my .csv imports have created a massive number of subcategories (my fault for not accurately entering category ID's in my csv import). How can I find out if there are any products within these numbered categories so I can move them to the correct categories? Link to comment Share on other sites More sharing options...
Geo Burlibasa Posted February 26, 2017 Share Posted February 26, 2017 You could build an SQL query for the table "category_product"; ex: "SELECT `id_product` FROM `_DB_PREFIX_category_product` WHERE `id_category` IN (1,2,3) 1 Link to comment Share on other sites More sharing options...
CrystalPhoenix18 Posted February 26, 2017 Author Share Posted February 26, 2017 I was hoping there was a way to do it through the back office. I'll try the sql query and see what happens. Thank you! Link to comment Share on other sites More sharing options...
Geo Burlibasa Posted February 26, 2017 Share Posted February 26, 2017 You could use "Filter by category" in "Product list" then. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now