1. Huubss
  2. RO CSVI
  3. Tuesday, 02 August 2022
  4.  Subscribe via email
Hello,

I'd like to export all orders but only the order items that are from a specific category I want to be exported. Is that possible?
Accepted Answer
Accepted Answer Pending Moderation
Hello,
Is it possible I can somehow make a custom change so that this is possible? Where is the query located? Maybe I can add the child products as well

You can create an override for export and edit the query to include child products. The file you need to create an override is located at plugins/csviaddons/virtuemart/com_virtuemart/model/export/order.php.

EDIT: Maybe is it possible to exclude categories? That would also be a solution

There is no option to exclude category. You can apply this solution in override file as explained.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
Hello,
You can select the category in Category filter in VirtueMart Order export template on Options tab. See attached screenshot.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thank you I found it.

But that takes me to the next problem. I got sub products that are not assigned to a category. I want to count these as well. Is it possible to somehow also add in all the childs of the products to the export?
  1. one week ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
But that takes me to the next problem. I got sub products that are not assigned to a category. I want to count these as well. Is it possible to somehow also add in all the childs of the products to the export?

With category filter we include products which are in Order items table and belong to the selected category. Including child products of the product which are in selected category is not possible as of now.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
But that takes me to the next problem. I got sub products that are not assigned to a category. I want to count these as well. Is it possible to somehow also add in all the childs of the products to the export?

With category filter we include products which are in Order items table and belong to the selected category. Including child products of the product which are in selected category is not possible as of now.


Is it possible I can somehow make a custom change so that this is possible? Where is the query located? Maybe I can add the child products as well

EDIT: Maybe is it possible to exclude categories? That would also be a solution
  1. one week ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Is it possible I can somehow make a custom change so that this is possible? Where is the query located? Maybe I can add the child products as well

You can create an override for export and edit the query to include child products. The file you need to create an override is located at plugins/csviaddons/virtuemart/com_virtuemart/model/export/order.php.

EDIT: Maybe is it possible to exclude categories? That would also be a solution

There is no option to exclude category. You can apply this solution in override file as explained.


Got it working thank you!
  1. one week ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


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