SKU Black List
- Susanna Romanelli (Unlicensed)
What is the SKU Black List section for?
On the SKU Black List page, users can set products in the SKU Black List when the product is out of stock for some time.
Setting a product | SKU in the SKU Black List means that the system will ignore the order with this product | SKU for the time being and send to fulfilment the other orders related to these ONE.
Example
The main order is out of stock, which is also being set in the SKU Black List
There is stock for the upsell orders
Result: The system sends all upsell orders and once the product of the main order is back in stock, the order will be sent out.
However, please note that if the Black Listed SKU is in stock, the system will override (ignore) this rule and send out the order.
Where is the SKU Black List section located?
To find this section, follow the below steps.
Log into CRM and go to the left-side menu
Scroll down and click on the Warehouse Management
Then click on SKU Black List.
What is on the SKU Black List page
On the SKU Black List page, there are:
The feature to add a new SKU to the Black List
The list of all SKUs that are blacklisted (see the below example):
Adding a new product to the SKU Black List
Click on the Add new Product SKU field
Pick one of the SKUs from the drop-down menu
Click on the + Add button
How the products set up as SKU Black List work in the fulfilment chain
Normally, the system follows the 50% rule to ship a bundle of orders (Main order + Upsells).
The 50% Rule - Fulfilment
The 51% of the products, in the bundle of orders (Main order + Upsells), need to be in stock and ONLY all orders can be shipped in just one package.
The reason behind this rule is to avoid paying multiple shipping fees for the same bundle of orders. Thus, the system will make sure to send out the products ONLY when more than 50% of the them are available at the warehouse.
Resuming, we can have the four cases below.
The 1st Scenario | The 2nd Scenario | The 3rd Scenario | The 4th Scenario |
|---|---|---|---|
In the same warehouse, there is a bundle with 2 orders:
| In the same warehouse, there is a bundle with 2 orders:
| In the same warehouse, there is a bundle with 2 orders:
| In the same warehouse, there is a bundle with 2 orders:
|
Result | Result | Result | Result |
The system won’t send any order, as for both items there isn't any stock available. | The system will ignore the blacklisted SKU, break the 51% rule and send anyway the 1st order. | The system will ignore the blacklisted SKU, and don’t send any order as the first item is out of stock. | The system will send out both orders as both items are available. |
Exceptions
Scenario
There is an order with 2 SKU
SKU 1 is blacklisted
SKU 2 is not blacklisted
Also, both SKUs are in stock BUT they have been assigned to different warehouses
SKU 1 has been sent to warehouse A to be fulfilled
SKU 2 has been sent to the warehouse B to be fulfilled
In this case, the system overrides the SKU BlackList rule, because the blacklisted SKU is in stock, and it will try to send out the 2 orders.
However, the 2 orders are in 2 different warehouses, so then they don’t comply with the 50% rule.
As a result, the fulfilment is rejected and both orders are set to Backorder, even though there is stock available.
Solution(s)
Users can force manually the fulfilment of one of the orders to be sent out by resetting the fulfilment itself.
Set one of the SKUs in the SKU Exceptions List.
How to reset the fulfilment of an order
Log in to CRM, go to the left side menu
Click on Orders
Look for the order using the filters given
Once the order has been found, go to the order page
Scroll down to the Shipping History
Click on the Manage Fulfillment button=
The Fulfillment Management page will open, scroll down till the Reset Fulfillment section
Select the Product
Click on the Assign warehouse option and from the drop-down menu picked the one the order has been already assigned to
Write down the reason in the Reason field
Click on the Reset button (see the below example)
The following warning message tab will pop up, informing the user that the fulfilment cannot be reset on the Warehouse, because (i.e. “Customer non-available” which means that the order is already been shipped) or for any other reason, just click on the Reset button and the order fulfilment will be reset, and the order will go back to the queue to be fulfilled.