Data can be imported to selected tables using the General Data Import feature. This is only for web site administrators. 
Step-by-step guide
- Login as an Administrator.
- Navigate to "Content" and then "Import Data"
- To create a New Import Profile, select "New Import Profile"
- Select the table to be imported.
Note that Commerce Vision can enable the tables that are allowed to be imported to. Please request table access from Commerce Vision to ensure data integrity between ERP and web is maintained.
- Select the fields to be imported. Note that the key to the table will automatically be selected.
- Select "Save" to save or "Run" to run without saving.
- If "Save" was selected, enter the profile name to save as.
- Select "Save" to save or "Save and Run" to save and run now.
- To run an existing import profile
- Find the profile you wish to run (search is provided)
- Select "Run"
- The required fields are listed at the top of the page. The CSV file needs to be in this format.
- Select optional functions:
- Replace Table - this will delete ALL records in the table and then replace the data in the CSV file to the table
- Ignore headings on first line - this will skip the first line in the file.
- Either use the "Select" option to browse for the file to import or drag and drop into the drop zone.
- Click on "Import Now" - the file will be imported and any errors will be displayed.
When exporting, there is a handy function to allow the download of a blank CSV file that will put the headings in the first row. This is useful to get the file format correct.
Related articles
