Walmart Marketplace Connector Reference
6 metrics38 dimensions
The Walmart Marketplace connector exposes 44 fields (6 metrics, 38 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Walmart Marketplace Fields
Walmart Marketplace Order fields
The Order report of the Walmart Marketplace connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customer_email_id | TEXT | Customer Email ID | The customer email ID |
| customer_order_id | TEXT | Customer Order ID | The customer order ID |
| line_item__currency | TEXT | Line Item Currency | The currency |
| line_item__item_price | NUMERIC | Line Item Item Price | The price of the item |
| line_item__item_quantity | NUMERIC | Line Item Item Quantity | The item quantity |
| line_item__line_number | TEXT | Line Item Line Number | The line number |
| line_item__name | TEXT | Line Item Product Name | The product name |
| line_item__sales_tax | NUMERIC | Line Item Sales Tax | The sales tax |
| line_item__shipping_price | NUMERIC | Line Item Shipping Price | The shipping price |
| line_item__shipping_tax | NUMERIC | Line Item Shipping Tax | The shipping tax |
| line_item__sku | TEXT | Line Item SKU | The stock keeping unit |
| line_item__status | TEXT | Line Item Current Status | The status |
| line_item__subscription_discount | NUMERIC | Line Item Subscription Discount | The subscription discount |
| line_item__unit_of_quantity | TEXT | Line Ite Unit of Quantity | The item unit of quantity |
| order_date | DATE | Order Date | The date when the order was placed |
| order_type | TEXT | Order Type | The type of the order |
| original_customer_order_id | TEXT | Original Customer Order ID | The original customer order ID |
| postal_address_address1 | TEXT | Postal Address | The postal address |
| purchase_order_id | TEXT | Purchase Order ID | The purchase order ID |
| ship_node_type | TEXT | Ship Node Type | The fulfillment type (SellerFulfilled or WFSFulfilled) |
| shipping_estimated_delivery_date | DATE | Estimated Delivery Date | The estimated delivery date |
| shipping_estimated_ship_date | DATE | Estimated Ship Date | The estimated ship date |
| shipping_info_phone | TEXT | Shipping Info Phone Number | The phone number |
| shipping_method_code | TEXT | Shipping Method Code | The method code |
Walmart Marketplace other fields
The Walmart Marketplace connector has 20 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The account ID | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| 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 | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| 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_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| 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 |
