Resolved Available fields - add new field

Hello,
I have linked a document with text Override import/export routines in my previous reply. The document will explain on how to create an override file for export. In the override file write custom query to get value of branch_id field from #__virtuemart_shipment_plg_ppldhl table.

No, I have no idea how. Can you give me some advice?

Hello,
As I mentioned branch_id field is not supported in VirtueMart export by default. You need to add this field as custom available field in override.sql which you have already done and then write custom code to include this field in export by creating a override field for export. Did you also create override file for export?

Hello,
I created override.sql in /www_root/administrator/templates/atum/html/com_csvi/com_virtuemart/install
After updating the fields, branch_id can be inserted into the template, but no value is loaded.

Thanks
DC

Hello,

We have added the branch_id field to the table xxxx_virtuemart_shipment_plg_ppldhl in the Joomla 4 database, Virtuemart 4. When updating the available fields, the field is not loaded.

That field is not loaded because xxxx_virtuemart_shipment_plg_ppldhl table is not supported with export.

Also you did not mention which export you are using but if you want to add new custom fields to export you will also need to add code to include in export. Read through Adding your own custom available fields document to add these new fields. Also check Override import/export routines document to write custom code to include new fields in export.