6. Usable code

1. General

Field Value
current_store_id current store id
store_address Store address (set in System > Configuration > Global PDF)
legal_information Legal information (set in system > configuration > Global PDF)
logo Logo path (set in System > Configuration > Global PDF)
globalpdf_image_directory Current theme image directory
catalog_image_directory Magento product image directory
store_currency Currency for current store

2. Product

entity_id, entity_type_id, attribute_set_id, type_id, sku, has_options, required_options, created_at, updated_at, exclude_from_supply_needs, external_logistic_run_id, sent_to_logistic_company, name, meta_title, meta_description, image, small_image, thumbnail, url_key, url_path, custom_design, page_layout, options_container, image_label, small_image_label, thumbnail_label, gift_message_available, price, special_price, cost, weight, status, tax_class_id, is_recurring, visibility, enable_googlecheckout, is_imported, default_supply_delay, allow_individual_quote_request, description, short_description, meta_keyword, custom_layout_update, special_from_date, special_to_date, news_from_date, news_to_date, custom_design_from, custom_design_to, media_gallery, tier_price, tier_price_changed, stock_item, is_in_stock, is_salable, additional_images, custom_options, has_custom_options, additional_information, has_additional_information, configurable_attributes, configurations, has_configurations, bundle_items, has_bundle_items

Note

You can also use any custom product attribute

3. invoice

invoice.entity_id, invoice.store_id, invoice.base_grand_total, invoice.shipping_tax_amount, invoice.tax_amount, invoice.base_tax_amount, invoice.store_to_order_rate, invoice.base_shipping_tax_amount, invoice.base_discount_amount, invoice.base_to_order_rate, invoice.grand_total, invoice.shipping_amount, invoice.subtotal_incl_tax, invoice.base_subtotal_incl_tax, invoice.store_to_base_rate, invoice.base_shipping_amount, invoice.total_qty, invoice.base_to_global_rate, invoice.subtotal, invoice.base_subtotal, invoice.discount_amount, invoice.billing_address_id, invoice.is_used_for_refund, invoice.order_id, invoice.email_sent, invoice.can_void_flag, invoice.state, invoice.shipping_address_id, invoice.cybersource_token, invoice.store_currency_code, invoice.transaction_id, invoice.order_currency_code, invoice.base_currency_code, invoice.global_currency_code, invoice.increment_id, invoice.created_at, invoice.updated_at, invoice.hidden_tax_amount, invoice.base_hidden_tax_amount, invoice.shipping_hidden_tax_amount, invoice.base_shipping_hidden_tax_amount, invoice.shipping_incl_tax, invoice.base_shipping_incl_tax, order.entity_id, order.state, order.status, order.coupon_code, order.protect_code, order.shipping_description, order.is_virtual, order.store_id, order.customer_id, order.base_discount_amount, order.base_discount_canceled, order.base_discount_invoiced, order.base_discount_refunded, order.base_grand_total, order.base_shipping_amount, order.base_shipping_canceled, order.base_shipping_invoiced, order.base_shipping_refunded, order.base_shipping_tax_amount, order.base_shipping_tax_refunded, order.base_subtotal, order.base_subtotal_canceled, order.base_subtotal_invoiced, order.base_subtotal_refunded, order.base_tax_amount, order.base_tax_canceled, order.base_tax_invoiced, order.base_tax_refunded, order.base_to_global_rate, order.base_to_order_rate, order.base_total_canceled, order.base_total_invoiced, order.base_total_invoiced_cost, order.base_total_offline_refunded, order.base_total_online_refunded, order.base_total_paid, order.base_total_qty_ordered, order.base_total_refunded, order.discount_amount, order.discount_canceled, order.discount_invoiced, order.discount_refunded, order.grand_total, order.shipping_amount, order.shipping_canceled, order.shipping_invoiced, order.shipping_refunded, order.shipping_tax_amount, order.shipping_tax_refunded, order.store_to_base_rate, order.store_to_order_rate, order.subtotal, order.subtotal_canceled, order.subtotal_invoiced, order.subtotal_refunded, order.tax_amount, order.tax_canceled, order.tax_invoiced, order.tax_refunded, order.total_canceled, order.total_invoiced, order.total_offline_refunded, order.total_online_refunded, order.total_paid, order.total_qty_ordered, order.total_refunded, order.can_ship_partially, order.can_ship_partially_item, order.customer_is_guest, order.customer_note_notify, order.billing_address_id, order.customer_group_id, order.edit_increment, order.email_sent, order.forced_do_shipment_with_invoice, order.gift_message_id, order.payment_authorization_expiration, order.paypal_ipn_customer_notified, order.quote_address_id, order.quote_id, order.shipping_address_id, order.adjustment_negative, order.adjustment_positive, order.base_adjustment_negative, order.base_adjustment_positive, order.base_shipping_discount_amount, order.base_subtotal_incl_tax, order.base_total_due, order.payment_authorization_amount, order.shipping_discount_amount, order.subtotal_incl_tax, order.total_due, order.weight, order.customer_dob, order.increment_id, order.applied_rule_ids, order.base_currency_code, order.customer_email, order.customer_firstname, order.customer_lastname, order.customer_middlename, order.customer_prefix, order.customer_suffix, order.customer_taxvat, order.discount_description, order.ext_customer_id, order.ext_order_id, order.global_currency_code, order.hold_before_state, order.hold_before_status, order.order_currency_code, order.original_increment_id, order.relation_child_id, order.relation_child_real_id, order.relation_parent_id, order.relation_parent_real_id, order.remote_ip, order.shipping_method, order.store_currency_code, order.store_name, order.x_forwarded_for, order.customer_note, order.created_at, order.updated_at, order.total_item_count, order.customer_gender, order.hidden_tax_amount, order.base_hidden_tax_amount, order.shipping_hidden_tax_amount, order.base_shipping_hidden_tax_amount, order.hidden_tax_invoiced, order.base_hidden_tax_invoiced, order.hidden_tax_refunded, order.base_hidden_tax_refunded, order.shipping_incl_tax, order.base_shipping_incl_tax, order.stocks_updated, order.fullstock_date, order.estimated_shipping_date, order.payment_validated, order.is_valid, order.anounced_date, order.anounced_date_max, order.external_logistic_run_id, order.sent_to_logistic_company, order.logistic_status, order.billing_address, order.shipping_address, order.payment_method, invoice.items, invoice.history

4. Credit memo

creditmemo.entity_id, creditmemo.store_id, creditmemo.adjustment_positive, creditmemo.base_shipping_tax_amount, creditmemo.store_to_order_rate, creditmemo.base_discount_amount, creditmemo.base_to_order_rate, creditmemo.grand_total, creditmemo.base_adjustment_negative, creditmemo.base_subtotal_incl_tax, creditmemo.shipping_amount, creditmemo.subtotal_incl_tax, creditmemo.adjustment_negative, creditmemo.base_shipping_amount, creditmemo.store_to_base_rate, creditmemo.base_to_global_rate, creditmemo.base_adjustment, creditmemo.base_subtotal, creditmemo.discount_amount, creditmemo.subtotal, creditmemo.adjustment, creditmemo.base_grand_total, creditmemo.base_adjustment_positive, creditmemo.base_tax_amount, creditmemo.shipping_tax_amount, creditmemo.tax_amount, creditmemo.order_id, creditmemo.email_sent, creditmemo.creditmemo_status, creditmemo.state, creditmemo.shipping_address_id, creditmemo.billing_address_id, creditmemo.invoice_id, creditmemo.cybersource_token, creditmemo.store_currency_code, creditmemo.order_currency_code, creditmemo.base_currency_code, creditmemo.global_currency_code, creditmemo.transaction_id, creditmemo.increment_id, creditmemo.created_at, creditmemo.updated_at, creditmemo.hidden_tax_amount, creditmemo.base_hidden_tax_amount, creditmemo.shipping_hidden_tax_amount, creditmemo.base_shipping_hidden_tax_amount, creditmemo.shipping_incl_tax, creditmemo.base_shipping_incl_tax, order.entity_id, order.state, order.status, order.coupon_code, order.protect_code, order.shipping_description, order.is_virtual, order.store_id, order.customer_id, order.base_discount_amount, order.base_discount_canceled, order.base_discount_invoiced, order.base_discount_refunded, order.base_grand_total, order.base_shipping_amount, order.base_shipping_canceled, order.base_shipping_invoiced, order.base_shipping_refunded, order.base_shipping_tax_amount, order.base_shipping_tax_refunded, order.base_subtotal, order.base_subtotal_canceled, order.base_subtotal_invoiced, order.base_subtotal_refunded, order.base_tax_amount, order.base_tax_canceled, order.base_tax_invoiced, order.base_tax_refunded, order.base_to_global_rate, order.base_to_order_rate, order.base_total_canceled, order.base_total_invoiced, order.base_total_invoiced_cost, order.base_total_offline_refunded, order.base_total_online_refunded, order.base_total_paid, order.base_total_qty_ordered, order.base_total_refunded, order.discount_amount, order.discount_canceled, order.discount_invoiced, order.discount_refunded, order.grand_total, order.shipping_amount, order.shipping_canceled, order.shipping_invoiced, order.shipping_refunded, order.shipping_tax_amount, order.shipping_tax_refunded, order.store_to_base_rate, order.store_to_order_rate, order.subtotal, order.subtotal_canceled, order.subtotal_invoiced, order.subtotal_refunded, order.tax_amount, order.tax_canceled, order.tax_invoiced, order.tax_refunded, order.total_canceled, order.total_invoiced, order.total_offline_refunded, order.total_online_refunded, order.total_paid, order.total_qty_ordered, order.total_refunded, order.can_ship_partially, order.can_ship_partially_item, order.customer_is_guest, order.customer_note_notify, order.billing_address_id, order.customer_group_id, order.edit_increment, order.email_sent, order.forced_do_shipment_with_invoice, order.gift_message_id, order.payment_authorization_expiration, order.paypal_ipn_customer_notified, order.quote_address_id, order.quote_id, order.shipping_address_id, order.adjustment_negative, order.adjustment_positive, order.base_adjustment_negative, order.base_adjustment_positive, order.base_shipping_discount_amount, order.base_subtotal_incl_tax, order.base_total_due, order.payment_authorization_amount, order.shipping_discount_amount, order.subtotal_incl_tax, order.total_due, order.weight, order.customer_dob, order.increment_id, order.applied_rule_ids, order.base_currency_code, order.customer_email, order.customer_firstname, order.customer_lastname, order.customer_middlename, order.customer_prefix, order.customer_suffix, order.customer_taxvat, order.discount_description, order.ext_customer_id, order.ext_order_id, order.global_currency_code, order.hold_before_state, order.hold_before_status, order.order_currency_code, order.original_increment_id, order.relation_child_id, order.relation_child_real_id, order.relation_parent_id, order.relation_parent_real_id, order.remote_ip, order.shipping_method, order.store_currency_code, order.store_name, order.x_forwarded_for, order.customer_note, order.created_at, order.updated_at, order.total_item_count, order.customer_gender, order.hidden_tax_amount, order.base_hidden_tax_amount, order.shipping_hidden_tax_amount, order.base_shipping_hidden_tax_amount, order.hidden_tax_invoiced, order.base_hidden_tax_invoiced, order.hidden_tax_refunded, order.base_hidden_tax_refunded, order.shipping_incl_tax, order.base_shipping_incl_tax, order.stocks_updated, order.fullstock_date, order.estimated_shipping_date, order.payment_validated, order.is_valid, order.anounced_date, order.anounced_date_max, order.external_logistic_run_id, order.sent_to_logistic_company, order.logistic_status, order.billing_address, order.shipping_address, order.payment_method, creditmemo.items, creditmemo.history

5. Cart

entity_id, store_id, created_at, updated_at, converted_at, is_active, is_virtual, is_multi_shipping, items_count, items_qty, orig_order_id, store_to_base_rate, store_to_quote_rate, base_currency_code, store_currency_code, quote_currency_code, grand_total, base_grand_total, checkout_method, customer_id, customer_tax_class_id, customer_group_id, customer_email, customer_prefix, customer_firstname, customer_middlename, customer_lastname, customer_suffix, customer_dob, customer_note, customer_note_notify, customer_is_guest, remote_ip, applied_rule_ids, reserved_order_id, password_hash, coupon_code, global_currency_code, base_to_global_rate, base_to_quote_rate, customer_taxvat, customer_gender, subtotal, base_subtotal, subtotal_with_discount, base_subtotal_with_discount, is_changed, trigger_recollect, ext_shipping_info, gift_message_id, anounced_date, anounced_date_max, x_forwarded_for, items, shipping_amount, shipping_description, tax_amount

6. Order

entity_id, state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount,shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest,customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, forced_do_shipment_with_invoice, gift_message_id, payment_authorization_expiration, paypal_ipn_customer_notified, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_sufficustomer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_atupdated_at, total_item_count, customer_gender, hidden_tax_amount, base_hidden_tax_amount, shipping_hidden_tax_amount, base_shipping_hidden_tax_amount, hidden_tax_invoiced, base_hidden_tax_invoiced, hidden_tax_refunded, base_hidden_tax_refunded, shipping_incl_tax, base_shipping_incl_tax, stocks_updated, fullstock_date, estimated_shipping_date, payment_validated, is_valid, anounced_date, anounced_date_max, external_logistic_run_id, sent_to_logistic_company, logistic_status, billing_address, shipping_address, payment_method, items

7. Order - Invoice - Credit memo

item_id, order_id, parent_item_id, quote_item_id, store_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, base_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, ext_order_item_id, weee_tax_applied, weee_tax_applied_amount, weee_tax_applied_row_amount, base_weee_tax_applied_amount, base_weee_tax_applied_row_amount, weee_tax_disposition, weee_tax_row_disposition, base_weee_tax_disposition, base_weee_tax_row_disposition, locked_do_invoice, locked_do_ship, price_incl_tax, base_price_incl_tax, row_total_incl_tax, base_row_total_incl_tax, hidden_tax_amount, base_hidden_tax_amount, hidden_tax_invoiced, base_hidden_tax_invoiced, hidden_tax_refunded, base_hidden_tax_refunded, is_nominal, tax_canceled, hidden_tax_canceled, tax_refunded, comments, reserved_qty, purchase_order_id, logistic_status

8. Purchase order

You can use the following codes to display informations

About purchase order

  • purchase.total_tax_amount
  • purchase.po_zoll_cost_ttc
  • purchase.po_shipping_cost_ttc
  • purchase.items
  • purchase.po_date
  • purchase.po_order_id (PO reference)
  • purchase.po_supply_date
  • purchase.po_carrier
  • purchase.po_payment_type
  • purchase.po_currency
  • purchase.po_invoice_date
  • purchase.po_invocie_ref
  • purchase.po_paid
  • purchase.po_currency_change_rate
  • purchase.po_shipping_cost
  • purchase.po_zoll_cost
  • purchase.po_tax_rate
  • purchase.po_comments
  • purchase.po_payment_date
  • purchase.po_status

About the purchase order items

  • pop_product_id
  • pop_product_name
  • pop_qty
  • pop_supplied_qty
  • pop_price_ht (excl tax)
  • pop_supplier_ref (supplier sku)
  • pop_eco_tax (weee)
  • pop_extended_costs
  • pop_tax_rate
  • pop_discount
  • pop_delivery_date
  • pop_subtotal
  • pop_total

About the supplier

  • supplier.sup_name (supplier name)
  • supplier.sup_address1
  • supplier.sup_address2
  • supplier.sup_zipcode
  • supplier.sup_country
  • supplier.sup_city
  • supplier.sup_tel
  • supplier.sup_fax
  • supplier.sup_contact
  • supplier.sup_mail
  • supplier.sup_website
  • supplier.currency