[vqmod] Order Options Filter

This extension is a free single vQmod that adds an "Options" column to Sales - Orders area and a possibility to filter orders by option names and values.

Prerequisites:
* You need vQmod installed for this module to work.

Compatibility: OpenCart 1.5.x

Screenshots and also downloadable in OpenCart extension store and in our store.

Cheers,
Martin

ffct.cc

I like it... thanks added to my collection

Dear sir,

I downloaded your mod: [vqmod] Order Options Filter and uploaded it to my website. But I get this error message:
Notice: Undefined index: options in /home/www/zero2hero.asia/admin/vq2-admin_controller_sale_order.php on line 547

Can you advise me what is missing? Your help is very much appreciated

Thanks

Peter

Please replace the following line in the xml
with
That should fix the notice.

Dear sir,

Thank you

peter

Dear sir,

The earlier error messages disappered but this new message appears when I do a search:

Notice: Error: Unknown column 'oo.name' in 'where clause'
Error No: 1054
SELECT o.order_id, o.firstname, o.lastname, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified, o.email, o.age, o.ride, o.payment_address_2, o.telephone, o.payment_method FROM `order` o WHERE o.order_status_id > '0' AND LCASE(concat(oo.name,' ',oo.value)) LIKE '%kuala%' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 in /home/www/zero2hero.asia/system/database/mysql.php on line 49


Your kind advise is n=much appreciated,

Thanks

peter

Found the answer. Thanks anyway

Hello,

If I want to retrieve the name of the product in the admin order list how do I modify the SQL?

Is this correct:

$sql = "SELECT o.order_id, o.firstname, o.lastname, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status, oo.value AS options, oo.name AS prodname, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified, o.email, o.age, o.ride, o.payment_address_2, o.telephone, o.payment_method FROM `" . DB_PREFIX . "order` o LEFT JOIN `" . DB_PREFIX . "order_option` oo LEFT JOIN `" . DB_PREFIX . "order_product` oo ON o.order_id = oo.order_id";

Thanks

Peter