Set up order sync for Walmart Marketplace
Import orders from Walmart Marketplace and send shipment and cancellation updates back to the marketplace using order sync in Productsup.
Productsup lets you synchronize orders between Walmart Marketplace and your order management system (OMS). Walmart Marketplace order sync covers two separate flows:
- Import orders into your OMS — relay new orders from Walmart Marketplace to your OMS so you can fulfill them. The order line item strategy described below doesn't apply to this flow.
- Export shipment and cancellation updates back to Walmart — send tracking and cancellation information from your OMS back to Walmart. This flow requires you to combine your Walmart order data with your OMS data, and how you do that depends on your chosen order line item strategy.
An order on Walmart Marketplace can include one or more order line items. Each line item is identified by a purchaseOrderId, the overall order ID, and a lineNumber, which is sequential (1, 2, 3...) for each item in the order. Every shipment confirmation or cancellation you send to Walmart applies to an individual order line item, even if you ship multiple items in one package.
Prerequisites
To use Walmart Marketplace order sync in Productsup, you need:
- An approved Walmart Marketplace seller account (US) with access to Seller Center.
- To authorize Productsup to access your Walmart account. You do this when you configure the export destinations below.
Import orders into your OMS
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Search for Walmart Marketplace Orders Import and select Add. Give it a name as desired and select Continue.
In Authentication, choose an existing authentication or select Add New Authentication to connect your Walmart account.
Selecting Add New Authentication redirects you to Walmart's authorization page. After you approve access, Walmart redirects you back to Productsup automatically.
Configure any filters you need, such as ship node type or date ranges, then select Save.
Select Run in the top-right corner to import your order data from Walmart.
The platform automatically acknowledges newly imported orders that are in Created status.
Once your order data is imported, go to Exports to add and set up an export that sends it to your OMS. Before running your export, map the mandatory attributes in Dataflow.
Choose an order line item strategy
Before you set up shipment and cancellation exports back to Walmart, decide how your OMS returns tracking and cancellation information:
- Per order line item — Your OMS returns tracking or cancellation information for each individual order line item (
purchaseOrderIdandlineNumber). - Per order — Your OMS returns tracking or cancellation information for the order as a whole and doesn't track individual line items. Walmart still requires every line item to be confirmed, so the same update applies to all line items in that order.
Set up your data sources for Walmart updates
To send shipment and cancellation updates back to Walmart, you need both your Walmart order data and your OMS data in the same site, joined together.
Take the steps in Import orders into your OMS again, but in a new site separate from the one you use to relay orders to your OMS. Use Walmart Marketplace Orders Import as the main data source in this new site.
Add your OMS as an additional data source in the same site, and select Run to import your tracking and cancellation data.
Join your OMS data to your Walmart order data:
- If you're tracking per order line item, join by
purchaseOrderIdandlineNumber. - If you're tracking per order, join by
purchaseOrderIdonly.
Tip
Filter your joined data to orders with status Acknowledged before your shipment or cancellation export runs — either with a status filter on the data source or a rule box in Dataflow, whichever fits your setup. This prevents the export from processing orders before Walmart has confirmed them or sending the same update more than once.
Send shipment notifications to Walmart
Go to Exports from your site's main menu and select ADD EXPORT.
Search for Walmart Marketplace Shipment Notification and select Add.
Select Add Destination, choose the matching destination from the dropdown, give it a name as desired, and select Save.
In Authentication, choose the Walmart authentication you previously set up, or select Add New Authentication.
Toggle Active to On and select Save.
Go to Dataflow and select Walmart Marketplace Shipment Notification in the dropdown on the left to map your attributes from import to export.
Select Run in the top-right corner to send shipment notifications to Walmart.
The export has the following attributes at the export stage:
| Attribute | Mandatory or not | Meaning and expected values |
|---|---|---|
purchaseOrderId | Mandatory | The overall order ID as assigned by Walmart. |
lineNumber | Mandatory if tracking per line item | The sequential number of the line item within the order. |
trackingInfo.carrierName.carrier | Mandatory in most cases | The carrier delivering the order, using Walmart's accepted carrier codes. |
trackingInfo.carrierName.otherCarrier | Mandatory if carrier isn't provided | The carrier name, when your carrier isn't in Walmart's accepted list. |
trackingInfo.trackingNumber | Mandatory | The shipment tracking number. |
trackingURL | Mandatory if otherCarrier is used | The URL where the buyer can track the shipment. |
Send cancellations to Walmart
Go to Exports from your site's main menu and select ADD EXPORT.
Search for Walmart Marketplace Order Cancellation and select Add.
Select Add Destination and choose Walmart Marketplace Order Cancellation export from the dropdown. Give it a name as desired and select Save.
In Authentication, choose the Walmart authentication you previously set up, or select Add New Authentication.
Toggle Active to On and select Save.
Go to Dataflow and select Walmart Marketplace Order Cancellation in the dropdown on the left to map your attributes from import to export.
Select Run in the top-right corner to send cancellations to Walmart.
Common pitfalls
| Pitfall | What to do |
|---|---|
| An order line item can't be canceled or shipped individually | Confirm you joined your OMS data by purchaseOrderId and lineNumber, not purchaseOrderId alone. See Choose an order line item strategy. |
| Orders are processed before they're ready, or get processed more than once | Confirm you filtered your joined data to status Acknowledged before running the export, either on the data source or with a rule box in Dataflow. |
| A shipment notification is rejected for a missing carrier | Provide trackingInfo.carrierName.otherCarrier and trackingURL when your carrier isn't in Walmart's accepted carrier list. |
How is this guide?