Portal | Homepage | Blog

Amazon Orders again not showing up at POS


#1

HI guys

The following Amazon orders from yesterday still have not arrived at our POS nor have we received a Nitrosell web order email about them. Our normal web site order emails are fine.

116-4133674-0486642
112-9049680-2105809
110-1323919-3847459
109-5510001-3624257
108-8191225-4909036
107-9965303-6949005
104-9408436-4821054

bob


#3

Hi Bob,

Can you review your configuration here to make sure it’s correct, please?

http://chicagolandtoysandhobbies.com/store/administration/config_amazon.nsc?action=displaysummary

Am I right in understanding that you don’t use the ‘Order fulfillment at POS’ option because you use ShipWorks?

Regards,
Donogh


#4

Hi Donogh

Yes, that is correct.

bob


#5

Hi Bob,

Okay, thanks. I think this delay may have been our fault. We’ve been testing an update to the order handling side of the integration to commit quantities from orders that aren’t yet ready for download, using what Amazon calls the Actionable Orders Report.

It seems we inadvertently delayed order downloads since yesterday due to a bug in this test functionality. Frankly, it should not have affected your live store and I apologise for that.

The good news is that it’s ready to be released and will be tomorrow. It adds a new column to the reports called ‘Qty Committed’, which is taken from individual quantities for each SKU in the ‘Actionable Orders Report’ for orders that have yet to be downloaded by the store.

One of the quirks in Amazon’s Orders API is that, according to the MWS API support team, data is often available quicker to the Reports API. By using this Actionable Orders Report, we should get the committed quantities into the webstore quicker than if we were waiting for the orders to actually download via the Orders API. (Why is true is mysterious to say the least, but empirical evidence bears it out.)

Once we have updated the committed quantities from the Actionable Orders Report, we then immediately re-sync the data feeds, so the Inventory feed will get re-uploaded with that quantity subtracted.

We also take into account whether an order has been cancelled and doesn’t ultimately become available for download – in that case, we discard the committed quantity and reset it to where it was before the ‘unshippable’ order was placed.

The only gap in the process is the in-store quantities: there are currently no way for us to commit additional item quantities in-store without pushing down a web order. So there is still a possibility of an item selling out in store before the order gets downloaded from Amazon.

We hope to address this deficiency in future. However, for now, we believe this update will greatly enhance the accuracy of the quantities being uploaded to Amazon, especially where there is a lengthy delay in Amazon making an order available for us to download.

We’ll let you know as soon as it’s released. Sorry for the inconvenience regarding the orders that failed to download.

Kind regards,
Donogh


#6

Hi Bob,

The processing of the Actionable Orders Report is now in place and working. This should ensure more accurate quantities on Amazon, especially where they haven’t yet made an order available for download.

You can see a new column on the reports page: Qty Committed.

Next, we are going to add a filter to the reports page to show only those with positive Qty Committed values, and we are going to add a page to report on ‘Actionable Orders’.

We welcome your feedback.

Kind regards,
Donogh


#7

Hi Bob,

Quick update: the Actionable Orders Report is now available on your WSM:

http://chicagolandtoysandhobbies.com/store/administration/config_amazon.nsc?action=actionableorders

It shows both orders that have already been downloaded, as well as those in the report from Amazon that have yet to be made available for download.

Please let us know if you have any questions.

Regards,
Donogh


#8

One last update, Bob! You can now also filter the Reports page by enabling the ‘Show only items with committed quantities’ option:

So you can see all the items that need to be reserved at a glance.

Regards,
Donogh


#9

HI Donogh

Thanks for the input on this. I do see everything except the last item where I can filter the report to show only items with committed qtys. I don’t have that option :disappointed:
bob


#10

Hi Bob,

My guess is that the old JavaScript is cached in your browser. Could you try a hard refresh, please? Ctrl+F5.

Regards,
Donogh


#11

Hi Donogh

I see it was already checked off. Thanks again.

Bob