Categories
View Replies (4)

Resolved Custom field value gets duplicated

  1. costas_io
    costas_io
  2. RO CSVI
  3. Monday, 06 June 2016
  4.  Subscribe via email
I using CSV 6.7.0 which is the latest version.i have the following issue..

i have created a custom field as show in the screenshot and i have created a product import template

and when i import, the product are getting imported successfully but the issue for example when i import 3 products with same custom field and same custom field value.

even though the custom field name and value is same, every time it create a duplicate value
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I using CSV 6.7.0 which is the latest version.i have the following issue..

The latest version is 6.5.7 and not 6.7.0 :)

i have created a custom field as show in the screenshot and i have created a product import template

and when i import, the product are getting imported successfully but the issue for example when i import 3 products with same custom field and same custom field value.

even though the custom field name and value is same, every time it create a duplicate value

The debug log you have posted is not complete, it doesnt tell anything. As of your custom field setting and your import file all looks good. In fact trying an import with your file did not create any duplicate for me. So I would need the complete debug log to tell you the cause for the issue.
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
costas_io
costas_io
Accepted Answer Pending Moderation
sorry the version im using is is 6.5.7.

i have attached the log which was used, can you please check if that would help you
Attachments (1)
com_csvi.log.85.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your debug log says there is an issue in a query where customsforall_value_id is inserted as 0, which could be the cause for the issue. Look below

INSERT INTO `vtast_virtuemart_product_custom_plg_customsforall` (`customsforall_value_id`,`virtuemart_product_id`,`customfield_id`) VALUES  (0,3081,23879),(79461,3081,23879)


Can you try to load the attached patch file and try import again?


patch_customfieldsforall_2016-06-06.zip
Attachments (1)
patch_customfieldsforall_2016-06-06.zip
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
costas_io
costas_io
Accepted Answer Pending Moderation
thanks for the fix. it is now working as expected..
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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