Office Hours
Day Hours (GMT)
Bank Holidays Closed
Monday 9:00 - 17:30
Tuesday 9:00 - 17:30
Wednesday 9:00 - 17:30
Thursday 9:00 - 17:30
Friday 9:00 - 17:30
Saturday Closed
Sunday Closed
Knowledgebase: Installation Help
How do I use the bulk product import tool?
Posted by Al Brookbanks on 24 September 2007 10:43 AM

From the "Inventory" >> "Import Cataglog" section of the administration control panel of your store it is possible to import your product catalog from a CSV file of any format. CubeCart will provide a prompt for you to select a CSV file from your local computer. After upload you can choose with a dropdown menu to select which field you want to import it against.

Below is a table of the possible fields identifiers with notes and example data. If your CSV has matching column headers to those in the table below CubeCart will automatically match up the columns to the fields. If these are not found you can manually match them up. 

Column HeadersDescriptionAccepted ValueNotesExampleGenerated Automatically if empty
status Status Number 1 or 0 1  
name Product Name Text   X4 Quadcopter  
image Main Image Text Document root relative path from the images/source folder. Before CSV import all images much have been uploaded to this folder and the image database updated using the "Update File List" button in the images filemanager section of your admin control panel. It is possible to comma seperate multiple images. 

hus_x4quad.jpg 

or

hus_x4quad.jpg,hus_x4quad2.jpg

 
product_code Product Code Text   H107C Yes
cat_id Master Category ID Number/Text Category id of an existing category. From 5.2.14 this can be comma seperated for multiple categories. This can also be a text value. If the category name is not found it will be created. 

23

or

Drones

 
description Description Text   The new Hubsan X4 LED edition features a whole host of new...  
manufacturer Manufacturer Text   Hubsan  
price Price Decimal   59.99  
sale_price Sale Price Decimal   33.29  
cost_price Cost Price Decimal   23.55  
product_weight Weight Decimal   0.454  
use_stock_level Use Stock Level Number 1 or 0 1  
stock_level Stock Level Number   75  
stock_warning Stock Level Warning Number Threshold you want stock warnings to show. 5  
digital Is Digital Download Number 1 or 0 0  
digital_path File path/name.ext Text Absolute server path to download file /var/www/downloads/file.zip  
tax_type Tax Class Number Tax Class ID 2  
tax_inclusive Tax Inclusive Number 1 if the price above includes tax, 0 if not 0  
featured Include in latest products Number 1 or 0 1  
seo_path Custom SEO URL Path Text Custom URL address hubsan-x4 Yes
seo_meta_title Meta Title Text Meta title on product detail page X4 Quadcopter  
seo_meta_keywords Meta Keywords Text Meta keywords on product detail page X4 Quadcopter with Camera,Hubsan,H107C  
seo_meta_description Meta Description Text Meta description on product detail page X4 Quadcopter with Camera: Toys & Games  
condition Condition Text   New  
upc UPC Code Text      
ean EAN Code Text      
jan JAN Code Text      
isbn ISBN Code Text      
brand Brand Text      
gtin GTIN Code Text      
man MPN Code Text      

©2017 CubeCart Limited. All rights reserved. CubeCart Limited is a company registered in England & Wales under number 5323904. VAT Registration Number GB886451190.