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:

FILTERDESCRIPTION
CompanyInclude only products from one or more companies.
Unfillable TypeInclude 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.
VendorInclude only products from one or more vendors.
Include Sold Statistics forInclude only sold statistics for specific time ranges.
On OrderInclude only products that are or are not on order.
SKUInclude only specific products.
ChannelInclude only specific channels.
WarehouseInclude only specific warehouses.
Channel SubTypeInclude only specific channel subtypes.
Exclude ChannelExclude specific channels.
Fulfilled ByInclude only products with a specific Fulfilled By status – Merchant or Amazon, as set on product pages > Toolbox > Amazon Properties.
Product GroupInclude only specific product groups.

 

Key Terms

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

COLUMNDESCRIPTION
SKUShows the product’s SKU.
Product NameShows the product’s name.
LOCShows the product’s Location Notes set on the product page > Inventory > General.
VendorShows the product’s vendor.
Vendor SKUShows the vendor SKU.
OnOrderShows the product quantity ordered from a vendor but not received yet.
Qty AvailShows the quantity available in sellable warehouses or the specific warehouses selected in the filters.
Orders QtyShows quantities in uncompleted orders.
Req. QtyShows the quantity required to fit all criteria to fulfill orders and increase inventory.
QtyPerCaseShows 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.
BuyerShows the buyer’s email address.
ReplacementsShows 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:

FILTERDESCRIPTION
CompanyInclude only products from one or more companies.
Unfillable TypeInclude 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.
ChannelInclude only specific channels.
Exclude ChannelExclude specific channels.
SubtypeInclude only specific channel subtypes.
VendorInclude only products from one or more vendors.
Fulfilled ByInclude only products with a specific Fulfilled By status – Merchant or Amazon, as set on product pages > Toolbox > Amazon Properties.
Include Sold Statistics forInclude only sold statistics for specific time ranges.
On OrderInclude only products that are or are not on order.
WarehouseInclude only products in specific warehouses.
ProductIDInclude only specific products by SKU.
Product GroupInclude only specific product groups.

 

Key Terms

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

COLUMNDESCRIPTION
ProductIDShows the product’s SKU.
Product NameShows the product’s name.
LOCShows the product’s Location Notes set on the product page > Inventory > General.
VendorShows the product’s vendor.
Vendor SKUShows the vendor SKU.
OnOrderShows the product quantity ordered from a vendor but not received yet.
Qty AvailShows the quantity available in sellable warehouses or the specific warehouses selected in the filters.
Low Stock NoticeShows the product quantity threshold set to trigger a low stock notice alert.
Req. QtyShows the quantity required to fit all criteria to fulfill orders and increase inventory.
QtyPerCaseShows quantity per case, as set on the product’s Toolbox > Purchasing menu.
BuyerShows the buyer’s email address.
ReplacementsShows 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