Support is online

Custom field value gets duplicated #8324

Open costas_io opened this topic Monday, 06 June 2016 · 4 replies
Author

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

Support

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

Author

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

Support

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

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

thanks for the fix. it is now working as expected..

Log in to reply to this topic.