Partners can look up available Marketplace reconciliation reports dates by partner ID and download Marketplace reconciliation reports by partner ID and report date.
To download the reconciliation report for a specific date, call GET v3/report/reconreport/reconFile (e.g. https://marketplace.walmartapis.com/v3/report/reconreport/reconFile?reportDate={reportDate}).
List all Reconciliation Report Dates
To get a list of all available reconciliation report dates for a seller, call GET v3/report/reconreport/availableReconFiles.
What’s in the Recon Report CSV file?
The Item Report is returned in a .CSV file, with report name listed in content-disposition header, (e.g. filename=10000000354_2016-01-15T23:09:54.438+0000.zip). Your Partner ID is attached to report as a prefix, (e.g. 10000000354) followed by file generation timestamp.
The .csv file returned in the API response contains this information:
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 |