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.
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 5,551–5,600 of 12,819

PID Lang Original Name Proposed SEO Name Length Status / Bucket Actions
103264 1 CUSTOM QT 7.65X53 ARG MA
25 characters
25/70 Passed audit Unassigned
<h2><span style=background-color:#FFFF00;color:#000000;font-weight:bold;padding-bottom:3px;padding-left:7px;padding-right:7px;padding-top:3px;text-transform:uppercase;>FEATURES:</span></h2><ul></ul>
103265 1 Lee Precision Quick Trim Die .25-20 Winchester
46 characters
46/70 Passed audit Unassigned
&lt;p&gt;The&amp;nbsp;&lt;strong&gt;Lee Precision .25-20 Winchester Quick Trim Rifle Die&lt;/strong&gt;&amp;nbsp;is used in conjunction with the&amp;nbsp;&lt;strong&gt;Lee Precision Deluxe Quick Trim Case Trimmer&lt;/strong&gt;&amp;nbsp;or the&amp;nbsp;&lt;strong&gt;Lee Precision Value Trim Case Trimmer&lt;/strong&gt;.&lt;/p&gt;&lt;p&gt;When installed in a press like the&amp;nbsp;&lt;strong&gt;Lee Precision Breech Lock Challenger press&lt;/strong&gt;, it holds the trimmer in precise alignment with the case so no calipers, measurement or trial and error adjustment is required to precisely trim your cases.&lt;/p&gt;&lt;h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;&gt;&lt;strong&gt;&lt;b style=&quot;background-color: rgb(255, 255, 0); padding: 3px 7px; text-transform: uppercase;&quot;&gt;FEATURES:&lt;/b&gt;&lt;/strong&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Holds trimmer in precise alignment with the case.&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;No measurement or trial and error required.&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Quick and easy.&lt;/strong&gt;&lt;/li&gt;&lt;/ul&gt;
103266 1 CUSTOM QT 7X64 BRENNEKE
24 characters
24/70 Passed audit Unassigned
<h2><span style=background-color:#FFFF00;color:#000000;font-weight:bold;padding-bottom:3px;padding-left:7px;padding-right:7px;padding-top:3px;text-transform:uppercase;>FEATURES:</span></h2><ul></ul>
103267 1 Lee Precision APP Primer Pocket Swage Kit
41 characters
41/70 Passed audit Unassigned
&lt;h3&gt;This product has been redesigned and is no longer available.&lt;/h3&gt;&lt;h3&gt;&lt;br&gt; It has been replaced by &lt;a href=&quot;https://fsreloading.com/lee-precision-app-swage-kit-90237.html&quot;&gt;Lee Precision 90237 APP Swage Kit&lt;/a&gt;.&lt;/h3&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;The Lee Precision Primer Pocket Swager is designed exclusively for the APP press. &lt;/p&gt;&lt;p&gt;Now you can swage primer pockets as fast as you can operate the press lever. A universal shell holder adapter allows you to use your press shell holder or X-PRESS shell holder to swage a variety of foreign military brass.&amp;nbsp;&lt;/p&gt;&lt;p&gt;Primer pocket swaging is necessary when reloading brass that have crimped primer pockets, most cases used in military or non civilian applications have this crimp. Typical cases on which you will encounter primer pocket crimps are 45 ACP, 223(5.56mm), 30-06, 308(7.62x51), 9mm Luger and special law enforcement 40 S&amp;amp;W.&amp;nbsp;&lt;br&gt;&lt;/p&gt;&lt;p&gt;The hardened steel swage punch is automatically extracted from the primer pocket by five 400 pound force disc springs. The breech lock die body installs in seconds, no adjustment required.&amp;nbsp;&lt;br&gt;&lt;/p&gt;&lt;p&gt;Primer pocket swaging is so fast youll want to swage all range brass. Nothing reduces priming problems on a progressive press more than properly swaged primer pockets. With the Lee Primer Pocket Swage Kit, surplus military and police department brass becomes a great, low cost source of cases.&lt;br&gt;&lt;/p&gt;&lt;p&gt;Complete swaging set includes 223/5.56 NATO decapping and flaring die, automatic swage die with proper punch size and proper push die with universal shell holder adapter installed. Use X-PRESS shell holder (sold separately) and speed your cases through the swaging operation.&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;h2&gt;&lt;b style=&quot;background-color: rgb(255, 255, 0);&quot;&gt;Note:&amp;nbsp; &lt;/b&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong style=&quot;&quot;&gt;This product is for use in the Lee APP Press only.&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong style=&quot;&quot;&gt;A Universal Press Shell Holder or Lee X-PRESS Shell Holder is required to use with this swage kit. If you have the Lee Deluxe APP press, it will ship with the Lee Precision # 2, #4 and #19 XPRESS Shell Holders.&lt;br&gt;&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;/ul&gt;
103268 1 Lee Precision Bench Plate Instructions
38 characters
38/70 Passed audit Unassigned
&lt;p&gt;These instructions are for the metal Lee Precision Bench Plate that includes a steel base block.&lt;/p&gt;&lt;p&gt;This is a repair part for Lee Precision reloading tools. The product photos show a typical repair part of this type. There may be minor differences due to size variations and/or product version updates from Lee Precision.&lt;/p&gt;
103271 1 Hornady FMJ Bullets 10mm .400 180 Grain box of 100
50 characters
50/70 Passed audit Unassigned
&lt;p&gt;Hornady FMJ handgun bullets have long served as a standard for target shooting applications. Hornady FMJ bullets are built with a rugged jacket and the difference in performance is clear. The thinly plated full metal jacket from other manufacturers is easily distorted and often breaks or separates when the bullet impacts the target.&lt;br&gt;&lt;/p&gt;&lt;p&gt;Hornady FMJ bullets are carefully designed and manufactured to give superior functioning in semi-automatic handguns, and they deliver match-grade accuracy!&lt;/p&gt;&lt;h2&gt;&lt;b style=&quot;background-color: rgb(255, 255, 0);&quot;&gt;FEATURES:&lt;/b&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;strong style=&quot;font-weight: bold;&quot;&gt;BUILT FOR COMPETITION&lt;/strong&gt;&lt;br&gt;Expansion isn't an issue in action pistol shooting, so we removed the expansion-aiding skives. The result is a bullet that delivers the accuracy its sleek appearance promises.&lt;/li&gt;&lt;li&gt;&lt;strong style=&quot;font-weight: bold;&quot;&gt;NO EXPOSED LEAD&lt;/strong&gt;&lt;br&gt;A jam can cost the match for a competitive shooter, and that's why our jacket protects the nose of our FMJ bullet.&lt;/li&gt;&lt;li&gt;&lt;strong style=&quot;font-weight: bold;&quot;&gt;SWAGED CORE&lt;/strong&gt;&lt;br&gt;The core of the FMJ bullet is cold swaged from pure lead to deliver consistency, balance and stability in flight. It delivers pinpoint accuracy with every shot.&lt;/li&gt;&lt;/ul&gt;
103272 1 Armscor Bullets 10mm .400 diameter 180gr FMJ bag of 100
55 characters
55/70 Passed audit Unassigned
<p>Armscor bullets are made with precise tolerances to deliver performance down range with each shot.</p><p><br></p><h2><b style=&quot;background-color: rgb(255, 255, 0);&quot;>FITS:</strong></h2><ul><li><strong>10mm Auto</strong></li><li><strong>.40 S&amp;amp;W</strong></li></ul>
103310 1 MTM Case-Gard Four Pistol Case Black
36 characters
36/70 Passed audit Unassigned
<p><p>Designed to hold four handguns with barrel lengths up to 8'' long. Guns are held in place with a three-piece foam padding set. Larger ergonomic handle for easy carrying. Strong snapping latches. Padlock tabbed for security. There is also space available for a trigger lock.</p><h2><span style=&quot;background-color: rgb(255, 255, 0);&quot;>FEATURES:</span></h2><ul><li><strong>Four pistol, snap-latch, black textured finish handgun case</strong></li><li><strong>Rugged polypropylene with textured finish, thick foam padding and double</strong></li><li><strong>Holds up to four handguns with 8&quot; barrels or 6 sub-compacts with magazines</strong></li><li><strong>Outside Dimensions: 15.5&quot; x 12.2&quot; x 5.6&quot;</strong></li><li><strong>Inside Dimensions: 14&quot; x 10&quot; x 5.1&quot;</strong></li><li><strong>Twin padlock tabs </strong></li><li><strong>Made in USA</strong></li></ul><h2><b style=&quot;background-color: rgb(255, 255, 0);&quot;>PHOTO NOTE:</strong></h2></p><ul><li><strong>Firearms not included</strong></li></ul>
103311 1 MTM Case-Gard Pocket Pistol Case
33 characters
33/70 Passed audit Unassigned
<p>For All subcompacts &amp;amp; most compact semi-auto's and revolvers barrel lengths 2&quot; or less.</p><p>Outside dimensions: 9.5&quot; x 5.9&quot; x 2.1&quot;</p><p><br></p><h2><b style=&quot;background-color: rgb(255, 255, 0);&quot;>PHOTO NOTE:</strong></h2><ul><li><strong>Hand Gun not included</strong></li></ul>
103312 1 MTM Case-Gard Compact Handgun Case
34 characters
34/70 Passed audit Unassigned
&lt;p&gt;This small case fits a standard Colt .45 Caliber 1911-A1 perfectly. It is also great for carrying all pocket-sized handguns with barrel lengths of 3&quot; or less.&amp;nbsp;&amp;nbsp;The 803, with most pistols, leaves just enough room inside for a spare magazine.&lt;/p&gt;&lt;h2&gt;&lt;b style=&quot;background-color: rgb(255, 255, 0);&quot;&gt;FEATURES:&lt;/b&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Inside Dim.: 9.0&quot; x 5.6&quot; x 2.0&quot;&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Outside Dim.: 9.6&quot; x 6.5&quot; x 2.2&quot;&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Fits all compacts and most full-size semi-auto's.&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Fits revolvers 3&quot; or less.&lt;/strong&gt;&lt;/li&gt;&lt;/ul&gt;&lt;h2&gt;&lt;b style=&quot;background-color: rgb(255, 255, 0);&quot;&gt;PHOTO NOTE:&lt;/b&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Handgun not included&lt;/strong&gt;&lt;/li&gt;&lt;/ul&gt;
103356 1 AR15 Mustang Steel Muzzle Compensator/crush washer
50 characters
50/70 Passed audit Unassigned
103357 1 AK47 Mustang Steel Muzzle Compensator
37 characters
37/70 Passed audit Unassigned
103358 1 AR15 Spitfire Steel Muzzle Compensator w/crush washer
53 characters
53/70 Passed audit Unassigned
103359 1 AK47 Spitfire Steel Muzzle Compensator
38 characters
38/70 Passed audit Unassigned
103360 1 AR15 Razor Steel Muzzle Compensator w/crush washer
50 characters
50/70 Passed audit Unassigned
103361 1 AK47 Razor Steel Muzzle Compensator
35 characters
35/70 Passed audit Unassigned
103362 1 .22 Cal., .224 Diam., 55 gr FMJ-BT w/c 500 Qty Box
51 characters
51/70 Passed audit Unassigned
103397 1 9mm Casings, 500 Qty Jug
24 characters
24/70 Passed audit Unassigned
103399 1 9mm Casings, 1000 Qty Jug
25 characters
25/70 Passed audit Unassigned
103401 1 38 Special Casing 500 Qty Jug
30 characters
30/70 Passed audit Unassigned
103403 1 .40 S&W Casings, 500 Qty Jug
28 characters
28/70 Passed audit Unassigned
103405 1 .40 &W Casings, 1000 Qty Jug
28 characters
28/70 Passed audit Unassigned
103407 1 Lightning Ammo .45 ACP Casings Jug of 500
41 characters
41/70 Passed audit Unassigned
<p style=&quot;margin-bottom: 10px; color: rgb(102, 102, 102); font-size: 14px;&quot;>Lighting Ammo brass cases have been cleaned and polished. Theses cases have not been de-primed or resized.</p><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(68, 68, 68); margin-top: 20px; margin-bottom: 10px; font-size: 27px;&quot;><span style=&quot;font-weight: 700; background-color: rgb(255, 255, 0);&quot;>FEATURES:</span></h2><ul style=&quot;margin-bottom: 10px; color: rgb(102, 102, 102); font-size: 14px;&quot;><li><strong><span style=&quot;font-weight: 700;&quot;>.45 ACP</span></strong></li><li><strong><span style=&quot;font-weight: 700;&quot;>Cleaned</span></strong></li><li><strong><span style=&quot;font-weight: 700;&quot;>Polished</span></strong></li><li><strong><span style=&quot;font-weight: 700;&quot;>Mixed head stamps</span></strong></li></ul>
103408 1 .44 Magnum Casing 100+ Qty Bag **
40 characters
40/70 Passed audit Unassigned
103409 1 Lightning Ammo .45 ACP Casings jug of 1000
42 characters
42/70 Passed audit Unassigned
<p>Lighting Ammo brass cases have been cleaned and polished. Theses cases have not been de-primed or resized.</p><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><b style=&quot;background-color: rgb(255, 255, 0);&quot;>FEATURES:</strong></h2><ul><li><strong>.45 ACP</strong></li><li><strong>Cleaned</strong></li><li><strong>Polished</strong></li><li><strong>Mixed head stamps</strong></li></ul>
103410 1 .45 Colt Casing 100+ Qty Bag **
37 characters
37/70 Passed audit Unassigned
103411 1 .380 ACP Casings, 500 Qty Jug
29 characters
29/70 Passed audit Unassigned
103412 1 .357 Magnum Casing 100+ Qty Bag
33 characters
33/70 Passed audit Unassigned
103413 1 .380 ACP Casings, 1000 Qty Jug
30 characters
30/70 Passed audit Unassigned
103415 1 .357 Magnum Casing 500 Qty Jug
32 characters
32/70 Passed audit Unassigned
103416 1 9MM Reconditioned Fired Brass Casing 500+ Qty Jug
50 characters
50/70 Passed audit Unassigned
103417 1 .45 ACP Reconditioned Fired Brass Casing, 500+ Qty Jug
54 characters
54/70 Passed audit Unassigned
103418 1 9MM Reconditioned Brass Casing 1000+ Qty Jug
44 characters
44/70 Passed audit Unassigned
103419 1 .45 ACP Reconditioned Brass Casing 1000+ Qty Jug
49 characters
49/70 Passed audit Unassigned
103420 1 .40 S&W Reconditioned & Rollsized Fired Brass 500+
51 characters
51/70 Passed audit Unassigned
103421 1 .380 Reconditioned Fired Brass Casing, 500+ Qty Jug
51 characters
51/70 Passed audit Unassigned
103422 1 .40 S&W Reconditioned & Rollsized Casing 1000+ Jug
50 characters
50/70 Passed audit Unassigned
103423 1 .380 Reconditioned Brass Casing 1000+ qty
42 characters
42/70 Passed audit Unassigned
103432 1 7.62/.308 Recond. Brass Casing 250+ Qty Jug **
47 characters
47/70 Passed audit Unassigned
103433 1 5.56/.223 Cal. Recond. Brass 1000+ Qty Jug
42 characters
42/70 Passed audit Unassigned
103434 1 7.62/.308 Recond. Brass Casing 500+ Qty Jug **
47 characters
47/70 Passed audit Unassigned
103435 1 300 AAC Recond. Brass Casing 500+ Qty Jug **
46 characters
46/70 Passed audit Unassigned
103436 1 300 AAC Recond. Brass Casing 1000+ Qty Jug **
45 characters
45/70 Passed audit Unassigned
103439 1 9mm Brass & 9mm Cal,.356 Dia, 125 gr. RN Lead Cast Bullets
58 characters
58/70 Passed audit Unassigned
103444 1 9mm Brass &9mm Cal,.356 Dia, 125 gr. RN Lead Cast Bullets
57 characters
57/70 Passed audit Unassigned
103445 1 .40 Brass & .40 Cal, .400 Dia, 155 gr, SWC Lead Cast Bullets
60 characters
60/70 Passed audit Unassigned
103448 1 223 Brass &.22 Cal. .224 Diam. 55 Gr FMJ-BT Bullets 100 EACH
60 characters
60/70 Passed audit Unassigned
103449 1 223 Brass &.22 Cal. .224 Diam. 55 Gr FMJ-BT Bullets 500 EACH
60 characters
60/70 Passed audit Unassigned
103452 1 Yamaha YACCL4C Bb 4C Clarinet Mouthpiece (CL-4C)
48 characters
48/70 Passed audit Unassigned
&lt;p&gt;The Yamaha 4C Bb clarinet mouthpiece is made of high quality resin designed to produce a well-balanced tone with all the flexibility the player requires. This Yamaha mouthpiece provides a well-balanced tone over all octaves. Great for professionals and beginners alike&lt;br&gt;&lt;/p&gt;
103454 1 Yamaha Clarinet Maintenance Kit
31 characters
31/70 Passed audit Unassigned
&lt;p&gt;Protect and maintain your clarinet with genuine Yamaha accessories to keep it in excellent condition for years to come.&lt;/p&gt;&lt;h2&gt;&lt;strong&gt;INCLUDES:&lt;/strong&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Care &amp;amp; Maintenance Manual&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Tone Hole Cleaners&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Pad Cleaning Paper&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Mouthpiece Brush&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Polishing Cloth&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Cleaning Swab&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Cork Grease&lt;/strong&gt;&lt;/li&gt;&lt;/ul&gt;