Problems with characteristics when importing CSV

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #22158

I am having problems with my characteristics setting when importing CSV-files, files that I imported at the beginning of my project works with the size characteristic but other files (made the same way) the heading disapears in the product view and the size doesn't change when I change it in the drop down.

I also just noticed that the heading has disapered on the files that worked before after I upgraded to a newer version. I used to have the headline in fron of the ID and size behind but now I only have size in front of and behind the ID

Size option works: www.fashionyouknow.com/klaeder/product/s...category_pathway-356

Size option not working: www.fashionyouknow.com/abercrombie-fitch...e-fitch-hoodies-herr

I also get this message on some products: The default value of one of the characteristics of that product isn't available as a variant. Please check the characteristics and variants of that product

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #22170

The title on the product page isn't updating because there is a problem with the way you imported your products/variants.
It's hard to say more without having a look at the CSV but there must be an error in it. Also, note that if you have several characteristics with the same values, it can sometimes cause a conflict during the import. If so, you should make sure that each value is unique and try again after updating the CSV.

For the last message, it's also because of the CSV. It means that in the CSV, your product has values of characteristics which do not match with a variant of that product in the CSV.

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

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #22230

This is an example of the file that worked before the update of hikashop to newer version:

product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id
Armani kalsonger;Armani Underkläder Herr;334549;;1;Armani Underkläder Herr;Armani Underkläder Herr;85;;334549.jpg;2,16,15,355,356,31,363;150
;;334549 M;334549;;;;;m;;;
;;334549 L;334549;;;;;l;;;
;;334549 XL;334549;;;;;xl;;;
;;334549 XXL;334549;;;;;xxl;;;
;;334549 XXXL;334549;;;;;xxxl;;;

And here is an example of one that never worked properly with characteristics

product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id
Lacoste Piké Dam;Fin Pikétröja Dam;339078;;1;Lacoste Pikétröja Dam;Lacoste Pikétröja Dam;125;;339078.jpg;2,15,16,49,513,656,765;150
;;339078 xs;339078;;;;;XS ;;;150
;;339078 s;339078;;;;;S;;;150
;;339078 m;339078;;;;;M;;;150
;;339078 l;339078;;;;;L;;;150
;;339078 xl;339078;;;;;XL;;;150


Products without chracteristics work without any problems

Last edit: 13 years 3 months ago by Andreas_Sweden.

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #22233

Could you do a screenshot of the characteristic storlek edition screen ?
I see that you use both upper and lower case or the characteristics values... It might come from that...

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

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #22236

I have tried to change the upper and lower case but not had any success, it still remain the same.
And the thing is that the first example used to work until I upgraded, after the upgrade I lost the headline for the product and just got the ID and size (but the size characteristivs still works)

Attachments:

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #22241

I think I understand. You didn't specify the default value for the characteristic in the main product data of your CSV.
It should be:
Armani kalsonger;Armani Underkläder Herr;334549;;1;Armani Underkläder Herr;Armani Underkläder Herr;85;M;334549.jpg;2,16,15,355,356,31,363;150

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

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #22247

Thanks, I will give it a try amd get back with the result

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

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #22295

That worked the sizes are now working on the ones I tested it on, however I am still missing the headlines and just get the Product Code and size in the headline supposed to be headline, product ID and size, the headlines went away after upgrading could it be related to this: www.hikashop.com/en/support/forum/4-how-...customer-can-se.html if there has been changes made in the code to the new version?

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #22322

Did you edit the show file of the view product before updating maybe ?
We had changed the way the name is displayed so if you had edited the view before updating, such problem could be happening.

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

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #23156

All problems solved with characteristics s, m, l etc but I am still having trouble with sizes on shoes where it is numeric, I get the drop down menu but the size doesen't change in the order or the headline.

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #23179

Could you give a link to the product page where the size doesn't change ?

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

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #23422

Sorry for the delay, here is one example www.fashionyouknow.com/barnklaeder2/prod...category_pathway-895

I also get: The default value of one of the characteristics of that product isn't available as a variant. Please check the characteristics and variants of that product

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #23436

Could you try the modification explained on that post: www.hikashop.com/en/support/forum/3-bug-...cs-issues.html#23222

That might solve the problem.

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

  • Posts: 51
  • Thank you received: 0
13 years 3 months ago #23484

nicolas wrote:

Could you try the modification explained on that post: www.hikashop.com/en/support/forum/3-bug-...cs-issues.html#23222

That might solve the problem.


It didn't help :(

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
13 years 3 months ago #23546

The problem on this product www.fashionyouknow.com/barnklaeder2/prod...category_pathway-895 is that the default value of the characteristic in your CSV is not available as a variant. So HikaShop cannot pick it up to generate the dropdown properly. That's why the refresh is not working and that's why you have the error message

The default value of one of the characteristics of that product isn't available as a variant. Please check the characteristics and variants of that product

So the problem comes from the CSV.

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

Time to create page: 0.081 seconds
Powered by Kunena Forum