Script Overview
This screen finds a caliber string in product names, product calibers, product descriptions, category descriptions, and weblog articles, then replaces it. Description reads and writes stay on language 1. View lists the matches first. Update saves every changed catalog row. A selected caliber name becomes the replacement. The run stops before any catalog search when that name matches From.
Operator Workflow
Step 1
Enter the Text
- Type the current caliber in From.
- Type the replacement in To, or select a caliber. The selected caliber replaces To.
Step 2
View One Area
- Choose one view button. Only that area is listed.
- Nothing is saved by a view.
Step 3
Review the Comparison
- Read the current text and the replacement on each row.
- Use the page arrows or the Go box to move through the list.
Step 4
Update
- Update changes writes every match, including rows on other pages.
- The banner reports how many catalog rows were written.
Step 5
Close
- Choose Close to return to the inventory index.
- The screen stays in this window.
Technical Reference & Safeguards
- Data Read:
pd_calibers for the drop-down and the selected name. Catalog reads use oc_product_description, oc_category_description, and oc_weblog_article_description with language_id = 1, plus oc_product.custom_field.
- Database Writes: Product name or description, category description, weblog article description, and custom-field calibers 2 and 35. Unchanged rows are not written. The pager counts comparison lines. The banner counts catalog rows written.
- Safeguards & Notifications: Each save uses
begin_transaction(), commit(), and rollback() in batches of 2,500. A failed batch is rolled back. The banner states the number of rows written.