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

PID Lang Original Name Proposed SEO Name Length Status / Bucket Actions
136880 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136881 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136882 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136883 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136884 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136885 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136887 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136888 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136889 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136890 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136891 1 Lee Precision 2 REQ.
22 characters
22/70 Passed audit Unassigned
136892 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136893 1 Lee Precision 2 REQ.
22 characters
22/70 Passed audit Unassigned
136894 1 Lee Precision 2 REQ.
22 characters
22/70 Passed audit Unassigned
136895 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136896 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136897 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136898 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136899 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136900 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136901 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136902 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136904 1 Lee Precision 3 REQ.
22 characters
22/70 Passed audit Unassigned
136905 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136906 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136907 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136908 1 Lee Precision 2 REQ.
22 characters
22/70 Passed audit Unassigned
136909 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136910 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136911 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136913 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136915 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136916 1 Lee Precision 4 REQ.
22 characters
22/70 Passed audit Unassigned
136917 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136918 1 Lee Precision 1 REQ.
22 characters
22/70 Passed audit Unassigned
136921 1 Lee Precision CUST FC DIE 30/284
34 characters
34/70 Passed audit Unassigned
136922 1 Lee Precision INSTRUCT SWIVEL ADAP
34 characters
34/70 Passed audit Unassigned
136923 1 Lee Precision QUICK START GUIDE
34 characters
34/70 Passed audit Unassigned
136924 1 Hornady Lock-N-Load Bullet Comparator Insert #20 .204 Cal
57 characters
57/70 Passed audit Unassigned
<p>Bullet Comparator Inserts are designed for use with the Hornady Lock-N-Loadยฎ Bullet Comparator; it eliminates variables when measuring the over-all length of a bullet. Bullet length can vary a few thousandths due to material variation and tip finish.</p><p>The Lock-N-Loadยฎ Bullet Comparator Inserts allow the reloader to measure the bullet from the base to a specific point on the ogive, which has little variation, if any. This versatile system also provides the reloader with a much more consistent way to monitor the overall length of their reloads, allowing the reloader to build more precision into their handloads, that translates into better groups at the range and more meat in the freezer.</p>
136925 1 Hornady Lock-N-Load Bullet Comparator Insert #41 .416 Cal
57 characters
57/70 Passed audit Unassigned
<p>Bullet Comparator Inserts are designed for use with the Hornady Lock-N-Loadยฎ Bullet Comparator; it eliminates variables when measuring the over-all length of a bullet. Bullet length can vary a few thousandths due to material variation and tip finish.</p><p>The Lock-N-Loadยฎ Bullet Comparator Inserts allow the reloader to measure the bullet from the base to a specific point on the ogive which has little variation if any. This versatile system also provides the reloader with a much more consistent way to monitor the overall length of their reloads allowing the reloader to build more precision into their handloads that translates into better groups at the range and more meat in the freezer.</p><strong>PHOTO NOTE:</strong><ul><li><strong>Photo is a generic representation of Bullet Comparator Inserts. Markings vary depending on caliber.</strong></li></ul>
136926 1 Hornady Lock-N-Load Modified Case .340 Weatherby Magnum
55 characters
55/70 Passed audit Unassigned
<h3 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;>Achieve precise bullet seating depth.</h3><p>To use the Lock-N-Loadยฎ O.A.L. Gauge, you will need a Modified Case (sold separately) to fit your firearm's chamber and thread it onto the gauge. These specially prepared modified cases are threaded at the case-head and have a .002&quot; oversized neck to accept the same bullets you intend to load.</p><p>This is critical, as the Lock-N-Loadยฎ O.A.L. Gauge dimensions obtained will be accurate to .001&quot;. These results cannot be attained with competitive products, which use a simulated bullet with an arbitrary shape.</p><p>Lock-N-Loadยฎ Modified Cases are readily available to fit most popular rifle chambers. All are manufactured to SAAMI specs.</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>Works with Hornady &amp;nbsp;Lock-N-Loadยฎ O.A.L. Gauge.</strong></li><li><strong>Manufactured to SAAMI specs.</strong></li><li><strong>Fits .340 Weatherby Magnum.<br></strong></li><li><strong>Accurate to .001&quot;.</strong></li></ul>
136927 1 Hornady Lock-N-Load Modified Case .458 Winchester
49 characters
49/70 Passed audit Unassigned
<h3 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;>Achieve precise bullet seating depth.</h3><p>To use the Lock-N-Loadยฎ O.A.L. Gauge, you will need a Modified Case (sold separately) to fit your firearm's chamber and thread it onto the gauge. These specially prepared modified cases are threaded at the case-head and have a .002&quot; oversized neck to accept the same bullets you intend to load.</p><p>This is critical, as the Lock-N-Loadยฎ O.A.L. Gauge dimensions obtained will be accurate to .001&quot;. These results cannot be attained with competitive products, which use a simulated bullet with an arbitrary shape.</p><p>Lock-N-Loadยฎ Modified Cases are readily available to fit most popular rifle chambers. All are manufactured to SAAMI specs.</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>Works with Hornady &amp;nbsp;Lock-N-Loadยฎ O.A.L. Gauge.</strong></li><li><strong>Manufactured to SAAMI specs.</strong></li><li><strong>Fits .458 Winchester.<br></strong></li><li><strong>Accurate to .001&quot;.</strong></li></ul>
136928 1 Hornady Lock-N-Load Modified Case 6.5x55mm Swedish Mauser
57 characters
57/70 Passed audit Unassigned
&lt;h3 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;&gt;Achieve precise bullet seating depth.&lt;/h3&gt;&lt;p&gt;To use the Lock-N-Loadยฎ O.A.L. Gauge, you will need a Modified Case (sold separately) to fit your firearm's chamber and thread it onto the gauge. These specially prepared modified cases are threaded at the case-head and have a .002&quot; oversized neck to accept the same bullets you intend to load.&lt;/p&gt;&lt;p&gt;This is critical, as the Lock-N-Loadยฎ O.A.L. Gauge dimensions obtained will be accurate to .001&quot;. These results cannot be attained with competitive products, which use a simulated bullet with an arbitrary shape.&lt;/p&gt;&lt;p&gt;Lock-N-Loadยฎ Modified Cases are readily available to fit most popular rifle chambers. All are manufactured to SAAMI specs.&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;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;Works with Hornady &amp;nbsp;Lock-N-Loadยฎ O.A.L. Gauge.&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong&gt;Manufactured to SAAMI specs.&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong&gt;Fits 6.5x55mm Swedish Mauser.&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;li&gt;&lt;b style=&quot;&quot;&gt;&lt;strong style=&quot;&quot;&gt;Accurate to .001&quot;.&lt;/strong&gt;&lt;/b&gt;&lt;/li&gt;&lt;/ul&gt;
136929 1 Lucas Oil Extreme Duty Gun Grease 1 ounce Tube
46 characters
46/70 Passed audit Unassigned
&lt;p&gt;Used and recommended by major firearms manufacturers, Lucas Extreme Duty Gun Grease is a premium, heavy duty firearm grease formulated with a unique additive system designed to provide maximum lubrication under the most severe operating conditions.&lt;/p&gt;&lt;p&gt;This is true firearms grease, it was developed to lubricate and protect under the harshest heat, friction and pressures of sustained firing while reducing friction and wear. Its unique formulation is designed to prevent rust and corrosion from rain and moisture in fresh and saltwater environments.&lt;br&gt;&lt;/p&gt;&lt;p&gt;Application to metal surfaces and bores will prevent corrosion during long term storage. Lucas Extreme Duty Gun Grease withstands extreme pressures and cushions metal surfaces with an 80 LB Timken load (35 LB is the minimum industry standard). Lucas Oil Extreme Duty Gun Grease is recommended for all firearm types. It provides excellent lubrication and protection on shotguns, pistols and revolvers as well as full auto carbines, rifles and belt fed machine guns.&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;p&gt;&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;span style=&quot;background-color: rgb(255, 255, 0); font-weight: bold; padding: 3px 7px; text-transform: uppercase;&quot;&gt;FEATURES:&lt;/span&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Smooth tacky consistency stays where you apply it.&lt;br&gt;&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Excellent rust protection.&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Long lasting all-weather lubrication, prevents saltwater corrosion.&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Temperature range -20 to 540 F.&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Timken Load โ€“ 80 lbs. (over twice the minimum industry standard).&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Weld Point โ€“ 620 Kg (over 3x the minimum industry standard).&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Made in U.S.A.&lt;/strong&gt;&lt;/li&gt;&lt;/ul&gt;
136930 1 Claybuster Shotshell Wads 12 Gauge CB2118-12
44 characters
44/70 Passed audit Unassigned
<p>For use in 1-1/8 to 1-1/4 oz. trap, skeet, sporting clays or hunting loads. Performs best in straight wall cases such as Federal paper or plastic and Fiocchi.<br></p><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><strong>FEATURES:</strong></h2><ul><li><strong>Maid from Ripstop Nylon</strong></li><li><strong>Optimum load 1 1/8 ounce</strong></li><li><strong>Straight Wall Federal Style </strong></li><li><strong>12 Gauge</strong></li><li><strong>Replaces&amp;nbsp;12S3</strong></li></ul>
136931 1 Claybuster Shotshell Wads 410 Bore CB5050-410HS
47 characters
47/70 Passed audit Unassigned
<p>For use in 1/2 oz. Winchester, Remington, or Federal hulls.</p><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><strong>FEATURES:</strong></h2><ul><li><strong>Lead-in taper</strong></li><li><strong>Optimum load 1/2 ounce</strong></li><li><strong>Remington Style </strong></li><li><strong>12 Gauge</strong></li><li><strong>Replaces&amp;nbsp;WAA410HS</strong></li></ul>
136932 1 Claybuster Shotshell Wads 12 Gauge CB1114-12
44 characters
44/70 Passed audit Unassigned
<p>For use in 1-1/8 to 1-1/4 oz. loads. Performs best in tapered hulls, Remington or Winchester.<br></p><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><strong>FEATURES:</strong></h2><ul><li><strong>Lead-in taper</strong></li><li><strong>Optimum load 1 1/4 ounce</strong></li><li><strong>Remington Style Tapered </strong></li><li><strong>12 Gauge</strong></li><li><strong>Replaces&amp;nbsp;WAA12F114</strong></li></ul>
136933 1 Claybuster Shotshell Wads 12 Gauge CB6118-12
44 characters
44/70 Passed audit Unassigned
&lt;p&gt;For use in 1 to 1-1/8 oz. Trap, skeet, sporting clays or hunting loads. Designed for Federal and all Imports.&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;FEATURES:&lt;/strong&gt;&lt;/h2&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;Optimum load 1 1/8 ounce&lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Straight Wall Federal &amp;amp; Fiocchi Style &lt;/strong&gt;&lt;/li&gt;&lt;li&gt;&lt;strong&gt;12 Gauge&lt;/strong&gt;&lt;/li&gt;&lt;/ul&gt;
136934 1 Claybuster Shotshell Wads 12 Gauge CB4100-12B
45 characters
45/70 Passed audit Unassigned
<p>For use in 1 to 1-1/4 oz. Trap, skeet, sporting clay or hunting loads. Versatile for most hulls depending on powder volume.</p><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><strong>FEATURES:</strong></h2><ul><li><strong>Optimum load 1 ounce</strong></li><li><strong>Fits most 12 Gauge hulls depending on powder volume</strong></li><li><strong>Replaces&amp;nbsp;WJ12</strong></li></ul>
136935 1 Accurate 1680 1lb
17 characters
17/70 Passed audit Unassigned
&lt;p&gt;Accurate 1680 is an extremely fast burning, double-base, spherical rifle powder that is well suited for large capacity, high performance handgun cartridges such as the 454 Casull, 460 S&amp;amp;W and 500 S&amp;amp;W. 1680 is also an excellent choice for the 22 Hornet and 7.62 x 39, as well as other low capacity rifle cartridges. Made in the USA.&lt;br&gt;&lt;/p&gt;