This section explains the user interface of the Import tab in ExcelPort:
Extensions > Modules > ExcelPort, tab Import
What kind of data do you wish to import?
|Import type||Corresponds to|
|Products||Admin > Catalog > Products|
|Categories||Admin > Catalog > Categories|
|Options||Admin > Catalog > Options|
|Attributes and Attribute Groups||Admin > Catalog > Attributes|
|Manufacturers||Admin > Catalog > Manufacturers|
|Customers||Admin > Sales > Customers > Customers|
|Customer Groups||Admin > Sales > Customers > Cusomer Groups|
|Orders||Admin > Sales > Orders|
|Coupons||Admin > Sales > Coupons|
|Gift Vouchers||Admin > Sales > Gift Vouchers|
Which language do you wish to import?
Available for the following import types: Products, Categories, Options, Attributes and Attribute Groups, Customers, Customer Groups, Manufacturers (only in OpenCart 3.x)
This option specifies the language in which you are going to import.
Important ExcelPort is designed to export/import only a single language. You cannot do an import for many langauges in a single go.
You will notice the following checkboxes which give you further control over the import process:
Import entries as new ones
Available for the following import types: Products, Categories, Attributes and Attribute Groups, Customers, Customer Groups, Manufacturers, Coupons, Gift Vouchers
The first column in every spreadsheet holds the entity ID. ExcelPort relies on the values of this column to find existing entities in your store during the import.
Enabling the checkbox Import entries as new ones will cause ExcelPort to stop regarding the value of the ID. This means that your OpenCart store will not be checked for already existing entities - all data in the imported file will be inserted with a newly assigned ID.
Importing without enabling the checkbox Import entries as new ones will cause ExcelPort to regard the values of the ID column. In this case, if an ID match is found in your store, ExcelPort will update your existing entity without creating a new one.
Note Using this may lead to duplicates. Remember to always do a backup of your database before importing.
Delete the entries before doing the import?
Available for all possible import types.
Enabling this checkbox before starting the import will cause ExcelPort to first delete all corresponding entries in your store, after which the import will begin. For example, if you are importing Options and if you have enabled Delete the entries before doing the import?, all Options will be deleted from your store, and then the import will begin.
Note If used incorrectly, this may lead to loss of store data. Remember to always do a backup of your database before importing.