Product Import Guide

In order to import products from a csv file or "comma delimited" file your file must meet the following guidelines.

  1. Your data cannot contain any commas other then the ones separating the values or the data will be inputted incorrectly. Instead of commas in your descriptions use the code "," without the quotes of course. Upon import the , will be converted into a comma.  
  2. All items being imported must have a UNIQUE Item ID or the import will just return errors. For best results just leave it blank and it will be assigned automatically.
  3. The general format for the files is as follows. (If you wish to leave a field empty you may skip it but you must leave the empty space where it belongs.)  
Field
Description
Format
1
Item ID
Leave this blank as it will assign automatically.
Numbers Only
2
Categories
This can be taken from the admin area or made up to create that category when imported.   
Numbers w/ Seperators (ex. 10->23|2->18) 10 is category ID "->" seperates each cat and sub cat ID 23 is the sub category ID. The "|" seperates multiple categories & subcategories
3
Title Product title.
Letters and Numbers
4
Image File
Image file located in your product images directory.
Filename
5
Thumbnail
Thumbnail image file, located in your product images directory.
Filename
6
Overview
Overview of the product.
Letters and Numbers

7
Details
Details of the product.
Letters and Numbers
8
Meta Keywords
Meta tag keywords that will appear in the header.
Letters and Numbers
9
Meta Description
Meta tag description that will appear in the header.
Letters and Numbers
10
Quantity
Number of the products in stock.
Numbers Only
11
Sold
Quantity of product sold.
Numbers Only
12
Retail
Retail price of the product.
Numbers and Decimal Point
13
Price
Product price.
Numbers and Decimal Point
14
Sale Price
Product sale price if any.
Numbers and Decimal Point
15
Shipping Price
Product fixed shipping price if any.
Numbers and Decimal Point
16
Weight
Product weight. (Required for most shipping methods)
Numbers and Decimal Point
17
Length
Product length. (Required for most shipping methods)
Numbers and Decimal Point
18
Width
Product width. (Required for most shipping methods)
Numbers and Decimal Point
19
Height
Product height. (Required for most shipping methods)
Numbers and Decimal Point
20
Ship Seperate
Set to yes if this item requires its own box.
"Yes" or "No"
21
Max Per Box
Max number of items that can fit in the same box.
Numbers Only
22
Charge Shipping
Charge shipping for the product?
"Yes" or "No"
23
Charge Tax
Charge tax for the product?
"Yes" or "No"
24
Is New
Mark as new item?
"Yes" or "No"
25
Is Featured
Mark as featured?
"Yes" or "No"
26
Available To
Group number that can view the product. (Blank for All)
Numbers
27
Viewable?
Product is viewable to customers?
"Yes" or "No"
28
Manufacturer
Name of the manufacturer
Letters and Numbers
29
Vendor
Name of the vendor
Letters and Numbers
30
Item SKU#
Use this field to assign your own item number instead of the above item ID.
Letters and Numbers

Basically your files will look something like this. Each product on its own line:
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30