[Skip to main content](#vessel-content) # How can I insert a column with product code in the backend in the new version 3 ## - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") Topic Author - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 3 years 3 months ago [\#353373](#353373) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3?start=20#353373 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below: [attachme In the current version 3.2, I tried several ways to make this modification, but I do not get the same result. Thank you so much")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 3 years 3 months ago [\#353374](#353374) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3?start=20#353374 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below: [attachme In the current version 3.2, I tried several ways to make this modification, but I do not get the same result. Thank you so much")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") Topic Author - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 3 years 3 months ago [\#353386](#353386) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3?start=20#353386 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below: [attachme In the current version 3.2, I tried several ways to make this modification, but I do not get the same result. Thank you so much")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") Topic Author - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 3 years 3 months ago [\#353397](#353397) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3?start=20#353397 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below: [attachme In the current version 3.2, I tried several ways to make this modification, but I do not get the same result. Thank you so much")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 3 years 3 months ago [\#353432](#353432) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3?start=20#353432 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below: [attachme In the current version 3.2, I tried several ways to make this modification, but I do not get the same result. Thank you so much")* 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: Code: $db->setQuery('SELECT order_id '.$_SESSION['hikashop_order_listing_query']); to: Code: $db->setQuery('SELECT b.order_id '.$_SESSION['hikashop_order_listing_query']); 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.052 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)