Free Black Friday Inventory Planner Template
Get your stock and pricing ready for Black Friday. Copy this free template in one click, then ask Teable Agent to adapt it to your products, warehouses and cost rules.
Plan stock and discounts in one workspace
A Black Friday discount works best when you have enough stock to fulfill it and enough margin to make it worthwhile. This free inventory planner connects supplier lead times, stock assumptions, purchase arrivals and discount scenarios so you can review those decisions together.
Start with the fictional Northstar Home shop, replace its example figures, and keep your team working from the same stock plan. Use it as it is or describe your business requirements to Teable Agent to build the fields, views and calculations you need.
What is inside the free template
Four connected working tables, a Start Here guide and a dashboard give you a practical starting point.
BFI Suppliers
Keep supplier details, peak lead times and minimum order assumptions together.
- Three fictional suppliers to replace with your own
- Review lead times before committing to launch dates
BFI Stock Plan
Turn campaign assumptions into planned demand, stock shortfalls and suggested order quantities.
- Five sample products
- Reorder queue and order-by dates
- Input checks for incomplete or invalid assumptions
BFI Purchase Orders
Track ordered and received units alongside expected arrival dates.
- Partial receipts and outstanding units
- Late-arrival review before the campaign starts
BFI Discount Scenarios
Compare six sample pricing scenarios using product costs, fees, fulfillment and advertising assumptions.
- Contribution profit and margin
- Review loss and below-target scenarios separately
Free Black Friday Inventory and Profit Template
Review stock readiness, supplier planning, arrivals and discount profitability in an English dashboard.
- Overview, stock, suppliers, purchases and discounts sections
- Copy ready-to-use customization prompts for Teable Agent
Stock planning fields that are ready to use
Enter your assumptions; formula fields calculate the planning outputs.
| Field | Type | How to use it |
|---|---|---|
| Campaign Start | Date | Set the date orders need to be ready for. |
| Normal Daily Units | Number | Establish your usual demand before applying campaign uplift. |
| Uplift Factor | Number | Model the change in demand you expect during the promotion. |
| Confirmed Inbound | Number | Enter a dated snapshot of stock already on its way. |
| Shortfall Units | Formula | See demand plus safety stock that current supply does not cover. |
| Suggested Order Units | Formula | Review an order quantity that respects the minimum order assumption. |
| Order By | Formula | Work back from campaign start using the lead time. |
| Input Check | Formula | Find incomplete or invalid assumptions before using a result. |
Make inventory decisions with clearer assumptions
Keep the inputs and their consequences visible to the team.
Connected stock and pricing plans
Review suppliers, demand, inbound orders and discount economics together.
Order before the deadline
Use order-by dates and late-arrival views to prioritize supplier follow-up.
Compare contribution margins
Include entered product, fee, fulfillment and ad costs when reviewing each scenario.
Who this template is for
A starting point for teams preparing a seasonal product promotion.
Online stores
Plan stock and pricing across your Black Friday product selection.
Operations teams
Coordinate supplier follow-up, inbound arrivals and purchasing reviews.
Small retailers
Replace scattered stock and discount sheets with one shared plan.
How to use the free inventory planner
Start with a working example and adapt it to your business.
- 1
Use the free template
Click Use template and choose your Teable workspace to create your own copy.
- 2
Replace the sample data
Open Start Here. Add your products, suppliers, lead times and stock snapshot using one currency.
- 3
Review stock and margins
Check input warnings, reorder quantities, arrival dates and discount scenarios before choosing your plan.
- 4
Customize with Teable Agent
Tell the agent what your business needs. It can build the fields, views, calculations and app changes in your copy.
Tell Teable Agent what your business needs
The template is ready to use and open to change. Describe your workflow to Teable Agent and let it build your customization directly in the workspace.
Plan across warehouses
Adapt your stock workflow to multiple locations.
Include your packaging costs
Extend contribution calculations with a cost your business tracks.
Review supplier delays
Create a focused view for purchasing follow-up.
Frequently asked questions
Is this Black Friday inventory planner free?
Yes. The template is free to copy and customize. Teable account limits and optional AI or app usage depend on your chosen plan.
Can I customize it for my own business?
Yes. Edit the tables yourself or tell Teable Agent what you need. For example, ask it to add warehouse locations, packaging costs or purchasing review views.
Does it place purchase orders or sync my store inventory?
Enter stock and inbound figures in the template and reconcile them with your purchasing records. Use your purchasing and sales tools to place orders and publish prices.
How is contribution profit calculated?
Each discount scenario uses your entered sales, product cost, fees, fulfillment and advertising assumptions. Review those inputs and your target margin. Fixed overhead and tax are outside the included calculation.
More free business templates
Start your Black Friday plan for free
Use this free template in one click. Tell Teable Agent what your business needs to make it yours.
