0

Is it possible to filter Expresso Store 2 orders between two dates in a template? EG the customer wants to see all their orders between 2013 and 2014.

Many thanks

3

You could do this pretty simply with this:

{exp:query sql="SELECT order_hash FROM exp_store_orders WHERE order_completed_date > 1356998400 AND order_completed_date < 1420070400"}
{exp:store:orders order_hash="{order_hash}"}
Order #{order_id}
{/exp:store:orders}
{/exp:query}

Brad

  • Thanks so much for this was a great (and simple) solution – MrTomTom Nov 18 '15 at 2:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.