I am about to start building a module to manage client services. Based on what the client purchased, those steps can vary. For example,
- get code from client
- send code to vendor
- get serial number from vendor
- send serial number to client
- get a list of names from client
- send names to engraver
- get product back from engraver
- send product to client
There could be as many as 15-20 steps in the process depending upon the product purchased.
What I am trying to figure out is the best way to manage the process using mysql and PHP. So, far what I am thinking is creating a table (customer_service_process) with all the many possible steps for all products. Then for each product I could have a field for the steps necessary for that specific product. Then I could pull the 'customer_service_process' record for the client and see which steps were necessary for their product and step through the process. This would work, but seems a little inefficient site I could have many unnecessary fields for each client. Also not a great idea if a new product is added and a new step in the process is required.
Any experts with experience building something like this? Any suggestions on how best to manage this?
Thanks in advance for your time in giving me some input on this project.