Prices change and stock data have to be maintained – if the product range is relatively large, processing data in the store management feature may take some time to complete. This is quicker and more clearly arranged offline, for example, with MS Excel.
Data can be transferred from the store management feature to an offline document or from an offline document to the store management feature in Products -> Import and Export.
1. Export.To export data select the desired data and its display form from the drop-down menus.
Clicking on the ‘Export’ button generates a file which can be edited and saved locally on your hard drive.
Note: If you have enabled a download blocker for your browser, you will need to activate the download to save the file. Export files end in the extension *.csv. CSV stands for Comma Separated Value. This format is understood, for example, by MS Excel.
When it is launched Excel automatically sorts the values into columns. If this is not the case, change the separator from semicolon to comma. Data processing in Excel: Leave the information in the first row unchanged as far as possible and do not add any new columns. You can alter the cells and even add new cells in all of the other rows. Even the order of the columns can be changed. This provides all of the data in a clearly arranged format and it enables you now to implement percentage price increases, make changes to product designations and much more by making just a few entries.
Special features in Excel: Excel has some automatic features, which unfortunately cannot be turned off. If, for example, you have entered a value of "1.5" for a product attribute in the store and then view this in Excel, Excel automatically converts the entry to "01 May ". This can only be prevented by formatting the respective cell or the entire column as text. Note: Save the file again in Excel with the extension .csv (not .xls!).
2. Import. If you just want to launch the store and use the data import feature, first create a few products and categories in the store manager and then export these. Use the resulting CSV file as a template for future use. To import a file into the store manager simply upload it under Import and Export and then click on Import.