1. 4Design
  2. RO CSVI
  3. Wednesday, 23 March 2016
  4.  Subscribe via email
Hello,

I have an issue with importing products with stockable variants issue. My CSV file seems to be created as in your tutorial but after import child products are not binded to parent correctly. There is 33 child products but in parent product there is only one: Villaport Type 1. Also Rozmiar and Kolor (Size and Color) fields are empty.
I enclose CSVI log, parent product screen and my csv file.

Thanks
Tomasz.
Accepted Answer Pending Moderation
Hello,
The patch for stockablecustom fields plugin supporting customfieldsforall values is done. Please load the attached patch file and try import again.


patch_CF4ALL_stockablecustomfields_2016-03-29.zip
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Tomasz,
Not sure how but the patch code for stockablecustomfields and customfieldsforall was missing in your site and so it was not working. I have updated the file through ftp and ran the import of all three CSV files you have attached here. It looks good now. Can you have a look and try one import and see if all works now?
Kind regards,

Tharuna

=========================
If you use our extensions, 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 Tomasz,
There is a problem in your CSV file for that product. The values have been shifted by one column, Parent Product SKU column has custom_title values, custom_title with custom_value and so on.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Tomasz,
Your file looks good. Your debug log is missing in your post. Can you send the debug log to check more on this?
Kind regards,

Tharuna

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

I somehow missed it. Now it is added.

Tomasz.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Seems like again Its missed. If the file is too big try to compress it and post it.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
I tried with compression and it is also missing. So I uploaded it here:
http://spoiwo.vdl.pl/com_csvi.log.139.txt
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Tomasz,
That really helped. The debug log says that you don't have custom fields Kolor and Rozmiar added. Can you send the screenshot of how your stockable custom fields is setup on Virtuemart custom fields page?
Kind regards,

Tharuna

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

Thanks for suggestion. Rozmiar and Kolor was created but unpublished. I published it and tried to run import again but result seems to be as before...
I enclose new log: http://spoiwo.vdl.pl/com_csvi.log.140.txt
And screenshot of stockable field configuration.

Regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
Your debug log still says it cannot find the custom field. Probably try updating available fields and do the import again. If you still have issue, can you mail your administrator login details and database login details to tharuna@csvimproved.com?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
I did reset and field update but no effect... I just sent You access to our site.
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
Checking your site, i found that you are using customfieldsforall values to stockablecustomfields. But current code of stockablecustomfields don't support this combination. I am working on this improvement and will post you the patch once done.
Kind regards,

Tharuna

=========================
If you use our extensions, 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
Hello,

Thank You. We installed your path but import result is the same... You can see it in product #id 1866.
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,
Ignore the email i sent for not able to access the site. It works good now and so i tested import on your site and here are the issues i found

1. First of all there is no CSVIext stockablecustom fields plugin installed in your site. This is required so CSVI imports stockable custom fields values into Virtuemart tables. I installed and enabled it and then applied the patch sent.
2. You have used language string as custom title in your custom fields but have used names in import file. It is never going to work as CSVI looks for the same title as in import file with database name. So it was throwing "No custom available fields found" error in debug log. I changed custom title in your import file to COM_VIRTUEMART_PRODUCT_SIZE~COM_VIRTUEMART_PRODUCT_COLOR.

Solving these issues i did an import on your site and see all working good. Have a look and let me know if you see any more issues.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Thank You very much.
As I opened Villaport Type 1 after yours import it has derived product assigned ok, size was ok, but in color was set some empety values.
I updated my csv as You suggested adding virtuemart labels.
After import from my file derived products are ok, but size and color is empty.
Also in Kolor field in Virtuemart in custom fields, I can see 3 values with 'FFFFFF' color. They are apearing after import.

I attached my updated csv.

Best regards
Tomasz.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Tomasz,
I applied a new patch and tried importing your file few times on your site and it looks good now. Can you take a look and let me know?
Kind regards,

Tharuna

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

I did some testing and Size field works perfect now but there is still problem empty values for Colour fields. Product import adds 3 empty values for Color field which shouldnt be done.
I attached screens.

Thanks.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello Tharuna,

Great - now its working perfect! Thank You for your great support and patience.

Best regards
Tomasz.
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello,
The problem with Colour fields is that you are trying to import wrong values. You are not importing the values with files but its label. For example custom_value should be 0,80x1,00m~c7a885 as c7a885 is the value of Galv. Try importing values and let me know how it goes.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
I don't know if its ok to write still in this topic but we would need to import also products which have only one custom field.
I attached csv file - product with SKU: #ov40.
I tried to delete size and left only color but it doesnt work ok.
Is it possible to have in one import products with two custom fields and with one custom field?

Tomasz.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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