- Posts: 298
- Thank you received: 7
Duplicating a store, or categories to a new store
2 years 10 months ago #358029
by a2zcs
Duplicating a store, or categories to a new store was created by a2zcs
-- url of the page with the problem -- :
mainepromos.com
I've a client that needs to have a full category and all the items and variants in that category migrated over to a new separate site/hikashop install. What is the best way to accomplish this? Is there a product export, import function I've missed?
I've a client that needs to have a full category and all the items and variants in that category migrated over to a new separate site/hikashop install. What is the best way to accomplish this? Is there a product export, import function I've missed?
Please Log in or Create an account to join the conversation.
2 years 10 months ago #358033
by nicolas
Replied by nicolas on topic Duplicating a store, or categories to a new store
Hi,
Well, there is a products export / import functions.
On the products listing in your backend, you have the "export" button to get a CSV of the data of your products.
And in the menu Products>Import you can import CSV files with the data of the products.
However, these have some limitations.
For example, if you have created custom product fields on your website, you'll have to create them first on your new website so that the data of the products can be imported in them.
Same for characteristics, you need to created them and their values first in the new website.
Also, the CSV file doesn't contain the images and files of the products. You'll have to manually copy them from the images/com_hikashop/upload/ and media/com_hikashop/upload/safe folders (or other folders if you changed the path in the HikaShop configuration's Files section) via FTP.
Also, the import can create the categories for you, but the export/import don't support all the categories data, only the basics.
A more complete solution would be to export / import the tables hikashop_product, hikashop_price, hikashop_related, hikashop_product_category, hikashop_category, hikashop_variant and hikashop_characteristic from your old PHPMyAdmin to your new PHPMyAdmin. You would still have to move the images and files via FTP, though, but it can be an easier method (for example, if you have hundreds of characteristics, this method is better since you don't have to manually create the characteristics and their values via the interface). Now, using this method, you need to be careful if the table prefix is not the same between both joomla websites as you'll have to modify it.
Well, there is a products export / import functions.
On the products listing in your backend, you have the "export" button to get a CSV of the data of your products.
And in the menu Products>Import you can import CSV files with the data of the products.
However, these have some limitations.
For example, if you have created custom product fields on your website, you'll have to create them first on your new website so that the data of the products can be imported in them.
Same for characteristics, you need to created them and their values first in the new website.
Also, the CSV file doesn't contain the images and files of the products. You'll have to manually copy them from the images/com_hikashop/upload/ and media/com_hikashop/upload/safe folders (or other folders if you changed the path in the HikaShop configuration's Files section) via FTP.
Also, the import can create the categories for you, but the export/import don't support all the categories data, only the basics.
A more complete solution would be to export / import the tables hikashop_product, hikashop_price, hikashop_related, hikashop_product_category, hikashop_category, hikashop_variant and hikashop_characteristic from your old PHPMyAdmin to your new PHPMyAdmin. You would still have to move the images and files via FTP, though, but it can be an easier method (for example, if you have hundreds of characteristics, this method is better since you don't have to manually create the characteristics and their values via the interface). Now, using this method, you need to be careful if the table prefix is not the same between both joomla websites as you'll have to modify it.
Please Log in or Create an account to join the conversation.
Time to create page: 0.043 seconds