How can I insert a column with product code in the backend in the new version 3

Hi Nicolas,
I just realized that the "Orders product filter" plugin only searches for existing products, but if the product has been removed it no longer finds the order. It is not possible to find the orders with products that have already been deleted?
Thanks again.

Hi,

Indeed, it doesn't support deleted products since the customer first have to select a product among the existing ones.
I don't see a way to allow for that with that plugin.
I would require developing from scratch to allow for searches with an input field.

Hi Nicolas,

Thanks for your answer, sorry I didn't explain myself well.
I am referring to the case of searching for orders that at the time (when the order was placed), the product existed, but that currently, due to stock updates, has been eliminated.

Thank you, have a nice weekend

Hi Nicolas,
I have noticed a strange behavior when making a new order or consulting any of the existing ones in the administration orders list, if I have an item selected in the "order product filter" plugin at the same time
The following error screen appears:

1052 Column 'order_id' in field list is ambiguous
Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/views/order/view.html.php:440
6 OrderViewOrder->form() JROOT/administrator/components/com_hikashop/views/order/view.html.php:1203
7 OrderViewOrder->show() JROOT/administrator/components/com_hikashop/views/order/view.html.php:28
8 OrderViewOrder->display() JROOT/libraries/src/MVC/Controller/BaseController.php:645
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2463
10 hikashopController->display() JROOT/administrator/components/com_hikashop/controllers/order.php:608
11 OrderController->show() JROOT/administrator/components/com_hikashop/controllers/order.php:658
12 OrderController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:678
13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441
14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73
15 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
16 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293
21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
22 require_once() JROOT/administrator/index.php:32

in the debugger

error - Uncaught Throwable of type mysqli_sql_exception thrown with message "Column 'order_id' in field list is ambiguous". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(137): mysqli->prepare() #1 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(1089): Joomla\Database\Mysqli\MysqliStatement->__construct() #2 [ROOT]/libraries/vendor/joomla/database/src/DatabaseDriver.php(1900): Joomla\Database\Mysqli\MysqliDriver->prepareStatement() #3 [ROOT]/administrator/components/com_hikashop/views/order/view.html.php(440): Joomla\Database\DatabaseDriver->setQuery() #4 [ROOT]/administrator/components/com_hikashop/views/order/view.html.php(1203): OrderViewOrder->form() #5 [ROOT]/administrator/components/com_hikashop/views/order/view.html.php(28): OrderViewOrder->show() #6 [ROOT]/libraries/src/MVC/Controller/BaseController.php(645): OrderViewOrder->display() #7 [ROOT]/administrator/components/com_hikashop/helpers/helper.php(2463): Joomla\CMS\MVC\Controller\BaseController->display() #8 [ROOT]/administrator/components/com_hikashop/controllers/order.php(608): hikashopController->display() #9 [ROOT]/administrator/components/com_hikashop/controllers/order.php(658): OrderController->show() #10 [ROOT]/libraries/src/MVC/Controller/BaseController.php(678): OrderController->edit() #11 [ROOT]/administrator/components/com_hikashop/helpers/helper.php(2441): Joomla\CMS\MVC\Controller\BaseController->execute() #12 [ROOT]/administrator/components/com_hikashop/hikashop.php(73): hikashopController->execute() #13 [ROOT]/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('/homepages/23/d...') #14 [ROOT]/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() #15 [ROOT]/libraries/src/Component/ComponentHelper.php(361): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() #16 [ROOT]/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent() #17 [ROOT]/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch() #18 [ROOT]/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\AdministratorApplication->doExecute() #19 [ROOT]/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute() #20 [ROOT]/administrator/index.php(32): require_once('/homepages/23/d...') #21 {main}

Thanks

Hi,

Thanks for the feedback. That's an issue with the new "next" and "previous" buttons on the order edit screen, in some cases.
Change the line: to: in the file administrator/components/com_hikashop/views/order/view.html.php and it will fix the problem.
We'll add the patch on our end.