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]
[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]
[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]
[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]