I need a script that will do the following:
1. It will pull orders from Shopify and store them in a mySQL database.
2. It will allow me to log in and view the order, and then assign each product of that order to either Purchase Order or Drop-Ship.
3. It will create emails based on those products for each vendor as either Purchase Orders or Drop Shipments.
4. At the end of the day, I can view the pending POs or Drop-Ships and send the emails.
5. Orders will be then be marked in the system as "Sent."
6. Nothing is sent back to Shopify.
More Info and layout: [url removed, login to view]