Skip to main content

Data Interface Requirements - Product Master

Judi Zietsman avatar
Written by Judi Zietsman
Updated over 3 months ago

Product Master

File name

master.csv

Importance

Required

Description

Basic product information

Criteria

One record for each unique product appearing in the Stock by Location data


Columns

Pos.

Name

Type

Importance

Description

1

Item Code

Char

Required

Product/SKU code.

2

Description

Char

Required

Product description.

3

NETSTOCK Unit of Measure

Char

Preferred

Main unit of measure used in Netstock (must be granular enough to avoid decimals). All stock-related quantities in all files must use this UOM.

4

Unit Volume

Decimal

If Applicable

Base volume per unit.

5

Unit Weight

Decimal

If Applicable

Base weight per unit.

6

Not used (Spare)

Char

Historically interpreted as “Superseded Item Code.” Use the supersessions.csv file instead.

7

Not used (Spare)

Char

Historically interpreted as “Superseded Item Factor.” Use the supersessions.csv file instead.

8

Not used (Spare)

Char

Currently not used.

9

Unique Identifier

Char

Required

A unique, stable system identifier for the product (does not change).


Forget about these 👇 😞 😐 😃 Have your say here!

Did this answer your question?