Walmart_v2

Walmart ETL connector for data replication

Locate the API keys on seller dashboard

  1. Log in to seller dashboard (https://www.seller.walmart.com)

  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

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

NameDatatype

Destinationstate

STRING

orderplaceddt

STRING

2. InventoryReport

Purpose: provides inventory information about seller’s items.

Replication: Full load

Fields

NameDatatype

sku

STRING

item_id

INTEGER

product_name

STRING

ship_node_id

NUMERIC

ship_node_name

STRING

input_quantity

INTEGER

availtosell_quantity

INTEGER

3. CancellationReport

Purpose: provides information about cancellation of items

Replication type: Full load

Fields

destinationstate

STRING

orderplaceddt

STRING

4. ItemPerformanceReport

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

Replication type: Full load

Fields

NameDatatype

brand

STRING

authorized_orders

INTEGER

authorized_sales

NUMERIC

category

STRING

item_conversion_rate

NUMERIC

commission

NUMERIC

super_department

STRING

total_ly_gmv

NUMERIC

authorized_units

INTEGER

department

STRING

cancelled_sales

NUMERIC

total_product_visits

INTEGER

gmv_commission

NUMERIC

aur

NUMERIC

gmv_comp__

NUMERIC

product_name

STRING

base_item_id

INTEGER

product_level_conversion_rate

NUMERIC

total_units_sold

INTEGER

cancelled_units

INTEGER

product_level_pageviews

INTEGER

refunded_sales

NUMERIC

gmv

NUMERIC

item_id

INTEGER

sku_id

STRING

sub_category

STRING

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

NameDatatype

period_start_date

STRING

period_end_date

STRING

total_payable

STRING

currency

STRING

transaction_key

STRING

transaction_posted_timestamp

STRING

transaction_type

STRING

transaction_description

STRING

customer_order__

STRING

customer_order_line__

STRING

purchase_order__

STRING

purchase_order_line__

STRING

amount

STRING

amount_type

STRING

ship_qty

STRING

commission_rate

STRING

transaction_reason_description

STRING

partner_item_id

STRING

partner_gtin

STRING

partner_item_name

STRING

product_tax_code

STRING

ship_to_state

STRING

ship_to_city

STRING

ship_to_zipcode

STRING

contract_category

STRING

product_type

STRING

commission_rule

STRING

shipping_method

STRING

fulfillment_type

STRING

fulfillment_details

STRING

original_commission

STRING

commission_incentive_program

STRING

commission_saving

STRING

customer_promo_type

STRING

campaign_id

STRING

reportdate

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

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

Field name

Type

sku

STRING

shipNodes

RECORD

offerId

STRING

5. ItemDetails

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

Replication type: Incremental

NameDatatype

itemid

STRING

ismarketplaceitem

BOOLEAN

images

RECORD

customerrating

STRING

freeshipping

BOOLEAN

offercount

NUMERIC

price

RECORD

description

STRING

title

STRING

brand

STRING

producttype

STRING

properties

RECORD

Last updated