Bulk Product Uploads

Title

Guidance

Category ID

Each category must be assigned a category ID. Values must be numeric and unique (56 not 56A).

Category Columns

These are the names of your top level categories and multiple level sub-categories. You must create a top-level category on one row prior to creating its sub category on the following row. This value should be entered as a column range (B-D where Column B is a top level category, Column C a second level category etc.)

Display Order

This is the running order that your categories will be displayed in. Values must be numeric and unique within each category level, beginning from 1 and increasing infinitely.

Link

Here you can enter an optional link from a category to an external website.

Image

This can either be a URL to an image stored online (e.g. http://www.quantumweb.co.uk/images/logo.jpg) or the exact file name of a file uploaded through the Image Import section of the control panel.

Description

This is where you can enter a brief description of the category. This field may contain HTML.

Hidden

Choose your category's status as either active or hidden. Enter 0 for active or 1 for hidden

Template

This field represents the template to use for displaying products and sub-categories for this category. Can normally be left to the default of 'template1.php' or alternatively left blank

Meta Title

This value is automatically generated by our software.

Meta Description

This can be filled out with a short description (10-15 words) of the category, however if left blank our software will automatically generate the content.

Meta Keywords

Again, your keywords are automatically generated by our software, however you can enter specific keywords (comma separated) in this column if you wish to override the automatic settings.

Title

Guidance

Code

A product code must be entered for EVERY ITEM, or the import will fail. The product code must be made up of alphanumeric characters and not contain any spaces.

Display Name

The name of the product that will be displayed on the website and in searches. This will also be used in the product URL and may be modified for these purposes.

Images

The exact names (including case sensitivity) of all of the images that you wish to be assigned to this product should be entered here. Image names should include the file extension associated (e.g. .GIF, .JPG, .PNG) and cannot contain any spaces or special characters. When entering more than one image separate with commas but no spaces.

Product Hidden

If you wish to keep a product hidden on your site, (this is not advised for SEO), then place a '1' in the field. If you wish to display the product, place a '0' in the field.

Category

Every product MUST be put into a category. Input the corresponding category number(s) that the product belongs to based on your separate Category Import CSV document. If the product belongs to more than one category, enter the numbers separated with commas, e.g. 35,75,77.

Short Description

This is a short description of your product, which will be shown on the category level. It should be no more than 10-20 words long.

Long Description

This is a longer description of the product that will be displayed on the product page. This should consist of at least 50 words and mention the product name 2-3 times in order to assist your website's optimisation.

Meta Title

This value is automatically generated by our software.

Meta Description

This can be filled out with a short description (10-15 words) of the product, however if left blank our software will automatically generate the content.

Meta Keywords

Again, your keywords are automatically generated by our software, however you can enter specific keywords (comma separated) in this column if you wish to override the automatic settings.

Manufacturer

Here you can enter the brand or manufacturer of your product.

Ship Weight

Your product's shipping weight should be entered in kg, without the kg symbol.

Stock Level

This is the amount of stock that you have for the chosen product.

Stock Control

The stock control function within the control panel  allows a product to be displayed as out of stock dependent of the product's stock level. To activate the stock control function enter a '1' into this field. If you do not wish to activate stock control for this product then enter a '0'.

RRP

This is the pre-sale price or RRP for a product. Do not use a £ symbol.

Price

This is the price that you want to sell your product for. Again, do not use a £ symbol.

Sale Price

This is the price that you wish to offer this product at when on sale. Again, do not use a £ symbol.

Original Price

When 'Price' is the same amount as 'Sale Price', enter the non-sale price here. Again, do not use a £ symbol.

VAT Type

Select one of the following values in order to calculate the correct VAT rate for the product: '0' for excluding VAT, '1' for inclusive of VAT and '2' for VAT exempt

Discount Code

The ecommerce system allows you to create and assign codes to individual discount offers. The value within this field should reflect the internal codes created from the Discounts Settings page within your control panel.

Options Prompt

This is the prompt/type for the option you want associated with a product, Type in this box either "size", "colour", "finish" or anything relevant that you require. The CSV allows for additional option types to be added. As an example, if a product came in both different sizes and colours, you would need 2 columns.

Option Values

Option values are associated with the option prompts provided in the prior column'(s). These are the option values you wish to display for a product, e.g. if in 'Option Prompt' you typed "colour" you might want 'Option Values' to display "blue,orange,purple,green." When putting in option values you need to separate the different options with a comma but no space. 'Option Prompt:0' relates to 'Option Value: 0' and 'Option Prompt: 1' relates to 'Option Values: 1'

Option Stock

This column is for the associated stock levels for the individual Option Values. They must be coma separated and should be in the same consecutive order as the Values.

Option Codes

In this column you can put the associated product codes for the individual Option Values. Once again they must be coma separated and should be in the same consecutive order as the Option Values.

Option Price Difference

The option price difference differentiates the price of the option value from that of the original product price. Values are once again comma separated, and should be in the same consecutive order as the Option Values. These price differences should have a plus or minus sign to indicate as to whether the system should add or subtract from the main product price.

Product Code (Code)

1.       A product code must be entered for every item, or the import will fail. (This is absolutely essential to a product upload. Should even one product that you are attempting to upload be without a product code, the upload will not work)

2.       The product code must not contain any spaces or non-alphanumeric characters.

Hide Product?

If you wish to keep a product hidden on your site, (this is not advised for SEO), then place a "1" in the field. If you wish to show the product, put "0" in the box instead.

Meta Title

You need not fill this box out, as it is automatically generated by our software.

Meta Keywords

Once again, your keywords are automatically generated, however you can fill this column if you wish to override the automatic settings.

Meta Description

This can be filled out with a short description of the product, (10-15 words), however if left blank our software will automatically generate the content.

Product Name

This is your product name.

Long Description

The 'Long Description' should make use of the product name 2-3 times, in a piece of text at least 50 words in length as it will help with your website's rank.

Short Description

This is a short description o your product, which will be shown on the category level. It should be no more than 10-20 words.

Weight

This should be inputted in kg, without the kg symbol

Stock Level

This is the level of stock you have.

Stock Notification Level

This is the level you are notified of low stock via email.

RRP

This is the pre-sale price or RRP for a product, do not use a £ symbol

Price

This is the price you want to sell your product for, do not use a £ symbol

Image Names

This column holds all the images associated with the product. Image names should follow the following rules:

1.       The file extension associated (e.g. .GIF, .JPG, .PNG)

2.       Each image name should be separated by a comma without any spaces.

3.       The image name cannot contain any spaces or special characters

4.       The image name is case sensitive

Top Level Category

(Category 0)

Every product needs to be put into a category, in this column you need to stipulate the top level categories a product is in. Separate categories need to be separated by a comma.

Subcategory

If a product resides in a subcategory, type the name of the subcategory in this field

Sub-Subcategory

If the product resides in a sub-subcategory, type the name of the subcategory in this field. Once again if there are multiple subcategories, separate their names with a comma.

Option Type'(s)

This is the type of option you want associated with a product, such as size, colour, finish or anything relevant that you require. 'Option Type: B' allows for an additional option type to be added. This can be applied when a product not only comes in different sizes, but also in different colours for example.

Option Values'(s)

The 'Option Values: A' in Column U relates to the 'Option Type: A' in Column F. These are the option values you wish to display for a product, e.g. if 'Option Type: A' was set to "colour" you might want 'Option Values: A' to display "blue,orange,purple,green." When putting in option values you need to separate the different options with a comma but no space. 'Option Type: A' relates to 'Option Values: A' and 'Option Type: B' relates to 'Option Values: B.'

Option Price Difference

The option price difference differentiates the price of the option value from that of the original product price. Values are once again comma separated, in the example document you will see column W and X hold the price difference values. Therefore on the import page within the control panel you would input W-X. These price differences should have a plus or minus sign to indicate as to whether the system should add or subtract from the main product price.

Option Stock

This is the stock level for the individual Option Values.

Title

Guidance

HAS_SCALLOP

In this column you must define if the product has a Scallop (1 = Yes)

SIZESET

If the product has a preset size, (i.e. if it's a standalone product that does not come in different size bands), place a 1 in this box

PRICE BAND NAME

This sets the Price band to make use of for the product, it must exactly match the existing price bands that are on the system.