I am not able to connect Ecwid 'new order' to excel 'new row' due to "no data"

[Yupa223]

I am not sure if I am doing the Data value right. Url :https://connect.pabbly.com/workflow...YBDlfS1ZSAlQCcVZPVUdXVFAqWxZUZw1IADMMUld_Vjc#

Trying to figure our how to set up new orders on excel from Ecwid. But run into an issue when customer doesn't order everything. Please help me with the "no data" entry I am trying to bypass it with the Data Value but no luck.

 

[Supreme]

Hey @Yupa223

You can try the following if condition formula to pass the default value in the given field.

Here is the shared workflow where we have tried the same - https://connect.pabbly.com/workflow...aBGFaTgoOUAZRIlJIABJdXlAqVRgIcwZXX2xbBVF5VTQ#

 

[Yupa223]

Do I have to do this for all my 160 Items? I want to process, without the "no data" entry blocking it

 

[Supreme]

Hey @Yupa223

Yes, you need to pass the formula in all your fields.

 

[Yupa223]

Can you check my workflow once more Ive tried to integrate the formula but im not sure how to use them. Any way you can help?

 

[Yupa223]

Are there any specific tutorials that can help me?

 

[Yupa223]

Can You tell me exactly what to do, I am a beginner.

 

[Supreme]

Seems like after mapping the data in the Excel action step you have disrupted the webhook response, so please remap the webhook response which has all the possible items and then try again.

 

[Yupa223]

How do I do that

 

[Yupa223]

Can you recheck the workflow. I captured the web hook with all the items. But one I try to process it without testing it it doesn't go through I stay stuck In the same position of it being stuck with no data. Ive already the formula to all items.

 

[Yupa223]

Can I get my trigger time shorten to as much as you can. Thank You!

 

[Supreme]

Can I get my trigger time shorten to as much as you can. Thank You!

We can reduce the polling time to a minimum of 10 minutes only for paid users from the backend.

In your case, we cannot reduce the polling time by 10 minutes as you are not a paid user of Pabbly Connect.

Can you recheck the workflow. I captured the web hook with all the items. But one I try to process it without testing it it doesn't go through I stay stuck In the same position of it being stuck with no data. Ive already the formula to all items.

Seems like you have remapped the values in the MS Excel action step and seems to be working.

 

[Yupa223]

I am confused the workflow executes. But when I check the excel sheet It doesn't show? It only updates when I recapture the web hook. How do I fix that

 

[Yupa223]

All Orders show task is executed. But when I check my Excel there's no new orders

 

[Supreme]

Please check your other thread, we have replied to your their.