[Skip to main content](#vessel-content) # Move products to Joomla 2.5 ## - **[HappyHammer](/forum/user/852-happyhammer "View HappyHammer's Profile")** - [![HappyHammer's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar852.jpg)](/forum/user/852-happyhammer "View HappyHammer's Profile") Topic Author - [ Offline](/forum/user/852-happyhammer) Less More - Posts: 43 - Thank you received: 0 - - 14 years 9 months ago [\#37239](#37239) by [HappyHammer](/forum/user/852-happyhammer "View HappyHammer's Profile") *[Move products to Joomla 2.5](/forum/4-how-to/37239-move-products-to-joomla-2-5#37239 "Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH.")* was created by *[HappyHammer](/forum/user/852-happyhammer "View HappyHammer's Profile")* Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH. --- always look on the bright side.... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM3MjM5LW1vdmUtcHJvZHVjdHMtdG8tam9vbWxhLTI1P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile")** - [![woonydanny's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5795.jpg)](/forum/user/5795-woonydanny "View woonydanny's Profile") - [ Offline](/forum/user/5795-woonydanny) Less More - Posts: 218 - Thank you received: 6 - - 14 years 9 months ago - 14 years 9 months ago [\#37244](#37244) by [woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile") Replied by *[woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile")* on topic *[Re: Move products to Joomla 2.5](/forum/4-how-to/37239-move-products-to-joomla-2-5#37244 "Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH.")* I will try and recall this from my memory. 1. upgrade your hikashop version on J1.5 site to latest version! 2. I use SP Upgrade to migrate site from J1.5 to J2.5, this will migrate all your core joomla stuff. 3. On new J2.5 site install HikaShop 4. then export hikashop tables from J1.5 database with phpmyadmin 5. import those tables into the J2.5 database with phpmyadmin 6. as the hikashop versions are the same on both J1.5 and J2.5 sites it should all work then ![B)](/media/kunena/emoticons/1.png "B)") Last edit: 14 years 9 months ago by [woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM3MjM5LW1vdmUtcHJvZHVjdHMtdG8tam9vbWxhLTI1P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile")** - [![woonydanny's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5795.jpg)](/forum/user/5795-woonydanny "View woonydanny's Profile") - [ Offline](/forum/user/5795-woonydanny) Less More - Posts: 218 - Thank you received: 6 - - 14 years 9 months ago [\#37249](#37249) by [woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile") Replied by *[woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile")* on topic *[Re: Move products to Joomla 2.5](/forum/4-how-to/37239-move-products-to-joomla-2-5#37249 "Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH.")* Just found these pretty useful articles on migrating J1.5 to 2.5 from the team over at Jomsocial. There are 8 articles that explain the processes, reviews the different migrators and what you need to know - [ www.jomsocial.com/blog.html](http://www.jomsocial.com/blog.html) The article that explains the process for migrating jomsocial would be the same for hikashop - [ www.jomsocial.com/blog/migrating-jomsoci...-into-joomla-25.html](http://www.jomsocial.com/blog/migrating-jomsocial-data-into-joomla-25.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM3MjM5LW1vdmUtcHJvZHVjdHMtdG8tam9vbWxhLTI1P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile")** - [![woonydanny's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5795.jpg)](/forum/user/5795-woonydanny "View woonydanny's Profile") - [ Offline](/forum/user/5795-woonydanny) Less More - Posts: 218 - Thank you received: 6 - - 14 years 8 months ago [\#39174](#39174) by [woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile") Replied by *[woonydanny](/forum/user/5795-woonydanny "View woonydanny's Profile")* on topic *[Re: Move products to Joomla 2.5](/forum/4-how-to/37239-move-products-to-joomla-2-5#39174 "Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH.")* Also, just thought that after you install HikaShop on the new J2.5 site, you will need to delete all the Hikashop database tables before importing the J1.5 hikashop tables. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM3MjM5LW1vdmUtcHJvZHVjdHMtdG8tam9vbWxhLTI1P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")** - [![brentwilliams2's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile") - [ Offline](/forum/user/1200-brentwilliams2) Less More - Posts: 78 - Thank you received: 5 - - 13 years 6 months ago [\#98944](#98944) by [brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile") Replied by *[brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")* on topic *[Re: Move products to Joomla 2.5](/forum/4-how-to/37239-move-products-to-joomla-2-5#98944 "Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH.")* Hi woonydanny, I used your instructions and had no problem on my local server. But I had an issue with importing to my shared server. Specifically: Error SQL query: CREATE ALGORITHM = UNDEFINED DEFINER = `XXXXXXX_XXXXXXX`@`localhost` SQL SECURITY DEFINER VIEW `jos_hikashop_click_view` AS SELECT `a`.`user_id` AS `user_id` , SUM( `b`.`click_partner_price` ) AS `click_price` FROM ( `jos_hikashop_user` `a` LEFT JOIN `jos_hikashop_click` `b` ON ( ( ( `a`.`user_id` = `b`.`click_partner_id` ) AND ( ( CASE WHEN ( `a`.`user_currency_id` =0 ) THEN 2 ELSE `a`.`user_currency_id` END ) = `b`.`click_partner_currency_id` ) ) ) ) WHERE ( ( `a`.`user_partner_activated` =1 ) AND ( `b`.`click_partner_paid` =0 ) ) GROUP BY `b`.`click_partner_id` ; MySQL said: \#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation Any suggestions? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM3MjM5LW1vdmUtcHJvZHVjdHMtdG8tam9vbWxhLTI1P3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86295 - Thank you received: 14273 - - 13 years 6 months ago [\#99015](#99015) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Move products to Joomla 2.5](/forum/4-how-to/37239-move-products-to-joomla-2-5#99015 "Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH.")* The _view "tables" are not necessary. Simply delete them before and try again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM3MjM5LW1vdmUtcHJvZHVjdHMtdG8tam9vbWxhLTI1P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")** - [![brentwilliams2's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile") - [ Offline](/forum/user/1200-brentwilliams2) Less More - Posts: 78 - Thank you received: 5 - - 13 years 6 months ago [\#99020](#99020) by [brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile") Replied by *[brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")* on topic *[Re: Move products to Joomla 2.5](/forum/4-how-to/37239-move-products-to-joomla-2-5#99020 "Hi Nicolas, Can you tell me the easiest way to move all of my products and categories to a new Joomla 2.5 build. Do I need to upgrade the version of Hikashop on the old version of the site first? HH.")* Thanks for the response, Nicolas. I ended up having my hosting company import for me. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM3MjM5LW1vdmUtcHJvZHVjdHMtdG8tam9vbWxhLTI1P3RtcGw9bWFya2Rvd24=) 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.101 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)