Variants not importing

  • Posts: 96
  • Thank you received: 0
11 years 3 months ago #119743

-- HikaShop version -- : 2.2.0
-- Joomla version -- : 3.1.5

When I try to import my test file with 5 items (1 base + 4 variants), I get the message that 5 products have been created. However, only the base item gets created.

When I look at the products list in the HikaShop backend with the filter set to show variants, they do not show up. When I look at the product on the front end, only the base item appears. When I edit the base item, no variants exist.

I've attached the CSV file I'm using and as far as I can tell it should work fine.

Attachments:

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

  • Posts: 846
  • Thank you received: 92
11 years 3 months ago #119762

i think after test that HKS have not implemented the way to import characteristic ( independant) and attach variants to specific product .

when you create manually the characteristic ( size 15 mL, 5 mL,100 ml, 15 mL //dilution : pure 10%) and attach manually characteristic to product ( with the same name ImortelleTEST) . Then the variant ll be import !!!

Attachments:
Last edit: 11 years 3 months ago by lionel75.

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

  • Posts: 846
  • Thank you received: 92
11 years 3 months ago #119764

strange the docmentation say it can be achieve !! www.hikashop.com/support/20-documentatio...hikashop-import.html

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 3 months ago #119781

The documentation says that you can import products and variants (which need characteristics). But you first have to manually pre-create the characteristics first via the menu Products>Characteristics.

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

  • Posts: 846
  • Thank you received: 92
11 years 3 months ago #119944

Hi


A) I really need to """ attach manually characteristic to product""" for resolve the problem .

B) Create all characteristic by hand is not efficient , In the case i export HKS products using HKS export t to file ,
Does the import of this file will not work on a new fresh hks installation for variants ?!!! to resume even in this context do i need to pre create the characteristic !!!!


C) it is strange to see a lot of post for import problem in this forum
1 does people don't read the documentation ?
2 does the documentation miss some informations ?
3 the default documentation example don't work ? ( see attach file and doc )

D) why so many "debug " informations ( false ? ) when import file ?
The column "xxxxx" is twice in your CSV. Only the second column data will be taken into account.

E) is there a way to import export the characteristic using a file instead do it using the backend manually ( write all with keyboard ) ?


F) is it a shame that many post realtive to import export don't upload a minimal zip file ( many csv files ) to be able to test !!!


G) the documentation say use excel and then export csv and use notepad !!! why not edit data in excel if the user have excel !!!
I really not understand why but really want to learn something i don't know ( really ....) .

regard's

Last edit: 11 years 3 months ago by lionel75.

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

  • Posts: 96
  • Thank you received: 0
11 years 3 months ago #119947

Ni Nicolas,

Have you had a chance to look at my original post that started this topic? I believe I have structured the file as specified in the documentation...the test import file is attached to the original message in this post.

(For the record, the characteristics I am trying to import have already been created)

Thanks,

Scott

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 3 months ago #119981

@lionel75
A. HikaShop cannot create the characteristics itself from the CSV as it doesn't know if your field is a characteristic or a custom product field. So it displays an error.
So yes, you need to pre create the characteristics, as I already said in my previous message.

C. The examples works and the documentation includes the necessary information. For example, if you look at the example for the variants import, you will see that the main product has the default values in there and the text of the documentation tells you that you need to fill them if you want the import to work.
The thing is that CSV import is already something quite advanced and just a small mistake in the CSV and the import won't understand it and will display an error.

D. That specific error message bug, was introduced recently and will be fixed in next version of HikaShop. It can just be ignored as it displays even when it shouldn't display.

E. Sure. We already posted on that on this and one of the users did a really nice post explaining the procedure here:
www.hikashop.com/forum/2-general-talk-ab...teristics.html#40387

F. The documentation already include many small CSV examples. On top of that, you can export your own products to see what you need to do.

G. The check that is recommended with notepad is to check that the file you're trying to import is a CSV and not a XLS with a CSV extension (yes, it already happened). We don't recommend to use notepad to edit your CSV of course, you should use Excel or Calc for that.

@piggybank Sorry, lionel75 confused me by posting in the same thread and I thought that your issue was that you didn't create the characteristics before importing, thus my previous reply.
I checked your CSV and you're missing the default value for the characteristics of the main product. Because of that the system doesn't associate the product with the characteristics and even though the product and the variants are imported, you don't see the variants as there is no link between the main product and the characteristics.

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

  • Posts: 96
  • Thank you received: 0
11 years 3 months ago #120055

Hi Nicolas,

Thanks...I got confused with Lionel's feedback too...at first, I thought they were answers from you for my question!

I understand needing to put in characteristics for the base product. In our case,

Maybe I'm wrong in this thinking...let me know your thoughts...

I had been thinking that the base item wouldn't actually physically exist...it would be a "dummy" item to allow us to have the variants which would be the real products. I would then make one of those variants my "default".

What I'm wondering now is...perhaps my thinking/methodology is flawed and can lead to some unintended consequences. Perhaps I should be making one of the variants the actual base product?

Thanks,

Scott

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 3 months ago #120059

No, your thinking is correct. The base item doesn't exist.
And in order to make one of your variant your default one, you need to enter the value of the characteristics of that variant in the characteristic column of the base product in the CSV.

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

  • Posts: 96
  • Thank you received: 0
11 years 3 months ago #120078

That did it! Worked like a charm...very impressed with the power of HikaShop! :)

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

  • Posts: 846
  • Thank you received: 92
11 years 3 months ago #120296

Hi sorry for "confused ".
I read many post on the forum and what i see is that many recents questions for import /Export turn arround the same recents problems . For excel extension csv , use total commander or a tool like this that show us the extension of the file to not make mistake when save from excel to csv !!

to manage variant we could also create a new int colum and associate the same variant value /name to hte same value this it ll be more easy to read the table


Relative to your answer :

1) How is set the order of the variant if we don't explicit enter a value for each characteristic for the main products ? ( during import ..order id/csv ?)

2) What mean the order column label in the characteristics setting for a product ?


thank's


Thank's

Attachments:
Last edit: 11 years 3 months ago by lionel75.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 3 months ago #120339

1. you can configure the ordering of the variants by editing each characteristic in your backend and entering an ordering for each value.

2. There is no "order" column in the hikashop_characteristic table of the database. I don't know where you got that.

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

  • Posts: 846
  • Thank you received: 92
11 years 2 months ago #120392

the order is locate at HKS-> product->productNAme-> characteristic

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 2 months ago #120402

This is the ordering of characteristics for a product. It is stored in the hikashop_variant table, in the column "ordering".
The import system doesn't support the import of that value.

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

Time to create page: 0.092 seconds
Powered by Kunena Forum