Import user's orders history

  • Posts: 23
  • Thank you received: 3
  • Hikashop Business
1 year 4 months ago #347210

-- HikaShop version -- : 4.7.0
-- Joomla version -- : 4.2.5
-- PHP version -- : 8.1

I have been importing products from a csv file with no problems. It's working great !!
However, what I'd like to do now is import users order history from a csv file
I can easily export Hikashop orders records as a csv file which enables me to use its pattern to create an import csv file, but I see no option for importing back orders in Hikashop ? Am I missing something ?
If not, what would be your suggestion to accomplish this ?
Thanks !!

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

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
1 year 4 months ago #347215

Hi,


There is indeed no option for that in HikaShop.
I would recommend looking at RO CSVI to see if it can do that:
rolandd.com/

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

  • Posts: 23
  • Thank you received: 3
  • Hikashop Business
1 year 4 months ago #347229

Or use phpMyAdmin ?

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

  • Posts: 23
  • Thank you received: 3
  • Hikashop Business
1 year 4 months ago #347232

The main things I'd like to accomplish is for the users to still have access to the digital products they already downloaded before, once I migrate to Hikashop.
If I understand correctly those records are contained in hikashop_order table ?

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

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
1 year 4 months ago #347239

Hi,

You could indeed directly add the data in PHPMyAdmin.
The hikashop_order table contains the orders main data.
Then, you have the hikashop_order_product table linking the products and the orders together.
And then, you have the hikashop_address table, where the addresses of each order as stored.
You'll want to fill all these tables for an order to be complete.

The following user(s) said Thank You: Pierrick

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

  • Posts: 23
  • Thank you received: 3
  • Hikashop Business
1 year 4 months ago #347242

Thank you for these useful info

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

Time to create page: 0.067 seconds
Powered by Kunena Forum