Community Forums

by **bull5-i** » Sun Sep 25, 2011 5:06 pm

Admin Quick Edit (AQE) modification enables you to select which columns are displayed on the admin
product list page and which of them are editable. Additionally you can change to order of the displayed columns.

Currently you can choose to display id, image, product name, model, manufacturer, category, price, quantity, sort order, weight, sku, upc, ean, jan, isbn, mpn, location, seo keyword, status, tax class, minimum quantity, subtract stock, out of stock status, requires shipping, date available, length, width, height, length class, weight class, stores, downloads and points. From this list you can choose to quick edit all but product id.
Additionally you can quick edit product descriptions, additional images, attributes, discounts, specials, options and related products.

To quick edit a value just click on the value you want to change and it gets saved when you hit Enter. Clicking outside the edit box or pressing Esc will cancel the edit.

Features:

choose, which columns are displayed
choose, which columns can be quick edited
custom sort the column order
fully multilingual
autocomplete filter value for location, seo, sku, upc, ean, mpn, jan, isbn [added in v1.2]
display & filter by category [added in v1.3]
search anywhere (OC 1.4.9 like filtering that matches filter string anywhere in the phrase) [added in v2.0]
alternating row colours and hover highlighting for easier reading (pure CSS3, so you need to use a newer browser) [added in v2.0]
links to the store front for quick viewing of products (has multistore support) [added in v2.0]
interval filtering for numeric and temporal filters (to search price between 100 and 300 type "100<300"; to search quantity below 10 (included) type "<=10"; to search amount greater than 12.3 type "12.3<") [added in v2.0]
option to choose between single and double click quick editing [added in v2.0]
status highlighting

Modification settings can be configured from module settings page (Extensions -> Modules). From there you can select which columns are displayed, which are editable and how the columns are sorted.

Product Quick Edit can be purchased from http://www.opencart.com/index.php?route=extension/extension/info&extension_id=3369

Version 2.0.1 is compatible with OpenCart 1.5.x and it is currently available only as a vQmod.

Live DEMO: http://goo.gl/pFHNJ

Some screenshots:
ADMIN
Modification settings page

: Modification settings page; admin_module_settings_products.png (32.13 KiB) Viewed 2433 times

: Editing SEO Keyword value; admin_catalog_products_edit_seo.png (34.31 KiB) Viewed 2587 times

: Saving SEO Keyword value; admin_catalog_products_saving_seo.png (34.29 KiB) Viewed 2587 times

- edit 30.11.2012 - Released version 2.0.1 for OpenCart 1.5.x (improved interoperability on CSS & JS side)
- edit 11.10.2012 - Released version 2.0.0 for OpenCart 1.5.x (new feature and new quick editable fields)
- edit 05.04.2012 - Released version 1.5.1 for OpenCart 1.5.x (improves page load speed a bit by optimizing total count sql query)
- edit 16.02.2012 - Released version 1.5.0 (adds extension and support info to module settings page) for OpenCart 1.5.x
- edit 03.12.2011 - Released version 1.4.0 (adds option to switch to single language editing) for OpenCart 1.5.x
- edit 29.11.2011 - Released version 1.3.3 (fixes single quote escaping problem) for OpenCart 1.5.x
- edit 22.11.2011 - Released version 1.3.2 (fixes filtering products without category) for OpenCart 1.5.x
- edit 22.11.2011 - Released version 1.3.1 (fixes product filtering if Status column is not displayed) for OpenCart 1.5.x
- edit 26.10.2011 - Released version 1.3 (adds filter by category capability) for OpenCart 1.5.x
- edit 03.10.2011 - Released version 1.2 (adds autocomplete to seo, sku, upc and location) for OpenCart 1.5.1.3
- edit 28.09.2011 - Released version 1.1 (adds support for editing product names, manufacturer, upc and location)
- edit 24.09.2011 - Initial release

by **bull5-i** » Sun Sep 25, 2011 5:08 pm

Additional images:

: SEO Keyword saved; admin_catalog_products_seo_saved.png (36.65 KiB) Viewed 2586 times

: Editing Status value; admin_catalog_products_edit_status.png (35.48 KiB) Viewed 2586 times

by **Maansy** » Sun Sep 25, 2011 7:20 pm

What a great mod. What other columns can be added to the code? Best of all, it vqmod
Thanks

by **bull5-i** » Mon Sep 26, 2011 3:20 pm

The easiest would be to add columns that store values directly in the "product" table. That includes upc, location, length, width, height and date available. With a little more code you could also add manufacturer selection.

Theoretically you could edit just about anything you like, it's just a question of coding amount, necessity and expediency.

by **bull5-i** » Wed Sep 28, 2011 10:17 am

Version 1.1 released - this adds the support to edit product names, manufacturer, upc and location. The cool thing about editing product names is that it also works for multilingual shops and you can edit the name for whichever language you have installed.

by **bull5-i** » Mon Oct 03, 2011 6:16 pm

Version 1.2 released - this adds autocomplete to seo, sku, upc and location filters. Compatible with the OpenCart 1.5.1.3

by **bull5-i** » Tue Oct 25, 2011 9:26 pm

Version 1.3 released for OpenCart 1.5.x - this adds filter by category capability

: Filter by category; admin_catalog_products_filter_by_category.png (41.8 KiB) Viewed 2433 times

by **bull5-i** » Tue Nov 22, 2011 8:52 am

Released version 1.3.1 - this is a bugfix release to correct the issue with product filtering if Status column was not displayed.

by **bull5-i** » Tue Nov 22, 2011 11:17 pm

Released version 1.3.2 - this is a bugfix release that fixes filtering of products without category.

by **bull5-i** » Tue Nov 29, 2011 8:04 pm

Released version 1.3.3 - this is a bugfix release that fixes single quote escaping problem in javascript.

by **bull5-i** » Sat Dec 03, 2011 9:59 am

Released version 1.4.0 - this is a small feature release that adds option to switch to single language editing. This affects Product Name editing. It will automatically switch to single language editing mode if only one language is installed.

by **daguy** » Sat Dec 31, 2011 8:11 pm

have issues probably due to cusomization of template can you contact me to help please willing to pay for time involved

by **bull5-i** » Thu Feb 16, 2012 9:42 pm

Released version 1.5.0 - this adds extension and support info to module settings page

by **bull5-i** » Thu Apr 05, 2012 8:55 am

Released version 1.5.1 - this improves page load speed a bit by optimizing total count sql query

by **i2Paq** » Fri Apr 20, 2012 5:37 am

I bought your extension but it is not working at-all.

I’m running 1.5.2.x with the latest patch and also the latest version of vQmod.

Other vQmods are working so it must be your Extension.

I see the following error in the vQmod log.

MOD DETAILS:
modFile : /var/www/vhosts/hydromedi.nl/httpdocs/store/vqmod/xml/admin_quick_edit.xml
id : Enables you to select which columns are displayed on overview pages and enables to quick edit the values in place
version : 1.5.1
vqmver : 1.0.7
author : rmg
SEARCH NOT FOUND (ABORTING MOD): $url .= '&filter_name=' . $this->request->get['filter_name'];

I also tried your without any other vQmod, still not working.

by **bull5-i** » Fri Apr 20, 2012 7:36 am

The issue is caused by the latest patches that have not been formed into an official release yet.
If you want to use the bleeding edge version of OC (SVN version) then you have to update the xml script file yourself.
Once the next official version is released I will update the script myself.

by **reflexweb** » Thu Jun 28, 2012 12:09 pm

Hello,

I have installed this and it works fine using the lastest version of FireFox, Safari & Crome but not in IE - no errors are shown and it looks ok just the FILTER button does not do anything when clicked.

Please help as my client insists on IE

Kinds

Roger

by **reflexweb** » Sat Jun 30, 2012 10:16 am

Bump

Anyone able to help with this issue?

Thanks

by **bull5-i** » Tue Jul 03, 2012 7:44 am

Hi Roger,

What version of IE is your client using? I did check with the OpenCart 1.5.3 and IE 9.0 and the filter button together with other features seemed to work fine. If you are using an older version of IE than 9.0, then I kindly suggest you to upgrade to the latest.

BR

by **bull5-i** » Thu Oct 11, 2012 6:57 am

Released version 2.0.0 for OpenCart 1.5.0.x - 1.5.4.x:

Added: many new quick editable fields (including attributes, options, discounts, specials, images, descriptions and related products)
Added: alterante row background colour and hover highlighting
Added: match anywhere and interval filtering
Added: status highlighting