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

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 consignments and get the sum of the pending 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: You will be redirected to the Order items page. Apply the filter of Order item status as "Cancelled" and Putback status is "Pending to create"

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 or Return Non-sellable Items with ESIN.

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: From the header, navigate to Orders > Process orders.
Step 2: You will be redirected to the Shipments page. Click on Order items.
Step 3: You will be redirected to the Order items page. Apply the filter of Order item status as Created, Picking and Picked.

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.

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 failed quality check and putaway completed

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: 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.

4.2 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.3 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 status as Pending and Putaway type as Non sellable inwards.

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.

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.
Step 3: Apply the filter of the ESIN with Not Found > 0.

You can also reconcile this by navigating to the Not Found tab.

Note: In case you are reconciling the inventory for a specific workspace, you need to also check if any SKU is not getting missed when applying the workspace filter. You can cross check the same by exporting the SKU, where workspace is blank and checking if any SKU where workspace is blank is matching with the list of all products from that workspace. Please include these SKUs as well.