{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["README","Clean_Products","Name_Conflicts","Price_Outliers","Missing_Identity","Field_Dictionary","Expected_Warnings"],"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"merged":[[0,0,1,3],[2,0,2,3],[4,0,5,0],[4,1,5,3],[7,0,9,0],[7,1,9,3],[19,0,20,0],[19,1,20,3],[22,0,23,0],[22,1,23,3],[25,0,26,0],[25,1,26,3],[28,0,29,0],[28,1,29,3],[31,1,31,3]]}
["Commerce Mapping Studio | Source samples"]
[]
["FICTIONAL DATA - SOURCE REFERENCE ONLY - NOT IMPORTER-READY"]
[]
["Current workflow","Commerce Studio can read CSV, TSV and XLSX source tables in the browser, map columns, check records, and prepare supported export files. It does not write to a store or activate a promotion. These fictional source samples are not importer-ready templates. A successful download does not certify a live import."]
[]
[]
["How to use","1. Choose Products and the intended destination in Commerce Studio. 2. Upload this workbook, select one product tab, and use header row 1. 3. Review mapping, source/store currency, and all findings. 4. Correct values only with evidence and inspect the separate prepared output. Do not select the README, Field_Dictionary, or Expected_Warnings tab as product data. The original workbook is never modified by the app."]
[]
[]
[]
["Sheet","Purpose","Rows","Review focus — not an exhaustive result"]
["Clean_Products","Eight intentional product rows: six explicit Size siblings and two distinct items. A flat family is not a native WooCommerce variable-parent definition.",8,"Check mapping, target taxonomy and destination structure; clean does not mean import-ready."]
["Name_Conflicts","Same title with different supplier and category facts. Names do not establish identity.",3,"Review the supplier and category conflicts without merging by title."]
["Price_Outliers","Six comparable sibling prices, including deliberate USD 300 and USD 3 values on source rows 6 and 7.",6,"Review high/low price candidates under the current comparison settings."]
["Missing_Identity","Missing title/price/category, explicit zero price, duplicate SKU and reused fictional GTIN.",4,"Resolve missing values and identity conflicts; verify any intended zero price."]
["Field_Dictionary","Definitions, types and safe handling for all source columns.",17,"Reference only"]
["Expected_Warnings","Ten illustrative findings for selected source mistakes, not an exhaustive current result.",10,"Static examples; not a live validator or passing test report."]
[]
["Identifiers and CSV","XLSX identifiers are stored as text. CSV cannot store cell types: use your spreadsheet app's text/CSV import flow and set SKU, GTIN and other identifier columns to Text. Opening CSV directly may remove leading zeros. Do not repair a missing GTIN by inventing one."]
[]
[]
["Review expectations","Run the app’s current checks after selecting the destination and mapping. Findings depend on source context, settings, edits, references and review date. Editing this workbook does not recalculate the printed examples. A clean example can still have destination, context or omission findings. Never treat a static count as proof of import readiness."]
[]
[]
["Google and categories","These are neutral source columns. There is no separate Google feed file. Google-related values belong in the final product sheet only after the destination importer, installed Google integration, field types and taxonomy are confirmed. Category labels here are not official taxonomy IDs."]
[]
[]
["Fictional data only","Products, suppliers, SKUs and barcodes in this workbook are fictional. This workbook contains no customer records. The inspected file has no formula cells, macros, embedded files or external workbook relationships. These observations apply to this saved file only. Never use the example barcodes as real catalog assignments."]
[]
[]
["Snapshot","See the current README.md and manifest.json beside the downloads for the observed file hashes, row/column counts, and evidence scope. Recalculate hashes after any workbook change. These source fixtures are not a live-store certification."]

{"sheet":"Clean_Products","index":1,"n_rows":9,"n_cols":17,"rows_kept":9}
["source_record_id","product_name","supplier","category","brand","sku","price","currency","pack_quantity","tax_basis","condition","price_basis","gtin","variant_family","variant_option","sample_notice","variant_option_name"]
["cl2","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","000142-XS",28,"USD",1,"exclusive","new","regular",null,"CLEAN-TEE-142","XS","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["cl3","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","000142-S",29,"USD",1,"exclusive","new","regular",null,"CLEAN-TEE-142","S","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["cl4","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","000142-M",30,"USD",1,"exclusive","new","regular",null,"CLEAN-TEE-142","M","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["cl5","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","000142-L",31,"USD",1,"exclusive","new","regular",null,"CLEAN-TEE-142","L","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["cl6","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","000142-XL",30,"USD",1,"exclusive","new","regular",null,"CLEAN-TEE-142","XL","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["cl7","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","000142-XXL",29,"USD",1,"exclusive","new","regular",null,"CLEAN-TEE-142","XXL","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["cl8","Canvas Weekend Bag","Northstar Supply","Bags","Northstar Basics","000250",48,"USD",1,"exclusive","new","regular",{"$nulls":3},"FICTIONAL SOURCE - NOT IMPORTER READY",""]
["cl9","Cotton Cap","Northstar Supply","Hats","Northstar Basics","000300",18,"USD",1,"exclusive","new","regular",{"$nulls":3},"FICTIONAL SOURCE - NOT IMPORTER READY",""]

{"sheet":"Name_Conflicts","index":2,"n_rows":4,"n_cols":17,"rows_kept":4}
["source_record_id","product_name","supplier","category","brand","sku","price","currency","pack_quantity","tax_basis","condition","price_basis","gtin","variant_family","variant_option","sample_notice","variant_option_name"]
["c2","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","NS-142",30,"USD",1,"exclusive","new","regular",{"$nulls":3},"FICTIONAL SOURCE - NOT IMPORTER READY",""]
["c3","Everyday Cotton Tee","Harbor Wholesale","Hoodies","Northstar Basics","HW-142",31,"USD",1,"exclusive","new","regular",{"$nulls":3},"FICTIONAL SOURCE - NOT IMPORTER READY",""]
["c4","Canvas Weekend Bag","Harbor Wholesale","Bags","Northstar Basics","HW-250",48,"USD",1,"exclusive","new","regular",{"$nulls":3},"FICTIONAL SOURCE - NOT IMPORTER READY",""]

{"sheet":"Price_Outliers","index":3,"n_rows":7,"n_cols":17,"rows_kept":7}
["source_record_id","product_name","supplier","category","brand","sku","price","currency","pack_quantity","tax_basis","condition","price_basis","gtin","variant_family","variant_option","sample_notice","variant_option_name"]
["p2","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","TEE-XS",28,"USD",1,"exclusive","new","regular",null,"TEE-142","XS","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["p3","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","TEE-S",29,"USD",1,"exclusive","new","regular",null,"TEE-142","S","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["p4","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","TEE-M",30,"USD",1,"exclusive","new","regular",null,"TEE-142","M","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["p5","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","TEE-L",31,"USD",1,"exclusive","new","regular",null,"TEE-142","L","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["p6","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","TEE-XL",300,"USD",1,"exclusive","new","regular",null,"TEE-142","XL","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]
["p7","Everyday Cotton Tee","Northstar Supply","T-shirts","Northstar Basics","TEE-XXL",3,"USD",1,"exclusive","new","regular",null,"TEE-142","XXL","FICTIONAL SOURCE - NOT IMPORTER READY","Size"]

{"sheet":"Missing_Identity","index":4,"n_rows":5,"n_cols":17,"rows_kept":5}
["source_record_id","product_name","supplier","category","brand","sku","price","currency","pack_quantity","tax_basis","condition","price_basis","gtin","variant_family","variant_option","sample_notice","variant_option_name"]
["m2",null,"Northstar Supply",null,"Northstar Basics","NEW-001",null,"USD",1,"exclusive","new","regular",{"$nulls":3},"FICTIONAL SOURCE - NOT IMPORTER READY",""]
["m3","Canvas Tote","Northstar Supply","Bags","Northstar Basics","DUP-010",0,"USD",1,"exclusive","new","regular","0000000000017",null,null,"FICTIONAL SOURCE - NOT IMPORTER READY",""]
["m4","Cotton Cap","Northstar Supply","Hats","Northstar Basics","DUP-010",18,"USD",1,"exclusive","new","regular","0000000000024",null,null,"FICTIONAL SOURCE - NOT IMPORTER READY",""]
["m5","Ribbed Beanie","Northstar Supply","Hats","Northstar Basics","HAT-020",22,"USD",1,"exclusive","new","regular","0000000000017",null,null,"FICTIONAL SOURCE - NOT IMPORTER READY",""]

{"sheet":"Field_Dictionary","index":5,"n_rows":18,"n_cols":4,"rows_kept":18}
["Source field","Cell type","Meaning and handling rule","Example"]
["source_record_id","Text identifier","Stable ID for this fictional source row. It is not a Shopify or WooCommerce store ID.","p6"]
["product_name","Text / blank","Confirmed product title. Matching names trigger review; they never establish identity or authorize a merge.","Everyday Cotton Tee"]
["supplier","Text","Source supplier. Keep supplier identity separate from manufacturer brand and catalog identity.","Northstar Supply (fictional)"]
["category","Text / blank","Source category label, not a verified Shopify/Woo/Google taxonomy assignment. Confirm target paths and rules.","T-shirts"]
["brand","Text","Supplied manufacturer or brand, separate from supplier. Sibling-price comparison requires known compatible brand context.","Northstar Basics (fictional)"]
["sku","Text identifier","Preserve leading zeros. The sample uses SKU matching; duplicate SKUs block that strategy. Supplier SKUs may need a supplier namespace.","000250"]
["price","Number / blank","Regular selling price in the stated currency and pack context. Blank is unknown; zero is explicit. It is distinct from cost and active sale price. For text numbers, select the actual decimal convention; supported grouping must be valid and currency symbols must not be included.","30.00"]
["currency","Text code","Explicit source currency code. Confirm the actual store currency separately; the app never converts amounts between currencies or invents a currency for unknown reference data.","USD"]
["pack_quantity","Positive integer","Supplied count of items sold for the amount. Compare like packs; the app does not assume one or convert cases, weights or volumes without evidence.","1"]
["tax_basis","Text","Supplied inclusive/exclusive price context. Compatible peers must use the same basis; the app does not compute tax.","exclusive"]
["condition","Text","Supplied product condition, never guessed from a title or category. These fictional rows explicitly use new.","new"]
["price_basis","Text","Meaning of the price, such as regular selling price. Do not compare retail price with wholesale cost or another basis.","regular"]
["gtin","Text / blank","Keep all digits including leading zeros. Example GTINs are fictional, not registered identifiers. A valid check digit does not establish assignment.","0000000000017"]
["variant_family","Text / blank","Explicit sample family identifier. It is not a destination parent ID. Missing families are not inferred from matching titles.","TEE-142"]
["variant_option","Text / blank","Supplied first option value within the family. Use the corresponding option name and the complete option combination for a real variant.","XL"]
["sample_notice","Text marker","Safety label on every row. This is documentation only; never map this column to a product field.","FICTIONAL SOURCE - NOT IMPORTER READY"]
["variant_option_name","Text / blank","First option name, such as Size. Supply it with the corresponding variant_option value; no option type is inferred from a product title.","Size"]

{"sheet":"Expected_Warnings","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,0,1,6]]}
["ILLUSTRATIVE FINDINGS ONLY — not an exhaustive current warning count or live validator. Run checks after mapping and selecting the destination."]
[]
[]
["Scenario","Example issue code","Severity","Source record IDs","CSV / XLSX rows","Why this is expected","Suggested review"]
["conflicts","NAME_SUPPLIER","Warning","c2, c3","2, 3","Everyday Cotton Tee has two suppliers.","Compare brand, model, packaging and identifiers; confirm multi-sourcing or keep distinct products."]
["conflicts","NAME_CATEGORY","Warning","c2, c3","2, 3","The same product name is assigned to T-shirts and Hoodies.","Choose the confirmed classification or explain the difference. Do not merge by name."]
["prices","PRICE_OUTLIER","Warning","p6","6","USD 300 is unusually high; the other five comparable variants have median USD 29.","Check price source, decimal placement and pack size. Correct only with evidence."]
["prices","PRICE_OUTLIER","Warning","p7","7","USD 3 is unusually low; the other five comparable variants have median USD 30.","Check price source, decimal placement and pack size. Confirm a special price if intentional."]
["missing","SKU_CONFLICT","Blocker","m3, m4","3, 4","DUP-010 is assigned to both Canvas Tote and Cotton Cap.","Resolve the duplicate SKU or choose another verified matching strategy. Never merge these titles automatically."]
["missing","NAME_MISSING","Blocker","m2","2","The new sellable record has no product name.","Supply a confirmed product name; do not create one from an identifier."]
["missing","PRICE_MISSING","Blocker","m2","2","The selling price is blank.","Supply the confirmed price. A blank price must not silently become zero."]
["missing","CATEGORY_MISSING","Warning","m2","2","The product category is blank.","Choose a confirmed category; this is a sample quality rule, not a universal importer requirement."]
["missing","PRICE_ZERO","Warning","m3","3","Canvas Tote has a zero selling price.","Confirm that a free product is intentional or correct its price."]
["missing","GTIN_REUSED","Warning","m3, m5","3, 5","0000000000017 is reused for Canvas Tote and Ribbed Beanie with different SKUs.","Verify item and packaging identity. The check digit is valid, but the example barcode is fictional and not authorized for sale."]