Categories
View Replies (6)

Resolved RE: Unable to import stockable custom fields - VM

  1. New
  1. markomo
    markomo
  2. RO CSVI
  3. Sunday, 27 October 2024
  4.  Subscribe via email
Hi Tharuna,

If you could help me with similar but not the same issue. I have created CSV as describer in docs and when I import it, custom field variations are created with but no values has been imported.
I have 3 related (child) products which I can see as children for main product (my root product has SKU 286). Child products are SKU-s 287, 288, 289,
When I run import custom fields are created as shown below. Issue I am having is that it is linking itself 3 times by adding it's own Root product SKU.
I have defined product_as_derived flag but it does not get applied at all.

When I hit buttom "Select Existing" it lists only one product (itself, root product). It does not give me any oter products to pick.
Could this be a bug in latest version of component/plugins?

My CSV look like this:



"product_sku","product_parent_sku","custom_title","custom_value","custom_multiple","product_name","product_price","product_as_derived","custom_parent_title","custom_parent_value"

"286","","VelicinaBoja~VelicinaBoja~VelicinaBoja","stockablecustomfields~stockablecustomfields~stockablecustomfields","Y~Y~Y","Glavni proizvod","123",1,"Velicina~Boja","3-6M~smeđa"

"287","286","Velicina~Boja","3-6M~Green",,"Pleteni kombinezon 1 3-6M",,,

"288","286","Velicina~Boja","9-12M~Red",,"Pleteni kombinezon 2 9-12M",,,

"289","286","Velicina~Boja","9-12M~Orange",,"Pleteni kombinezon 3 9-12M",,,



select_product.jpg

no_relation.jpg

My custom fields configurations:

custom_fields_velicinaboja.jpg

custom_velicina.jpg
Attachments (4)
no_relation.jpg no_relation.jpg
select_product.jpg select_product.jpg
custom_fields_velicinaboja.jpg custom_fields_velicinaboja.jpg
custom_velicina.jpg custom_velicina.jpg
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I have created your issue as new topic as that other topic is very old.

Please post import debug log to check. To get the debug log see How to collect debug information? document.
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
markomo
markomo
Accepted Answer Pending Moderation
HI Tharuna,

Thank You very much. I will add Debug Log in a minute. After spending all night in attempts trying to figure out what is going wrong, have done few things and did make it work at the end but there are still some bugs and issues.

I have:
- Latest version 4.x.x of Joomla
- Latest version of RO CSV and it's plugins
- PHP version 8.2

Will try to cover all my findings and with the issues I can replicate. Not all are related to my attempt to import data but overall findings which maybe belong to a Bug report.


  1. Exporting and Importing templates (as a backups) does work in some sitiotions, while it's throwing errors depending on state of other tables in DB
  2. #_virtuemart_product_custom_plg_customsforall' doesn't exist error during import if import template has "Delete custom fields relations" enabled in settings.
    3. I had to reinstall RO CSV component to fix the tables and disable this feature in template settings (even if I need it). I need this feature to delete custom fields data during import (drop everything it has and insert it again). As a workaround same issue I am using "Delete related products" option which deletes related products just in order to insert fresh Custom Fields data. Please see description below.
  3. Stockable Custom Field limited support for flields that contain characters in names: č ć š ž đ. I had field named "Veličina" (Size in english) which would skip the field on import.



In relation to "Delete related products", I am using Example VirtueMart Product Import template to import products (and update them) on daily basis.
If I don't use this feature, Root product where I have child products will get double entries for custom fields. Import does not owerwrite custom fields of existing entries but adds more on top of it.

Will add few more once I run the process again and force the errors. Log is attached below.
Attachments (1)
com_csvi.log.18.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please add details in this thread as this is the new forum topic created.
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
markomo
markomo
Accepted Answer Pending Moderation
Hi Tharuna,

I am sorry I don't understand what do you mean by adding details in this thread. I have added details above.

Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

tharuna means the Site Details that you can add when you add or edit a message below your message. By default the Attachments tab is opened at the bottom of each message.
Kind regards,

RolandD

=========================
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. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Exporting and Importing templates (as a backups) does work in some sitiotions, while it's throwing errors depending on state of other tables in DB

What is the error you see? Can you post a screenshot?

#_virtuemart_product_custom_plg_customsforall' doesn't exist error during import if import template has "Delete custom fields relations" enabled in settings.
I had to reinstall RO CSV component to fix the tables and disable this feature in template settings (even if I need it). I need this feature to delete custom fields data during import (drop everything it has and insert it again). As a workaround same issue I am using "Delete related products" option which deletes related products just in order to insert fresh Custom Fields data. Please see description below.

That table belongs to Breakdesigns customfieldsforall. That table is missing and has not been installed when you installed Breakdesigns customfieldsforall plugin. You are seeing that error with RO CSVI because with Delete custom fields relations RO CSVI deletes all custom fields relations with a product which also includes customfieldsforall. You will see this error if you create customfieldsforall field from VirtueMart. Please check with breakdesigns support on this issue.

Stockable Custom Field limited support for flields that contain characters in names: č ć š ž đ. I had field named "Veličina" (Size in english) which would skip the field on import.

In the attached debug log there is no log entries about processing of stockablecustomfields. Please check and send me latest debug log so I can check what is going on with stockablecustomfields import.
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
  • Page :
  • 1


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