arctic-product-prices

[earnest arch]

Hi 👋
So you have the Product ID and want to retrieve the price?

[pulsar dove]

yes

exactly

[earnest arch]

The Price List API accepts a product ID as a parameter: https://stripe.com/docs/api/prices/list

[pulsar dove]

ohh thank you

love your guys support

so fast and accurate

hope you have a great day

[earnest arch]

Sure thing, it's non-obvious so I get it. But since we allow multiple prices for a single product the relationship goes the other way (price has product ID)

Happy to help 🙂

[pulsar dove]

I see !

so im building an admin panel to manage our products, should i make a call to list all prices for every product or will that get me rate limited?

[earnest arch]

Depends on how many products you have. Also whether you can cache the results or not.

[pulsar dove]

hmm i see, okay maybe ill just retrieve the prices once and put them in our relational database then

since there will be only 1 price per product

[earnest arch]

FWIW I have a test integration running that uses webhook events to keep all my DB data in sync with Stripe. That's been a pretty useful way to reduce the API calls.

[half flower]

arctic-product-prices

[pulsar dove]

damn im interested in this

im building that right now

[earnest arch]

I use an async queue system that handles the DB actions to ensure I send a success message back immediately.

[pulsar dove]

what stack are you using? im on nextjs, using prisma + mysql for my db

i am build an UI right now to add products and prices that adds them to stripe and my database

so i can retrieve the data from my own database

[earnest arch]

I'm going off-shift but I've been using Python & Celery for an async task queue.
Whichever stack you choose there should be some sort of queue option. Best of luck 👋

[pulsar dove]

enjoy your off-shift