API returned "available" quantity doesn't match website

GraphQL API
1

We have a problem with the inventory graphQL API report, that for certain SKU item, the “available” returned in GraphQL API doesn’t match what’s shown on website UI. For example, website says
Allocated = 1
OnHand = 134
Available = 133

However, in the GraphQL response, “available” = 134 between all the locations even though it should be 133.

Any idea why this is?

2

Hi @pei_cribsi

I can investigate this issue.
Please provide the account_id and the SKU showing the discrepancy.
Also, just to confirm, you are talking about the inventory snapshot report, correct?

Have a nice day!

3

Account ID: 60549SF291573
SKU:FTN-HBX-ID2
Note that this is not an issue now anymore, but has been an issue yesterday and about 4 days before.

Thanks!
Pei

4

Hello, just checking if there’s any update?

5

Hi,

I replied on the community website with below info two days ago:

Account ID: 60549SF291573
SKU:FTN-HBX-ID2
Note that this is not an issue now anymore, but has been an issue yesterday and about 4 days before.

Haven’t heard back. Any update? Thanks.

Pei

H

6

Hi @pei_cribsi

I checked the inventory snapshot of the 29th, and while looking at the inventory log in the UI, I found that the ABE warehouse had one unit in transit due to a load balance from the 25th.
If you have a live example, please provide it, and I’ll keep digging. Otherwise, that would be the reason.

Have a nice day!

7

Thanks for the info @Luisperrone . Is the “in_transit” value available anywhere in API so we can grab? An old discussion at Get information about products in transit - #10 by sh-agent says it wasn’t back then. Is it available now?

8

Hi @pei_cribsi

Unfortunately, that field has not been implemented, and I see the feature request was not approved.
I’ll ask the product team again to consider adding it again.

9

Got it. Thanks. Appreciate your effort of pushing this forward.

10

Not a problem.

Have a nice day!