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.
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
To import images you can also upload them to your server and in the images column set full server path to each image file
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
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.