I have a client who uses custom objects to store information about buyers, consumers & associated purchases.
Right now there are two types of leads (defined by the "Purchase Status" field, populated from the external DB): Buyers (those who make a purchase) and Consumers (those who created a Purchase Order).
There are also two first-level custom objects: a Purchase Order (linked to Consumer who needs buyer(s) to buy something for him) and a Purchase (linked to the Buyer, who made a purchase for a specific PO. It contains all info about the purchase, as well as "fulfilment %" for the purchase order) .
What I need to do: I need to send an alert email to every buyer, who contributed to the purchase order when "fulfilment %" reaches 30%/50%/60%/90%, etc.. Right now the way this works is that we have a daily batch campaign sending email to everyone who has a Purchase record with "fulfilment %" = 30/50/90%. For that to work we have to update each purchase record's "fulfilment %" via API every time a new purchase is made for the same PO.
Problem: new purchases are happening daily and there are thousands of them - we have already exhausted our API limit, so we have to limit purchase record updates by date, so we aren't really sending all the notifications we need.
Any ideas on how to solve this? So far I've come up only with an idea to raise the API limit. I was thinking that possibly second-level custom objects could help, but I can't quite tackle this yet.