Proposal For Stock Level online & By Location
This proposal covers the scope of showing the “Coolants” category for logged-in customers and for each “Coolants” code/item, we need to show a table that contains location, Available, and In Progress in the table.
Requirement
The requirement is to display the stock level information for the items in the “Coolants” category for the logged-in customer, which having the Location, Available, and In-Progress in it. We need to condense all locations into the main city
Our Solution
- We will add the table in the PDP page that are available in the “Coolants” category, in which the table contains Location, Available, and In Progress, the sample is given as below.
- If there more than one location it will be listed in the table.
Location – Item Record, Purchasing/Inventory Tab – Location Column
In Progress – Item Record, Purchasing/Inventory Tab – Location Row, Quantity in Progress Column
Available – Item Record, Purchasing/Inventory Tab – Location Row, Quantity on Hand Column
- We will create a configuration field for the coolant category to make it configurable for each website. Here we need to specify the coolant category URL to get used in the code.
If we consider the location,
- First, we need to determine whether there is a parent-child relationship for the locations in the location record before condensing the location into the main city and displaying it in the table.
- We will consider the “Parent location” field as the main city and display the location on the table. And for quantity, we will show the sum of the quantity available in the sub location that is under the parent location.
Assumption
- We assume that Available and In-Progress values will be there for all items.
- We assume that all of the item’s locations are available in the webstore or online.
- We assume that there is a parent-child relationship between the locations so we can condense them into a main city and display them in the information section.