Pregenerated Reports

Sellers and partners can look up available Marketplace reconciliation reports available by date, and generate those reports to download with the Reconciliation Report APIs.

1. Call Get available recon report dates – generates a list of all available recon reports available for download.
2. Call Get Recon Report – specify the report date and download the report.

Step 1: Get a list of all available reconciliation report dates

To get a list of all available reconciliation reports, call Get available recon report dates API. For example:

/v3/report/reconreport/availableReconFiles

Step 2: Generate the Reconciliation report

To get the reconciliation report, call Get Recon Report API, and specify a date for reportDate parameter. For example:

/v3/report/reconreport/reconFile?reportDate=20201105

Step 3: Receive CSV download file

Upon success, the API call to generate the report will stream the data via CSV file with the field values.

Recon File Fields

Name	Description	Type
Walmart.com Order #	Walmart Order Number	String
Walmart.com Order Line #	Item number within the order	String
Walmart.com PO #	Purchase Order number	String
Walmart.com P.O. Line #	Item number within the Purchase Order	String
Partner Order #	Partner Order Number	String
Transaction Type	SALE: sale transaction REFUNDED: refund transaction ADJMNT: fees, corrections and adjustments which will appear as credits or debits	String
Transaction Date Time	Sales: when the shipment confirmation was received Refunds: when the return or refund was invoiced Adjustments: when the adjustment was issued	String
Shipped Qty	Shipped quantity	String
Partner Item ID	Partner’s Item ID	String
Partner GTIN	Partner’s GTIN #	String
Partner Item name	Partner’s item name	String
Product tax code	Item’s tax code, used to calculate sales tax on item	String
Shipping tax code	Item’s tax code, used to calculate sales tax on shipping (currently empty)	String
Gift wrap tax code	Item’s tax code, used to calculate sales tax on gift wrap (currently empty)	String
Ship to state	2 letter code of the state where the order was shipped; Sales transactions only	String
Ship to county	Code of county where item was shipped (currently empty)	String
County Code	Code of city where item was shipped (currently empty)	String
Ship to city	City where order was shipped; Sales transactions only	String
Zip code	Zip-code where order was shipped	String
shipping_method	Payment method used on the sale	String
Total tender to / from customer	Total amount received from/refunded to customer on sale/refund	String
Payable to Partner from Sale	Total amount paid to/recouped from partner on sale/refund	String
Commission from Sale	Referral fee paid to/recouped from Walmart on sale/refund	String
Commission Rate	Referral fee rate (%) on sale.	String
Gross Sales Revenue	Item price + shipping charge on sale; total amount subject to referral fee	String
Refunded Retail Sales	Refunded item price + shipping charge; refunds only	String
Sales refund for Escalation	This column has been retired and merged into col #26 (Refunded Retail Sales)	String
Gross Shipping Revenue	Shipping charge on sale	String
Gross Shipping Refunded	Shipping amount refunded	String
Shipping refund for Escalation	This column has been retired and merged into col #29 (Gross Shipping Refunded)	String
Net Shipping Revenue	Sum of shipping revenue on sales and refunds (col #28 + #29)	String
Gross Fee Revenue	Product fee collected from customers on sale	String
Gross Fee Refunded	Amount of product fee refunded	String
Fee refund for Escalation	This column has been retired and merged into col #33	String
Net Fee Revenue	Sum of fee revenue on sales and refunds (col #32 + #33)	String
Gift Wrap Quantity	Gift-Wrap quantity	String
Gross Gift-Wrap Revenue	Gift-Wrap charges collected from customer	String
Gross Gift-Wrap Refunded	Refunded amount on Gift-Wrap charges	String
Gift wrap refund for Escalation	This column has been retired and merged into col #38	String
Net Gift Wrap Revenue	Sum of gift-wrap revenue on sales and refunds (col #37 + #38)	String
Tax on Sales Revenue	Sales tax amount on item price	String
Tax on Shipping Revenue	Sales tax amount on shipping charge	String
Tax on Gift-Wrap Revenue	Sales tax amount on Gift-Wrap fee	String
Tax on Fee Revenue	Sales tax amount on Product Fee	String
Effective tax rate	Sales tax rate	String
Tax on Refunded Sales	Refunded tax amount on item price	String
Tax on Shipping Refund	Refunded tax amount on shipping charge	String
Tax on Gift-Wrap Refund	Refunded tax amount on Gift-Wrap charge	String
Tax on Fee Refund	Refunded tax amount on Product Fee	String
Tax on Sales refund for Escalation	This columnhas been retired and merged into col #46	String
Tax on Shipping Refund for Escalation	This columnhas been retired and merged into col #47	String
Tax on Gift-Wrap Refund for escalation	This columnhas been retired and merged into col #48	String
Tax on Fee Refund for escalation	This columnhas been retired and merged into col #49	String
Total NET Tax Collected	For sales: sum of cols #41-#44; Refunds: sum of cols #46-#49	String
Tax Withheld	Y: sales tax withheld by Walmart; N: sales tax included in payment (col #22)	String
Adjustment Description	Return/refund or adjustment description	String
Adjustment Code	Return/refund or adjustment code	String
Original Item price	Partner’s original item price before CAP program adjustment	String
Original Commission Amount	Referral fee amount before CAP program adjustment	String
Spec Category	Category provided by seller during ingestion	String
Contract Category	Contract Category for the item sold	String
Product Type	Product Type for the item sold	String
Flex Commission Rule	Dynamic commission rule ID (when applicable)	String
Return Reason Code	Customer given reason associated with refund/return	String
Return Reason Description	Customer given reason code associated with refund/return	String
Fee Withheld Flag	Y: product fee withheld by Walmart; N: product fee included in payment (col #22)	String
Fulfillment Type	Walmart Fulfilled(WFS) or Seller Fulfilled	String