[SOLVED] Amending Sub Total Wording on OC4 invoice

Testing OC4.0.2.3
Have copied over a version of the invoice.twig file that drives our current OC3 invoice & it's working well on OC4 - but there's a glitch.
Have used Language Editor to change extension/opencart/total/sub_total to change the checkout text from "Sub-Total" to "Sub-Total (excluding VAT)" - hoped this would also change the same text on the invoice but it hasn't
What file do I need to edit / what do I need to add to the invoice.twig file to change the invoice sub total text as above? - cant find any other suitable place to edit on language editor or any other file that I can edit to make this change.
Ideally would also like to add "(excluding VAT)" after the name of the shipping method on the invoice but that's not essential
Please dont say dont use it / wait for 4.1!! - for reasons too complex for here, need to move forward on the OC4 site!
Thanks in advance

Well, the latest OC v.4.1.0.0 Release is already here:
https://github.com/opencart/opencart/tree/master

You change Sub-Total to Sub-Total?

All the order totals are stored under the "order_total" table in the database. Therefore, since you mentioned you've already changed the "Sub-Total" text, it will only affect orders that are placed after the change. Orders placed before the change will not be affected since the order total title texts are stored in the database.

You will have to update the text directly in the database for sub-total.

Perhaps you can run an SQL query like:
or in PHP
This is assuming that your database prefix is "oc_".

khnaz35 wrote: ↑

Tue Jan 07, 2025 2:26 pm

You change Sub-Total to Sub-Total?

I believe they mentioned that they changed it from "Sub-Total" to "Sub-Total (excluding VAT)".

Thank you softmonke - solved the issue - have updated subject accordingly
Appreciate your prompt help