| |
 |
Image (File Name) (Required) Put the name of the Image file or number this item is marked with, as on the catalog. Specify multiple pictures item in the same column by separating them by a semicolon.
|
| |
 |
Item Number (Optional) Product ID or SKU number that you use to identify this product, leave blank if not applicable.
|
| |
 |
Categories: (Required) Category help organizing the catalog and makes it easy for visitors to browse and find products on the website. Specify the name of the category in this column, use semi colon to separate multiple categories.
|
| |
 |
Item Packing Type: (Required if Item Packing Quantity is not empty). Bulk packing items that are only available for sale in multiple of packing quantity can be handled by putting a packing type here example, case, dozen, box, pallet etc. in conjunction with item packing quantity.
|
| |
 |
Item Packing Quantity: (Required if Item Packing type is Not empty) Bulk packing items that are only available for sale in multiple of packing quantity can be handled by putting a packing quantity in conjunction with item packing type.
|
| |
 |
Item Name : Name of the item, users can search for this name.
|
| |
 |
Descriptions : (Optional)
| a.
|
Short
Description
A short description for the item (200 characters) this always shows on the item detail page. It shows on the category pages in some templates. Basic HTML formatting tags are allowed in the descriptions. |
| b. |
Detailed
Description
A detailed description for the item (2000 characters). This description shows on the item detail page. |
|
| |
 |
Out of Stock (Optional) Default 'N' Specify 'Y' if you generally carry this item and it is temporarily out of stock. It will show on the website but visitors will not have an option to order it.
|
| |
 |
Shipping Weight: (Required if using UPS or USPS to calculate shipping cost) This is the weight of the item after packing it for shipping, for items that take up more volume please specify a value that will result into a more accurate calculation of shipping costs.
|
| |
 |
Shipping Instructions: (Optional) Indicate any special instructions about shipping a product. Can be used to message back ordered, pickup only doesn't ship etc.
|
| |
 |
Specifications : (Optional)
Item specification defines the characteristics of the item like volume, weight, length etc.: Specify them as Name:Description: Order:Primary add more columns to the spreadsheet for multiple specifications.
a. Specification
b. Description
c. Order:
Sequence in which this displays.
d. Primary:
Boolean flag Y/N. The ones flagged 'Y' show in the item list and item detail page. 'N' show only on item detail page.
|
| |
 |
Variants Name: (Optional)
Used to give customers an option to choose appropriate variant for Items that are sold with some variations e.g. color, size, pattern etc. Add more columns for variant name and variant options to handle multiple variants for an item. |
| |
 |
Variant Options: (Required if variant name is not empty)
Options corresponding to the variant name, a semicolon is used to separates multiple options. Additional price for an option is handled by putting it in parenthesis e.g. "(add $ 2.00) " will add $2 to the base price of the item when added to shopping cart. |
| |
 |
Wholesale Price: (Optional)
Specify the item price in the format "qty:price;qty:price", multiple prices allow you to support quantity based discounts and have different prices based on the quantity ordered. These prices are Wholesale and retail prices are calculated by adding a % markup on the wholesale prices if your store supports both wholesale and retail business. You can specify the retail price in this column if you don't support retail trade. |
| |
 |
Discount (Optional)
Specify what is the discount available on the item, it can be a $ amount or a fix % determined by the discount type column. Items with discount display differently on the site and highlight the fact that the item is sale prices. |
| |
 |
Discount Type (Required if Discount is not empty)
Works in conjunction with discount column. Can have a value of $ or %.
|