Table of expected data field definitions – General Merchandise_

Owned by Mary Volkmer (Unlicensed)
Dec 12, 2019
1 min read


Field #

Name

Max Size

Description

1

Update Type Code

2

"03" = Add/Update, "05" = Delete –
default is "03" if not present

2

Description

70

Item description

3

Image URL

128

URL of item image

4

Catalog Number

30

Required Field used in conjunction
with the vendor ID to identify the
SKU and Supplier's catalog number

5

Size

15

 

6

Color

20

 

7

Type

15

Specific to the item, eg. Fine Point

8

Package Type

3

 

9

Units per Package

4

Max 9999

10

Mfg's number

25

Manufacturer's part number

11

Cost

6

Currency format, max 999.99

12

Suggested Retail

6

Currency format, max 999.99

13

Currency Code

3

CAD or USD – default USD if not present

14

BarCode

12

Item Barcode