Lucky Posted September 17, 2018 Share Posted September 17, 2018 Can I delete the 2 root categories? Or can I give them another (negative?) ID? I need to import a .csv file that is exported by another software and it contains categories with IDs 1 and 2, which are already used by the 2 root categories. These IDs are also used in the products.csv so I can't skip those lines or give them another number because then I need to rename all products.category_id every time there's an export/import (every 24 hours). So, can I delete the 2 root categories? Or can I give them another (negative?) ID? Or how to make sure ID's 1 and 2 become available to imported categories? Thanks for any quick help. Link to comment Share on other sites More sharing options...
Rolige Posted September 17, 2018 Share Posted September 17, 2018 You can't delete these categories. You can import your new categories without keep the original ID. Link to comment Share on other sites More sharing options...
Lucky Posted September 17, 2018 Author Share Posted September 17, 2018 (edited) If I import the new categories without keeping their original ID then my products with category_id 1 and 2 won't be in the right category anymore. And also all other products will shift 2 categories. And I can't change the products.category_id before the import because they are exported from a third party software every 24 hours. So how can I solve this? Edited September 17, 2018 by Lucky (see edit history) Link to comment Share on other sites More sharing options...
electriz Posted September 17, 2018 Share Posted September 17, 2018 Hi, I would recommend to change those ID's number from 1 and 2 (in the source where it comes from) or modify the importer to check if ID is 1 or 2, Then assign it to corresponding new IDs. 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