- Posts: 107
- Thank you received: 3
Export
2 years 10 months ago #356564
by Uniweb
-- HikaShop version -- : 5.0.0
-- Joomla version -- : 3.10.12.
-- PHP version -- : 8.1
-- Browser(s) name and version -- : Firefox 119.0.1 (64bit)
Hi How do i do a full export of all the products, products information, price and all the phots. What i need to do is export it from joomla 3 to a new site i am going to build on joomla 4 or 5.
Thanks in advance for all your help
-- Joomla version -- : 3.10.12.
-- PHP version -- : 8.1
-- Browser(s) name and version -- : Firefox 119.0.1 (64bit)
Hi How do i do a full export of all the products, products information, price and all the phots. What i need to do is export it from joomla 3 to a new site i am going to build on joomla 4 or 5.
Thanks in advance for all your help
Please Log in or Create an account to join the conversation.
2 years 10 months ago #356578
by nicolas
Hi,
The simplest is to click on the "export" button of the products listing in your backend, import that CSV in the Products>Import menu of your new HikaShop, and then move the images and files of the products from the images/com_hikashop/upload/ and media/com_hikashop/upload/safe/ folders to the same folders on your new website via FTP.
Now, the export/import processes are quite resources hungry and they are not perfect either. For example, if the id of the user groups change between the two websites and you're using the "access level" setting in your products, the groups won't match anymore on the new website.
An alternative is to export the tables with "hikashop_" in your PHPMyAdmin and import the exported file via the interface of the PHPMyAdmin of the new website. What's great with that is that you can not only get back the products data but also the order history, the customers addresses, your previous configuration of HikaShop, etc.
The simplest is to click on the "export" button of the products listing in your backend, import that CSV in the Products>Import menu of your new HikaShop, and then move the images and files of the products from the images/com_hikashop/upload/ and media/com_hikashop/upload/safe/ folders to the same folders on your new website via FTP.
Now, the export/import processes are quite resources hungry and they are not perfect either. For example, if the id of the user groups change between the two websites and you're using the "access level" setting in your products, the groups won't match anymore on the new website.
An alternative is to export the tables with "hikashop_" in your PHPMyAdmin and import the exported file via the interface of the PHPMyAdmin of the new website. What's great with that is that you can not only get back the products data but also the order history, the customers addresses, your previous configuration of HikaShop, etc.
Please Log in or Create an account to join the conversation.
2 years 8 months ago #358056
by Uniweb
Hi
Thanks for all the help... I will give it ago will this work for Joomla 3 to Joomla 4 - i am building a new site on Joomla 4 -- The site at the moment is on Joomla 3.
J
Thanks for all the help... I will give it ago will this work for Joomla 3 to Joomla 4 - i am building a new site on Joomla 4 -- The site at the moment is on Joomla 3.
J
Please Log in or Create an account to join the conversation.
1 year 7 months ago #365838
by nicolas
Hi,
The characteristics are in the table hikashop_characteristic, the variants are in the table hikashop_product, along with the products, and the links between the variants / products and the characteristics / values are in the table hikashop_variant.
So, if you followed my previous instructions and exported / imported all the hikashop_* tables, it should also include these 3 tables and you shouldn't have lost your characteristics.
So I'm not sure what you did to loose them.
The characteristics are in the table hikashop_characteristic, the variants are in the table hikashop_product, along with the products, and the links between the variants / products and the characteristics / values are in the table hikashop_variant.
So, if you followed my previous instructions and exported / imported all the hikashop_* tables, it should also include these 3 tables and you shouldn't have lost your characteristics.
So I'm not sure what you did to loose them.
Please Log in or Create an account to join the conversation.
Time to create page: 0.211 seconds