Sorry, we don't support your browser.  Install a modern browser

Vendor Orders (purchaseOrders) report for the Amazon Vendor connector#2036

Subscribe to updates
A

Hello Windsor team,

we use your Amazon Vendor connector for our Vendor Central accounts in the EU (DE, ES, FR, IT). The existing reports work well for us: sales, inventory, traffic, forecasting and margin.

What we are missing is the individual purchase orders that Amazon places with us. We currently fetch them directly from the SP-API for our daily PO tracking, and we would like to have them in Windsor as well, so that we have a second, independent way to get them. Could you add the following as a new report?

Endpoint

Vendor Orders API v1, operation getPurchaseOrders

GET /vendor/orders/v1/purchaseOrders (EU endpoint: sellingpartnerapi-eu.amazon.com)

Fields we need

Paths relative to payload.orders[]:

FieldPath
PO numberpurchaseOrderNumber
PO statepurchaseOrderState (New, Acknowledged, Closed)
Order dateorderDetails.purchaseOrderDate
Order typeorderDetails.purchaseOrderType
Last changeorderDetails.purchaseOrderChangedDate, orderDetails.purchaseOrderStateChangedDate
Vendor codeorderDetails.sellingParty.partyId
Fulfillment centerorderDetails.shipToParty.partyId
Ship and delivery windoworderDetails.shipWindow, orderDetails.deliveryWindow
Line numberorderDetails.items[].itemSequenceNumber
ASINorderDetails.items[].amazonProductIdentifier
Vendor SKUorderDetails.items[].vendorProductIdentifier
QuantityorderDetails.items[].orderedQuantity.amount, .unitOfMeasure, .unitSize
Net costorderDetails.items[].netCost.amount, .currencyCode
List priceorderDetails.items[].listPrice.amount, .currencyCode

How we would like the data

  • One row per PO line item, with the PO level fields (number, state, dates, vendor code, fulfillment center) repeated on each row.
  • All three states (New, Acknowledged, Closed), so we can follow a PO through its life cycle.
  • All vendor codes of the account. We have several per marketplace, for example 948V5, 94B3S and B00034 for Germany, and need to tell them apart via sellingParty.partyId.
  • Date range based on createdAfter / createdBefore. If possible also on changedAfter, so that state changes of older POs are picked up.
  • Freshness: new POs should appear the same day. A refresh several times a day would be ideal.

Our questions

  1. Is this something you can add to the Amazon Vendor connector?
  2. If yes, what would the timeline be, and does it change our pricing?
  3. Does your Amazon app need an additional SP-API role for the Vendor Orders API? If so, please tell us whether we have to re-authorize the connector on our side.

Our account is registered on the Standard plan.

Thank you, we look forward to hearing from you.

Best regards
Andreas Schmidt

2 hours ago
Request feature