Data Import

System > Data > Import

Example 1: Update products
Example 2: Insert Products
Example 3: Insert Products with Images
Example 4: Import Product Media by URLs

You able to import data into your AbanteCart store using '.xml' or '.csv' files. Some of fields are required for a successful import, yet nearly almost all fields are supported, allowing you to determine the level of detail you wish to import.
This is particularly useful when migrating and importing from a different eCommerce platform.

Note

  • Please select correct CSV delimiter.
  • You can run import in Test Mode to prevent any unexpected results.
  • If you import data with table auto-increment index columns provided (example: product_id), default auto action will be update. In case, new inserts required with auto-increment columns values, action insert needs to be specified manually. For example in XML file, you need to add <action>insert</action> for each table or new column in CSV file.

Example 1: Update products

In this example we will show how to easily update your exiting products.

First export it. Go to System->Data->Import/Export. In the Export Tab find Products, click to expand table and select only product_descriptions table.


In the bottom of the page select this export options:

File Format: CSV

CSV/TXT delimiter: TAB

Click Export button.


Then open exported CSV file in CSV editor like OpenOffice Calc, Microsoft Excel etc. Be sure to open file with correct CSV delimiter.


In the opened CSV file easy to update/edit this products fields:

products.model

products.quantity

products.price

products.weight

products.length

products.width

products.height

products.sort_order

product_descriptions[0].name

product_descriptions[0].description

 

Also You can edit other fields. But You need to know your correct exiting in your data ids/values for this fields:

products.stock_status_id

products.manufacturer_id

products.shipping

products.tax_class_id

and others

Then Import file. Go to System->Data->Import/Export. In the Import Tab select correct File to import and correct CSV/TXT delimiter. Click Import button.


After processing the message will be shown. Normally 0 errors should be displayed.

Update complete.

Example 2: Insert products

Before insert a lot of new products just create sample product in Admin > Catalog > Products and configure it.

Then export to CSV file. Make sure to select required tables like:

product_descriptions

products_to_categories

products_to_stores

or any others tables which one contain needed data for configured sample product.

Then open exported CSV file in CSV editor like OpenOffice Calc, Microsoft Excel etc. Be sure to open file with correct CSV delimiter.

Copy row with sample product to make sure new product will be configured in the same way.

To insert new products using import tool you need to add new column named action in the exported file. See example for CSV file.


Make sure to:

leave empty products.product_id

type insert in the action column

and fill others columns like in exiting sample product.

Then Import file. Go to System->Data->Import/Export. In the Import Tab select correct File to import and correct CSV/TXT delimiter. Click Import button.

After processing the message will be shown. Normally 0 errors should be displayed.

Insert complete. See CSV (TAB delimeted) examples for insert :

Categories

Download

Manufacturers

Download

Products

Download

Example 3: Insert products with Images

  • 1

    upload images by ftp to this path ../resources/image/somefolder/

  • 2

    update permission for this folder to 777 (or 755)

  • 3

    change/add this columns in your csv file

    resource_map[0].resource_id              = leave empty
    resource_map[0].object_name            = products
    resource_library[0][0].type_id            = 1
    resource_descriptions[0][0][0].language_id      = 1  (the id of installed language)
    resource_descriptions[0][0][0].name             =    anyname (usually imagefile name)
    resource_descriptions[0][0][0].title            =    leave empty or fill if you need title
    resource_descriptions[0][0][0].description      =    leave empty or fill if you need description for the resource
    resource_descriptions[0][0][0].resource_path    =    somefolder/product_image_1.jpg

    in case You have 2 languages installed in your cart add next columns
    resource_descriptions[0][0][1].language_id      = 9  (the correct id of second installed language)
    resource_descriptions[0][0][1].name             =    anyname (usually imagefile name)
    resource_descriptions[0][0][1].title            =    leave empty or fill if you need it
    resource_descriptions[0][0][1].description      =    leave empty or fill if you need it
    resource_descriptions[0][0][1].resource_path    =    somefolder/product_image_1.jpg

    ------------------------------------------------------------------------------------
    in case If you need to add multiply images to one product please add more columns

    resource_map[1].resource_id              = leave empty
    resource_map[1].object_name           = products
    resource_library[1][0].type_id            = 1
    resource_descriptions[1][0][0].language_id   = 1 (the id of installed language)
    resource_descriptions[1][0][0].name          = sometext (any resource name to second image)
    resource_descriptions[1][0][0].title            =    leave empty or fill if you need it
    resource_descriptions[1][0][0].description      =    leave empty or fill if you need it
    resource_descriptions[1][0][0].resource_path = somefolder/product_image_2.jpg   (path to second image)

    same for second language if you have it installed
    resource_descriptions[1][0][1].language_id   = 9 (the correct id of second installed language)
    resource_descriptions[1][0][1].name          = sometext (any resource name to second image)
    resource_descriptions[1][0][1].title            =    leave empty or fill if you need it
    resource_descriptions[1][0][1].description      =    leave empty or fill if you need it
    resource_descriptions[1][0][1].resource_path = somefolder/product_image_2.jpg   (path to second image)


    ---------------------------------------------------------------------------------------
    and to add one more image
    resource_map[2].resource_id                     = leave empty
    resource_map[2].object_name            = products
    resource_library[2][0].type_id            = 1
    resource_descriptions[2][0][0].language_id   = 1 (the id of installed language)
    resource_descriptions[2][0][0].name          = sometext (any resource name to 3rd image)
    resource_descriptions[2][0][0].title            =    leave empty or fill if you need it
    resource_descriptions[2][0][0].description      =    leave empty or fill if you need it
    resource_descriptions[2][0][0].resource_path = somefolder/product_image_3.jpg   (path to second image)

    resource_descriptions[2][0][1].language_id   = 9 (the id of second installed language)
    resource_descriptions[2][0][1].name          = sometext (any resource name to 3rd image)
    resource_descriptions[2][0][1].title            =    leave empty or fill if you need it
    resource_descriptions[2][0][1].description      =    leave empty or fill if you need it
    resource_descriptions[2][0][1].resource_path = somefolder/product_image_3.jpg   (path to second image)

    You can and more and more images for one product with similar way

products with images CSV Tab delimited example Download

Example 4: Import Resources by URL

For AbanteCart 1.2.6 and higher!

  • 1

    change/add this columns in your csv file

    resource_map[0].type           = image
    resource_map[0].source_url     = http://www.abantecart.com/images/devices.png
    resource_map[0].source_path    = leave empty
    resource_map[0].html_code      = <i class="fa fa-optin-monster">  (if you want to add html resource or leave empty)

    ------------------------------------------------------------------------------------
    in case If you need to add multiply images to one product please add more columns

    resource_map[1].type          = image
    resource_map[1].source_url    = http://www.abantecart.com/images/banners/admin_iphone.jpg
    resource_map[2].type          = pdf
    resource_map[2].source_url   = http://www.pdf995.com/samples/pdf.pdf

    You can and more and more images for one product with similar way

products with images CSV COMMA delimited examples Download New Product Example Download Update Product Example

CSV file format

  • The first row must include column headers and the column headers must match those given in the documentation.
  • Values must be separated by a delimiter, which is expected to be a tab, comma “,” by default, though this can be set during the import process to any other character, so long as you are consistent within your file.
  • Each imported item (Products, Category) belongs on its own row
  • Some CSV file editor like MS Excel may automaticly change price or date fields format and broke your file.

Troubleshooting

  • 1

    Allowed memory size of xxx bytes exhausted

    Your server may not have enough memory to perform the import.
  • 2

    Import is timing out

    Increase the max_execution_time. If its not possible for you to increase the max_execution_time you can either break your CSVs into multiple parts and import each separately
  • 3

    Special / foreign characters imported not properly

    The file you are importing must be properly encoded as UTF-8.