Walmart Dropship Vendor Integration Via API

SellerCloud connects to Walmart DSV via API to upload inventory, download orders, and upload tracking.

Your server should have a Last Write date on or after May 19, 2018, in order to use orders, tracking, and inventory upload working properly.
Keep in mind that if you manually acknowledge the orders on Walmart, SellerCloud will not download them.
  1. In your Walmart DSV portal, press on the Settings Icon.
  2. Select Consumer IDs & Secret Keys in the API section.
  3. Press the Create Consumer ID and Secret Key button. 
    If you receive an error when trying to generate your keys in Walmart, please contact Walmart support to have your account enabled for API.
  4. Go into SellerCloud to Settings > company > Toolbox > Walmart > General Settings.
  5. Enable settings " Enable API Integration",  "Walmart Enabled", and "Walmart Direct".
  6. Copy and paste the ID and Key into the Walmart Settings page in SellerCloud.
  7. In the Walmart DSV portal under Settings > Distribution Facilities, retrieve your Distribution ID. 
  8. In SellerCloud, enter this under Warehouse ID(s). If there are multiple warehouses you can enter them separated by a comma.

  9. Save. 
  10. Verify the connection from the action menu. 
  11. Under Toolbox > Walmart > Shipping Method Mapping, be sure to set up all mapping to properly import orders with the correct shipping methods.
  12. Make sure all items have the correct price in the Walmart Initial Cost field on the Walmart Properties page. You can do this in bulk using column header WalmartPrice.  If you want to use the item's Site Price as the Walmart Initial Cost, enable the column WalmartPriceUseDefault
    This field will be pulled into the order as the item's price, as the price that Walmart sends is the amount they charge the customer, not the amount you will receive for the order. If this is not properly set up, your P&L will be incorrect.

Switching from EDI to API integration

While SellerCloud still supports existing EDI integrations with Walmart DSV, if you choose to migrate to the API integration, you will need to be very careful during this process. All orders will need to be fulfilled and tracking uploaded through 

  1. Turn off order download for Walmart DSV under Settings > company > Toolbox > Walmart > General Settings. 
  2. Have your Walmart DSV account enabled for API. (Do not yet change the credentials in SellerCloud)
  3. Fulfill all orders that are open.
  4. Once all tracking is uploaded to Walmart DSV, turn off Fulfillment Upload and Inventory Upload. 
  5. Enable the "Enable API integration" to be able to fill in credentials. You should follow all steps above.

How did we do?