I’m currently working on a module for a magento site that exports orders as they are made on the site. If anyone is trying to do the same then this list of properties may prove useful. I’m simply repeating it here because it took me so long to find and because magento themselves don’t seem to provide a reference and nor is it anywhere in the actual source code! Anyway here is the list… BILLING/SHIPPING INFO [entity_id] [entity_type_id] [attribute_set_id] [increment_id] [parent_id] [store_id] [created_at] [updated_at] [is_active] [address_type] [firstname] [lastname] [company] [street] [city] [region] [postcode] [country_id] [telephone] [fax] [region_id] FOR ORDER INFORMATION [entity_id] [entity_type_id] [attribute_set_id] [increment_id] [parent_id] [store_id] [created_at] [updated_at] [is_active] [customer_id] [tax_amount] [shipping_amount] [discount_amount] [subtotal] [grand_total] [total_paid] [total_refunded] [total_qty_ordered] [total_canceled] [total_invoiced] [total_online_refunded] [total_offline_refunded] [base_tax_amount] [base_shipping_amount] [base_discount_amount] [base_subtotal] [base_grand_total] [base_total_paid] [base_total_refunded] [base_total_qty_ordered] [base_total_canceled] [base_total_invoiced] [base_total_online_refunded] [base_total_offline_refunded] [subtotal_refunded] [subtotal_canceled] [tax_refunded] [tax_canceled] [shipping_refunded] [shipping_canceled] [base_subtotal_refunded] [base_subtotal_canceled] [base_tax_refunded] [base_tax_canceled] [base_shipping_refunded] [base_shipping_canceled] [subtotal_invoiced] [tax_invoiced] [shipping_invoiced] [base_subtotal_invoiced] [base_tax_invoiced] [base_shipping_invoiced] [shipping_tax_amount] [base_shipping_tax_amount] [shipping_tax_refunded] [base_shipping_tax_refunded] [store_to_base_rate] [store_to_order_rate] [weight] [remote_ip] [customer_email] [base_currency_code] [store_currency_code] [order_currency_code] [coupon_code] [applied_rule_ids] [shipping_method] [shipping_description] [state] [status] [store_name] [quote_id] [customer_group_id] [customer_note_notify] [customer_is_guest] [is_virtual] [gift_message_id] [email_sent] [billing_address_id] [shipping_address_id] FOR ORDER ITEMS INFORMATION [item_id] [order_id] [parent_item_id] [quote_item_id] [created_at] [updated_at] [product_id] [product_type] [product_options] [weight] [is_virtual] [sku] [name] [description] [applied_rule_ids] [additional_data] [free_shipping] [is_qty_decimal] [no_discount] [qty_backordered] [qty_canceled] [qty_invoiced] [qty_ordered] [qty_refunded] [qty_shipped] [cost] [price] [base_price] [original_price] [base_original_price] [tax_percent] [tax_amount] [base_tax_amount] [tax_invoiced] [base_tax_invoiced] [discount_percent] [discount_amount] [base_discount_amount] [discount_invoiced] [base_discount_invoiced] [amount_refunded] [base_amount_refunded] [row_total] [base_row_total] [row_invoiced] [base_row_invoiced] [row_weight] [gift_message_id] [gift_message_available] [base_tax_before_discount] [tax_before_discount]