[Skip to main content](#vessel-content) # Transfer hikashop addres from Joomla 3 site to Joomla 5 site ## - **[fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile")** - [![fgonc124's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39153-fgonc124 "View fgonc124's Profile") Topic Author - [ Offline](/forum/user/39153-fgonc124) Less More - Posts: 19 - Thank you received: 0 - - 2 years 9 months ago [\#358432](#358432) by [fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile") *[Transfer hikashop addres from Joomla 3 site to Joomla 5 site](/forum/33-customers/907626-transfer-hikashop-addres-from-joomla-3-site-to-joomla-5-site#358432 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 5.0.2 -- PHP version -- : 8.1 -- Browser(s) name and version -- : chrome 120 Hi need to transfer address data from a site with Joomla 3.9.28 + Hikashop 502+PHP 8.1 to a new site Joomla 502+Hikashop 502+PHP 8.1 . There's a diference in table hikashop_address between those two site. On the new site hikashop_address has a field address_type that doesn't appear on the Joomla 3 site . They have the same hikashop version. How do I know from the hikashop_address table on Joomla 3 site which address are billing and which are shipping address? Thanks")* was created by *[fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile")* -- HikaShop version -- : 5.0.2 -- Joomla version -- : 5.0.2 -- PHP version -- : 8.1 -- Browser(s) name and version -- : chrome 120 Hi need to transfer address data from a site with Joomla 3.9.28 + Hikashop 502+PHP 8.1 to a new site Joomla 502+Hikashop 502+PHP 8.1 . There's a diference in table hikashop_address between those two site. On the new site hikashop_address has a field address_type that doesn't appear on the Joomla 3 site . They have the same hikashop version. How do I know from the hikashop_address table on Joomla 3 site which address are billing and which are shipping address? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDc2MjYtdHJhbnNmZXItaGlrYXNob3AtYWRkcmVzLWZyb20tam9vbWxhLTMtc2l0ZS10by1qb29tbGEtNS1zaXRlP3RtcGw9bWFya2Rvd24=) 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: 14267 - - 2 years 9 months ago [\#358433](#358433) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Transfer hikashop addres from Joomla 3 site to Joomla 5 site](/forum/33-customers/907626-transfer-hikashop-addres-from-joomla-3-site-to-joomla-5-site#358433 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 5.0.2 -- PHP version -- : 8.1 -- Browser(s) name and version -- : chrome 120 Hi need to transfer address data from a site with Joomla 3.9.28 + Hikashop 502+PHP 8.1 to a new site Joomla 502+Hikashop 502+PHP 8.1 . There's a diference in table hikashop_address between those two site. On the new site hikashop_address has a field address_type that doesn't appear on the Joomla 3 site . They have the same hikashop version. How do I know from the hikashop_address table on Joomla 3 site which address are billing and which are shipping address? Thanks")* Hi, Are you sure you're using HikaShop 5.0.2 on your Joomla 3 website ? Because the address_type field should be there if you have the 5.0.2. Otherwise, you would get many errors as this field is now mandatory. Before adding address_type, an address could be both a billing and a shipping address. Each address has an address_id. And the order_billing_address_id and order_shipping_address_id columns of the hikashop_order point at the address_id of the selected address. So in an order, you know if an address is for the billing or the shipping based on these two columns. The address_type is used for the selecting the addresses during the checkout. Before, an address would appear both as a billing and as a shipping address candidate. So when you created a new address, it would automatically appear as both a billing and a shipping address. With recent versions of HikaShop, you create either a billing address or a shipping address, and it appears only on the corresponding selector during the checkout. So you can now have different addresses for billing and for shipping linked to your user account. Now, when you migrate the data, you don't have to be too mindful about all this. If the address_type is empty, HikaShop will display the address as both a billing address and a shipping address. And if the customer changes the address on the billing address selector, then HikaShop will automatically split it into two addresses, a shipping and a billing address. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDc2MjYtdHJhbnNmZXItaGlrYXNob3AtYWRkcmVzLWZyb20tam9vbWxhLTMtc2l0ZS10by1qb29tbGEtNS1zaXRlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile")** - [![fgonc124's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39153-fgonc124 "View fgonc124's Profile") Topic Author - [ Offline](/forum/user/39153-fgonc124) Less More - Posts: 19 - Thank you received: 0 - - 2 years 9 months ago [\#358442](#358442) by [fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile") Replied by *[fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile")* on topic *[Transfer hikashop addres from Joomla 3 site to Joomla 5 site](/forum/33-customers/907626-transfer-hikashop-addres-from-joomla-3-site-to-joomla-5-site#358442 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 5.0.2 -- PHP version -- : 8.1 -- Browser(s) name and version -- : chrome 120 Hi need to transfer address data from a site with Joomla 3.9.28 + Hikashop 502+PHP 8.1 to a new site Joomla 502+Hikashop 502+PHP 8.1 . There's a diference in table hikashop_address between those two site. On the new site hikashop_address has a field address_type that doesn't appear on the Joomla 3 site . They have the same hikashop version. How do I know from the hikashop_address table on Joomla 3 site which address are billing and which are shipping address? Thanks")* Hi This is what I see in Joomla 3 site [ ![Hikashop_address.JPG](/forum/attachment/58639) ](/forum/attachment/58639 "...op_address.JPG") [ ![Hikashop_address.JPG](/forum/attachment/58639) ](/forum/attachment/58639 "...op_address.JPG") - [ ![Hikashop_address.JPG](/forum/attachment/58639) ](/forum/attachment/58639 "...op_address.JPG") [ ](/forum/attachment/58639?download=1 "...op_address.JPG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDc2MjYtdHJhbnNmZXItaGlrYXNob3AtYWRkcmVzLWZyb20tam9vbWxhLTMtc2l0ZS10by1qb29tbGEtNS1zaXRlP3RtcGw9bWFya2Rvd24=) 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: 14267 - - 2 years 9 months ago [\#358444](#358444) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Transfer hikashop addres from Joomla 3 site to Joomla 5 site](/forum/33-customers/907626-transfer-hikashop-addres-from-joomla-3-site-to-joomla-5-site#358444 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 5.0.2 -- PHP version -- : 8.1 -- Browser(s) name and version -- : chrome 120 Hi need to transfer address data from a site with Joomla 3.9.28 + Hikashop 502+PHP 8.1 to a new site Joomla 502+Hikashop 502+PHP 8.1 . There's a diference in table hikashop_address between those two site. On the new site hikashop_address has a field address_type that doesn't appear on the Joomla 3 site . They have the same hikashop version. How do I know from the hikashop_address table on Joomla 3 site which address are billing and which are shipping address? Thanks")* Hi, So, are you sure you're using HikaShop 5.0.2 on that website ? Could you check the version number displayed on the main tab of the HikaShop configuration page ? If that's the case, please click on the "check database" button. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDc2MjYtdHJhbnNmZXItaGlrYXNob3AtYWRkcmVzLWZyb20tam9vbWxhLTMtc2l0ZS10by1qb29tbGEtNS1zaXRlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile")** - [![fgonc124's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39153-fgonc124 "View fgonc124's Profile") Topic Author - [ Offline](/forum/user/39153-fgonc124) Less More - Posts: 19 - Thank you received: 0 - - 2 years 9 months ago [\#358525](#358525) by [fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile") Replied by *[fgonc124](/forum/user/39153-fgonc124 "View fgonc124's Profile")* on topic *[Transfer hikashop addres from Joomla 3 site to Joomla 5 site](/forum/33-customers/907626-transfer-hikashop-addres-from-joomla-3-site-to-joomla-5-site#358525 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 5.0.2 -- PHP version -- : 8.1 -- Browser(s) name and version -- : chrome 120 Hi need to transfer address data from a site with Joomla 3.9.28 + Hikashop 502+PHP 8.1 to a new site Joomla 502+Hikashop 502+PHP 8.1 . There's a diference in table hikashop_address between those two site. On the new site hikashop_address has a field address_type that doesn't appear on the Joomla 3 site . They have the same hikashop version. How do I know from the hikashop_address table on Joomla 3 site which address are billing and which are shipping address? Thanks")* Hi What should I do to transfer hikashop from one site to another? Should I export first and then import? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDc2MjYtdHJhbnNmZXItaGlrYXNob3AtYWRkcmVzLWZyb20tam9vbWxhLTMtc2l0ZS10by1qb29tbGEtNS1zaXRlP3RtcGw9bWFya2Rvd24=) 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: 14267 - - 2 years 9 months ago [\#358526](#358526) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Transfer hikashop addres from Joomla 3 site to Joomla 5 site](/forum/33-customers/907626-transfer-hikashop-addres-from-joomla-3-site-to-joomla-5-site#358526 "-- HikaShop version -- : 5.0.2 -- Joomla version -- : 5.0.2 -- PHP version -- : 8.1 -- Browser(s) name and version -- : chrome 120 Hi need to transfer address data from a site with Joomla 3.9.28 + Hikashop 502+PHP 8.1 to a new site Joomla 502+Hikashop 502+PHP 8.1 . There's a diference in table hikashop_address between those two site. On the new site hikashop_address has a field address_type that doesn't appear on the Joomla 3 site . They have the same hikashop version. How do I know from the hikashop_address table on Joomla 3 site which address are billing and which are shipping address? Thanks")* Hi, If you want to transfer a HikaShop from one Joomla to another, I would recommend doing it through PHPMyAdmin and FTP: [ www.hikashop.com/forum/import-export-csv...a/343486.html#343525](https://www.hikashop.com/forum/import-export-csv-xls/904777-migrate-all-store-data/343486.html#343525) That will be a lot more complete than just export/import of the products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy85MDc2MjYtdHJhbnNmZXItaGlrYXNob3AtYWRkcmVzLWZyb20tam9vbWxhLTMtc2l0ZS10by1qb29tbGEtNS1zaXRlP3RtcGw9bWFya2Rvd24=) 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.208 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)