...
Once you have your dead stock under control. You need to get a finer understanding of your live stock. not all live stock is the same. Some live stock is core range, other live stock is less important, such as endless isle stock. Getting a better understanding of your stock can help you get the most of of the money you have tied up in stock.
Procedure
Select inventory then products from the navigation panel. Then from the product list view, create a series of view variants to help you better understand your stock:
- Dead stock, products that are just about never selling. Discussed separately, see, How can I free up cash and space currently tied up in dead stock.
- Obsolete products, products that you can't buy anymore
- Create a view variant "Discountined stock". Then apply the filter below:
| Info |
|---|
[Status] = 'Discontinued' And [Qty on Hand] > 0.0m |
| Expand | ||
|---|---|---|
| ||
|
- Store products, products that are not by default displayed on the website
| Info |
|---|
[Catalogue Lines][].Count() = 0 And [Category.Category Type] = 'Stock control products' And [Qty on Hand] > 0.0m |
| Expand | ||
|---|---|---|
| ||
|
- Endless isle products, extra products beyond the core range
| Info |
|---|
[Catalogue Product] = False And [Catalogue Lines][[Catalogue.Catalogue ID] = 'WEB01'].Count() = 0 And [Category.Category Type] = 'Stock control products' And [Qty on Hand] > 0.0m |
| Expand | ||
|---|---|---|
| ||
|
- Web01 products, products displayed on the website, not not regarded as core range catalogue products
| Info |
|---|
[Catalogue Lines][[Catalogue.Catalogue ID] = 'WEB01'].Count() > 0 And [Category.Category Type] = 'Stock control products' And [Qty on Hand] > 0.0m |
| Expand | ||
|---|---|---|
| ||
|
- Catalogue products, core product lines
...
| Info |
|---|
[Catalogue Product] = True And [Category.Category Type] = 'Stock control products' And [Qty on Hand] > 0.0m |
| Expand | ||
|---|---|---|
| ||
|
- Products that used to be on a corporate catalogue but have now been moved to web01 or endless isle
- Other more detailed combinations are possible. Showing you recent history. Such as which products used to be catalogue products but are not catalogue products now. Products which used to be catalogue lines but which are now web01 or endless isle.
| Info |
|---|
[Catalogue Product] = False And [Catalogue Lines][[Catalogue.Catalogue ID] = 'WEB01'].Count() > 0 And [Catalogue Lines][[Catalogue.Catalogue ID] = 'CC08''].Count() > 0 And [Category.Category Type] = 'Stock control products' And [Qty on Hand] > 0.0m |
| Expand | ||
|---|---|---|
| ||
|
- For example the filter can:
...