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 3,051–3,100 of 12,819

PID Lang Original Name Proposed SEO Name Length Status / Bucket Actions
4223 1 Lee Precision EZ Seat Die Body 7.65x53
38 characters
38/70 Passed audit Unassigned
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.
4254 1 Crimp Collet 45 Colt
20 characters
20/70 Passed audit Unassigned
<p>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.</p>
4255 1 Lee Precision Crimp Collet 500 S&W
38 characters
38/70 Passed audit Unassigned
<p>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.</p>
4256 1 Lee Precision Crimp Collet 9.3x62mm
35 characters
35/70 Passed audit Unassigned
<p>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.</p><p></p>
4257 1 Lee Precision Crimp Collet .44 Magnum
37 characters
37/70 Passed audit Unassigned
<p>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.</p><p></p>
4258 1 Lee Precision Crimp Collet .357 Magnum
38 characters
38/70 Passed audit Unassigned
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.
4261 1 Lee Precision Collet Crimp Die Instructions .460 S&W
57 characters
57/70 Passed audit Unassigned
<p>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.</p>
4262 1 Factory Crimp Die Instructions .17 Hornet
41 characters
41/70 Passed audit Unassigned
<p>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.</p>
4263 1 Factory Crimp Die Instructions .375 Ruger
41 characters
41/70 Passed audit Unassigned
<p>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.</p>
4264 1 Lee Precision Collet Crimp Die Instructions .45 Colt
52 characters
52/70 Passed audit Unassigned
<p>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.</p>
4265 1 Factory Crimp Die Instructions 9.3x62mm
39 characters
39/70 Passed audit Unassigned
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.
4266 1 500 S&W CLT CMP Instructions
32 characters
32/70 Passed audit Unassigned
<p>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.</p>
4267 1 44 MAG CLT CMP Instructions
27 characters
27/70 Passed audit Unassigned
<p>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.</p>
4268 1 Factory Crimp Die Instructions .22 TCM
38 characters
38/70 Passed audit Unassigned
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.
4269 1 357 MAG CLT CMP Instructions
28 characters
28/70 Passed audit Unassigned
<p>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.</p>
4270 1 Lee Precision SEAT DI BODY .22 TCM
34 characters
34/70 Passed audit Unassigned
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.
4271 1 Size Die Body .17 Hornet
24 characters
24/70 Passed audit Unassigned
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.
4272 1 Lee Precision Size Die Body .375 Ruger
38 characters
38/70 Passed audit Unassigned
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.
4273 1 Lee Precision Size Die Body .22 TCM
35 characters
35/70 Passed audit Unassigned
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.
4274 1 Lee Precision Size Die Body 9.3x62mm
36 characters
36/70 Passed audit Unassigned
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.
4275 1 Lee Precision EZ X Expander .17 Hornet
38 characters
38/70 Passed audit Unassigned
<p>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.</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><strong><b style=""><strong style="">Fits Lee Precision Full-length Size Die .17 Hornet.</strong></li><li><strong><b style=""><strong>Expands case mouth to aid bullet seating.</strong></li><li><strong><b style=""><strong style="">Made from steel.</strong></li></ul>
4277 1 Short Charge Die Body
21 characters
21/70 Passed audit Unassigned
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.
4278 1 Lee Precision EZ X Expander 9.3x62mm
36 characters
36/70 Passed audit Unassigned
<p>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.</p>FEATURES:<ul><li><strong>Fits Lee Precision Full-length Size Die 9.3x62mm.</strong></li><li><strong>Expands case mouth to aid bullet seating.</strong></li><li><strong>Made from steel.</strong></li></ul>
4279 1 BODY PRIME TOOL089
18 characters
18/70 Passed audit Unassigned
&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;
4298 1 Bog CLD-2, Camo Legged Devil Bipod, Tall
40 characters
40/70 Passed audit Unassigned
<h2><strong>FEATURES:</strong></h2><ul><li><strong>Switcheroo Shooting System Easily switch between accessories in the field using the same rifle bipod</strong></li><li><strong>Three-section, high-strength, lightweight aluminum legs with camo finish</strong></li><li><strong>Universal Shooting Rest swivels 360 and rubber covered to prevent damage to gun stocks</strong></li><li><strong>Rapid-adjust lever locks with adjustable tension</strong></li><li><strong>Legs adjust independently out to 40 angle with adjustable tension</strong></li><li><strong>Inch markers on middle leg sections help to quickly reach a set height</strong></li><li><strong>All-terrain foot system with rubber feet that screw up to reveal a steel tip for better grip on ice</strong></li><li><strong>Use in sitting, kneeling, or standing positions from 22? to 68? usable height when legs are spread</strong></li><li><strong>Height when closed for carrying is 31?</strong></li><li><strong>Carry bag and allen wrench included</strong></li><li><strong>Weighs approximately 32 oz.</strong></li></ul>
4299 1 Bog CLD-3, Camo Legged Tripod, Tall
35 characters
35/70 Passed audit Unassigned
<p>Bog Pod's Camo Legged Tall Tripod features three aluminum legs with camo finish that adjust independently for use in sitting, kneeling or standing positions from 22&quot; to 68&quot;. Works with Bog Pod Switcheroo Shooting System accessories.</p><h2>Features:</h2><ul><li><strong>Switcheroo Shooting System Easily switch between accessories in the field using the same platform</strong></li><li><strong>Three-section, high-strength, lightweight aluminum legs with camo finish</strong></li><li><strong>Universal Shooting Rest swivels 360 and rubber covered to prevent damage to gun stocks</strong></li><li><strong>Rapid-adjust lever locks with adjustable tension</strong></li><li><strong>Legs adjust independently out to 40 angle with adjustable tension</strong></li><li><strong>Inch markers on middle leg sections help to quickly reach a set height</strong></li><li><strong>All-terrain foot system with rubber feet that screw up to reveal a steel tip for better grip on ice</strong></li><li><strong>Use in sitting, kneeling, or standing positions from 22? to 68? usable height when legs are spread</strong></li><li><strong>Height when closed for carrying is 31?</strong></li><li><strong>Carry bag and allen wrench included</strong></li><li><strong>Weighs approximately 40 oz.</strong></li></ul><p><strong>NOTE:</strong> The only difference between the CLD and TAC Series is the finish on the legs (i.e. black vs. camo).</p>
4306 1 Bog-Pod Bog SB-2, Sportsman's Bipod, Short
42 characters
42/70 Passed audit Unassigned
<p><h2><strong>FEATURES:</strong></h2><ul><li><strong>Three-section, lightweight aluminum legs with matte black finish</strong></li><li><strong>High-strength ABS plastic head and leg connectors</strong></li><li><strong>Universal Shooting Rest swivels 360 and rubber covered to prevent damage to gun stocks</strong></li><li><strong>Rapid-adjust twist locks loosen or tighten legs with just a couple of turns</strong></li><li><strong>Removable rubber feet unscrew to a reveal carbide tip for better grip on ice</strong></li><li><strong>Use in sitting or kneeling positions from approximately 21? to 40? usable height when legs are spread</strong></li><li><strong>Height when closed for carrying is 25?</strong></li><li><strong>Weighs approximately 19 oz.</strong></li></ul><h2><strong>NOTES:&amp;nbsp;</strong></h2></p><ul><li><strong>The BOG SB-2 is BOG's lightest, least expensive bipod, and is not designed to hold more than 10-12 lbs of weight on the shooting rest. Unlike other BOG bipods, it features an ABS plastic head and leg connectors to reduce its weight. Therefore, it is not designed for extremely hard field use. When the legs of the bipod are spread fully out, it is important to make sure not to put any excessive downward pressure on the rest as this could cause damage to the leg connectors.</strong></li></ul>
4325 1 Caldwell Mag Charger TAC 30
27 characters
27/70 Passed audit Unassigned
4326 1 Caldwell Mag Charger Ammo Box, AK 7.62x39, 5pk
46 characters
46/70 Passed audit Unassigned
4339 1 Caldwell Max Grip Sling, Black
30 characters
30/70 Passed audit Unassigned
4340 1 Caldwell Max Grip Sling, Flat Dark Earth
40 characters
40/70 Passed audit Unassigned
4341 1 Caldwell Optic Armor Scope Cover, Large
39 characters
39/70 Passed audit Unassigned
4342 1 Caldwell Optic Armor Scope Cover, Extra Large
45 characters
45/70 Passed audit Unassigned
4343 1 Caldwell Fast Case Gun Cover
28 characters
28/70 Passed audit Unassigned
4344 1 Caldwell Ballistic Precision G2 Chronograph
43 characters
43/70 Passed audit Unassigned
<p>The G2 literally flips conventional Chronograph technology upside down. By inverting the system the G2 is capable of measuring in adverse light conditions making the measurements more accurate than conventional chronographs, even indoors. The light sensors were spaced 18? apart for more accuracy and the sunscreens have self-contained LED lights when a little extra light is needed. Collapsible and compact, the system is quick and easily deployed from its heavy duty storage case. Higher accuracy was achieved by using a high speed 48 MHz processor and by designing a circuit with an advanced data interface that allows each unit to be computer calibrated at the factory after assembly. The end result is the ability to provide much better accuracy than other chronographs on the market (+/- .25%) and measures from 5 to 9,999 FPS.</p><h2>Features:</h2><ul><li><strong>18&quot; sensor spacing for maximum accuracy</strong></li><li><strong>Each unit factory calibrated to within +/- 0.25% accuracy</strong></li><li><strong>Built in LED Light Kit</strong></li><li><strong>Bluetooth to interface with Smartphone</strong></li><li><strong>Rechargeable Lithium Ion Battery</strong></li><li><strong>Ideal for Firearms, Archery, Airgun or Paintball</strong></li><li><strong>Meters Per Second (MPS) or Feet Per Second (FPS) readings</strong></li><li><strong>App displays velocity, logs data, notes, weather conditions and easily exports via SMS or Email</strong></li><li><strong> Carry bag included</strong></li><li><strong>Heavy Duty height adjustable from 15&quot; 42&quot; Tripod</strong></li><li><strong>Includes 1/4-20 dovetail plate to attach to the chronograph for quick assembly</strong></li></ul><p>A free App is available for download that displays the velocity of each shot on the phone screen and records it with other data identifying the load and environmental conditions. The App also automatically calculates Average Velocity, Standard Deviation, Min, Max and Velocity Spread for the shot string. The data is stored and can be exported via Email or simply recalled for reference at a later date.</p><ul><li><strong>IOS-(<a href=&quot;https://itunes.apple.com/us/app/caldwell-ballistic-precision/id659981375?mt=8&quot; target=&quot;_blank&quot;>https://itunes.apple.com/us/app/caldwell-ballistic-precision/id659981375?mt=8</a>)</strong></li><li><strong>Andriod- (<a href=&quot;https://play.google.com/store/apps/details?id=com.battenfeld.chrono&amp;hl=en&quot; target=&quot;_blank&quot;>https://play.google.com/store/apps/details?id=com.battenfeld.chrono&amp;hl=en</a>)</strong></li></ul>
4345 1 Caldwell EU Chronograph Light Kit
33 characters
33/70 Passed audit Unassigned
4346 1 Caldwell Orange Peel 12 bulls-eye: 5 sheets, PINK
49 characters
49/70 Passed audit Unassigned
4347 1 Caldwell Orange Peel Sight-In Target: 16 5 sheets
49 characters
49/70 Passed audit Unassigned
4348 1 Caldwell Orange Peel Sight-In Target: 16 12 sheets
50 characters
50/70 Passed audit Unassigned
4349 1 Caldwell Silhouette Center Mass Target 8pk
42 characters
42/70 Passed audit Unassigned
4350 1 Caldwell Silhouette Center Mass Target 25pk
43 characters
43/70 Passed audit Unassigned
4351 1 Caldwell Silhouette Dual Zone Target 8pk
40 characters
40/70 Passed audit Unassigned
4352 1 Caldwell Silhouette Dual Zone Target 25pk
41 characters
41/70 Passed audit Unassigned
4354 1 Caldwell Sight In Target 16 Hi Contrast Blue, 10pk
50 characters
50/70 Passed audit Unassigned
4355 1 Caldwell Sight In Target, 9 Diamond, Hi Contast Blue, 10pk
58 characters
58/70 Passed audit Unassigned
4357 1 Caldwell Strobe Flash Hit Indicator
35 characters
35/70 Passed audit Unassigned
4362 1 Caldwell Duramax 5 Target Ball
30 characters
30/70 Passed audit Unassigned
4363 1 Caldwell Duramax 5 Target Square
32 characters
32/70 Passed audit Unassigned
4368 1 Caldwell Tac Ops Holster Glock 19 RH (19/23/32)
47 characters
47/70 Passed audit Unassigned
4369 1 Caldwell Tac Ops Holster Glock 17 RH (22/31)
44 characters
44/70 Passed audit Unassigned