[Skip to main content](#vessel-content)

#   Duplicating a store, or categories to a new store

##

- **[a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile")**
- [![a2zcs's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33209.jpg)](/forum/user/33209-a2zcs "View a2zcs's Profile") Topic Author
- [ Offline](/forum/user/33209-a2zcs)

Less More

- Posts: 298
- Thank you received: 7
-
-

2 years 10 months ago [\#358029](#358029) by [a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile")  *[Duplicating a store, or categories to a new store](/forum/32-content-creation/907539-duplicating-a-store-or-categories-to-a-new-store#358029 "-- 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?")* was created by *[a2zcs](/forum/user/33209-a2zcs "View a2zcs's Profile")*

-- url of the page with the problem -- : [ mainepromos.com](https://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?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2NvbnRlbnQtY3JlYXRpb24vOTA3NTM5LWR1cGxpY2F0aW5nLWEtc3RvcmUtb3ItY2F0ZWdvcmllcy10by1hLW5ldy1zdG9yZT90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86359
- Thank you received: 14296
-
-

2 years 10 months ago [\#358033](#358033) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Duplicating a store, or categories to a new store](/forum/32-content-creation/907539-duplicating-a-store-or-categories-to-a-new-store#358033 "-- 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?")*

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&gt;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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2NvbnRlbnQtY3JlYXRpb24vOTA3NTM5LWR1cGxpY2F0aW5nLWEtc3RvcmUtb3ItY2F0ZWdvcmllcy10by1hLW5ldy1zdG9yZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.048 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
