How VeeSheets Turns Your Veeqo Data Into Decisions

A plain-English guide to every column — where the data comes from, how it's calculated, and what to do with it.

Three Questions Every Seller Needs Answered

📈

What's selling fastest right now?

Your SKUs ranked by a weighted velocity score. Recent sales this week count more than last month — so a product that just went viral beats one that used to sell well but has slowed. Focus your reorder budget on what's actually earning money today.

📅

When will I run out?

Days of Cover and Out-of-Stock Date tell you exactly how long your current stock will last at today's rate. Not next month's forecast — today's rate.

📦

How much should I reorder?

Suggested Reorder Qty does the maths: target 30 days of cover, subtract what you have and what's already inbound. One number, ready to put on a purchase order.

Every column in VeeSheets answers one of these three questions. Here's how each one works.

Raw Data — Pulled Directly from Veeqo

These columns are values fetched from your Veeqo account, unchanged.

Product Info

SKU
Always included. The unique identifier used to match stock, sales, and purchase order data together. Each row = one SKU.
Product Title
The product name as it appears in Veeqo.
Barcode
UPC/EAN from Veeqo's product catalogue. Useful for cross-referencing with suppliers or warehouse systems.

Stock Levels

Available
The quantity free to sell right now (not reserved for any order). This is the number VeeSheets uses as the basis for all intelligence calculations. A negative Available means you've oversold.

“Available” is the only stock column shown by default. On Hand and Committed exist in the backend but are hidden from the column picker as they're rarely needed for replenishment decisions.

Sales Velocity

Units Sold — 7d / 14d / 30d
Total units shipped (not just ordered — Veeqo status=shipped orders only) in each window. Cancelled, pending, and returned orders are excluded.
Relatable example: Your Blue Widget Pro sold 20 units last week (7d), 35 over the last two weeks (14d), and 60 over the last month (30d). The difference between 14d and 7d — 15 units — tells you how many sold the week before last.

Inbound (Purchase Orders)

Inbound Units
Total quantity on all open (not yet received) POs for this SKU. Two POs of 50 units each = 100 Inbound Units.
Expected Delivery
Earliest expected delivery date across all open POs. If you have two POs, VeeSheets picks the sooner one.

Inventory Intelligence — Calculated by VeeSheets

These 7 columns don't exist in Veeqo. VeeSheets computes them from your raw data — no formulas, no manual work. Each one is designed to answer a financial question: what to buy, when to buy it, and where cash is tied up in stock you're not moving.

Daily Velocity

Calculated
Daily Velocity = (Sold 30d × 0.5 + Sold 14d × 0.3 + Sold 7d × 0.2) ÷ 30

A weighted average that gives more influence to recent sales than older ones. A product that's accelerating this week shows a higher velocity than a flat 30-day average would suggest.

Example: Blue Widget Pro — Sold 60 (30d), 35 (14d), 20 (7d)
(60×0.5 + 35×0.3 + 20×0.2) ÷ 30 = 44.5 ÷ 30 = 1.48 units/day

Days of Cover

Calculated
Days of Cover = Available ÷ Daily Velocity

How many days your current available stock will last at today's sales rate. Rounded to 1 decimal place. Blank if there are no recent sales.

Example: You have 43 Blue Widget Pro units available. Daily Velocity is 6.2.
43 ÷ 6.2 = 6.9 days — you'll run out in under a week.

Out-of-Stock Date

Calculated
Out-of-Stock Date = Today + Days of Cover (rounded down)

The calendar date when stock hits zero — assuming today's sales rate holds. Sort this column ascending to see your most urgent SKUs first.

Example: Synced on Feb 23. Days of Cover = 6. Out-of-Stock Date = Mar 1, 2026.
You have 6 days to raise a purchase order.

Inventory Status

Calculated
Status Condition What to do
Dead SKU 0 units sold in 30 days Review pricing, listings, or consider liquidating
Critical < 14 days of cover Reorder immediately
Reorder Soon 14–30 days of cover Raise a PO this week
Healthy 30–120 days of cover No action needed
Overstock > 120 days of cover Consider promotions or smaller future orders
Relatable story: You bought 200 units of a seasonal product. It's now two months later and it shows "Overstock" — 180 units left, selling 0.5/day. That's 360 days of cover and $3,000 tied up in slow stock. VeeSheets flags it before your accountant does.

Sales Momentum

Calculated
Recent rate = Sold 7d ÷ 7 Baseline = Sold 30d ÷ 30 Ratio = Recent rate ÷ Baseline ≥ 1.25 → Accelerating | 0.75–1.25 → Stable | ≤ 0.75 → Declining

Compares this week's daily rate to the 30-day average. Tells you if demand is building, holding, or fading — before it shows up in a stockout or dead inventory.

Example: Red Widget sold 14 units in 7d (2.0/day) but only 30 in 30d (1.0/day baseline). Ratio = 2.0. → Accelerating.

If you were about to skip reordering because "stock looks fine", this flag changes that decision.

Inbound Risk

Calculated
If Out-of-Stock Date < Expected Delivery → At Risk If Out-of-Stock Date ≥ Expected Delivery → OK

Cross-references when you'll run out with when your next PO arrives. A reorder already being in transit doesn't mean you won't have a stockout gap.

Example: You have 43 units of Blue Widget Pro. You'll run out March 1. Your PO is expected March 15. → At Risk.

Without this flag, you'd assume the PO covers you — it doesn't. You have a 14-day gap.
Relatable scenario: The warehouse ops team raised the PO. The buyer approved it. Logistics booked the shipment. Everyone thinks they're covered. VeeSheets is the only one checking whether the maths actually works.

Suggested Reorder Qty

Calculated
Target = Daily Velocity × 30 Already covered = Available + Inbound Units Reorder Qty = max(0, Target − Already covered)

How many units to order today to bring your cover back to 30 days, accounting for stock you already have plus what's already on order. Zero means you're already covered — no action needed.

Example 1 (reorder needed): Velocity = 2.0/day, Available = 10, Inbound = 5. Target = 60. Covered = 15. → Reorder 45 units.

Example 2 (no action): Velocity = 2.0/day, Available = 50, Inbound = 20. Target = 60. Covered = 70. → Reorder 0 (you're already covered).

Note: 30-day target is conservative. If your supplier lead time is longer, treat this as a minimum and scale up.

Auto Mode vs Manual Mode

Auto Mode (default)

VeeSheets ranks all your Veeqo SKUs by a weighted velocity score and syncs the top 10 (Free) or 100 (Pro) fastest-moving ones automatically. You don't need to specify which SKUs — the data tells you which matter.

Velocity Score = (Sold 7d × 8) + (Sold 14d × 4) + (Sold 30d × 2)

Recent sales count proportionally more, so a SKU that just accelerated rises to the top even if its 30-day total is lower than a steadily slower seller.

Best for: daily replenishment reviews, catching trending SKUs, weekly supplier calls.

Manual Mode

Add SKUs to column A of your sheet (one per row, starting at row 2), then switch the sidebar toggle to Manual. VeeSheets syncs exactly those SKUs — no ranking, no filtering by velocity.

Best for category-specific reviews, supplier meetings ("show me all SKUs from Supplier X"), warehouse physical counts, or auditing specific product lines.

Limit still applies: Free syncs the first 10 from your list, Pro syncs the first 100.

Best for: category audits, supplier prep, physical count reconciliation.

Getting the Most from Your Sheet

Three things to do every time you sync — takes under 5 minutes and prevents the two most expensive inventory mistakes: stockouts and overstock.

1

Sort by Out-of-Stock Date (ascending)

Your most urgent SKUs are at the top. Anything within 14 days needs a purchase order today.

2

Filter by Inventory Status = Critical or At Risk

Two columns that flag problems before they become lost sales.

3

Check Sales Momentum on Healthy SKUs

A healthy SKU that's "Accelerating" may need its next order brought forward. A healthy SKU that's "Declining" may need a smaller reorder.

Frequently Asked Questions

Why are some Inventory Intelligence cells blank?
These columns require both sales data (Daily Velocity) and stock data (Available). If one phase of the sync hasn't completed yet, or if a SKU has no sales in the last 30 days, VeeSheets leaves the cell blank rather than showing a misleading number.
What does "Dead SKU" mean — does VeeSheets delete it?
No. "Dead SKU" simply means zero units shipped in the last 30 days. VeeSheets flags it so you can review — it doesn't touch your sheet or Veeqo in any way.
My PO is already on the way. Why does Inbound Risk show "At Risk"?
Because the stock will run out before the PO arrives, based on current sales rate. The risk is a stockout gap, not a missing PO. You may need to expedite, find alternative stock, or pause promotion on that SKU.
How often should I sync?
Once a day is enough for most sellers. After the first sync (which fetches full order history), subsequent daily syncs use a 4-hour orders cache, so they complete significantly faster.
Can I change which columns appear in the sheet?
Yes. Open the VeeSheets sidebar → Column Picker → check or uncheck any column. SKU is always included. Only columns you select will be fetched and written — this keeps syncs fast.
Why is my Daily Velocity higher than I expected?
Daily Velocity is weighted: recent sales count more than older ones. If your SKU had a strong week, the 7-day rate pulls the weighted average up above what a plain 30-day-divided-by-30 would show.
Does VeeSheets modify my Veeqo data?
No. VeeSheets is read-only. It connects to Veeqo via OAuth, reads orders, stock, and PO data, and writes to your Google Sheet. It never changes anything in Veeqo.

Ready to see your own data?

Start free — no credit card, no CSV exports, no formulas.

📊 Add to Google Sheets — Free Back to Home