Shopify Textile Compliance Audit Template: Free Download
This free Excel template lets you check every apparel SKU in your Shopify catalog for missing or inconsistent fiber content, origin, care, supplier and document data, and shows you what to fix first. It has 500 rows, built-in dropdowns, automatic fiber-percentage checks and a summary sheet. It is a working tool, not legal advice.
What is in the workbook
| Sheet | What it does |
|---|---|
| Read Me | Short instructions and a colour legend |
| Compliance Matrix | One row per SKU or variant, 28 columns, with an example row to copy |
| Summary | Counts of OK, incomplete and overdue rows, plus the most common gaps |
| Lists | The dropdown values (FTC fiber names, product types, document types) |
How the Compliance Matrix is organised
The columns follow the order in which you will normally find information, from product identity to evidence to review.
- Identity (A–D): SKU, style name, variant, product type.
- Fiber content (E–M): up to three named fibers with percentages, other fibers, an automatic total and a check that flags totals other than 100%.
- Labeling data (N–P): country of origin, company name or RN, and whether a care label is present.
- Supplier (Q–R): supplier and factory.
- Evidence (S–V): flammability basis, certificate type, any environmental claim and the evidence behind it.
- Review (W–Z): earliest document expiry, last review date, next review due (last review + 180 days, calculated) and an owner.
- Result (AA–AB): an automatic list of open issues and a status.
How to use it in six steps
- Export your products from Shopify (Products > Export) and copy SKU, title, variant and product type into columns A–D.
- Fill fiber content from the supplier specification or the physical label, not from the web description.
- Add origin, company identity and care data from the label.
- Record the supplier, the factory and the document that supports each claim.
- Set the review date and owner. Filter the Status column for anything not OK.
- Fix the gaps in Shopify, then update the last review date.
The fiber check only tests that percentages add up to 100%. It does not tell you whether the names are FTC-acceptable or whether the label is correct. Treat it as a screen, not a certification.
What the template deliberately does not decide
Requirements depend on product type, market and claim. The template records evidence for what you say about a product. It does not tell you that every product needs the same documents. For example, an environmental claim only needs the evidence that supports that particular claim, and flammability documentation depends on the garment type (children's sleepwear differs from adult clothing).
Who should use it
- Brands with 50 to 500 SKUs that currently track data in scattered sheets.
- Agencies and Shopify partners doing a catalog clean-up.
- Teams preparing for California SB 707 data requests or retailer audits.
If your catalog is bigger than 500 rows, copy the formulas down or move to a CSV-based audit.
Frequently asked questions
Is the template free? Yes. No sign-up is needed to use it.
Does it work in Google Sheets? Yes, upload the .xlsx to Google Drive. Dropdowns and formulas are supported. Conditional formatting may look slightly different.
Does it make my catalog compliant? No. It helps you find gaps and keep evidence in one place. Compliance depends on the actual products, labels and claims.
How often should I review rows? The template defaults to every 180 days. Change the formula in column Y if your process needs a different cycle.
Related guides
- How to audit your Shopify catalog for missing textile data
- How to build an apparel compliance matrix in Excel
- FTC textile labeling requirements: Shopify checklist
Sources: FTC, Threading Your Way Through the Labeling Requirements · 16 CFR Part 303
Not legal advice. Check requirements for your products and markets.