5 columnsCSV
Anyone with a 3PL or carrier contract
Shipping rate card
What this file is
A shipping rate card is the price list a carrier or 3PL bills you on: one row per zone and weight bracket, with the price a parcel in that bracket costs. Copying your contract into one file is how per-order shipping cost stops being a guess.
What is inside
One header row, one filled example.
Copy your carrier's price list into it once: each row is a zone, a weight bracket and the price. This is the single most under-tracked cost in ecommerce, and the one that quietly decides whether small orders are worth shipping.
Rows 1 and 2 are the file. Click any cell to read it; the foot of the sheet says what its column is for.
A2Germany
| Row | A | B | C | D | E | F | G | H | I | J | K |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | zone | country_codes | weight_from_g | weight_to_g | price | ||||||
| 2 | Germany | DE | 0 | 1000 | 4.90 | ||||||
| 3 | |||||||||||
| 4 | |||||||||||
| 5 | |||||||||||
| 6 | |||||||||||
| 7 |
nouz-shipping-rate-card
A · zoneYour name for the zone: Germany, Rest of EU, World.
Every column, explained.
In the order they sit in the file. Point at one and it is outlined in the sheet.
Behind the file
Why it is built this way.
Carriers do not charge a flat rate. They charge by where a parcel goes and what it weighs, so the card mirrors that: a zone, which is a name plus the countries it covers, a weight range in grams, and a price. Any parcel is then priced by finding its one row.
Two details save the arithmetic later. Brackets must touch without overlapping, or one parcel has two prices. And every country you ship to needs a zone, with a catch-all for the rest of the world, so no order is ever unpriced. Done properly, the card turns logistics cost per order from a monthly surprise into a number you can read per order.
Keep this file to carriage. If your 3PL bills pick and pack separately, that belongs in its own rule, because mixing the two hides which half is rising. Some contracts price by parcel size instead of weight; nouz's rate cards take either, chosen per card, and the weight columns here then become size brackets. Once the card is filled, feeding a typical order into the ecommerce break-even calculator shows what a carrier increase does to the orders a month has to clear.
In nouz
Where the card lives in nouz.
On the Logistics page, a rate card has zones across and weight brackets down (or parcel sizes, on a card priced by size), with a price in every cell, from the day it starts. Each zone holds its countries, and one catch-all zone prices the rest of the world.
More templates
More free files, same format.
Your daily P&L, without the spreadsheet.
nouz works out your real profit every night, after product costs, shipping, payment fees, ad spend and running costs, and sends it to your inbox each morning.
Your trialToday
14 days of nouz, every feature€0,00
Card needed to startNone
Access to your storeRead-only
Due today€0,00