How-to: Add A New Product - CSV method

CSV Method

You can edit the file in most spreadsheet applications such as Microsoft Excel.

As this is a "Comma Seperated Values", please do not include commas in your file. You may edit the specific entries after if you wish to change the Product Name or Description.

The file contains the following headings:
product_code
product_name
description
price
stock
size_id
colour_id
weight
height
width
depth
postage_local *
postage_europe *
postage_zone1 *
postage_zone2 *
next_delivery_date
tb_filename
filename
gallery_id

* fields not yet used by system.

The fields should be fairly self-explanatory.

The price is input in decimal. 2.34 Do not include a currency symbol.

The stock level if given must be numeric. It can also be negative (out of stock and on back order) or zero. Depending on options in the administration sections your system may not display the data to customers, but you may find it useful.

The size_id and colour_id must be the id numbers as reported on their respective pages.

The weight field is in grammes, and may be used for postage calculations.

The height, width and depth are shown on some installations if the data is given.

The administration section optionally allows the next_delivery_date to be displayed on out of stock items.

tb_file_name is the filename of the thumbnail image used in the gallery view for a product, such as cat_a123_tb.gif

filename is the name of the display image as used by the product page.

Both images are uploaded the 'media' folder as specified in your administration section.

Please see the image naming conventions section for further advice.

The gallery_id is either a numeric id number or the name of a gallery. If a name is given, it will attempt to match it and return the existing id, otherwise a new gallery will be created. Matches have to be exact with case and punctuation.

To add new products from a csv file visit you administration section:
1. Product/Category/Gallery
2. Choose "Add New Products from CSV file"
3. Brose to find the updated csv form on your computer
4. Hit "upload"

The system will then attempt to add all the new products, and will add the relevant entires to the product-gallery relationship table, specific products details (such as pricing and sizes) and will add the image names if supplied.

The images themselves will now have to be uploaded separately, either via FTP or using the "Image Management System" section.