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 Tomasz,
There is something really wrong with your custom field values. Looking at the screenshot the SKU of derived product shows the one for the parent and also price is not set but as per your CSV file there is price for all derived product. I tested with the product you mentioned and it works good even with one value. Can you post the debug log of 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. # 21
Accepted Answer Pending Moderation
Of course, I enclose it in attachments.

Tomasz.

http://spoiwo.vdl.pl/com_csvi.log.183.txt
  1. more than a month ago
  2. RO CSVI
  3. # 22
Accepted Answer Pending Moderation
Hello Tomasz,
Your debug log confirms that there is something really wrong. Looking for the product "#ov40" whose product_id is 2579, there is a query in debug log "SELECT customfield_params FROM #__virtuemart_product_customfields WHERE virtuemart_product_id = 2579 AND customfield_value = 'stockable'", there is no such value in your csv file as 'stockable'. Just to find why this is happening, Can you clean up the tables "#__virtuemart_product_custom_plg_customsforall" and "#__virtuemart_custom_plg_customsforall_values" and do the import only with few records probably the 4 records of the product "#ov40" and see how it goes? Please note that cleaning these tables will also delete the records you have already. So make sure you take a backup before testing.
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. # 23
Accepted Answer Pending Moderation
Hi Tharuna,

Thank You for clear instructions. I did it. It seems that derrived products have empty fields now. I enclose import csv.
Log You can view here in admin in import #id 186.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 24
Accepted Answer Pending Moderation
Hello Tomasz,
Now i see the derived products SKU and price populated correct and also see there are empty values. There is no entry into customfieldsforall plugin tables so you dont see them. Can you send me your site FTP details? I need to check stockable custom fields file code.
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. # 25
Accepted Answer Pending Moderation
Hello Tomasz,
Thank you for posting the ftp details, that was just needed to check the code but it was all good. I checked your site and the table #__virtuemart_product_customfields was all messy. I took a backup of it, cleaned the table and ran the import of your original file on your site. Now i see the product #ov40 showing values correct. Please check into the site. Also If you need the backup of #__virtuemart_product_customfields table, i can send it to you. 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. # 26
Accepted Answer Pending Moderation
Hello Tharuna,

Yes, now all products including #ov40 shows correct values. Thank You very much!
One more question: some of products will need one more field - weight. What would You suggest? To create new custom field Multi2 which would consist of 3 fields (size, color, weight)? Or add it directly to current field Multi?
Does CSVI handle it in one csv file that some product will have 2 and some 3 fields?

Regards
Tomasz.
  1. more than a month ago
  2. RO CSVI
  3. # 27
Accepted Answer Pending Moderation
Hello Tomasz,
Yes, now all products including #ov40 shows correct values. Thank You very much!

Glad to hear that it is all good.
One more question: some of products will need one more field - weight. What would You suggest? To create new custom field Multi2 which would consist of 3 fields (size, color, weight)? Or add it directly to current field Multi?
Does CSVI handle it in one csv file that some product will have 2 and some 3 fields?

Yes, You can add it directly to current field Multi. Make sure you set the custom_title and custom_value counts to be equal. For example if a product has three values then custom_title would be color~size~weight and custom_value is value1~value2~value3. If a product has only 2 say color and weight then custom_title would be color~size~weight and custom_value is value1~~value3. Note that value2 is left empty.Hope it is clear.
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. # 28
Accepted Answer Pending Moderation
Hello Tharuna,

Thank You for your instructions regarding to third field.

Unfortunately today I have again problem with import :(
I wanted to import next category (Flettverke) but all products didnt have any custom fields. So I cleared tables: #__virtuemart_product_custom_plg_customsforall and #__virtuemart_custom_plg_customsforall_values and #__virtuemart_product_customfields and tried to run import again. But after that even products from categories which was ok, have none custom fields... (Stopler, Porter).
Can You have a look what is wrong?

Regards
Tomasz.
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 29
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 30
Accepted Answer Pending Moderation
Hello Tharuna,

Yes now import was successful. I have issue only with one product id 2646. It has empty custom fields. Can You have a look on it?
I looked carefully on csv file but it looks ok. If You wolud like to test import, You can delete all products with id between 2643 and 2702 and then run import with csv I attached.

Regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 31
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 32
Accepted Answer Pending Moderation
Hello Tharuna,

So banal mistake... Thank You very much :) Its working now.

Two posts ago You wrote:
Not sure how but the patch code for stockablecustomfields and customfieldsforall was missing

Was it caused by CSVI update? Is this patch resistant to updates?

Best regards
Tomasz.
  1. more than a month ago
  2. RO CSVI
  3. # 33
Accepted Answer Pending Moderation
Hello Tomasz,
Yes it was caused by CSVI update :)

This code will be included in our CSVI 6.6.0 release so till then please make sure the patch is updated when you update CSVI version.
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. # 34
  • Page :
  • 1
  • 2


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