Like did u mean u need to enter all the order 1 details once while order2 for once like that?
yes , as i have to put them into a form and save it order by order
I had added the comments so that it can help in designing the workflow rest.
it doesn’t work can you provide me with sheet to understand what you mean
error with that variable
U can add ur sheet as input there
Sorry it should be
ask.xlsx (11.0 KB)
you may not understand me as i will get unknowen number of orders
I did not understand ur requirement well
enter the sku’s with same order number (example order no 154) and save them , then
enter the sku’s with same order number (example order no 155) and save them and so on
To understand more, I recommend you to use debug mode. I have left on purpose breakpoints in strategic points. Each time the robot does a break, in the local panel, watch carefully the variables sku, increment_id and temp_DT.
To write in the right line in All items table (in your website), do you know how to do ?
If no, use UiExplorer and indicate these elements and send us a screenshot of what you see:
and indicate the following fields (so we need 2 screenshots):
Using exactly the same data you sent us as a screenshot (the 3 columns + 4 lines) ? with my sample it works:
Can one order_ num have more than one incrementID?? Only sku differs with every combination of order_num and increment_id right?
I checked the flow of @Hiba_B and it works well.
When working with Sheet4, you need to customize the column names in the workflow.
Column order_number to order.
Column sku to *product
no ,every order number has one increment_id with differ sku and qty
i try to put each order example in screen shoot i add qty colom in my sheet
as i work on sap system not website
Condition_on_excel_sheet.xaml (39.1 KB)