Walmart_v2
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 | 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
Name | Datatype |
---|---|
Destinationstate | STRING |
orderplaceddt | STRING |
2. InventoryReport
Purpose: provides inventory information about seller’s items.
Replication: Full load
Fields
Name | Datatype |
---|---|
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
Name | Datatype |
---|---|
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
Name | Datatype |
---|---|
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
Name | Datatype |
---|---|
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