FOVERA · FC Consignment Planner

Sign in

Cloud-synced planner. Use the account created for you in Supabase.

All uploads and settings are stored in your private Supabase database. Only signed-in users can read or write.

FC Consignment Planner

Drop your Flipkart sales, inventory and in-transit exports. Get an FC-wise, SKU-wise send plan.

1 · Sales
Drop sales report here
Flipkart Seller Hub export with Order Date, SKU, Location Id and Final / Gross Units
2 · Inventory
Drop current inventory here
Current-Inventory export with Warehouse Id, SKU and Live on Website
3 · In-transit
Add in-transit shipment
Filename becomes the Shipment Code. Drop multiple files to add more shipments. Same-named upload replaces the existing one.
4 · SKU values (INR)
Drop SKU value file here
Excel / CSV with columns: SKU · Value (INR per unit) · Status (Active / Discontinued, optional). Prices SOH, in-transit, supply and overstock, and tags every row.

Planning inputs

Where each FC stands

Under 15 days Below target At target Overstocked Share of SKUs stocked at each FC, by days of cover.

Shipment manager

Select one or more files at a time — each file becomes its own shipment, using its filename as the Shipment Code. Re-uploading with the same filename replaces that shipment; changing status to Completed takes it out of the DOC calculation (it stays in the database as history).

How the numbers are worked out

FC DRR is that FC's units sold in the window ÷ the window length. Non-FC DRR is that FC's share of the SKU's non-FBA (self-ship) units. The share is the FC's slice of the same SKU's FBF sales; if the SKU had no FBF sales anywhere, the non-FBA units are split by each FC's share of overall (all-SKU) sales.

Total DRR = FC DRR + Non-FC DRR. SOH = Live on Website from the inventory file. Intransit Units = the sum of Intransit Quantity rows for that FC × SKU across every Shipment Code in the in-transit file.

DOC (days of cover) = (SOH + Intransit) ÷ Total DRR. Target Qty = Total DRR × Required cover. Qty to Supply = Target − SOH − Intransit, floored at zero, rounded up to your min-qty multiple, then dropped if it falls below your don't-process threshold.

Overstock is SOH + Intransit − Total DRR × Overstock days at that FC.