dt88 Posted October 19, 2010 Share Posted October 19, 2010 is there a means to mass modify the product category data?I have imported all my products from oscommerce, but all the products only show in the 3 deep sub category and nothing in the parent categories. makes the site look very empty until you click 3 deep.I tried exporting all the products then reimporting them, only they didn't like the subcategories and stuck them all under parent categories, thus i had 250 categories on my home page. Wasted a bit of time doing that, thinking it would be straight forwardthoughts? Link to comment Share on other sites More sharing options...
rocky Posted October 20, 2010 Share Posted October 20, 2010 Manually editing products and importing a CSV file are the only ways in PrestaShop to do this. I've written an SQL query here that might help. Link to comment Share on other sites More sharing options...
dt88 Posted October 20, 2010 Author Share Posted October 20, 2010 Rocky,you are a legend, worked perfectly, haha i got myself lost trying to do a sql myself. you saved me so much time, the site flows some much better and took 30 secondsgreatly appreciatedcheers,DT Link to comment Share on other sites More sharing options...
dt88 Posted October 20, 2010 Author Share Posted October 20, 2010 Rocky,you wouldnt have a script that would change the default category in the product edit by chance, everytime i open a product that has been imported in from oscommerce, it has a default cat as 'home' when it should be the subcategory that it is currently. I cant save the modification to the product file until i change it to the correct sub-category.Cheers,DT 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