Import orders from excel file in woocommerce

Create woocommerce order by Uploading Excel file

We have some orders from our customer that they are ordered by directly calling to us . So we have save their details in excel file with every details (customer name address etc to product name , product id , variation id , discount ,coupon details etc ).

We know how to upload data to database through excel by php code .

for a sample example

<form name="import" method="post" enctype="multipart/form-data">
    <input type="file" name="file" /><br />
    <input type="submit" name="submit" value="Submit" />
 </form>

if(isset($_POST["submit"]))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
$c = 0;

while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
{
    $name = $filesop[0];
    $email = $filesop[1];

    $sql = mysql_query("INSERT INTO order (name, email) VALUES ('$name','$email')");
}

    if($sql){
        echo "Correctly uploaded";
    }else{
        echo "it's not working";
    }

}

And we know how to fetch each and every details of product .

But please help to integrate with woocommerce . Since we noticed that each order is saved in wp_posts , with post_type='shop_order', and order status as a taxonomy named shop_order_status , customer details of order is save as post_meta field ets and we know how to use each class in woocommerce for retrieving data for example WC_Order,WC_Order_Item_Meta.

Please help to complete this . If any one can explain the basic table structure of woocommerce for inserting query through sql, it is also helpful.

Thank you .

Note : We need to create sql query . We don’t need to create
customer and customer meta table entries , because in this order the
customer who place this order is our default company customer service
account . So no need to think about customer and customer meta table .
The real customer information is added into order meta fields like
_billing_phone,_billing_email, _shipping_address_1 etc