I,


i need to reformat a spreadsheet and convert to .csv so i can automatically prepare monthly prices list for an ECommerce site using HikaShop shopping cart plugin for Joomla.
I need recommendation as to the most elegant way to archive this so there is the minimum monthly manual input required in the conversion.

A sample of the price list from Polycom has been attached and placed in a Dropbox folder for DL.
Here are the instructions from HikaShop support;

"You can add one category per row in the csv. They must be filled in the column "category" and "parent_category" depending on the three.
Example:
parent_category;category
;realpresence room
realpresence room;HDX Executive Collection Stand Systems
realpresence room;Service - HDX Executive Collection
HDX Executive Collection Stand Systems;Installation Services

You just have to keep this format, but the categories can be in row1, 3, 9 and 14. You just need to have the parent category before the child one."

Attached Files

Polycom Price List May 2014.xlsx (434.6 KB, 17 views)