Get Invoice with Country of Origin and HS Code

Shopify Discussion
1

We need an invoice when sending orders out of EU. The Invoice needs to show price, HS code and Country of Origin for each product.

Im currently using the Print Order app to generate the invoice. And I’m now trying to add the HS code and Country of Origin to the invoice.

After a lot of hassle, the HS code is now shown by adding this line:

{{ line_item.variant.metafields.harmonized_system_code.value }}

I did however read that metafields are not recommended to use, as this is deprecated, but nothing else have worked.

And I still haven’t found any solution as to how to show the Country of Origin.

It seems like a fairly straight task, but it has not been possible for me to find any documentation on this field or how to access it.

I really hope someone can help me, ideally on how to access this field, or on how to generate an invoice with this (really common) info.

4 Likes
2

I’m having exactly the same issue. All I need is a print out for each order showing the item, the SKU, weight, value, HS code and country or origin. Astonishingly, it appears Shopify can’t accomplish this really basic task. I spent most of yesterday chatting with support and we are nowhere nearer a solution. I am completely amazed that Shopify cannot resolve this.

3 Likes
3

I’m also looking for the same solution but I couldn’t find it yet. Why does Shopify ask to fill the “Country of Origin” if they can’t have an option to show it?

DISAPPOINTED!!!

3 Likes
4

It is ridiculous that Shopify does not enable this function as standard. If you need this functionality it appears you have no alternative but to pay a developer a solution. I am becoming more and more frustrated with Shopify and the fact that you have to stick your hand in your pocket everytime you want a basic function such as showing the HS code on shipping paperwork or defining shipping rules based on weight. These functions should be standard.

3 Likes
5

Hi @deranged and @TG-Admin ,

SOLVED!

I have finally created a solution to this issue. No more spending a lot of money on this now.

Reach out to me at hello@iamrohitsoni.com

Thanks!

1 Like
6

Could someone share an answer for this? I’m also unable to output the Variant country of origin.

1 Like
7

We’re having the same issue & I agree - this is now a requirement for any business sending goods overseas and Shopify really should have a solution for it.

4 Likes
8

Could you help us with this? We want to show country of origin & hs code. We also want variables of this. You can call us on 9716072875. I am Kawal.

9

Yes, same problem here. Shipping out of the UK and unable to get Country of Origin to appear on Order Printer paperwork. I’ve sorted the HS code (although Shopify only supports a 6 digit code, not the 8 or 10 we use here). Layout issue can be solved in Order Printer after a bit of digging, but can I find the Country Code? Not a chance! Support have been unable to help and have pointed me in the direction of a developer, but I only want to know how to extract that COO so I can finish the code in the template!! How difficult can it be.

1 Like
10

We’ve now solved this with the help of a developer. They were also unable to just enter the Country of Origin onto the order printer template and ended up having to add a tag to each product showing the name of the country. It works, but how crazy. We have to use a tag creator app to enter all the tags quickly as buld edit doesn’t allow you to do that job quickly.

11

I actually am a shopify partner / developer / expert and I can’t find this information either. If I find something I will update.

For the HST code I did end up using:
{{ line_item.variant.metafields.harmonized_system_code.value }}

I’m still looking for Country of Origin. I’m using the “Order Printer” app.

12

@NessaSnipe
Do you mind please sharing how to add this {{ line_item.variant.metafields.harmonized_system_code.value }} (which line to use in the printer app) as it does not show up.

Many thanks

13

For anyone struggling with invoice print including HS code, I managed to include this code

**** {% if show_line_item_taxes %} {% endif %} {% for line_item in line_items %} **** {% if show_line_item_taxes %}
Quantity ItemHSN CodeTaxesPrice
{{ line_item.quantity }} x {{ line_item.title }}{{ line_item.variant.metafields.harmonized_system_code.value }}

Hope it works for others too

14

I just downloaded Invoice Wizard app which has both HSN Code + Country of Origin fields.

1 Like
15

Did this solve the problem? How is it working?

16

hello your code work for me . But one problem arise with me HS code is one step shifted on my table . please have a look . Can you help me with this? i used

{{ line_item.variant.metafields.harmonized_system_code.value }} code

hs code.png
hs code.png1366×1500 140 KB

17

I now use https://apps.shopify.com/partners/wizard-labs.

18

As a complete newbie to coding - please could you let me know where I would insert this in the template? Thank you!

19

Hey @Hemant_Chauhan

Try to use this code, it worked for me!


  {{ "now" | date: "%m/%d/%y" }}

  Invoice for {{ order_name }}

  **{{ shop_name }}**

  {{ shop.address }}

  {{ shop.city }} {{ shop.province_code }} {{ shop.zip | upcase }}

  {{ shop.country }}

---

### Item Details

      {% if show_line_item_taxes %}
      
      {% endif %}
      
    {% for line_item in line_items %}
      
        {% if show_line_item_taxes %}
        
        {% endif %}
        
    {% endfor %}
  

| Quantity | HSN CODE | Item | Taxes | Price |
| - | - | - | - | - |
| {{ line_item.quantity }} x | {{ line_item.variant.metafields.harmonized_system_code.value }} | **{{ line_item.title }}** | <br>          {% for tax_line in line_item.tax_lines %}<br>            {{ tax_line.price | money }} {{ tax_line.title }}<br><br>          {% endfor %}<br>         | <br>          {% if line_item.original_price != line_item.price %}<br>            ~~{{ line_item.original_price | money }}~~<br>          {% endif %}<br>          {{ line_item.price | money }}<br>         |

{% if transactions.size > 1 %}
  ### Transaction Details
  
      {% for transaction in transactions %}
        
      {% endfor %}
    

| Type | Amount | Kind | Status |
| - | - | - | - |
| {{ transaction.gateway | payment_method }} | {{ transaction.amount | money }} | {{ transaction.kind }} | {{ transaction.status }} |

{% endif %}

### Payment Details

  {% for discount in discounts %}
  
  {% endfor %}
  
  {% if shipping_address %}
    
  {% endif %}
  
  {% if total_paid != total_price %}
    
  {% endif %}

| Subtotal price: | {{ subtotal_price | money }} |
| - | - |
| Includes discount "{{ discount.code }}" | {{ discount.savings | money }} |
| Total tax: | {{ tax_price | money }} |
| Shipping: | {{ shipping_price | money }} |
| **Total price:** | **{{ total_price | money }}** |
| **Total paid:** | **{{ total_paid | money }}** |
| **Outstanding Amount:** | **{{ total_price | minus: total_paid | money }}** |

{% if note %}
  ### Note
  

{{ note }}

{% endif %}

{% if shipping_address %}
  ### Shipping Details

  
    **{{ shipping_address.name }}**

    {{ shipping_address | format_address }}
  

{% endif %}

If you have any questions, please send an email to {{ shop.email }}
1 Like