export - import users and order

  • Posts: 252
  • Thank you received: 3
9 years 8 months ago #210062

-- url of the page with the problem -- : www.dodowear.nl
-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3

As I have rebuild our website and also hikashop I would like to export all users and orders and import them into the new website.
Is there also a tool for that?
Or can you tell which tables to use?
Thank in advance

Please Log in or Create an account to join the conversation.

  • Posts: 26226
  • Thank you received: 4035
  • MODERATOR
9 years 8 months ago #210065

Hi,

There are already several thread talking about it
www.hikashop.com/forum/import-export-csv...-duplicate-site.html
www.hikashop.com/forum/import-export-csv...nd-import-users.html
www.hikashop.com/forum/import-export-csv...hop-to-new-site.html
www.hikashop.com/forum/import-export-csv...ort-on-new-site.html

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 252
  • Thank you received: 3
9 years 8 months ago #210146

Hi Jerome,
Thank you for your links.
These discussion don't tell which tables includes the Hikashop orders.
Could you tell me that

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
9 years 8 months ago #210148

Hi,

To get all the orders data, you need of course the _hikashop_order table, _hikashop_order_product, _hikashop_history.
Then based on the informations you need, there could be the shipping and payment tables, etc.

Please Log in or Create an account to join the conversation.

  • Posts: 252
  • Thank you received: 3
9 years 8 months ago #210546

Hi Xavier,
Based on the 3 tables you name.
hikashop_order table, _hikashop_order_product, _hikashop_history
What will user get to see when look into there history?

And do I first need to move the joomla users?
And afterwords import these tables?

What is "enough" for me is that they can see there orders and see them on screen or pdf.
Payment and shipping is less interesting

Please Log in or Create an account to join the conversation.

  • Posts: 26226
  • Thank you received: 4035
  • MODERATOR
9 years 8 months ago #210559

Hi,

What will user get to see when look into there history?

I'm sorry, I don't understand the question.

And do I first need to move the joomla users?
And afterwords import these tables?

It depends if your users will have the same id or not, if it's a copy or a migration.
Otherwise, the order is not important, as long as you import all the required data.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 252
  • Thank you received: 3
9 years 8 months ago #210898

Hi,
It's a bit strange. I don't receive a placed reaction of this topic.

Nevertheless,
What I mean with history.
If we use these tables will the user/customer be able to get there Original account details? such as the orders they have done.

Is it so when I do a copy the Original user will they have the same id.
And then when we copy these 3 tables will it match then?

Sorry that I ask so detailed. It is not a routinejob for me

ps I was hoping that there was some sort a import plugin like you have for import from other shops as vm and redshop

Please Log in or Create an account to join the conversation.

  • Posts: 83671
  • Thank you received: 13545
  • MODERATOR
9 years 8 months ago #210916

Hi,

First you need to migrate your Joomla users (there are several extensions to do that that you'll find on the JED).
Once you have the users, you can copy these tables from your old website database:
hikashop_order, hikashop_order_product, hikashop_history, hikashop_address and hikashop_user
hikashop_shipping and hikashop_payment can also be interesting so that the name of the shipping and payment methods are still available in the orders.
Then, install HikaShop and it should link users and orders together automatically. There is no issue with the ids of the Joomla users being the same or not.
It's not complex to do so there is no need for an import script and it works much better than an import script would. And yes, your customers will keep the same access to their user control panel as before with these tables.

Please Log in or Create an account to join the conversation.

  • Posts: 252
  • Thank you received: 3
9 years 8 months ago #210994

thanks for you clear comment.
the only difference is that every thing is already installed and ready to go live.
this is the last part.
the way you describe it now is that the import has been done before installation.
Then it probably better to forget these tables.
hikashop_shipping and hikashop_payment

Please Log in or Create an account to join the conversation.

Time to create page: 0.081 seconds
Powered by Kunena Forum