We have a number of "dealer" type customers that submit surveys for equipment they might need, as well as an order containing the equipment to meet the survey requirements. What we'd like to do is, once we've reviewed the site survey, generate an order for that particular customer, and then send a URL so they can review it.
I want to generate the order from a different (C# MVC5 based) administration system by making appropriate entries directly in the SmartStore SQL database.
What tables do I need to add row to? Is there a stored procedure that I can use to simplify matters?
Many thanks in advance for any guidance.