You can import and export certain essential data sets (including order, product and customer data) using the Export and Import programs accessible in Admin.
|Important: All data needs to be in UTF-8 format. |
On some versions of Excel spreadsheets you may need to open a new sheet then import the data to select UTF-8
NB Take care when modifying your data and re-importing it. Always try a single line of data first and check it is ok before re-importing the whole dataset.
The encoding will normally automatically populate as shown below:
It will then open in columns and you can make your changes.
Note: Unless instructed in the particular import/export program, don't remove any columns or the import will either fail or not populate all the data correctly.
After making your changes, save the file as a Text CSV file that ends .txt in the Save As field but with the Automatic file name extension field unticked.
If you see the message below select Use Text CSV Format.
You will now have a Text CSV file ending .txt in UTF-8 format ready to import into the system.
As stated previously, if you are new to imports/exports we recommend doing a test run with a single row of data and checking it has imported as expected and all the data looks fine in the relevant program (e.g. Product Manager for Products, User Manager for Users etc). Once you're happy then you can import in bulk.