How to Export POs to Excel

Vendors have the ability to export PO information to Excel. All search fields require an exact match to be entered. You may use the "In the List" drop down for any query to search using multiple inputs, these must be entered using a comma and no spaces. Please review the below processes to action:

• Successfully log into Tradestone

• Under the 'Vendor Tools'  Section on the Dashboard select  'Export POs to Excel-Detail'

Enter Search Parameters:

• Vendor: Enter your URBN Vendor ID # (ex: 12345EU), this  must  be entered for data to populate.
• Channel: You may search for Omni, Direct or Retail POs. If left blank all POs will populate.
• Brand: You may select the Brand that issued the PO (Anthropologie EU, URBN EU, Free People). If left blank all POs will populate.
• Ship Date: The Cancel date listed on the PO is the last day the PO may arrive at the URBN DC. You may change the drop down to  'Greater than or Equal to'  and enter a date to populate all POs with a Cancel Date of the date you entered and in the future. If left blank all POs will populate.
• Vendor Status: You may select the PO Status, NEW will show POs not yet Accepted. ACCEPTED will populate the POs that have been Accepted in Tradestone. URBN REVISION will show all POs that have been revised and need to be re-accepted in Tradestone. If left blank all POs will populate.
• Vendor Colour: You may enter the Vendor Colour that is listed on the PO. If left blank all POs will populate.
• Vendor UPC: You may enter your Vendor UPC that is listed on the SKU. This must be an exact match, you may use the "In the List" drop down to search using multiple inputs, these must be entered using a comma and no spaces. If left blank all POs will populate.
• Vendor Style Number: You may enter your Vendor Style Number that is listed on the SKU. This must be an exact match, you may use the "In the List" drop down to search using multiple inputs, these must be entered using a comma and no spaces. If left blank all POs will populate.

This query will export the data by SKU with the following fields Purchase Order #, Design Source (Market or Ownbrand), Short SKU, Ship Mode, Deliver To Location, Place of Handover, Vendor Color, Ship Pack (Loose or Prepack), Received Qty, Origin Country (COO), Long SKU, Vendor UPC PO Status, Sell Channel, Last Revised Date, Vendor Style #, Style Description, IP Class, Brand, Total Units, Vendor Accept Date, Order Place Date, Pass to Vendor Date, Ship Date, Cancel Date, Vendor Status, Vendor Number, Vendor Name, Agent, Agent Description, FOB Currency, FOB Price & Size Description

Once all search parameters have been entered select 'Search'  then  'Export to Excel'. The Excel export will pop up in a separate window.