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

Single File CSV

Single File CSV Definition

 

Overview

 

A single file will be generated for this export. It will 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 (“).

 

Products.csv

 

Products.csv

 

This file contains products which met the publish criteria you set in your price list configurator within Stock in the Channel and will contain the columns you chose. (The file generated may not contain columns in the same order).

 

Name Format Example Comments
ID Int32 Not nullable 1 Unique product identifier
SKU Text
Max length 255 chars
Not nullable
A3L791B02M-GRN
BrandName Text
Max length 255 chars
Not nullable
HP
Name Text
Max length 255 charsNot nullable
Patch cable – RJ-45(M)
Stock Int32 Not nullable 1
Price Decimal
Not nullable
18.04 Up to 4 decimal places
Cost Decimal
Not nullable
17.55 Up to 4 decimal places
EANCodes Text
Max length unlimited
Nullable
5028253561456 Codes separated by spaces
SearchCache Text
Max length unlimited
Nullable
networking etworking
MainImageURL Text
Max length 255 charsNullable
http://images.icecat.biz/
ThumbImageURL Text
Max length 255 charsNullable
http://images.icecat.biz/
Specifications Text
Max length unlimited
Nullable
<table class=”…
CategoryName TextMax length 255 chars
Not nullable
Accounting Software
SubCategoryName TextMax length 255 chars
Nullable
Accounting Software
SubSubCategoryName TextMax length 255 chars
Nullable
Accounting Software
Description Text
Max length unlimited
Nullable
What is a Category
SearchFeature1 TextMax length 20 chars
Nullable
Memory
SearchValue1 TextMax length 20 chars
Nullable
2GB
SearchFeature2 TextMax length 20 chars
Nullable
Memory
SearchValue2 TextMax length 20 chars
Nullable
2GB
SearchFeature3 TextMax length 20 chars
Nullable
Memory
SearchValue3 TextMax length 20 chars
Nullable
2GB
SearchFeature4 TextMax length 20 chars
Nullable
Memory
SearchValue4 TextMax length 20 chars
Nullable
2GB
SearchFeature5 TextMax length 20 chars
Nullable
Memory
SearchValue5 TextMax length 20 chars
Nullable
2GB
SearchFeature6 TextMax length 20 chars
Nullable


Memory
SearchValue6 TextMax length 20 chars
Nullable
2GB
SearchFeature7 TextMax length 20 chars
Nullable
Memory
SearchValue7 TextMax length 20 chars
Nullable
2GB
SearchFeature8 TextMax length 20 chars
Nullable
Memory
SearchValue8 TextMax length 20 chars
Nullable
2GB
1stCheapestDistributorID Int32Not nullable 1
1stCheapestDistributorName Text
Max length 255 chars
Not nullable
TechData
1stCheapestDistributorPrice Decimal
Not nullable
18.04 Up to 4 decimal places
1stCheapestDistributorStock Int32 Not nullable 1
1stCheapestDistributorProductName Text
Max length 100 charsNot nullable
Patch cable – RJ-45(M)
1stCheapestDistributorDeliveryCost Decimal
Not nullable
18.04 Up to 4 decimal places
1stCheapestDistributorSKU TextMax length 100 chars
Not nullable
ABC123
2ndCheapestDistributorID Int32Not nullable 1
2ndCheapestDistributorName Text
Max length 255 chars
Not nullable
C2000
2ndCheapestDistributorPrice Decimal
Not nullable
18.04 Up to 4 decimal places
2ndCheapestDistributorStock Int32 Not nullable 1
2ndCheapestDistributorProductName Text
Max length 100 charsNot nullable
Patch cable – RJ-45(M)
2ndCheapestDistributorDeliveryCost Decimal
Not nullable
18.04 Up to 4 decimal places
2ndCheapestDistributorSKU TextMax length 100 chars
Not nullable
ABC123
3rdCheapestDistributorID Int32Not nullable 1
3rdCheapestDistributorName Text
Max length 255 chars
Not nullable
C2000
3rdCheapestDistributorPrice Decimal
Not nullable
18.04 Up to 4 decimal places
3rdCheapestDistributorStock Int32 Not nullable 1
3rdCheapestDistributorProductName Text
Max length 100 charsNot nullable
Patch cable – RJ-45(M)
3rdCheapestDistributorDeliveryCost Decimal
Not nullable
18.04 Up to 4 decimal places
3rdCheapestDistributorSKU TextMax length 100 chars
Not nullable
ABC123
4thCheapestDistributorID Int32Not nullable 1
4thCheapestDistributorName Text
Max length 255 chars
Not nullable
C2000
4thCheapestDistributorPrice Decimal
Not nullable
18.04 Up to 4 decimal places
4thCheapestDistributorStock Int32 Not nullable 1
4thCheapestDistributorProductName Text
Max length 100 charsNot nullable
Patch cable – RJ-45(M)
4thCheapestDistributorDeliveryCost Decimal
Not nullable
18.04 Up to 4 decimal places
4thCheapestDistributorSKU TextMax length 100 chars
Not nullable
ABC123
5thCheapestDistributorID Int32Not nullable
5thCheapestDistributorName Text
Max length 255 chars
Not nullable
C2000
5thCheapestDistributorPrice Decimal
Not nullable
18.04 Up to 4 decimal places
5thCheapestDistributorStock Int32 Not nullable 1
5thCheapestDistributorProductName Text
Max length 100 charsNot nullable
Patch cable – RJ-45(M)
5thCheapestDistributorDeliveryCost Decimal
Not nullable
18.04 Up to 4 decimal places
5thCheapestDistributorSKU TextMax length 100 chars
Not nullable
ABC123
UNSPSC Int32Nullable 43160000
CategoryID Int32
Not nullable
870
Title TextMax length 255

Not nullable

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

Nullable

Aspire
Reviews Text
Max length 1000
Iframe containing reviews
DescriptionType TextMax length 10

Not nullable

Datasheet

Let us know if we missed anything...

Leave a Comment

You must be logged in to post a comment.