Resolved Additional fields not available to me

Ah indeed I see in the DB available fields tables that they are there - BUT there seems to be for the com_csvi component - Can I just change the component table to virtuemart_products and the component
?

HM - No that didnt work

Hello,

Ive added extra tables and extra fields for Virtuemart. ##_virtuemart_products_ext_misc

We only support core VirtueMart table fields as template fields and so you don't see the fields from this table in export. If you want to include this table with other VirtueMart tables then you should use RO CSVI custom table export. Since this export is a generic one there are no filters available like you have in VirtueMart Product export.

I"m guessing I could do this via a plugin tho I I wanted them added to standard VM template?

Hello,
You can create an Override for adding the fields from table as custom available fields as explained in the document Adding your own custom available fields. You can create an override for VirtueMart Product export to include these fields in export file.

Yes I did see taht - I wasnt too clear on the operation

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


I dont see any mention od how to add specific fields

how would I for example add to virtuemart_products_ext_misc

"field1","field2"
?

Hi Derek,

So you create the override.sql file and put it in the folder as explained in the document. In the file you put the fields from your own table. In your case it should look like this:

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

('YOURNAME', 'YOURNAME', 'product', 'com_virtuemart', 'export'),

('YOUROTHERNAME', 'YOUROTHERNAME', 'product', 'com_virtuemart', 'export');

Change the YOURNAME, YOUROTHERNAME to the name of your fields. This will make the fields available to the VirtueMart product export. Now you also need to add code in the VirtueMart export routine to know what to do with these fields, that can be done with the Product VirtueMart override that Tharuna mentioned.

Let us know how it goes.