> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/walmart-1.md).

# Walmart\_v2

## Locate the API keys on seller dashboard

1. Log in to seller dashboard (<https://www.seller.walmart.com>)&#x20;
2. Click on **Settings** -> **API Key Management**

<figure><img src="/files/LuGVOj8UQhB2ni8cegQK" alt=""><figcaption></figcaption></figure>

3\. Click on **Walmart Developer Portal**. You will be redirected to Walmart developer portal.

<figure><img src="/files/uUqbHhZ2QOZEv4ZmbolX" alt=""><figcaption></figcaption></figure>

4\. Note down the **client ID** and **client secret** on **Production keys** tab. These will be used to create the integration in Daton.

<figure><img src="/files/zU9ypgafvHmzHZDuieNs" alt=""><figcaption></figcaption></figure>

## Snapshot

| Features                        | Details                                          |
| ------------------------------- | ------------------------------------------------ |
| Release Status                  | Released                                         |
| Source API Version              | V3                                               |
| Table Selection                 | Yes                                              |
| Column Selection                | Yes                                              |
| Edit Integration                | Yes                                              |
| Replication Type Selection      | No                                               |
| Authentication Parameters       | <p>Client ID</p><p>Client Secret</p>             |
| Replication Type                | <p>Full Replication<br>Key Based Incremental</p> |
| Replication Key                 | Date                                             |
| Suggested Replication Frequency | 1 hr                                             |

## Walmart Tables

### Reports

Source documentation: <https://developer.walmart.com/doc/us/us-mp/us-mp-reports/>

Frequency: Data loaded once in a day after 6am PST.

#### 1. Delivery\_DefectReport

Purpose: provides all information about delivery defects

Replication: Full load

#### Field name

<table><thead><tr><th width="188">Name</th><th>Datatype</th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Destinationstate</td><td>STRING</td><td></td><td>REQUIRED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>orderplaceddt</td><td>STRING</td><td></td><td>REQUIRED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

<br>

#### 2. InventoryReport

Purpose: provides inventory information about seller’s items.

Replication: Full load

#### Fields

<table><thead><tr><th>Name</th><th>Datatype</th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>sku</td><td>STRING</td><td>sku</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>item_id</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>product_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ship_node_id</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ship_node_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>input_quantity</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>availtosell_quantity</td><td>INTEGER</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

<br>

#### 3. CancellationReport

Purpose: provides information about cancellation of items

Replication type: Full load

#### Fields

<table data-header-hidden><thead><tr><th>Name</th><th>Datatype</th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>destinationstate</td><td>STRING</td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>orderplaceddt</td><td>STRING</td><td>NUMERIC</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

#### 4. ItemPerformanceReport

Purpose: provides insights into performance data of seller’s catalog.

Replication type: Full load

#### Fields

<table><thead><tr><th>Name</th><th>Datatype</th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>brand</td><td>STRING</td><td>Level 1brand</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>authorized_orders</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>authorized_sales</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>category</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>item_conversion_rate</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>commission</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>super_department</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_ly_gmv</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>authorized_units</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>department</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>cancelled_sales</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_product_visits</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>gmv_commission</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>aur</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>gmv_comp__</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>product_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>base_item_id</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>product_level_conversion_rate</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_units_sold</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>cancelled_units</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>product_level_pageviews</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>refunded_sales</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>gmv</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>item_id</td><td>INTEGER</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>sku_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>sub_category</td><td>STRING</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

<br>

#### 5. PromoReport

Purpose: provides all active and future promotions of seller.

Replication type: Full load

#### Fields

| Name                        | Datatype |
| --------------------------- | -------- |
| Partner\_ID                 | NUMERIC  |
| SKU                         | STRING   |
| Item\_ID                    | STRING   |
| Product\_Name               | STRING   |
| Product\_Category           | STRING   |
| Promo\_ID                   | STRING   |
| Promo\_Effective\_Date      | STRING   |
| Promo\_Expiration\_Date     | STRING   |
| Current\_Price              | STRING   |
| Current\_Price\_Currency    | STRING   |
| Comparison\_Price           | STRING   |
| Comparison\_Price\_Currency | STRING   |
| Promo\_Type                 | STRING   |
| Promo\_Status               | STRING   |

#### 6. ShippingConfigurationReport

Purpose: provides SKU-level template configuration to node mapping for the seller.

Replication type: Full load

#### Fields

| Name              | Datatype |
| ----------------- | -------- |
| SKU               | STRING   |
| Item\_ID          | NUMERIC  |
| Product\_Name     | STRING   |
| Publish\_Status   | STRING   |
| Lifecycle\_Status | STRING   |
| Ship\_Node\_ID    | STRING   |
| Ship\_Node\_Name  | STRING   |
| Ship\_Node\_Type  | STRING   |
| Template\_ID      | STRING   |
| Template\_Name    | STRING   |
| Template\_Type    | STRING   |

#### 7. ShippingProgramReport

Purpose: Provides seller-specific details of SKU-level shipping-program.

Replication type: Full load

**Fields**

| Name                   | Data Type |
| ---------------------- | --------- |
| Product\_Name          | STRING    |
| Item\_ID               | NUMERIC   |
| SKU                    | STRING    |
| Publish\_Status        | STRING    |
| Lifecycle\_Status      | STRING    |
| Program\_Participation | STRING    |
| Template\_ID           | STRING    |
| Template\_Type         | STRING    |
| Coverage\_Areas        | STRING    |

#### 8. ReturnItemOverridesReport

Purpose: Provides the information of item level overrides for all seller’s items.

Replication type: Full load

#### Fields

| Name                                | Data Type |
| ----------------------------------- | --------- |
| partnerId                           | NUMERIC   |
| SKU                                 | STRING    |
| Keep\_It                            | STRING    |
| Return\_Restricted                  | STRING    |
| Restriction\_Reason                 | STRING    |
| Return\_Center\_Brace\_Alias\_Brace | STRING    |

#### 9. ReconReport

Purpose: Lists all payment and order reconciliation for a specific date for seller.

Replication type: Full load

#### Fields

<table><thead><tr><th>Name</th><th>Datatype</th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>period_start_date</td><td>STRING</td><td>Level 1period_start_date</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>period_end_date</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_payable</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>currency</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>transaction_key</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>transaction_posted_timestamp</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>transaction_type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>transaction_description</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>customer_order__</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>customer_order_line__</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>purchase_order__</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>purchase_order_line__</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>amount</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>amount_type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ship_qty</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>commission_rate</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>transaction_reason_description</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>partner_item_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>partner_gtin</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>partner_item_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>product_tax_code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ship_to_state</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ship_to_city</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ship_to_zipcode</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>contract_category</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>product_type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>commission_rule</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>shipping_method</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>fulfillment_type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>fulfillment_details</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>original_commission</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>commission_incentive_program</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>commission_saving</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>customer_promo_type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>campaign_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>reportdate</td><td>STRING</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Raw Tables

#### 1. Orders

Source documentation: <https://developer.walmart.com/doc/us/us-mp/us-mp-orders/>

Frequency: hourly

Replication type: Incremental

Replication key: OrderDate

#### Fields&#xD;

| Name            | Data Type |
| --------------- | --------- |
| shipNodeType    | STRING    |
| purchaseOrderId | NUMERIC   |
| customerOrderId | NUMERIC   |
| customerEmailId | STRING    |
| orderType       | STRING    |
| orderDate       | TIMESTAMP |
| shippingInfo    | RECORD    |
| orderLines      | RECORD    |
| shipNode        | RECORD    |

#### 2. Returns

Purpose: Retrieves the details of return orders for the specified filter criteria.

Source documentation: <https://developer.walmart.com/doc/us/mp/us-mp-returns/>

Replication type: Incremental

Replication key: ReturnOrderDate

#### Fields

| Name              | Data Type |
| ----------------- | --------- |
| returnOrderId     | NUMERIC   |
| customerEmailId   | STRING    |
| customerName      | RECORD    |
| customerOrderId   | NUMERIC   |
| returnOrderDate   | TIMESTAMP |
| returnByDate      | TIMESTAMP |
| refundMode        | STRING    |
| totalRefundAmount | RECORD    |
| returnLineGroups  | RECORD    |
| returnOrderLines  | RECORD    |
| returnChannel     | RECORD    |

#### 3. Inventory

Source documentation: <https://developer.walmart.com/doc/us/mp/us-mp-inventory/>

Purpose: This API will retrieve the inventory count for all of a seller's items across all ship nodes by item to ship node mapping. Inventory can be zero or non-zero.

ReplicationType: Full load

#### Fields

| Name  | Data Type |
| ----- | --------- |
| sku   | STRING    |
| nodes | RECORD    |

#### 4. WFSInventory

Source documentation: <https://developer.walmart.com/api/us/mp/inventory>

Purpose: You can use this API to get the current Available to Sell inventory quantities for all WFS items in your catalog.

Replication type: Incremental

Replication key: FromModifiedDate

#### Fields&#xD;

| Field name | Type   |
| ---------- | ------ |
| sku        | STRING |
| shipNodes  | RECORD |
| offerId    | STRING |

#### 5. ItemDetails

#### <https://developer.walmart.com/api/us/mp/items#operation/getSearchResult>

Purpose: You can use this API to get additional details about items

Replication type: Incremental

<table><thead><tr><th>Name</th><th>Datatype</th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>itemid</td><td>STRING</td><td>itemid</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ismarketplaceitem</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>images</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>customerrating</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>freeshipping</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>offercount</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>price</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>description</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>title</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>brand</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>producttype</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>properties</td><td>RECORD</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

<br>