Import Wizard

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

CSV editor tips

When working with CSV files for importing data into AbanteCart, it’s essential to use an editor that preserves data accuracy. Be aware that some editors, such as Microsoft Excel, may modify cell formats, for example, converting dates to its internal format or altering numeric delimiters (e.g., switching a period . to a comma , in prices) based on the system’s locale settings. This can lead to unintended errors, such as prices being imported incorrectly. For this reason, it’s recommended to use the price format 19.99 to avoid accidental editor conversion to formats like 19,99

Apple’s Numbers software mostly correctly opens CSV files but only allows saving them with a comma delimiter by default. You can use File → Export To → CSV to save your work in the required format.

OpenOffice is another reliable tool with useful features for CSV editing. It allows you to set specific columns as text, preventing issues like leading zeros being removed (e.g., 00134 becoming 134). However, when opening your CSV file in OpenOffice, ensure to select only one delimiter (e.g., a comma) and avoid using combined delimiters, as this can cause compatibility problems.

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 products-with-options-comma.csv.zip

example with images loaded to options values products-with-options-comma-optimages-2.csv.zip (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