Category Import issue...please help.
Posted: Thu Apr 29, 2010 3:05 pm
Hi,
I have a website I'm working on which deals with automotive parts. Have it setup so that customers can browse for parts based on either type (compressor, coil, switch) or application (year, make, model and engine).
I've been working on a large .csv file for the categories and pushing it to the site each time a group of applications is complete. My problem is that between my last upload and now, someone entered 7 categories through the admin and then deleted them after realizing they were not necessary. I have literally thousands of new rows of info to upload...but now the CategoryID and ParentID for the new .csv file I have is off by 7...through more rows of data than I want to think about. I would have simply restored the database, but the "good" backup had already been overwritten by the "bad" one. Please tell me there is some way, some easy way, to take the old info from .csv file I downloaded from the databse and merge it with the info in the new .csv I have and replace all the category info currently on the database. I really, really dont want to go through line by line in Excel checking and double checking to be sure that all CategoryID and ParentID numbers are increased by 7 to compensate for the ones that were added through the admin.
Thank you,
(Holding out for hope)
I have a website I'm working on which deals with automotive parts. Have it setup so that customers can browse for parts based on either type (compressor, coil, switch) or application (year, make, model and engine).
I've been working on a large .csv file for the categories and pushing it to the site each time a group of applications is complete. My problem is that between my last upload and now, someone entered 7 categories through the admin and then deleted them after realizing they were not necessary. I have literally thousands of new rows of info to upload...but now the CategoryID and ParentID for the new .csv file I have is off by 7...through more rows of data than I want to think about. I would have simply restored the database, but the "good" backup had already been overwritten by the "bad" one. Please tell me there is some way, some easy way, to take the old info from .csv file I downloaded from the databse and merge it with the info in the new .csv I have and replace all the category info currently on the database. I really, really dont want to go through line by line in Excel checking and double checking to be sure that all CategoryID and ParentID numbers are increased by 7 to compensate for the ones that were added through the admin.
Thank you,
(Holding out for hope)