Add a line of data triggered by input data…

When our customer’s, customer purchases product B our customer would like to add product Z to the order. I’ve done this for others in the past with VBA in our WMS. But, there’s always a risk of duplication when the order gets moved around. I feel the safest way is to add product Z during the import. Any suggestions, much thanks in advance.

JD

Hi JD,

It´s possible but a bit tricky. I´ve attached a short example.

With an IF-THEN-ELSE condition you decide with product is currently proceeded. In case of product “B” you have to duplicate the CSV record X times by using the GroupOut Heater . In your case you need just one copy of them. This is done with the Input parameter form the two X-Value Heaters . 0=no copy needed, 1=make one copy. Note: 2=make two copies …

Afterwards you need for each field you would like to have other content another IF-THEN-ELSE condition to decide which content should be adopt on the WRITE side. For this condition you need the AutoID Heater with enabled GroupOut option. With this you can build a condition like if AutoID = 2 use Product Z other use the original content.

Sounds hard but I guess with the example it should be clear and easy to handle.

You guys rock

Thanks FlowHeater-Team…thanks for the easy to follow instructions and example.

As always Robert, very helpful I will find other uses for this as well.

Thanks Again, JD

Hey guys I’m still struggling with this. It’s overwriting one of the line items on the first order and adding the new item. In your example (zip) change the second line item “B” to “C”, run the def as it is and it will change the “C” to “Z”. We were forced to reship a couple orders, on our dime, until I was able to identify the problem. They’re manually entering the additional item where needed for now.

Hi JD,

On my side the output is like expected. I guess you use an old Version? Please try it with the latest Version.

After updating and making a couple adjustments this works like a charm…thanks again Robert.