Quick Attribute Price Update

Quick Attribute Price Update v3.0.0: find attribute (option value) prices across all your products and update them in one table, for Zen Cart 1.5.8 through 3.0.0, as an encapsulated plugin

GitHub: https://github.com/dbltoe/Quick_Attribute_Price_Update
Download: https://github.com/dbltoe/Quick_Attribute_Price_Update/releases/tag/v3.0.0
Zen Cart: 1.5.8a, 2.0.x, 2.1.0, 2.2.x, 2.3.x and 3.0.0, one package
PHP: 7.4 through 8.5
License: GPL-2.0

What it does

Zen Cart changes attribute prices in Catalog > Attributes Controller, one product and one attribute at a time. On a store where most products are priced by attributes, a round of price changes means opening every product. This adds Catalog > Quick Attribute Price Update: find the attribute rows you want across all your products, type the new prices right in the table, and save them all with one button.

• By product: exact IDs and ranges, 12, 15, 40-55.
• By category, with or without everything in its subcategories (linked products included).
• By option name and option value: every product's Size option, or just Size: 1 inch, on one screen.
• Plus product name or model, Active/Inactive, and Priced Rows Only to hide rows with no price; 25 to 200 rows per page.
• Grouped by product, with each product's base price and its "Starting at" price, and links to edit the product, open it in the Attributes Controller, or change its base price in Quick Price Update when that's installed.
• Edit in the table: the prefix (+, - or blank), the price and the one-time price. Changed rows are highlighted and counted, and only those rows are saved.
• Checked before anything is written. 1,234.50 works; 12,50 is refused rather than misread. A row that doesn't pass comes back highlighted with what you typed.
• No overwriting each other. If a row changed somewhere else after your page loaded, it's skipped and you're told which one.
• The storefront stays right. For every product a save touches, the value Zen Cart sorts by price with is refreshed, so price sorting and "Starting at" prices update, and the product's last-modified date is stamped.
• Notes for what a row's price doesn't show by itself: Free, Display Only, Default, Not Discounted, Not in Base Price, price factors, quantity prices, and word or letter pricing. A product whose own price is 0 but which isn't set to Priced by Attributes is flagged, since shoppers may see a price of 0.
• A link in the Attributes Controller: its Additional Actions menu gets "Quick Attribute Price Update: This Product" (or "This Category").

Admins without the page in their profile don't see it, its menu entry, or the link.

Encapsulated. One folder under zc_plugins/, installed from Plugin Manager. No core files are changed, no tables are added, and there are no settings. Uninstalling takes it off the menu and leaves nothing behind.

Installing

1. Upload zc_plugins/QuickAttributePriceUpdate/ so it lands at <store root>/zc_plugins/QuickAttributePriceUpdate/v3.0.0/.
2. Admin > Modules > Plugin Manager > Quick Attribute Price Update > Install.
3. Open Catalog > Quick Attribute Price Update.

For admins who aren't superusers, add the page to their profile in Admins > Admin Profiles.

Companion: Quick Price Update changes products' own (base) prices and quantities: https://www.zen-cart.com/threads/207447. This page links to it when both are installed, but each works alone.

The full documentation (readme.html) is inside the plugin and linked from the Plugin Manager panel.

Reporting a problem

Please include your Zen Cart and PHP versions and what you saw. If a page goes blank or something doesn't save, look in logs/ for a myDEBUG- file from that moment and attach it.

Quick Attribute Price Update v3.0.1 is out: https://github.com/dbltoe/Quick_Attribute_Price_Update/releases/tag/v3.0.1

A fix for stores whose option or value names repeat, found on a live store the day v3.0.0 came out.

• Option Name and Option Value now search by name. If your store has two options both called "Size:", or "1 inch" saved as several different option values, v3.0.0 listed each one separately with nothing to tell them apart, and choosing one found only part of the rows. Now each name shows once and finds every matching row, so Size: plus 1 inch brings up every product's 1-inch row.
• Choosing an option value while Option Name is on "All Option Names" now picks its option name too.

Links and bookmarks from v3.0.0 still work.

To upgrade: copy zc_plugins/QuickAttributePriceUpdate/v3.0.1/ beside the v3.0.0 folder and click Upgrade in Plugin Manager. No settings or database changes.

Quick Attribute Price Update v3.0.2 is out: https://github.com/dbltoe/Quick_Attribute_Price_Update/releases/tag/v3.0.2

A behind-the-scenes release. On a store with nothing added, the page looks and works exactly as before.

• Saving sends only the rows you changed. On a full page of 200 rows, that keeps the form well under PHP's max_input_vars limit, which some hosts set low. It writes only the changed values, as before. With JavaScript off, every row is sent the way it was.
• New notifiers for developers, so other code can extend the page without editing it: extra data for the rows shown, panels between the search form and the table, extra table columns, its own search fields (kept through paging and after saving), and its own lines in the save messages. They're listed with their parameters in docs/CUSTOMIZING.md in the repo.

No tables, no settings, and no core files are changed. Tested on Zen Cart 1.5.8a, 2.0.1, 2.1.0, 2.2.2, 2.3 and 3.0.0-dev, on PHP 7.4 through 8.5.

To upgrade: copy zc_plugins/QuickAttributePriceUpdate/v3.0.2/ beside your current version folder and click Upgrade in Plugin Manager. If Plugin Manager was already open when you copied the folder, reload it first. No settings or database changes.