Use the Data Import Wizard to import CSV files (spreadsheets) into your website. You can import the following:
The only field required when importing products into the system is the item’s SKU (its unique identifier, also known as Item Code), all other inventory fields are optional.
Go to Setup & tools > Import Data then click Perform complex import and select Start Data Import Wizard.
If you want to import data from other file types (xml, txt etc) or an external location such as an FTP location or web address you must do so using a data import template. These import templates have advanced features such as feed scheduling, find and replace functionality, update control and more.
Click on Continue to Next Step. The .CSV file will be uploaded and the wizard will try to match the column names in the import file with fields in the database.
This page is where you map the column names from your import file with the database fields on your web store. If you are using one of our sample templates then the fields should be mapped correctly. Have a look in the first column. If you see any fields marked – ignore column –, this means it could not match the column with a field in the database. You can click on the drop down menu and select the correct field from the list.
If the is a column you don’t want to import, you can select – ignore column – on that row to prevent it from being imported. You can also click on the red cross on the right to remove that column from being imported.
If you have removed a column by mistake, click on the Add Extra Field button and select the name of the column from your file under Column Name. Then select the database field you want to map it to in the Database Field Name column.
Click on the Continue to Next Step button.
Here, you can select how your imported data will integrate with existing products on your site.
In most cases, you would select Add New / Update Existing Products.
Click on the Continue to Next Step button.
If you want to save this import as a template that you can use again, check Do you wish to save this import session as an import template to import with in the future? and select a template name when prompted.
Click on Process File Now to queue the import process. Depending on the size of the import file, it can take up to 15 minutes to complete.
Does my import file need to have columns named exactly the same as my website database?
No, you can map columns during the import process. This negates the need to name columns in any specific way.
Can I upload HTML into an items description field?
Yes, if a field accepts HTML through your control panel, you can import HTML into that field using the import wizard.
What is the unique identifier for an item when importing a file to update inventory?
What is the unique identifier for a customer?
What is the unique identifier for an order?
Is there a list of inventory import fields?
For more information on inventory import fields, types and restrictions, see the support article What product / inventory import fields are available?
How many records can I upload at once?
As many as you like, your only limitation is the browser time out. If the import file is too large, the browser will time out during an upload. In these cases you can split your files up into smaller sizes.
If I leave a field blank in a file that I upload, will that field be ignored or replaced with blank data?
It will be replaced with blank data. Therefore, if you do not want to update a field through a file upload, do not include that field in your import file.
Can I upload a blank file with just headers?
Yes, you can do this to create an import template. Note: If you choose the update option “replace all” and you upload a blank file, all records will be purged or replaced.
Will any products I upload automatically be visible on the website?
No, products will need to be “active” and “approved” in order to be visible on the website after upload. You can mark items as active and approved using the column headers “active” and “approved” and the static values “y” or “n” (yes or no).
What if I have two columns mapped to the same header/ identifier in Neto?
This will cause an error. Please only map one column to a header at a time.
Can I make changes to the data feed template that change the import/ export data?
Changes can be made to the data using the bulk find and replace feature within the import template. View more information here.