1. webstar
  2. RO CSVI
  3. Friday, 02 May 2025
  4.  Subscribe via email
HI - Ive added extra tables and extra fields for Virtuemart. ##_virtuemart_products_ext_misc

Ive updated the available fields and see them in the list but I cannot seem to use/access them in the product export template for VM

Any ideas?
Accepted Answer
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.