While most Shopify founders are buried in late November 2026 Black Friday traffic, operators who have been through a few Q1 cycles are already planning for early 2027 factory shutdowns across Asia. Miss those pre-holiday production cutoffs, and your bestsellers go dark in March and April. Chinese New Year (CNY) purchasing comes down to working capital. Order too little and you starve Q1 revenue while competitors pick up your customers. Double your usual POs across the board and you trap cash in slow-moving stock right when Q4 ad bills land. Native Shopify tools log supplier orders cleanly, though the actual replenishment math is still on you. You need a shopify purchase order template built around six-week supply chain gaps, factory minimums, and master-carton pack sizes. Here is the exact two-tab Google Sheets setup, holiday reorder formula, and cash-trimming process to size your pre-CNY buys properly. We will also cover where spreadsheets break at scale and how Monocle automates this workflow.
Why Chinese New Year Breaks Normal Shopify Reordering
Chinese New Year is a short public holiday on the calendar, yet on the factory floor the disruption lasts six to nine weeks. Production slows down two weeks ahead of the official break as line workers travel home to inland provinces. Factories then shut down completely for two to four weeks. After reopening, manufacturers still need two to three weeks to bring returning staff up to speed, clear raw material bottlenecks, and work through factory and port backlogs. In 2026, that extended freeze exposes a big gap for growing merchants. Teams moving off Stocky to native Shopify admin Purchase Orders (POs) quickly find out that Shopify admin works mostly as a record-keeping ledger. Shopify admin tracks what you bought, who supplied it, unit costs, and expected arrival dates. What it will not do is calculate the extended order quantities required to bridge a two-month manufacturing gap. For a $300k to $5M DTC brand, guessing those numbers hits both sides of the P&L. Placing standard two-week or four-week reorder batches leaves core SKUs (Stock Keeping Units) out of stock in March and April, right when Q1 ad costs drop. Over-ordering across the entire catalog does just as much damage. Slapping a flat 60-day buffer onto every variant ties up cash in slow-moving sizes and colors right after Q4 inventory payments drain your bank account. Say you manage 150 active variants with $80,000 in January cash on hand. Without SKU-level coverage math, supplier minimums on slow C-tier items can chew through half that budget while your top sellers run dry before the first post-CNY container arrives.
How to Build a Shopify Purchase Order Template for CNY in Google Sheets
Most free templates online fall short before you enter a single number. A quick search usually gives you static invoice layouts, a customer-facing shopify order form for all products in shop catalogs, or a printable shop policies template part of shopify planner bundle pdf downloads. Static forms only format a PDF once you already know your quantities. A working shopify purchase order template strategy separates your messy replenishment math from the clean purchase order you send to the factory. Before opening Google Sheets, spend ten minutes cleaning up Shopify Admin. Check the Vendor field on every product and standardize it to match the exact factory or supplier name. Once vendor labels match, you can export your Shopify variants, filter by factory, and roll every SKU into one consolidated PO per supplier. Grouping by supplier is the only practical way to check order-level minimums and plan container space. Set up your Google Sheet with two linked tabs. Tab 1 (Replenishment Math) stays strictly internal. Use it to clean daily sales velocity, extend your holiday order cycle, add safety stock, and run cash checks across every supplier SKU. Tab 2 (Supplier PO Document) pulls only finalized order lines with positive quantities from Tab 1 using `FILTER()` or `VLOOKUP()`. Export Tab 2 as a clean PDF so your supplier never sees your daily run rates or warehouse stock counts.
Essential Columns for Your Calculation & PO Tabs
Build Tab 1 (Calculation Tab) left to right with sixteen columns so each input feeds directly into the next calculation:
- Step 01SKU & Demand Inputs:`SKU`, `Variant Name`, `Supplier`, and `Adjusted Daily Sales` (cleaned of Q4 promos and stockout days).
- Step 02Timing Buffers:`Real Lead Time (Days)`, `Extended CNY Order Cycle (Days)`, and `Safety Stock` (in units).
- Step 03Current Stock Position:`On-Hand Inventory`, `Incoming Inventory` (confirmed open POs), and `Raw Order Qty`.
- Step 04Supplier & Cash Controls:`Supplier MOQ`, `Case Pack Size`, `Final Rounded Qty`, `Unit Cost`, `Line Total`, and `Days of Cover`.
Set up Tab 2 (Supplier-Facing PO Tab) as a ready-to-send factory purchase order with nine core fields:
- Step 01PO Header Details:`PO Number`, `Order Date`, `Committed Ship-Before-Cutoff Date`, and `Payment Terms` (for example, 30% deposit, 70% on Bill of Lading).
- Step 02Order Table Columns:`SKU / Barcode`, `Supplier Item Code`, `Final Case & Unit Qty`, `Unit Cost`, and `Extended Cost`.
Putting a Committed Ship-Before-Cutoff Date right on the PDF protects your Q1 schedule. You want the factory signing off that cartons will clear port customs before holiday trucking stops, rather than just finishing assembly on the last day before shutdown.
The CNY Order Quantity Formula (With a Worked Example)
Base your calculation tab on the Order Quantity Formula: `Daily Sales * (Real Lead Time + Order Cycle) + Safety Stock - Stock Position`. Here, `Stock Position` equals `On-Hand Inventory + Incoming Inventory`. In normal months, `Order Cycle` is just the number of days between reorders, usually 14 or 30 days. For Chinese New Year, you stretch `Order Cycle` to cover both the factory closure and post-holiday production and port recovery. Say your supplier shuts down for 21 days and needs another 16 days after reopening to clear backlogs and book vessel space. Add those 37 disruption days to a 7-day buffer after arrival, and you get an extended 44-day CNY order cycle. Take `SKU-101`, a steady seller moving 5 units a day. It has a 20-day real lead time, 35 units of safety stock, 60 units on hand, and 0 units incoming. On a normal 14-day cycle, raw demand is `5 * (20 + 14) + 35 - 60 = 145` units. Stretch `Order Cycle` to 44 days for CNY and raw demand jumps to `5 * (20 + 44) + 35 - 60 = 295` units. Next, layer in the factory's physical constraints. This supplier enforces a 100-unit MOQ (Minimum Order Quantity) and packs 24 units per master carton. Wrap your raw quantity in `MAX()` to clear the MOQ, then wrap that in `CEILING()` to round up to full cases. In a normal month, 145 units rounds up to 168 units (7 cases). For CNY, 295 units rounds up to 312 units (13 cases). Look at how that compares in Row 5 below with `SKU-204`, a 1-unit-per-day slow mover where the 100-unit MOQ pushes coverage out to 150 days:
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Row | A: SKU | B: Daily Sales | C: Real Lead Time | D: Order Cycle | E: Safety Stock | F: On-Hand | G: Incoming | H: Raw Order Qty | I: MOQ | J: Case Pack | K: Final Rounded Qty | L: Unit Cost | M: Line Total | N: Days of Cover |
| 2 | 2 (Formula) | SKU-101 | 5 | 20 | 14 | 35 | 60 | 0 | =MAX(0,B3*(C3+D3)+E3-(F3+G3)) | 100 | 24 | =IF(H3=0,0,CEILING(MAX(H3,I3),J3)) | $8.00 | =K3*L3 | =(F3+G3+K3)/B3 |
| 3 | 3 (Normal Cycle) | SKU-101 | 5 | 20 | 14 | 35 | 60 | 0 | 145 | 100 | 24 | 168 (7 cases) | $8.00 | $1,344 | 45.6 |
| 4 | 4 (CNY Extended) | SKU-101 | 5 | 20 | 44 | 35 | 60 | 0 | 295 | 100 | 24 | 312 (13 cases) | $8.00 | $2,496 | 74.4 |
| 5 | 5 (CNY Slow SKU) | SKU-204 | 1 | 20 | 44 | 10 | 30 | 0 | 44 | 100 | 24 | 120 (5 cases) | $12.00 | $1,440 | 150.0 |
Before sending any pre-holiday PO, run a cash-flow check. Multiply final units by unit cost across your sheet, sum Column M (`Line Total`), and check that figure against the cash you actually have available for deposits and balance payments. If the total comes in over budget, sort Column N (`Days of Cover`) from highest to lowest. Cut or push back high-cover items like `SKU-204` (150 days of cover) first instead of trimming units from fast movers that are close to stocking out.
Four Spreadsheet Mistakes That Ruin Q1 Inventory Position
Small spreadsheet shortcuts turn into real cash problems when you are buying ten weeks of stock in one shot. Check your sheet for these four pre-CNY mistakes before sending POs to your factories.
Rounding down to full case packs. When math outputs 295 units for 24-unit cases, operators often round down to 288 (12 cases) to save cash. Rounding down re-creates the exact shortage you are ordering to avoid. Rounding up to 312 just pushes your next spring order out by three days.
Trusting quoted lead times over Real Lead Time. Compare PO sent dates against warehouse received dates across your last three or four orders. That history reveals whether a supplier's quoted "30 days" actually performs at 30 +/- 2 days or 38 +/- 8 days, letting you size safety stock properly.
Using unadjusted Q4 sales velocity. Pulling raw November and December daily sales inflates CNY orders because Black Friday promos spike baseline demand. Conversely, ignoring Q4 stockout days artificially depresses daily averages on bestsellers that sold zero units only because shelves were empty.
Forgetting to log incoming inventory immediately. The moment you send a PO and record the supplier's committed delivery date, log those units in your `Incoming` column. Failing to track in-transit air or sea shipments right away causes expensive double-ordering before the holiday cutoff.
Where Manual Shopify Purchase Order Template Spreadsheets Break Down at Scale
A clean Google Sheet holds up fine when you manage 30 variants across one or two suppliers. Once you hit 500 to 5,000 variants across ten or more overseas factories, running reorders out of spreadsheets becomes a liability.
- Insight 01SKU and supplier sprawl:Exporting CSVs from Shopify, stripping promo spikes, and recalculating formulas across thousands of variants takes days. By the time you finalize ten supplier sheets, your live on-hand inventory counts have already shifted.
- Insight 02Flat rules during a cash crunch:Standard spreadsheet formulas apply identical coverage buffers to slow-moving C-items and high-margin A-items. Protecting top revenue drivers requires manually rebuilding ABC-XYZ classifications every single month.
- Insight 03Hidden component dependencies:Brands selling Shopify bundles or kitted multi-packs miscalculate raw factory demand in flat variant exports. Selling a kitted holiday set depletes shared child components without flagging the underlying component SKU cleanly.
- Insight 04Disconnected supplier follow-up:Chasing factory confirmations, tracking split sea-and-air shipments, and receiving partial containers across scattered email threads and PDF attachments guarantees stale spreadsheet numbers.
Stock levels shift every day during Q4. Working off a static mid-November CSV export leaves your ops team blind if a December sales spike wipes out your planned Q1 safety stock.
How to Automate Chinese New Year Purchase Orders in Monocle
Switching from manual spreadsheets to dedicated shopify purchase order template tools gets rid of fragile CSV exports during your busiest quarter. Monocle plugs straight into Shopify to automate demand cleanup, SKU prioritization, and supplier POs. Inventory software should show its math instead of burying assumptions in a black box. Here is how each step of the manual CNY spreadsheet maps into Monocle, plus the commercial calls you still make yourself.
Manual Spreadsheet Step vs. Automated in Monocle
Every calculation step from the two-tab Google Sheet maps straight to an automated workflow in Monocle:
Cleaning Q4 velocity & stockouts
Demand forecasting automatically corrects for out-of-stock days and supports promo and event tagging so BFCM spikes do not distort your Q1 baseline.
Prioritizing SKUs for CNY cash
Automatic ABC-XYZ classification of every variant (with configurable ABC segmentation) appears directly in the reorder table and inventory plan so you protect top revenue drivers first.
Calculating extended CNY coverage
AI-suggested reorder quantities based on target coverage days, backed by explainable reorder recommendations showing projected stock at PO arrival, coverage period, daily demand, and safety stock.
Grouping by vendor & checking MOQs
Automated purchase order suggestions use supplier lead time, forecast, and current inventory on a Reorders page grouped by supplier, complete with MOQ validation, PO batches, cost adjustments, and bundles and components tracking.
Sending POs & tracking real lead times
Automated PO emails with a formatted PDF and a supplier PO portal for collaboration, plus built-in shipments, receiving, and supplier lead time tracking across orders.
Scenario planning with AI
Read-only MCP access lets you connect Claude or ChatGPT to ask planning questions directly against Monocle's data (strictly read-only for planning, as AI assistants never create or send POs).
Having the math spelled out right inside the reorder table lets you check projected stock at arrival in seconds, without digging through nested spreadsheet formulas.
What You Still Do Manually as the Operator
Monocle handles the forecasting math, supplier grouping, and lead-time tracking, though software cannot negotiate with factory managers or set your cash limits. Three practical steps stay with you as the operator:
- Step 01Confirming supplier holiday schedules:You still communicate directly with each factory to confirm exact CNY closure dates, final pre-holiday production cutoffs, and local port schedules before setting your coverage targets.
- Step 02Editing final quantities for case packs and cash:Monocle provides AI-suggested reorder quantities with manual editing. You manually adjust quantities to match physical master-carton multiples or trim lower-priority variants to fit your exact Q1 cash budget.
- Step 03Reviewing and approving final POs:Automated suggestions never turn into binding commitments without human sign-off. You review unit costs, MOQ flags, and batch totals before approving and sending purchase orders.
Keeping final PO sign-off and factory schedule confirmation in human hands makes sure the math lines up with real container space and Q1 cash reserves.
2026-2027 Chinese New Year PO Action Checklist
Whether you build your shopify purchase order template in Google Sheets or run reorders through Monocle, pre-holiday factory cutoffs leave very little room for error. Work through these six steps this week to protect your Q1 stock:
Confirm factory cutoff and reopen dates: Ask every supplier in writing for their final pre-CNY production cutoff date, port gate-in deadline, and expected post-holiday reopen date.
Measure real lead times: Audit your last three to four received POs per supplier to calculate real lead time from PO sent date to warehouse receipt, and size your safety stock to cover actual variance.
Scrub Q4 daily sales averages: Strip Black Friday promotional spikes and out-of-stock zero-sale days out of your velocity math so your Q1 baseline reflects true daily demand.
Extend your coverage window: Increase your order cycle days to bridge the full factory shutdown plus two to three weeks of post-CNY production and shipping congestion.
Validate MOQs, round up cases, and audit cash: Check supplier minimums, round every SKU up to full case packs, and trim high-days-of-cover C-SKUs first if the PO total exceeds your cash budget.
Issue PDFs and log incoming inventory immediately: Send clean PDF purchase orders with committed ship-before-cutoff dates, and mark confirmed units as incoming right away to prevent accidental double-ordering.
If your catalog has outgrown spreadsheets and you want automated demand forecasting, ABC-XYZ prioritization, and supplier PO tracking in one place, try Monocle on the Shopify App Store at https://apps.shopify.com/forecast?utm_source=blog.

.webp)