Categories
View Replies (6)

Resolved Export with only orders with products from specific category

  1. Huubss
    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?
0
Accepted Answer
tharuna
tharuna
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. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (6)
tharuna
tharuna
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)
Screenshot 2022-08-02 at 4.31.12 PM.png Screenshot 2022-08-02 at 4.31.12 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Huubss
Huubss
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. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
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. more than a month ago
  2. RO CSVI
  3. # 3
Huubss
Huubss
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. more than a month ago
  2. RO CSVI
  3. # 4
Huubss
Huubss
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. more than a month 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!