Export Formats

 

There are many formats available, the following are some examples of layouts in case your supplier can use them.

 

Generic Format

order code, number required,unit

603043,3.00,cs
512541,2.00,cs
634766,5.00,cs
33,1.00,cs
908018,3.00,cs
55224,2.00,cs

Centennial Food Services, Pratt's wholesale Canada

Order code, required

603043,3.00
512541,2.00
634766,5.00
33,1.00
908018,3.00
55224,2.00

Gordon Food Services - Shamrock Foods - Ben E Keiths

order code,number required, split no = 0 yes = 1

603043,3.00,0
512541,2.00,0
634766,5.00,0
33,1.00,0
908018,3.00,0
55224,2.00,0

US Foodservice

This format is specific to USFoodservice.  On Web site select St2 or import 2

0011220800032012000000002000000002            603043          0003000Sugar portion                 cs          Sugar port
0011220800032012000000002000000002            512541          0002000Straws 8 "                    cs          Straws 8 "
0011220800032012000000002000000002            634766          0005000Tea                           cs          Tea      
0011220800032012000000002000000002                33          0001000Bread Crumbs                  cs          Bread Crum
0011220800032012000000002000000002            908018          0003000Buns-Kaiser                   cs          Buns-Kaise
0011220800032012000000002000000002             55224          0002000Cheese-Feta                   cs          Cheese-Fet

Sysco Canada - contact your representative and make sure they enable transfers tab on your ordering site.

This format is specific to Sysco Canada

Customer number (9 space) purchase order number(9) (3 space) date(6) order code (9) order amount (3)

112208         000000002   032012603043   003  
112208         000000002   032012512541   002  
112208         000000002   032012634766   005  
112208         000000002   03201233       001  
112208         000000002   032012908018   003  
112208         000000002   03201255224    002  

Sysco US

HEcustomer number (fixed width 10) 12 spaces date mmddyyyyIO201

HEPurchase order number (10)

DTorder code (space) order amount

HD0000112208            03202012IO201
HE000000002-                   
DT603043 3
DT512541 2
DT634766 5
DT33 1
DT908018 3
DT55224 2

Performance Food Group  - PFG

You must putFSOR01_20120319_082849_XYZ.txt  you will provided a group code by your representative.  you must replace XYZ in the file name with the code given to you, then save,

Y

01000112208000000002      03/20/12                                                 
02000112208000000002      603043003000                        
02000112208000000002      512541002000                        
02000112208000000002      634766005000                        
02000112208000000002      000033001000                        
02000112208000000002      908018003000                        
02000112208000000002      055224002000