gb
  • gb
  • gb
  • gb
  • gb
  • gb
  • gb
  • gb
  • gb
  • gb
  • gb
-->

Multi file CSV

Overview

The following files will be generated for this export. They always contain a header row and use the delimiter of your choice (one of comma, pipe, tab or semi colon). Each piece of data may be escaped by double quotations (“). The following files are published and their content fully described below

Categories.csv CategoryFeatures.csv CategoryTypes.csv
ContractPrices.csv Distributors.csv DistributorStockAndPrices.csv
EANCodes.csv Manufacturers.csv Multimedia.csv
ProductCategories.csv ProductChanges.csv ProductFeatures.csv
ProductPictures.csv Products.csv RelatedProducts.csv
RestrictedValues.csv StockAndPrices.csv

Categories.csv

This file contains the categories which met the publish criteria you set in your store configurator within Stock in the Channel

Name

Format

Example

Comments

ID

Int32

Not nullable

535

Unique category identifier

ParentID

Int32

Nullable

535

Links to an existing ID in this file unless a root category

Name

Text

Max length 50 chars

Not nullable

Accounting Software

Order

Int32

Not nullable

12

This is the order in which categories are displayed

IsHidden

Boolean

Not nullable

FALSE

ProductCount

Int32

Not nullable

7

SubCategoryProductCount

Int32

Not nullable

0

ThumbImageURL

Text

Max length 255 chars

Nullable

http://images.icecat.biz

NestLevel

Int32

Not nullable

1

Where the category sits in the category tree

SubCategoryCount

Int32

Not nullable

1

UNSPSC

Int32

Nullable

43160000

TypeID

Int32

Not nullable

1

Links to ID in file CategoryTypes.csv

MainImageURL

Text

Max length 255 chars

Nullable

http://images.icecat.biz

MetaTitle

Text

Max length 50 chars

Nullable

Can be used for SEO

MetaDescription

Text

Max length 200

Nullable

Can be used for SEO

Description

Text

Nullable

 

CategoryFeatures.csv

 

This file contains the features a category can have i.e. a feature for the category Laptops may be Screen Dimesions.

 

Name

Format

Example

Comments

ID

Int32

Not nullable

97

Unique category feature identifier

CategoryID

Int32

Not nullable

708

Links to ID in file Categories.csv

Name

Text

Max length 50 chars

Not nullable

Hard disk size

Order

Int32

Not nullable

144

The order in which the filters are displayed.

CategoryTypes.csv

 

This file contains the names of each root category tree

 

Name

Format

Example

Comments

ID

Int32

Not nullable

12

Unique category type identifier

Name

Text

Max length 255 chars

Not nullable

Toner

ContractPrices.csv

 

This file contains any contract prices you have set up.

Name

Format

Example

Comments

ID

Int32

Not nullable

12

Unique contract price rule  identifier

MinimumCost

Decimal

Not nullable

123.00

MaximumCost

Decimal

Not nullable

123.00

CategoryID

Int32

Nullable

1

Links to ID in file Categories.csv

BrandID

Int32

Nullable

1

Links to ID in file Manufacturers.csv

Sku

Text

Max length 255 chars

Nullable

ABC123

Name

Text

Max length 30 chars

Not nullable

NHS

The customer group name this rule belongs to

MarkupPercentage

Decimal

Nullable

1.5

MarkupPrice

Decimal

Nullable

123.00

AbsolutePrice

Decimal

Nullable

123.00

ExecutionOrder

Int32

Not nullable

1

Order in which rules should be applied

 

Distributors.csv

 

This file contains all the distributors that are selling the products within your export..

 

Name

Format

Example

Comments

ID

Int32

Not nullable

12

Unique distributor identifier

Name

Text

Max length 255 chars

Not nullable

C2000

Website

Text

Max length 255 chars

Not nullable

www.computer2000.co.uk

DistributorStockAndPrices.csv

 

This file contains all the distributor stock and prices for the products in your export.

 

Name

Format

Example

Comments

ProductID

Int32

Not nullable

1

Links to ID in file Products.csv

DistributorID

Int32

Not nullable

1

Links to ID in file Distributors.csv

Stock

Int32

Not nullable

0

Cost

Decimal

Not nullable

18.04

Up to 4 decimal places

DistributorSKU

Text

Max length 100 chars

Not nullable

ABC123

DistributorCategory

Text

Max length 100 chars

Nullable

Camcorders

ETA

Date

Nullable

2012-01-01

EANCodes.csv

 

This file contains any EAN codes we have for the products in your export.

 

Name

Format

Example

Comments

ProductID

Int32

Not nullable

1

Links to ID in file Products.csv

EANCode

Text

Max length 13 chars

Not nullable

0660543009702

Manufacturers.csv

 

This file contains all the manufacturers for products in your export.

 

Name

Format

Example

Comments

ID

Int32

Not nullable

1

Unique manufacturer identifier

Name

Text

Max length 255 chars

Not nullable

Acer

ThumbImageURL

Text

Max length 255 chars

Nullable

http://images.icecat.biz

Multimedia.csv

 

This file contains links to multimedia objects relating to products within the export.

 

Name

Format

Example

Comments

ProducID

Int32

Not nullable

1

Links to ID in file Products.csv

ShortDescription

Text

Max length 255 chars

Not nullable

1

URL

Text

Max length 255 chars

Not nullable

http://www.someurl.com/1.pdf

Type

Text

Max length 255 chars

Not nullable

application/pdf

ProductCategories.csv

 

This file contains the relationship between products and their categories.

 

Name

Format

Example

Comments

ProducID

Int32

Not nullable

1

Links to ID in file Products.csv

CategoryID

Int32

Not nullable

1

Links to ID in file Categories.csv

ProductChanges.csv

 

This file contains any changes in product IDs so you can easily manage data changes.

 

Name

Format

Example

Comments

OldProducID

Int32

Not nullable

1

NewProductID

Int32

Not nullable

1

Links to ID in file Products.csv

ProductFeatures.csv

 

This file contains product features for the products within your export.

 

Name

Format

Example

Comments

ID

Int32

Not nullable

1

Unique product feature identifier

ProductID

Int32

Not nullable

1

Links to ID in file Products.csv

RestrictedValueID

Int32

Not nullable

1

Links to ID in file RestrictedValues.csv

ProductPictures.csv

 

This file contains all possible pictures for the products in your export.

 

Name

Format

Example

Comments

ProductID

Int32

Not nullable

1

Links to ID in file Products.csv

MainImageURL

Text

Max length 512 chars

Not nullable

http://images.icecat.biz

ThumbImageURL

Text

Max length 512 chars

Not nullable

http://images.icecat.biz

Products.csv

 

This file contains the main product data.

 

Name

Format

Example

Comments

ID

Int32

Not nullable

30974

Unique store product identifier

SKU

Text

Max length 255 chars

Not nullable

A3L791B02M-GRN

Name

Text

Max length 255 chars

Not nullable

Patch cable – RJ-45(M)

ManufacturerID

Int32

Not nullable

30

Links to ID in Manufacturers.csv

MainImageURL

Text

Max length 255 chars

Nullable

http://images.icecat.biz

ThumbImageURL

Text

Max length 255 chars

Nullable

http://images.icecat.biz

Specifications

Text

Max length infinite chars

Nullable

<table class=”

Description

Text

Max length infinite chars

Nullable

What is a Category

SearchCache

Text

Max length infinite chars

Nullable

networking etworking

DescriptionType

Text

Max length 10

Not nullable

Datasheet

MediumImageURL

Text

Max length 255 chars

Nullable

http://images.icecat.biz

Title

Text

Max length 255

Not nullable

Patch cable – RJ-45(M)

Weight

Decimal

Nullable

123.46

Up to 4 decimal places

Family

Text

Max length 255

Nullable

Aspire

Reviews

Text

Max length 1000

Iframe containing reviews

PDFURL

Text

Max length 255

Nullable

ShortDescription

Text

Max length infinite chars

Nullable

RelatedProducts.csv

 

This file contains all the related products within your export.

 

Name

Format

Example

Comments

ProductID

Int32

Not nullable

1

Links to ID in file Products.csv

RelatedProductID

Int32

Not nullable

1

Links to ID in file Products.csv

RestrictedValues.csv

 

This file contains all the feature values for the products within your export.

 

Name

Format

Example

Comments

ID

Int32

Not nullable

1

Unique restricted value identifier

CategoryFeatureID

Int32

Not nullable

1

Links to ID in file CategoryFeatures.csv

Text

Text

Max length 50 chars

Not nullable

2 to 3 GHz

Order

Int32

Not nullable

1052

StockAndPrices.csv

 

This file contains the combined stock from all distributors for your products and the calculated prices based on your pricing rules within your price list configurator.

 

Name

Format

Example

Comments

ProductID

Int32

Not nullable

1

Links to ID in file Products.csv

Stock

Int32

Not nullable

10

Price

Decimal

Not nullable

18.039

Up to 4 decimal places

Cost

Decimal

Not nullable

17.55

Up to 4 decimal places

DistributorID

Int32

Not nullable

19

Links to ID in file Distributors.csv

Let us know if we missed anything...

Leave a Comment

You must be logged in to post a comment.