Complex Calculations Required – Seeking Advice

Questions & Answers
1

I’m working on a scenario where I need to perform a lot of calculations. I’ve started storing the shipping rules in a Datastore, but I’m finding it challenging to find the most efficient method for the calculations. Could you offer some guidance?

FYI, I’ve written a Python script that does what is needed, and it works without any issues: Google Colab.

Below is an example input:

{
    "product_code": "iphone-15-pro-blue-1",
    "order_quantity": 34,
    "shipping_country": "US",
    "US_units": 12,
    "DE_units": 10,
    "FR_units": 10,
    "UK_units": 0
}

For the provided input, the output JSON should be:

{
    "1 business day": "12 units",
    "5 business days": "20 units",
    "Supplier backordered; delivery time to be confirmed": "2 units"
}

The shipping times in days table from each location:

shipping_rules = {
    "US": {"US": 1, "DE": 5, "FR": 5, "UK": 5},
    "FR": {"US": 5, "DE": 3, "FR": 1, "UK": 3},
    "DE": {"US": 5, "DE": 1, "FR": 3, "UK": 3},
    "UK": {"US": 5, "DE": 3, "FR": 3, "UK": 1}
}

Prioritize shipping locations with available stock until the stock is 0. Then, prioritize by shorter delivery times.

2

Hi Nicolas,

if you already have a pythons script to do the calculations - then you can host it on pythonanywhere and call it with an ssh module from the Make.com scenario. I believe that would be faster/easier way than to figure out how to do the calculations in Make.

2 Likes
3

Thank you, Stoyan. You’re correct. I had considered hosting the API endpoint on render.com. However, in my current situation, I’m not permitted to use a non-approved solution like Make. That’s why I was thinking of exclusively using Make for that purpose.

4

Actually, I’m on the enterprise plan and I have access to custom functions where you can write any business logic in JavaScript: https://www.make.com/en/help/functions/custom-functions.

That is exactly what I needed. But it’s a shame that it’s only available on the enterprise plan…

3 Likes
5