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 3,101–3,150 of 12,819

PID Lang Original Name Proposed SEO Name Length Status / Bucket Actions
4370 1 Caldwell Tac Ops Holster Glock 26 RH (27/33)
44 characters
44/70 Passed audit Unassigned
4371 1 Caldwell Tac Ops Holster Glock 34
33 characters
33/70 Passed audit Unassigned
4372 1 Caldwell Tac Ops Holster Glock 42
33 characters
33/70 Passed audit Unassigned
4373 1 Caldwell Tac Ops Holster S&W M&P Shield
39 characters
39/70 Passed audit Unassigned
4374 1 Caldwell Tac Ops Holster S&W M&P 9mm
36 characters
36/70 Passed audit Unassigned
4375 1 Caldwell Tac Ops Holster S&W M&P Compact
48 characters
48/70 Passed audit Unassigned
4376 1 Caldwell Tac Ops Holster S&W Bodyguard 380
42 characters
42/70 Passed audit Unassigned
4377 1 Caldwell Tac Ops Holster S&W J Frame Revolver
45 characters
45/70 Passed audit Unassigned
4378 1 Caldwell Tac Ops Holster Taurus 24/7
36 characters
36/70 Passed audit Unassigned
4381 1 Caldwell Tac Ops Holster M1911
30 characters
30/70 Passed audit Unassigned
4383 1 Caldwell Tac Ops Holster Sig Sauer P226
39 characters
39/70 Passed audit Unassigned
4389 1 Caldwell Tac Ops Magazine Holster 1911
38 characters
38/70 Passed audit Unassigned
4394 1 Caldwell Tac Ops IWB Covert RH 3.75-4.5
39 characters
39/70 Passed audit Unassigned
4395 1 Caldwell Tac Ops IWB Covert RH 2-3 Revolver
43 characters
43/70 Passed audit Unassigned
4396 1 Caldwell Tac Ops IWB Covert RH 4 Revolver
41 characters
41/70 Passed audit Unassigned
4400 1 Caldwell Tac Ops Drop Leg Rig
29 characters
29/70 Passed audit Unassigned
4401 1 Caldwell Tac Ops Holster M.O.L.L.E. Attachment
46 characters
46/70 Passed audit Unassigned
4402 1 Caldwell Tac Ops Holster Belt Clip
34 characters
34/70 Passed audit Unassigned
4403 1 Caldwell Tac Ops Duty Belt Sm 28-36
35 characters
35/70 Passed audit Unassigned
4404 1 Caldwell Tac Ops Duty Belt Md 34-42
35 characters
35/70 Passed audit Unassigned
4405 1 Caldwell Tac Ops Duty Belt Lg 40-48
35 characters
35/70 Passed audit Unassigned
4406 1 Caldwell Tac Ops Duty Belt XL 48-56
35 characters
35/70 Passed audit Unassigned
4407 1 Frankford Arsenal Platinum Series Rotary Tumbler Spare Drum
59 characters
59/70 Passed audit Unassigned
<p>Spare drum for the Frankford Arsenal Rotary Tumbler. Includes a .7 liter capacity dual layer drum with noise dampening rubber lining and 2 end caps.</p><p>Need More Capacity? Pick up a spare Tumbler drum. The Frankford Arsenal Platinum Series Series Spare Rotary Tumbler Drum is the perfect addition for the high capacity reloaders.</p><p> </p><h2><b>Features:</b></h2><ul><li><strong>2 clear end caps included</strong></li><li><strong>Brass comes out cleaner than brand new brass</strong></li><li><strong>Dual layer drum with noise dampening rubber lining</strong></li><li><strong>Large 7 liter capacity can tumble up to 1000 cases of .223 brass</strong></li></ul>
4408 1 Frankford Arsenal Platinum Series Wet/Dry Media Separator
57 characters
57/70 Passed audit Unassigned
<p>The <strong>Frankford Arsenal Platinum Series Wet/Dry Media Separator</strong> easily separates brass from wet or dry media and separates wet media from water in a single operation. Dual cranks allow ambidextrous use.</p><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> <li><strong>The tub top includes a mesh strainer to rinse brass during wet separating to remove any left over cleaning solution</strong></li> <li><strong>Mesh strainers for draining the water from the tub base without losing stainless steel pins</strong></li> <li><strong>Includes two sifting handles for ambidextrous use when separating brass from media</strong></li> <li><strong>Rugged rubber latch keeps sifter closed even with heavy loads of brass and media</strong></li> <li><strong>Perforated sifter allows media to fall through while retaining cleaned brass!</strong></li> <li><strong>Spill proof tub fully captures water, dry media and stainless steel pins</strong></li> <li><strong>Includes 2 installed strainers to separate wet media from water!</strong></li> <li><strong>I<strong>deal for both wet or dry cleaning processes!</strong></li></ul>
4410 1 Frankford Arsenal Case Prep Power Expansion Kit
47 characters
47/70 Passed audit Unassigned
<p>The <strong>Frankford Arsenl Case Prep Expansion Kit</strong> works with the Frankford Arsenal Case Trim &amp;amp; Prep Center to remove military crimps.</p><p><br></p><h2><span style=&quot;background-color:#FFFF00;color:#000000;font-weight:bold;padding-bottom:3px;padding-left:7px;padding-right:7px;padding-top:3px;text-transform:uppercase;&quot;>Features:</span></h2><ul><li><strong>Standard 8-32 threads fits Case Trim &amp;amp; Prep Center's auxiliary shafts</strong></li><li><strong>Large and small primer pocket uniformer/cleaner</strong></li><li><strong>Large and small primer pocket crimp remover</strong></li><li><strong>Made of hardened high speed steel (HSS)</strong></li></ul>
4411 1 Frankford Arsenal Case Prep Essentials Kit
42 characters
42/70 Passed audit Unassigned
&lt;p&gt;The &lt;strong&gt;Frankford Arsenal Platinum Series Case Prep Essentials Kit&lt;/strong&gt; is a great all in one hand kit for prepping your brass. The kit includes 2 handles inside and outside chamfer tools large and small primer pocket uniformer/cleaner large and small primer pocket crimp remover and a handy storage case. All metal tools are made of hardened high speed steel.&lt;/p&gt;&lt;ul&gt; &lt;li&gt;&lt;strong&gt;Large &amp; small primer pocket uniformer/cleaner&lt;/strong&gt;&lt;/li&gt; &lt;li&gt;&lt;strong&gt;Large &amp; small primer pocket crimp cutter tools&lt;/strong&gt;&lt;/li&gt; &lt;li&gt;&lt;strong&gt;Made of hardened high speed steel&lt;/strong&gt;&lt;/li&gt; &lt;li&gt;&lt;strong&gt;Inside chamfer tool &lt;/strong&gt;&lt;/li&gt; &lt;li&gt;&lt;strong&gt;Outside deburr tool&lt;/strong&gt;&lt;/li&gt;&lt;/ul&gt;
4433 1 Lockdown Accessories Essentials Kit
35 characters
35/70 Passed audit Unassigned
<p>The Lockdown Vault Accessory Essentials Kit is perfect for setting up a new safe. The Dehumidifier Rod eliminates moisture and protects from rust, corrosion and mildew which is harmful for all firearm collections. The Handgun Hanger makes great use of the lost space on the door, letting you hang handguns where you desire. The Hygrometer is great for visually monitoring the humidity level inside your safe. The Automatic Cordless Vault Light allows you to position exactly where more light needs to be shed. Lockdown is the most comprehensive line of vault accessories available today. A wide variety of items designed to enhance organization, control climate and generally improve the usability of your vault.</p><h2>Features:</h2><ul><li><strong>Contains: 12&Prime; Dehumidifier Rod, Handgun Hanger, Hygrometer &amp; Automatic Cordless Vault Light</strong></li><li><strong>Protects from rust, corrosion and mildew with the Dehumidifier Rod</strong></li><li><strong>Makes use of lost space with the Handgun Hanger</strong></li><li><strong>Monitor safe humidity levels with the Hygrometer</strong></li><li><strong>Positional light for dark spots under shelves with Automatic Cordless Vault Light</strong></li></ul>
4435 1 Lockdown Cordless 75 LED Vault Light
36 characters
36/70 Passed audit Unassigned
<p>The Lockdown LED Vault Light has 75 Ultra-Bright LEDS with 95 total lumen output. It runs on 3 AAA batteries (not included) and has built in magnetic and screw mounting options. Mount it on walls or shelves to illuminate all the dark corners of your vault. </p><p><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><li><strong>75 Ultra-Bright LEDS</strong></li><li><strong>95 Lumen Output </strong></li></ul>
4436 1 Lockdown Automatic Cordless 25 LED Vault Light, 2pk
51 characters
51/70 Passed audit Unassigned
<p>The Lockdown Automatic Cordless 25 LED Vault Light turns on when you open your vault door an shuts off when you close your vault door.</p><h2>Features:</h2><ul><li><strong>Auto ON/OFF sensor turns the lights on when you open the vault and off after you close the vault</strong></li><li><strong>Two 25 LED lights with 70 Lumens output each</strong></li><li><strong>Auto ON/OFF light/motion sensor</strong></li><li><strong>Strong magnet or screw attachment</strong></li><li><strong>Uses 3 &quot;AAA&quot; batteries each (not included)</strong></li><li><strong>70 Lumen output per light</strong></li><li><strong>6hr continuous runtime per light</strong></li><li><strong>Standby time 8,700hrs</strong></li><li><strong>Sensor range 5 meters</strong></li><li><strong>Sensor angle 120o</strong></li></ul>
4437 1 Lockdown AR-15 Magazine Rack
28 characters
28/70 Passed audit Unassigned
<p>The Lockdown Magazine Rack is ideal for keeping AR-15 magazines organized. It conveniently holds up to 10 magazines either loaded or unloaded. It is designed to stand upright on a shelf or any flat surface or it can easily be mounted to a wall or vault door. It is compatible with both mil-spec and polymer mags. Holds any &ldquo;in line&rdquo; magazine from 10 round up to 30 round. The vinyl coated steel structure is durable and wont scratch or mar surface finishes.</p><p>Features:</p><ul><li><strong>Organizing and free up room in your vault or gun room</strong></li><li><strong>Holds up to 10 AR-15 magazines</strong></li><li><strong>Compatible with all in line mags from 10 round up to 30 round</strong></li><li><strong>Free-standing or wall mountable</strong></li><li><strong>Vinyl coated to protect magazines from scratching and marring</strong></li><li><strong>Robust steel frame can hold 10 fully loaded 30-round magazines</strong></li></ul>
4438 1 Lockdown Handgun / AR Upper Hanger
34 characters
34/70 Passed audit Unassigned
4439 1 Lockdown Universal Vault Door Organizer, Medium
47 characters
47/70 Passed audit Unassigned
4441 1 Lockdown Gun Concealment Magnet
31 characters
31/70 Passed audit Unassigned
4442 1 Lockdown Night Guardian Gun Holster, Handgun
44 characters
44/70 Passed audit Unassigned
4443 1 Lockdown Night Guardian Gun Holster, Long Gun
45 characters
45/70 Passed audit Unassigned
4444 1 Lockdown AR-15 Mag Well Lock
28 characters
28/70 Passed audit Unassigned
<p>The Lockdown AR-15 Mag Well Lock conveniently locks into the magazine well of any AR-15 platform gun to secure the gun in an unfireable condition. It engages into the bolt raceway while holding the bolt carrier partially open, completely disabling the firing mechanism. This also prevents the upper from being disassembled from the lower. A high strength coated steel cable and pin are included that allow the lock and gun to be anchored to any stationary object such as a frame member in a vehicle. Glass reinforced Nylon construction is durable and robust, yet is non-marring or damaging for inserting in your magazine well. Two keys included. Works with any Mil-Spec AR-15 Fully disables the firing mechanism Prevents disassembly of the upper and lower Prevents a magazine from being loaded into the firearm Comes with theft deterrent steel anchoring cable</p>
4445 1 Lockdown AR-15 Mag Well Lock with Wall Mount
44 characters
44/70 Passed audit Unassigned
<p>The AR-15 Mag Well Lock conveniently locks into the magazine well of any AR-15 platform gun to secure the gun in an unfireable condition. It engages into the bolt raceway while holding the bolt carrier partially open, completely disabling the firing mechanism. This also prevents the upper from being disassembled from the lower. The Wall Mount base is designed to receive the bottom of the Mag Well Lock while it is inserted into the gun. Once in place, the Mag Well Lock engages a steel pin on the base and secures the gun to the Wall Mount. A vinyl coated I bolt adds additional security by locking the barrel in position. The Wall Mount has four possible mounting configurations to fit ideally for any application.</p><p>Additional features of the Mag Well Lock: A high strength coated steel cable and pin are included that allow the lock and gun to be anchored to any stationary object such as a frame member in a vehicle. Glass reinforced Nylon construction is durable and robust, yet is non-marring or damaging for inserting in your magazine well. Two keys included.</p><h2>Features</h2><ul><li><strong>Works with any Mil-Spec AR-15</strong></li><li><strong>Fully disables the firing mechanism</strong></li><li><strong>Prevents disassembly of the upper and lower</strong></li><li><strong>Prevents a magazine from being loaded into the firearm</strong></li><li><strong>Comes with theft deterrent steel anchoring cable</strong></li><li><strong>Wall mounting system allows for convenient display and storage</strong></li><li><strong>Multiple mounting configurations</strong></li></ul>
4446 1 Lockdown SuperMax Universal Vault, Mechanical
45 characters
45/70 Passed audit Unassigned
4447 1 Lockdown SuperMax Universal Vault, Keyed
40 characters
40/70 Passed audit Unassigned
4448 1 Lockdown SuperMax Ready Vault
29 characters
29/70 Passed audit Unassigned
4453 1 Lockdown Golden Rod 36 Dehumidifier Rod
39 characters
39/70 Passed audit Unassigned
4454 1 Lockdown Golden Rod Digital Wireless Hygrometer
47 characters
47/70 Passed audit Unassigned
4455 1 Lockdown GunSaver 12 Dehumidifier Rod by GoldenRod
50 characters
50/70 Passed audit Unassigned
<p>The GUN SAVER Dehumidifier works by slightly increasing the air temperature inside the gun safe or other enclosure. This allows the warm air to circulate throughout the safe on a continual basis eliminating humidity mildew and condensation</p><p><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><li><strong>Eliminates Humidity</strong></li><li><strong>Mounting Bracket Included </strong></li></ul>
4456 1 Lockdown GunSaver 18 Dehumidifier Rod by GoldenRod
50 characters
50/70 Passed audit Unassigned
<p>The GUN SAVER Dehumidifier works by slightly increasing the air temperature inside the gun safe or other enclosure. This allows the warm air to circulate throughout the safe on a continual basis eliminating humidity mildew and condensation</p><p><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><li><strong>Eliminates Humidity</strong></li><li><strong>Mounting Bracket Included </strong></li></ul>
4457 1 M&P Accessories Alpha Electronic Ear Muff
42 characters
42/70 Passed audit Unassigned
<p>Alpha Electronic Ear Muff</p>
4458 1 M&P Accessories Officer Tactical Range Bag
43 characters
43/70 Passed audit Unassigned
4460 1 M&P Accessories Pro Tac Gun Case, 42
37 characters
37/70 Passed audit Unassigned
4461 1 M&P Accessories Pro Tac Gun Case, 48
37 characters
37/70 Passed audit Unassigned
4462 1 M&P Accessories Pro Tac Handgun Case, Single
45 characters
45/70 Passed audit Unassigned
4463 1 M&P Accessories Pro Tac Handgun Case, Double
45 characters
45/70 Passed audit Unassigned