Import

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?

Visible 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.


Import checkboxes

You will notice the following checkboxes which give you further control over the import process:


Import products as new ones

Visible for the following import types: Products

The XLSX Products sheet contains a column called Product ID. ExcelPort relies on the values of this column to find existing products in your store during the import.

Enabling the checkbox Import products as new ones will cause ExcelPort to stop regarding the value of the column Product ID. This means that your OpenCart store will not be checked for already existing products - all data in the imported file will be inserted with a new Product ID.

Importing without enabling the checkbox Import products as new ones will cause ExcelPort to regard the values of the column Product ID. In this case, if a Product ID match is found in your store, ExcelPort will update your existing product without creating a new entry.

Note Using this may lead to duplicate products. Remember to always do a backup of your database before importing.


Delete the entries before doing the import?

Visible 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.