Import/Export products with variants

  • Posts: 45
  • Thank you received: 1
8 years 9 months ago #229126

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 2.5.28
-- PHP version -- : n/a
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : n/a

Hi,

I wanted to simply duplicate an entire Hikashop to a 2nd website. So I thought I could just use the import/export feature but it doesn't seem to be able to import the variants at all. The products and categories worked fine but not the variants. Did I need to make changes to something before I can import the variants? Do I need to do something on the new site so it can accept the variants or something like that?

Thanks,
Michael.

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 9 months ago #229151

Hi,

You need to create first the characteristics and their values on your new website. Then the import should take into account the variants.

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

  • Posts: 45
  • Thank you received: 1
8 years 9 months ago #229181

Is that the only way? Surely for something as commonly used as variants Hikashop has a way to move them from one site to another without manual input???

I'm planning on upgrading these sites soon to 3.4 soon, so I'm going to have to setup all the variants again before I migrate them? This is a pretty big let down if that's the case.

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

  • Posts: 45
  • Thank you received: 1
8 years 9 months ago #229186

Furthermore; I did as you said and then get blank variants after import for some reason? I did a copy paste from the original site so they should be exactly the same names for the variants.

Am I doing something wrong?

Also, how do I remove the images of the variants on the product display?

Thanks again for your help.

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 9 months ago #229197

Hi,

1. You don't need to recreate the variants. Only the characteristics. Normally, you have for example one color characteristic with 20 values, and you apply it to all the products with different colors.
So just recreating the characteristics and their values should be quite rapid.
And if you don't want to recreate them, you can just export the hikashop_characteristic table from your old website database and import it in the new database with PHPMyAdmin. It should only take a minute.

2. If you get blank variants, it's probably that the value of the characteristic column of the variant in the CSV doesn't exactly match with the value of the characteristic in the database.

3. You can add such CSS on your website:
.hikashop_product_image_row, .hikashop_product_image { display:none; }
www.hikashop.com/support/documentation/1...ize-the-display.html

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

  • Posts: 45
  • Thank you received: 1
8 years 9 months ago #229333

1 & 2: Ok so I deleted all the variants from the new website and only left the characteristic but not variants/values. As a test, I just exported a single product category (iPad) and imported it to the new website. It just shows a bunch of errors regarding seeing columns that aren't in the new website and the variants are not created within the characteristic BUT there is now blank variants for each product with the correct value.

I guess this is still to do with point 2 in your last post but they look exactly the same to me? I have not checked the database manually, but I see any reason why it should have made it a different value unless I spelt it differently?

3. Ok thank you.

Thank you again for your help.

Attachments:
Last edit: 8 years 9 months ago by DFX. Reason: spelling

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 9 months ago #229361

Hi,

1&2 As I said in my previous post, you don't need to create the variants in the new website, however I also said:

So just recreating the characteristics and their values should be quite rapid.

So values have to be pre created as HikaShop won't create them automatically during the import.
Why not export the hikashop_characteristic table from your old website database and import it in the new database ? It should only take a minute and the problem would be solved.

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

  • Posts: 45
  • Thank you received: 1
8 years 9 months ago #230128

Yes, no doubt copying the tables would have been easier but I don't have access to PHPMyAdmin on the original site at the moment and I didn't think this was going to be such a big problem.

Ok, I had already tried importing with the characteristics AND values created but that didn't work correctly. So that's why I then tried the import without the values pre-made and yes as you said in your response, that didn't work either. So I just tried again and again I'm back to having some blank variants.

So you said that this must happen because of mismatching values? I have put screen shots of both websites in here for you to see. Can you see a difference? Or is there another problem?

Thank you for your help.

Attachments:

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

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

Hi,

I just tried on my local, I added manually the "iPad" characteristic with its 8 values.
Then imported the product from your csv file, and the variants are correctly created, no blank name.

So there is potentially a setting different on your environment, maybe the database collation or something like that.
If you check the database of the new site, do you see all the content correctly or it is blank too ?

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

Time to create page: 0.085 seconds
Powered by Kunena Forum