If you are eligible for the Walmart 2-day shipping tag and prefer to manage it from Zentail, you already know that you can do so on a warehouse-to-warehouse basis. The good news is that by leveraging the power of Zentail's Bulk Action suite, you can further refine which SKUs get the 2-day tag.  

For example, if you want to offer Walmart free 2-day shipping for specific SKUs and only when you have a threshold level of quantity in stock, you can set up a series of scheduled bulk actions that will regularly check those SKUs inventory level and then effectively add or remove the 2-day tag on Walmart.

The following example bulk actions show the main rules and actions needed.  In order for them to work, you would first need (1) to have a 2-day warehouse enabled, (2) to add a label such as "2-day" to each SKU you wish to include, and (3) to decide what the inventory threshold for inclusion is, such as "less than x units in the main warehouse".  

Below we have provided the filtering argument needed to perform this bulk action and you can create and use bulk actions in this manner if you wish. However, this filter can also be more easily created from QuickEdit. To do so: 

  1. Navigate to Catalog > QuickEdit. 
  2. You will be presented with the default QuickEdit view, remove the Title and Cost columns by clicking the small X next to each of these. 
  3. Click Add Column, then search for “Quantity” - you should see a column for your primary warehouse name followed by Quantity, add that to the view by clicking the + sign next to the column header.
  4. Search for “Labels” and add the labels column as well. Click Done to stop adding columns.

Now that you have this view configured with the needed columns, we can filter for only the values we want. 

Click the filter icon in the Labels column, and filter to Contains “2-day” (or whatever label name you choose for your Walmart 2 day tag name. Label names will always be lowercase.)

Then, filter the Quantity column to the minimum threshold you’d like for when items should no longer be flagged walmart 2-day. In this example we will use 50.

From there, you can continue to create the bulk action by clicking Create Bulk Action near the top right.

Important Note: You'll need to replace x with your threshold amount and change the italicized field names (e.g. "main quantity", "2-day quantity") below to the specific ones for your warehouses. You can find the correct field name by using the Insert Field Name button when you set up your filter.

Bulk Action 1 - adds inventory to your 2-day warehouse for labelled SKUs with more than x units in your main warehouse
Label:  Set quantity to 1 in 2-Day Warehouse
Filter:  
AND(ISTRUE(still_in_catalog),CONTAINS(labels,"2-day",true),GREATERTHAN(main quantity,"x",false))
Actions:
SET(2-day quantity, 1)
SET(Walmart max listings, main quantity)
Frequency:  Every 4 hours beginning

Bulk Action 2 - removes SKUs from the 2-day warehouse when inventory drops below your threshold of x units
Label:  Zero out 2-Day Warehouse for low inventory 2-day SKUs (1)
Filter:  
AND(CONTAINS(labels,"2-day",true),LESSTHAN(main quantity,”x",true))
Actions:
SET(2-day quantity, 0)
CLEAR(Walmart max listings)
Frequency:  Every 4 hours beginning

Bulk Action 3 - same function as Bulk Action 3 on a different cadence so that SKUs are removed every two hours
Label:  Zero out 2-Day Warehouse for low inventory 2-day SKUs (2)
Filter:  
AND(CONTAINS(labels,"2-day",true),LESSTHAN(main quantity,”x",true))
Action:
SET(2-day quantity, 0)
Frequency:  Every 4 hours middle

Bulk Action 4 - handles any SKUs where you have removed the "2-day" label
Label:  Audit - Remove from Walmart 2-Day, check entire catalog including archived skus
Filter:  
NOT(CONTAINS(labels,"2-day",true))
Actions:
SET (2-day quantity, 0)
CLEAR(Walmart max listings)
Frequency:  Daily

Related Reading
Bulk Actions and Automation Rules
Walmart 2-day shipping tag

Did this answer your question?