Apparel stock availability and reservation management system

The buyer and consultant see the availability of a specific size and color. When calculating the amount offered, bookings, transfers, and sale of ineligible goods are evaluated.

The availability calculation does not always distinguish between reservations, unverified returns and goods moved between locations. A unit seen in the system is not necessarily ready for sale. The size or color ordered by the buyer is not found in the store. It is necessary to combine an alternative, cancel the purchase or ask for a wait, although the initial offer showed an affordable item.

How the solution works

  1. When asked for the selected size and color, the stock is sold
  2. Reservation confirmed at specific pick-up point
  3. The employee collects the item or registers the non-conformity
  4. If the customer does not show up, the reservation is released according to the set deadline

Key challenges

  • The displayed option balance doesn't always mean actual availability

Solution capabilities

Balance by variant and location

Availability is calculated for a specific SKU rather than a common model.

Sales volume rule

The amount displayed by the channel may be more conservative than the accounting balance if the risk of physical accuracy is high.

Reservation

Reservations for a specific unit or quantity are protected from other sales under agreed rules.

Handling discrepancies

If the item is not found, the store must quickly mark the discrepancy and offer another location or option.

Business context

The displayed option balance doesn't always mean actual availability
The availability calculation does not always distinguish between reservations, unverified returns and goods moved between locations. A unit seen in the system is not necessarily ready for sale. The size or color ordered by the buyer is not found in the store. It is necessary to combine an alternative, cancel the purchase or ask for a wait, although the initial offer showed an affordable item.
The search ends with the product actually received
The buyer can refuse the order if it turns out to be no size after the choice. The condition of the evaluated reservation and goods allows for more reliable availability. The consultant may offer another store or option while the customer is still making the purchase decision.

Core features

  • Balance by variant and location
  • Sales volume rule
  • Reservation
  • Handling discrepancies

Key integrations

ERP or stock system
Accounting balances and commodity movements.
Point-of-sale system (POS)
Sales and returns in the store.
E-commerce platform
Accessibility request and customer reservation actions.
Store staff workspace
Finding, confirming and registering non-compliance.
Warehouse System
Central warehouse balance and carry-overs.

Potential impact (%)

The ranges indicate an illustrative relative change in the metric under the stated assumptions. Results depend on the starting position and actual use of the solution. Percentages for different metrics must not be added together.

Share of reservations that the store cannot meet due to unfound goods

12–42%Decreasing

This illustrative scenario assumes that 30-60% of errors can be addressed through the data and rule checks described. That share is assumed to fall by 40-70%. Company data is needed to verify both the addressable share and the resulting change.

The portion of reservations that had to be cancelled is calculated because the promised option was not actually available. The percentage is calculated on the number of all bookings made.

Share of manual calls or queries to stores for a specific option balance

12–42%Decreasing

This illustrative scenario assumes that 30-60% of errors can be addressed through the data and rule checks described. That share is assumed to fall by 40-70%. Company data is needed to verify both the addressable share and the resulting change.

Employee contacts with another location are counted, the purpose of which is to verify the availability of one particular SKU. The percentage is calculated on the number of all requests for availability of the item.

Share of missing size requests completed by purchase

9–37%Increasing

Sample starting part - 30%. Assumption: 20-40% of the remaining cases relate to unproposed size in another store; a solution would help resolve 20-40% of these cases.

Orders executed are divided by all requests for size not available locally but available on the network. Transfer of stocks without a completed purchase is not counted.

Conditional calculation scenarios. The assumptions have not been validated against client measurements.

When this solution is relevant

  • Many stores and one common e-commerce channel
  • Customers check size availability before going to the store
  • Used reservations, click-and-collect or goods transfers
  • The physical and systemic balance by variant is periodically mismatched

Implementation requirements

Stores, internet and metering reservations are compatible for availability management. There is agreement when a product is blocked for another sale, which confirms its finding and when the amount not withdrawn is released.

Further development options

  • Use of physical identification data for goods
  • Evaluation of the time of booking preparation by store

Frequently asked questions

Adapting the solution to your business