Hi,
I’m making an expiration_lots query to see how many units expire at what time. The lots have an expiration date and SKU, but how do I know how many units of that SKU are expiring at that date?
Hey @harsha,
Thanks for reaching out and welcome to our Developer Community!
I’ve started looking into this inquiry, I’ll have an update for you shortly.
Best,
RayanP
Hey @harsha,
Thanks for hanging in there!
Unfortunately, I wasn’t able to find a way to return the quantity through the expiration lots query. I will go ahead and pass along your feedback to the team.
Please let me know if you have any questions or concerns.
Best,
RayanP
Hello, is there any update on this?
Hey @rypaul12,
There is no straightforward way at the moment, you can get the locations for that sku/expiration lot, but you would need to query the quanities per location for it some other way. For example, fro warehouse_products
you can get the quantity per bin, and then match it.
Have a great day!