Unfillable Products

 
 

Overview

The Unfillable Products report page lets you track low inventory items and compare the currently available quantities against items on order. This feature works well with the Out of Stock Notice that alerts you when items are out of stock.

You can easily create new Purchase Orders or FBA shipments by dragging the products in the related cart to auto-populate the required quantity.


Manage Unfillable Products

To view and manage unfillable products: 

  1. Click Inventory.
  2. Select Tools > Unfillable Products.
  3. Set up the filters to narrow down the search results.
  4. Click Search.

 

Filters

Refer to the table below for filter definitions:

FILTER DESCRIPTION
Company Include only products from one or more companies.
Unfillable Type Include only specific types of unfillable products:

  • Unfulfillable orders – Show only products in open orders, that cannot be fulfilled due to insufficient quantities.
  • Below inventory low level – Checks quantity sold in the past days and compares it to the quantities in stock and those on order. The Inventory Low level Notice can be set for each product from the product’s Toolbox > Purchasing. For example, a product has negative stock and low inventory notice set to 10. There have been no units sold in the past 90 days, so the Req Qty is 34.
  • Vendor Central Backorder – Show only Vendor Central products in open orders, that cannot be fulfilled due to insufficient quantities.
Vendor Include only products from one or more vendors.
Include Sold Statistics for Include only sold statistics for specific time ranges.
On Order Include only products that are or are not on order.
SKU Include only specific products.
Channel Include only specific channels.
Warehouse Include only specific warehouses.
Channel SubType Include only specific channel subtypes.
Exclude Channel Exclude specific channels.
Fulfilled By Include only products with a specific Fulfilled By status – Merchant or Amazon, as set on product pages > Toolbox > Amazon Properties.
Product Group Include only specific product groups.

 

Key Terms

Refer to the list below for key terms used in the report and their descriptions:

COLUMN DESCRIPTION
SKU Shows the product’s SKU.
Product Name Shows the product’s name.
LOC Shows the product’s Location Notes set on the product page > Inventory > General.
Vendor Shows the product’s vendor.
Vendor SKU Shows the vendor SKU.
OnOrder Shows the product quantity ordered from a vendor but not received yet.
Qty Avail Shows the quantity available in sellable warehouses or the specific warehouses selected in the filters.
Orders Qty Shows quantities in uncompleted orders.
Req. Qty Shows the quantity required to fit all criteria to fulfill orders and increase inventory.
QtyPerCase Shows quantity per case, as set on the product’s Toolbox > Purchasing menu.
Orders
Shows the number of orders, and you can click for a list of related orders.
Buyer Shows the buyer’s email address.
Replacements Shows the number of replacement product units. For example, if Product A has Product B as a replacement, and Product B has 100 units available, the “Replacements” for Product A will show 100.

Reorder Inventory

To quickly reorder inventory based on results in the report:

  1. Check the box to the left of each product to select it.
  2. Click the Actions button on the bottom right.
  3. Select Add to PO or Add to FBA Inbound Shipment.
  4. Proceed with the next steps depending on your choice.

Purchasing Forecast

Predictive purchasing helps you organize inventory levels and predict what quantities to order in the future based on past sales. You can even set up predictive purchasing to automatically create/suggest purchase orders via a scheduled task.


Overview

The Unfillable Products page lets you track low inventory items and compare currently available quantities against items on order. This feature works well with the Out of Stock Notice that alerts you when items are out of stock.

You can easily create new Purchase Orders or FBA shipments by dragging the products in the related cart to auto-populate the required quantity.


Manage Unfillable Products

To view and manage unfillable products: 

  1. Click Inventory.
  2. Select Unfillable Products.
  3. Set up the filters to narrow down the search results.
  4. Click Search.

 

Filters

Refer to the table below for filter definitions:

FILTER DESCRIPTION
Company Include only products from one or more companies.
Unfillable Type Include only specific types of unfillable products:

  • Unfulfillable orders – Show only products in open orders, that cannot be fulfilled due to insufficient quantities.
  • Below inventory low level – Checks quantity sold in the past days and compares it to the quantities in stock and those on order. The Inventory Low level Notice can be set for each product from the product’s Toolbox > Purchasing. For example, a product has negative stock and low inventory notice set to 10. There have been no units sold in the past 90 days, so the Req Qty is 34.
  • Vendor Central Backorder – Show only Vendor Central products in open orders, that cannot be fulfilled due to insufficient quantities.
Channel Include only specific channels.
Exclude Channel Exclude specific channels.
Subtype Include only specific channel subtypes.
Vendor Include only products from one or more vendors.
Fulfilled By Include only products with a specific Fulfilled By status – Merchant or Amazon, as set on product pages > Toolbox > Amazon Properties.
Include Sold Statistics for Include only sold statistics for specific time ranges.
On Order Include only products that are or are not on order.
Warehouse Include only products in specific warehouses.
ProductID Include only specific products by SKU.
Product Group Include only specific product groups.

 

Key Terms

Refer to the list below for key terms used in the report and their descriptions:

COLUMN DESCRIPTION
ProductID Shows the product’s SKU.
Product Name Shows the product’s name.
LOC Shows the product’s Location Notes set on the product page > Inventory > General.
Vendor Shows the product’s vendor.
Vendor SKU Shows the vendor SKU.
OnOrder Shows the product quantity ordered from a vendor but not received yet.
Qty Avail Shows the quantity available in sellable warehouses or the specific warehouses selected in the filters.
Low Stock Notice Shows the product quantity threshold set to trigger a low stock notice alert.
Req. Qty Shows the quantity required to fit all criteria to fulfill orders and increase inventory.
QtyPerCase Shows quantity per case, as set on the product’s Toolbox > Purchasing menu.
Buyer Shows the buyer’s email address.
Replacements Shows the number of replacement product units. For example, if Product A has Product B as a replacement, and Product B has 100 units available, the “Replacements” for Product A will show 100.

 

Reorder Inventory

To quickly reorder inventory based on results in the report:

  1. Check the box to the left of each product to select it.
  2. Drag and drop the products into the FBA Cart or PO Cart.
  3. Click Edit Cart to proceed with the purchase order.
  4. Proceed with the next steps depending on your choice.

Purchasing Forecast

Predictive purchasing helps you organize inventory levels and predict what quantities to order in the future based on past sales. You can even set up predictive purchasing to automatically create/suggest purchase orders via a scheduled task.


Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support