Import Products

The Import Product settings can be found in the Shopping Cart Administration Area under Products > Import.

To import products, product data must be stored in a tab delimited file with a ".txt" extension. A tab delimited file is a file with one line of data for each product. Each line is made up of fields separated by the tab character. The following tab delimited file examples contain product data for 4 products.

Example 1. This tab delimited file will be used to add new products. The minimal amount of data is provided (product name, description and price). 

Shirt    100% cotton t-shirt    19.99

Pants    Cotton blend pants    49.50

Socks    Crew training socks  15.00

Shoes    Retro running shoes    93.87

Example 2. This tab delimited file will be used to update existing products, which is why each product's item ID is in column 1. The fields that are updated will be the product name, description, price, weight, inventory, low inventory warning amount, volume discounts, minimum quantity, apply sales tax and disallow add to cart if inventory reaches 0.

1    Motor Oil    Motor Oil 4 Pack    19.99    10    1000    75    16-80=10    NULL    t    t

2    Brake Fluid    Brake Cleaning Fluid    3.50    5    850    40    NULL    2    t    t

3    Car Wax    Car Wax Formula II    6.95    4    600    50    6-10=1,11-999=1.50    2    t    t

4    Air Filter    Engine Air Filter    6.25    5    700    100    NULL    2    t    t

Product 1 does not have a minimum quantity amount, so that column is set to NULL. Volume discounts are not offered on Products 2 and 4, so that column is set to NULL. On product 3, all fields are set.

Use NULL when the field you are updating is normally edited inside a text box on the product edit form. Use t or f (true or false) when the field you are updating is normally a checkbox that's either checked or not on the product edit form.