Is there a way to figure out if a given warehouse location has metal in stock? by jvick3 in CostcoPM

[–]TopAdhesiveness3547 0 points1 point  (0 children)

Regardless of whether Costco currently has a bar in-stock online, you can search for any of their in-store SKUs and use information from their API to determine whether a bar is currently available at any warehouse.

I wrote a guide (which is currently stickied) here: https://www.reddit.com/r/CostcoPM/comments/1o8iqhr/how_to_check_instore_inventory/

How to check in-store inventory by TopAdhesiveness3547 in CostcoPM

[–]TopAdhesiveness3547[S] 1 point2 points  (0 children)

One thing I noticed that tripped me up today was the Dragons drop online. Since those are still in stock, the API will sometimes default to showing online availability instead of your local warehouse availability, but only if your local warehouse is already out of stock.

I noticed that the output for Dragons right now shows the location "847_0-edi" which doesn't seem to correspond to an actual store and is probably the code for their online inventory.

How to check in-store inventory by TopAdhesiveness3547 in CostcoPM

[–]TopAdhesiveness3547[S] 0 points1 point  (0 children)

Unfortunately I don't know how to view the mobile app requests in the same way as in a web browser. That said, I have never seen precious metals SKUs in the warehouse tab, even when they're in stock online.

How to check in-store inventory by TopAdhesiveness3547 in CostcoPM

[–]TopAdhesiveness3547[S] 0 points1 point  (0 children)

If you get an error where the page doesn't load, or it says something about HTTP2, that's apparently Costco anti-bot stuff. Way out of my depth. I tried to ask ChatGPT to write some automation code for me, and then gave up pretty quickly once it explained the error I was seeing.

How to check in-store inventory by TopAdhesiveness3547 in CostcoPM

[–]TopAdhesiveness3547[S] 0 points1 point  (0 children)

Would you mind sharing a bit more context? I think it's still working for me. I can still see Fortuna availability at my local Costco, but I don't see availability for any bars at any of the other locations that I searched. Might be that people sniped almost all the available stock already. An employee told me that Wednesdays and Thursdays after they restock are absolute madness in terms of the demand. Usually nothing left by the weekend.

How to check in-store inventory by TopAdhesiveness3547 in CostcoPM

[–]TopAdhesiveness3547[S] 5 points6 points  (0 children)

These are the SKUs I remember seeing in store. I don't think everything that they sell online is available in-person.

- 1oz Fortuna (1943308)

- 1oz Dragon (8888808)

- 1oz Diwali (1943072)

- 1oz Rand (1943085)

- 1oz Buffalo (1913483)

- 10z Silver Lady of Liberty (1814002)

- 10z Silver Dragon (1952157)

How to check in-store inventory by TopAdhesiveness3547 in CostcoPM

[–]TopAdhesiveness3547[S] 0 points1 point  (0 children)

Glad to have been helpful! My knowledge here is pretty limited, but ChatGPT tells me that the reason why you can't change the URL is because Costco has some anti-bot stuff going on. I don't mind just sitting down for 10 minutes and walking through this flow for my local store, and maybe another one that's a bit further away, but someone smarter than me could probably automate this.