- CSVI 6.0+
- VirtueMart 3.0
- Joomla 3.0+
- PHP 5.4+
It is possible in CSVI to combine fields and export them in one field.
As a first step of combining fields on export. Create a CSVI export template. This document explains on combining VirtueMart product fields product_sku, product_name and product_price. The same should be followed for other exports.
Say for example we need product_sku, product_name and product_price fields combined so the output looks like AB123-Product1-12.00 in product_name field. Add all these three fields to template fields.
Create a combine rule to export
No setup a combine rule to combine product_sku, product_name and product_price fields.
Give a name to the rule say Export combine rule
Select the operation as Export
The plugin to select is CSVI Field Combine
Source fields should be the fields we need to combine product_sku, product_name and product_price
Target field will be product_name as we need all these fields to be combined and exported to product_name field
Save the rule
Apply the rule on product_name field in template fields.
The final setting of template field will look like
Finally do the export to get the fields combined in csv file
Please check Combining multiple fields into one in import to combine fields on import.