How can I automatically send an SMS to customers when their ordered part arrives?

I have been trying to use some automation to help with a workflow related to parts.  We are an appliance company, and often need to order parts.  What I am looking to do is when parts arrive, we gene...