The system can be adjusted to all types of price lists. There is no standard format for a price list. It is random.
Do you create price lists before uploading them to the website? What's the point? Everything is set up so you will use the price list of your vendor (supplier), adjust configurator and update the E-shop items in one mouse-click.
“Upload items from all configured worksheets” button will appear only after you specify the value of incoming price. “Price” parameter is an optional one. It means that if the purchasing price as well as the selling price is indicated in your price list, you may just specify the “Price” parameter without using pricing matrices. In case the selling price is indicated in your price list, specify it as incoming one as well. Use markup matrix with value field “1” for the whole price range. But keep in mind that the shop will not be able to calculate your “profit” then.
You need to divide your price list into categories with items. And then you may arrange these categories in any hierarchy or change their names in Categories management. This needs to be done once. It will not effect further price updates. It means that if a new item will appear in a category from a price list, it will be in the same category after the update in spite of category's changes.
Create the price list you need in Microsoft Excel. I did it like this:
Save it in .xls 97-2004 format
Go to Control panel->E-shop->Processing of .xls price list
Set the configuration. I did it like this:
Incoming price is a mandatory field. If you haven't created the following category before, it would be created automatically
Click “Upload items from all configured worksheets”
Do not forget to click “Save current configuration” as well
Further updates can be easily done via editing .xls file