# Walmart ## Locate the API keys on seller dashboard 1. Log in to seller dashboard () 2. Click on **Settings** -> **API Key Management**
3\. Click on **Walmart Developer Portal**. You will be redirected to Walmart developer portal.
4\. Note down the **client ID** and **client secret** on **Production keys** tab. These will be used to create the integration in Daton.
## 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 |

Client ID

Client Secret

| | Replication Type |

Full Replication
Key Based Incremental

| | Replication Key | Date | | Suggested Replication Frequency | 1 hr | ## Walmart Tables ### On-Request Reports Source documentation: #### 1. ItemReportsOnRequest Purpose: To view all the information associated with your items that are set up on Walmart’s platform. Replication: Full load Replication key: NA #### Fields | Name | Datatype | | ------------------------------- | -------- | | ReportDateTime | DATETIME | | SKU | STRING | | Item\_ID | NUMERIC | | Product\_name | STRING | | Lifecycle\_Status | STRING | | Publish\_status | STRING | | Status\_Change\_Reason | STRING | | Product\_category | STRING | | Price | NUMERIC | | Currency | STRING | | Buy\_Box\_Item\_Price | NUMERIC | | Buy\_Box\_Shipping\_Price | NUMERIC | | MSRP | NUMERIC | | Product\_Tax\_Code | NUMERIC | | Ship\_Methods | STRING | | Shipping\_weight | NUMERIC | | Shipping\_weight\_Unit | STRING | | Fulfillment\_lag\_Time | NUMERIC | | Fulfillment\_Type | STRING | | WFS\_Sales\_restriction | STRING | | WPID | STRING | | GTIN | NUMERIC | | UPC | NUMERIC | | Item\_page\_URL | STRING | | Shelf\_name | STRING | | Primary\_category\_path | STRING | | Brand | STRING | | Offer\_start\_date | DATE | | Offer\_end\_date | DATE | | Item\_Creation\_date | DATE | | Item\_Last\_updated | DATE | | Reviews\_count | NUMERIC | | Average\_rating | NUMERIC | | Searchable\_\_ | STRING | | Competitor\_URL | STRING | | Competitor\_price | NUMERIC | | Competitor\_Ship\_Price | NUMERIC | | Competitor\_Last\_Date\_Fetched | DATE | #### 2. InventoryReportOnRequest Purpose: The report shows individual rows for each fulfillment center that holds inventory for that item. For example, if you have one item at four fulfillment centers, you will see 4 rows in the report for that item, each row for the corresponding fulfillment center (aka “ship node”). Replication: Full load Replication key: NA #### Fields | Name | Datatype | | --------------------- | -------- | | ReportDateTime | DATETIME | | SKU | STRING | | Item\_ID | NUMERIC | | Product\_Name | STRING | | Ship\_Node\_ID | NUMERIC | | Ship\_node\_name | STRING | | Input\_quality | STRING | | AvailToSell\_Quantity | NUMERIC | ### Pre-Generated Reports Source documentation: Frequency: Data loaded once in a day after 6am PST. #### 1. ItemReport Purpose: provides all information about a seller’s items that are currently set up on Walmart.com. Replication: Full load Replication: N/A #### Field name | Name | Datatype | | ------------------------------- | -------- | | ReportDate | DATE | | PARTNER\_ID | NUMERIC | | SKU | STRING | | PRODUCT\_NAME | STRING | | PRODUCT\_CATEGORY | STRING | | PRICE | NUMERIC | | CURRENCY | STRING | | BUY\_BOX\_ITEM\_PRICE | NUMERIC | | BUY\_BOX\_SHIPPING\_PRICE | NUMERIC | | PUBLISH\_STATUS | STRING | | STATUS\_CHANGE\_REASON | STRING | | LIFECYCLE\_STATUS | STRING | | INVENTORY\_COUNT | NUMERIC | | SHIP\_METHODS | STRING | | WPID | STRING | | ITEM\_ID | NUMERIC | | GTIN | NUMERIC | | UPC | NUMERIC | | PRIMARY\_IMAGE\_URL | STRING | | SHELF\_NAME | STRING | | PRIMARY\_CAT\_PATH | STRING | | OFFER\_START\_DATE | STRING | | OFFER\_END\_DATE | STRING | | ITEM\_CREATION\_DATE | STRING | | ITEM\_LAST\_UPDATED | STRING | | ITEM\_PAGE\_URL | STRING | | REVIEWS\_COUNT | NUMERIC | | AVERAGE\_RATING | NUMERIC | | SEARCHABLE\_\_ | STRING | | COMPETITOR\_URL | STRING | | COMPETITOR\_PRICE | NUMERIC | | COMPETITOR\_SHIP\_PRICE | NUMERIC | | COMPETITOR\_LAST\_DATE\_FETCHED | STRING | | BRAND | STRING | | PRODUCT\_TAX\_CODE | NUMERIC | | MSRP | NUMERIC | | SHIPPING\_WEIGHT | NUMERIC | | SHIPPING\_WEIGHT\_UNIT | STRING | | FULFILLMENT\_LAG\_TIME | NUMERIC | | FULFILLMENT\_TYPE | STRING | | WFS\_SALES\_RESTRICTION | STRING | #### 2. BuyBoxReport Purpose: provides buy box information about seller’s items. Replication: Full load Replication: N/A #### Fields | Name | Datatype | | -------------------- | -------- | | ReportDate | DATE | | Seller\_Id | NUMERIC | | Sku | STRING | | Item\_ID | NUMERIC | | Product\_Name | STRING | | Product\_Category | STRING | | Seller\_Name | STRING | | Seller\_Item\_Price | NUMERIC | | Seller\_Ship\_Price | NUMERIC | | IsSellerBuyBoxWinner | STRING | | Buybox\_Seller\_ID | NUMERIC | | Buybox\_Item\_Price | NUMERIC | | Buybox\_Ship\_Price | NUMERIC | | Offer2\_Seller\_ID | NUMERIC | | Offer2\_Item\_Price | NUMERIC | | Offer2\_Ship\_Price | NUMERIC | | Offer3\_Seller\_ID | NUMERIC | | Offer3\_Item\_Price | NUMERIC | | Offer3\_Ship\_Price | NUMERIC | | Offer4\_Seller\_ID | NUMERIC | | Offer4\_Item\_Price | NUMERIC | | Offer4\_Ship\_Price | NUMERIC | #### 3. CAPReport Purpose: provides the CAP Item Opt-in file that helps sellers to get information about all items eligible for Competitive price adjustments. Replication type: Full load Replication key: N/A #### Fields | Datatype | | | ------------- | ------- | | ReportDate | DATE | | PARTNER\_ID | NUMERIC | | SKU | STRING | | SKU\_OPT\_IN | STRING | | PRODUCT\_NAME | STRING | | CURRENCY | STRING | | PRICE | STRING | | SHIP\_PRICE | STRING | #### 4. ItemPerformanceReport Purpose: provides insights into performance data of seller’s catalog. Replication type: Full load #### Fields | Name | Datatype | | ---------------------- | -------- | | ReportDate | DATE | | Product\_Name | STRING | | Item\_ID | NUMERIC | | SKU\_ID | STRING | | Super\_Department | STRING | | Department | STRING | | Category | STRING | | Sub\_Category | STRING | | Brand | STRING | | GMV | NUMERIC | | Commission | NUMERIC | | GMV\_Dash\_Commission | NUMERIC | | AUR | NUMERIC | | Total\_Units\_Sold | NUMERIC | | Cancelled\_Units | NUMERIC | | Cancelled\_Sales | NUMERIC | | Item\_Conversion\_Rate | NUMERIC | | Base\_Item\_Id | NUMERIC | | Total\_Product\_Visits | NUMERIC | | GMV\_Comp\_\_Percent | NUMERIC | | Authorized\_Orders | NUMERIC | | Authorized\_Units | NUMERIC | | Authorized\_Sales | NUMERIC | | Total\_LY\_GMV | NUMERIC | #### 5. PromotionsReport Purpose: provides all active and future promotions of seller. Replication type: Full load #### Fields | Name | Datatype | | --------------------------- | -------- | | ReportDate | DATE | | 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 | | ----------------- | -------- | | ReportDate | DATE | | 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 | | ---------------------- | --------- | | ReportDate | DATE | | 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 | | ----------------------------------- | --------- | | ReportDate | DATE | | partnerId | NUMERIC | | SKU | STRING | | Keep\_It | STRING | | Return\_Restricted | STRING | | Restriction\_Reason | STRING | | Return\_Center\_Brace\_Alias\_Brace | STRING | #### 9. ReconciliationReport Purpose: Lists all payment and order reconciliation for a specific date for seller. Replication type: Full load #### Fields | Name | Data Type | | -------------------------------------------------- | --------- | | ReportDate | DATE | | Walmart\_dot\_com\_Order\_\_hash | NUMERIC | | Walmart\_dot\_com\_Order\_Line\_\_hash | NUMERIC | | Walmart\_dot\_com\_PO\_\_hash | NUMERIC | | Walmart\_dot\_com\_P\_dot\_O\_dot\_\_Line\_\_hash | NUMERIC | | Partner\_Order\_\_hash | STRING | | Transaction\_Type | STRING | | Transaction\_Date\_Time | STRING | | Shipped\_Qty | NUMERIC | | Partner\_Item\_ID | STRING | | Partner\_GTIN | NUMERIC | | Partner\_Item\_name | STRING | | Product\_tax\_code | NUMERIC | | Shipping\_tax\_code | STRING | | Gift\_wrap\_tax\_code | STRING | | Ship\_to\_state | STRING | | Ship\_to\_county | STRING | | County\_Code | STRING | | Ship\_to\_city | STRING | | Zip\_code | NUMERIC | | shipping\_Underscore\_method | STRING | | Total\_tender\_to\_\_slash\_\_from\_customer | NUMERIC | | Payable\_to\_Partner\_from\_Sale | NUMERIC | | Commission\_from\_Sale | NUMERIC | | Commission\_Rate | NUMERIC | | Gross\_Sales\_Revenue | NUMERIC | | Refunded\_Retail\_Sales | NUMERIC | | Sales\_refund\_for\_Escalation | NUMERIC | | Gross\_Shipping\_Revenue | NUMERIC | | Gross\_Shipping\_Refunded | NUMERIC | | Shipping\_refund\_for\_Escalation | NUMERIC | | Net\_Shipping\_Revenue | NUMERIC | | Gross\_Fee\_Revenue | NUMERIC | | Gross\_Fee\_Refunded | NUMERIC | | Fee\_refund\_for\_Escalation | NUMERIC | | Net\_Fee\_Revenue | NUMERIC | | Gift\_Wrap\_Quantity | NUMERIC | | Gross\_Gift\_Dash\_Wrap\_Revenue | NUMERIC | | Gross\_Gift\_Dash\_Wrap\_Refunded | NUMERIC | | Gift\_wrap\_refund\_for\_Escalation | NUMERIC | | Net\_Gift\_Wrap\_Revenue | NUMERIC | | Tax\_on\_Sales\_Revenue | NUMERIC | | Tax\_on\_Shipping\_Revenue | NUMERIC | | Tax\_on\_Gift\_Dash\_Wrap\_Revenue | NUMERIC | | Tax\_on\_Fee\_Revenue | NUMERIC | | Effective\_tax\_rate | NUMERIC | | Tax\_on\_Refunded\_Sales | NUMERIC | | Tax\_on\_Shipping\_Refund | NUMERIC | | Tax\_on\_Gift\_Dash\_Wrap\_Refund | NUMERIC | | Tax\_on\_Fee\_Refund | NUMERIC | | Tax\_on\_Sales\_refund\_for\_Escalation | NUMERIC | | Tax\_on\_Shipping\_Refund\_for\_Escalation | NUMERIC | | Tax\_on\_Gift\_Dash\_Wrap\_Refund\_for\_escalation | NUMERIC | | Tax\_on\_Fee\_Refund\_for\_escalation | NUMERIC | | Total\_NET\_Tax\_Collected | NUMERIC | | Tax\_Withheld | STRING | | Adjustment\_Description | STRING | | Adjustment\_Code | STRING | | Original\_Item\_price | STRING | | Original\_Commission\_Amount | STRING | | Product\_Type | STRING | | Spec\_Category | STRING | | Contract\_Category | STRING | | Flex\_Commission\_Rule | STRING | | Return\_Reason\_Code | STRING | | Return\_Reason\_Description | STRING | | Fee\_Withheld\_Flag | STRING | | Fulfillment\_Type | STRING | ### Insights Source documentation: Frequency: hourly #### 1. UnpublishedItemsReport Purpose: Get insights into why your items are getting unpublished with Unpublished Items APIs. Find out reasons why items got unpublished and republish them. Find out what is the total cost of all items unpublished for a specific reason Replication type: Incremental Replication key: #### Fields | Name | Data Type | | ---------------- | --------- | | gtin | STRING | | marketPrice | RECORD | | offerStartDate | DATE | | marketTrending | STRING | | lifecycleStatus | STRING | | unpublishReasons | STRING | | conversionRate | NUMERIC | | productName | STRING | | gmvAmount | RECORD | | itemId | NUMERIC | | customerRating | STRING | | pageViews | NUMERIC | | price | RECORD | | unpublishedDate | DATE | | brand | STRING | | sku | STRING | | productType | STRING | | offerEndDate | DATE | | publishStatus | STRING | #### 2. TopTrendingItemsReport Purpose: Using the Trending Items API to discover what items are currently trending best sellers at Walmart. Replication type: Incremental Replication key: #### Fields | Name | Data Type | | ------------------- | --------- | | ReportDate | DATE | | DepartmentId | NUMERIC | | TimeFrame | NUMERIC | | departmentName | STRING | | isbn | STRING | | categoryName | STRING | | productName | STRING | | subCategoryName | STRING | | isTwoDayEligible | NUMERIC | | itemId | STRING | | totalOffers | NUMERIC | | issn | STRING | | superDepartmentName | STRING | | existsForSeller | NUMERIC | | rank | NUMERIC | | brand | STRING | ### Raw Tables #### 1. Orders Source documentation: Frequency: hourly Replication type: Incremental Replication key: OrderDate #### Fields | 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: 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: 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: 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 | Field name | Type | | ---------- | ------ | | sku | STRING | | shipNodes | RECORD |