I am trying to create a standalone script to import oscommerce orders.
i know there is a tool, but it creates new tables and places the orders there.
I need the orders to be imported into the normal magento tables for orders
I am particularly looking for (in the database tables) where the order info is stored
when an order is placed
the shipping info
the billing info
the payment method
the shipping method
the shipping charge
the order total
per order, and the links (index,key) btw the tables i.e: something like order_id
ur help is appreciated.