|
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 500kb 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 - Pricing and Dimensions" 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 |
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. |
| Use this option to ask customer a question |
Specifies
if an Option, if selected, should ask the customer a question that must be typed in.
Use a 0 if this Option will not ask customers a question.
Use a 1 if this Option will ask customers a question. If this field is imported as 1, the Description field should be used as the Question Text.
If it is not imported for a new option, this field
is by default imported as "0". |
| Question Required |
Specifies
if a Question being asked for the option should be required. This only applies if the previous field (Use this option to ask customer a question) is set to 1.
Use a 0 if the question should not be required.
Use a 1 if the question should be required.
If it is not imported for a new option, this field
is by default imported as "0". |
| 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
Use 3 for Qty Field
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 |
Specifies if the First Option should be shown on the invoice when selected.
Use
0 for Not Checked (Do not display the option selected
on orders if it is the First Option).
Use 1 for Checked (Display the option selected on
orders even if it is the First 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 - Show Options On |
Use
0 to show this Group of Options on both Retail and
Wholesale sites.
Use
1 to show this Group of Options only on the Retail
site.
Use
2 to show this Group of Options only on the Wholesale
site.
Use
3 to not show this Group of Options on any site.
If it is not imported for a new Group of Options, this
field is by default imported as "0". |
| Group
of Options - Apply 2nd Product Purchase Discount |
Use
0 for No (Do not apply category discount to options).
Use 1 for Yes (Apply category discount to options).
If it is not imported for a new Group of Options,
this field is by default imported as "1". |
| Group
of Options - Cannot Select the First Option |
Use
0 for Not Checked (Allow customers to choose the
First Option).
Use 1 for Checked (Do not allow customers to choose
the First Option). Checked (1) should only be
used when the First 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 - Cannot Select the First
Option field. |
| Group
of Options - Pricing and Dimensions |
Specifies how to treat the price, weight, and dimensions for each option in the Group of Options when the Qty Field type is selected. This only applies is you selected Qty Field (4) for the Display Type on the Group of Options (the Group of Options - Display Type field).
Use
1 for Use Product + Options Pricing and Dimensions.
Use
2 for Only Use Option's Pricing and Dimensions.
Use
3 for Use Parent Product's Pricing and Dimensions for Each 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. |
| 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 |
