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 choosing (one of comma, pipe, tab or semi colon). Each piece of data may be escaped by double quotations (“).

Categories.csv

CategoryFeatures.csv

CategoryMappings.csv

CategoryTypes.csv

CustomerGroupPrices.csv

CustomerGroupRules.csv

CustomerGroups.csv

Distributors.csv

DistributorStockAndPrices.csv

EANCodes.csv

Manufacturers.csv

Multimedia.csv

PriceTypes.csv

ProductCategories.csv

ProductChanges.csv

ProductContracts.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 product 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 TextMax length 255 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 512 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 Int32Nullable 43160000
TypeID Int32
Not nullable
1 Links to ID in file CategoryTypes.csv
MainImageURL TextMax length 512 chars

Nullable

http://images.icecat.biz
MetaTitle TextMax length 255 chars

Nullable

Can be used for SEO
MetaDescription Text
Max length unlimitedNullable
Can be used for SEO
Description TextMax length unlimited

Nullable

CategoryFeatures.csv

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

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 255 chars
Not nullable
Hard disk size
Order Int32
Not nullable
144 The order in which the filters are displayed.

CategoryMappings.csv

This file contains mappings between your product categories and standard stock in the channel categories.

Name Format Example Comments
CategoryID Int32
Not nullable
97 Links to ID in file Categories.csv
SinchCategoryID Int32
Not nullable
708 Stock in the Channel category ID

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

CustomerGroupPrices.csv

This file contains customer group specific prices

Name Format Example Comments
CustomerGroupID Int32
Not nullable
12 Links to ID in file CustomerGroups.csv
ProductID Int32
Not nullable
30974 Links to ID in file Products.csv
PriceTypeID Byte
Not nullable
1 Links to ID in file PriceTypes.csv
Price Decimal
Not nullable
18.039 Up to 4 decimal places

CustomerGroupRules.csv

This file contains any customer group rules you have set up.

Name Format Example Comments
ID Int32
Not nullable
12 Unique customer group 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 charsNullable
ABC123
CustomerGroupID Int32
Not nullable
1 Links to ID in file CustomerGroups.csv
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

CustomerGroups.csv

This file contains any customer groups you have created.

Name Format Example Comments
ID Int32
Not nullable
12 Unique customer group identifier
Name Text
Max length 30 chars
Not nullable
Education

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
TechData
Website Text
Max length 255 charsNot nullable
http://www.techdata.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 charsNot nullable
ABC123
DistributorCategory Text
Max length 100 chars
Nullable
Camcorders
ETA DateNullable 2012-01-01
BrandSKU Text
Max length 255 chars
Not nullable
ABC123

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 TextMax length 14 chars

Not nullable

06605430097021

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 TextMax length 255 chars

Not nullable

Acer
ThumbImageURL TextMax length 512 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 charsNot nullable
1
URL Text
Max length 512 charsNot nullable
http://www.someurl.com/1.pdf
Type Text
Max length 255 charsNot nullable
application/pdf

PriceTypes.csv

This file contains possible price types i.e. standard, education etc.

Name Format Example Comments
ID Int32
Not nullable
12 Unique price type identifier
Name Text
Max length 50 chars
Not nullable
Education

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 for the last 7 days 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
Date Date
Not nullable
2012-01-01 Date change took place

ProductContracts.csv

This file contains any contract numbers you have uploaded for products.

Name Format Example Comments
ProductID Int32
Not nullable
12 Links to ID in file Products.csv
ContractNo Text
Max length 50 chars
Not nullable
ABC

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 TextMax length 512 chars

Not nullable

http://images.icecat.biz
ThumbImageURL TextMax 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 product identifier
SKU Text
Max length 255 chars
Not nullable
A3L791B02M-GRN
Name Text
Max length 255 charsNot nullable
Patch cable – RJ-45(M)
ManufacturerID Int32
Not nullable
30 Links to ID in Manufacturers.csv
MainImageURL Text
Max length 512 charsNullable
http://images.icecat.biz
ThumbImageURL Text
Max length 512 chars
Nullable
http://images.icecat.biz
Specifications Text
Max length unlimited
Nullable
<table class=”
Description Text
Max length unlimited
Nullable
What is a Category
SearchCache Text
Max length unlimited
Nullable
networking etworking
DescriptionType TextMax length 10 chars

Not nullable

Datasheet
MediumImageURL Text
Max length 512 chars
Nullable
http://images.icecat.biz
Title TextMax length 255 chars

Not nullable

Patch cable – RJ-45(M)
Weight DecimalNullable 123.46 Up to 4 decimal places
Family TextMax length 255 chars

Nullable

Aspire
Reviews Text
Max length 1000 chars
Iframe containing reviews
PDFURL TextMax length 255 chars

Nullable

ShortDescription Text
Max length 1000 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 100 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.