Data upload is a significant and at the same time risky operation, you should consider a couple of things before starting the import process:
|
In AbanteCart you can choose between native import format and free format.
This article describes import with the native AbanteCart format. If you are looking for a more simplified (but less controlled) way to import please try the easy-to-use import format with Import Wizard tool
pros control all values control all languages control all stores can import orders, customers cons linking between objects by IDs - for example, you need to import categories first then find categories IDs and only after import products with categories ID's. Same with brands, stores, etc a lot of columns to edit if one column name incorrect it will be ignored |
pros no IDs required - simply type names to add fewer columns to edit - you can set multiple categories or image URLs in one select columns meaning to be recognized as preview first row of the imported file you can import product almost from any data format cons import to only one language and store not everything can be added (for example you can not add tags) can not import orders, customers |
With native format 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 the CSV file, you need to add a new column action and add value insert for each table or a new column in the CSV file.
in the same way, you can bulk remove products with action delete |
When editing CSV files make sure your editor works correctly with data. For example, Microsoft Excel has known issues with cell data format (can change dates format to software internal, change price delimiters ... etc). Apple's Numbers software opens CSV correctly but by default you able to save it as CSV only with a comma delimiter (File → Export To → CSV). OpenOffice is a good tool but make sure you set only one delimiter when opening your CSV file (OpenOffice support combined delimiter, please never use this approach) |
In this example we will show how to easily update your existing products.
First export one or all products. Go to System → Data → Import/Export. In the Export Tab find Products, click to expand the table and select only product_descriptions table.
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 ids/values already existing in your data for this fields:
products.stock_status_id
products.manufacturer_id
products.shipping
products.tax_class_id
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.
Before inserting a lot of new products just create a sample product in Admin → Catalog → Products with all fields you need.
Then export to CSV file. Make sure to select required tables like:
product_descriptions
products_to_categories
products_to_stores
or any other tables which one contain needed data for a configured 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.
See CSV (TAB delimited) examples for insert :
Very minimum example
Very minimum CSV file with columns allowing you to insert product with basic settings like name, weight, price, description, blurb, category id to assign, store id, tax class, quantity etc
products minimum CSV TAB delimited example abantecart_import_minimum.csv
In this example you can see some very important columns like products_to_stores[0].store_id For most cases it is 0 (unless you have multiple stores). |
upload images by FTP to this path ../resources/image/somefolder/
permission for this folder to 777 (or 755)
change/add these columns in your CSV file
resource_map[0].resource_id = leave empty |
For AbanteCart 1.2.6 and higher! |
change/add this columns in your csv file
resource_map[0].type = image |
You can and more and more images for one product in a similar way
You can and more product rows
product-insert-quantityprice.csv
You can and more product rows. The attached example is TAB delimited CSV file update_product_with_images.csv
1. put your images to resources/image/folder_in_resource_directory
2. please use the attached TAB delimited CSV file as an example of how to update products (add resource image to products)
3. In the CSV file double-check you set a valid product id (first column) and the path to the image file (last column).
4. When import, make sure to select the correct delimiter!
Download New Products Example (insert)
Download Update Products Example (update)