Import Users

  • Posts: 33
  • Thank you received: 0
12 years 3 weeks ago #71352

I know this topic has been covered in other threads. But I would like to request that HikaShop consider adding the ability to add Customers and Orders via CSV files. I am trying to import from a shopping cart product that is not running on Joomla. I can import them as users but will then loose all there Address (billing and shipping), passwords, phone numbers and order history.

As this is currently not available, can you provide what tables I will need to modify if I create a SQL script to Create each record to import the content? and how do I link this to the Joomla user tables.

Regards,
Richard

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

  • Posts: 13201
  • Thank you received: 2322
12 years 3 weeks ago #71439

Hi,

The tables needed are #__users which is a Joomla table with the user informations (name, username, email, password...).
#__hikashop_user default informations for HikaShop and link with the joomla user informations
#__hikashop_address for the address of the user (shipping and billing) with phone number...
#__hikashop_order, informations about the orders.
#__hikashop_order_product all the products present in an order.

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

  • Posts: 51
  • Thank you received: 1
11 years 11 months ago #81977

So there is no way provided to bring users in and out of hikashop?

That is disappointing ... Are there any plans to add this or sample SQL queries available?

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

  • Posts: 13201
  • Thank you received: 2322
11 years 11 months ago #82060

The HikaShop users are the Joomla Users, you can maybe find a component or a plugin which allow the importation in Joomla.

We have no examples of SQL queries actually.

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

Time to create page: 0.087 seconds
Powered by Kunena Forum