Hi,
I think you need more knowledge on how ECommerce works within Joomla.
OK here goes,
Firstly you need Categories and if necessary Sub-Categories then within these Categories you place the individual Products.
e.g.

Category = Shoes
sub Category = Mens Shoes
2nd sub category = Mens Sports Shoes.
After categories are created, you then add the individual Products.

I think the above example is easier to follow than the Polycom Price list.

In order to export these results to the E-commerce Joomla plugin called HikaShop, you finally need to take the very simple step of converting the resultant spreadsheet to a .csv format.

However, if you have no experience in creating E-commerce sites from external spreadsheets, I can understand your initial confusion.

My requirement is to create (VBScript or Macro?) that will automate the conversion to a column and row format as outlined by the HikaShop support team,


Best regards,

Tim