VirtueMart

I used the following to view an order:

INSERT INTO `#__vm_product` (`product_id`, `vendor_id`, `product_parent_id`, `product_sku`, `product_s_desc`, `product_desc`, `product_thumb_image`, `product_full_image`, `published`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_url`, `product_in_stock`, `product_available_date`, `product_availability`, `product_special`, `ship_code_id`, `cdate`, `mdate`, `product_name`, `product_sales`, `attribute`, `custom_attribute`, `product_unit`, `product_packaging`, `product_order_levels`, `metadesc`, `metakey`, `metarobot`, `metaauthor`, `layout`) VALUES
(17, 1, 0, 'test001', '', '<p>Test Product</p>', '', '', 1, 1.0000, 'pounds', 0.0000, 0.0000, 0.0000, 'inches', '', 1, 1258761600, '', 'Y', NULL, 1258826095, 1259719476, 'Test Product', 0, NULL, '', '', 0, NULL, '', '', '', '', '');

INSERT INTO `#__vm_product_category_xref` (`category_id`, `product_id`, `product_list`) VALUES
(1, 17, 1);

INSERT INTO `#__vm_product_mf_xref` (`product_id`, `manufacturer_id`) VALUES
(17, 1);

INSERT INTO `#__vm_product_price` (`product_price_id`, `product_id`, `product_price`, `product_currency`, `product_price_vdate`, `product_price_edate`, `cdate`, `mdate`, `shopper_group_id`, `price_quantity_start`, `price_quantity_end`, `product_override_price`) VALUES
(17, 17, 1.00000, 'USD', 0, 0, 1258826095, 1259719476, 5, 0, 0, 0);

INSERT INTO `#__vm_order_user_info` (`order_info_id`, `order_id`, `user_id`, `address_type`, `address_type_name`, `company`, `title`, `last_name`, `first_name`, `middle_name`, `phone_1`, `phone_2`, `fax`, `address_1`, `address_2`, `city`, `state`, `country`, `zip`, `email`, `extra_field_1`, `extra_field_2`, `extra_field_3`, `extra_field_4`, `extra_field_5`, `bank_account_nr`, `bank_name`, `bank_sort_code`, `bank_iban`, `bank_account_holder`, `bank_account_type`) VALUES
(1, 1, 62, 'BT', '-default-', '', 'Mr.', 'Smith', 'John', '', '555-123-1234', '', '', '1234 Some Rd.', 'Apt. 1', 'Some City', 'CA', 'USA', '12345', 'testuser@virtuemart.com', NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', 'Checking');

INSERT INTO `#__vm_orders` (`order_id`, `user_id`, `vendor_id`, `order_number`, `user_info_id`, `order_total`, `order_subtotal`, `order_tax`, `order_tax_details`, `order_shipping`, `order_shipping_tax`, `coupon_discount`, `coupon_code`, `order_discount`, `order_currency`, `order_status`, `cdate`, `mdate`, `ship_method_id`, `customer_note`, `ip_address`, `payment_method_id`) VALUES
(1, 62, 1, '70_91930ad9dbbcbdb3ceb86cf515ccf', 'c2d7127e51716480305290b403d8107b', 1.00000, 1.00000, 0.00, 'a:0:{}', 0.00, 0.00, 0.00, '', 0.00, 'USD', 'C', 1259719767, 1259719769, 'shipvalue|STD|Standard Shipping under 10000.00|0', '', '165.196.201.131', 1);

INSERT INTO `#__vm_order_history` (`order_status_history_id`, `order_id`, `order_status_code`, `date_added`, `customer_notified`, `comments`) VALUES
(1, 1, 'C', '2009-12-01 18:09:29', 0, '');

INSERT INTO `#__vm_order_item` (`order_item_id`, `order_id`, `user_info_id`, `vendor_id`, `product_id`, `order_item_sku`, `order_item_name`, `product_quantity`, `product_item_price`, `product_final_price`, `order_item_currency`, `order_status`, `cdate`, `mdate`, `product_attribute`) VALUES
(1, 1, 'c2d7127e51716480305290b403d8107b', 1, 31, 'test001', 'Test Product', 1, 1.00000, 1.00, 'USD', 'C', 1259719767, 1259719769, '');

INSERT INTO `#__vm_shopper_vendor_xref` (`user_id`, `vendor_id`, `shopper_group_id`, `customer_number`) VALUES
(62, 1, 5, '13398953924b063f1c14676');

I have to test first and then i close it ;-).