Walmart

Walmart ETL connector for data replication

Locate the API keys on seller dashboard

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

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

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: https://developer.walmart.com/doc/us/us-mp/us-mp-onrequestreports/

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: https://developer.walmart.com/doc/us/us-mp/us-mp-reports/

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

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: https://developer.walmart.com/doc/us/mp/us-mp-insights/

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: https://developer.walmart.com/doc/us/us-mp/us-mp-orders/

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