1. HennieBraun
  2. RO CSVI
  3. Friday, 22 June 2018
  4.  Subscribe via email
Hello,

Attached I have several images of steps I have made to import a file with stockable products.
The problem is in VM products (image attached) It does not combine the childproducts with the parent.

I have tried several options, and the csv-file seems to import correctly but no parent product.
Hope you can help (again :-)

kind regards,
Hennie

[attachment]Test-customfields.csv[/attachment] [attachment]Test-import-custom.jpg[/attachment] [attachment]Test-import-custom-2.jpg[/attachment] [attachment]com_csvi.log.33.zip[/attachment] [attachment]csvi_templates_http://www.vdvegt-shop.nl_20180622.xml[/attachment]
Accepted Answer Pending Moderation
I did get an error on my post, so I do attach the files again,

[attachment]csvi_templates_http://www.vdvegt-shop.nl_20180622.xml[/attachment] com_csvi.log.33.zip Test-import-custom.jpg Test-import-custom-2.jpg Test-customfields.csv
Attachments (5)
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
The problem is with your import file, you have 151-0404032-5400 for parent_product_sku field for parent product. This should be empty since it itself is a parent product. Do the change and run the import.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Tharuna,

The import is run again and I have attached the logfile.

I have some questions according importing:
- do I need the parent product present before the import? -> After several import-settings atemps with no luck I made a parent article before importing the child products. I assigned customfields to the parent and set the parent product to be ordered.

After the parent product in place I did run a new import trough csvi : The child products are combined with the parent now. But no customfields in place.

Hope that makes sence ?? :-)

com_csvi.log.38.zip
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Is it not possible then to import a products-list, containing parent-product and child- products in once?
I have a file with 5 product-sku , same artikel but different sizes. I assign one article ( example size S) as parent and the other sizes as child products.
That is correct??
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
The import is run again and I have attached the logfile.

I have some questions according importing:
- do I need the parent product present before the import? -> After several import-settings atemps with no luck I made a parent article before importing the child products. I assigned customfields to the parent and set the parent product to be ordered.

After the parent product in place I did run a new import trough csvi : The child products are combined with the parent now. But no customfields in place.

No, you don't need to create parent product before the import. If the values in your import file are set correct, CSVI will create the parent product. Did you make the changes to your import file as i said in my previous post? The debug log attached shows that you still have product_parent_sku value for parent product. Can you run the modified import file attached with this post? Check if the parent product has been created on import.

Is it not possible then to import a products-list, containing parent-product and child- products in once?
I have a file with 5 product-sku , same artikel but different sizes. I assign one article ( example size S) as parent and the other sizes as child products.
That is correct??

Yes thats correct, for child products you should set product_parent_sku field with SKU of the parent product. In your case SKU of example size S to the child products. Hope it is clear.

Test-customfields.csv
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hi Tharuna,

but how knows this file that my parent product has Size S ??

I clearly missing the clue here... :-(

kind regards,
Hennie
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Two attachment present:

com_csvi.log.39.zip Test-import-custom-3.jpg

Imported the file but in the VM products no parent product..

kind regards,
Hennie
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
I have attached another file :-(

Test-import-custom-4.jpg
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Since you want parent product also to be on sale, you need to define ramifications for parent product which in your case it is Size S so i think it would be better if you use Multi variants import instead of Stockable custom fields plugin. Let me know if that solves your problem.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Tharuna,

could you explain this a bit more?
>>
Order of import

Import should be done twice for multi variants, First import will store the custom fields and the second import will import the custom fields. The order of import is:

Import the parent products
Import the child products or both the parents and the children

Instead of making 2 separate files with one for the parents and one for the children, you can use 1 file with both the parent and the children in there. This will generate a message saying there are unsupported fields, this is expected because the available fields have not yet been updated. This can be safely ignored, and on the second import, all will be fine.<<
What do you mean by First import?

And the Size and Color are regular Custom fields? ( string/text and the sizes divide in xs;s;m;l etc?)

kind regards,
Hennie
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Tharuna,

I feel we are getting somewhere :-) See the image!

However in the shop the products are still visible in all sizes....

Hope you stick by me :-)

kind regards,
Hennie

PS did not yet tried your other option. One at the time..


Test-parent-2.csv Customfields-2.jpg
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Hennie,
What do you mean by First import?

That piece of document explains that you need to import file twice so with First import CSVI will create the custom fields if not already created by you and with second import the values of custom fields are imported and linked to products.

And the Size and Color are regular Custom fields? ( string/text and the sizes divide in xs;s;m;l etc?)

Yes they are regular custom fields.

However in the shop the products are still visible in all sizes....

As i explained in my other post reply you need to set category_path to parent product and leave it empty for child products. This way child products uses parent product on frontend and gets grouped to parent product. Try and let me know.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Dear Tharuna,

That did the job!! I now have all the childproducts and sizes in place and in the shop just one Product with the size options !!
You came a long way with me ':-)

Thanks very much,
kind regards,
Hennie
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Hennie,
Glad to know that your issues are solved :). Would appreciate if you can leave us a review on Joomla Extension Directory.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!