|
How to export/import a BULK amount of products from CSV (Excel file)?
|
|
|
The import/export interface allows you import/export product data as well as store settings such as users, taxes, orders and shipping rates.
To start the import/export process go to the import/export page by selecting the Import/export option from the "OTHER SETTINGS
" menu section :
The default page displayed is the import interface.
|
|
|
|
Exporting data
|
To start the export process, click on the top link "Export data" located on the top "In this section" dialog box.
The exporting data interface is divided in 2 section: the setting and the specification of which data type to export.
|
|
|
|
|
|
Providing the export settings:
CSV Delimiter:
All data is exported to a CSV file. This field let you choose the CSV delimiter that you prefer.
Data rows per file:
This field let you specify a max number of rows per CSV file. If the number of records exported is greater than this number then another CSV file will be created for the remaining rows. If you leave than field blank or just input the value 0 then no split will be done on the exported data.
Export images?:
When exporting data about products you can specify whether or not you want to also export images. If you say yes, then an additional column will be inserted in the exported CSV file and the product images will be exported to your host server <site root dir>/images folder.
Category path separator:
Provide here the character(s) that you want to use as a separator for category naming. You could really use any character that does not appear in category names, however we recommend you to leave the default "/" symbol.
Select the data that you want to export.
Select the checkboxes of all the data to be
included in the exported CSV file. If you intend to export Users, Orders or Products you can also choose the range or leave the default (ALL).
Once that selection
is done click on the [export] button, the export will be done and a link to the exported data CSV file will be displayed at the bottom of the export data page.
|
|
|
|
|
Importing data
|
The import function of your store is here to help to do a bulk import of different kind of data type into your store. This import function is provided to help you save time
and can be used to either create or update existing store data. The imported data has to be in a CSV file and requires a very specific format for your store to accept it.
If you are not sure about the exact format then we recommend you to first do an export of the data that you intend to import and use the exported format to build your CSV
import file.
The import data process is done in 3 steps. The first one is to prepare the CSV file to be imported. The second and third consists in filling out the
import data form basic and optionally advanced section.
Once you have the CSV file ready to be imported you can go to configure the import settings.
Providing the basic import settings:
The import data form is located on the default page you would get when selecting the import/export data option from the "OTHER SETTINGS" menu section.
|
|
|
|
|
|
Basic import settings are simple and easy to configure:
CSV delimiter:
that is the delimiter used in the imported CSV file
The source of import file:
Origin of the file. Specify here where is your CSV file located, is it on your computer, server or on a web site.
Once the CSV file location provided and selected you are ready to click the [import] button unless you need to configure advanced settings.
|
|
|
|
|
Advanced settings
|
|
These are additional import options that you can configure.
|
|
|
|
|
|
Default category: This is the category that would be used if the main category is not specified in the CSV file
Category path separator:
Provide here the character(s) that you want to use as a separator for category naming. You could really use any character that does not appear in category names, however we recommend you to leave the default "/" symbol.
Directory where images are located:
This is the server root-directory for the images that you want to import. This field is only used when importing products.
Encrypted?:
if you import customers or order data, you need to specify here if the customers password or orders are encrypted.
DROP section:
In this section you can select a data type to delete before the import operation starts. You would typically want to do
this if you are rebuilding an entire data type.
NOTE:
When importing product or other data type that includes an ID column such as the productID you need to be careful to:
- leave it in place if you want the import process to update existing records.
- provide an empty value if you want the import process to create new records.
|
|
