Add HS & COO to invoice & packing slip

Linked a walk through on how to do it below, time consuming if you have a lot of products
https://support.starshipit.com/hc/en-us/articles/360002952915

Dear @reeko6616

Many thanks for your link.

This is exactly what we have done for ALL of our products. Each one of our products now has specific:
– HS (Harmonized System) code
– COO (Country of Origin)

Our question is: How can we add these to the invoices that Booster produces?

I suspect there is a very simple way of triggering these but I can’t figure it out.

Many thanks for your help with this.

[ Signature deleted ]

• This reply was modified 3 years, 9 months ago by Yui.
• This reply was modified 3 years, 5 months ago by Jan Dembowski.

Hi @pairfumlondon

If this has product attributes you can use this [wcj_product_meta] shortcode. Also, if you have any ready shortcodes then you can use that too.

Dear @gravid7

This would be fantastic! Thank you for the tip.

We have tried to implement it but something is not working. This is the pattern that we followed: https://booster.io/shortcodes/wcj_product_meta/

Within Booster, we navigated to ‘PDF Invoicing …’ > Templates > Invoice > HTML Template. Here we see the following section:

<p>
[wcj_order_items_table table_class="pdf_invoice_items_table"
	columns="item_number|item_name|item_quantity|line_total_tax_excl"
	columns_titles="|Product|Qty|Total"
	columns_styles="width:5%;|width:75%;|width:5%;|width:15%;text-align:right;"]
<table class="pdf_invoice_totals_table">
<tbody>
	<tr><th>Total (excl. TAX)</th><td>[wcj_order_total_excl_tax]</td></tr>
	<tr><th>Taxes</th><td>[wcj_order_total_tax hide_if_zero="no"]</td></tr>
	<tr><th>Order Total</th><td>[wcj_order_total]</td></tr>
</tbody>
</table>
</p>
<p>Notes:<br> 
[wcj_product_meta before="COO: " name="attribute_pa_country-of-manufacture"]</p>

Ideally, we would like to add the HS and COO within the table itself, in the line that contains the ‘product’ but I don’t think this is what you meant.

Hence, we added your suggested code to the ‘Notes’ area.

Subsequently, we regenerated an invoice for an existing, completed order but the ‘Notes’ field was still blank.

Can you help us identify what is going wrong?

Many thanks for your help with this.

Kind regards,

[ Signature deleted ]

• This reply was modified 3 years, 8 months ago by Yui.
• This reply was modified 3 years, 5 months ago by Jan Dembowski.

Hi @pairfumlondon

If you have used custom order notes then you can use the “[wcj_order_meta meta_key=’_your_key’]” this shortcode to display notes.

Hi @gravid7

Many thanks for the suggestion but sadly it didn’t work.

Following your advice, we amended the ‘notes’ part of the invoice template (see above) like this:

<p>Notes:<br>
[wcj_product_meta before=”COO: ” meta_key=”attribute_pa_country-of-manufacture”]</p>

When we re-generated an old invoice afterwards, the ‘notes’ section was still blank.

What do you suggest?

Kind regards,

[ Signature deleted ]

• This reply was modified 3 years, 6 months ago by Steven Stern (sterndata).
• This reply was modified 3 years, 5 months ago by Jan Dembowski.

Hi @pairfumlondon

I think you have used the wrong shortcode. Please try to use this shortcode [wcj_order_meta] instead of [wcj_product_meta] shortcode.

Let me know if you need any further help.

Hi @gravid7

Many thanks for the tip and we tried but sadly it doesn’t work either.

This is what we changed it to:
<p>Notes:<br>
[wcj_order_meta before=”COO: ” meta_key=”attribute_pa_country-of-manufacture”]</p>

I have double checked the slug under WP Dashboard > Products > Attributes and it is clearly: country-of-manufacture. In other words, it looks like it is not the ‘meta_key’ which is wrong.

Would you have another suggestion?

Kind regards,
[ Signature deleted ]

• This reply was modified 3 years, 6 months ago by Yui.
• This reply was modified 3 years, 5 months ago by Jan Dembowski.

Hi @pairfumlondon

If possible can you check where these fields are storing on the Database? We will check how can we show these fields. This field is stored product-wise or order-wise?

Hi @gravid7

These fields are created from within WooCommerce on a product level:
WP Dashboard > Products > Attributes > …

There we have created two attributes:
– Country of Manufacture:
/wp-admin/edit-tags.php?taxonomy=pa_country-of-manufacture&post_type=product

– Commodity Code:
/wp-admin/edit-tags.php?taxonomy=pa_commodity-code&post_type=product

Does this give you all the information you need or is there anything else I can assist you with?

If you would like, we can give you access to our staging website.

Many thanks for your help with this.

With kind regards,

[ Signature deleted ]

• This reply was modified 3 years, 6 months ago by Yui.
• This reply was modified 3 years, 5 months ago by Jan Dembowski.

Hi @pairfumlondon

Thanks for letting us know. If that is product-wise then you can try to add the below code. You can try to add an attribute key instead of “_your_meta_key”.

[wcj_order_items_table<br />
    table_class="pdf_invoice_items_table"<br />
columns="item_number|item_name|product_post_meta=_your_meta_key|item_quantity|line_total_tax_excl"<br />
    columns_titles="#|Product|Meta|Qty|Total"<br />
    columns_styles="width:5%;|width:45%;|width:30%;|width:5%;|width:15%;text-align:right;"]

Dear @gravid7

Many thanks for your suggestion but unfortunately, it doesn’t work.

However, we search your site for the exact phrase “product_post_meta” and found this page:
https://booster.io/shortcodes/wcj_order_items_table/

We noticed that it listed the following identifier: product_attribute

Considering that this is what we are trying to display on the invoice, we tried it instead of your suggestion.

We found that it works and we are using this code now:

<p>
[wcj_order_items_table table_class="pdf_invoice_items_table"
    columns="item_number|item_name|product_attribute=pa_country-of-manufacture|product_attribute=pa_commodity-code|item_quantity|line_total_tax_excl"
    columns_titles="#|Product|COO|HS Code|Qty|Total"
    columns_styles="width:5%;|width:50%;|width:10%;|width:15%;|width:5%;|width:15%;text-align:right;"]
<table class="pdf_invoice_totals_table">
<tbody>
	<tr><th>Total (excl. TAX)</th><td>[wcj_order_total_excl_tax]</td></tr>
	<tr><th>Taxes</th><td>[wcj_order_total_tax hide_if_zero="no"]</td></tr>
	<tr><th>Order Total</th><td>[wcj_order_total]</td></tr>
</tbody>
</table>
</p>

We must admit that we are disappointed that you couldn’t point us in the direction of this solution when it seems rather obvious in hindsight.

Regardless, we hope that other users of your plugin might find the solution useful for their website.

Kind regards,

[ Signature deleted ]

• This reply was modified 3 years, 6 months ago by Steven Stern (sterndata).
• This reply was modified 3 years, 5 months ago by Jan Dembowski.

Hi @pairfumlondon

Glad to know that it’s working now, I am marking this as solved ?? and yes sure this will help other customers to refer many thanks for that.