wrong variant import from CSV

  • Posts: 7
  • Thank you received: 0
11 years 3 months ago #117499

-- HikaShop version -- : 2.2.0
-- Joomla version -- : 2.5.8
-- PHP version -- : 5.3.14

Hi,
I have a problem since I have upgrated from Hikashop Starter 2.1.2 to Hikashop Business 2.2.0.
Before upgrade I was able to successfully import products and variants.
After upgrade, only main products are imported. Variants seem to be ignored.

I made some debug and i noticed that variants are loaded into database but product_parent_id were lose during import.
This behavior occurs even when i import a previously exported csv without modifications.
I also tried in a new installation with products and variants created from user interface but the problem still persist.

I also get load of errors saying The column "X" is twice in your CSV. Only the second column data will be taken into account.
In many posts i have read to ignore there errors.

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

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

Hi,

You say that the variants are ignored. How do you know that they are ignored ? Does that mean that they are not added to the product ?
Or they are added in the database but not to the product ? Or they are added to the product but not linked to the characteristics ?
If you look in the database, do you see them in the hikashop_product table ?

Normally, issues with variants import comes from the CSV not being correct. Having the CSV that you're using would help us check that everything is ok with it. Also a screenshot of your characteristic option page would be great.

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

  • Posts: 263
  • Thank you received: 11
11 years 3 months ago #118045

I also get load of errors saying « The column "X" is twice in your CSV. Only the second column data will be taken into account.
In many posts i have read to ignore there errors. » since my update to 2.2
:(

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

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

Yes, as you read, you can ignore those.

You'll have to answer my questions if you want me to be able to say more on your issue.

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

  • Posts: 7
  • Thank you received: 0
11 years 3 months ago #118105

Hi, thanks to reply.
Variants are added in the database but not to the product. From backend, in products list page (index.php?option=com_hikashop&ctrl=product) I can see only main products, not variants (of course I set filters to "all").
From database I saw that variants are linked to characteristics but not to their product. In hikashop_product column product_parent_id is equal to zero.

Today I made a new environment from scratch, and If I load a full csv (with products and variants) then all works fine.
Actually, problem arise when I try to import only variants.

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

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

Hi,

That explains why. The import doesn't support CSVs with variants without their main products.
Both should be in the same CSV for it to work properly.

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

  • Posts: 263
  • Thank you received: 11
11 years 3 months ago #118138

Weird... I only have one CSV file to import.

My file worked before update to 2.2.

Import seems ok but I really have error messages like you said.

I will do other tests later.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 3 months ago #118312

Hi,

I checked and we didn't modify the CSV import system in HikaShop 2.2.0.
There are some fixes but the main algorithm is the same, the import works the same than the previous version (but with some fixes).

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Last edit: 11 years 3 months ago by Jerome.

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

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

1) In many case the "information" is in the documentation and answer need only a link to the documentation .
if there is no "404 error " message ! ......( !important :P )
www.hikashop.com/support/support/documen...hikashop-import.html

2) But what about Troubleshooting page documentation about import export ?
there ll be less post and more time to enhance HKS core functionnalities !!!


3) The chapters of the whole forum follow the workflow process of ecommerce for BackEnd and FrontEnd .
Why not a sticky post with a link for each sub forum ?

for example
for "Import & export ( CSV XLS) " a sticky post could contain many link to the documentation relative to import export ?

Regards

It is awesome how HKS team is responsive ( :P ) in this forum ( never see that )

all :P is relative :P to css Layout selector

Last edit: 11 years 3 months ago by lionel75. Reason: add chapter number

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

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

1. If you find other 404 errors, don't hesitate to tell us and we'll fix them.

2. Again, if you want to rewrite parts of it, tell you what you want us to add/replace with what text and we'll change it. Note that we already mention that the main product must be together with the variants in the CSV file:

Finally, you can also insert variants of products. You will have to specify in the product_parent_id column the product_code of the main product which must be inserted before the variants in the file.


3. I don't see the practical use for that since there is already a documentation page where we arranged the documentation pages into different groups and that when you create a new topic, we already mention that you can look at that page with a link to it.

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

  • Posts: 263
  • Thank you received: 11
11 years 3 months ago #118989

Still et again this error....

Do you want to have the error too? Try to import this in a textfield :

product_id;product_code;product_name;product_description;images;product_published;categories;parent_category;categories_image;product_manufacturer_id;product_layout;price_min_quantity;price_value;files
;;;;;;Fichiers;Produits;Fichiers.jpg;;;;;
f0001;Agenda_automatise_cslsj_2013_2014;Agenda automatisé 2013-2014;Notre.;Agenda_automatise_cslsj_2013_2014.jpg;1;Fichiers;;;La Page PT;;1;2,97;Agenda_automatise_cslsj_2013_2014.xls

And see Attachment for error.

It was without error before Hikashop 2.2. I think.

(For the error in blue « Annonce », that's ok. It's the second line of the import who does it. The one for the category. No problem)

Where is the problem with this importation?

Attachments:

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 3 months ago #119055

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: Flooder

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

Time to create page: 0.093 seconds
Powered by Kunena Forum