1. erdelyikaroly1
  2. RO CSVI
  3. Monday, 14 April 2025
  4.  Subscribe via email
We use Joomla 4 and VirtueMart 4 systems. Among the shipping methods, we installed a plugin that allows selecting package lockers and pickup points of partner courier companies. The plugin created a table in the database named virtuemart_shipment_plg_pontnomap. The fields in this table store the data selected by users.

In the RO CSVI component's "Available Fields" menu, the fields from the table can be found, such as:

order_number

shipment_point

pont_name

ppshipmentpoint

pont_operator_id

pont_place_id

We export orders using the "VirtueMart Order Export" template because it allows selecting purchases for export based on their identifiers. We would like assistance to ensure that, in addition to the default fields, the following fields from the virtuemart_shipment_plg_pontnomap table appear in the "VirtueMart Order Export" template:

pont_operator_id

pont_place_id or ppshipmentpoint

pont_name

This is crucial because these fields are necessary to create a CSV file that can be used to upload orders to courier companies' online platforms in bulk. Without these fields, we can only upload orders individually, which is practically impossible due to the high number of orders.
Accepted Answer Pending Moderation
I apologize for the impolite omission of a greeting and signature in my previous email.
Best regards,
Karoly Erdelyi
  1. 1 day ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
We do not support 3rd party shipment plugins in VirtueMart order export and so the fields from virtuemart_shipment_plg_pontnomap table are not available by default.

Two ways to solve this
1. Add fields of virtuemart_shipment_plg_pontnomap table as custom available fields and create an override for VirtueMart order export template to include virtuemart_shipment_plg_pontnomap table in export. All filters available in order export template can still be used.
2. Create Advanced custom export template and link all tables needed for VirtueMart order export. You can also include virtuemart_shipment_plg_pontnomap table in this export and link it using order_id or order_number. The downside of this export is that there are no filters available as in VirtueMart Order export template.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 1 day ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!