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

PID Lang Original Name Proposed SEO Name Length Status / Bucket Actions
6982 1 S&W Accessories Sigma Electronic Ear Muff
42 characters
42/70 Passed audit Unassigned
6983 1 S&W Flashlights MP 10 Tactical (SW1010CMP)
43 characters
43/70 Passed audit Unassigned
6984 1 S&W Flashlights MP 12 Tactical (SW1012CMP)
43 characters
43/70 Passed audit Unassigned
6986 1 S&W Flashlights S&W Bulb, 2D Xenon Bulb, Pkg of 2 (SW102X)
59 characters
59/70 Passed audit Unassigned
6987 1 S&W Flashlights S&W Bulb, 3D Xenon Bulb, Pkg of 2 (SW103X)
59 characters
59/70 Passed audit Unassigned
6988 1 S&W Flashlights S&W Bulb, 4D Xenon Bulb, Pkg of 2 (SW104X)
59 characters
59/70 Passed audit Unassigned
6989 1 S&W Flashlights S&W Bulb, 5D Xenon Bulb, Pkg of 2 (SW105X)
59 characters
59/70 Passed audit Unassigned
6990 1 S&W Flashlights MP 15 Rechargeable Flashlight (SW118USB)
57 characters
57/70 Passed audit Unassigned
6991 1 S&W Flashlights S&W Bulb, SW1200XT (SW1200SB)
46 characters
46/70 Passed audit Unassigned
6993 1 S&W Flashlights Galaxy 12 LED (SW1222)
39 characters
39/70 Passed audit Unassigned
6994 1 S&W Flashlights S&W Bulb, 2D Krypton Bulb (SW125AL)
52 characters
52/70 Passed audit Unassigned
6995 1 S&W Flashlights Galaxy 13 LED (SW1300RW)
41 characters
41/70 Passed audit Unassigned
6996 1 S&W Flashlights S&W Bulb, 3D Krypton Bulb (SW135AL)
51 characters
51/70 Passed audit Unassigned
6997 1 S&W Flashlights S&W Bulb, 4D Krypton Bulb (SW145AL)
52 characters
52/70 Passed audit Unassigned
6998 1 S&W Flashlights Galaxy 28 LED (SW2800RBW)
42 characters
42/70 Passed audit Unassigned
6999 1 S&W Flashlights S&W Bulb, 3X Galaxy Xenon Bulb (SW320SB)
57 characters
57/70 Passed audit Unassigned
7000 1 S&W Flashlights Galaxy Flare (SW393TL)
39 characters
39/70 Passed audit Unassigned
7001 1 S&W Flashlights Galaxy Flare Dual Color (SW393TLR)
51 characters
51/70 Passed audit Unassigned
7002 1 S&W Flashlights Galaxy Pro (SW4AACR)
37 characters
37/70 Passed audit Unassigned
7003 1 S&W Flashlights SW 5020 (SW5020LBK)
36 characters
36/70 Passed audit Unassigned
7004 1 S&W Flashlights Galaxy 6 LED (SW600RW)
39 characters
39/70 Passed audit Unassigned
7005 1 S&W Flashlights S&W Bulb, Delta Force Bulb (SW700SB)
54 characters
54/70 Passed audit Unassigned
7006 1 S&W Flashlights Delta Force (SW702DX)
38 characters
38/70 Passed audit Unassigned
7007 1 S&W Flashlights Delta 2 Compact Combo (SW717CBO)
49 characters
49/70 Passed audit Unassigned
7008 1 S&W Flashlights Galaxy Pathmarker (SW718CR)
44 characters
44/70 Passed audit Unassigned
7009 1 S&W Flashlights Self Defense Tactical Penlight (SW747PLT)
58 characters
58/70 Passed audit Unassigned
7010 1 S&W Flashlights Galaxy Green Beam (SW760GKL)
45 characters
45/70 Passed audit Unassigned
7011 1 S&W Flashlights Galaxy Elite (SW775CR)
39 characters
39/70 Passed audit Unassigned
7014 1 S&W Flashlights Explorer Pack (SW8880CBO)
42 characters
42/70 Passed audit Unassigned
7018 1 Tipton Compact Range Vise
25 characters
25/70 Passed audit Unassigned
<p>The Tipton Compact Range Vise offers a completely new level of performance securely holding the widest array of guns possible while collapsing to fit in a range bag. The compact design is a convenient solution to gun cleaning at the range. The Compact Range Vise collapses to 11-1/4 and fully expands to 17-3/4 making it easy to carry but also fully functional when completely expanded. Six rubber feet provide the vise a very rigid non-slip base. Two non-marring forks protect your guns' finish while holding them securely in place for cleaning light maintenance or as an extra set of hands. The Compact Range Vise is extremely durable and is made from high quality solvent-resistant nylon that will deliver years of lasting performance. Serious shooters know keeping their guns clean is essential to performance making the Compact Range Vise the perfect range accessory. </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>Solvent-Resistant Nylon</strong></li><li><strong>Non-Slip Base</strong></li><li><strong>Non-Marring Forks </strong></li></ul>
7019 1 Tipton Transporter Range Vise
29 characters
29/70 Passed audit Unassigned
<p>The Tipton Transporter Range Vise is an all-in-one solution, a flexible range bag with a built-in range vise that clamps to tabletops up to 3-5/8&quot; thick. Everything stores in 3 built-in pockets with room for 40lbs of tools and supplies. It even includes a built-in drink holder.</p><h2>Features:</h2><ul><li><strong>Holds up to 4 long rifles</strong></li><li><strong>Clamps on tabletops up to 3-5/8&quot; in thickness</strong></li><li><strong>Holds up to 40lbs</strong></li><li><strong>Includes 2 removable forks for cleaning a gun</strong></li><li><strong>Non-marring surface</strong></li><li><strong>Built in drink holder</strong></li><li><strong>Everything disassembles and stores in 3 built in pockets making a nice carry bag</strong></li><li><strong>3 pockets are great for holding pistols while in use</strong></li><li><strong>Usable bag measures 9&quot; x 20&quot; x 9&quot;</strong></li><li><strong>Overall Footprint measures 11.5&quot; x 23&quot; x 9&quot;</strong></li></ul>
7020 1 Tipton Max Force Carbon Fiber Cleaning Rod, 22 cal
50 characters
50/70 Passed audit Unassigned
7021 1 Tipton Max Force Carbon Fiber Cleaning Rod, 17/20 cal
53 characters
53/70 Passed audit Unassigned
7024 1 Tipton Deluxe 1-Piece CFR 20 Cal. 40, retail pk
47 characters
47/70 Passed audit Unassigned
7038 1 Tipton Deluxe 3-Pc Stainless Steel Cleaing Rod, 22 cal
54 characters
54/70 Passed audit Unassigned
7040 1 Tipton M&amp;P Maintenance Mat- 11x17
37 characters
37/70 Passed audit Unassigned
&lt;p&gt;The perfect material to lay on your workbench while cleaning or disassembling firearms. Padded neoprene construction protects firearm finishes while helping keep track of small parts. Excess oils and solvents are absorbed into the mat, keeping the surface clean and dry. The Tipton® Maintenance Mat rolls easily to fit your range box. Hand washable.&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;b style=&quot;&quot;&gt;&lt;strong style=&quot;&quot;&gt;Screen printed exploded view of an M&amp;amp;P for easy part identification&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong&gt;No-mar, padded neoprene surface protects the fiream's finish&lt;br&gt;&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong&gt;Perfect for cleaning &amp;amp; disassemblingfirearms&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong&gt;Absorbs oils &amp;amp; solvents keeping surface dry&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong&gt;Rolls up to easily fit in your range bag&lt;br&gt;&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong style=&quot;&quot;&gt;Helps keep track of small parts&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;/ul&gt;
7041 1 Tipton Glock Maintenance Mat- 11x17
35 characters
35/70 Passed audit Unassigned
7042 1 Tipton 1911 Maintenance Mat 11 x 17
35 characters
35/70 Passed audit Unassigned
<p>Tipton's 1911 Maintenance Mat includes a screen printed, exploded view of an M&amp;P handgun or a Glock model pistol for easy part identification with a no-mar, padded newoprene surface that absorbs oils &amp; solvents to keep surface dry.</p><h2>Features:</h2><ul><li><strong>Screen printed exploded view of an M&amp;P handgun or a Glock model pistol for easy part identification</strong></li><li><strong>No-mar, padded neoprene surface protects the firearm's finish</strong></li><li><strong>Perfect for cleaning &amp; disassembling firearms</strong></li><li><strong>Absorbs oils &amp; solvents keeping surface dry</strong></li><li><strong>Rolls up to easily fit in your range bag</strong></li><li><strong>Helps keep track of small gun parts</strong></li><li><strong>Large 11&quot; x 17&quot; size</strong></li></ul>
7043 1 Wheeler Engineering Delta Series AR Armorer's Bench Block
57 characters
57/70 Passed audit Unassigned
<p>The Wheeler Engineering Delta Series AR Armorer&#39;s Bench Block is made of extremely durable, non-marring urethane to protect the finish of your firearms and last for years. It features a variety of notches, grooves, and holes on both sides and is ideally suited for the upper receiver, lower receiver, front sight and charging handle of an AR-15.</p><p>Tired of trying to secure your AR parts while installing a pin, detent, or spring? The AR-15 Bench Block is the answer! Specifically designed for AR-15 assembly and disassembly, the AR-15 Bench Block is the perfect tool.</p><h2>Features:</h2><ul><li><strong>Positions the upper receiver, lower receiver, front sight, and charging handle for maintenance or assembly</strong></li><li><strong>Durable non-marring urethane material to protect gun finish</strong></li><li><strong>Designed to assist in all aspects of an AR-15 build</strong></li><li><strong>Ideal for changing or adjusting triggers</strong></li></ul>
7044 1 Wheeler Engineering Ultra Armorer's Kit
39 characters
39/70 Passed audit Unassigned
<p>The Wheeler Delta Series AR-15 Armorer's Kit ULTRA contains every tool a gunsmith or armorer needs to complete a full rifle build, make repairs or perform maintenance on AR-15/M16 platform rifles. This kit can perform over 50 different operations and functions of AR-15 building and maintenance. Delta Series tools are designed with specific features to perform functions with precision and ease. Each tool is constructed of the highest quality materials to deliver the best performance at a great value. The Wheeler Delta Series AR-15 Armorer's Kit ULTRA is the most comprehensive AR-15 build and maintain kit on the market.</p><h2>Includes:</h2><ul><li><strong>AR Armorers Vise</strong></li><li><strong>AR-15 Combo Tool</strong></li><li><strong>Torque Wrench</strong></li><li><strong>AR-15 Armorer's Bench Block</strong></li><li><strong>AR-15 Roll Pin Install Tool Kit</strong></li><li><strong>Upper Vise Block Clamp with</strong></li><li><strong>Gas Tube Alignment Tool</strong></li><li><strong>Maintenance Mat with Exploded view AR-15</strong></li><li><strong>Pivot Pin &amp;amp; Roll Pin Installation Tool</strong></li><li><strong>AR Front Sight Tool</strong></li><li><strong>Delta Ring Tool</strong></li><li><strong>Strap Wrench</strong></li><li><strong>AR-15 Bore Guide</strong></li><li><strong>AR-15 Adjustable Receiver Link</strong></li><li><strong>Bore Brush, .22 Cal.</strong></li><li><strong>Bolt Carrier Brush</strong></li><li><strong>Chamber Brush</strong></li><li><strong>Magazine/Upper Receiver Brush</strong></li><li><strong>Nylon Brush Handle</strong></li><li><strong>Double-ended General Cleaning Brush</strong></li><li><strong>Cleaning Pick Set</strong></li><li><strong>Custom Fitted Carrying Case</strong></li></ul>
7048 1 Wheeler Engineering Delta Series Pic Rail Riser .5
50 characters
50/70 Passed audit Unassigned
7049 1 Wheeler Engineering Delta Series Pic Rail Riser .7
50 characters
50/70 Passed audit Unassigned
7050 1 Wheeler Engineering Delta Series Pic Rail Riser 1
49 characters
49/70 Passed audit Unassigned
7051 1 Wheeler Engineering Delta Series 300 Blackout Bore Guide
56 characters
56/70 Passed audit Unassigned
<p>The nozzle of the Wheeler Engineering AR-15 300 AAC Blackout Bore Guide extends inside the chamber to prevent solvent from leaking into the action. A solvent port is conveniently located to the rear of the guide which extends out of the upper making it easily accessible during cleaning. Made of precision CNC machined aluminum with a durable anodized finish.</p><h2>Features:</h2><ul><li><strong>Protects chamber &amp; bore from damage</strong></li><li><strong>Ensures proper rod alignment for easier cleaning</strong></li><li><strong>Reduces solvent leakage into gun’s action</strong></li><li><strong>Anodized aluminum for durability</strong></li><li><strong>Integrated solvent port</strong></li><li><strong>Secures in place with dust cover engagement</strong></li><li><strong>300 AAC Blackout Bore Guide fits any 30 caliber, 6.5 or 6.8 AR-15</strong></li></ul>
7052 1 Wheeler Engineering Digital FAT Wrench
38 characters
38/70 Passed audit Unassigned
<p>The Wheeler Engineering Digital F.A.T. Wrench brings more precise torque settings to the handheld torque wrench market. This amazing digital handheld torque wrench lets you apply repeatable, accurate torque settings. The audible and visual indicators let you know exactly when the desired torque setting has been achieved. The large range of 15-100 in/lbs. will aid in accuracy of all your screws and decreases the opportunity for problems in the field. The FAT Wrench Bits are built to last and are made from S2 Tool steel and hardened to 56-56 Rockwell &ldquo;C&rdquo;.</p><h2>Features:</h2><ul><li><strong>Ergonomic over molded design</strong></li><li><strong>Large LCD Digital display for ease of viewing</strong></li><li><strong>15 -100 in/lb. range</strong></li><li><strong>+/- 2% accuracy</strong></li><li><strong>Audible indicator tone</strong></li><li><strong>Visual indicator</strong></li><li><strong>Low battery indicator</strong></li><li><strong>Soft touch buttons</strong></li><li><strong>Injection molded storage case</strong></li></ul>
7054 1 Wheeler Engineering Roll Pin Starter Set
40 characters
40/70 Passed audit Unassigned
<p>The Wheeler Engineering® Roll Pin Punches are machined from hardened steel to prevent bending or breaking while driving any size roll pin. The punches are designed with a hemispherical tip to provide proper alignment of the roll pin to prevent damage to the firearm and the roll pin. The 9 piece set includes: 5/16?, 1/4?, 7/32?, 3/16?, 5/32?, 1/8?, 3/32?, 5/64?, 1/16? punches in a nylon pouch.</p><h2>Features:</h2><ul><li><strong>9-piece set 1/16? through 5/16?</strong></li><li><strong>Hardened Steel construction</strong></li><li><strong>Hemispherical Tip</strong></li><li><strong>Fitted Nylon Storage Pouch</strong></li></ul>
7055 1 Wheeler Engineering Optics Fastener Kit
39 characters
39/70 Passed audit Unassigned
<p>These Grade 8 high strength quenched and tempered alloy steel fasteners will hold up to any application. Durable black zinc surface finish for corrosion resistance. Commonly requested Ring Windage 10-32&times;7.5mm slotted head fasteners included. 6-48 and 8-40 taps included to repair damages treads on guns or ring sets. Convenient storage case included.</p><h2>158 Piece Set Features:</h2><ul><li><strong>Common slotted and Torx fasteners</strong></li><li><strong>Fasteners have a black zinc surface finish</strong></li><li><strong>6-48 and 8-40 taps included for repairing damaged treads</strong></li><li><strong>Grade 8 strength fasteners made from quenched and tempered alloy steel for maximum durability</strong></li></ul>
7056 1 Wheeler Engineering Ultra Scope Mounting Kit
44 characters
44/70 Passed audit Unassigned
<p>The Wheeler Engineering ULTRA Scope Mounting Kit from Wheeler Engineering&reg; puts all the best Wheeler&reg; scope mounting accessories into one perfect package. With this kit you can level your rifle, level your scope, mount your scope to the rifle, and then coarse sight in your scope with precision and accuracy. No more guess work and &ldquo;that&rsquo;s good enough&rdquo;. The ULTRA Scope Mounting Kit even provides thread locker and a lens pen to keep your scope clean and your optics secure on even the largest caliber guns.</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;">Includes:</span></h2><ul><li><strong>The Wheeler Engineering Professional Reticle Leveling System</strong></li><li><strong>The Wheeler Engineering Professional Laser Bore Sighter to align your crosshairs and get you on paper faster</strong></li><li><strong>The Wheeler Engineering FAT Wrench&reg; to apply precise inch-lb. pressure on all of your screws</strong></li><li><strong>9 screwdriver bits, 1 socket and a bit holder</strong></li><li><strong>Wheeler Engineering thread locker</strong></li></ul>
7057 1 Wheeler Engineering Professional Digital Trigger Gauge
54 characters
54/70 Passed audit Unassigned
<p>The Wheeler Engineering Professional Digital Trigger Gauge measures trigger pull with a load sensor that directly contacts the trigger. It measures loads from 0-12lbs with an accuracy of plus or minus 0.5%. Max, min, average and live functions with an audible indicator tone and soft touch buttons provide control of the measurement task. A foam lined storage case is included to protect your tool when not in use.</p><h2>Features:</h2><ul><li><strong>Ergonomic over molded design</strong></li><li><strong>0-12lbs range</strong></li><li><strong>+/-0.5% accuracy</strong></li><li><strong>Load sensor directly contacts the trigger</strong></li><li><strong>Feature max, min, average and live functions</strong></li><li><strong>Audible indicator tone</strong></li><li><strong>Low battery indicator</strong></li><li><strong>Soft touch buttons</strong></li><li><strong>Arm folds inside housing to protect the load sensor when not in use</strong></li><li><strong>Foam lined storage case</strong></li></ul>
7058 1 Wheeler Engineering Amorers Handgun Sight Tool
46 characters
46/70 Passed audit Unassigned
<p>The Wheeler Engineering Amorers Handgun Sight Tool is used to install, un-install or adjust fron and rear dovetail sights.</p><h2>Features:</h2><ul><li><strong>Precision machined unit</strong></li><li><strong>Designed in install, un-install or adjust front and rear dovetail sights</strong></li><li><strong>Fully captures and supports slide so it won't deform</strong></li><li><strong>Works on all semi auto pistols</strong></li><li><strong>Large 4 post drive knob to easily push the sight</strong></li><li><strong>Reference marks for precise adjustments</strong></li></ul>