I need to create an advanced workflow

[daniel54]

I need to take a list of order items based on qty sorted by price ranging from least to greatest.

Example: Item 1 (qty 2), Item 2 (qty 1), Item 3 (qty 5), etc…

Each Items single qty needs to be indexed by 1.

Then each of these items need to be processed by 3’s.

So in a Group Numbered 0 I would have [Item 1, Item 1, Item 2] In Group 2 I would have [Item 2, Item 3, Item 3], etc…

For each set of 3 [Items] sorted by price least to greatest the height priced item in position 3 will have its price discounted by half.

I would like to store in each batch of 3 Items a [0 for 1, 0 for 2, and for 3 price / 2]

This way I can simple sum the Order Items Discount to get my final total.

This Discount Calculation is a sum of each 3rd item being half off.

[J805]

Hey @daniel54

I think by writing out what you did like above is the biggest challenge. So kudos to you for figuring that part out.

The other part is creating a backend workflow that loops through each item and does what you want. You can create a new thing that groups them if you want, then when that group is full of 3 items, then you can create another one and attach the next three items to it.

That is just one way to do it, there are probably a bunch of ways to do this.

Does that help at all?

[daniel54]

Thank you very much. I am doing all of this as a recursive Backend Workflow.

You wouldn’t be able to pop on a quick video chat to help me asset this would you?

I am willing to pay you for your time.

I have been working on this now for days and still no resolve.

[J805]

I’m all booked for today but I should have some availability tomorrow to assist if you would like. You can book a session with me here. NoCodeMinute

Hope you can find a time that matches your schedule.