[Skip to main content](#vessel-content) # Import Open cart to Hikashop ## - **[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")** - [![Erwin66's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35552-erwin66 "View Erwin66's Profile") Topic Author - [ Offline](/forum/user/35552-erwin66) Less More - Posts: 7 - Thank you received: 0 - - 11 years 7 months ago [\#193647](#193647) by [Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile") *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#193647 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* was created by *[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")* -- url of the page with the problem -- : [ www.breister.nl](http://www.breister.nl) -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 11 years 7 months ago [\#193870](#193870) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#193870 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* Hello, > I have set the asked options correct Can you check again the values that you have set through the "Database's name where your Opencart's datas are hosted " and "Opencart's website root path" options ? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")** - [![Erwin66's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35552-erwin66 "View Erwin66's Profile") Topic Author - [ Offline](/forum/user/35552-erwin66) Less More - Posts: 7 - Thank you received: 0 - - 11 years 7 months ago [\#193888](#193888) by [Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile") Replied by *[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")* on topic *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#193888 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* I have checked the values but it's not working. The values i use are correct, i think. I use the correct name of the Open cart database and the full path where open cart is installed. Any suggestions? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 7 months ago [\#193979](#193979) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#193979 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* Hi, Can you try to change the line: $query = 'SHOW TABLES FROM '.$this->opencDatabase.' LIKE '.$database->Quote(substr(hikashop_table('oc_product',false),3)).';'; to: $query = 'SHOW TABLES FROM '.$this->opencDatabase.' LIKE '.$database->Quote('oc_product').';'; in the file administrator/components/com_hikashop/helpers/import/openc.php and see if that helps ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")** - [![Erwin66's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35552-erwin66 "View Erwin66's Profile") Topic Author - [ Offline](/forum/user/35552-erwin66) Less More - Posts: 7 - Thank you received: 0 - - 11 years 7 months ago [\#194021](#194021) by [Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile") Replied by *[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")* on topic *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#194021 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* Sorry, this gives the same result. "Opencart has not been found in the database you specified" Is it possible that there is something changed in the database structure of open cart? I use open cart version 1.5.6 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 7 months ago [\#194027](#194027) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#194027 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* Hi, It's possible. Can you check the tables of the OpenCart database ? Do you have a table called oc_product ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")** - [![Erwin66's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35552-erwin66 "View Erwin66's Profile") Topic Author - [ Offline](/forum/user/35552-erwin66) Less More - Posts: 7 - Thank you received: 0 - - 11 years 7 months ago [\#194410](#194410) by [Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile") Replied by *[Erwin66](/forum/user/35552-erwin66 "View Erwin66's Profile")* on topic *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#194410 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* I have found the problem, the table prefix was not oc_ because i changed this during the installation of open cart in another prefix. The import is now completed but without the images and incorrect prices. The categories and products are succesfully imported. Thanx for your help so far. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 7 months ago [\#194419](#194419) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import Open cart to Hikashop](/forum/37-import-export-csv-xls/875497-import-open-cart-to-hikashop#194419 "-- url of the page with the problem -- : www.breister.nl -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.4.0 -- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified I get the message "Opencart has not been found in the database you specified" I have set the asked options correct")* Ah ok ! Thank you for the information. We didn't know that it was possible to change the prefix of the tables in OpenCart. We'll have to do something handle that then ! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU0OTctaW1wb3J0LW9wZW4tY2FydC10by1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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.252 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)