TEAM STORE PRICING CALCULATOR

• Ecommerce builders pricing new SKUs for a team store or pop-up collection.
• Account managers confirming pricing before a store goes live.
• Anyone handing off finished pricing to the ecommerce build team.

The calculator is hosted as an internal Google Apps Script web app. Open it using the shared link from your team lead, or from the Apps Script project directly.

Note: If you don’t have the link, ask in the internal tools channel or contact whoever manages the Apps Script deployment (see Section 7).

3. Step-by-Step Usage

Step 1 — Pick a Product
Type a product name or catalog ID into the search box under “Pick a Product.” Results filter as you type. Click a result to select it — this loads the product’s base cost (COGS) from the live pricing sheet.

Select the size range from the dropdown. Sizes S–XL carry no surcharge; 2XL through 6XL add the standard oversize surcharge automatically.

Click “+ Add decoration location” for each place on the garment that will be decorated (e.g. front, back, sleeve). For each location:

• Choose the decoration method from the dropdown.
• If Embroidery is selected, choose the stitch count — this determines the per-unit cost.
• All other methods are flat-rate per location and need no further input.

Add as many locations as the design requires. Remove a location with the × in its top-right corner.

The Pricing Ticket on the right updates live as you make selections, showing:

• Base COGS, size surcharge, and total decoration cost
• Total product cost (COGS + surcharge + decoration)
• A Suggested Selling Price, automatically rounded up to the nearest $.95

Use the Target Margin slider (40–60%) to see how the suggested price changes. If you need to charge a specific number instead, type it into “Or set your own price” — the badge next to it shows the resulting margin and flags whether it’s below, within, or above the 40–60% target.

Click Copy to copy a tab-separated row (Product, Decoration Method, COGS, Decoration Cost, Total Cost, Selling Price, MSRP, Margin) to your clipboard. Paste it directly into the team’s pricing spreadsheet — it will land in the correct columns automatically.

Note: If Copy doesn’t populate your clipboard, see Section 6 (Troubleshooting).

All Signature Locker orders are on-demand, single-unit prints. The calculator always prices at the single-unit tier — there is no order-quantity input, and no bulk discount is ever applied.

The tool is built around a 40–60% margin target. The margin badge reflects this:

Selling prices always round up to the nearest $.95 (e.g. a calculated $24.30 becomes $24.95; a calculated $24.96 becomes $25.95, not down to $24.95). This guarantees the rounded price never falls below the calculated margin.

Only methods fulfilled through our fulfillment network (FE) are included:

Note: Screen printing, heat seal patch, HTV, liquid 3D, and label application are intentionally excluded — they are not run through FE for team store items.

This was a known display bug (the dropdown was clipped by its container) and has been fixed in the current version. If it recurs, confirm the tool is running the latest deployment (Section 7).

Google Apps Script renders the tool inside a sandboxed frame, which can occasionally block clipboard access depending on browser settings. If this happens:

1. Try a different browser (Chrome tends to work most reliably).
2. If it still fails, manually record the values shown on the Pricing Ticket into the pricing sheet.
3. Report the issue so the fallback (a selectable text box) can be added.

The catalog reflects the pricing sheet at the time the tool was last deployed. If a SKU is missing or a price looks outdated, flag it to whoever maintains the tool so the catalog can be refreshed and redeployed.

This almost always means the underlying code was only partially pasted into Apps Script (a common issue given how much product data the file contains). See Section 7 for the correct update procedure.

The tool lives in a Google Apps Script project as two files:

1. Get the updated Index.html file from whoever maintains the source (currently built and version-controlled via Claude).
2. Download the file and open it in a plain text editor — not a browser preview — to avoid copy/paste corruption.
3. In the Apps Script project, open the Index file, select all existing content, delete it, and paste in the new content.
4. Save the project.
5. Go to Deploy → Manage deployments → edit the existing deployment → set Version to “New version” → Deploy.
6. Refresh the tool’s URL and confirm products load and pricing calculates correctly before sharing that it’s updated.

Note: Simply saving the file does not update the live link — a new deployment version must be published each time.