Catalog Health Report

Harbour Lane Supply (SAMPLE) · generated 2026-11-14 · input: before.csv
Products audited41
Variants audited133
Problems found97
Critical problems27
Minor improvements149
Fixed automatically203
Need client input35
Feed-ready variants (before)61/130 (47%)
Feed-ready variants (after)95/120 (79%)

"Feed-ready" = passes the Google Merchant Center required-field checks this tool runs (id, title, description, link, image, availability, price, brand, valid GTIN or identifier_exists, title policy, apparel gender/age group). It is a pre-check, not a guarantee of Google approval.

Issues by category

CategoryCriticalWarningInfoFixed automatically
GTIN / identifiers5128
Apparel attributes437032
Images303839
Descriptions31101
Titles3306
Brand / vendor3202
Variants & options242124
Duplicate listings2002
SKUs1172
Pricing1303
Product type & category044044
SEO004040
Inventory sync0200
Shipping data0200
Feed eligibility0010

Google feed blocking problems (variants affected)

ProblemBeforeAfter
missing gender (apparel)4112
missing age_group (apparel)412
promotional title80
missing description44
missing brand44
invalid gtin40
missing image_link44
missing identifier (gtin/mpn or identifier_exists=no)35
title > 150 chars20
invalid image_link20
missing price11

Examples: before → after

GTIN / identifiers

SeverityProductProblemBeforeAfterAction
criticalwool-beanie
HL-WB-BLAC		Invalid GTIN (check digit fails); Google disapproves invalid GTINs062800025532cleared; needs correct GTIN from client
criticalstoneware-mug
HL-SM-12OZ		GTIN corrupted by spreadsheet scientific notation (digits lost)6.28E+11cleared; needs correct GTIN from client
criticalenamel-camp-mug
HL-ECM		Invalid GTIN (check digit fails); Google disapproves invalid GTINs1234-5678cleared; needs correct GTIN from client
criticalinsulated-water-bottle
HL-IWB-500M		Placeholder GTIN (all same digit)000000000000cleared; needs correct GTIN from client
criticalrain-jacket
HL-RJ-BLAC-M		Same GTIN used on 2 variants (each variant needs its own)062800038119cleared on duplicate; needs correct GTIN from client
warningcanvas-tote-bag
HL-CTB		UPC lost its leading zero (spreadsheet); restored and checksum verified12345678905012345678905auto-fixed

Apparel attributes

SeverityProductProblemBeforeAfterAction
criticalkids-logo-teeMissing gender (required for apparel); no tag to derive it fromneeds client input
criticalankle-socksMissing gender (required for apparel); no tag to derive it fromneeds client input
criticalankle-socksMissing age group (required for apparel)needs client input
criticalkids-rain-bootsMissing gender (required for apparel); no tag to derive it fromneeds client input
warningclassic-crew-teeMissing gender (required for apparel)unisex (from tags)auto-fixed
warningclassic-crew-teeMissing age group (required for apparel)adult (from tags)auto-fixed

Images

SeverityProductProblemBeforeAfterAction
criticalweekly-plannerNo product image (Google requires image_link)needs client input
criticalyoga-matImage URL is not a full https:// linkcdn.example.com/sample/yoga-mat.jpghttps://cdn.example.com/sample/yoga-mat.jpgauto-fixed
criticaldog-bandanaNo product image (Google requires image_link)needs client input
infoclassic-crew-teeMissing image alt text (accessibility/SEO)uses product titleauto-fixed
infoclassic-crew-tee-1Missing image alt text (accessibility/SEO)uses product titleauto-fixed
infoorganic-v-neck-teeMissing image alt text (accessibility/SEO)uses product titleauto-fixed

Descriptions

SeverityProductProblemBeforeAfterAction
criticalankle-socksMissing description (required by Google)needs client input
criticalmarket-toteMissing description (required by Google)needs client input
criticallip-balmMissing description (required by Google)needs client input
warningzip-hoodieVery short description (28 chars)Full-zip heavyweight hoodie.needs client input
warningwool-beanieVery short description (25 chars)Ribbed wool-blend beanie.needs client input
warningdad-capShouting caps / promotional text in descriptionUNSTRUCTURED SIX-PANEL COTTON CAP. BUY NOW!!!Unstructured six-panel cotton cap.auto-fixed

Titles

SeverityProductProblemBeforeAfterAction
criticalorganic-v-neck-teepromotional text / exclamation marks (Google title policy); ALL CAPSORGANIC V-NECK TEE - BEST SELLER!!Organic V-Neck Teeauto-fixed
criticaldad-cappromotional text / exclamation marks (Google title policy)Dad Cap - FREE SHIPPINGDad Capauto-fixed
criticalthrow-blankettoo long for Google (176 > 150 chars)Throw Blanket Soft Cozy Warm Blanket for Couch Sofa Bed Living Room Bedroom Gift for Mom Gift for Her Christmas Gift Housewarming Gift Recycled Cotton Throw Blanket Large 50x60Throw Blanket Soft Cozy Warm Blanket for Couch Sofa Bed Living Room Bedroom Gift for Mom Gift for Her Christmas Gift Housewarming Gift Recycledauto-fixed
warningzip-hoodieall lowercasezip hoodie heavyweightZip Hoodie Heavyweightauto-fixed
warningenamel-camp-muginconsistent unit formatEnamel Camp Mug 12 OZEnamel Camp Mug 12 ozauto-fixed
warningtravel-tumblerinconsistent unit formatTravel Tumbler 20oz.Travel Tumbler 20 ozauto-fixed

Brand / vendor

SeverityProductProblemBeforeAfterAction
criticalankle-socksMissing brand (required by Google)needs client input
criticalmarket-toteMissing brand (required by Google)needs client input
criticalbrass-penMissing brand (required by Google)needs client input
warningdad-capInconsistent brand spellingharbour lane supplyHarbour Lane Supplyauto-fixed
warningsilk-scarfInconsistent brand spellingHarbour Lane Supply Co.Harbour Lane Supplyauto-fixed

Variants & options

SeverityProductProblemBeforeAfterAction
criticalpocket-tee
HL-PT-BLAC-S		Variant missing its Size value (import/feed error)needs client input
criticalfleece-vestDuplicate variant (same option combination twice; Shopify rejects this)navy / mduplicate row removedauto-fixed
warningclassic-crew-teeVariant gap: 1 combination(s) missing from the size/color gridNavy / Lneeds client input (confirm discontinued or add)
warningorganic-v-neck-teeInconsistent option nameColourColorauto-fixed
warningorganic-v-neck-teeInconsistent option namesizeSizeauto-fixed
warningpocket-teeVariant gap: 2 combination(s) missing from the size/color gridOlive / XL, Black / Sneeds client input (confirm discontinued or add)

Duplicate listings

SeverityProductProblemBeforeAfterAction
criticalclassic-crew-tee-1Likely duplicate of 'classic-crew-tee' (title similarity 100%, same description, same price)activedraft + tag duplicate-of-classic-crew-teeauto-fixed (set to draft, not deleted; merge after client review)
criticalsoy-candle-cedar-sageLikely duplicate of 'soy-candle-cedar' (title similarity 100%, same description, same price)activedraft + tag duplicate-of-soy-candle-cedarauto-fixed (set to draft, not deleted; merge after client review)

SKUs

SeverityProductProblemBeforeAfterAction
criticalsoy-candle-sea-salt
HL-SCC		Duplicate SKU also used by 'soy-candle-cedar' (inventory & feed ID collision)HL-SCCHL-SCC-2auto-fixed (proposed, confirm)
warningdot-grid-notebookMissing SKU (inventory & feed ID risk)HL-DGNauto-fixed (proposed, confirm)
infoclassic-crew-tee-1
HL-CCT-BLAC-S		SKU shared with 'classic-crew-tee' because this listing is a duplicate; resolves when mergedHL-CCT-BLAC-Srecommendation
infoclassic-crew-tee-1
HL-CCT-BLAC-M		SKU shared with 'classic-crew-tee' because this listing is a duplicate; resolves when mergedHL-CCT-BLAC-Mrecommendation
infoclassic-crew-tee-1
HL-CCT-BLAC-L		SKU shared with 'classic-crew-tee' because this listing is a duplicate; resolves when mergedHL-CCT-BLAC-Lrecommendation
infoclassic-crew-tee-1
HL-CCT-BLAC-XL		SKU shared with 'classic-crew-tee' because this listing is a duplicate; resolves when mergedHL-CCT-BLAC-XLrecommendation

Pricing

SeverityProductProblemBeforeAfterAction
criticalthrow-blanket
HL-TB-OAT		Missing or zero price (Google disapproves)0.00needs client input
warningtravel-tumbler
HL-TT-BLAC		Price not in plain number format$32.0032.00auto-fixed
warningleather-card-wallet
HL-LCW-TAN		Compare-at price is not higher than price (misleading sale / feed mismatch)40.00auto-fixed
warningleather-card-wallet
HL-LCW-BLAC		Compare-at price is not higher than price (misleading sale / feed mismatch)40.00auto-fixed

Product type & category

SeverityProductProblemBeforeAfterAction
warningorganic-v-neck-teeInconsistent product type namingt shirtsT-Shirtsauto-fixed
warningpocket-teeInconsistent product type namingTeesT-Shirtsauto-fixed
warninglinen-tea-towelMissing product type (inferred from title)Kitchen Towelsauto-fixed
warningbamboo-sunglassesMissing product type (inferred from title)Sunglassesauto-fixed
infoclassic-crew-teeMissing Google product category (optional, improves targeting)Apparel & Accessories > Clothing > Shirts & Topsauto-fixed
infoclassic-crew-tee-1Missing Google product category (optional, improves targeting)Apparel & Accessories > Clothing > Shirts & Topsauto-fixed

SEO

SeverityProductProblemBeforeAfterAction
infoclassic-crew-teeMissing SEO titleClassic Crew Teeauto-fixed
infoclassic-crew-tee-1Missing SEO titleClassic Crew Teeauto-fixed
infoorganic-v-neck-teeMissing SEO titleOrganic V-Neck Teeauto-fixed
infopocket-teeMissing SEO titlePocket Teeauto-fixed
infolong-sleeve-waffle-henleyMissing SEO titleLong Sleeve Waffle Henleyauto-fixed
infoharbour-pullover-hoodieMissing SEO titleHarbour Pullover Hoodieauto-fixed

Inventory sync

SeverityProductProblemBeforeAfterAction
warningharbour-pullover-hoodie
HL-HPH-FORE-L		Negative inventory (stock count out of sync)-3needs client input
warningkids-rain-bootsActive product not published to Online Store (won't sync to Google channel)FALSEneeds client input (confirm intended)

Shipping data

SeverityProductProblemBeforeAfterAction
warningcutting-board-maple
HL-CBM-SMAL		Missing weight (shipping rates may be wrong)0needs client input
warningcutting-board-maple
HL-CBM-LARG		Missing weight (shipping rates may be wrong)0needs client input

Feed eligibility

SeverityProductProblemBeforeAfterAction
infogift-cardGift card excluded from shopping feed (not eligible)recommendation

Still needs client input (35)

These need real product facts (GTINs, prices, images, descriptions, weights) or a business decision. We never invent them.

SeverityProductSKUWhat is neededCurrent value
criticalankle-socksMissing description (required by Google)
criticalankle-socksMissing brand (required by Google)
criticalankle-socksMissing gender (required for apparel); no tag to derive it from
criticalankle-socksMissing age group (required for apparel)
criticalbrass-penMissing brand (required by Google)
criticaldog-bandanaNo product image (Google requires image_link)
criticalkids-logo-teeMissing gender (required for apparel); no tag to derive it from
criticalkids-rain-bootsMissing gender (required for apparel); no tag to derive it from
criticallip-balmMissing description (required by Google)
criticalmarket-toteMissing description (required by Google)
criticalmarket-toteMissing brand (required by Google)
criticalpocket-teeHL-PT-BLAC-SVariant missing its Size value (import/feed error)
criticalthrow-blanketHL-TB-OATMissing or zero price (Google disapproves)0.00
criticalweekly-plannerNo product image (Google requires image_link)
warningankle-socksNo color option or color in title (required for apparel)
warningbamboo-sunglassesNo color option or color in title (required for apparel)
warningbrass-penVery short description (4 chars)Pen.
warningclassic-crew-teeVariant gap: 1 combination(s) missing from the size/color gridNavy / L
warningcutting-board-mapleHL-CBM-SMALMissing weight (shipping rates may be wrong)0
warningcutting-board-mapleHL-CBM-LARGMissing weight (shipping rates may be wrong)0
warningdog-bandanaVery short description (24 chars)Cotton bandana for dogs.
warningenamel-camp-mugVery short description (22 chars)Enamel steel camp mug.
warningfleece-vestVery short description (17 chars)Grid fleece vest.
warninghand-creamVery short description (26 chars)Unscented shea hand cream.
warningharbour-pullover-hoodieHL-HPH-FORE-LNegative inventory (stock count out of sync)-3
warningkids-rain-bootsNo color option or color in title (required for apparel)
warningkids-rain-bootsActive product not published to Online Store (won't sync to Google channel)FALSE
warninglinen-tea-towelVery short description (28 chars)Stonewashed linen tea towel.
warningmerino-crew-socksNo color option or color in title (required for apparel)
warningpocket-teeVariant gap: 2 combination(s) missing from the size/color gridOlive / XL, Black / S
warningsilk-scarfVery short description (22 chars)100% silk twill scarf.
warningsilk-scarfNo color option or color in title (required for apparel)
warningweekly-plannerVery short description (23 chars)Undated weekly planner.
warningwool-beanieVery short description (25 chars)Ribbed wool-blend beanie.
warningzip-hoodieVery short description (28 chars)Full-zip heavyweight hoodie.

Method

Checks: duplicate listings (title similarity, handle family, identical description/price), duplicate SKUs and GTINs, variant grid gaps and duplicate option combinations, empty option values, title policy (promotional text, caps, units, length), brand/vendor consistency, product type and Google category mapping, apparel attributes, GTIN length/check digit/spreadsheet corruption, price format and compare-at logic, weights, negative stock, images and https links, publish status, SEO titles. All automatic changes are listed in issues.csv and are applied only to after.csv; nothing is pushed to a live store without approval.