WholeCell's Walmart integration keeps your Walmart listing quantities synced with current stock levels from WholeCell, imports Walmart sales orders to WholeCell for IMEI fulfillment, and sends shipment tracking to Walmart.
This integration syncs:
Listings (Walmart → WholeCell)
Listing Quantities (WholeCell → Walmart)
Orders (Walmart → WholeCell)
Shipments (WholeCell → Walmart)
Enabling the Integration
Enable the Walmart integration from your Integrations Dashboard:
To start, connect your Walmart account by entering your Walmart credentials (check with Walmart Support if you don't know the Client ID and Client Secret).
Note: In Walmart, as you access your API Keys, access permissions may need to be configured. WholeCell will need full access to Feeds, Item Management, Order Management, and Fulfillment. No other permissions are needed for the other areas.
Order Import
WholeCell will import Walmart sales orders once this checkbox is selected. Older orders can be imported to WholeCell retroactively by selecting a date and time in the Minimum Order Date section.
Organization Type
When WholeCell imports new sales orders from Walmart it can create new customers in your WholeCell account based on their actual name (like "John Doe") or it can import them under a single customer named "Walmart". You can decide which option fits your business needs better.
Order Statuses
You need to map Walmart's order statuses to your WholeCell order statuses for orders to be imported. If you want to create new order statuses in WholeCell for this, follow the instructions in this article: Managing Sales Order Statuses.
WholeCell routinely fetches status updates from Walmart to update your Walmart orders. If an order is marked as shipped in Walmart, for example, it will update in WholeCell at the next sync interval. Changes to the order status in WholeCell will not affect the order status on Walmart.
Some actions like adding a shipment will sync back to Walmart and mark the order as shipped.
Inventory Quantity Sync
Enabling Inventory Quantity Sync will automatically update the quantities of your Walmart listings based on the calculated quantities* of associated Product Variations or SKUs in WholeCell.
* Calculated Quantity = Available Quantity - Outstanding Quantity
Inventory Statuses
With Inventory Quantity Sync enabled, choose the inventory statuses that should count towards your total calculated quantity* of available inventory to update your Walmart listings with.
Warehouses
With Inventory Quantity Sync enabled, choose which warehouse(s)' inventory should count towards your total calculated quantity* of available inventory to update your Walmart listings with.
Order Acknowledgment
Select the option that you want for WholeCell to behave in terms of order acknowledgment.
After taking all the steps above, save the configuration.
Importing your Walmart Listings
Once your settings have been saved on the Details tab, click the Listings tab and hit "Import Listings" to bring in your listings from Walmart.
You'll see the table fill with your Walmart listings once they've been imported.
If your Walmart listing SKUs match your SKUs in WholeCell exactly, those listings will connect automatically and you'll see a green "Connected" tag in the status column.
For listings that are not connected, you can click on the listing title to manually connect it to either:
a single SKU
multiple SKUs
or specific Product Variation(s)
You can also connect listings in bulk by uploading your product variations and SKUs in WholeCell, following the instructions in this article: Setting Your Product Variations and SKUs
Syncing Orders and Shipments
As you receive orders in Walmart, they will be automatically created in WholeCell. When you add shipment tracking information to those orders in WholeCell, the tracking number will automatically sync back to Walmart.
If you're using ShipStation to create shipping labels for your Walmart orders, you'll want to connect ShipStation to WholeCell so that your Walmart orders flow as follows:
Walmart→ WholeCell → ShipStation
Then, when you create shipping labels for your orders, the tracking numbers will flow:
ShipStation → WholeCell → Walmart
**If you have not created the sales channel's name in WholeCell yet, you can do that here. WholeCell will not be able to sync orders to ShipStation if your sales channels don't exactly match (case sensitive) the channel names that the integration uses -- like "Walmart", in this case. Changing these channel names will prevent the sync from working. After creating the channel name, put a check in the box here if you want to sync orders with ShipStation:
Important Notes or Reminders
When you enable 'Order Import' and receive orders with unknown SKUs, you won't be able to map different SKUs for the order item (e.g. mapping a WholeCell SKU to the channel's listing's SKU settings page in WholeCell). Even if you map the WholeCell SKU for that listing in WholeCell, the order item will still show "Unknown SKU". The only way to make those SKUs be recognized is to add them to the WholeCell product catalog. To proceed, you can either do a 'Direct Commit', or delete the order item and just commit whatever item you want to fulfill the channel order.
Troubleshooting
The listing quantities are not being updated
Has the listing been imported to WholeCell?
Is the listing connected?
Does the listing show active or ended?
Is the 'Enable Inventory Sync' box checked?
Is the warehouse set on the inventory items you want to sync?
If an order comes in and shows "Unknown SKU", check:
Are there matching SKUs in both Walmart and WholeCell?
Have all of your listings been imported to WholeCell?
If your orders are not coming into WholeCell, check:
Is the 'Enable Order Import' box checked?
Multi-variation listing quantities are not synced
Does each listing have matching SKUs in Walmart and WholeCell? Are they all showing 'Connected'?
The outstanding count on the listing is incorrect
Check which sales order statuses are supposed to count toward open orders
Check if the 'Shipped' and 'Canceled' order statuses are set to count toward open orders
Are your listings being set to out-of-stock even though WholeCell is actively syncing non-zero quantities? Check to see if you have other eCommerce software connected to the channel.
If you can't find the listing on the channel's settings page in WholeCell, make sure to search using the listing ID and not the SKU.