Product Name Cleanup — Phase 4

Product Name Cleanup — Functional Description

This dashboard reviews pd_name_cleanup_staging and writes approved English product titles and specification snippets into oc_product_description. Filter the queue, edit a proposed title or HTML snippet in place, approve unflagged rows, then commit approved batches. A commit reads the live description, removes an existing cleanup block, appends the new snippet between PD_CLEANUP comment markers, and stores the proposed name. Titles longer than 70 characters stay flagged and are not written to the catalog.

Operator Workflow

Work through these five steps in order. You do not need to edit code or open the database.

Step 1

Export Batches

  • Go to the Phase 3 Batch Dashboard.
  • Click Generate Batch JSON Files (250 items/batch) in Module A.
  • Click Download All as ZIP to save grok_batch_*.json files locally.
Step 2

Process in Cursor

  • Open the batch in Cursor AI.
  • Copy the prompt from the Phase 3 Batch Dashboard, then paste it into the Cursor chat window.
  • Let Cursor save grok_batch_XXX_done.json.
Step 3

Upload & Import

  • Return to the Phase 3 Batch Dashboard.
  • Drag your *_done.json files into Module B and click Upload *_done.json Files.
  • Click Import Uploaded *_done.json Files to Staging in Module C.
Step 4

Audit Staging

  • Review completed rows on this Phase 4 Review Dashboard.
  • Inline edit any titles exceeding 70 characters until the length badges turn green.
Step 5

Commit Live

  • Approve reviewed rows, then click Commit Approved Batches to Production.
  • That writes optimized titles and feature lists into the live OpenCart tables.

Technical reference

  • Passed Audit is passed_audit. Bucket A (Auto) is auto_processed. Bucket B (AI) is ai_completed. Flagged Review is is_flagged = 1 or a proposed title over 70 characters.
  • Filters cover status, bucket, and a keyword matched to product id, original name, or proposed name. Pagination links and the page jump keep those filters.
  • The grid loads 50 rows at a time. Choose 25 or 100 on the filter bar. Spec drawers open under the row.
  • Changing a proposed title or snippet saves that product and language immediately. The length badge is green at 70 characters or fewer and red above 70.
  • Approve sets staging status to approved and does not change the live catalog. Approve Visible Page does that for every unflagged, non-committed row on this page whose proposed title is 1 to 70 characters.
  • Commit Approved Batches to Production processes English rows (language_id = 1) with status approved and is_flagged = 0, in batches of 250. Each batch is one database transaction.
  • The live description is cleaned with the PD_CLEANUP comment pattern. If that pattern fails, the product is flagged REGEXP_STRIP_FAILURE and skipped. A failed batch rolls back. The browser retries up to 3 times, waiting 3 seconds between tries.
  • Original names and descriptions on the staging row are not rewritten here. Every production update binds both product_id and language_id.
Total Catalog
29,011
Passed Audit
12,819
Bucket A (Auto)
11,592
Bucket B (AI)
499
Flagged Review
0
Approved
0
Committed
1
Clear

This writes approved, unflagged English titles (language_id = 1) into oc_product_description in batches of 250. Each batch is one transaction. A failed batch rolls back and the page retries it.

0%

Showing 29,001–29,011 of 29,011

PID Lang Original Name Proposed SEO Name Length Status / Bucket Actions
137854 1 Berry's 40 Caliber (0.401") 180gr Round Shoulder Box of 1,000
66 characters
0/70 AI ready Bucket B
<p>Berry's Superior Plated Bullets are swaged and plated to final weight and re-struck for accuracy and precision. They are more affordable than jacketed rounds and won't foul your barrel with lead.</p><h2><b>FEATURES:</b></h2><ul><li><b>SAAMI MAX 40 COL=1.135".</b></li><li><b>SAAMI MAX 10mm COL=1.250".</b></li><li><b>Can withstand velocities up to 1250 fps.</b></li></ul>
137855 1 Summit City Bullets 10mm / .40 Caliber 180 Gr FPNLG BB HI-Tek Coated Bullets Case of 2500
89 characters
0/70 AI ready Bucket B
<p>These 10/40 caliber, .400" diameter, 180 grain Flat Point (FP) No Lube Groove (NLG) cast lead bullets are made from 92-6-2 commercial casting alloy and coated with Hi-Tek Heat Set Supercoat that molecularly bonds to the lead encasing the entire projectile in a protective shell that is self-lubricating.</p><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b style="background-color: rgb(255, 255, 0);">FEATURES:</b></h2><ul><li><b>Bevel Base (BB)</b></li><li><b>Flat Point (FP)</b></li><li><b>No Lube Groove</b></li><li><b>Sized at .400" diameter</b></li><li><b>No additional lubrication is required. </b></li><li><b>Great for competitive shooting, practice, and small game and medium game</b></li></ul><p><b>What does this mean to you?</b></p><p><b>No messy wax lubes that smoke when fired, gum up your reloading dies and bullet feeders, and require extra work and expense to apply. And since the bullet is totally encapsulated, it also greatly reduces your exposure to lead. </b></p>
137856 1 Dunlop TORTEX Standard Bulk Variety Pack of 12 Picks
52 characters
52/70 Passed audit Unassigned
<p>The pick used by top musicians worldwide</p><p>Tortex® picks are carefully designed and manufactured to give the characteristic maximum memory and minimum wear that made original tortoise shell famous.</p><p>Dunlop Tortex guitar picks are manufactured from Delrin, a highly durable, crystalline thermoplastic material. Developed as a high-quality, synthetic alternative to tortoiseshell, Tortex picks feature a specialized matte, treatment process that enhances grip and produces an aggressive, sharp, and crisp attack.</p><h2><b>FEATURES:</b></h2><ul><li><b>Color-coded gauges </b></li><li><b>Snappy attack</b></li><li><b>Textured surface</b></li><li><b>Superior durability</b></li></ul><h2><b>INCLUDES 2 Each Of:</b></h2><ul><li><b>.50mm Red</b></li><li><b>.60mm Orange</b></li><li><b>.73mm Yellow</b></li><li><b>.88mm Green</b></li><li><b>1.0mm Blue</b></li><li><b>1.14mm Purple</b></li></ul> <p>TORTEX and the DUNLOP logo are © 2026 Dunlop Manufacturing, Inc. All rights reserved. TORTEX and the DUNLOIP logo are trademarks of Dunlop Manufacturing Inc.</p>
137857 1 Dunlop TORTEX Standard .50mm Red Pack of 12 Picks
49 characters
49/70 Passed audit Unassigned
<p>The pick used by top musicians worldwide</p><p>Tortex® picks are carefully designed and manufactured to give the characteristic maximum memory and minimum wear that made original tortoise shell famous.</p><p>Dunlop Tortex guitar picks are manufactured from Delrin, a highly durable, crystalline thermoplastic material. Developed as a high-quality, synthetic alternative to tortoiseshell, Tortex picks feature a specialized matte, treatment process that enhances grip and produces an aggressive, sharp, and crisp attack.</p><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>FEATURES:</b></h2><ul><li><b>Color-coded gauges</b></li><li><b>Snappy attack</b></li><li><b>Textured surface</b></li><li><b>Superior durability</b></li></ul><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>INCLUDES:</b></h2><ul><li><b>12 red .50mm Tortex picks.</b></li></ul><p>TORTEX and the DUNLOP logo are © 2026 Dunlop Manufacturing, Inc. All rights reserved. TORTEX and the DUNLOIP logo are trademarks of Dunlop Manufacturing Inc.</p>
137858 1 Dunlop TORTEX Standard .60mm Orange Pack of 12 Picks
52 characters
52/70 Passed audit Unassigned
<p>The pick used by top musicians worldwide</p><p>Tortex® picks are carefully designed and manufactured to give the characteristic maximum memory and minimum wear that made original tortoise shell famous.</p><p>Dunlop Tortex guitar picks are manufactured from Delrin, a highly durable, crystalline thermoplastic material. Developed as a high-quality, synthetic alternative to tortoiseshell, Tortex picks feature a specialized matte, treatment process that enhances grip and produces an aggressive, sharp, and crisp attack.</p><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>FEATURES:</b></h2><ul><li><b>Color-coded gauges</b></li><li><b>Snappy attack</b></li><li><b>Textured surface</b></li><li><b>Superior durability</b></li></ul><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>INCLUDES:</b></h2><ul><li><b>12 orange .60mm Tortex picks.</b></li></ul><p>TORTEX and the DUNLOP logo are © 2026 Dunlop Manufacturing, Inc. All rights reserved. TORTEX and the DUNLOIP logo are trademarks of Dunlop Manufacturing Inc.</p>
137859 1 Dunlop TORTEX Standard .73mm Yellow Pack of 12 Picks
52 characters
52/70 Passed audit Unassigned
<p>The pick used by top musicians worldwide</p><p>Tortex® picks are carefully designed and manufactured to give the characteristic maximum memory and minimum wear that made original tortoise shell famous.</p><p>Dunlop Tortex guitar picks are manufactured from Delrin, a highly durable, crystalline thermoplastic material. Developed as a high-quality, synthetic alternative to tortoiseshell, Tortex picks feature a specialized matte, treatment process that enhances grip and produces an aggressive, sharp, and crisp attack.</p><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>FEATURES:</b></h2><ul><li><b>Color-coded gauges</b></li><li><b>Snappy attack</b></li><li><b>Textured surface</b></li><li><b>Superior durability</b></li></ul><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>INCLUDES:</b></h2><ul><li><b>12 orange .73mm Tortex picks.</b></li></ul><p>TORTEX and the DUNLOP logo are © 2026 Dunlop Manufacturing, Inc. All rights reserved. TORTEX and the DUNLOIP logo are trademarks of Dunlop Manufacturing Inc.</p>
137860 1 Dunlop TORTEX Standard .88mm Green Pack of 12 Picks
51 characters
51/70 Passed audit Unassigned
<p>The pick used by top musicians worldwide</p><p>Tortex® picks are carefully designed and manufactured to give the characteristic maximum memory and minimum wear that made original tortoise shell famous.</p><p>Dunlop Tortex guitar picks are manufactured from Delrin, a highly durable, crystalline thermoplastic material. Developed as a high-quality, synthetic alternative to tortoiseshell, Tortex picks feature a specialized matte, treatment process that enhances grip and produces an aggressive, sharp, and crisp attack.</p><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>FEATURES:</b></h2><ul><li><b>Color-coded gauges</b></li><li><b>Snappy attack</b></li><li><b>Textured surface</b></li><li><b>Superior durability</b></li></ul><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>INCLUDES:</b></h2><ul><li><b>12 green .88mm Tortex picks.</b></li></ul><p>TORTEX and the DUNLOP logo are © 2026 Dunlop Manufacturing, Inc. All rights reserved. TORTEX and the DUNLOIP logo are trademarks of Dunlop Manufacturing Inc.</p>
137861 1 Dunlop TORTEX Standard 1.0mm Blue Pack of 12 Picks
50 characters
50/70 Passed audit Unassigned
<p>The pick used by top musicians worldwide</p><p>Tortex® picks are carefully designed and manufactured to give the characteristic maximum memory and minimum wear that made original tortoise shell famous.</p><p>Dunlop Tortex guitar picks are manufactured from Delrin, a highly durable, crystalline thermoplastic material. Developed as a high-quality, synthetic alternative to tortoiseshell, Tortex picks feature a specialized matte, treatment process that enhances grip and produces an aggressive, sharp, and crisp attack.</p><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>FEATURES:</b></h2><ul><li><b>Color-coded gauges</b></li><li><b>Snappy attack</b></li><li><b>Textured surface</b></li><li><b>Superior durability</b></li></ul><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>INCLUDES:</b></h2><ul><li><b>12 blue 1.0mm Tortex picks.</b></li></ul><p>TORTEX and the DUNLOP logo are © 2026 Dunlop Manufacturing, Inc. All rights reserved. TORTEX and the DUNLOIP logo are trademarks of Dunlop Manufacturing Inc.</p>
137862 1 Dunlop TORTEX Standard 1.14mm Purple Pack of 12 Picks
53 characters
53/70 Passed audit Unassigned
<p>The pick used by top musicians worldwide</p><p>Tortex® picks are carefully designed and manufactured to give the characteristic maximum memory and minimum wear that made original tortoise shell famous.</p><p>Dunlop Tortex guitar picks are manufactured from Delrin, a highly durable, crystalline thermoplastic material. Developed as a high-quality, synthetic alternative to tortoiseshell, Tortex picks feature a specialized matte, treatment process that enhances grip and produces an aggressive, sharp, and crisp attack.</p><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>FEATURES:</b></h2><ul><li><b>Color-coded gauges</b></li><li><b>Snappy attack</b></li><li><b>Textured surface</b></li><li><b>Superior durability</b></li></ul><h2 style="font-family: "Open Sans", sans-serif; color: rgb(0, 0, 0);"><b>INCLUDES:</b></h2><ul><li><b>12 purple 1.14mm Tortex picks.</b></li></ul><p>TORTEX and the DUNLOP logo are © 2026 Dunlop Manufacturing, Inc. All rights reserved. TORTEX and the DUNLOIP logo are trademarks of Dunlop Manufacturing Inc.</p>
137863 1 Tube of 20 - 1 oz American Silver Eagle Coins BU - Random Years - JM Bullion Sealed
83 characters
0/70 AI ready Bucket B
<p><b>Authentic JM Bullion Sealed Tube – 20 Troy Ounces of .999 Fine Silver</b></p><p>Up for sale is a complete tube of 20 American Silver Eagle coins, each containing 1 troy ounce of .999 pure silver. This tube is Sealed by JM Bullion, meaning it was taken directly from a U.S. Mint Monster Box and immediately sealed. This ensures the coins have remained untouched and unsearched since leaving the mint. The tube is just as we received it from JM Bullion in 2020.</p><p><span style="color: inherit; font-family: inherit; font-size: 25px;">Item Specifics</span></p><ul><li><b>Brand/Mint:</b> U.S. Mint / JM Bullion Sealed</li><li><b>JM Bullion Product ID:</b> 5543286</li><li><b>Composition:</b> Silver</li><li><b>Fineness:</b> 0.999</li><li><b>Precious Metal Content:</b> 20 oz total (1 oz per coin)</li><li><b>Condition:</b> Brilliant Uncirculated (BU)</li><li><b>Year:</b> Random Years. This tube contains coins with dates chosen by JM Bullion, providing  the iconic Adolph A. Weinman "Walking Liberty" design.</li><li><b>Sovereign Backing:</b> Each coin carries a $1 USD face value fully backed by the United States government.</li></ul><p><b>Shipping & Handling:</b></p><p>The tube will be shipped securely in protective packaging to ensure it arrives in the exact condition pictured. All shipments are fully insured for your peace of mind.</p>
137864 1 Tube of 25 - 2022 1 oz Australian Silver Kangaroo Coins BU - Perth Mint Sealed
78 characters
0/70 AI ready Bucket B
<p><b>Original Perth Mint Sealed Tube – 25 Troy Ounces of .9999 Fine Silver</b></p><p>This is a full, unopened mint tube of 25 Australian Silver Kangaroo coins from 2022. Each coin is struck in 1 troy ounce of .9999 pure silver, making them some of the purest sovereign bullion coins available on the market today.</p><h3><b>Item Specifics:</b></h3><ul><li><b>Brand/Mint:</b> The Perth Mint (Australia)</li><li><b>JM Bullion Product ID:</b> 4181501</li><li><b>Composition:</b> Silver</li><li><b>Fineness:</b> .9999 Fine Silver (Four-Nines)</li><li><b>Precious Metal Content:</b> 25 oz total (1 oz per coin)</li><li><b>Condition:</b> Brilliant Uncirculated (BU)</li><li><b>Year:</b> 2022</li></ul><h3><b>Key Features:</b></h3><p><b>Factory Sealed Security:</b> This tube features the original Perth Mint holographic tamper-evident seal. This ensures the coins have remained untouched and unsearched since they left the mint in Australia.</p><p><b>High Purity:</b> Unlike many other sovereign coins, the Kangaroo is minted at .9999 fineness (four-nines).</p><p><b>Iconic Design:</b> The reverse features the classic bounding red kangaroo design by Dr. Stuart Devlin, surrounded by a unique sunburst pattern that also acts as an authentication feature.</p><p><b>2022 Edition:</b> This tube contains the 2022 issue, featuring the Jody Clark effigy of Her Majesty Queen Elizabeth II on the obverse.</p><h3><b>Investment Value:</b></h3><p>With 25 ounces per tube, this is a highly efficient way to add significant silver weight to your stack. The Australian Silver Kangaroo is recognized worldwide for its quality and liquidity.</p><h3><b>Shipping & Handling:</b></h3><p>The tube will be packed with care to ensure the holographic seal remains intact during transit. Shipped with full insurance and tracking provided.</p>