SAP - Admin Product Quick / Bulk Edit + Product statistics

SAP- Admin Product Quick Edit

Fast and bulk editing of products without pain, clicks and opening the product editing form

SAP - Admin Product Quick Edit created for stores where the catalog is actually used, not just admired on weekends. If you have dozens, hundreds or thousands of products, the module removes one of the most annoying things in OpenCart: endlessly opening the product card for every small edit.

Here you edit products directly in the table.

Without reloading the page.

Without unnecessary transitions.

Without the classic admin quest of "open, wait, change one field, save, come back, repeat 200 more times."

No more needed:

• open a product card for one edit
• reload the page after each movement
• update the catalog manually where it should have been done en masse long ago

Now available:

• Edit directly in the product list
• Bulk change data by filter or by selected products
• Manage prices, promotions, discounts, SEO, categories, images, and related data in one place

In other words: OpenCart won't stop being OpenCart, but at least it will stop punishing you for every catalog edit.

What does this mean in practice?

• Faster point edits in the catalog.
• Mass updates without manual hell.
• Fewer clicks, fewer errors, less chance of hating the product edit form.
• Convenient work for a content manager, SEO specialist, marketer, merchandiser, and store owner.

How it works

Catalog -> Products -> Edit the required fields -> AJAX save without reloading

That is, the module does not force you to go into the full product card every time you need to correct the name, SKU, price, category, promotion, or image.

Key features

1. Inline editing in the product list

• Editing data without opening the full product card.
• AJAX saving without page reload.
• Popover windows for quick editing of more complex fields.
• Separate quick actions for titles, descriptions, attributes, options, OCFilter, prices, promotions, dates, categories, images.
• Quick toggles for Status and Noindex if the noindex field is present in the product table.
• Simple fields such as model, SKU, price, quantity and dates can now be edited inline: click the value in the table, edit it in place, and save without opening a popover.
• Empty model and SKU values still show the familiar + button, but the edit field opens empty and does not save + as a value.

2. Multilingual titles, descriptions and SEO

• Editing the product name in all store languages.
• Quick editing of product descriptions by language.
• Product names are now edited in one compact multilingual popover: all store languages are visible at once, with flags, without switching tabs.
• Description editing now opens in a separate modal window with the product name in the header and more workspace for language and SEO fields.
• The description editor can be selected in module settings: Summernote by default, CKEditor, or TinyMCE. CKEditor and TinyMCE use local assets and the admin language when available.
• Support for SEO fields with product_description, if they are in your build:

            - Description

            - HTML H1 / Meta H1 tag

            - Meta Title

            - Meta Description

3. Prices, promotions and discounts

• Quick editing of the base price.
• Editing special prices directly from the product list.
• One popover for multiple active special records.
• Validation of dates and checking the correctness of values.
• The promotional price cannot be higher than the basic price.

4. Features, options and OCFilter

• Quick editing of product characteristics.
• Create new attributes directly in the characteristics popover without leaving the product list.
• Inline + button in the attribute search field for creating a new attribute from the typed name when no exact match is found.
• Saved value suggestions above each language field with instant insertion into the text area.
• Copy the value to empty languages and see an empty-state indicator for faster multilingual filling.
• Attribute group display for existing and new characteristics, duplicate validation, and correct saving of the same attribute with different values.
• Quick editing of product options.
• Quick edit of OCFilter if the module is installed and active.
• For OCFilter, product categories are taken into account, and when dragging and copying, the compatibility of filters with the target product categories is checked.

5. Magnet Drag-Copy between products

• Copy data between products by simple drag and drop.
• Drag-copy is supported for: descriptions and SEO fields, characteristics, options, OCFilter.
• It is especially useful when the products are similar, and duplicating the same connections manually is simply ridiculous.

6. Images without pain and without unnecessary shamanism

• Editing the main image and product gallery in a separate window.
• Drag & Drop to sort images in the gallery.
• Drag & Drop to assign an additional photo as the main one.
• Batch upload images to the gallery.
• Automatic cleaning of temporary files after saving or canceling.
• Support for jpg, jpeg, png, gif, webp formats.

7. Flexible image storage, naming and display

• Image storage mode by category folders.
• Automatic grouping mode into folders of 100 files.
• Configurable file naming when saving an image: keep the original file name or generate a name from a template.
• The template supports {product_name}, {model}, {sku}, {product_id}, plus live preview and quick token insertion in module settings.
• If a file name is already taken, the module automatically adds a sequential index (-2, -3, -4 ...) and keeps the real extension of the uploaded image.
• Two image display modes in the product list: gallery or single photo
• For single photo mode, you can set your own width and height for the preview in the product catalog.

8. Flexible columns and normal list organization in settings

• Turning columns on and off in a table.
• Drag columns to change the order.
• Select the default sort column.
• Select ASC/DESC sorting direction.
• Option to work without default sorting.
• Controlling the display of quick action buttons: descriptions, characteristics, options, OCFilter

9. Custom columns from the product table

• Adding custom fields from the `product` table to the product list.
• Support for custom column names.
• Support for various field types: text, number, date, datetime, boolean/tinyint(1) as toggle
• For relation fields, convenient display via select is supported.

10. Product sales analytics

• A dedicated sales statistics window is available directly from the product list without opening the full product card.
• Periods 7 / 30 / 90 / 365 / all time, comparison with the previous period, average sale price, last sale, and a grouped chart for quantity, revenue, and orders.
• Additional sections include customers, bought together, reviews, promotions and discounts, product share in category turnover, general metrics, and stock forecast.
• Settings allow choosing the default period, the order-status calculation base, and enabling or disabling individual analytics sections.

Bulk operations

Mass changes: for all products in the current filter or only for selected ones.

Fields for mass update

• Price
• Promotional price
• Discount
• Number
• Status
• Noindex if the field exists in the `product` table
• Model
• SKUs
• Producer
• Categories
• Attributes
• Date added
• Date of change
• Subtract from the composition
• Delivery required
• Out of stock status

Numeric field change modes

• Set value
• Increase by a fixed value
• Reduce by a fixed value
• Increase by %
• Reduce by %
• Multiply by a factor
• Divide by the coefficient

Mass work with shares

• Support for multiple rules in one bulk operation.
• Work in groups of buyers.
• Stock priorities.
• Start and end dates.
• Separate "Change only end date" mode: updates only the end date in existing active records, does not create new records and skips products without promotions.
• Removing a promotional price.
• Option to clear previous entries before applying.
• Protection against date conflicts for the same group of buyers.

Bulk work with discounts

• Support for multiple rules in one bulk operation.
• Buyer groups.
• Quantity for discount.
• Priority.
• Start and end dates.
• Separate "Change only end date" mode: updates only the end date in existing active records, does not create new records and skips products without discounts.
• Removing a discount.
• Option to clear previous entries before applying.
• Protection against date conflicts for the same buyer group and quantity.

Bulk work with attributes

• Add/update, append, delete, replace text, migrate/rename attributes and sync values from product fields in one bulk operation.
• Apply changes to all store languages, only the current language, or selected languages.
• Copy attributes from a reference product in merge or overwrite mode before applying commands.
• Cleanup tools normalize case, trim extra spaces, remove duplicate words and remove empty attributes.
• Preview Before / After changes before applying, with optional sorting by attribute group and sort order.

Filters for quick work

The module adds filters that are really missing when working live with the catalog:

• Product ID
• SKUs
• Manufacturer with multi-select and live search
• Category with multi-select and live search
• Presence / absence of image
• Special price: quick selection of products with an active special price or without one

The standard OpenCart / ocStore filters do not disappear. That is, you do not change the usual catalog page to something else, you simply get an adequate version of it.

Security, validation and change control

• Checking the uniqueness of SKUs.
• Checking the uniqueness of the model.
• Validation of price, quantity and dates.
• Checking for `date_modified` conflict to avoid overwriting another user's changes.
• Correct processing of special / discount rules with conflict checking.

Interface improvements

• Button to collapse/expand the left menu.
• Ability to hide the right filter block for OS3.
• More workspace for the table.
• Fixed horizontal navigation buttons for wide tables.
• More convenient to work on laptops and small screens.
• Popover arrows for quick-edit windows are aligned to the element that opened them, so the popup visually points to the correct product row.
• TinyMCE fullscreen mode in the description modal opens across the full screen instead of being limited by the modal window.

What can be edited directly in the product list

• Product name by language
• Description by language
• HTML H1 / Meta H1 tag
• Meta Title
• Meta Description
• Model
• SKUs
• Producer
• Categories
• Main category, if supported by SEO Pro / main_category
• Price
• Promotional prices
• Number
• Status
• Noindex if the field exists in the product table
• Date added
• Date of change
• Main image
• Image gallery
• Characteristics
• Options
• OCFilter, if installed
• Custom fields from the product table

Module for

• stores with a large or small catalog.
• teams that edit titles, prices, promotions, categories, and SEO every day.
• those who want to work with products quickly, rather than through the traditional OpenCart endurance marathon.

Module languages

• Ukrainian
• English
• Russian

SAP- Admin Product Quick Edit transforms the product list from a simple view into a full-fledged working tool. The module covers both point-by-point inline edits and serious mass updates on prices, promotions, discounts, quantities, categories, images and related product data.

If your catalog is larger than "a few test items", this module shows its value very quickly. Because when a product is edited in one or two movements instead of a small administrative drama, working simply becomes faster. And, oddly enough, more pleasant.

Installation/Update of the module

Demo

🔗 Product catalog

https://oc34.sapas.pw/admin/index.php?route=catalog/product

🔗 Module settings

https://oc34.sapas.pw/admin/index.php?route=extension/module/sap_quick_edit

Login: demo

Password: demo

Performance tips

• Disable unnecessary columns
• Work through filters
• Especially effective for large catalogs

By purchasing the SAP - Admin Product Quick Edit module, you are investing in the development of the module, which will return to you in the form of new functionality.

Telegram group - Opencart SAP
Telegram @doc_sap

For those who read to the end - 952402-sap