SHOPIFY · HISTORICAL COGS & MARGIN
Your historical margin stops moving when a supplier changes the price
Shopify keeps one cost per variant and it is the current one. Every time you edit it, the margin attributed to orders you already shipped moves with it, and your spreadsheet stops agreeing with the admin. This pilot rebuilds the dated cost history from your own files so the number attached to each sale stays put — and so your accountant can trace it row by row.
FREE STEP · HEADER ROW ONLY
Paste the column names, get an answer
Paste just the header row of your two files — column names, no data. You get back which columns are recognised, which are missing, the ambiguities in SKU, date or currency, and whether the case can be reconciled at all. If it cannot, you are told so.
Ten seconds of work. No customer data leaves your side, and no calculation is delivered for free: it is a verdict on your files, not a mini-project.
WHAT THE PILOT DELIVERS
Two files in, five outputs out
- cost_timeline.csv — every receipt, its landed unit cost and the weighted average after it.
- margin_by_order.csv — net sales, COGS, margin, margin % and coverage, per order line.
- margin_by_sku_month.csv — units, net sales, COGS and margin per SKU and month.
- exceptions.csv — every row that could not be reconciled, with its reason. Nothing is dropped silently.
- reconciliation.md — totals in equal totals out, with the method, currency and timezone declared.
Method: weighted average cost by SKU and date. A sale takes the cost true on its date; nothing that happens later rewrites it. See a static sample report with fictional data.
SCOPE & BOUNDARIES
What is in and what is out
In: one store, one receipts/costs file and one order-lines file, up to 200 SKUs, 10,000 order lines and 24 months, one currency, stable SKUs, product cost with inbound freight, duties and other landed cost, and simple discounts and refunds linked to the original order.
Out: five full years in the first pilot, accounting or tax reconstruction, complex exchanges, bundles, kits, BOM, multi-currency and FX, payment fees, ad spend, multiple warehouses and FIFO/LIFO. The refund is due only if, with files that match the agreed scope, the agreed reconciliation cannot be delivered. Your accountant validates the policy; the deliverable makes the calculation visible. Full pilot terms (scope, exclusions, refund, data and VAT) — you accept them at checkout.
The limit that matters: this works when you have per-receipt costs — what you paid for each batch, with its freight and duties. If the only cost that exists is today’s number in the variant field, there is no history to rebuild and the honest answer is no.
DATA & PRIVACY
Redacted files only
The input is two redacted CSVs: SKUs, dates, quantities, amounts and currency. Before sending
anything, delete the customer columns from your export — Email,
Phone, Billing * and Shipping * name and address
columns. Files are received anonymised and are deleted 30 days after delivery. No admin
access, no credentials, no order API, no customer list.
PRICE & VAT
Who can buy through the payment link
US$299 carries no VAT for EU businesses outside Spain with a valid VAT number (reverse charge — enter it at checkout) and for customers outside the EU (not subject to Spanish VAT). Customers in Spain and EU customers without a valid VIES VAT number pay 21% VAT and are not sold through the payment link: email jose@josedrobles.com for an invoice with VAT. VAT terms.
Start with the free header check
Send the header row of your receipts file and of your order-lines file. If the files can be reconciled you get the scope and the payment link; if they cannot, you get the reason.