[Skip to main content](#vessel-content) # Importing new users and orders only ## - **[conlippert](/forum/user/10035-conlippert "View conlippert's Profile")** - [![conlippert's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10035-conlippert "View conlippert's Profile") Topic Author - [ Offline](/forum/user/10035-conlippert) Less More - Posts: 43 - Thank you received: 0 - - 11 years 7 months ago [\#196314](#196314) by [conlippert](/forum/user/10035-conlippert "View conlippert's Profile") *[Importing new users and orders only](/forum/37-import-export-csv-xls/875977-importing-new-users-and-orders-only#196314 "-- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL")* was created by *[conlippert](/forum/user/10035-conlippert "View conlippert's Profile")* -- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU5NzctaW1wb3J0aW5nLW5ldy11c2Vycy1hbmQtb3JkZXJzLW9ubHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 7 months ago [\#196358](#196358) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Importing new users and orders only](/forum/37-import-export-csv-xls/875977-importing-new-users-and-orders-only#196358 "-- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL")* Hi, You should be able to launch the import process from virtuemart again to import the missing data. If you export/import from the database, you will have the orders and Joomla users but the users will not be created in HikaShp and so no association with the orders. So it really require some PHP to import the content correctly. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU5NzctaW1wb3J0aW5nLW5ldy11c2Vycy1hbmQtb3JkZXJzLW9ubHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[conlippert](/forum/user/10035-conlippert "View conlippert's Profile")** - [![conlippert's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10035-conlippert "View conlippert's Profile") Topic Author - [ Offline](/forum/user/10035-conlippert) Less More - Posts: 43 - Thank you received: 0 - - 11 years 7 months ago [\#196508](#196508) by [conlippert](/forum/user/10035-conlippert "View conlippert's Profile") Replied by *[conlippert](/forum/user/10035-conlippert "View conlippert's Profile")* on topic *[Importing new users and orders only](/forum/37-import-export-csv-xls/875977-importing-new-users-and-orders-only#196508 "-- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL")* I reran the import and 2 of the orders came in but there are 4 orders that are not posting into hikashop. Can you suggest anything to help? These are new orders since I first imported. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU5NzctaW1wb3J0aW5nLW5ldy11c2Vycy1hbmQtb3JkZXJzLW9ubHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[conlippert](/forum/user/10035-conlippert "View conlippert's Profile")** - [![conlippert's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10035-conlippert "View conlippert's Profile") Topic Author - [ Offline](/forum/user/10035-conlippert) Less More - Posts: 43 - Thank you received: 0 - - 11 years 7 months ago - 11 years 7 months ago [\#196524](#196524) by [conlippert](/forum/user/10035-conlippert "View conlippert's Profile") Replied by *[conlippert](/forum/user/10035-conlippert "View conlippert's Profile")* on topic *[Importing new users and orders only](/forum/37-import-export-csv-xls/875977-importing-new-users-and-orders-only#196524 "-- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL")* FYI- I had to import the new users into the joomla users table then reran the vm import and the orders were found so I;m ok now. thanks. Last edit: 11 years 7 months ago by [conlippert](/forum/user/10035-conlippert "View conlippert's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU5NzctaW1wb3J0aW5nLW5ldy11c2Vycy1hbmQtb3JkZXJzLW9ubHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cthixton](/forum/user/27225-cthixton "View cthixton's Profile")** - [![cthixton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27225-cthixton "View cthixton's Profile") - [ Offline](/forum/user/27225-cthixton) Less More - Posts: 4 - Thank you received: 0 - - 11 years 5 months ago [\#202892](#202892) by [cthixton](/forum/user/27225-cthixton "View cthixton's Profile") Replied by *[cthixton](/forum/user/27225-cthixton "View cthixton's Profile")* on topic *[Importing new users and orders only](/forum/37-import-export-csv-xls/875977-importing-new-users-and-orders-only#202892 "-- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL")* Having the same issues here; upgrading from j2.5 to j3.4 and 2yo HikaShop, but need to be able to re-sync the users and orders from the production site before we go live and found there is at least one column difference in the _hikashop_order table (order_site_id). Hoping someone at HikaShop understands the migration issues for production environments and planned for cases like this were there is a lag during development and the production data needs to be imported into the new site as it goes live. Thanks, Cal Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU5NzctaW1wb3J0aW5nLW5ldy11c2Vycy1hbmQtb3JkZXJzLW9ubHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 5 months ago [\#202910](#202910) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Importing new users and orders only](/forum/37-import-export-csv-xls/875977-importing-new-users-and-orders-only#202910 "-- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL")* Hi, A simple re-installation of the latest HikaShop version will create the missing tables. Then you will be able to import the missing data. If the production site has missing tables and the tables are present in the dev environment it is not a problem, you can import the latest data, the missing columns will take the default value. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU5NzctaW1wb3J0aW5nLW5ldy11c2Vycy1hbmQtb3JkZXJzLW9ubHk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cthixton](/forum/user/27225-cthixton "View cthixton's Profile")** - [![cthixton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27225-cthixton "View cthixton's Profile") - [ Offline](/forum/user/27225-cthixton) Less More - Posts: 4 - Thank you received: 0 - - 11 years 5 months ago [\#202980](#202980) by [cthixton](/forum/user/27225-cthixton "View cthixton's Profile") Replied by *[cthixton](/forum/user/27225-cthixton "View cthixton's Profile")* on topic *[Importing new users and orders only](/forum/37-import-export-csv-xls/875977-importing-new-users-and-orders-only#202980 "-- HikaShop version -- : latest -- Joomla version -- : latest -- Error-message(debug-mod must be tuned on) -- : none Hi, Need a little guidance for this. I've been working on a new site for my client and last month I setup Joomla 3 and Hikashop buisness. At that time, I moved over all our products and past orders, and users from the VM2 on the old site. Now the new site is ready, but while I was developing, we had some new orders and users on the old site so I need to move just those orders and users to the new site before I make the new site live. What would be the best way to do this? I'm confortable with going to the database. Thanks, CL")* This worked like a charm: > On May 26, 2015, at 10:51 AM, HikaShop Support <contact@hikashop.com> wrote: > > Hi, > You can delete the tables of the new version and put the old ones. Then, click on the "check database" button of the HikaShop configuration page and it will add the missing columns/tables automatically. > > Best regards, > Nicolas Thanks, Cal Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzU5NzctaW1wb3J0aW5nLW5ldy11c2Vycy1hbmQtb3JkZXJzLW9ubHk/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.058 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)