Bag Maker Tracker

Bill of materials · Pricing · Inventory · History

Materials (leather, vinyl, fabric, lining)

Hardware

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

Material costs

Total material cost$0.00

Labor

Total labor$0.00

Shipping & packaging

Add/edit sizes in Settings tab

Total shipping + packaging$0.00

Overhead & markup

Cost basis

$0.00

Suggested retail

$0.00

Profit margin

0%

Profit at this price––

Full price breakdown

Save as product

How many of this item you have ready to sell.

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 / TypeColor / FinishWeight / Thickness$/sq inSq ftSq inUsedOn handAlertActions

Hardware

Name Vendor SKUColorCost/unitUnitStartingUsedOn handAlertActions

Supplies

Name Vendor CostUnitStartingUsedOn handActions

Pending vendor orders

Bulk import products from CSV

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

Vendors

Add material (leather, vinyl, fabric, lining)

Fabric / yardage calculator auto-fills sq in above

Add hardware

Bulk import materials from CSV

How to fill out the template

Required: vendor and name only. Everything else is optional.

To enter dimensions (width × length) instead of calculating area yourself:

  • Fill in width, length, and length_unit
  • length_unit applies to both width and length — use cm, m, inches, feet, or yards
  • The area will be calculated automatically on import

To enter area directly:

  • Metric: use start_dm2 and/or start_sq_cm (1 dm² = 100 sq cm)
  • Imperial: use start_sq_ft and/or start_sq_in (1 sq ft = 144 sq in)

Cost: Enter total_cost and leave cost_per_sq_cm / cost_per_sq_in blank — it will auto-calculate from total cost ÷ area. Or enter the cost per unit directly.

Weight & thickness: Enter one and the other auto-fills on import — weight (oz) × 0.4 = thickness (mm), and vice versa.

Duplicates: If a material with the same vendor + name already exists, it will be flagged and you can choose to overwrite or keep both.

⚠ Excel tip: Values like 4/5 in the weight_oz column may be automatically converted to dates by Excel. To prevent this: select the weight_oz column before typing, right-click → Format Cells → Text → OK, then type your values.

Bulk import hardware from CSV

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

Patterns & colorways

Track your bag patterns and the colorways you offer for each. Use the Notes field in your BOM or Product to reference a specific pattern and colorway.

Add supply item

Supplies are items like packaging, tissue paper, logo stickers, ribbon, etc. They appear in the Inventory tab and in the packaging dropdown on the Pricing tab.

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

Showing:

Log a sale

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.

App title & subtitle

Tab labels

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

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.

Storage

Loading...

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.

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.

© 2026 Emily Picard / Borrowed Leather Goods –– Bag Maker Tracker –– All rights reserved