Import Wizard

Go to the System → Data → Import

If AbanteCart fails to detect format the Import Wizard will start and ask you to select every column name and meaning you want to assign to column values.

Import wizard

Browse .csv file on your pc and select correct CSV delimiter.

Make sure correct file separator is designated since improperly set delimiter will negatively influence import results

After file upload, select a destination. Information you are going to upload to the database will be represented in this step. In order for product details to be placed to correct database fields, you should set associations between file columns and corresponding fields.

AbanteCart will try to set columns name's meaning on the fly but you can change columns meaning with select

Do not forget to opt for an identifier by which AbanteCart products will be recognized. To update products please set on what column wizard should look to update existing products.

New Product IDs are incremented by the AbanteCart system itself, wizard does not allow to force ID during import in order to ensure data integrity.

If your data contain multiple values for categories or images in one column you need to select a correct delimiter. The delimiter is a symbol that will be used to detach categories in the category tree, images in media resources. For example, your product has multiple images so in one column you can set multiple images URLs - url1,url2,url3

Or set full category tree you want to create and assign to the product - parent category name, child category name, child category name

Multiply categories trails

To assign the product to multiply categories trails (paths) please add more columns for example 

category 1 column with Makeup, face

category 2 column with Makeup, Skincare

images path

To import images you can also upload them to your server and in the images column set full server path to each image file

Map export

To avoid spending time on columns meaning selection you can export the mapping of columns|meanings to apply next time you upload a similar file

Copy the mapping code somewhere and apply it next time. All columns|meanings selected will be mapped to your file again

Map change

Take a note: if you remove or add some column to your file please create a new map. The old map key will ignore your new columns!

Products import example

follow this example to create products with categories and brands on the fly. You don't need to type categories or brand ids.

comma delimiter

example with images loaded to options values (comma delimiter)

in this example options values images separated by a comma

Categories import example

comma delimiter categories.csv

Brand import example

comma delimiter manufacturers.csv