How to import products from a CSV file spreadsheet into your Shopping Cart

Products EDI - import from excel spreadsheet in csv format. 

This advanced feature enables you to import product lists from 3rd parties or from your accounting system.

This feature is an advanced feature, intended for very technical users and is not provided with any warranty nor free support. We suggest you only attempt use on a new or trial site, and do not use without training on a site with an existing product inventory. If you have problems with your update, you can email technical support with your CSV file for feedback on how you could improve your file. If your data is not compatible, you will be given a quote for either fixing your data for you, or programatical changes to ensure your data can be more easily uploaded in future.

Column Layout is especially important. CSV files come in many different layouts. You need to open your file with some spreadsheet software, and shuffle your columns around so that they match the order and type of the columns in the second question below.

You can export your data in spreadsheet CSV format, then modify with a spreadsheet program, then import your data back in here. Note, not all fields may have been included in the export, but using the update by code option you can update the most important fields in this way. Take special note of the following warnings, and consider using a much reduced column format for you update so you only update the data you need to. Especially relevant to not breaking formated description text.

Very important warnings

  • Numeric columns must contain values, eg 0
  • Date columns must contain value, eg 1900-01-01 (Warning some spreadsheets rewrite this format)
  • Description column (and others) do not support multiline/formated text, and is suitable for text without newline characters only.
  • Product code must be unique if using any UPDATE method, otherwise use the INSERT ALL RECORDS option to ignore product codes..
  • The groupid acn be used to define which group a product belongs to. The groupid must already exist in our database. See list at end of this page.
  • The group text option can also be used to match to existing groups, and it will create new groups where neccessary.
  • Test your data on a trial web space a few times until you are confident about how it works
  • This section is intended for technical people who understand how databases work... If you have any problems, support time is chargeable (unless our system is at error, exlcuding known limitations listed above.) For all other users we recomend you use our catelogue manager directly to manage your product lists.

Prices

All prices are excl GST. 

Only the best price is given to a customer, from a range of options. General % discounts are only applied to RRP, so member prices and price breaks need to beat the RRP less discounts. 

Category IDs (Group IDs)

Refer to category ID's on footer of page where you upload file.

Otherwise,

0 = Main Shopping Page

-9 = hidden

Member Groups

These are a special pricing group that can be assigned to any member. Each member can only belong to one of these groups. All members are group A by default if they have logged in. These groups are not the ordinary member groups used for emailing or password protection. 

Column Definitions

 Column Description  Notes / Rules
p_code Product Code   50 chars ok
 p_title Product Title  
 p_order Visibility / Position of Product, eg position 1,2,3,4,5,6,7 etc, and 0 is hidden  
 p_img Image URL from the /uploads/ based path... eg should look like this, where 9999 is your site ID: "9999/images/myfilename.jpg"  
 p_details Short format description. The long format description and information tabs cannot be uploaded via CSV, as they are HTML formatted.  
 p_extra1 Optional extra fields, eg Make, Model, ISBN or Year  
 p_extra2  Optional extra fields, eg Make, Model, ISBN or Year  
 p_extra3  Optional extra fields, eg Make, Model, ISBN or Year  
 p_group Category Name, optional, use categories by name here, and a new category will be created or matched as required, instead of using the p_groupid method. 
p_groupid Primary Category or 0 for main menu, or -9 for n/a (setting this overrides the p_group method above) integer
p_groupid2 Additional Category integer
p_groupid3 Additional Category integer
p_groupid4 Additional Category integer
p_groupid5 Additional Category integer
p_groupid6 Additional Category integer
p_groupid7 Additional Category integer
p_groupid8 Additional Category integer
p_price The retail checkout price excl gst decimal(10,2)
p_priceprediscount RRP price, and base price for discounts., excl gst decimal(10,2)
p_pricea Price for logged in associated member group decimal(10,2)
p_priceb Price for logged in associated member group decimal(10,2)
p_pricec Price for logged in associated member group decimal(10,2)
p_priced Price for logged in associated member group decimal(10,2)
p_pricee Price for logged in associated member group decimal(10,2)
p_pricef Price for logged in associated member group decimal(10,2)
p_priceg Price for logged in associated member group decimal(10,2)
p_priceh Price for logged in associated member group decimal(10,2)
p_pricebreaka Price will be this if following quantity purchased decimal(10,2)
p_pricebreaka_minqty Minimum quantity required for special price above decimal(10,3)
p_pricebreakb Price will be this if following quantity purchased decimal(10,2)
p_pricebreakb_minqty Minimum quantity required for special price above decimal(10,3)
p_pricebreakc Price will be this if following quantity purchased decimal(10,2)
p_pricebreakc_minqty Minimum quantity required for special price above decimal(10,3)
p_shipping Additional domestic freight fee _added_ to other freight fees decimal(10,2)
p_shipping_int Additional international freight fee _added_ to other freight fees decimal(10,2)
p_uom Unit of measure eg EA
p_weight Weight in grams integer 
p_outofstockmessage Text message saying out of stock, shown next to price
p_minqty Minimum quantity that can be purchased decimal(10,3)
p_maxqty Maximum quantity that can be purchased decimal(10,3)
p_qtyinc Quantity Increment for purchasing (eg 12 means purchase by dozen, price each) decimal(10,3)
p_qtyinstock Quantity in stock decimal(10,3)
p_supplierprice Supplier Prce for reference only decimal(10,2)
p_suppliercode Supplier Code for reference only
p_suppliername Supplier Name For Reference only
p_filename SEO Filename valid filename
p_metatitle SEO Meta Title
p_emailfile Secure Doc File, emailed to customer after payment must exist in secure docs directory

Index Next