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

Single File CSV

This file can be used to import data without any technical knowledge in to your application of choice – such as shopping channels, CRM and ERP systems or even webstores. The most widely used file we produce is the relational tables which whilst more complex to import, contains more information and are more robust.

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 chars

Not 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 infinite chars
Nullable

5028253561456

Codes separated by spaces

SearchCache

Text
Max length infinite chars
Nullable

networking etworking

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=”…

CategoryName

Text

Max length 50 chars
Not nullable

Accounting Software

SubCategoryName

Text

Max length 50 chars
Nullable

Accounting Software

SubSubCategoryName

Text

Max length 50 chars
Nullable

Accounting Software

Description

Text
Max length infinite chars
Nullable

What is a Category

SearchFeature1

Text

Max length 50 chars
Nullable

Memory

SearchValue1

Text

Max length 50 chars
Nullable

2GB

SearchFeature2

Text

Max length 50 chars
Nullable

Memory

SearchValue2

Text

Max length 50 chars

Nullable

2GB

SearchFeature3

Text

Max length 50 chars
Nullable

Memory

SearchValue3

Text

Max length 50 chars
Nullable

2GB

SearchFeature4

Text

Max length 50 chars
Nullable

Memory

SearchValue4

Text

Max length 50 chars
Nullable

2GB

SearchFeature5

Text

Max length 50 chars
Nullable

Memory

SearchValue5

Text

Max length 50 chars
Nullable

2GB





SearchFeature6





Text

Max length 50 chars
Nullable





Memory

SearchValue6

Text

Max length 50 chars
Nullable

2GB

SearchFeature7

Text

Max length 50 chars
Nullable

Memory

SearchValue7

Text

Max length 50 chars
Nullable

2GB

SearchFeature8

Text

Max length 50 chars
Nullable

Memory

SearchValue8

Text

Max length 50 chars
Nullable

2GB

1stCheapestDistributorID

Int32

Not nullable

1

1stCheapestDistributorName

Text
Max length 255 chars
Not nullable

C2000

1stCheapestDistributorPrice

Decimal
Not nullable

18.04

Up to 4 decimal places

1stCheapestDistributorStock

Int32

Not nullable

1

1stCheapestDistributorProductName

Text
Max length 255 chars

Not nullable

Patch cable – RJ-45(M)

1stCheapestDistributorDeliveryCost

Decimal
Not nullable

18.04

Up to 4 decimal places

1stCheapestDistributorSKU

Text

Max length 100 chars
Not nullable

ABC123

2ndCheapestDistributorID

Int32

Not 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 255 chars

Not nullable

Patch cable – RJ-45(M)

2ndCheapestDistributorDeliveryCost

Decimal
Not nullable

18.04

Up to 4 decimal places

2ndCheapestDistributorSKU

Text

Max length 100 chars
Not nullable

ABC123

3rdCheapestDistributorID

Int32

Not 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 255 chars

Not nullable

Patch cable – RJ-45(M)

3rdCheapestDistributorDeliveryCost

Decimal
Not nullable

18.04

Up to 4 decimal places

3rdCheapestDistributorSKU

Text

Max length 100 chars
Not nullable

ABC123

4thCheapestDistributorID

Int32

Not 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 255 chars

Not nullable

Patch cable – RJ-45(M)

4thCheapestDistributorDeliveryCost

Decimal
Not nullable

18.04

Up to 4 decimal places

4thCheapestDistributorSKU

Text

Max length 100 chars
Not nullable

ABC123

5thCheapestDistributorID

Int32

Not 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 255 chars

Not nullable

Patch cable – RJ-45(M)

5thCheapestDistributorDeliveryCost

Decimal
Not nullable

18.04

Up to 4 decimal places

5thCheapestDistributorSKU

Text

Max length 100 chars
Not nullable

ABC123

UNSPSC

Int32

Nullable

43160000

CategoryID

Int32
Not nullable

870

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

DescriptionType

Text

Max length 10

Not nullable

Datasheet

 

Let us know if we missed anything...

Leave a Comment

You must be logged in to post a comment.