New Payment & Invoice Detail tables

This week we updated our Vendor Central invoice payment table schema to simplify invoice management and reconciliation. Our Vendor Central customers could access the payments_coop table containing a summary of invoices, fees paid, and the associated agreements. This let you aggregate fees and invoices by time period, as an input to Net PPM (pure product margin). However, the summaries did not break down fee calculations or billing, making it difficult to deep dive charges by agreement type.

We launched six new detail tables to help:

TableContentsPeriod
payments_cost_variance_distributor_detailsASIN level details regarding specific CoOP deductions for accrual based agreements. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop)Weekly
payments_distributor_returns_detailsASIN level details regarding specific CoOP adjustments for returned inventory for accrual based agreements. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop)Weekly
payments_distributor_shipment_detailsASIN level details regarding specific CooP deductions for accrual based agreements. Weekly
payments_customer_shipment_detailsASIN level details regarding specific CoOP based on customer purchases like VPCs.. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop)Weekly
ASIN level details regarding specific CoOP based on customer purchases like VPCs.. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop) Specific for CoOP deductions for VPCs, this table shows the number of clipped coupons and clipped fees for any given invoice_id, invoice_date, and agreement_idWeekly
payments_invoice_virAdditional detail for VPCs including coupon_face_value and redemption_feesWeekly


How should I use this data?

When a vendor owes Amazon money, Amazon usually takes it as a deduction from invoice payments to the vendor. The most common of these are CoOp deductions, which are taken for agreements such as:

  • Standard Accrual - Sometimes called the Base Accrual, this is a flat percentage of COGS paid to Amazon for baseline marketing on the website.

  • Damage Allowance - Compensation for products damaged en route to Amazon, returned by customers, or otherwise rendered unsellable. Amazon prefers to handle disposal of these products instead of shipping them back to the vendor, and receives a % of COGS in return.

  • Freight Allowance - If Amazon pays for shipping into their fulfillment centers (We-Pay), they charge vendors a flat % of COGS as compensation.

  • Subscribe and Save - When vendors enroll products in Subscribe & Save, Amazon charges the vendor a fee for every subscription to fund promotional discounts.

  • Vendor Powered Coupons (VPCs) - When vendors create VPCs, Amazon charges the vendor a fee for every coupon clip and redemption.

The new granularity gives you the ability to deep dive invoices and fees by type. We recommend starting with the payments_coop table and joining invoice_id to the detail tables you need.

Joe Shao

Chief Product Officer, Reason Automation

Previous
Previous

Why Amazon Data Download Is So Hard for Businesses, and What To Do About It

Next
Next

Buy Box and Out of Stock metrics are available for Amazon Business