Which Invoice Data Fields can I use?

You can use ALL data fields, that are available in your regular WooCommerce order in our PDF Invoice plugin. This also includes custom meta keys. Data is placed with curly brackets like {{billing_first_name}}.

  • id
  • qr_code
  • invoice_number
  • parent_id
  • status
  • currency
  • version
  • prices_include_tax
  • discount_total
  • discount_tax
  • shipping_total
  • shipping_tax
  • cart_tax
  • total
  • total_tax
  • customer_id
  • order_key
  • payment_method
  • payment_method_title
  • transaction_id
  • customer_ip_address
  • customer_user_agent
  • created_via
  • customer_note
  • date_completed
  • date_paid
  • cart_hash
  • number
  • billing_first_name
  • billing_last_name
  • billing_company
  • billing_address_1
  • billing_address_2
  • billing_city
  • billing_state
  • billing_postcode
  • billing_country
  • billing_email
  • billing_phone
  • shipping_first_name
  • shipping_last_name
  • shipping_company
  • shipping_address_1
  • shipping_address_2
  • shipping_city
  • shipping_state
  • shipping_postcode
  • shipping_country
  • order_created
  • order_modified
  • subtotal
  • shipping_method_title
  • _order_key
  • _customer_user
  • _payment_method
  • _payment_method_title
  • _transaction_id
  • _customer_ip_address
  • _customer_user_agent
  • _created_via
  • _date_completed
  • _completed_date
  • _date_paid
  • _paid_date
  • _cart_hash
  • _order_currency
  • _cart_discount
  • _cart_discount_tax
  • _order_shipping
  • _order_shipping_tax
  • _order_tax
  • _order_total
  • _order_version
  • _prices_include_tax
  • _billing_address_index
  • _shipping_address_index
  • _recorded_sales
  • _recorded_coupon_usage_counts
  • _order_stock_reduced
  • _edit_lock
  • _edit_last
  • _wpb_vc_js_status
  • _vc_post_settings

29 thoughts on “Which Invoice Data Fields can I use?

  1. vincent says:

    Hi there,

    How Can I show the VAT number on the invoice for customers that have filled in their tax id?

    Also… is there a way to make the column headings like: Product, SKU Qty etc… not bold but regular?

    Again thanks

  2. Hasnain Mahar says:

    I have the same question as vincent. How can we print VAT numbers on invoices for customers? It’s just not working.

  3. samkung says:

    Hi, I got a “Tracking number” from USPS, I added the “Tracking number” into my customer’s order sheet then regenerate a new invoice for updating the”shipping number” for my client checking their shipping.

    But I don’t know how to add the “Tracking number” to the invoice.({{_order_shipping}} is not updating.)

    • Daniel says:

      You can use ANY custom data field, that is available in the order meta data by using the meta key: {{meta_key_name}}

  4. Sam says:

    My orders all have a custom order number stored using the meta key _alg_wc_custom_order_number
    Your plugin doesn’t retrieve the value of that key using this syntax in the Content Intro:
    Order Number: {{_alg_wc_custom_order_number}}

    Am I missing something? The value for this key is present in wp_postmeta.

    • Sam says:

      Never mind. The editor for was wrapping the meta key name in an HTML label tag in the Content Intro field. Editing as raw text solved this issue (although I am unsure as to why this doesn’t happen with the other content fields as well).

  5. Oliver Gehrmann says:

    Is there any chance to get a tag that gives you the “type” of an order? I’m asking because we would like to generate pdfs that actually state that it’s a “refund” rather than an “invoice”. This would make life for our bookkeeping much easier.

    At the moment we just have static text there together with the order ID, so it reads: “Invoice no.: {{id}}”
    I’d very much like to have it say EITHER “invoice” if it’s an invoice OR “refund” if it’s a refund.
    Any help would be much appreciated.

  6. Mike Oppel says:

    Hallo Daniel,
    wie kann ich in der Kopfzeile oben rechts, statt Buchseite das Wort Seitenzahl X von Y stehen haben?
    Viele Grüße
    Mike

  7. Mariusz says:

    Hi Daniel,

    Variable {{order_number}} works in header and content but not for invoice filename.

    Can you fix this bug?
    Thanks a lot

  8. Angel says:

    Hi, how can I add discount subtotal for invoice? Also, how can I reflect discounted price on the CouponTotal if there us no coupon code used, only discount applied? Thanks

    • Daniel says:

      Yes of course you can show a product image inside the PDF invoice in the WooCommerce order PDF.

Leave a Reply

Your email address will not be published. Required fields are marked *