Extol

1
Extol

• Steps to automating purchase orders

February 12, 2007
2
What type of file is needed?

• Dot can accept files in the following formats,
  CSV, fixed length, xml, EDI
• A simple fixed length text file would look
  similar to this
• 000113223200708020000391MCS 7600270000587333
  buyer_at_fakeemail.com 12/32OZ
  POTATO AUGRATIN HBH 140102
• 000213223200708020000391MCS 7600350000510802
  buyer_at_fakeemail.com 6CT CARROT
  CAKE HBH 150219
• 000313223200708020000391MCS 7600850001591230
  buyer_at_fakeemail.com 5/3 PORK
  ROAST BBQ HBH 120134
• This file has everything Dot would need to accept
  the order.

3
Details Needed in Flat File

• Po number
• Requested delivery date
• Delivery location (if you only have onethis is
  not necessary)
• Whether it is a pickup or delivery (if you don't
  pick up from usthis is not necessary either)
• Qty ordered
• Unit of measure (if available)
• Your item number
• One other number such as Dot item, mfg or
  UPCwhichever you carry in your system
• Item description

4
Extra Details

• Any Extra details that you would like in your
  file are fine to add.
• If you want a notification to go to specific
  buyers, then you can include their email address.
  If you just want the notifications to go to a set
  email address (can be multiple), there is no need
  to send it, I can just hard code it in for
  you.--When the p.o. is accepted through our
  software, the Dot system will send an email
  message that we received the p.o.

5
How the POs get to Dot

• We will set up a folder on our server that you
  would be able to FTP your orders directly into
  from your system (if you wanted to copy and paste
  you can too...we have one distributor who chose
  to do that)
• All Po's can be in one file if you want, or
  you can send a separate file for each PO...we
  don't care which.

6
Contact Info

• For any questions on this or to begin working on
  the automation of your POs, please contact
• Sean Ketcham
• EC Coordinator
• Dot Foods
• Phone Tues, Thurs, Fri 217-773-4486 ext. 2428
• Phone Mon, Wed 309-338-5724
• Fax [phone]
• sketcham_at_dotfoods.com