3 ms·
My online store has an API endpoint to get order details, but they don't have a way to list orders. So to get sales numbers for last week, I had to write a scri
by jakobegger 8y ago
My online store has an API endpoint to get order details, but they don't have a way to list orders. So to get sales numbers for last week, I had to write a script that uses IMAP to log into my email account, checks the folder with order confirmation messages, parses the order numbers from the email subjects, then makes an API call for each order number to get order details. Then I get foreign exchange rates for every day of last week from a different API, put it all in a PostgreSQL database, and then I have a view that estimates weekly revenue...
- justaguyhere 8y agoWhat platform does your store use? Thanks for replying, after reading your comments, I did a quick search. There are tools like Panoply, Blendo etc, but I couldn't find many with the level of customization that you described here.
- jakobegger 8y agoI was talking about Fastspring, they run my store, and they offer the API and send order confirmation emails. The IMAP thing is just what I use to get a list of orders. (They also support webhooks for incoming orders, but that would require me to run a webservice... the IMAP hack seemed easier) Edit: I looked at Blendo, it sounds like that's kindof what I'm looking for, but it's probably cloud based and they don't even have pricing on their website ... not exactly the lightweight tool I had in mind.