Hi,
It is impossible to change the billing address in the invoice.
If you save the changed address, a message "Successfully saved" appears, in fact the entry is not changed.
https://frauenprojekt-kenia.de/
Best regards
Joerg
Closed Public
Category: Technical Support / Bugs
Ticket #100
Change billing address in the invoice
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Conversation
Joerg,
Happy Holidays! In the screenshots you attached, it's hard for me to see which address page that is. Can you reply with the url of that page so I can make sure you are editing the the address in the correct place?
Adam
Adam
Happy New Year.
https://frauenprojekt-kenia.de/administrator/index.php?option=com_j2store&view=order&id=1507
It is the invoice S-1351. However, the problem exists with all invoices.
Joerg
Joerg,
Can you take a backup of the database and send me a link via email? The address update works on new installs without issue so I am thinking some of the older j2store tables may not have been fully updated. Even just an export of the j2store_ tables sould be enough.
Adam
Thank you Joerg, we received the db structure dump, I will check it.
Olivier.
Joerg,
the vgarh_j2store_addresses table has extra columns so I am wondering if the issue is linked to custom fields that would have been created.
In particular, the fields:
- hausnummer
- addessline_3
- address_3
- adressenzusatz
have been added as columns to the table.
Olivier.
Hi Olivier,
I have created the following fields in "Settings / Custom Fields"
- hausnummer
- addessline_3
- address_3
- adressenzusatz
and later
- hausnummer
- addessline_3
- address_3
deleted again.
It seems that these fields have not been deleted in the DB
Joerg.
Hi Joerg,
I believe you should manually delete the columns in the database table when there is no associated custom field available.
Then check if you can save the billing address again.
Olivier.
H Olivier
I deleted the fields:
hausnummer
addessline_3
address_3
adressenzusatz
manually. Afterwards I could change the addresses different invoices without invoice S-1351.
What could be the Problem?
Joerg
Hi Joerg,
could you clarify? I am not sure I understand your latest reply.
- did you delete the cusom fields?
- did you remove the columns of the table in the database?
- Was the addition of addresses possible after the 2 previous steps were done?
Thank you! I apologise for requesting more information from you, but I want to make sure we are on the same page and that we understand the steps you have taken.
Olivier.
Hi Olivier,
> did you delete the custom fields?
Yes, I deleted in J2Store - settings - custom fields
> did you remove the columns of the table in the database?
Yes I did
> Was the addition of addresses possible after the 2 previous steps were done?
Yes, I was able to change the addresses of different invoices, but not of invoice S-1351.
Joerg
