Important Product Fields



SKU

SKU stands for Stock Keeping Unit. Every product in your database requires a SKU. This is the products unique identifier and is the only required field for all imports. Max Length: 25 characters, cannot contain spaces or special characters.

Regular Products - Popular Fields

The fields listed below are popular fields that are typically populated when importing a product or when adding a product through the user interface. In addition to these fields you will find a list of over 100 more fields at the end of this document.

Field Name

Field Type

Field Description

Field Restrictions

Notes

Example Input

SKU*

Text String

The unique identifier for the product, its stock keeping unit.

Max Length: 25, cannot contain spaces or special characters.

The unique identifier of the product. Required for all imports.

A-0987

Name

Text String

The name of the product as it appears to customers and on invoices.

Max Length: 150

 

Red T-Shirt - Small

Active

Boolean

Active products can be sold through all channels including eBay, web shop and control panel. If inactive a product cannot be sold.

Y or N or Yes or No or True or False

 

Y

Approved

Boolean

Only visible products can be seen on your webshop. Only applicable to customers with the web shop module installed.

Y or N or Yes or No or True or False

 

Y

Brand

Text String

The brand name or manufacturer of the product.

Max Length: 50

 

Nike

RRP

Decimal

The Recommended Retail Price of the product is used for descriptive purposes only. The RRP will only show when the products price is less than the RRP.

2 decimal places

 

9.95

Price

Decimal

The price of the product

2 decimal places

Currency symbol not required.

19.95

Cost Price

Decimal

The suppliers cost price. For reporting purposes.

2 decimal places

 

1.5

Description

Text String

Description field are long text fields that can contain html, images, videos and other content. You can edit these fields in source code mode or using the WYSIWYG (human friendly) editor. These fields are used to describe products in detail and are visible to customers.

No restriction, can contain html

 

My product description <b>can contain html</b>

Height m (Shipping)

Decimal

Used for shipping calculations. The height of the product in meters.

3 decimal places

meters

0.6

Width m (Shipping)

Decimal

Used for shipping calculations. The width of the product in meters.

3 decimal places

meters

0.6

Length m (Shipping)

Decimal

Used for shipping calculations. The length of the product in meters.

3 decimal places

meters

0.6

Cubic (Shipping)

Decimal

Used for shipping calculations. The cubic of the product in meters.

6 decimal places

cubic meters

0.2556

Qty In Stock (Primary Warehouse)

Integer

Total quantity in stock for specified warehouse. Used for stock take.

 

Used to replace the qty in a warehouse.

99

Category Name List

List

List of categories that the product is assigned to.

Semicolon separated string

Use the name of the category as it appears in your database.

Table


  • Last Modified: 03/11/2015