Export Retail Procurement Orders from Amazon Vendor Central
This task will export retail procurement purchase orders from Amazon Vendor Central, in XML format.
Settings
Amazon Region
Required
Select which Amazon region you want to send data to or receive data from. If you need data for more than one region, you will need to add a separate copy of the task to your workflow for each region.
Amazon Vendor Central Connection
Required
The Amazon Vendor Central Connection to use. See the Amazon Vendor Central Connection article if you require more information on how to create/manage connections.
Export Settings -> Date Created
Required
When the 'Export Modified, New or All Records' setting is set to 'New', only records created after this date will be exported. This date will update automatically each time the task runs.
Export Settings -> Date Modified
Required
When the 'Export Modified, New or All Records' setting is set to 'Modified', only records updated after this date will be exported. This date will update automatically each time the task runs.
Export Settings -> Export Modified, New or All
Required
Choose which records should be included in the export. The available options are:
- New - Only records created since the date specified in the 'Date Created' setting will be exported.
- Modified - Only records modified since the date specified in the 'Date Modified' setting will be exported.
- All - Records will not be filtered based on date created or modified.
Ordering Vendor Code
Optional
Filter purchase orders for a specific ordering vendor code. This corresponds to the SellingParty/PartyId
value shown in the output file. If left blank, the task will return purchase orders for all vendor codes that exist in the vendor group used to authorise the connection to Amazon.
Page Size
Required
The maximum number of records to fetch per call to the Amazon Vendor Central API. Must be between 1 and 100.
Purchase Order Numbers
Optional
Specify one or more purchase order numbers to export data relating to specific purchase orders. If you do this, please note that it will override all other export settings.
You can specify the list of purchase order numbers either as a comma separated list, or via the 'List' Zynk Object type.
Purchase Order State
Optional
Filter purchase orders based on the purchase order state. If left blank, the task will return purchase orders of any state. The valid values for this setting are listed below:
- New
- Acknowledged
- Closed
We recommend using this setting to export 'new' purchase orders from Amazon, and then acknowledge them via the Import Retail Procurement Order Acknowledgements into Amazon Vendor Central task once they have been processed successfully.
Output File
Required
The file to save the exported records to. A sample output file is shown below.
Zynk Settings
Examples
A sample output file is shown below:
<?xml version="1.0" encoding="utf-8"?>
<Orders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Order>
<PurchaseOrderState>Closed</PurchaseOrderState>
<PurchaseOrderNumber>4Z32PABC</PurchaseOrderNumber>
<OrderDetails>
<PurchaseOrderType>RegularOrder</PurchaseOrderType>
<PaymentMethod>Invoice</PaymentMethod>
<PurchaseOrderDate>2019-07-26T11:10:00Z</PurchaseOrderDate>
<PurchaseOrderChangedDate xsi:nil="true" />
<PurchaseOrderStateChangedDate>2019-08-25T19:29:23Z</PurchaseOrderStateChangedDate>
<BuyingParty>
<PartyId>ABCD</PartyId>
</BuyingParty>
<SellingParty>
<PartyId>999US</PartyId>
</SellingParty>
<ShipToParty>
<PartyId>ABCD</PartyId>
</ShipToParty>
<BillToParty>
<PartyId>ABCD</PartyId>
</BillToParty>
<ShipWindow>2019-07-26T07:00:00Z--2019-08-03T07:00:00Z</ShipWindow>
<Items>
<OrderItem>
<ItemSequenceNumber>1</ItemSequenceNumber>
<AmazonProductIdentifier>B0748G1ABC</AmazonProductIdentifier>
<VendorProductIdentifier>0017817748000</VendorProductIdentifier>
<OrderedQuantity>
<UnitOfMeasure>Eaches</UnitOfMeasure>
<Amount>37</Amount>
<UnitSize>1</UnitSize>
</OrderedQuantity>
<IsBackOrderAllowed>false</IsBackOrderAllowed>
<NetCost>
<CurrencyCode>USD</CurrencyCode>
<Amount>140</Amount>
<UnitOfMeasure>KILOGRAMS</UnitOfMeasure>
</NetCost>
<ListPrice>
<CurrencyCode>USD</CurrencyCode>
<Amount>140</Amount>
<UnitOfMeasure>KILOGRAMS</UnitOfMeasure>
</ListPrice>
</OrderItem>
<OrderItem>
<ItemSequenceNumber>2</ItemSequenceNumber>
<AmazonProductIdentifier>B0748JMABC</AmazonProductIdentifier>
<VendorProductIdentifier>0015217748000</VendorProductIdentifier>
<OrderedQuantity>
<UnitOfMeasure>Eaches</UnitOfMeasure>
<Amount>24</Amount>
<UnitSize>1</UnitSize>
</OrderedQuantity>
<IsBackOrderAllowed>false</IsBackOrderAllowed>
<NetCost>
<CurrencyCode>USD</CurrencyCode>
<Amount>15.62</Amount>
</NetCost>
<ListPrice>
<CurrencyCode>USD</CurrencyCode>
<Amount>15.62</Amount>
</ListPrice>
</OrderItem>
<OrderItem>
<ItemSequenceNumber>3</ItemSequenceNumber>
<AmazonProductIdentifier>B076SDSABC</AmazonProductIdentifier>
<VendorProductIdentifier>0017817755000</VendorProductIdentifier>
<OrderedQuantity>
<UnitOfMeasure>Eaches</UnitOfMeasure>
<Amount>1</Amount>
<UnitSize>1</UnitSize>
</OrderedQuantity>
<IsBackOrderAllowed>false</IsBackOrderAllowed>
<NetCost>
<CurrencyCode>USD</CurrencyCode>
<Amount>110</Amount>
</NetCost>
<ListPrice>
<CurrencyCode>USD</CurrencyCode>
<Amount>110</Amount>
</ListPrice>
</OrderItem>
</Items>
</OrderDetails>
</Order>
</Orders>