Let me specify from the outset, this applies to SharePoint 2013 Foundation (thus, 2010 workflows). Additionally, i'd like to thank in advance anyone that takes the time to help me.
I've been tasked with setting up a document library for our Vendor's quotes and a workflow that will send out emails based on when those quotes were uploaded to the library. To be specific, each vendor's - of which there are 27 - quotes expire at different times. For example, vendor A's quotes expire in 30 days, while vendor B's quotes may expire in a year. My goal is for the email to pause for 20 days in the case of vendor A, and 355 days in the case of vendor B (leaving our purchasing team 10 days of leeway to act before the quote expires). The email also should link to the quote in question, and be unique to the vendor, i.e. vendor A will get an email about a vendor A quote expiring, and link to the [%Current Item:URL Path%], while vendor B, C, etc. will have the same thing.
Unfortunately, my attempts haven't worked yet, but I'll go over what I have tried for the workflow:
I created a column in the document library so each vendor is specified when a document is uploaded, and a folder for each vendor in the document library into which the users put their quotes.
The workflow was originally all in one step, but I've since separated it into individual steps for each vendor, but the same issue happens so it doesn't seem to matter.
The workflow itself is as follows:
Step 1 If Current Item:Vendor equal Vendor A Pause for 20 days then email relevant parties (with a message that a vendor A quote is near expiration and a link to the item)
Step 2 If Current Item:Vendor equal Vendor B Pause for 355 days then email relevant parties (with a message that a vendor B quote is near expiration and a link to the item)
Etc. for the remaining 25 vendors.
As is, the correct emails are being sent, and it seems to be linking the correct item but it's also sending too many emails. Specifically, while the email for Vendor B is eventually sent, I will ALWAYS get vendor A's email first (for all vendors/items uploaded to the document library despite them not being a vendor A item) but it still links to the correct item.
I've discovered that perhaps having multiple items paused for days/weeks/months is probably not the best course of action “Pause until” in workflow 2010. Please advise if this would become an issue, too.
As is, I'm stuck folks. Any ideas on how I can achieve the desired outcome?