Windsor brings all your Walmart Marketplace data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQLPower BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Walmart Marketplace Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The account ID | |
| customer_email_id | TEXT | Customer Email ID | The customer email ID | Order |
| customer_order_id | TEXT | Customer Order ID | The customer order ID | Order |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date | |
| day_of_month | TEXT | Day of month | Day of the month | |
| line_item__currency | TEXT | Line Item Currency | The currency | Order |
| line_item__item_price | NUMERIC | Line Item Item Price | The price of the item | Order |
| line_item__item_quantity | NUMERIC | Line Item Item Quantity | The item quantity | Order |
| line_item__line_number | TEXT | Line Item Line Number | The line number | Order |
| line_item__name | TEXT | Line Item Product Name | The product name | Order |
| line_item__sales_tax | NUMERIC | Line Item Sales Tax | The sales tax | Order |
| line_item__shipping_price | NUMERIC | Line Item Shipping Price | The shipping price | Order |
| line_item__shipping_tax | NUMERIC | Line Item Shipping Tax | The shipping tax | Order |
| line_item__sku | TEXT | Line Item SKU | The stock keeping unit | Order |
| line_item__status | TEXT | Line Item Current Status | The status | Order |
| line_item__subscription_discount | NUMERIC | Line Item Subscription Discount | The subscription discount | Order |
| line_item__unit_of_quantity | TEXT | Line Ite Unit of Quantity | The item unit of quantity | Order |
| month | TEXT | Month | Number of the month | |
| order_date | DATE | Order Date | The date when the order was placed | Order |
| order_type | TEXT | Order Type | The type of the order | Order |
| original_customer_order_id | TEXT | Original Customer Order ID | The original customer order ID | Order |
| postal_address_address1 | TEXT | Postal Address | The postal address | Order |
| purchase_order_id | TEXT | Purchase Order ID | The purchase order ID | Order |
| shipping_estimated_delivery_date | DATE | Estimated Delivery Date | The estimated delivery date | Order |
| shipping_estimated_ship_date | DATE | Estimated Ship Date | The estimated ship date | Order |
| shipping_info_phone | TEXT | Shipping Info Phone Number | The phone number | Order |
| shipping_method_code | TEXT | Shipping Method Code | The method code | Order |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |