Field Name
|
Example
|
Type/Limit
|
Field Description
|
Item Type
|
Product/Variant
|
String (Defined)
|
The Item Type tells our system if the line is a product or
a variant.
|
Product ID
|
12345
|
Number (Auto-Generated)
|
The Product ID is uniquely defined by the database and
cannot be created manually. When importing NEW products please leave this
field blank. If you are re-importing existing products then you have to use
the already existing product ID provided from the bulk export.
|
Product Code/SKU
|
AD5001
|
String (50)
|
An optional product code or stock keeping unit (SKU) which
is a specific number/bar code used to identify a product.
|
Product Name
|
Apple Mighty Mouse
|
String (100)
|
Product name is the unique identifier for the table. This
is a required field.
|
Description
|
|
String (1000)
|
Here is where you can give a text description of your
product.
|
Category
|
Computer Accessories
|
String (100)
|
Here you can specify the main category of each product.
|
SubCategory
|
Mouse
|
String (100)
|
The subcategory which lies under the main category, that
each product lives within.
|
Brand
|
Apple
|
String (100)
|
A brand is the identity of a specific product, typically
the manufacturer.
|
Price
|
1499.99
|
Number
|
The amount it will cost the customer to buy the product
from you.
|
Stock Status
|
In Stock
|
String (Defined)
|
Here you can set stock status of the product. Stock status
can be 'In Stock', 'Out of Stock' or 'On Order Only'.
|
Stock
|
1, 2, 8
|
Number
|
This is the available product stock. This field is used
when you track inventory of a product, and it overrides Stock Status field
based on available stock. If you do not track product inventory, leave it
blank.
|
List Price
|
1200.00
|
Number
|
This field represents list or market price. If higher than
product price, discount is displayed with product with cutted list price.
|
Cost
|
1200.00
|
Number
|
How much this product cost you to buy. This does not
appear on the storefront/website and is used for internal reporting purposes
only.
|
Shipping Price
|
100
|
Number
|
Fixed shipping is the cost to ship one unit of this
product. If left blank, the default shipping calculator will be used during
checkout. Please remember that a fixed shipping cost will override any
shipping method in your store when this product is purchased.
|
Warranty
|
|
String (100)
|
You can enter any warranty details for each product into
this field.
|
Weight
|
0
|
Number
|
If you are using a physical product which needs to be
fixed, then you must enter a weight for each product(in LBS) so that it can
be used to calculate shipping costs when ordering.
|
Color
|
Black
|
String (100)
|
One of the colors of your product.
|
Size
|
Small,Medium,Large
|
String (100)
|
Available sizes of your product or a color variant
|
Size List Name
|
Shirt Sizes
|
String (50)
|
The name of size list being used for this product. You may
have multiple size lists for different product types.
|
Option Price
|
1200, +200, -150
|
Number
|
Price for any color/size variant of a product. If left
blank, the actual product price is applied. Price difference with respect to
actual price can be applied by adding + or - sign before the difference
amount.
|
Option Active
|
Y / N
|
Character (Defined)
|
Here you can set availability of color/size variant, if
any. (Y=yes N=no)
|
Option Stock
|
1, 2, 8
|
Number
|
This is the available product option stock. This field is
used when you track inventory of a product options, and it overrides Option
Status field based on available stock. If you do not track product option
inventory, leave it blank.
|
Image-1
|
sample.jpg
|
String (500)
|
This is the main image of product. This field contains URL
of the product image where it automatically gets downloaded from. If you have
exported pre-existing products then this field contains the file name of the
image already available on your website, and you can disregard this field,
unless you need to change the image.
|
Image-2
|
sample.jpg
|
String (500)
|
One of the other images of product.
|
Image-3
|
sample.jpg
|
String (500)
|
One of the other images of product.
|
Image-4
|
sample.jpg
|
String (500)
|
One of the other images of product.
|
Web Link
|
|
String (500)
|
You can specify URL of the product manufacturer's website.
|
Meta Keywords
|
|
String (1000)
|
Here you can specify unique meta keywords, or leave blank
to use default site wide keywords as defined in the Website Settings page.
|
Meta Title
|
|
String (100)
|
Here you can specify a page/meta title, or leave blank to
use the product's name as the page title.
|
Meta Description
|
|
String (1000)
|
Here you can specify a unique meta description, or leave
blank to use product description or default site wide description as defined
in the Website Settings page.
|
New Arrival
|
Y / N
|
Character (Defined)
|
Here you can tell if the product should be marked as 'New
Arrival' and visible on the storefront/website in the 'New Arrival' section.
(Y=yes N=no)
|
Featured
|
Y / N
|
Charater (Defined)
|
Here you can tell if the product should be marked as
'Featured' and visible on the storefront/website in the 'Featured Products'
section. (Y=yes N=no)
|
Active
|
Y / N
|
Character (Defined)
|
Here you can tell if the product should be visible on the
storefront/website. (Y=yes N=no)
|