[Skip to main content](#vessel-content) # Migrate Recent New Users and Their Orders ## - **[ACMLLC](/forum/user/34241-acmllc "View ACMLLC's Profile")** - [![ACMLLC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34241-acmllc "View ACMLLC's Profile") Topic Author - [ Offline](/forum/user/34241-acmllc) Less More - Posts: 21 - Thank you received: 2 - - 7 years 1 month ago [\#310515](#310515) by [ACMLLC](/forum/user/34241-acmllc "View ACMLLC's Profile") *[Migrate Recent New Users and Their Orders](/forum/37-import-export-csv-xls/898216-migrate-recent-new-users-and-their-orders#310515 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Browser(s) name and version -- : Firefox 69.0 Hello, I read a recent post about how to migrate Hikashop in its entirety: www.hikashop.com/forum/import-export-csv...igrate-hikashop.html Our situation is a little different... A couple of month ago, we made a copy of our production site so that we could work on a couple of new products and allow our team to test on this staging site. This testing included the integration of new large components (Easy Profile and Joomdle) that required a lot of config. In the meantime new users were registering and ordering on the old production site. Hikashop config is the same on both sites and were maintained simultaneously except for the new products on the staging site only. We want to migrate only the new users and their orders from production to the staging site and then take it live. I plan to migrate the users with one of the import-export extensions you have recommended here: extensions.joomla.org/category/users-import-a-export/ What do I need to do with Hikashop to get the orders over to the staging site? I will be deleting the test users and their test orders so that all of the id's and order numbers will not clash and be ordered sequentially. Thanks!")* was created by *[ACMLLC](/forum/user/34241-acmllc "View ACMLLC's Profile")* -- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Browser(s) name and version -- : Firefox 69.0 Hello, I read a recent post about how to migrate Hikashop in its entirety: [ www.hikashop.com/forum/import-export-csv...igrate-hikashop.html](https://www.hikashop.com/forum/import-export-csv-xls/897052-migrate-hikashop.html) Our situation is a little different... A couple of month ago, we made a copy of our production site so that we could work on a couple of new products and allow our team to test on this staging site. This testing included the integration of new large components (Easy Profile and Joomdle) that required a lot of config. In the meantime new users were registering and ordering on the old production site. Hikashop config is the same on both sites and were maintained simultaneously except for the new products on the staging site only. We want to migrate only the new users and their orders from production to the staging site and then take it live. I plan to migrate the users with one of the import-export extensions you have recommended here: [ extensions.joomla.org/category/users-import-a-export/](https://extensions.joomla.org/category/users-import-a-export/) What do I need to do with Hikashop to get the orders over to the staging site? I will be deleting the test users and their test orders so that all of the id's and order numbers will not clash and be ordered sequentially. Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTgyMTYtbWlncmF0ZS1yZWNlbnQtbmV3LXVzZXJzLWFuZC10aGVpci1vcmRlcnM/dG1wbD1tYXJrZG93bg==) 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: 14268 - - 7 years 1 month ago [\#310527](#310527) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Migrate Recent New Users and Their Orders](/forum/37-import-export-csv-xls/898216-migrate-recent-new-users-and-their-orders#310527 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Browser(s) name and version -- : Firefox 69.0 Hello, I read a recent post about how to migrate Hikashop in its entirety: www.hikashop.com/forum/import-export-csv...igrate-hikashop.html Our situation is a little different... A couple of month ago, we made a copy of our production site so that we could work on a couple of new products and allow our team to test on this staging site. This testing included the integration of new large components (Easy Profile and Joomdle) that required a lot of config. In the meantime new users were registering and ordering on the old production site. Hikashop config is the same on both sites and were maintained simultaneously except for the new products on the staging site only. We want to migrate only the new users and their orders from production to the staging site and then take it live. I plan to migrate the users with one of the import-export extensions you have recommended here: extensions.joomla.org/category/users-import-a-export/ What do I need to do with Hikashop to get the orders over to the staging site? I will be deleting the test users and their test orders so that all of the id's and order numbers will not clash and be ordered sequentially. Thanks!")* Hi, What I would recommend is to delete the tables hikashop_order, hikashop_history, hikashop_order_product, hikashop_address and hikashop_user in your staging website database. Then, export the data and structure of these tables from your old website's database. Then, import it in your new website database. Then, I think you'll want to click on the "check database" button of the HikaShop configuration to synchronize the new users imported from your old website to the user entries in HikaShop (as they might have a different id). Ideally, the user import/export tool you use would keep the same ids for your users in Joomla and in that case, this would not be necessary. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTgyMTYtbWlncmF0ZS1yZWNlbnQtbmV3LXVzZXJzLWFuZC10aGVpci1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 7 years 1 month ago [\#310535](#310535) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Migrate Recent New Users and Their Orders](/forum/37-import-export-csv-xls/898216-migrate-recent-new-users-and-their-orders#310535 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Browser(s) name and version -- : Firefox 69.0 Hello, I read a recent post about how to migrate Hikashop in its entirety: www.hikashop.com/forum/import-export-csv...igrate-hikashop.html Our situation is a little different... A couple of month ago, we made a copy of our production site so that we could work on a couple of new products and allow our team to test on this staging site. This testing included the integration of new large components (Easy Profile and Joomdle) that required a lot of config. In the meantime new users were registering and ordering on the old production site. Hikashop config is the same on both sites and were maintained simultaneously except for the new products on the staging site only. We want to migrate only the new users and their orders from production to the staging site and then take it live. I plan to migrate the users with one of the import-export extensions you have recommended here: extensions.joomla.org/category/users-import-a-export/ What do I need to do with Hikashop to get the orders over to the staging site? I will be deleting the test users and their test orders so that all of the id's and order numbers will not clash and be ordered sequentially. Thanks!")* Good Morning Nocolas, It is somehow possible import data by CSV to a custom field, added to the order table, using the order number as a load reference? Receive a warm greeting Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTgyMTYtbWlncmF0ZS1yZWNlbnQtbmV3LXVzZXJzLWFuZC10aGVpci1vcmRlcnM/dG1wbD1tYXJrZG93bg==) 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: 14268 - - 7 years 1 month ago [\#310536](#310536) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Migrate Recent New Users and Their Orders](/forum/37-import-export-csv-xls/898216-migrate-recent-new-users-and-their-orders#310536 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Browser(s) name and version -- : Firefox 69.0 Hello, I read a recent post about how to migrate Hikashop in its entirety: www.hikashop.com/forum/import-export-csv...igrate-hikashop.html Our situation is a little different... A couple of month ago, we made a copy of our production site so that we could work on a couple of new products and allow our team to test on this staging site. This testing included the integration of new large components (Easy Profile and Joomdle) that required a lot of config. In the meantime new users were registering and ordering on the old production site. Hikashop config is the same on both sites and were maintained simultaneously except for the new products on the staging site only. We want to migrate only the new users and their orders from production to the staging site and then take it live. I plan to migrate the users with one of the import-export extensions you have recommended here: extensions.joomla.org/category/users-import-a-export/ What do I need to do with Hikashop to get the orders over to the staging site? I will be deleting the test users and their test orders so that all of the id's and order numbers will not clash and be ordered sequentially. Thanks!")* Hi, There is no import system for orders in HikaShop. Now, I know that CSVimproved has a feature to import order data to HikaShop: [ csvimproved.com/support/import/227-hikas...ikashop-order-import](https://csvimproved.com/support/import/227-hikashop/2948-hikashop-order-import) But I don't know if it can also update the data based on the order number. You'll have to check with them. The following user(s) said Thank You: [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTgyMTYtbWlncmF0ZS1yZWNlbnQtbmV3LXVzZXJzLWFuZC10aGVpci1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ACMLLC](/forum/user/34241-acmllc "View ACMLLC's Profile")** - [![ACMLLC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34241-acmllc "View ACMLLC's Profile") Topic Author - [ Offline](/forum/user/34241-acmllc) Less More - Posts: 21 - Thank you received: 2 - - 7 years 1 month ago [\#310561](#310561) by [ACMLLC](/forum/user/34241-acmllc "View ACMLLC's Profile") Replied by *[ACMLLC](/forum/user/34241-acmllc "View ACMLLC's Profile")* on topic *[Migrate Recent New Users and Their Orders](/forum/37-import-export-csv-xls/898216-migrate-recent-new-users-and-their-orders#310561 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.1.31 -- Browser(s) name and version -- : Firefox 69.0 Hello, I read a recent post about how to migrate Hikashop in its entirety: www.hikashop.com/forum/import-export-csv...igrate-hikashop.html Our situation is a little different... A couple of month ago, we made a copy of our production site so that we could work on a couple of new products and allow our team to test on this staging site. This testing included the integration of new large components (Easy Profile and Joomdle) that required a lot of config. In the meantime new users were registering and ordering on the old production site. Hikashop config is the same on both sites and were maintained simultaneously except for the new products on the staging site only. We want to migrate only the new users and their orders from production to the staging site and then take it live. I plan to migrate the users with one of the import-export extensions you have recommended here: extensions.joomla.org/category/users-import-a-export/ What do I need to do with Hikashop to get the orders over to the staging site? I will be deleting the test users and their test orders so that all of the id's and order numbers will not clash and be ordered sequentially. Thanks!")* Thanks, Nicolas. Your recommended approach worked very well indeed. For the user export-import I used the Ukr Solutions extensions and they kept the same Id's. The order numbers were correct and any additional data collected using custom fields was also preserved. Splendid! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTgyMTYtbWlncmF0ZS1yZWNlbnQtbmV3LXVzZXJzLWFuZC10aGVpci1vcmRlcnM/dG1wbD1tYXJrZG93bg==) 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.166 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)