There are some vendors that are still in the process of getting EDI certification since the transition of the Golfsmith EDI to Golf Town EDI connection on August 25, 2017. While the processing of purchase orders need to be manual for these vendors until their EDI connection become functional, vendor such as Under Armour (UNDERA) requested for purchase orders to be submitted to them in mass Excel data extract format so that they can upload the orders more easily on their end.
Attached are two files:
- SQL query that can be run to extract the purchase order data fields required by Under Armour. The query can be easily modified to serve other purposes or vendors related to purchase orders.
- Sample query result