german Posted September 4, 2018 Share Posted September 4, 2018 I'm able to modify the category_default with the following lines, UPDATE ps_product_shop SET id_category_default = 69 WHERE id_product in ( select id_product from ps_product_lang WHERE name LIKE '%aire aco%' ); However, when I check, the previous category and the new one appear together for the product. I don't know where to find the table containing all the categories for the same product. Could you help me with this? Link to comment Share on other sites More sharing options...
Knowband Plugins Posted September 4, 2018 Share Posted September 4, 2018 Your query is not clear but please find below the response as per my understanding. Default category mapping of the product is saved in the product table itself. Refer to id_category_default column of product table. Other categories mapping of the product is saved in the category_product table. 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