Understanding Inventory status

Understanding Inventory status

Inventory status refers to the current state of an item present in the inventory. This includes information such as quantity available, location, and any issues or discrepancies that may need to be addressed.

You can also view the detailed categorization and analysis of the current status of items in inventory. Learn here about the inventory status breakup.

Keeping track of inventory status is crucial to ensure efficient and accurate inventory management and to monitor stock levels.

In this article, you will learn about the inventory statuses used by Eshopbox.

Overview of inventory statuses

  1. Inward in progress

  2. Outward in progress

  3. Sellable

  4. Non-sellable

  5. Under investigation

1. Inward in progress

These items are currently being received, signifying a temporary state before they are fully stored on the shelf.

Inward in progress consists of the sum total of inventory in the below-mentioned stages.

1.1 Consignments pending to inward: Consignment Items have been received at the fulfilment location, but the quality check is pending. To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Consignments > All Consignments.

  • Step 2: Apply the filters for the status as Delivered and the location where you want to reconcile the pending inward.

  • Step 3: Export the consignments, and then calculate: [(Pending quantity + Received quantity) − (Accepted quantity + Rejected quantity)]

1.2 Consignments pending for putaway: Consignment items that are not yet stored on the designated storage location post quality checks. To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will redirected to the Manage Inventory page. Select Putaway inventory. You will be redirected to the
    Putaways page.

  • Step 3: Click on Putaway items. You will be redirected to the Putaway items page. Select ESIN from the dropdown.

  • Step 4: Apply the filters for the status as Pending and Putaway type as Sellable Inwards.

1.3 Cancelled items pending for putaway completion: Items were picked up to process an order, but the order was cancelled. To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will redirected to the Manage Inventory page. Select Putaway inventory. You will be redirected to the Putaways page.

  • Step 3: Click on Putaway items. You will be redirected to the Putaway items page. Select ESIN from the dropdown.

  • Step 4: Apply the filters for the status as Pending and Putaway type as Sellable cancelled items


1.4 Cancelled items pending for putaway creation: Items were picked up to process an order, but the order was cancelled and putaway is still not created. To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Orders > Process orders.

  • Step 2: You will be redirected to the Shipments page. Click on Order items.

  • Step 3: On the Order Items page, click More Filters, select Workspace, and apply the following filters:

    • Previous Status: Picked/Packed

    • Putback Status: Pending to Create

      Apply the filters and export

  • Step 4: Return to the Shipments page. Click More Filters, select Workspace, and apply the following filters:

    • Previous Status: Picked/Sidelined on Pack
    • Putback Status: Pending to Create

      Apply the filters and export
  • Step 5:  Perform lookup on both exported files using the Shipment ID. Match the Shipment IDs between shipment and order item data and consider the matching count.

1.5 Returns pending for putaway: Consignment items that were received as returns and are pending to be stored or packed as removal. To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will redirected to the Manage Inventory page. Select Putaway inventory. You will be redirected to the Putaways page.

  • Step 3: Click on Putaway items. You will be redirected to the Putaway items page. Select ESIN from the dropdown.

  • Step 4: Apply the filters for: Status as Pending and Removal status is not completed and Putaway type as Return Sellable Items.


    Note: There can be certain instances when an unknown item is received in a consignment or in return. An unknown item means that Eshopbox was unable to identify the product SKU as the tag was missing or the product with the mentioned SKU was not created on the workspace. This ESIN is added to the inventory with a new SKU as IR_workspaceslug. You take this inventory for reconciliation purposes as well.

    For example, if your workspace name is Kapaskraft, then the inventory for an unknown item will be added with the SKU IR_kapaskraft.

1.6 Shelf transfer pending: Consignment items that are pending to be stored after internal shelf transfer. To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will redirected to the Manage Inventory page. Select Putaway inventory. You will be redirected to the Putaways page.

  • Step 3: Click on Putaway items. You will be redirected to the Putaway items page. Select ESIN from the dropdown.

  • Step 4: Apply the filters for the status as Pending and Putaway type as Shelf transfer: Sellable to Sellable, Shelf transfer: Sellable to Non-sellable, Shelf transfer: Non-sellable to Sellable, or Shelf transfer: Non-sellable to Non-sellable, along with ESIN.

2. Outward in progress

Outward in progress is the total inventory count picked from their storage locations and ready for packaging and labelling for delivery.

Outward in progress consists of the sum total of inventory in the below-mentioned stages.

2.1 Orders pending to pack: This is the number of items reserved for B2C orders prior to the packing process. It includes orders in New, Processing, and On hold statuses. It also includes the B2B orders, which are in created, picking, or picked status.

Note: This does not include the orders marked as unfulfillable.

To reconcile this, you need to follow the below-given steps:

  • Step 1: Login to brand workspace. In the header, go to Orders > All Orders.


  • Step 2: On the All Orders page, apply the Current Status filter, select New, On Hold, and Processing, and then click Apply Filter.



  • Step 3: Click Export.


  • Step 4: Select Sales Report, and then select the Split virtual kit orders into its components checkbox.


  • Step 5: Click Export CSV.



2.2 B2B order items pending to pack: All B2B orders that are in Created, Processing, picking or picked status. To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Orders > Process B2B orders.

  • Step 2: You will be redirected to the Confirm B2B Orders. Click on Create Picklist.

  • Step 3: You will be redirected to the B2B Shipments page. Click on Order items B2B.

  • Step 4: You will be redirected to the Order items (B2B) page. Apply the filter of Order item status as Created, Picking and Picked.

    Note: Temporary discrepancies may occur when an order is partially packed, as some items may be packed while others are still pending.

2.3 Removals pending to pack: This is the number of recall consignments which are in Processing, picking or picked status.

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Remove inactive inventory > All removals.

  • Step 2: You will be redirected to the All Removals page. Apply the filter of status as Processing and export the CSV.

  • Step 3: You need to reconcile the Shipped quantity and In-process quantity to get the total sum.

3. Sellable

Sellable refers to the inventory that is in prime condition, meets stringent quality standards, and is readily available for direct sale to customers.

To reconcile the sellable inventory, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will be redirected to the Inventory Snapshot page. Select the location for which you want to view the sellable inventory.

  • Step 3: Apply the filters for Inventory type as Sellable and Available is not 0.

4. Non sellable

Non-sellable refers to inventory that is not suitable for direct sales due to being damaged or expired. These items require specific handling procedures such as returns processing or proper disposal.

Non sellable consists of the sum total of inventory in the below-mentioned stages.

4.1 Items crossed stop ship date

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will redirected to the Inventory Snapshot page. Select the location for which you want to view the sellable inventory.

  • Step 3: Apply the filters for ESIN, and Expired quantity is > 0.

You can also export the batch-wise inventory report to reconcile the same. Learn here how to export batch-wise inventory reports

4.2 Inward items failed quality check pending for putaway

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will be redirected to the Inventory snapshot page. Click on Putaway inventory.

  • Step 3: You will be redirected to the Putaways page. Click on Putaway items.

  • Step 4: You will be redirected to the Putaway Items page. Apply the filter for removal status as Pending and Putaway type as Non sellable inwards.

4.3. Return non sellable items
 4.3.1.  To calculate Return non sellable count

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will be redirected to the Inventory snapshot page. Click on Putaway inventory.

  • Step 3: You will be redirected to the Putaways page. Click on Putaway items.


  • Step 4: You will be redirected to the Putaway Items page.

  • Step 5: Apply the following filters:

    • Removal Status: Pending
    • Putaway Type: Return Non-sellable items

  • Step 6: Apply the filters and Export.

4.3.2. To calculate bad inventory count

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will be redirected to the Inventory Snapshot page. Select the location for which you want to view the sellable inventory.

  • Step 3: Apply the filters for ESIN, Inventory type as Non sellable and Available is not 0.

    Note: Sum of the above two categories (4.3.1 & 4.3.2) will match with the return non sellable item count on UI.

4.5. Transferred non sellable items

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.
  • Step 2: You will be redirected to the Inventory snapshot page. Click on Putaway inventory.
  • Step 3: You will be redirected to the Putaways page. Click on Putaway items.

  • Step 4: You will be redirected to the Putaway Items page. Click More Filters, select Workspace.
  • Step 5: Apply the following filters:
    • Removal Status: Pending
    • Putaway Type: Non-sellable Batch Items
  • Step 6: Apply the filters and Export.

  • Note: There can be certain instances when an unknown item is received in a consignment. An unknown item means that Eshopbox was unable to identify the product SKU as the tag was missing or the product with the mentioned SKU was not created on the workspace. This ESIN is added to the inventory with a new SKU as IR_workspaceslug.

    You take this inventory for reconciliation purposes as well. The inventory type for such items will be Incorrect GRN items.

    For example, if your workspace name is Kapaskraft, then the inventory for an unknown item will be added with the SKU IR_kapaskraft.

5. Under investigation

Under investigation refers to the inventory that is currently under investigation due to their unavailability during picking or cycle count on their designated storage location.

5.1. Excess found

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will redirected to the Inventory Snapshot page. Click More Filters, select Workspace.

  • Step 3: Apply the following filter:

    • Excess found: Greater than 0

  • Step 4: Apply the filter and Export

  • Step 5: Combine the excess quantity.


5.2. Not found

To reconcile this, you need to follow the below-given steps:

  • Step 1: From the header, navigate to Inventory > Manage Inventory.

  • Step 2: You will redirected to the Inventory Snapshot page. Click More Filters, select Workspace.

  • Step 3:  Apply the following filter:

    • Not found: Greater than 0

  • Step 4: Apply the filter and Export
  • Step 5: Combine the not found quantity.