Overview
The market list import allows for the creation of the market list through load - as opposed to creating market lists, adding products, labelling, and sequencing through the Purchasing (formerly known as Trade Simple) web interface.
The market list import file is comprised of 3 segments:
- Header – Creates the header record for the market list
- Label – Allows for segmentation of market list categories
- Product – Specifies the products that are to be imported into the market list
A full list of articles covering the creation of other CSV files that can be loaded to Purchasing can be found here P2P&I - Purchase to Pay CSV Specification - Contents Page
Format
Header:
Field |
M/O |
Column |
Notes |
|
Record Type |
M |
A |
Always equal to “H” |
|
Market List Name |
M |
B |
Name to identify the market list |
|
Market List Code |
M |
C |
Unique code to identify the market list |
Label:
Field |
M/O |
Column |
Notes |
|
Record Type |
M |
A |
Always equal to “L” |
|
Label Description |
M |
B |
Label name to identify the categorisation |
Product:
Field |
M/O |
Column |
Notes |
|
Record Type |
M |
A |
Always equal to “P” |
|
{blank} |
M |
B |
Always empty |
|
Supplier Code |
M |
C |
Your code for the supplier |
|
{blank} |
M |
D |
Always empty |
|
Supplier Product Code |
M |
E |
Supplier code for the product |
|
Custom description |
O |
F |
Custom description for the product |
|
Default Quantity |
O |
G |
Default quantity for product on the market list |
Example
H,FULL LIST,ZFULL
L,BAKING TRAYS
P,,CZEN01,,L138BDH20,,
P,,CZEN01,,L138BP12,,
P,,CZEN01,,L138BRD520,,
P,,CZEN01,,L138BS12,,
L,BAR MEASURES & POURERS
P,,CZEN01,,G725BPT,,
L,BOTTLE OPENERS & RESEALERS
P,,CZEN01,,5F11WRV,,
P,,CZEN01,,5F11WRVS,,
L,CHOPPING BOARDS
P,,CZEN01,,L149CBNB18,,
P,,CZEN01,,L149CBNBR18,,
P,,CZEN01,,L149CBNG18,,
Comments
0 comments
Please sign in to leave a comment.