Plan a bookstore reorder
Use Kestrel when you have a sales and stock export and want to review the next buy by title. You choose the coverage, quantities and budget. Approval saves your decision; the CSV goes into your existing supplier process.
1. Create your store
Sign in or create an account, then name your bookstore and choose USD, CAD or GBP. One account has one store. The store currency applies to every imported unit cost and plan; Kestrel does not convert currencies.
2. Prepare and import the CSV
Include a header row and up to 500 titles in a file smaller than 500 KB. Match each of these seven fields to a column, then choose the date the stock export represents:
- ISBN: a 10 or 13 character ISBN. Hyphens and spaces are normalized; each ISBN must be unique.
- Title: the book name.
- Units sold: a whole, nonnegative quantity during the observation window.
- Observation days: the positive number of days covered by those sales.
- On hand and on order: whole, nonnegative quantities. Use an explicit zero when none are held or incoming.
- Unit cost: your purchase cost, with at most two decimal places and no currency symbol.
This small example is formatted for import:
ISBN,Title,Units sold,Observation days,On hand,On order,Unit cost 9780141321066,The Secret Garden,12,28,3,1,7.50
Fix duplicates, missing values and invalid numbers before saving. The preview shows the first ten valid titles; validation checks every row. A saved snapshot cannot be edited. Import a new snapshot when the source changes.
3. Review the calculation
Create a reorder plan from the saved snapshot. Coverage is lead time + review interval + safety days. For each title, the starting quantity is sales × coverage ÷ observation days, rounded up, minus on hand and on order, with a minimum of zero.
For the row above and 28 coverage days, that is 12 − 3 − 1 = 8 copies, or $60 at a $7.50 unit cost. This is an arithmetic starting point. Stockouts, seasonal events and short sales windows can distort the observed rate. Review the visible data flags and use your knowledge of the store.
4. Make the buying decision
Change quantities, exclude titles and save a buying reason beside each edit. Set a budget in your store currency. You can save an over-budget draft, but approval is blocked until its subtotal fits the cap. Freight and tax are not included. Saving from an outdated browser tab is rejected so it cannot overwrite a newer revision.
5. Approve and export
Approval freezes the plan, its inputs and buying decisions. Export includes only included titles with positive quantities, with ISBN, title, quantity, unit cost, line cost, currency and buying reason. To revise an approved plan, create a new draft from it. The original remains available.
The file is a generic CSV, not an order sent to a wholesaler. Confirm your supplier’s required columns and quantities before placing an order. Kestrel has no public API, direct POS sync, supplier connection or autonomous purchasing service. Accounts and saved inventory are private; automation uses the same signed-in browser workflow as a buyer.
Contact Kestrel if an import or plan does not behave as described.