To help retailers improve cash flow and reduce unnecessary reordering, Franpos now offers a Smart Inventory Transfer strategy. This feature helps you move products from low-performing stores to high-performing locations based on real sales data.

This option is available directly on the Stock Transfer page under:
Load using Smart Transfer Logic

What Problem Are We Solving?

Retailers often face this situation:

• One store is sitting on excess inventory
• Another store is running out of the same item
• The second store places a new purchase order

This leads to:

• Cash tied up in overstocked items
• Missed sales opportunities in fast-moving locations
• Poor inventory turnover

Our goal: Suggest intelligent transfers based on recent sales trends and current store inventory, so you make better use of the stock you already own.

How It Works

When creating a Stock Transfer, select:
Load using Smart Transfer Logic

You will define:

• Source Store – Location with excess inventory
• Target Store – Location where the product is selling better
• Sales Duration – Period used to measure sales trends (e.g., 4 or 8 weeks)
• Minimum Weeks of Inventory to Keep at Source – How many weeks of stock to keep at the source store

The system analyzes:

• Sales performance in both stores
• Current on-hand quantities
• Configured Min/Max levels (if set)
• Sales velocity (units sold per week)

It then determines:

• How much inventory can safely leave the source store without causing shortages
• How much the target store needs to support demand

Handling Missing Min / Max Quantities

If Min/Max quantities are not configured, Smart Transfer uses safe defaults so the feature can still work:

• If Target Max Qty is missing: Smart Transfer estimates a target maximum as Sales Velocity × Buffer Weeks.
• If Source Min Qty is missing: The system treats it as 0 (so transfers are not blocked by missing Min).

Only meaningful and actionable transfer quantities are suggested.

How the Math Works (Per SKU)

Smart Transfer calculates a recommended transfer quantity using sales velocity, current on-hand inventory, Min/Max settings, and your Buffer Weeks.

Variables Used:

• Weeks = Sales Duration (e.g., 4 or 8)
• BufferWeeks = Minimum Weeks of Inventory to Keep at Source
• OnHand_Source, OnHand_Target = current stock in each store
• Min_Source = Min Qty at the source store (if missing, treated as 0)
• Max_Target = Max Qty at the target store (optional)
  

Step 1: Calculate Sales Velocity

SalesVelocity = TotalUnitsSold / Weeks

Example:
If a SKU sold 24 units over 8 weeks, then:
SalesVelocity = 24 / 8 = 3 units per week

Step 2: Calculate Transferable Quantity (Source)

The source store can transfer stock only if it can keep enough inventory to cover: Min Qty + BufferWeeks of demand.

TransferableQty = OnHand_Source − Min_Source − (BufferWeeks × SalesVelocity_Source)

Example:
OnHand_Source = 50, Min_Source = 10, BufferWeeks = 4, SalesVelocity_Source = 3
TransferableQty = 50 − 10 − (4 × 3) = 50 − 10 − 12 = 28
→ Source can safely transfer up to 28 units.

Step 3: Calculate Needed Quantity (Target)

The target store “needs” stock based on Max Qty (if configured) or a safe estimate if Max is missing.

If Max Qty is configured:

NeededQty = Max_Target − OnHand_Target

If Max Qty is NOT configured:

EstimatedMax_Target = BufferWeeks × SalesVelocity_Target

NeededQty = EstimatedMax_Target − OnHand_Target

Example A (Max configured):
Max_Target = 40, OnHand_Target = 18
NeededQty = 40 − 18 = 22

Example B (Max missing):
BufferWeeks = 4, SalesVelocity_Target = 6, OnHand_Target = 18
EstimatedMax_Target = 4 × 6 = 24
NeededQty = 24 − 18 = 6

Step 4: Final Suggested Transfer Quantity

SuggestedTransferQty = MIN(TransferableQty, NeededQty)

If SuggestedTransferQty > 0, the SKU is shown as a recommended transfer.

Full Example:
TransferableQty (Source) = 28
NeededQty (Target) = 22
SuggestedTransferQty = MIN(28, 22) = 22
→ Recommend transferring 22 units.

Business Benefits

• Avoid unnecessary reordering
• Improve inventory turnover
• Free up cash tied in dead stock
• Respond quickly to demand shifts
• Reduce markdown risk

Tips for Success

• Run Smart Transfer weekly or bi-weekly
• Use a 4-week sales window for most products
• Adjust Buffer Weeks by category:
  • Fast-moving items → lower buffer
  • Seasonal or slower goods → higher buffer