- Posts: 23
- Thank you received: 3
Import user's orders history
3 years 9 months ago #347210
by Pierrick
Import user's orders history was created by Pierrick
-- 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 !!
-- 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.
3 years 9 months ago #347215
by nicolas
Replied by nicolas on topic Import user's orders history
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/
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.
3 years 9 months ago #347229
by Pierrick
Replied by Pierrick on topic Import user's orders history
Or use phpMyAdmin ?
Please Log in or Create an account to join the conversation.
3 years 9 months ago #347232
by Pierrick
Replied by Pierrick on topic Import user's orders history
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 ?
If I understand correctly those records are contained in hikashop_order table ?
Please Log in or Create an account to join the conversation.
3 years 9 months ago #347239
by nicolas
Replied by nicolas on topic Import user's orders history
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.
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.
3 years 9 months ago #347242
by Pierrick
Replied by Pierrick on topic Import user's orders history
Thank you for these useful info
Please Log in or Create an account to join the conversation.
Time to create page: 0.254 seconds