change Billing(Invoice) address in Bulk

[Henrik41]

Hello There,

    I am trying to figure out how the system differentiates between Billing and shipping address. How can the system know? Where is it in the database and how can I bulk change the billing address?

I have to bill the head office and need to change all my clients billing address.

Anyone knows?

Thanks

[jeanluc.12]

If you are checking the address only then there is no such identifier. Same address can be billing OR shipping address in differnet orders. 

So bascially address is shipping address OR billing address, its marked in order table (Orderwise). Refer to id_address_invoice, id_address_delivery column in order table for the same.

 

 

 

[Henrik41]

Many thanks Jean-Luc. I will change the values directly in my database then.