I'm doing a site rebuild, and forgot just how difficult it is to accomplish that goal on a large build ...
I first import the section text part of the Excel sheet to setup the sections and subsections. I then link the spreadsheet fields with the site, which creates thousands of orphaned products.
I then change the Short Description field link to the section Excel field which allows dragging and dropping of all of the items to the appropirate section, and aferwards change this linked field from section to sub-section to allow easy identification and dragging into the sub folders.
All in all, a tremendous amout of manual work.
Is there any way, perhaps with an add-in to import/link an Excel database and then use the existing site to export a flat file Excel sheet? I doubt it.
The straight linkage works fine, but it doesn't import the sections, nor move the items into the section. It's a major pain in the .....!
Ideas?
I first import the section text part of the Excel sheet to setup the sections and subsections. I then link the spreadsheet fields with the site, which creates thousands of orphaned products.
I then change the Short Description field link to the section Excel field which allows dragging and dropping of all of the items to the appropirate section, and aferwards change this linked field from section to sub-section to allow easy identification and dragging into the sub folders.
All in all, a tremendous amout of manual work.
Is there any way, perhaps with an add-in to import/link an Excel database and then use the existing site to export a flat file Excel sheet? I doubt it.
The straight linkage works fine, but it doesn't import the sections, nor move the items into the section. It's a major pain in the .....!
Ideas?
Comment