Walmart Data Connector User Guide
The following article is a guide to automating reports with your Walmart connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Walmart reports. To begin creating reports with your Walmart connector, you will need at least one Walmart account as well as access to Google Data Studio or Google Sheets.
Available Data
- Sales data by SKU and name - Measure quantity of items sold and returned. Calculate revenue.
- Breakdowns by Fulfillment Center
- Order breakdowns - Order times and dates, quantities, prices, tax, and shipping.
- Inventory reports - Data is available beginning on the first day you connect. Include Today in the date range to get the most recent inventory. Report inventory by SKU and Name. Display inventory count, price, rating, and number of reviews.
- Lifetime performance - List items by SKU, department, brand, and name, then compare Gross Merchandise Value (GMV), Average Unit Retail (AUR), total units sold, commission, canceled units sold, and canceled sales.
- Returns reporting - Returns over time, reasons, status, and charge totals.
- Reconciliation reports - Available 2-3 times per month.
- Complete List of Fields.
API Limitations
- Reconciliation reporting - These reports are available from the API 2-3 times per month. They are not yet available daily.
- Inventory - To get the most recent inventory, include Today in your date range. If Today is not included in the date range, the inventory shown will reflect the values of the last date in the set range.
- United States Only - Walmart has different APIs for Mexico and Canada. At this time, we only support the United States API.
- Custom fields - Custom fields are not available.
Connection Requirements
Connecting to Walmart is an involved process. See How to Connect to Walmart for complete instructions.
For a successful connection and accurate reports, we require view_only permission for Orders, Returns, Shipping, and Reports.
Backfilling
For most metrics, Walmart allows us to backfill 180 days (6 months) of data.
Exceptions:
- Inventory - Inventory is a live metric. We will begin to collect data the first time you create a report.
- Returns - All returns data can be backfilled up to 2 years from your Hub.
Troubleshooting
See our Troubleshooting Walmart article for all of the latest information on issues that may affect Walmart connectors.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Mailchimp Data Connector User Guide
The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating ...Taboola Data Connector User Guide
The following article is a guide to automating reports with your Taboola connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Taboola reports. To begin creating reports ...AdRoll Data Connector User Guide
The following is a guide to automating reports with your AdRoll connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your AdRoll reports. To begin creating reports with your ...eBay Data Connector User Guide
The following is a guide to automating reports with your eBay Seller connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your eBay Seller reports. To begin creating reports ...Quickbooks Data Connector User Guide
The following article is a guide for automating reports with your Quickbooks connector. It includes metrics available and things to know about the connector. To create a report, you will need access to at least one or more Quickbooks online accounts ...