how to change order numbering from alpha numberic

How do I change the order numbering from alphanumberic to just numeric?

I see under config

Order

Order Number Format {automatic_code}

I believe that I'll need to clear out the orders from virtuemart and re import them, can you give clear directions on how to remove past orders and re import them from virtuemart database?

Joomla

You can use the format: {id}
And that will use the id of the order instead of the alphanumeric code.

If you want to set the order number to the order id it will be easier to simply run a query to update it via phpmyadmin than redoing the import. The query to use is:
UPDATE #__hikashop_order SET order_number=order_id WHERE 1;

where #__ is the prefix of your tables

Thank you for your reply, just to clarify I need to change order number format from {automatic_code} to {id} ??

And then do the same for the Invoice number format??

Yes.

I did the query worked great, had a error the first go, but it took the second time.

UPDATE #__hikashop_order SET order_number=order_id WHERE 1;

I didn't notice the second _ removed it and all is swell.

Thanks things are working a little better now.