SITNS Inventory

Proper inventory management is the backbone of merchandise profitability. Whether you are a solo artist selling prerolls or a band with 10 different shirt designs, knowing your "Cost of Goods Sold" (COGS) vs. your "Retail Value" is essential.

1. The Numbering System (SKUs)

Every product needs a unique fingerprint. We use a simple SKU (Stock Keeping Unit) system in this tool:

 * Prefix: Determines the category (e.g., "SH" for Shirts, "JE" for Jewelry).

 * Identifier: A 3-digit sequential number.

 * Example: SH-001 is your first shirt design. PR-005 is your fifth preroll strain.

2. Understanding the Formulas

The logic built into our tool is universal. If you want to build this in Excel manually, here are the core formulas:

 * Total Cost (Asset Value):

   Use this to know how much money you have tied up in boxes.

 * Gross Retail Value:

   Use this to know your potential revenue if you sell out completely.

 * Profit Margin %:

   Use this to judge if an item is worth selling. Aim for margins above 60% for merch.

3. Integration & Exporting

 * Master Tour / Excel: Use the "Download CSV" button. This creates a flat data file that can be imported into almost any database system, including Master Tour (Merch section) or Google Sheets.

 * Hard Copies: Use the "Print/PDF" button. This strips away the dark mode and buttons, giving you a clean white paper manifest to hand to a venue merch rep for settlement.

Part 3: Features & Integration Guide

How to use the Code:

 * Save: Copy the code block above into a text editor (Notepad, TextEdit).

 * Name: Save the file as inventory.html.

 * Run: Open that file in Chrome, Safari, or Edge.

 * Embed: To put this on Sitnsmusic.com, paste the code into an "HTML Embed" block or an iframe on your site builder.

Technical Specs:

 * Storage: Uses localStorage (Client-side). This means data lives in your specific browser. Note: If you clear your browser cache, you lose the data, so export CSVs regularly as backups.

 * Export: Generates a universal .csv file.

 * Responsiveness: Works on Mobile and Desktop (Bootstrap-grid style CSS).

 * Expandability: The Javascript array structure (inventory = { shirts: [], ...}) allows for infinite additional categories if you learn basic JS.