|
Field
Name |
Column
/ Field Description & Import Instructions |
| SKU
(required) |
The
SKU Number for this option. Does not need
to be unique unless you plan on using the
inventory or accounting systems. The SKU
field has a limit of 15 characters. Please
avoid having the first character of the
SKU be a zero ( 0 ), as this may cause problems
while importing/exporting the products.
When importing the SKU field, keep in mind
that if a SKU is repeated but is NOT within
the same Group of Options, it will
import the multiple versions of the SKU
into the separate Groups of Options
without updating the other options with
the same SKU. |
| UPC
Code |
The
Universal Product Code or Barcode is the
barcode number. |
| Option
Name (required) |
This is the text that will appear and be
displayed as your option (either on the
scroll-down list, radio list, check box,
or next to a quantity field). The Option
Name has a limit of 255 characters. |
| Description
(required) |
A
detailed description of your option. This
field will support general HTML tags to
further enhance the appearance of the text
(see HTML Tags for
more details). This will only be displayed
to customers if they click on the option
to view its details |
| Additional
Text |
Description
or product, available for notices or other
information of interest to a buyer. This
field will support general HTML tags to
further enhance the appearance of the text
(see HTML Tags for
more details). This will only be displayed
to customers if they click on the option
to view its details |
| Image |
This
is the Option's Main Image.
When importing your images using a spreadsheet,
you must make sure that your image files
are located in the same directory or folder
on your PC as your spreadsheet is in. For
example, if your spreadsheet is in your
folder C:\Products\, then your image files
need to be in that same folder C:\Products\.
Refer to the image by the name and extension
on your spreadsheet (image.jpg). You may
also import images that are on the web by
specifying the full
URL path of the image. For example: http://www.website.com/images/picture2.jpg
Images must be JPEG, GIF or PNG Format (jpg,
jpeg, gif or png). Images must not exceed
100KB in size. The filename is case-sensitive.
The image will only be displayed to customers
if they click on the option to view its
details |
| Price
Variation (required) |
The
price of the option. Do not import with
currency symbols, only use numbers.
For no variation, use 0
For added variation use "+" and the currency
amount. For example: +23.50
For subtracted variation use "-" and the
currency amount. For example: -23.50
For the Give Away for FREE variation, use
*0
NOTE: If you
import the "Group of Options -
Options are Products" field as
1, the Price Variation is required. |
| Price
Level 1 - 5 |
These
are 5 separate fields that define 5 different
wholesale price levels (price lists) of
the Price Variation for each option.
By using the Administration Site each wholesale
customer can be initially set to one of
the five price levels available. Each price
level should be on a separate column.
Do not import with currency symbols, only
use numbers.
For no variation, use 0
For added variation use "+" and the currency
amount. For example: +23.50
For subtracted variation use "-" and the
currency amount. For example: -23.50
For the Give Away for FREE variation, use
*0 |
| Unit
of Measure (required) |
This
field defaults to Each, but other examples
include values Pair, Box, Dozen, lb., Gallon
and others. |
| Attached |
Specifies
if an Option requires additional packaging
aside from the Product with Options itself.
Use a 0 if this Option will not be physically
attached to the main product.
Use a 1 if this Option will be physically
attached to the main product.
If it is not imported for a new option,
this field is by default imported as "1". |
| Weight |
Additional
weight of the option. The weight is added
to the product's weight when this option
is selected and is included for the Shipping
Cost Calculation.
NOTE: The Weight
is required if you import the "Attached"
field as 0, or the "Group
of Options - Options are Products"
field as 1. |
| Length |
This
is the additional length of the option.
Used for Shipping Cost Calculations and
box consolidation.
NOTE:
The Length is required if you import
the "Attached" field
as 0, or the "Group of Options
- Options are Products" field
as 1. |
| Width |
This
is the additional width of the option. Used
for Shipping Cost Calculations and box consolidation.
NOTE: The Width
is required if you import the "Attached"
field as 0, or the "Group
of Options - Options are Products"
field as 1. |
| Height |
This
is the additional height of the option.
Used for Shipping Cost Calculations and
box consolidation.
NOTE:
The Height is required if you import
the "Attached" field
as 0, or the "Group of Options
- Options are Products" field
as 1. |
| Incremental
Qty |
Should
be set to 1 unless your option only sells
in Pair or units other than 1. |
| Product
SKU/Category Name to import to |
On
this field, import the SKU of the Product
that you want to attach each Option to,
or the Category Name of the Category
that you want to attach each Common
Option to.
Important
Note:
The SKU or the Category Name must be specified
EXACTLY as it is defined in the software.
This IS case sensitive. |
| Group
of Options - Name (required) |
Use
this to designate the Name of the Group
of Options that each option belongs
to (the question to the customer).
This field is required. Every option that
is imported should contain the information
of the Group of Options that the
option belongs to. Because of this you this
you can and should have multiple options
within the same Product that contain the
same information on the Group of Options
- Name field. |
| Group
of Options - Description |
This
sets the Description for the Group of
Options that each option belongs to.
Every option that is imported should contain
the information of the Group of Options
that the option belongs to. Because of this
you this you can and should have multiple
options within the same Product that contain
the same information on the Group of
Options - Description field. |
| Group
of Options - Additional Description |
Space
for a longer description for the Group
of Options in case your initial description
is too long. Every option that is imported
should contain the information of the Group
of Options that the option belongs
to. Because of this you this you can and
should have multiple options within the
same Product that contain the same information
on the Group of Options - Additional
Description field. |
| Group
of Options - Display Type |
Use
0 for Drop Down List
Use 1 for Radio List
Use 2 for Check Box
If it is not imported for a new Group
of Options, this field is by default
imported as "0".
Every option that is imported should contain
the information of the Group of Options
that the option belongs to. Because of this
you this you can and should have multiple
options within the same Product that contain
the same information on the Group of
Options - Display Type field. |
| Group
of Options - Display Default |
Use
0 for Not Checked (Do not display the option
selected on orders if it is the Default
Option).
Use 1 for Checked (Display the option selected
on orders even if it is the Default Option).
If it is not imported for a new Group
of Options, this field is by default
imported as "1".
Every option that is imported should contain
the information of the Group of Options
that the option belongs to. Because of this
you this you can and should have multiple
options within the same Product that contain
the same information on the Group of
Options - Display Default field. |
| Group
of Options - Enter a Qty |
Use
0 for Not Checked (Will not allow customers
to enter a quantity for each option).
Use 1 for Checked (Will allow customers
to enter a specific quantity for each option).
If it is not imported for a new Group
of Options, this field is by default
imported as "0".
Every option that is imported should contain
the information of the Group of Options
that the option belongs to. Because of this
you this you can and should have multiple
options within the same Product that contain
the same information on the Group of
Options - Enter a Qty field. |
| Group
of Options - Options are Products |
Use
0 for Not Checked (Do not display options
as separate products).
Use 1 for Checked (Display each option as
a separate product).
With this Checked, you must import the Price
Variation, Weight, Length, Width, and
Height of each option.
If it is not imported for a new Group
of Options, this field is by default
imported as "0".
Every option that is imported should contain
the information of the Group of Options
that the option belongs to. Because of this
you this you can and should have multiple
options within the same Product that contain
the same information on the Group of
Options - Options are Products field.
|
| Group
of Options - Must Select an Alternate Option
|
Use
0 for Not Checked (Allow customers to choose
the Default Option).
Use 1 for Checked (Do not allow customers
to choose the Default Option). Checked (1)
should only be used when the Default Option
is something similar to "Please Select
One".
If it is not imported for a new Group
of Options, this field is by default
imported as "0".
Every option that is imported should contain
the information of the Group of Options
that the option belongs to. Because of this
you this you can and should have multiple
options within the same Product that contain
the same information on the Group of
Options - Must Select an Alternate Option
field. |
| Price
Per Qty |
Use
0 to specify that this is not
an option with a Price Per Quantity Range.
Use 1 to specify that this is an option
with a Price Per Quantity Range.
If it is not imported for a new Option,
this field is by default imported as "0". |
| Price
Per Qty - From 1 - # |
The
"From" Quantity for each Quantity
Range of this option's price variation. |
| Price
Per Qty - To 1 - # |
The
"To" Quantity for each Quantity
Range of this option's price variation. |
| Price
Per Qty - Retail Price 1 - # |
Sets
the Additional Price for each Quantity Range. |
| Price
Per Qty - Wholesale Levels 1-5 |
These
are 5 separate fields that set the Additional
Price of Wholesale (up to 5 levels) for
each Quantity Range.
For no variation, use 0
For added variation use "+" and the currency
amount. For example: +23.50
For subtracted variation use "-" and the
currency amount. For example: -23.50
For the Give Away for FREE variation, use
*0 |
