Mass action filter set

  • Posts: 317
  • Thank you received: 17
  • Hikashop Business
2 years 2 weeks ago #346261

-- HikaShop version -- : 4.4.5

I have configured filter like in attachment.
I need to export ALL orders with status confirmed and preorder. With that setings I get only preorder.
Please help.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
2 years 2 weeks ago #346264

Hello,

Your filter on order created may be the issue, change it for this :

alt


Note : When you create/add a filter the result is dynamically displayed (here "3 results" on my screenshot), this will help you to define your massaction step by step.

Hope this will help you.
Regards

Last edit: 2 years 2 weeks ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 317
  • Thank you received: 17
  • Hikashop Business
2 years 2 weeks ago #346301

Order created is set as {time}-1604800. So all orders created 19days ago.
That filter works ok.
The problem is with order status. I only can get one of them in export.

So in result should be some preorder and some confirmed.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 2 weeks ago #346304

Hi,

Whatn you want want is the orders with the status confirmed OR preorder. The order status for one order can only be one, not two at the same time.
So you can't have two filters on the order status as they would use the AND logic, which you don't want here.

The solution is to use a filter "order column" with the operator "REGEXP" and the value

(confirmed|preorder)
That way, it will do the OR inside the regex

Last edit: 2 years 2 weeks ago by nicolas.
The following user(s) said Thank You: mojweb

Please Log in or Create an account to join the conversation.

  • Posts: 317
  • Thank you received: 17
  • Hikashop Business
2 years 2 weeks ago #346307

Thank you. That worked.

Please Log in or Create an account to join the conversation.

Time to create page: 0.071 seconds
Powered by Kunena Forum