Importing Products From CSV

Our platform will make it easy to import most common CSV formats of product information.

Our platform will attempt to auto match your column names to our column names. 

Minimum Import Requirements

Every product needs to provide at least 2 columns. A new product needs to have a product title (p_title).

However, it is best if your products have a unique product code, and price as well, eg (p_code,p_title,p_price)

Price/Quantity Updating via CSV 

You can do product updates, with just product code and one other field, ( eg p_code,p_qtyinstock,p_price)

Category Linking

You can simply provide a category name column in your CSV file, and our system will automatically create any missing categories, and otherwise link your products to that correct category. You can later on reorganise your categories, and the products will remain linked to the new category locations. 

Alternatively, you can provide category ID's. If you do not know your category ID's, you will need to first export your category data as a CSV file. This will give you the ID's you need. You can then assign each product to up to 8 different product groups aka p_groupid, p_groupid2, etc

You may want to import you categories in advance, and you can easily do that also in CSV format.

There is a custom option that allows you to import a single column containing multiple categories, that can be auto expanded into mutliple category relationships. Multiple categories should be separated by | 

Pricing

All pricing during CSV imports are excluding GST. There are many different pricing columns, with the main checkout pricing being p_price.

Member price groups will have A-H on the end, eg p_priceA

Images

You can either provide the image reference to the file location within your website, eg /images/myfolder/myimage.jpg, or you can provide a URL to an image hosted elsewhere. If you provide a URL, our system will copy/import those images into our local filesystem within 24 hours. If you do not want the images imported, you will need to notify our support team. Typically, it's safer/faster to have images hosted locally.

You can include multiple image URLs separated with a comma, within the single image column. These will be expanded into multiple/alternative image views of the product, with the first image being the primary image. 

Product Variants

You can import product variants via CSV... Ideally, you should ensure the parent products already exist. However, if your CSV file is in the right order, then the parent products should be created before any variants. 

To relate a variant product to a parent product, you simply need to provide a Parent PID/Code. (eg p_parentpid). This can either be the exact integer PID of the parent product or it can be a product code. Please note the importance of using unique product codes for both parent products, and for each variant. 

Options, Colours, Sizes, Styles

Multiple product colours,sizes and styles can be imported/expanded via a single column for each type of option. The options can be separated by | or comma , within the single column eg p_colour = "red,green,blue"

Pagination / Errors

If your import file is too long, like more than 1000 lines, then it may be paginated by our import system. Please allow the system time to have a breather, as it automatically imports 1000 rows at a time, then waits a few seconds in between. 

If your import has too many errors, it will fail totally, however, if may still import some data... Take care.. 

Fixing pricing errors

In the bulk pricing update area, you can revert all products back to this mornings prices.  If you really stuff it up, please contact support for a custom restoration of your data... We need not replace all data, we can be strategic if we know exactly what mistakes you made. Fees apply for help with restoration of data. 

Auto Matched Columns. 

The following column matching code may help you understand the relationships between commonly named data columns, and our columns. 

possibleColumns[possibleColumns.length] = ['pid','cmsProductID',['pid']];
possibleColumns[possibleColumns.length] = ['p_code','SKU/Code',['sku','code','product_code','product_id','productcode','productid','Item Number','ID']];
possibleColumns[possibleColumns.length] = ['p_title','Title',['p_title','title','productname','product_name','name','producttitle','Item Name','Product Name']];
possibleColumns[possibleColumns.length] = ['p_details','Description',['details','description','Description','Summary','product_description']];
possibleColumns[possibleColumns.length] = ['p_img','Image SRC',['image','src','Image URL','Images']];
possibleColumns[possibleColumns.length] = ['p_extra1','Custom Field 1',['customA','custom','Make']];
possibleColumns[possibleColumns.length] = ['p_extra2','Custom Field 2',['customB','Model']];
possibleColumns[possibleColumns.length] = ['p_extra3','Custom Field 3',['customC','Year','tag','Kind']];
possibleColumns[possibleColumns.length] = ['p_uom','UOM',['uom','UnitOfMeasure','Unit Of Measure','unit','Sell Unit Measure']];
possibleColumns[possibleColumns.length] = ['p_parentpid','Parent PID/Code',['Parent','Parent ID','Parent Code','Parent Product Code','Primary Product Code']];

possibleColumns[possibleColumns.length] = ['p_group','Category Name',['category','group','Custom List 1','Categories']];

possibleColumns[possibleColumns.length] = ['p_price','Checkout Price',['price','cost','Price Level A, Qty Break 1','Regular Price','price_1']];

possibleColumns[possibleColumns.length] = ['p_priceprediscount','RRP Price',['rrp','prediscount','Suggested Price']];
possibleColumns[possibleColumns.length] = ['p_pricea','Member Price A',['priceA']];
possibleColumns[possibleColumns.length] = ['p_priceb','Member Price B',['priceB']];
possibleColumns[possibleColumns.length] = ['p_pricec','Member Price C',['priceC']];
possibleColumns[possibleColumns.length] = ['p_priced','Member Price D',['priceD']];
possibleColumns[possibleColumns.length] = ['p_pricee','Member Price E',['priceE']];
possibleColumns[possibleColumns.length] = ['p_pricef','Member Price F',['priceF']];
possibleColumns[possibleColumns.length] = ['p_priceg','Member Price G',['priceG']];
possibleColumns[possibleColumns.length] = ['p_priceh','Member Price H',['priceH']];

possibleColumns[possibleColumns.length] = ['p_shipping','Shipping Fee Domestic',['shipping','domestic']];
possibleColumns[possibleColumns.length] = ['p_shipping_int','Shipping Fee international',['international']];

possibleColumns[possibleColumns.length] = ['p_deposit_pc','Deposit PC',[]];

possibleColumns[possibleColumns.length] = ['p_groupid','Category ID',[]];
possibleColumns[possibleColumns.length] = ['p_groupid2','Category ID 2',[]];
possibleColumns[possibleColumns.length] = ['p_groupid3','Category ID 3',[]];
possibleColumns[possibleColumns.length] = ['p_groupid4','Category ID 4',[]];
possibleColumns[possibleColumns.length] = ['p_groupid5','Category ID 5',[]];
possibleColumns[possibleColumns.length] = ['p_groupid6','Category ID 6',[]];
possibleColumns[possibleColumns.length] = ['p_groupid7','Category ID 7',[]];
possibleColumns[possibleColumns.length] = ['p_groupid8','Category ID 8',[]];
possibleColumns[possibleColumns.length] = ['p_promote','Promotion',['promote']];


possibleColumns[possibleColumns.length] = ['p_weight','Weight',['Weight','kgs','grams']];
possibleColumns[possibleColumns.length] = ['p_height','Height',['Height','x']];
possibleColumns[possibleColumns.length] = ['p_width','Width',['Width','y']];
possibleColumns[possibleColumns.length] = ['p_depth','Depth',['Depth','Length','z']];

possibleColumns[possibleColumns.length] = ['p_qtyinstock','Qty In Stock',['qty','stocklevel','quantity']];
possibleColumns[possibleColumns.length] = ['p_outofstockmessage','Public Stock Message',['availability','outofstock','outOfStockMsg']];
possibleColumns[possibleColumns.length] = ['p_minqty','Min Buy Qty',['minqty','MOQ','minimum_order_quantity']];
possibleColumns[possibleColumns.length] = ['p_maxqty','Max Buy Qty',['maxqty']];
possibleColumns[possibleColumns.length] = ['p_qtyinc','Quantity Increment',[]];
possibleColumns[possibleColumns.length] = ['p_backorder_maxqty','Back Order Qty',[]];
possibleColumns[possibleColumns.length] = ['p_qtylowstock','Low Stock Level',['reorder_point','lowstock']];
possibleColumns[possibleColumns.length] = ['p_target_quantity','ReStock Level',['restock_level']];

possibleColumns[possibleColumns.length] = ['p_supplier_puq','Supplier PU Qty',['puq','PurchaseUnitQuantity']];

possibleColumns[possibleColumns.length] = ['p_private_stock_notes','Private Stock Notes',['private_notes']];

possibleColumns[possibleColumns.length] = ['p_manufacturer','Manufacturer',['manufacturer','brand_name','Brand']];
possibleColumns[possibleColumns.length] = ['p_manufact_sku','Manufacturer Code',['manufacture_code','manufacture_id']];
possibleColumns[possibleColumns.length] = ['p_supplierName','Supplier',['supplier','supplier_name','Company Name']];
possibleColumns[possibleColumns.length] = ['p_supplierCode','Supplier Code',['supplier_code']];
possibleColumns[possibleColumns.length] = ['p_supplierPrice','Supplier Price',['supplier_price','supply_price','Cost']];

possibleColumns[possibleColumns.length] = ['p_code_gl_sales','GL Sales Code',['gl_code','glcode']];

possibleColumns[possibleColumns.length] = ['p_colour','Colour',['Colour','colours','colours_available_appa','Attribute 1 value(s)']];
possibleColumns[possibleColumns.length] = ['p_size','Size',['Size','Attribute 2 value(s)']];
possibleColumns[possibleColumns.length] = ['p_style','Style/Options',['Style','Options','decoration_areas','Option','Attribute 3 value(s)']];
possibleColumns[possibleColumns.length] = ['p_prompt4text','Prompt',['prompt']];
possibleColumns[possibleColumns.length] = ['p_emailfile','EmailFile',['secdoc']];

possibleColumns[possibleColumns.length] = ['p_filename','SEO Filename',['uri','filename','seo']];
possibleColumns[possibleColumns.length] = ['p_metatitle','SEO Meta Title',['metatitle','meta_title','Meta Title']];
possibleColumns[possibleColumns.length] = ['p_metadesc','SEO Meta Desc',['meta_description','meta description']];
possibleColumns[possibleColumns.length] = ['p_metakeywords','SEO Meta Keywords',['meta_keyword','Keywords']];

possibleColumns[possibleColumns.length] = ['p_location','Stock Location',['location','shelf']];
possibleColumns[possibleColumns.length] = ['p_buy_points','Bonus Points',['bonus points']];

possibleColumns[possibleColumns.length] = ['p_showbuybutton','Show Buy Button',['showbuybutton']];

possibleColumns[possibleColumns.length] = ['p_sale_ends','Sale Ends Date',[]];

possibleColumns[possibleColumns.length] = ['p_order','Order/Hidden',['order']];
possibleColumns[possibleColumns.length] = ['p_minlevelforsee','Privacy Level',['privacy']];

possibleColumns[possibleColumns.length] = ['p_qty_label','Show Buy Button',['quantitylabel']];

possibleColumns[possibleColumns.length] = ['p_additionaltext','Additional Text (HTML)',['additionaltext']];
possibleColumns[possibleColumns.length] = ['p_tab_moreinformation','More Info (HTML)',['moreinfo']];
possibleColumns[possibleColumns.length] = ['p_tab_features','Features (HTML)',['features','<?CID REWORD>$p_tab_features</?CID>']];
possibleColumns[possibleColumns.length] = ['p_tab_specifications','Specifications (HTML)',['Specifications','<?CID REWORD>$p_tab_specifications</?CID>']];
possibleColumns[possibleColumns.length] = ['p_tab_contents','Contents (HTML)',['Contents','<?CID REWORD>$p_tab_contents</?CID>']];
possibleColumns[possibleColumns.length] = ['p_tab_links','Links (HTML)',['Links','<?CID REWORD>$p_tab_links</?CID>']];
possibleColumns[possibleColumns.length] = ['p_tab_video','Video Widget (HTML)',['Video','<?CID REWORD>$p_tab_video</?CID>']];
possibleColumns[possibleColumns.length] = ['p_tab_reviews','Reviews (HTML)',['Reviews','<?CID REWORD>$p_tab_features</?CID>']];
possibleColumns[possibleColumns.length] = ['p_tab_termsconditions','Terms Conditions (HTML)',['Terms']];

possibleColumns[possibleColumns.length] = ['p_address_search','Address Search Postcodes',[]];

possibleColumns[possibleColumns.length] = ['p_checkout_questions','Checkout Fields (HTML)',['CheckoutFields']];


possibleColumns[possibleColumns.length] = ['p_freight_exclude','Exclude from freight rules',[]];

possibleColumns[possibleColumns.length] = ['p_gst_rule','Add GST',[]];
 
possibleColumns[possibleColumns.length] = ['p_bookingtype','Booking Type',[]];
possibleColumns[possibleColumns.length] = ['p_booking_price_unit','Booking Interval Per Price Unit',[]];
possibleColumns[possibleColumns.length] = ['p_bookingcalendartags','Filter Calendar Tags',[]];
possibleColumns[possibleColumns.length] = ['p_bookingsequence','Booking Sequence Number',[]];

possibleColumns[possibleColumns.length] = ['p_options_import','Booking Sequence Number',[]];
 

 

Index Previous