Skill Tracer
Skills › Knowledge Work Plugins › seo-ai-visibility › catalog_refresh.md

catalog_refresh.md

126 lines · small-business/skills/seo-ai-visibility/reference/catalog_refresh.md at 2574e29

Open on GitHub
1# Catalog Refresh
2
3The bulk product pass for stores. Score every product, rewrite the worst, apply in approved batches.
4
5Shopify and Wix are the connected paths. Wix exposes a full read/write site API, so a bulk
6catalog and site refresh applies directly there the same way it does on Shopify — the
7scoring, the revenue ordering, and the batch gates below are identical on both.
8
9Without either, work from a product CSV export and hand back a corrected CSV for import —
10the scoring and the rewriting are identical again.
12---

Catalog Refresh

The bulk product pass for stores. Score every product, rewrite the worst, apply in approved batches.

Shopify and Wix are the connected paths. Wix exposes a full read/write site API, so a bulk catalog and site refresh applies directly there the same way it does on Shopify — the scoring, the revenue ordering, and the batch gates below are identical on both.

Without either, work from a product CSV export and hand back a corrected CSV for import — the scoring and the rewriting are identical again.


Raw lines 1 to 13
14## What gets scored
16Four fields per product, each pass or fail with a reason.
18| Field | Passes when |
19|---|---|
20| Title | Says what the product is in plain terms. Not a bare SKU, not a keyword pile. Under about 70 characters |
21| Description | Answers what it is, what it fits, what is included, and what makes it different. At least a few real sentences |
22| Image alt text | Present on every image and describes the image. Not the product title copied in |
23| SEO title and description | Present, unique, under the length limits, distinct from the product title |
25A fifth check worth running: **duplicate descriptions**. Stores routinely have the same paragraph on forty products. Flag the clusters.
27---

What gets scored

Four fields per product, each pass or fail with a reason.

FieldPasses when
TitleSays what the product is in plain terms. Not a bare SKU, not a keyword pile. Under about 70 characters
DescriptionAnswers what it is, what it fits, what is included, and what makes it different. At least a few real sentences
Image alt textPresent on every image and describes the image. Not the product title copied in
SEO title and descriptionPresent, unique, under the length limits, distinct from the product title

A fifth check worth running: duplicate descriptions. Stores routinely have the same paragraph on forty products. Flag the clusters.


Raw lines 14 to 28
29## The scoring pass
31Run across the whole catalog first, before writing anything. The owner needs to see the size of the problem.
33```
34Catalog scan — 412 products
36Missing SEO description 318 77%
37Missing or duplicate alt text 287 70%
38Description under 40 words 201 49%
39Duplicate description text 94 23% (11 clusters)
40Title is a bare SKU 38 9%
42Fully complete 41 10%
44Worst 25 by revenue: 19 have no SEO fields and 22 have no alt text. Those
45are the ones losing money, so they go first.
46```
48**Order by revenue, not by score.** Fixing a product that sells one unit a year is a waste of the owner's approval attention. Sort by units sold or revenue over the last 90 days and start at the top. Say that this is what you are doing.
50---

The scoring pass

Run across the whole catalog first, before writing anything. The owner needs to see the size of the problem.

Catalog scan — 412 products

Missing SEO description        318   77%
Missing or duplicate alt text  287   70%
Description under 40 words     201   49%
Duplicate description text      94   23%  (11 clusters)
Title is a bare SKU             38    9%

Fully complete                  41   10%

Worst 25 by revenue: 19 have no SEO fields and 22 have no alt text. Those
are the ones losing money, so they go first.

Order by revenue, not by score. Fixing a product that sells one unit a year is a waste of the owner's approval attention. Sort by units sold or revenue over the last 90 days and start at the top. Say that this is what you are doing.


Raw lines 29 to 51
52## Rewriting
54Read [the shared voice profile](../../../shared/voice-profile.md). Product copy carries the store's voice as much as email does.
56**Titles.** What it is, then the distinguishing detail. Brand, model, size, and material where they matter to a buyer.
58```
59Bad: HVAC-FLT-2025-B
60Bad: Best Premium High Quality Air Filter Furnace AC HVAC MERV 13 Cheap
61Good: MERV 13 Pleated Furnace Filter — 20x25x1, 6-Pack
62```
64**Descriptions.** First sentence says what it is and who it is for. Then specifics — dimensions, compatibility, what is in the box, how long it lasts. Then anything genuinely distinguishing.
66```
67MERV 13 pleated filter for standard 20x25x1 furnace and AC returns. Catches
68pollen, dust, pet dander, and smoke particles down to 0.3 microns — the
69grade most allergy sufferers want. Six filters, about a year of coverage
70at the recommended 60-day change. Fits most residential systems built
71after 1995; measure your existing filter before ordering.
72```
74**Alt text.** Describe the image, for someone who cannot see it. This is an accessibility requirement first and a search benefit second.
76```
77Bad: MERV 13 filter buy online best price
78Good: White pleated furnace filter, front view, showing the 20x25x1 size
79 printed on the cardboard frame
80```
82**Never invent product facts.** Dimensions, materials, compatibility, certifications, and country of origin come from the existing product data or from the owner. When they are missing, write around them and flag it — "compatibility list needed for 14 products" — rather than guessing. A wrong compatibility claim generates returns.
84---

Rewriting

Read the shared voice profile. Product copy carries the store's voice as much as email does.

Titles. What it is, then the distinguishing detail. Brand, model, size, and material where they matter to a buyer.

Bad:   HVAC-FLT-2025-B
Bad:   Best Premium High Quality Air Filter Furnace AC HVAC MERV 13 Cheap
Good:  MERV 13 Pleated Furnace Filter — 20x25x1, 6-Pack

Descriptions. First sentence says what it is and who it is for. Then specifics — dimensions, compatibility, what is in the box, how long it lasts. Then anything genuinely distinguishing.

MERV 13 pleated filter for standard 20x25x1 furnace and AC returns. Catches
pollen, dust, pet dander, and smoke particles down to 0.3 microns — the
grade most allergy sufferers want. Six filters, about a year of coverage
at the recommended 60-day change. Fits most residential systems built
after 1995; measure your existing filter before ordering.

Alt text. Describe the image, for someone who cannot see it. This is an accessibility requirement first and a search benefit second.

Bad:   MERV 13 filter buy online best price
Good:  White pleated furnace filter, front view, showing the 20x25x1 size
       printed on the cardboard frame

Never invent product facts. Dimensions, materials, compatibility, certifications, and country of origin come from the existing product data or from the owner. When they are missing, write around them and flag it — "compatibility list needed for 14 products" — rather than guessing. A wrong compatibility claim generates returns.


Raw lines 52 to 85
86## Batch approval
88**Batches of 20 to 25. Every batch gets its own yes.** A rewrite pattern that looked fine on three samples and is wrong across 400 products is a very long afternoon of undo.
90Before the first batch, show three full before-and-after examples and get agreement on the pattern. Fixing the approach on three products costs nothing.
92```
93Batch 3 of 17 — products 51-75, ranked by 90-day revenue
95Changing: 25 titles, 25 descriptions, 61 alt texts, 25 SEO descriptions
96Sample: <3 full before-and-after pairs>
97Not touching: prices, inventory, variants, collections, publish status
98Reversible: Yes — original values saved to catalog-backup-2026-07-27.csv
100Apply these 25?
101```
103Rules that keep this safe:
105- **Save the originals before the first write.** A CSV of the current values, always, no exception.
106- **Never touch price, inventory, variants, or publish status.** This skill edits how products are described. Nothing else.
107- **Stop on the first surprise.** If a write errors or a field comes back different from what was sent, stop the run and report rather than continuing through the remaining batches.
108- **Report per batch.** Applied, skipped, failed, with product names.
110---

Batch approval

Batches of 20 to 25. Every batch gets its own yes. A rewrite pattern that looked fine on three samples and is wrong across 400 products is a very long afternoon of undo.

Before the first batch, show three full before-and-after examples and get agreement on the pattern. Fixing the approach on three products costs nothing.

Batch 3 of 17 — products 51-75, ranked by 90-day revenue

Changing:  25 titles, 25 descriptions, 61 alt texts, 25 SEO descriptions
Sample:    <3 full before-and-after pairs>
Not touching: prices, inventory, variants, collections, publish status
Reversible: Yes — original values saved to catalog-backup-2026-07-27.csv

Apply these 25?

Rules that keep this safe:

  • Save the originals before the first write. A CSV of the current values, always, no exception.
  • Never touch price, inventory, variants, or publish status. This skill edits how products are described. Nothing else.
  • Stop on the first surprise. If a write errors or a field comes back different from what was sent, stop the run and report rather than continuing through the remaining batches.
  • Report per batch. Applied, skipped, failed, with product names.

Raw lines 86 to 111
112## Structured data for products
114Once descriptions are clean, add `Product` schema with `Offer`. Most store platforms generate it — check what is already there before adding a second, conflicting block.
116Only mark up what is true and visible: price, availability, brand, SKU, and ratings that come from real reviews on the page.
118---

Structured data for products

Once descriptions are clean, add Product schema with Offer. Most store platforms generate it — check what is already there before adding a second, conflicting block.

Only mark up what is true and visible: price, availability, brand, SKU, and ratings that come from real reviews on the page.


Raw lines 112 to 119
120## Without Shopify or Wix
122Ask for the product export — most platforms have one — and return a corrected file for import.
124Say the path plainly: "Export your products to CSV, send me the file, and I'll send back a version with the titles, descriptions, alt text, and SEO fields rewritten. You import it and check the first few before letting it run."
126Same scoring, same revenue ordering, same batching in the review. The only difference is the owner clicks import.

Without Shopify or Wix

Ask for the product export — most platforms have one — and return a corrected file for import.

Say the path plainly: "Export your products to CSV, send me the file, and I'll send back a version with the titles, descriptions, alt text, and SEO fields rewritten. You import it and check the first few before letting it run."

Same scoring, same revenue ordering, same batching in the review. The only difference is the owner clicks import.

Raw lines 120 to 126