Hello! Anyone else on Amazon Marketplace and connected via Celigo? There's sometimes a lag between when an order has shipped vs when Amazon decides to actually release the order and send it to us because of payment issues. The business can't seem to understand why if an order has shipped, it won't come in the system. I understand it's a limitation with how the order release is setup with Amazon, but wondering if this payment lag issue happened to anyone else and what you guys did to resolve it, if at all?

Yes I've seen this payment lag many times. Usually I just leave the error in the settlement flow as unresolved until the next settlement then retry it at that time

@MGBC the issue isn't outstanding errors it's the fact that business is trying to do real time reporting and analytics and they can't do that if we don't even get the shipped orders until sometimes up to 120 days after the fact they shipped because there was a payment issue. That's why I'm wondering how have other business's handled this? Do you take amazon out of netsuite? Is there a better answer to give the c-suite to help them understand?

I guess I'm not understanding the scenario. You're saying the order is not shipped and not paid on Amazon? But you still want it to show up in NetSuite?

@MGBC No the order is shipped in amazon but there is some kind of payment processing issue on the Amazon end. This is going to be said it not the most eloquent way but basically I know we don't get orders into NetSuite if they are in "pending state" in amazon seller central. An order pending this long usually means Amazon had an issue with the payment and is giving the buyer a chance to resolve the issue. On the order page itself in seller central it doesn't provide any of the payment information but Irene pulled the payment report for me. The date the order is created in NetSuite at least in the sample I'm looking at is within 24 hours of that payment date. It's FBA

Hmm, interesting....this sounds like a configuration or setting change. Most accounts we've worked with the shipped orders come into Netsuite regardless of if they are pending payment or not

@MGBC yeah it's the opposite issue for us. the settlement order application will get an error because the order doesn't exist in NetSuite. Then when I try to manually grab the individual order the error is that the order is in Pending Review State and amazon doesn't allow us to bring in the order

The Celigo flow that brings FBA orders to NetSuite filters to orders that are in "Shipped" status. I'm guessing this type of order would still be in some "Pending" status and thus we don't pull it. If you really wanted to, you could build your own flow to pull in orders and say you want pending orders along with shipped orders. I'm not sure what tool you're using for reporting and analytics, but assuming it's NSAW, Snowflake, some BI tool, you could just build a flow that brings pending orders to it and report from that data vs having to recreate all the logic built into the Celigo IA that imports orders.

@Tyler Lamparter We use snowflake for reporting. Yeah just trying to get a gauge on what other companies do to handle this. It's very high volume on amazon. We have netsuite data flowing into the data warehouse. Amazon, shopify, etc all flow into netsuite and flow into the warehouse as well

Gotcha, in that case you are relying on the orders being in NetSuite so if you separately bring the orders directly to Snowflake then you can report off of it and add filters for "is in netsuite", "netsuite status", "amazon status", etc.