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.

    • Daniel

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      says:

      You simply use the meta key on users data like {{VAT}} – VAT is just an example. It must be the exact user meta key.

  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

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      says:

      Please send your codecanyon purchase code & admin access to [email protected]

    • Daniel

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      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).

    • Daniel

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      says:

      Well currently not, but we can customize / add this feature for you on Charge. Contact us at [email protected]

  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.

    • Daniel

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      says:

      Well currently not, but we can customize / add this feature for you on Charge. Contact us at [email protected]

  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

    • Daniel

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      says:

      Try customer_username

    • Daniel

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      says:

      Please submit a ticket on our website

  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

      The Real Person!

      Author Daniel acts as a real person and verified as not a bot.
      Passed all tests against spam bots. Anti-Spam by CleanTalk.
      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 *