Catalogue Repricing Spreadsheet, Bulk Product Pricing and Profit Margin Calculator for Handmade Sellers, Excel and Google Sheets Template
Price:$4.86
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
Check every product in your shop at once: what you make at today's price, which items fall short of your target margin, and a suggested price for each.
WHAT IT IS
A repricing workbook for your whole catalogue, not one item at a time. Enter your fee settings once, then list each SKU with its materials, labour time, packaging, shipping you absorb and current price. The sheet shows the fees, profit and margin at the current price, flags each SKU "Reprice" or "OK" against your target margin, and works out the price that would hit that target.
WHO IT'S FOR
• Handmade and small online sellers reviewing prices after costs or fees go up
• Sellers with many SKUs or colourways who want one view instead of one calculator per item
• Anyone who wants to see which products actually earn their place
WHAT'S INCLUDED (4 tabs)
• Instructions: short step-by-step guide
• Settings: percentage fee, fixed fee per order, labour rate per hour, target margin and default shipping absorbed
• Catalogue: up to 300 SKUs with labour cost, total cost, fees, profit and margin at the current price, suggested price, price change and status
• Summary: SKU count, items below target, average margin, total profit (one sale of each SKU), and checks for missing inputs and settings
25 sample SKUs (pouches, totes, notebook covers, key fobs and coaster sets in five colours) are filled in so you can see how it works before replacing them with your own.
ABOUT FEES
Enter your platform's current fees on the Settings tab: one combined percentage (for example transaction plus payment processing) and one fixed amount per order. The sample fee settings are placeholders to show how the sheet works; they aren't any platform's actual fees. Check your platform's current fee page and update Settings whenever fees change.
HOW IT WORKS
1. Type only in the blue cells. Gray cells calculate for you.
2. Fill in Settings with your fees, labour rate, target margin and usual shipping cost. Type percentages with the % sign (e.g. 6.5%).
3. List each SKU with its materials cost, labour minutes, packaging and current price, all per sellable unit. Leave Shipping absorbed blank to use your default, or enter 0 if the buyer pays shipping.
4. Read the margin and status for each SKU. The suggested price is the price that reaches your target margin after fees. Round it up to your usual price step.
5. Check the Summary for items below target and any missing inputs.
Each row assumes one unit per order, so the fixed fee is counted once per unit. Sales tax and VAT aren't included. Suggested prices are a calculation from your own inputs, not pricing advice. Use one currency throughout.
COMPATIBILITY
• Microsoft Excel (.xlsx file)
• Google Sheets: upload the file to Google Drive, choose Open with > Google Sheets, then File > Save as Google Sheets
• Standard formulas only: no macros, no add-ins, no sign-up. It doesn't connect to any shop; you enter the figures yourself.
INSTANT DIGITAL DOWNLOAD
This is a digital file. No physical item will be shipped. You can download it as soon as your purchase is complete.
Please note: this template was created with the help of AI tools and reviewed before release.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
Maker Spreadsheet Bundle, 7 Workbooks: Inventory, Candle, Jewelry and Bakery Trackers, Bookkeeping and Repricing, Excel and Google Sheets
$15.40
-
Digital download
Home Bakery Inventory and Batch Cost Tracker, Ingredient Cost Per Bake and Recipe Costing Spreadsheet, Excel and Google Sheets Template
$7.21
-
Digital download
Jewellery Inventory and Materials Cost Tracker, Jewelry Spreadsheet for Bead, Wire and Findings Cost Per Piece, Excel and Google Sheets
$7.21
-
Digital download
Print on Demand Order Ledger Spreadsheet, POD Income and Expense Tracker with Cash Per Order, Excel and Google Sheets Template
$7.21