search-icon

Walmart Marketplace allows third-party sellers to list their items on Walmart's website. If you've sold products on Amazon or eBay, you'll experience a similar process on Walmart Marketplace. People conduct searches on the site and browse product listings from sellers.


Prerequisites

  • Active Walmart Seller account with admin access to the Walmart Seller Center, with the following configured:
    • Partner profile (allows to configure company information, customer service policies, shipping options, return policy, privacy policy and tax information);
    • Shipping profile (allows to add and update the fulfillment centers for free TwoDay delivery setup);
    • Financial settings (allows to update payment information and tax forms);
    • Client ID and a Client Secret - to access the APIs. Once generated would be stored in seller account until deletion.
  • Familiarity with the Processing a Sale process (required)
  • Users will need the Integration: eCommerce - Walmart Marketplace permission in order to use this feature. 
  • Currently DEAR supports the Walmart USA Marketplace.


2) Products for listing should be populated according to requirements of related Walmart template:


Table of Contents


Walmart Marketplace integration setup

[back to top]


First, you must connect DEAR to your Walmart Marketplace store. You must have an active Walmart Seller account to use this integration. 



Each linked store has an independent catalog, logs and settings. Additional external integrations can be purchased from the My Subscription page if your account does not have enough available to make the connection. 


Connect Walmart Marketplace to DEAR: 

  1. Navigate to Integration → Walmart Marketplace.
  2. Click + to connect a new store. 
  3. From your Walmart Seller account, generate your Client ID and Client Secret
  4. Enter a name for your store. Note that a default value with be populated based off of the given data in country client and key but can be overridden. 
  5. Click Connect to Walmart Marketplace

Integration settings

[back to top]


Under the Setup tab, several integration settings can be customized.


Load from Walmart 

Select when sales are loaded from Walmart Marketplace. The user has the option between loading paid sales or fully shipped sales.


Consolidate orders 

There are two options for order consolidation:

  • No consolidation

  • Daily consolidation.


No consolidation indicates that sales will be captured from Walmart as they occur. Daily consolidation will consolidate all orders from that day into a single order. When daily consolidation is chosen, an additional setting becomes available: Consolidation time. This is your local time when all pending orders aggregated during the day will be processed.


See the Pending order processing section below for more details.


Customer 

For pending order processing to be successful, an existing customer must be selected.


When the consolidation type is Daily consolidation, this customer is used to create a new sales task, which will combine all daily sales. A customer can be created just for this purpose.


When No consolidation is selected, DEAR uses the customer company name as the customer name, unless the company name was not specified. In this case, the customer contact name is used instead.


Sales representative name 

This option allows the shop name to be used to fill the sales representative field of the sale. It is useful if you have several shops in the same region so as not to cause confusion. 


Price tier 

Choose which price tiers to use as default when DEAR downloads products from and updates products in Walmart Marketplace.



Location

Fulfillment By Merchant (FBM) means that products are stored somewhere at the merchant (seller) location. You can specify a location just for Walmart Marketplace. Selecting a particular warehouse will limit the availability of stock in Walmart Marketplace to that location. Selecting All locations will display the total stock quantity across all of your locations.



Pick, pack and ship processing mode 

When pending orders are processed by DEAR, new sales tasks are created. This setting tells DEAR if it should try to auto pick, auto pack and auto ship these tasks. If there is not enough stock on hand to pick the full quantity of products in an order, then pick will remain in draft state, and pack and ship won’t be completed.



Process auto-assembly as

This dropdown field has two options:

  • For ordered quantity: Does not check stock quantity. An assembly order is created for the quantity specified in the sale order, regardless of stock availability. 
  • For minimum quantity required for picking: Assemble stock required to meet the quantity of specific sale order. 
    • If stock availability is negative, auto-assembly will produce a finished goods quantity which is more than the quantity ordered through sale order. 
    • If there is already stock available in inventory but not enough to fulfill the sale order quantity, auto-assembly will assemble the difference in quantity needed to meet the sale order requirement.
    • If stock availability exceeds sale order quantity, auto-assembly is not triggered. 

Stock availability is validated against the sale order location and does not take on order quantity into account.


Match product manually

This is the option to choose automatic mapping according to SKU or manual mapping by the user. When automatic mapping is selected, an existing product will be searched for automatically by SKU, and if a product is found with a matching SKU, then the mapping is done automatically. When manual mapping is selected, the user will have to manually select which DEAR products to link to via the Catalog tab. Manual mapping can still be performed even if automatic mapping is enabled.


Create a new product if not found by SKU 

This option is only available when Match product by SKU is enabled. With this option enabled, if there is a product (SKU) in the sales channel that does not yet exist in DEAR, then this product can be automatically built in DEAR based on the data received about the product from a sales channel. The possibility of a manual build is still always available through the DEAR UI.



Buffer inventory

Displayed when Use buffer inventory is enabled. Enter an integer number of stock to act as a buffer.  Sync stock passed to Walmart Marketplace when updating stock levels will be equal to Actual stock - buffer inventory. When this setting is enabled, Sync quantity and Buffer inventory quantity will be added as fields to the Catalog and Bulk listing tables alongside stock availability.


NOTE: Once buffer inventory is enabled and specified, it will be applied across all products listed on the Catalog and Bulk listing tabs. However, sync quantities will only be updated in the channel if the user updates or lists a product.


Ignore restock for non-fulfilled sales

When a refund is processed for an unfulfilled Walmart Marketplace sale, this will cause an error with restocking the unfulfilled items. These will appear on the log as Pending fulfillment. If you are experiencing this error, you will need to enable this setting. Restock/stock allocation quantities will be edited to match the fulfilled items of the sale. This setting is only applicable when Pick, pack, and ship mode for processing online sales is set to Auto pick + pack + ship.


Use Walmart Marketplace as master source for DEAR products 

We have removed this option as DEAR does not enlist any data into Walmart. We only download data from Walmart, so by default Walmart is the Master of Data.


Update stock levels in Walmart Marketplace 

You may choose to disable automatic stock level update in Walmart Marketplace performed by DEAR at the time available product quantity changes in DEAR. This may be useful if you are managing stock levels in Walmart manually and do not want DEAR to change it. Please ensure you have the correct stock quantities entered in DEAR before you turn on this option as these values will override the stock quantities in Walmart.


Export shipping information to Walmart Marketplace 

You may enable the export of shipping information from DEAR to Walmart Marketplace.


Invoice status 

You can control the invoice status for sales tasks created as a result of pending order processing. By default, the invoice will not be authorized and will be in draft state, adjustable and waiting for authorization. However, if this setting is changed to authorized, the invoice will be automatically authorized, and pending sync will be created for it to sync with an accounting application of your choice.


Optional revenue account 

This is the revenue account to be used for all Walmart Marketplace sales. This will override settings at the product/customer level and any other account mapping. 


Ignore Walmart taxes 

You may choose to ignore taxes from Walmart Marketplace.


Money settlement bank account

Select the bank account that is used to receive settlements from Walmart Marketplace. 


Tax rule mapping 

When a pending order is processed by DEAR, a sales task is created. Each order and invoice line is assigned a tax rule. The tax rules specified in these settings will be used to create these lines. According to Walmart Marketplace policy, Marketplace Sellers are responsible for collecting and remitting the sales tax for the items they sell and may choose to add the cost of tax to the price of their items or can list the tax separately.


DEAR does not apply the tax rule to recalculate tax and is simply using the actual tax amount from the Walmart Marketplace order. This means that if certain products are not taxable or with varying tax in Walmart, all data and totals in DEAR will look identical to Walmart, but with DEAR tax rule name selected in this setting.


The tax Free tax rule mapping specified in this setting is used to create these lines for non-taxable products. 


In the case of tax recalculation, the tax amount will be overwritten with a value calculated by the DEAR taxation rule.


IMPORTANT! Tax rules are downloaded from Orders, hence the tax will be mapped upon order download.  


Payment account mapping 

DEAR can capture payments made against orders in Walmart Marketplace and is able to automatically add payments to a created sales invoice. To do this, complete payment account mapping here. You must choose an account that is able to receive payments from the chart of accounts. We recommend not to use a bank account; instead, use a dedicated accrual account. This will make it more convenient to view Walmart fees and charges.


This setting is not mandatory – if payment mapping is not completed, orders are still captured and downloaded from Walmart Marketplace, but payments must be manually added to invoices in DEAR. Some customers prefer to keep invoices open and then reconcile them manually with payments. 


Walmart accepted payment methods:

    • Credit cards: American Express, Discover, MasterCard, Visa

    • ATM/Debit/Check Cards, including Walmart MoneyCard

    • Walmart Credit Card and Walmart MasterCard

    • Walmart Gift Cards and eGift Cards

    • PayPal

    • Pay with Cash (credit cards, cash, checks, Walmart gift cards, money order, and EBT). SNAP and WIC benefits cannot be used to pay for the order amount

    • Chase Pay

    • Amex Express Checkout

    • Affirm installment financing.


Payment Method Restrictions:

    • You can use up to 5 gifts cards and 1 credit/debit card to split payment (6 total)

    • Gift cards cannot be used to purchase other gift cards

    • Two credit/debit/pre-paid cards cannot be used to split payment

    • You can't split any payment type with PayPal or Pay with Cash


Disconnect from Walmart Marketplace store 

When you disconnect from the Walmart Marketplace store, DEAR removes all associations between DEAR objects and Walmart Marketplace, including log and product catalog.


Catalog

[back to top]


The DEAR Walmart Marketplace catalog page allows user to download products from Walmart Marketplace, break the link between a DEAR product and its Walmart listing and update quantities in Walmart Marketplace according to DEAR available stock. This integration allows two-way exchange between DEAR and Walmart Marketplace product catalogs.


Downloading products

[back to top]


Products can be loaded from Walmart Marketplace to DEAR in the catalog tab by clicking Load products. This operation may take some time. Users can Refresh to show the latest data and search the catalog via the search field. 


There are two types of products in Walmart: a simple product and a complex product (a product with options/variations such as, for example, the same product in different colorsours and sizes). These map to DEAR products and product families. 

  • Each complex product has at least one option to differ and up to three as maximum. When downloading products from Walmart, DEAR checks if the product has/does not have options and creates a product or product family (with product variants as separate products) in DEAR. 
  • If a product family and its products are already created/linked with Walmart, then DEAR will update the existing family/products instead of creating new versions. 


When downloading products, DEAR first tries to match the existing products to avoid creating duplicates. This search takes place in several steps:

  • First, DEAR attempts to search for a product family by name using the Walmart product title.
  • Then, for each variant, DEAR searches for a DEAR product using the Walmart variant group ID.
  • If not found, DEAR then searches for a DEAR product by Walmart product (or variant) SKU.


When a product is created or updated in DEAR during the download process, a link is established between the product and variant unique Walmart Marketplace ID and DEAR unique product ID. This link is used when products are matched against sales order lines in Walmart and when subsequent product downloads take place.


Walmart Marketplace maintains a hierarchical and pre-defined list of categories and sub-categories while DEAR categories are all treated at the same level. Only the first (top-level) category of Walmart product will be linked to DEAR category, while attributes of variations are linked to options of DEAR product family. Product variation names once downloaded consist of the product family name + “(Option1Value, Option2Value, ...)".


During product download, DEAR automatically should create product categories and product brands/names for all product types downloaded from Walmart Marketplace. 


[If a product price in the catalog is important for the user, they MUST use a different price tier for each Walmart Marketplace; otherwise, the price will be overwritten with the last price in the marketplace currency.]


Data mapping for products between DEAR and Walmart Marketplace is as follows:

DEARWalmart Marketplace
SKU

SKU

NameproductName
CategoryCategory, subCategory
DescriptionshortDescription
Weightweight (“value” and “unit” are implied to use additionally for proper conversion)
WidtheachWidth* (in inches, used only for WFS conversion)
HeighteachHeight* (in inches, used only for WFS conversion)
LengtheachDepth* (in inches, used only for WFS conversion)
BarcodeproductIdType
Price tier. Default is price tier 1Price
ImagesmainImageUrl, productSecondaryImageURL: [“…”,“…”,“…”]
Quantityquantity: { unit, amount }
Sale tax ruleProvided set of structures: tax: { taxName, TaxAmount: { currency, amount } }
Option 1 NamevariantGrouID, variantAttributeNames**
Option 2 NamevariantGrouID, variantAttributeNames
Option 3 NamevariantGrouID, variantAttributeNames
Option 1 Value (for variation)variantGrouID, variantAttributeValue
Option 2 Value(for variation)variantGrouID, variantAttributeValue
Option 3 Value(for variation)variantGrouID, variantAttributeValue

**See here for details 


Manage catalog

[back to top]


There are three possible statuses for products in the catalog: Not listed, Listed and Canceled. The Canceled status appears for products that were removed from Walmart Marketplace. By default, they are not visible in the catalog unless the Show only active checkbox is disabled.


There is also an option that allows you to switch the appearance of the catalog to Show variations separately. If checked off, all products without variations are displayed, and each product variation is shown as a separate product line. In this function is not enabled, products without variations are displayed as usual and product families are displayed as a single product line.


In addition to downloading products from Walmart Marketplace and performing automatic product mapping, you can choose to manage your Walmart catalog from DEAR. There is a column for manually linking and unlinking DEAR and Walmart products. This is useful when the correct product has not been found.


There are three linking options:

  • Leave blank (do not tie to a product in DEAR)
  • Link to an existing product
  • Create a new product in DEAR (available if the product with the required SKU does not exist).


Catalog modifications in Walmart Marketplace

[back to top]


Consider a catalog which contains 3 products: A, B, C. Product C has been modified in the sale channel. Next time a catalog download is triggered, the products: A, B, D will be visible with the following statuses:

Products A and B (the unchanged products) will remain in the catalog with a Listed status. Product D will now appear in the catalog with a listed status, but product C’s status will change to Canceled.

Product mapping must be completed in order for sales to be successfully downloaded from your sales channels to DEAR. When sales are loaded from a sale channel and a sale contains a product that is not mapped to any product in DEAR, then this sale will be not be downloaded.

The user will be notified if a sale is skipped through internal messages such as: notifications, recordings in operation log, or text message on the screen (depending on the situation).



Orders and sales

[back to top]


Processing pending orders

[back to top]


Whenever a sale is created in Walmart Marketplace, it is first placed in Pending orders, and stock is allocated immediately. DEAR checks every hour if there are any new orders and imports them immediately as individual sales orders (if No consolidation is selected in the integration settings) or once a day as a consolidated sales order (if Daily consolidation is selected). 


If No consolidation is selected, each Walmart Marketplace sale is converted into an identical sale in DEAR, keeping the same customer, shipping and billing information. With Daily consolidation, the single daily sales task will use the customer selected in the integration settings, and customer, billing and shipping information imported from Walmart Marketplace will be ignored. 


When processing orders, the logic is identical to that of the DEAR UI. Dropshipping, kitting and other important scenarios are implemented in the same way as the DEAR UI.


Pending orders can be processed manually by clicking Process. They can then be viewed in the Log tab.


Order field mapping

[back to top]


No Consolidation 


Daily consolidation 

DEAR sale order header fieldsWill have value:
Customer and customer details (contact, phone, email)

Default customer in Walmart Marketplace settings will be used.

ReferenceReference added with the date on which the sales were consolidated.

Ex: Walmart sales for 28/05/2020

Billing address

Billing address for the default customer will be used. 

Price tierSale price tier specified in Walmart Marketplace settings 
TermsDefault payment terms (Settings → Reference Books → Payment Terms)
Sales representative
  • Sales representative name specified in Walmart Marketplace settings.
  • If sales representative name is not specified, Walmart store name will be used. 
Account
  • Optional revenue account specified in Walmart Marketplace settings.
  • If optional revenue account is not specified, default sales account will be used. 
Tax ruleWill be set according to tax rule mapping in Walmart Marketplace settings.
Invoice #Generated automatically by DEAR.
Invoice dateSale order capture date.
Due dateCalculated from invoice date + payment term
Location
  • If order routing is enabled, the field will have value determined by order routing. 
  • Otherwise default Walmart Marketplace location for online sales will be used.
DateSale order capture date.
Shipping addressShipping address for the default customer will be used.
Ship to companyDefault customer in Walmart Marketplace settings will be used.
Ship to contactDefault customer in Walmart Marketplace settings will be used.
Shipping notesWalmart Marketplace notes
CommentsWalmart Marketplace notes
Required bySame as sale order capture date.
Carrier/Service

Walmart Marketplace carrier information will be used.

If no Walmart carrier information is provided, Free Shipping will be used.


Downloading orders and payments

[back to top]


Orders are automatically downloaded every hour when an order is paid, modified or changed in Walmart Marketplace settings


Any imported order is saved to the Pending orders section. It is a temporary storage of all sales and payments in DEAR. Only orders matching the selected capture option are accepted: with status paid/unshipped/shipped. 'Load from Walmart' can be changed in the integration settings. 


If an order already has an entry in the log, i.e. it has been imported previously, it will be skipped. This guarantees that no duplicate sales will be created by DEAR.


While saving orders, DEAR captures customer information such as the shipping address. [Unfortunately, upon order download, it is impossible to obtain the billing address details, except for the billing name (the person who paid for the order).]] All line items are captured together with quantities, prices and totals. 


For each line in a sales order, DEAR will try to locate the corresponding product by SKU. If no product is found, DEAR tries to download the product information from Walmart Marketplace using the same logic as in the Download products function described above. If the product information is not found (if removed from the Walmart store, for example), DEAR marks this line as a service (non-product). Next, the sale line is saved to pending orders with all the data imported from Walmart Marketplace: tax, quantity and total.


If a payment account has been specified in the integration settings, DEAR will always assign associated payments to the captured orders (whether the order has already been processed or is still pending) when the Walmart Marketplace order is paid.


Only Order's with order st acknowledged, shipped and delivered orders are downloaded.


The final step in the order download is to trigger an update of stock levels in the other Walmart Marketplace stores and the other connected eCommerce channels.


Updating fulfillment in Walmart Marketplace

[back to top]


When shipment is authorized in DEAR and the carrier specified, DEAR will try to create order shipment information in Walmart Marketplace. This will only work in the No Consolidation processing mode.


Logs

[back to top]


Each captured Walmart Marketplace order once saved to pending orders creates a log entry to track the link between the sale in DEAR and in Walmart Marketplace. This eliminates the possibility of creating duplicate orders when capturing the same order several times during manual order load. 


Each log entry has a link to the sales task in DEAR. Depending on the settings selected by the user in the setup tab, this sales task could be draft or authorized, one or more of the pick, pack and ship tabs could be authorised, and payment could have been applied to the invoice. 


Log entries allow you to see which sales task reflects a particular Walmart Marketplace sale. You also have the option to delete a log entry manually. This will allow DEAR to reprocess an order if required. Deleting a log entry will not void or delete its associated sales task.


Reloading orders from Walmart Marketplace

[back to top]


If for any reason you need to reload an order from Walmart Marketplace, this can be managed from DEAR.


To reload an order from Walmart Marketplace: 

  1. Void the sales task. A record of this will be kept in DEAR for reconciliation purposes, but the transactional data will be deleted. 
  2. Return to the Walmart Marketplace integration Log tab and delete the log entry. This will allow the order to be recaptured from Walmart Marketplace.
  3. Navigate to the Pending orders tab and click Load orders, making sure to set the date before the order to reload was made. DEAR allows loading historical sales data a maximum of one year old.


Refunds Returns and Replacements

[back to top]


All refund and return rules are defined by a customer in the Seller Central account. It doesn't matter for DEAR what these rules are, DEAR just grabs returns and refunds from Walmart and process them on our end. 


DEAR will process the captured refunds automatically every hour, but users can manually load and process refunds and credit notes via the pending orders tab. Only refunds that are Completed from Walmart Marketplace will be captured and loaded to DEAR. Pending or Declined refunds will not be loaded or processed to DEAR.


When processing refunds for historical sale orders on Walmart Marketplace integration, DEAR would load the sale order together with the refund and credit note from Walmart Marketplace. If the sale pre-dates the date when DEAR was integrated with your Walmart Marketplace store, a stand-alone credit note will be processed, while the original order will not be altered or synced.


At Walmart orders are differentiated with respect to OrderType which can be new orders or Replacements. DEAR cannot recognize order type, All Replacements are also processed as a new order under order management.

When processing refunds for historical sale orders on Walmart Marketplace integration, DEAR would load the sale order together with the refund and credit note from Walmart Marketplace. If the sale pre-dates the date when DEAR was integrated with your Walmart Marketplace store, a stand-alone credit note will be processed, while the original order will not be altered or synced. 


Operations log

[back to top]


Each time the user or DEAR downloads sales, the appropriate record is added to the operations log, which also contains information about results of downloading, including the count of processed, skipped or cancelled order. Currently the operations log also logs any setting changes in general settings or others in set up tab.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.