Sep 08 2010 
Support Center » Knowledgebase » Example CSV Format For Bulk Upload
 Example CSV Format For Bulk Upload
Solution

Shown below is an example of the most commonly used attributes for bulk uploading:





Category Key: Insert the key, not the name, of the category you want this product to belong to. If you want to have multiple categories for this product, separate the keys with a double | which is located above the enter key on most keyboards.

Product Name: Name of the product.

Product ID: Unique ID given for the product.

Price: What you want the price to be. Note that you do not want to use currency symbols like the $ sign as it will not work.

Manufacturer ID: If you have setup manufacturers, you can specify what products belong to them using this option.

Unit Weight: Here you specify the weight of your products.

Is Taxable: Specifies if the item is to be taxed.

Description: Here you enter your full product description. HTML is allowed in this field.

Overview: Here you specify your product overview, which is a quick snippet about the product usually. HTML is not accepted here.

Attribute Options (1-3): Here you can setup a product attribute. The format is as follows - option1(+/- price, +/- weight) or (+/- % of price, +/- % of weight). All options must be separated by a double || .

Attribute Name (1-3): Here you give your options a reference name.

Attribute Caption (1-3): Name of the option that gets displayed on the website.

Other fields are
Meta Keywords
Meta Title
Meta Description
Sorting Priority
Call for Price
Sales Price
Price Level 1
Price Level 2
Price Level 3
Shipping Price - Product Level
Free Shipping
Unit Weight
Case Pack
Inter Pack
Min Order
Max Order
Available
On Home Page
Hot Deal
Digital Product
Digital Product File
Track Inventory
Stock
Stock Warning
Inventory Rule
Image URL

For further example, attached is a csv file with some pregenerated products for experimentation or creating a template.

Sample CSV file for bulk uploading



Article Details
Article ID: 1
Created On: Jan 11 2008 06:15 PM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Submit a Ticket | Knowledgebase | Troubleshooter | News | Downloads
Language:

Help Desk Software Help Desk Software By Kayako SupportSuite v3.60.04