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 6,551–6,600 of 29,011

PID Lang Original Name Proposed SEO Name Length Status / Bucket Actions
103142 1 CUST FC 264 WIN MAG
20 characters
20/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>
103143 1 CUST FC 270 WHBY MAG
21 characters
21/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>
103144 1 FACT CRMP DIE 30-378 WHB [ 1 1/4-12 THREAD ]
45 characters
45/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>
103145 1 CUST FC 308 MARLIN EXP
23 characters
23/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>
103146 1 CUST FC 308 NORMA MAG
22 characters
22/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>
103147 1 CUST FC 32 REM
15 characters
15/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>
103148 1 CUST FC 325 WSM
16 characters
16/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>
103149 1 CUST FC 338 BLASER MAG
23 characters
23/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>
103150 1 CUST FC 338 RUM
16 characters
16/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>
103151 1 CUST FC 340 WHBY MAG
21 characters
21/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>
103152 1 CUST FC 357 HERRETT
20 characters
20/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>
103153 1 CUST FC 375 SOCOM
18 characters
18/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>
103154 1 Lee Precision Factory Crimp Die 401 WSL
40 characters
40/70 Passed audit Unassigned
<p>The Lee Precision 401 WSL Factory Crimp Die with standard 7/8&quot; by 14 threads is packaged in a custom fit plastic storage case with complete instructions.</p><p><strong style=&quot;line-height: 1.6em;&quot;>Lee Precision Factory Crimp Dies</strong><span style=&quot;line-height: 1.6em;&quot;>&amp;nbsp;are the only effective way to crimp Bottle Neck Rifle Cartridges<strong>.</strong>&amp;nbsp;This important step should be performed on all loads used for hunting. It crimps the bullet in place more firmly than any other tool. It is impossible to buckle the case, as with regular roll crimp dies. Trim length is not critical. Tests demonstrate that bullets which have no cannelure will shoot more accurately if crimped in place with the Lee Factory Crimp Die.</span></p><p><span style=&quot;line-height: 1.6em;&quot;>Factory ammo is often more accurate and able to withstand rough handling because the bullet is firmly crimped in place. A firm crimp improves accuracy because pressure must build to a higher level before the bullet begins to move. This higher start pressure insures a more uniform pressure curve and less velocity variation. Even powder selection is less critical.</span></p><p><img alt=&quot;&quot; src=&quot;https://fsreloading.com/image/catalog/userfiles/riflefactorycrimp.jpg&quot; style=&quot;height: 323px; float: right; margin-left: 10px; margin-right: 10px;&quot;></p><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><span style=&quot;background-color: rgb(255, 255, 0); font-weight: bold; padding: 3px 7px; text-transform: uppercase;&quot;>INCLUDES:</span></h2><ul><li><strong>Instructions</strong></li><li><strong>Custom fit plastic storage case</strong></li><li><strong>Hardened Steel Factory Crimp Die</strong></li></ul><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><strong><span style=&quot;background-color: rgb(255, 255, 0); padding: 3px 7px; text-transform: uppercase;&quot;>FEATURES:</span></strong></h2><ul><li><strong>Crimps bullets in place more firmly with more uniform pressure than any other die.</strong></li><li><strong>A Simple adjusting screw makes setting the amount of crimp desired easy.</strong></li><li><strong>Produces more consistent and dependable ammo.</strong></li><li><strong>Eliminates magnum powder ignition problems.</strong></li></ul><h2 style=&quot;font-family: &amp;quot;Open Sans&amp;quot;, sans-serif; color: rgb(0, 0, 0);&quot;><span style=&quot;background-color: rgb(255, 255, 0); font-weight: bold; padding: 3px 7px; text-transform: uppercase;&quot;>NOTES:</span></h2><ul><li><strong>Factory Crimp Die is included with the Lee Pacesetter 3-Die sets</strong></li><li><strong>Fits presses with standard 7/8&quot;-14 threads</strong></li><li><strong><a href=&quot;https://fsreloading.com/press-shell-holders&quot;>Shell holder sold separately</a></strong></li><li><strong>Trim length is not critical</strong></li></ul><p><ul></ul></p>
103155 1 CUST FC 416 RUGER
18 characters
18/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>
103156 1 CUST FC 45-90 SHARPS
21 characters
21/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>
103157 1 CUST FC 6 X 45MM
17 characters
17/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>
103158 1 CUST FC 6.5X47 LAPUA
21 characters
21/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>
103159 1 CUST FC 6.5X57 R
17 characters
17/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>
103160 1 CUST FC 6.5X65 R
17 characters
17/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>
103162 1 CUST FC 7.35 CARCANO
21 characters
21/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>
103163 1 CUST FC 7.62X40 WT
19 characters
19/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>
103164 1 CUST FC 8MM LEBEL
18 characters
18/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>
103165 1 CUST FC 8X56 R
15 characters
15/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>
103166 1 CUST FC 9.3X64
15 characters
15/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>
103167 1 CUST FC 9.3X72 R
17 characters
17/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>
103168 1 CUST FC 300 HAMR
17 characters
17/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>
103169 1 CUST FC 9.3X74 R
17 characters
17/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>
103171 1 CUSTOM CLG 6.5-06
18 characters
18/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>
103172 1 CUSTOM CLG 340 WHBY MAG
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>
103173 1 CUSTOM CLG 270 WHBY MAG
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>
103174 1 CUSTOM CLG 225 WIN
19 characters
19/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>
103175 1 CUSTOM CLG 240 WHBY MAG
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>
103176 1 CUSTOM CLG 6MM PPC
19 characters
19/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>
103177 1 CUSTOM CLG 222 REM MAG
23 characters
23/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>
103178 1 CUSTOM CLG 28 NOSLER
21 characters
21/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>
103179 1 CUSTOM CLG 6MM TCU
19 characters
19/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>
103180 1 CUSTOM CLG 45/70 LEVEREV
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>
103181 1 CUSTOM CLG 8X68MM S
20 characters
20/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>
103182 1 CUSTOM CLG 308 NORMA MAG
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>
103183 1 CUSTOM CLG 458 SOCOM
21 characters
21/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>
103184 1 CUSTOM CLG 6.5X57 MAU
22 characters
22/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>
103185 1 CUSTOM CLG 50 BEOWULF
22 characters
22/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>
103186 1 CUSTOM CLG 7.35 CARCANO
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>
103187 1 CUSTOM CLG 416 RUGER
21 characters
21/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>
103188 1 CUSTOM CLG 280 REM ACK I
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>
103189 1 CUSTOM CLG 30 HERRETT
22 characters
22/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>
103190 1 CUSTOM CLG 7.62X40 WIL T
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>
103191 1 CUSTOM CLG 6X47 LAPUA
22 characters
22/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>
103192 1 CUSTOM CLG 327 FED MAG
23 characters
23/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>
103193 1 CUSTOM CLG 348 WIN
19 characters
19/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>