Resolved How to add new field in product import?

Hello Anton,
The available fields for product import for language table are loaded from available fields sql file and not from table. There are two ways of doing this, you either need to add your new field to #__virtuemart_product table and not to your virtuemart_products_ru_ru language table and so CSVI reads it from virtuemart_product table.

The second option if you have multi-language site setup, you can create your own override sql file and add your custom fields so CSVI updates it during Update available fields. This feature is yet to be released but the patch file is available and is attached to this post. Load the patch file through CSVI maintenance menu. You need to have your override sql file in the path administrator/templates/youradmintemplatename/html/com_csvi/com_virtuemart/install/ and the name of the sql file should be override.sql. Kindly note that youradmintemplatename in the path represents your administrator template name like for example 'isis'. You need to put your file in your corresponding administrator template folder. This should help you to load your custom available fields.

The query in override.sql file should be like below, dont forget to replace yourfieldname to name of your available field.

INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`,`action`) VALUES

('yourfieldname', 'yourfieldname', 'product', 'com_virtuemart', 'import');

patch_availablefield_override_2016-09-27.zip

Thank you

i am added new field in mysql virtuemart_products_ru_ru
I am install patch!

But i did not understand what i must to do then!

please send me video

Hello,
Once you install the patch you need to create an override sql file with query given in my previous post and the name of the sql file should be override.sql. Put this override.sql file in the location administrator/templates/youradmintemplatename/html/com_csvi/com_virtuemart/install/ and then update your available fields. That will update your custom available field too.

ok, i am understand

This code is correct for me?

INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`,`action`) VALUES
('product_youtube_code', 'product_youtube_code', 'product', 'com_virtuemart', 'import');

it's like similar for all additional field?

Hello,
Yes the query is correct, if you need to include more you need to add like below, just add the field names in VALUES separated by comma. The last line should end with ;

INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`,`action`) VALUES

('product_youtube_code', 'product_youtube_code', 'product', 'com_virtuemart', 'import'),

('field2', 'field2', 'product', 'com_virtuemart', 'import'),

('field3', 'field3', 'product', 'com_virtuemart', 'import');

thank you
why new field write 2 time?
'field2', 'field2'?

ok, script takes product_youtube_code value from virtuemart_products_ru_ru table?

Hello,

why new field write 2 time?
'field2', 'field2'?

Please check the query i sent, the value belongs to two different columns names though it is same.

ok, script takes product_youtube_code value from virtuemart_products_ru_ru table?

Yes, the value will be imported to product_youtube_code field in virtuemart_products_ru_ru table. Remember that this will work only for the import as the custom field is added for import.