Uploading Order Status Information From File Import

Back

• Print
• Email article

Issue:

You would like to batch import your order tracking information using SAGE Supplier Center.

Solution:

If you do not already have the SAGE Supplier Center installed, see How to Access SAGE Supplier Center.


Using the SAGE Supplier Center to upload information

SAGE Supplier Center includes an upload feature that allows you to upload an XML file in "batch" mode to our system.  For example, if you have an external system such as your accounting or order management software that contains tracking information, you can build a script to export that information to a text file for uploading on a routine basis.  Note that it is preferable to use the Supplier Direct Connect if possible since that provides real-time information and can be automated so that you do not have to upload the file manually (See SAGE Connect Developer's Guide for more information). 


XML File Format


<?xml version="1.0"?>
<OrderTrackingUpload>
      <RequestVersion>1.1</RequestVersion>
      <UserInfo>
            <AcctID>ACCOUNT ID</AcctID>
            <LoginID>LOGIN ID (See below for user setup information)</LoginID>
            <Password>PASSWORD</Password>
            <SAGENum>YOUR SUPPLIER SAGE #</SAGENum>
      </UserInfo>
      <StatusPacket>
            <TimeStamp>Date and time in your local time zone - form MM/DD/YYYY HH:MM:SS AM/PM</TimeStamp>
            <InternalID>Your unique internal ID for this status packet (optional)</InternalID>
            <CustomerNumber>Your customer number for the distributor</CustomerNumber>
            <CustomerName>Customer's company name</CustomerName>
            <CustomerPhone>Customer's company phone</CustomerPhone>
            <OrderNumber>Your order number for this order</OrderNumber>
            <PONumber>Distributor's purchase order number (optional)</PONumber>
            <ExpectedShipDate>Expected ship date (optional)</ExpectedShipDate>
            <StatusID>Status ID (see below)</StatusID>
            <Comments>Detailed comments</Comments>
            <ShipCarrier>Shipping carrier - see chart below (for shipments only)</ShipCarrier>
            <ShipTrackingNumber>Tracking number (for shipments only)</ShipTrackingNumber>
            <Delete>See below (optional)</Delete>
      </StatusPacket>
       .... [You can include as many status packets as you want in the same XML request]...
</OrderTrackingUpload>


Notes:

1.  ALL fields are required except where "optional" is indicated.

2. The following status ID fields are permitted:

1 Pending
2 Accepted
3 In Production
4 On Hold
5 Proof Hold
6 Complete
7 Shipped
8 Partial Ship
9 Ready for Pickup
10 In Storage
11 Canceled
12 Back Ordered
999 Other

3.  The shipping carrier code should be FDX=FedEx, UPS=UPS, USPS=US Postal Service, or DHL=DHL.  Only include the shipping carrier if the status record is a shipment.

4.  You should set up a specific user in SAGEmember.com with XML API access only to be used for this purpose.  We strongly recommend NOT using your main administration password.  In either case, it is imperative that you keep your user name and password secure.

5.  If you want to delete a specific status event, send the Delete tag in the request with a value of "1".  Note that a request to delete MUST include either (a) the unique Internal ID or (b) the TimeStamp, Order Number, and Status (and the three fields must match the original request in order for the delete to succeed).  Other fields can be omitted in the delete request.

More Information:

Uploading Order Status Information

Back to list New search Print Copy Link Email article