Edit your OpenCart catalog like a spreadsheet.

How to bulk edit products in OpenCart

OpenCart’s product form edits one product at a time. A price rise across a brand means opening every product, or exporting a sheet, which some extension must then import without damaging anything.

Bulk Product Editor turns Catalog, Bulk product editor into a spreadsheet. Click, type, use Enter, Tab and the arrow keys, paste a column from Excel or Google Sheets, and save it all at once. Paging and sorting run on the server, so it stays quick whether you have 50 products or 50,000.

What you can edit

• In the grid: name, model, SKU, price, special price, quantity, status, weight, categories, manufacturer and out-of-stock status.
• The quantity and price of every option value, which most editors leave out.
• Filters: name, model, SKU, ID, category with subcategories, manufacturer, status, stock, active special, price and quantity ranges, and OpenCart 4 masters and variants.

Changed cells are highlighted until you save. A value someone else changed after you opened the page is never overwritten. OpenCart 4 variants follow their master product unless they override the field, just as they do in the product form.

Bulk actions with preview

Apply to the ticked products or everything that matches the filter. The preview shows before and after first, and large jobs run in steps of 200 by default, adjustable from 20 to 1000, with a progress bar. Lower it on slow or shared servers.

Specials with dates per customer group are useful for campaigns: filter a category, apply 20% off for two weeks, and remove it afterwards in one action.

Undo, change log and CSV export

Every save and bulk action goes into a change log with the user, the time and the old and new value of each cell. One click undoes a change, and values changed again since then are kept. You can undo the undo, and interrupted actions can be continued. Entries are kept for 90 days by default.

CSV export covers the filtered or selected products, ready for Excel and Google Sheets. Note that the editor exports only; for scheduled supplier updates, see Scheduled Supplier Feed Import.

The editor follows user group permissions: access opens the grid read-only, and modify allows saving, bulk actions and undo.

Bulk editor or CSV import?

It is a good partner for large catalogs and theme kits: the Food, Axle and other store kits include it. See the packages, or get the Bulk Product Editor on the store.

Compatibility

OpenCart 4.0.2 to 4.1.x and 3.0.3 to 3.0.5, in separate packages under one licence. Tested on 4.1.0.4 and 3.0.5.1. OpenCart events only, with no core changes and no OCMOD patches. Thumbnails can be turned off for the fastest grid on very slow image storage.

Common jobs and how long they take

1. Price rise on one brand: filter by manufacturer, select all matching, increase by a percentage, round to .99, preview, apply.
2. Weekend sale: filter a category, add a special at 20% for one customer group, with dates.
3. Stock count: filter by model, paste a column from your stocktake sheet, save.
4. Tidy a category: filter products with no category, and add them in one action.
5. Rename a supplier code: find and replace in models or SKUs.

A good habit is to run a bulk action on ten products first, check them on the storefront, and then apply it to the whole filter. If something is off, undo takes one click. Do not rely on the log as a backup, though. Keep normal database backups, as entries expire after your chosen period.