Ceramics Studio Tracker

Welcome to Ceramics Studio Tracker

Your complete ceramics studio business tool –– inventory, pricing, sales & more.

Step 1 of 5 –– Set up your vendors & materials

Start in the Setup tab. Add your material vendors first –– everything else is organized by vendor.e.g. Sheffield Pottery, The Ceramic Shop, Georgies, Standard Clay, local clay supplier

Add your materials –– clay, glaze, underglaze, slip –– with name, source, color, mesh/grit, cost per oz, lbs on hand, and a low-stock alert.Already have a spreadsheet? Use Bulk import from CSV to bring it all in at once.

Add your supplies –– kiln wash, wax resist, stamps, ribs, wire tools –– with vendor, SKU, cost per unit, starting stock, and unit type.Bulk CSV import is available here too.

Add packaging supplies like bubble wrap, tissue paper, and boxes –– they'll show up in your Inventory and in the packaging dropdown on the Pricing tab.

⚠️ Important: If you rename a material or hardware item, existing recipe entries will still reference the old name and won't deduct correctly. After renaming, open the affected BOM entries in the History tab and re-save them from the Pricing tab to relink.

Tip: Set your default labor rate in Setup so it pre-fills every time you price a product.

Step 2 of 5 –– Log what you make

When you finish a piece, go to the Bill of Materials tab. Enter a product name and date.

Select a vendor –– only that vendor's items appear in the dropdowns. Enter oz for clay/glazes and quantity for supplies.Live on-hand counts show next to each item as you build your list.

Hit Save BOM. Your BOM saves to your History tab –– inventory is not deducted yet.Inventory deducts when you save a product from this BOM in the Pricing tab.

Tip: Load any saved BOM straight into the Pricing tab with one click –– no re-entering costs.

Step 3 of 5 –– Price your products

Go to the Pricing tab. Load a saved BOM or enter material costs manually. Add your labor rate, hours worked, packaging, shipping, overhead, and markup %.

The app calculates your cost basis, suggested retail price, and profit margin. Enter your actual selling price to see real profit.

Add a photo and notes, set qty on hand, then hit Save product. It appears in the Products tab, becomes available in the Sales log, and inventory is deducted for the qty made.Editing a product and increasing qty will deduct the additional units. Deleting a product restores inventory for any qty on hand.

Tip: Use Quick Add in the Products tab for fast catalog entry when you don't need the full pricing breakdown.

Step 4 of 5 –– Track your sales

Go to the Sales log tab. Select a product, then enter the sale price, quantity, platform, buyer name, shipping charged, and any discount.

A live preview shows revenue, COGS, profit, and margin before you save. Qty on hand updates automatically when you log the sale.

Running totals at the top track all-time revenue, COGS, profit, average margin, and units sold –– exactly what you need at tax time.

Tip: COGS pulls from your saved product cost basis automatically –– no extra math at sale time.

Step 5 of 5 –– Customize & keep your data safe

Go to Settings to rename the app and tabs, hide tabs you don't use, and choose a color theme –– 8 presets or a custom color picker.

Back up regularly. Settings → Create backup saves a .studio file to your computer. Use this when moving to a new version of the app –– not the Excel export.

Your data lives in browser storage and saves automatically on every change. Clearing your browser cache will erase it –– keep that backup habit.

You're all set! You can replay this guide anytime from Settings → Review getting started guide.

Item / product name *

Date made

Design / glaze combo (optional)

Materials (clay, glaze, underglaze, slip)

Supplies

Notes

Inventory deducts when you save a product from this BOM in the Pricing tab.

Product name (for saving)

Load from saved BOM

Material costs

Total material cost$0.00

Labor

Hourly rate ($)

Hours spent

Total labor$0.00

Shipping & packaging

Packaging size

Add/edit sizes in Settings tab

Additional shipping ($)

Pass shipping to customer?

Total shipping + packaging$0.00

Overhead & markup

Overhead (%)

Profit markup (%)

Cost basis

$0.00

Suggested retail

$0.00

Profit margin

Your selling price ($)

Profit at this price––

Full price breakdown

Save as product

Notes / description

Qty on hand (finished goods)

How many of this item you have ready to sell.

Category (optional)

Product photo (optional, max 2MB)

Drag & drop a photo here

or click to choose a file

Saved products appear in the Products tab with full pricing breakdown.

Materials

	Name	Vendor	Source / Type	Color / Finish	Mesh / Grit	$/oz	Lbs	Oz	Used	On hand	Alert	Actions

Supplies

	Name	Vendor	SKU	Cost/unit	Unit	Starting	Used	On hand	Alert	Actions

Package Supplies

Name	Vendor	Cost	Unit	Starting	Used	On hand	Actions

Pending vendor orders

Bulk import products from CSV

Imports to Products tab only –– does not affect your inventory counts.

Import products CSV

Vendors

Add material (clay, glaze, underglaze, slip)

Vendor

Source / type (manufacturer, brand)

Name

Color / finish

Total cost ($)

Starting lbs auto-fills oz

Starting oz

Cost per oz ($) auto-calculated or enter manually

Mesh / grit (optional — e.g. 200 mesh for glazes)

Low stock alert (oz)

Add supply item (tools, kiln wash, stamps, brushes)

Vendor

Name

SKU

Cost per unit ($)

Unit type

Starting stock

Low stock alert

Bulk import materials from CSV

CSV columns: vendor, source_type, name, color, mesh_grit, total_cost, start_lbs, start_oz, cost_per_oz, alert_at. Only vendor and name are required. Duplicate items (same vendor + name) are skipped automatically.

Import materials CSV

Bulk import supplies from CSV

CSV columns: vendor, name, sku, cost_per_unit, unit, starting_stock, alert_at. Only vendor and name are required. Duplicate items are skipped automatically.

Import hardware CSV

Forms & glaze combos

Track your ceramic forms and glaze combos. Use the Notes field in your BOM or Product to reference a specific form and glaze combination.

Form name

Glaze combo / variation

Notes (optional)

Reference file path (optional) local path or URL

Add package supply

Package supplies are items like bubble wrap, boxes, logo stickers, tissue paper, etc. They appear in the Package Supplies section of Inventory and in the packaging dropdown on the Pricing tab.

Name *

Vendor (optional)

Cost each ($)

Unit

Starting stock

Low stock alert

Record each sale. COGS is calculated from your saved product costs.

Showing:

Log a sale

Date sold *

Platform

Buyer name (optional)

Shipping charged to buyer ($)

Discount applied

Sold in person –– exclude shipping costs

Notes

Sales history

Currency

Choose the currency symbol displayed throughout the app.

Measurement units

Choose how material quantities are displayed and entered. Switching updates all labels and values instantly.

Imperial (oz / lbs) Metric (g / kg)

App title & subtitle

Main title

Subtitle (below title)

Tab labels

Enter a custom name for any tab, or leave blank to keep the default.

Bill of Materials tab

Pricing tab

Inventory tab

History tab

Products tab

Sales log tab

Setup tab

Settings tab

Visible tabs

Choose which tabs are shown. Bill of Materials and Settings cannot be hidden.

App colors & theme

Choose a preset or pick your own colors.

Header background color

Tab & accent color

Storage

Getting started guide

New to the app? Review the step-by-step setup guide at any time.

Export & import your data

Transferring to a new version? Export your backup first, then open the new file and import it.

The Excel export is for viewing your data. Use Create backup to save your data and Restore from backup to load it into a new version.

View in Excel / Sheets

All your data in a readable spreadsheet. Not for importing.

Data backup

Saves a .json backup –– use this when moving to a new version.

Restore from backup

Load a .studio backup file to restore all your data.

Restore from backup

Storage troubleshooting

If you see "Storage is full" errors or your data won't import, use this to wipe only this app's browser data so you can start fresh or re-import a backup. Your .studio backup file is not affected.

⚠️ Danger zone

Permanently deletes all data –– every product, sale, inventory item, and BOM entry. This cannot be undone. Export a backup before proceeding.