Calculate Est Delivery date for products

Amila Deshan (1407)

 I have a problem to solve. I need your help for that. This is my scenario

 

I want to show Estimate Delivery time in the Order Email Template and Invoice Template. 

 

This is the calculation to calculate the Estimate Delivery date. 

 

If the product is in Pre Order, The use this formula to calculate the Estimate date

 

Handling Time should be taking from the Products Handling Time Field

 

 (arrival date + Handling Time) - (arrival date +  Handling Time   + 14 business days)  

 

If the product is not in Pre Order, Use this formula

 

Handling Time should be taking from the Products Handling Time Field

 

Make sure to get only weekdays for the handling date count.

 

  (today+ Handling Time  ) - (today +  Handling Time   + 14 Calendar days)  

 

Can you help me with this calculation? 

 

I want to use that calculation inside the Order Receipt Email template and Order Invoice PDF Template. 

 

Can anyone help me with this to make the calculation using B@SE Tags.

 

Thank you

Erik Merkley

That'll take a bit of B@SE code but most of what you want is achievable. I'll give you a starting point.

 

Use [@preorder@] to check if the order line is a pre-order. If that field isn't available in a particular template, look it up with [%show_order%]

https://developers.maropost.com/documentation/neto-designer-documentation/b-se-tag-library/function-tags/orders/show_order/

 

There are two ways to add/subtract dates. One is with the [%format%] tag, like this:

[%format type:'date' add:'14 day' format:'#D #K #Y'%]now[%/format%]

https://developers.maropost.com/documentation/maropost-commerce-cloud-designer-documentation/b-se-tag-library/function-tags/formatting-and-data/format/

 

The other way is to convert the date to a unix timestamp, then do maths directly on that number, like this:

[%set [@mydate@]%]

[%format format:'#U'%]now[%/format%]

[%/set%]

[%set [@mydate@] = [@mydate@] + (86400 * 14) /%]

[%format format:'#D #K #Y'%][@mydate@][%/format%]

 

You can look up the product's custom field with the [%product%] tag

 

Allowing for weekends will probably be impractical. I'd stick with calendar days if you can. Good luck!