Magazento

EXCEL invoice \ shipment \ credit memo templates

  • Popularity Score 4 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

Using Excel templates you can create your own custom invoices, shipments and refunds.
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.

Magento Connect

$125.00
Previous Next
Overview

EXCEL invoice \ shipment \ credit memo templates

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. 

Visit Extension Page: http://www.magazento.com/english/magento-ext/magazento-extensions/xls-invoice-shipment-credit-memo

Demo:

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

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

 

General:
- Order data access through snippets, <a href="#order_snippets">go to snippets</a>
- Invoice data access through snippets, <a href="#invoice_snippets">go to invoice snippets</a>
- Ordered product data access through snippets, <a href="#item_snippets">go to product snippets</a>
- Billing data access through snippets, <a href="#billing_snippets">go to billing snippets</a>
- Shipping data access through snippets, <a href="#shipping_snippets">go to shipping snippets</a>
- 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}}

How it looks:

...............................................................................................................................
Professional magento development serviсes & Magento extensions 
Magento menu allows you fully control/edit the store catalogue displaying type.
We also provide premium Magento modules development services
Simplify the checkout process with Magento checkout and increase online sales
Questions & Tickets: http://www.magazento.com/ticket/ 
E-mail: service@magazento.com 
M1 Extension Versions

There are no uploaded releases.

Q&A
Get Help

Support for This Extension

The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Magento Platform Support

If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.

Reviews

About the Developer

This extension was developed by and is supported by Magazento

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.