---
description: Walmart ETL connector for data replication
---

# Walmart\_v2

## Locate the API keys on seller dashboard

1. Log in to seller dashboard ([https://www.seller.walmart.com](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/](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>

\


#### 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>

\


#### 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>

\


#### 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/](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/](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/](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](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](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>

\


