# 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="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FifDBLNsPHO8iTyvuS1XF%2F1.png?alt=media&#x26;token=0c11dd38-52bb-4339-a71f-a62862590368" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FahGmuMgXnAXbRsELBufV%2F2.png?alt=media&#x26;token=6c11a4b4-b1f9-4268-a6ad-58bedf0a9bca" 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="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FaLCjjVMpte2C4tKBuRaG%2F3.png?alt=media&#x26;token=d55b99c7-a494-45ff-8e03-14868235c6e6" 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/walmart-1.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.