Inventory Count Digitisation - 20 July 2026

Converted the manual godown counting register (19 notebook pages, 6-20 July 2026) into the Meru Trophy All Price Google Sheet and prepared shopify_products for Shopify upload.

What was done

1. Transcription. All 19 photographed pages were transcribed: 574 count entries, 29,432 pieces total. Quantities written with pluses (e.g. 68+48+4+8) were summed. Items counted at multiple racks kept as separate entries.

2. New tab "Inventory Count" in the Google Sheet with columns: Date, Model (as written), Qty Expression, Qty Total, Rack No, Mapped A-Z Model, Map Status, Notes. Entries with doubtful handwriting are marked CHECK in Notes.

3. A-Z tab. Added two columns: Quantity (col D) and Rack No (col E). Counted models carry the real counted total and rack numbers; all uncounted models are set to 1 as agreed. 257 A-Z rows carry real counts.

4. Model mapping conventions discovered. The counting book uses short names; the A-Z list uses suffixed names. Mapping applied:

• Book -1/-2/-3 = A-Z -MA/-MB/-MC or -M1/-M2/-M3 or -N1/-N2/-N3 (e.g. 728-1 = 728-MA, 511-1 = 511-M1, 1351-4 = 1351-N4)
• Book -4/-5/-6 = A-Z -M4/-M5/-M6 (e.g. 510-4 = 510-M4)
• Digit vs letter sizes are the same (2967-1 = 2967-A, 5001-C = 5001-3)
• Spaces/hyphens ignored (JH-207-C = JH 207-C)
• Manual fixes: 8143 read as 814-M3 (rack 196 next to 813/814), 5033-A-S read as 5033-SILVER

5. shopify_products tab.

• Variant SKU and Variant Barcode set to the A-Z model number for 749 variants (was mostly empty). Products not in the price list but with a clear model in the title got that model as SKU.
• Variant Inventory Qty: counted models = real count, everything else = 1.
• Two new product metafield columns added: Inventory Count (product.metafields.custom.inventory_count) and Rack No (product.metafields.custom.rack_no). These import into Shopify as product metafields.
• 1,601 new rows appended (rows 945-2545): 1,431 A-Z models that did not exist in Shopify (Active, priced from A-Z, qty 1 or counted) and 170 counted models that are in no price list (Draft, no price - need pricing before publish).
• New products are single-variant with Title = model + category, handle = model slug. Grouping sizes into variants (like the existing 4288 product) can be done later.

Couldn't be changed / needs your review