Import some products from another Hikashop database

  • Posts: 64
  • Thank you received: 6
2 years 6 months ago #345896

-- HikaShop version -- : 4.6.2
-- Joomla version -- : 4.2.3
-- PHP version -- : 8.0.24

Hello everyone,
I have a question about how to import some products from a backup to a live site.
I recently migrated a site from J3 to J4. I made a backup and started the process, but the client published some products only an hour after my backup (obviously).
Fortunately, I uploaded the new version to a new database, so I am able to retrieve the missing products from the old database.

I gave it a try: I exported the product entries from the product table as a csv and imported them onto a stage version. It seems to work, in part, because I can see the products but with some missing information, such as category, prices, images, etc., which are recorded in other tables.
We are talking about 10 to 15 products, so filling in the missing fields is nothing 'heavy'.

The questions are:
1. Is the export-import process I have done correct?
2. What is the best thing to do? Fill in all the missing information using the administration panel or try to export-import the other tables as well?

Thanks!
David

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

  • Posts: 83749
  • Thank you received: 13553
  • MODERATOR
2 years 6 months ago #345911

Hi,

1. Export / Import should work if you're using HikaShop's. The prices, images, categories are listed in the CSV when exporting and the import is taking them into account. So it should normall work fine. Note that for images/files, the files themselves need to be copied via FTP as the data of the images/files itself is not in the CSV, only the path of the files/images.
If you're using PHPMyAdmin's export/import on the hikashop_product table, then it's normal you're missing all that as that data is in other tables: hikashop_file, hikashop_price, hikashop_product_category, etc. So if you want to do a PHPMyAdmin export/import, it's possible, but you need to export/import all the tables related to the product, not just hikashop_product

2. For 10-15 products, I wouldn't bother and just fill in the missing information in the backend interface. That way, you're guaranteed it will work like you want, and you won't have any surprise. And time-wise, it shouldn't change much.

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

  • Posts: 64
  • Thank you received: 6
2 years 6 months ago #346038

Thanks a lot Nicolas.
I'll go with the second option for now.

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

Time to create page: 0.054 seconds
Powered by Kunena Forum