(in process)Inventory Aging
- Akanksha Srivastava (Unlicensed)
The inventory aging analysis determines the storage duration of an item. That is, for how long a given item quantity is in storage. Inventory aging help you to know:
the number of units in each age group.
Estimated LTSF(Long Term Storage Fee) amount for those units (assuming no further sales).
Your recent sales performance for each SKU.
Opportunities for you to increase traffic or sales conversion to help you sell your aged inventory.
This article will help you to know below:
Determining inventory aging
View and filter inventory aging
Download inventory aging report.
💡Inventory aging is available only for base products and kits. For virtual combo, you’ll not be able to see inventory aging. To check the inventory aging of the virtual combo, you can check the inventory aging of its components.
Determining inventory aging
Inventory age is based on the number of days a unit is kept in the Eshopbox fulfilment center. Eshopbox accounts for inventory on a FIFO basis across the entire fulfilment network. This means that each sale or removal will be applied to the inventory that has been in the Eshopbox network the longest. This is regardless of which physical unit was actually shipped or removed.
Any product with at least one unit available for sale in the Eshopbox fulfilment center is shown in the Inventory Age view.
View and filter inventory aging
You can view inventory details on the dashboard and inventory aging listing page of your workspace
Dashboard: You can view a summary of your inventory age. This is the combined view of your total inventory at Eshopbox for all FCs. Here you can view the below details:
Days: The number of days is categorized into four groups. 0-90, 91-180, 181-36 and 365+. For example, the inventory is in Eshopbox for the last 50 days, so that inventory aging will fall under the 0-90 category.
Units: Number of units per age group.
Percentage: The percentage of inventory with respect to total inventory in each group.
Listing Page: To view the full inventory aging details, navigate Inventory>Inventory aging. From the filter, select the warehouse name for which you want to view the inventory aging. You can choose one warehouse at a time. If you wish to view all the inventory, Click on all.
Now, you will able to see inventory aging details on the main pane. You can view the below details:
Status: This is the status of the product. There can be 2 types of status:
Available: The product is which are available in Eshopbox.
Out of stock: The product is not available in Eshopbox.
Image: Image of the product.
Product name: The name of your product.
Name of the product(SKU): The SKU (Stock Keeping Unit) is a unique name for your product against which you want to send the inventory.
ESIN: Eshopbox generated product identification number against which you want to send inventory.
Sales: By default, it will reflect the sales of your product for the last 90 days. That means the number of units shipped from Eshopbox in the last 90 days. On click/hover on the number, you can see age group wise sales and unit shipped summery. Here, you can view the below details:
Days: The days are categorized into groups.
Total sales in Rs: Total sales cost in a group.
Unit: Number of units sold per group.
Available: The number of units that are available at FC. The total number of units will be mentioned. On hover, you can see the below details:
Available quantity: The number of units in inventory available for purchase.
Pending removal quantity: The number of units in inventory that you have requested to recall.
Inventory age: Shows a breakdown of the units by age group. Eshopbox separates your units into the following age groups: 0 – 90 days, 91 – 180 days, 181 – 270 days, 271 – 365 days, and 365+ days. For example, the inventory age is between 0-90 days. This means The number of sellable units that have been in the fulfilment center for the last 0–90 days.
Est LTSF(Long term storage fees): Shows the estimated long-term storage fee amount incurred on the next charge date (the 15th of each month) and the number of units subject to the fee, assuming no further sales or removals of the item. Know mote about LTSF.
Your price: Your listed price.
Action: You can perform the below actions on the inventory.
Lower Price: This product has a low conversion rate, meaning that customers are looking at the listing but not following through and buying the product. Lowering prices can help improve conversion rates.
Create Removal order: Estimated quantity of inventory that would likely benefit from removal instead of being charged storage fees.
Status | Image | Product name | Sales | Available | Inventory age | Est LTSF | Your price | Actions |
|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Download report
If you have a large number of products, and you would want to do some advanced analysis on this data set. You can download your inventory aging report with the help of the 'download' button on the top right.
Click on 'download' and submit your request. You will get a notification when your file is ready. You can also navigate to files on the menu to get your files. You can download the file for the next 48 hours.
💡 Use filters to get a specific set of records. Eshopbox workspace will ask you to confirm your download, make sure you have selected only relevant data.
About your download file
Your downloaded file displays your essential information about your inventory again. Your downloads are only available in CSV format. Each line of the downloaded file represents a single product.
What's included
SKU
ESIN
Available Quantity
Removal in progress
age 0-90
age 91-180
age 181-270
age 365 plus
units-shipped-last-7-days
units-shipped-last-30-days
units-shipped-last-60-days
units-shipped-last-90-days
Est LTSF
Your price