Walmart Marketplace (Edge)

Walmart Marketplace is an online platform that allows approved third-party sellers to list and sell their products on Walmart.com. It enables sellers to manage their item catalog, inventory, pricing, orders, returns, and fulfillment, including Walmart Fulfillment Services (WFS).

Hevo uses the Walmart Marketplace Seller APIs to replicate data from your Walmart Marketplace account to the Destination of your choice. To ingest data, you must provide Hevo with the Client ID and Client Secret of a production API key from your Walmart Marketplace account. Hevo uses these credentials to authenticate with the Walmart Token API using the client credentials grant.

Supported Features

Handling of Deletes

Walmart Marketplace does not mark records as deleted in its API responses. When a record is deleted, it is no longer returned by the API. Hence, Hevo captures deletes as follows:

• Objects ingested in full in each run: For all objects except those listed below, Hevo compares the data fetched from the Source with the data present in the Destination table in each run. If a record exists in the Destination but is no longer returned by the Source, Hevo marks it as deleted by setting the value of the metadata column __hevo__marked_deleted to True. This also applies to their child objects.

• Child objects of Orders, Shipment, and Fulfillment Order Status: When Hevo ingests an updated parent record in an incremental run, it replaces the child records of that parent. Child records that are no longer present in the parent record are removed from the Destination. During a historical load or a resync, the child records are merged and no records are removed. If you resync with Drop and Load, the tables are recreated with the data that Walmart currently returns.

• Shipment: Hevo ingests all the shipments and their child objects again once every seven days, and marks the shipments and child records that are no longer returned by the Source as deleted. Deletes are marked only when this weekly re-ingestion completes in a single Pipeline run.

• Promotional Pricing (child object of Promotional Price) and the Shipping Method child objects of Shipping Template: These records are identified by their position in the Walmart response. When Walmart reorders or removes entries, for example, when a promotion expires, the affected records are marked as deleted and loaded again under their new position.

Hevo does not capture deletes for the following objects. Records deleted in the Source remain in the Destination:

• Available Report Date and its child object, Recon Report

• Feed Status and its child objects

• Fulfillment Order Status

• Orders

• Seller Listing Quality Score

• Unpublished Item

• WFS Inventory Log Payload and its child object, WFS Inventory Log

Source Considerations

• Walmart returns only the orders created in the last 180 days. As a result, Hevo ingests only the orders created in this period, and an order is no longer updated in the Destination once it is older than 180 days.

• Walmart provides the data of the following objects only if your seller account is enrolled in the related Walmart program. If your account is not enrolled, these objects and their child objects are displayed as Inaccessible in the Pipeline, and no data is ingested for them:

  Walmart program	Objects
  Walmart Fulfillment Services (WFS)	Shipment, WFS Inventory Log Payload, and Inbound Shipment Error Payload
  Multichannel Solutions (MCS)	Fulfillment Order Status
  Repricer	Repricer Strategy Collection

  To ingest data for these objects, enroll in the program in Walmart Seller Center, and then refresh the schema of the Pipeline.

• If your API key does not have access to an API, the objects that use the API are displayed as Inaccessible in the Pipeline. To ingest data for them, grant the key access to the API in the Walmart Developer Portal.

• You can also connect using the API key of a Walmart Solution Provider that you have given delegated access to your seller account. The objects that the Solution Provider key cannot access are displayed as Inaccessible in the Pipeline.

• Walmart lists only the 2,000 most recent feeds. In each run, Hevo ingests these feeds, and retains the feeds ingested in earlier runs after Walmart stops listing them. Feeds that are older than the 2,000 most recent ones when the Pipeline is created cannot be ingested. If more than 2,000 feeds are submitted between two Pipeline runs, the feeds that are no longer listed cannot be ingested, and Hevo displays a warning in Needs Attention.

• Walmart returns only the orders created in the last 180 days and the 2,000 most recent feeds. If you resync the Orders or Feed Status object, or the Pipeline, with Drop and Load, older orders and feeds that were previously ingested are removed from the Destination and cannot be ingested again.

• Walmart provides shipping label data only for the orders that you fulfill. Hence, Hevo does not ingest label data for orders fulfilled by WFS.

• Hevo uses the same API rate limits as the other applications that use your seller account. Running such applications at the same time as the Pipeline can increase the time taken to ingest data.