I would like to do two things with one scenario, but I cannot get it to work for multiple records. The first record works fine, but all the others error with the message “The system failed to commit the Items Row”.
We have multiple discount sequences “5” and “10” within a code “SALE”, which mark items as 5% or 10% off; nothing complicated. Some items got put into the 5 sequence that should have gone into the 10 and I would like to use an import scenario to remove them from one and add them to the other. Yes, I can do this as two different scenarios, but it seems like something that should be manageable all at once.
It seems straightforward enough: go to one sequence, lookup the item with @@InventoryID and remove it, then go to the second sequence (same discount code) and add it. Oddly, it wasn’t working when I had a ‘<Line Number> = -1’ action to add the item to the second sequence. I can’t reset the InventoryID key in the second sequence; it just merges with the first key line.
Thank you for any insight you can provide,