Home » Best Magento Extensions » Magento EXCEL invoice, shipment, credit memo

Magento EXCEL invoice, shipment, credit memo

 

If you need additional data to appear on your invoices, or you need to adapt invoices to your business practices, then the templates are right for you. You can easily customize the contents of invoices to meet your business requirements.

Templates can be easily customized in Microsoft Excel 2003+ or OpenOffice. You can start with commented templates supplied with the module. For ease of work, a tuning template is available, which displays the source data. You can get an overview of usable data, even if you want to use your own added data.

Demo:

EXCEL creditmemo sample:
creditmemo_2_1347625448.xls
EXCEL invoice sample:
invoice_2_1347716319.xls
invoice_atkart.xls
invoice_kidzarella.xls
EXCEL shipment sample:
shipment_2_1347625437.xls

Magento admin: http://demo2.ecommerceoffice.com/admin/ [login:demo123 \ password:demo123]

XLS Invoice 1.1.3 new features!

Decimal help fuction added – Format a number with grouped thousands. {{xls.invoice.XXX.decimal.Y}}

Example:
{{xls.invoice.shipping_tax_amount}} will display 1002.01

XLS Invoice 1.1.2 features!

Now you can add custom attributes for your Invoices,Shipments and Credit Memos. So your clients will see addtional information like county of origin or varrianty directly in document

 XLS Invoice 1.1.1 features:

You can you following functions to format invoice and order varables
round {{pdf.invoice.XXX.round}}
day {{pdf.invoice.XXX.day}}
month {{pdf.invoice.XXX.month}}
year {{pdf.invoice.XXX.year}}
round {{pdf.order.XXX.round}}
day {{pdf.order.XXX.day}}
month {{pdf.order.XXX.month}}
year {{pdf.order.XXX.year}}

Example:
{{pdf.invoice.shipping_tax_amount}} will display 1002.01
{{pdf.invoice.shipping_tax_amount.round}} will display 1002

General:
– Order data access through snippets, go to snippets
– Invoice data access through snippets, go to invoice snippets
– Ordered product data access through snippets, go to product snippets
– Billing data access through snippets, go to billing snippets
– Shipping data access through snippets, go to shipping snippets
– Excel invoices, shipments, credit memos support
– Magento variables support
– Magento static blocks\snippets support
– Generate Exceldocuments compliant with Microsoft Excel XP,2003,2007,2010 and OpenOffice
– HTML, text, images support
– Full support for UTF-8
– Multilingual support – English, Português, ไทย, Español, Руcский, 한국어, Français, Deutsch, 中文, العربية, etc..

Compatibility:
– Magento™ CE 1.3.x, 1.4.x, 1.5.x, 1.6.x, 1.7.x
– Magento™ EE 1.8.x, 1.9.x, 1.10.x, 1.11.x, 1.12.x
– No Magento™ patching required, no core files modifications
Features:
– Free support guarantee
– Free upgrades guarantee
– Easy to install, easy to upgrade, just copy to use
– User-friendly and flexible configuration
– Easy customizable front-end via wysiwyg – no coding!
– 100% open-source
Installation:
– Easy integration, no installation or setup is necessary on the server. All you have to do is upload your files
Support:
– Email support for our clients
– Free upgrades at least in current version branch
– Free installation by request
– Free high priority new feature development by request
– Free high priority technical support

Invoice snippets:

  • entity_id = {{pdf.invoice.entity_id}}
  • store_id = {{pdf.invoice.store_id}}
  • base_grand_total = {{pdf.invoice.base_grand_total}}
  • shipping_tax_amount = {{pdf.invoice.shipping_tax_amount}}
  • tax_amount = {{pdf.invoice.tax_amount}}
  • base_tax_amount = {{pdf.invoice.base_tax_amount}}
  • store_to_order_rate = {{pdf.invoice.store_to_order_rate}}
  • base_shipping_tax_amount = {{pdf.invoice.base_shipping_tax_amount}}
  • base_discount_amount = {{pdf.invoice.base_discount_amount}}
  • base_to_order_rate = {{pdf.invoice.base_to_order_rate}}
  • grand_total = {{pdf.invoice.grand_total}}
  • shipping_amount = {{pdf.invoice.shipping_amount}}
  • subtotal_incl_tax = {{pdf.invoice.subtotal_incl_tax}}
  • base_subtotal_incl_tax = {{pdf.invoice.base_subtotal_incl_tax}}
  • store_to_base_rate = {{pdf.invoice.store_to_base_rate}}
  • base_shipping_amount = {{pdf.invoice.base_shipping_amount}}
  • total_qty = {{pdf.invoice.total_qty}}
  • base_to_global_rate = {{pdf.invoice.base_to_global_rate}}
  • subtotal = {{pdf.invoice.subtotal}}
  • base_subtotal = {{pdf.invoice.base_subtotal}}
  • discount_amount = {{pdf.invoice.discount_amount}}
  • billing_address_id = {{pdf.invoice.billing_address_id}}
  • is_used_for_refund = {{pdf.invoice.is_used_for_refund}}
  • order_id = {{pdf.invoice.order_id}}
  • email_sent = {{pdf.invoice.email_sent}}
  • can_void_flag = {{pdf.invoice.can_void_flag}}
  • state = {{pdf.invoice.state}}
  • shipping_address_id = {{pdf.invoice.shipping_address_id}}
  • cybersource_token = {{pdf.invoice.cybersource_token}}
  • store_currency_code = {{pdf.invoice.store_currency_code}}
  • transaction_id = {{pdf.invoice.transaction_id}}
  • order_currency_code = {{pdf.invoice.order_currency_code}}
  • base_currency_code = {{pdf.invoice.base_currency_code}}
  • global_currency_code = {{pdf.invoice.global_currency_code}}
  • increment_id = {{pdf.invoice.increment_id}}
  • created_at = {{pdf.invoice.created_at}}
  • updated_at = {{pdf.invoice.updated_at}}
  • customer_id = {{pdf.invoice.customer_id}}
  • invoice_status_id = {{pdf.invoice.invoice_status_id}}
  • invoice_type = {{pdf.invoice.invoice_type}}
  • is_virtual = {{pdf.invoice.is_virtual}}
  • real_order_id = {{pdf.invoice.real_order_id}}
  • total_due = {{pdf.invoice.total_due}}
  • total_paid = {{pdf.invoice.total_paid}}
  • hidden_tax_amount = {{pdf.invoice.hidden_tax_amount}}
  • base_hidden_tax_amount = {{pdf.invoice.base_hidden_tax_amount}}
  • shipping_hidden_tax_amount = {{pdf.invoice.shipping_hidden_tax_amount}}
  • base_shipping_hidden_tax_amount = {{pdf.invoice.base_shipping_hidden_tax_amount}}
  • shipping_incl_tax = {{pdf.invoice.shipping_incl_tax}}
  • base_shipping_incl_tax = {{pdf.invoice.base_shipping_incl_tax}}
  • base_total_refunded = {{pdf.invoice.base_total_refunded}}

Order snippets:

  • entity_id = {{pdf.order.entity_id}}
  • state = {{pdf.order.state}}
  • status = {{pdf.order.status}}
  • coupon_code = {{pdf.order.coupon_code}}
  • protect_code = {{pdf.order.protect_code}}
  • shipping_description = {{pdf.order.shipping_description}}
  • is_virtual = {{pdf.order.is_virtual}}
  • store_id = {{pdf.order.store_id}}
  • customer_id = {{pdf.order.customer_id}}
  • base_discount_amount = {{pdf.order.base_discount_amount}}
  • base_discount_canceled = {{pdf.order.base_discount_canceled}}
  • base_discount_invoiced = {{pdf.order.base_discount_invoiced}}
  • base_discount_refunded = {{pdf.order.base_discount_refunded}}
  • base_grand_total= {{pdf.order.base_grand_total}}
  • base_shipping_amount = {{pdf.order.base_shipping_amount}}
  • base_shipping_canceled = {{pdf.order.base_shipping_canceled}}
  • base_shipping_invoiced = {{pdf.order.base_shipping_invoiced}}
  • base_shipping_refunded = {{pdf.order.base_shipping_refunded}}
  • base_shipping_tax_amount = {{pdf.order.base_shipping_tax_amount}}
  • base_shipping_tax_refunded = {{pdf.order.base_shipping_tax_refunded}}
  • base_subtotal = {{pdf.order.base_subtotal}}
  • base_subtotal_canceled = {{pdf.order.base_subtotal_canceled}}
  • base_subtotal_invoiced = {{pdf.order.base_subtotal_invoiced}}
  • base_subtotal_refunded = {{pdf.order.base_subtotal_refunded}}
  • base_tax_amount = {{pdf.order.base_tax_amount}}
  • base_tax_canceled = {{pdf.order.base_tax_canceled}}
  • base_tax_invoiced = {{pdf.order.base_tax_invoiced}}
  • base_tax_refunded = {{pdf.order.base_tax_refunded}}
  • base_to_global_rate = {{pdf.order.base_to_global_rate}}
  • base_to_order_rate = {{pdf.order.base_to_order_rate}}
  • base_total_canceled = {{pdf.order.base_total_canceled}}
  • base_total_invoiced = {{pdf.order.base_total_invoiced}}
  • base_total_invoiced_cost = {{pdf.order.base_total_invoiced_cost}}
  • base_total_offline_refunded = {{pdf.order.base_total_offline_refunded}}
  • base_total_online_refunded = {{pdf.order.base_total_online_refunded}}
  • base_total_paid = {{pdf.order.base_total_paid}}
  • base_total_qty_ordered = {{pdf.order.base_total_qty_ordered}}
  • base_total_refunded = {{pdf.order.base_total_refunded}}
  • discount_amount = {{pdf.order.discount_amount}}
  • discount_canceled = {{pdf.order.discount_canceled}}
  • discount_invoiced = {{pdf.order.discount_invoiced}}
  • discount_refunded = {{pdf.order.discount_refunded}}
  • grand_total = {{pdf.order.grand_total}}
  • shipping_amount = {{pdf.order.shipping_amount}}
  • shipping_canceled = {{pdf.order.shipping_canceled}}
  • shipping_invoiced = {{pdf.order.shipping_invoiced}}
  • shipping_refunded = {{pdf.order.shipping_refunded}}
  • shipping_tax_amount = {{pdf.order.shipping_tax_amount}}
  • shipping_tax_refunded = {{pdf.order.shipping_tax_refunded}}
  • store_to_base_rate = {{pdf.order.store_to_base_rate}}
  • store_to_order_rate = {{pdf.order.store_to_order_rate}}
  • subtotal = {{pdf.order.subtotal}}
  • subtotal_canceled = {{pdf.order.subtotal_canceled}}
  • subtotal_invoiced = {{pdf.order.subtotal_invoiced}}
  • subtotal_refunded = {{pdf.order.subtotal_refunded}}
  • tax_amount = {{pdf.order.tax_amount}}
  • tax_canceled = {{pdf.order.tax_canceled}}
  • tax_invoiced = {{pdf.order.tax_invoiced}}
  • tax_refunded = {{pdf.order.tax_refunded}}
  • total_canceled = {{pdf.order.total_canceled}}
  • total_invoiced = {{pdf.order.total_invoiced}}
  • total_offline_refunded = {{pdf.order.total_offline_refunded}}
  • total_online_refunded = {{pdf.order.total_online_refunded}}
  • total_paid = {{pdf.order.total_paid}}
  • total_qty_ordered = {{pdf.order.total_qty_ordered}}
  • total_refunded = {{pdf.order.total_refunded}}
  • can_ship_partially = {{pdf.order.can_ship_partially}}
  • can_ship_partially_item = {{pdf.order.can_ship_partially_item}}
  • customer_is_guest = {{pdf.order.customer_is_guest}}
  • customer_note_notify = {{pdf.order.customer_note_notify}}
  • billing_address_id = {{pdf.order.billing_address_id}}
  • customer_group_id = {{pdf.order.customer_group_id}}
  • edit_increment = {{pdf.order.edit_increment}}
  • email_sent = {{pdf.order.email_sent}}
  • forced_do_shipment_with_invoice = {{pdf.order.forced_do_shipment_with_invoice}}
  • gift_message_id = {{pdf.order.gift_message_id}}
  • payment_authorization_expiration = {{pdf.order.payment_authorization_expiration}}
  • paypal_ipn_customer_notified = {{pdf.order.paypal_ipn_customer_notified}}
  • quote_address_id = {{pdf.order.quote_address_id}}
  • quote_id = {{pdf.order.quote_id}}
  • shipping_address_id = {{pdf.order.shipping_address_id}}
  • adjustment_negative = {{pdf.order.adjustment_negative}}
  • adjustment_positive = {{pdf.order.adjustment_positive}}
  • base_adjustment_negative = {{pdf.order.base_adjustment_negative}}
  • base_adjustment_positive = {{pdf.order.base_adjustment_positive}}
  • base_shipping_discount_amount = {{pdf.order.base_shipping_discount_amount}}
  • base_subtotal_incl_tax = {{pdf.order.base_subtotal_incl_tax}}
  • base_total_due = {{pdf.order.base_total_due}}
  • payment_authorization_amount = {{pdf.order.payment_authorization_amount}}
  • shipping_discount_amount = {{pdf.order.shipping_discount_amount}}
  • subtotal_incl_tax = {{pdf.order.subtotal_incl_tax}}
  • total_due = {{pdf.order.total_due}}
  • weight = {{pdf.order.weight}}
  • customer_dob = {{pdf.order.customer_dob}}
  • increment_id = {{pdf.order.increment_id}}
  • applied_rule_ids = {{pdf.order.applied_rule_ids}}
  • base_currency_code = {{pdf.order.base_currency_code}}
  • customer_email = {{pdf.order.customer_email}}
  • customer_firstname = {{pdf.order.customer_firstname}}
  • customer_lastname = {{pdf.order.customer_lastname}}
  • customer_middlename = {{pdf.order.customer_middlename}}
  • customer_prefix = {{pdf.order.customer_prefix}}
  • customer_suffix = {{pdf.order.customer_suffix}}
  • customer_taxvat = {{pdf.order.customer_taxvat}}
  • discount_description = {{pdf.order.discount_description}}
  • ext_customer_id = {{pdf.order.ext_customer_id}}
  • ext_order_id = {{pdf.order.ext_order_id}}
  • global_currency_code = {{pdf.order.global_currency_code}}
  • hold_before_state = {{pdf.order.hold_before_state}}
  • hold_before_status = {{pdf.order.hold_before_status}}
  • order_currency_code = {{pdf.order.order_currency_code}}
  • original_increment_id = {{pdf.order.original_increment_id}}
  • relation_child_id = {{pdf.order.relation_child_id}}
  • relation_child_real_id = {{pdf.order.relation_child_real_id}}
  • relation_parent_id = {{pdf.order.relation_parent_id}}
  • relation_parent_real_id = {{pdf.order.relation_parent_real_id}}
  • remote_ip = {{pdf.order.remote_ip}}
  • shipping_method = {{pdf.order.shipping_method}}
  • store_currency_code = {{pdf.order.store_currency_code}}
  • store_name = {{pdf.order.store_name}}
  • x_forwarded_for = {{pdf.order.x_forwarded_for}}
  • customer_note = {{pdf.order.customer_note}}
  • created_at = {{pdf.order.created_at}}
  • updated_at = {{pdf.order.updated_at}}
  • total_item_count = {{pdf.order.total_item_count}}
  • customer_gender = {{pdf.order.customer_gender}}
  • base_custbalance_amount = {{pdf.order.base_custbalance_amount}}
  • currency_base_id = {{pdf.order.currency_base_id}}
  • currency_code = {{pdf.order.currency_code}}
  • currency_rate = {{pdf.order.currency_rate}}
  • custbalance_amount = {{pdf.order.custbalance_amount}}
  • is_hold = {{pdf.order.is_hold}}
  • is_multi_payment = {{pdf.order.is_multi_payment}}
  • real_order_id = {{pdf.order.real_order_id}}
  • tax_percent = {{pdf.order.tax_percent}}
  • tracking_numbers = {{pdf.order.tracking_numbers}}
  • hidden_tax_amount = {{pdf.order.hidden_tax_amount}}
  • base_hidden_tax_amount = {{pdf.order.base_hidden_tax_amount}}
  • shipping_hidden_tax_amount = {{pdf.order.shipping_hidden_tax_amount}}
  • base_shipping_hidden_tax_amount = {{pdf.order.base_shipping_hidden_tax_amount}}
  • hidden_tax_invoiced = {{pdf.order.hidden_tax_invoiced}}
  • base_hidden_tax_invoiced = {{pdf.order.base_hidden_tax_invoiced}}
  • hidden_tax_refunded = {{pdf.order.hidden_tax_refunded}}
  • base_hidden_tax_refunded ={{pdf.order.base_hidden_tax_refunded}}

Ordered items snippets:

  • {{xls.item.order_id}}
  • {{xls.item.parent_item_id}}
  • {{xls.item.quote_item_id}}
  • {{xls.item.store_id}}
  • {{xls.item.created_at}}
  • {{xls.item.updated_at}}
  • {{xls.item.product_id}}
  • {{xls.item.product_type}}
  • {{xls.item.product_options}}
  • {{xls.item.weight}}
  • {{xls.item.is_virtual}}
  • {{xls.item.sku}}
  • {{xls.item.name}}
  • {{xls.item.description}}
  • {{xls.item.applied_rule_ids}}
  • {{xls.item.additional_data}}
  • {{xls.item.free_shipping}}
  • {{xls.item.is_qty_decimal}}
  • {{xls.item.no_discount}}
  • {{xls.item.qty_backordered}}
  • {{xls.item.qty_canceled}}
  • {{xls.item.qty_invoiced}}
  • {{xls.item.qty_ordered}}
  • {{xls.item.qty_refunded}}
  • {{xls.item.qty_shipped}}
  • {{xls.item.base_cost}}
  • {{xls.item.price}}
  • {{xls.item.base_price}}
  • {{xls.item.original_price}}
  • {{xls.item.base_original_price}}
  • {{xls.item.tax_percent}}
  • {{xls.item.tax_amount}}
  • {{xls.item.base_tax_amount}}
  • {{xls.item.tax_invoiced}}
  • {{xls.item.base_tax_invoiced}}
  • {{xls.item.discount_percent}}
  • {{xls.item.discount_amount}}
  • {{xls.item.base_discount_amount}}
  • {{xls.item.discount_invoiced}}
  • {{xls.item.base_discount_invoiced}}
  • {{xls.item.amount_refunded}}
  • {{xls.item.base_amount_refunded}}
  • {{xls.item.row_total}}
  • {{xls.item.base_row_total}}
  • {{xls.item.row_invoiced}}
  • {{xls.item.base_row_invoiced}}
  • {{xls.item.row_weight}}
  • {{xls.item.gift_message_id}}
  • {{xls.item.gift_message_available}}
  • {{xls.item.base_tax_before_discount}}
  • {{xls.item.tax_before_discount}}
  • {{xls.item.weee_tax_applied}}
  • {{xls.item.weee_tax_applied_amount}}
  • {{xls.item.weee_tax_applied_row_amount}}
  • {{xls.item.base_weee_tax_applied_amount}}
  • {{xls.item.base_weee_tax_applied_row_amnt}}
  • {{xls.item.weee_tax_disposition}}
  • {{xls.item.weee_tax_row_disposition}}
  • {{xls.item.base_weee_tax_disposition}}
  • {{xls.item.base_weee_tax_row_disposition}}
  • {{xls.item.ext_order_item_id}}
  • {{xls.item.locked_do_invoice}}
  • {{xls.item.locked_do_ship}}
  • {{xls.item.price_incl_tax}}
  • {{xls.item.base_price_incl_tax}}
  • {{xls.item.row_total_incl_tax}}
  • {{xls.item.base_row_total_incl_tax}}
  • {{xls.item.hidden_tax_amount}}
  • {{xls.item.base_hidden_tax_amount}}
  • {{xls.item.hidden_tax_invoiced}}
  • {{xls.item.base_hidden_tax_invoiced}}
  • {{xls.item.hidden_tax_refunded}}
  • {{xls.item.base_hidden_tax_refunded}}
  • {{xls.item.is_nominal}}
  • {{xls.item.tax_canceled}}
  • {{xls.item.hidden_tax_canceled}}
  • {{xls.item.tax_refunded}}

Billing snippets:

  • {{xls.billing.entity_id}}
  • {{xls.billing.parent_id}}
  • {{xls.billing.customer_address_id}}
  • {{xls.billing.quote_address_id}}
  • {{xls.billing.region_id}}
  • {{xls.billing.customer_id}}
  • {{xls.billing.fax}}
  • {{xls.billing.region}}
  • {{xls.billing.postcode}}
  • {{xls.billing.lastname}}
  • {{xls.billing.street}}
  • {{xls.billing.city}}
  • {{xls.billing.email}}
  • {{xls.billing.telephone}}
  • {{xls.billing.country_id}}
  • {{xls.billing.firstname}}
  • {{xls.billing.address_type}}
  • {{xls.billing.prefix}}
  • {{xls.billing.middlename}}
  • {{xls.billing.suffix}}
  • {{xls.billing.company}}
  • {{xls.billing.address_id}}
  • {{xls.billing.gift_message_id}}
  • {{xls.billing.tax_id}}

Shipping snippets:

  • {{xls.shipping.entity_id}}
  • {{xls.shipping.parent_id}}
  • {{xls.shipping.customer_address_id}}
  • {{xls.shipping.quote_address_id}}
  • {{xls.shipping.region_id}}
  • {{xls.shipping.customer_id}}
  • {{xls.shipping.fax}}
  • {{xls.shipping.region}}
  • {{xls.shipping.postcode}}
  • {{xls.shipping.lastname}}
  • {{xls.shipping.street}}
  • {{xls.shipping.city}}
  • {{xls.shipping.email}}
  • {{xls.shipping.telephone}}
  • {{xls.shipping.country_id}}
  • {{xls.shipping.firstname}}
  • {{xls.shipping.address_type}}
  • {{xls.shipping.prefix}}
  • {{xls.shipping.middlename}}
  • {{xls.shipping.suffix}}
  • {{xls.shipping.company}}
  • {{xls.shipping.address_id}}
  • {{xls.shipping.gift_message_id}}
  • {{xls.shipping.tax_id}}

Check Also

What makes Magento extensions be one of the best online store development platforms

What makes Magento extensions be one of the best online store development platforms?

Life has been changing and the way we shopping is now totally different from the …

CLOSE
CLOSE