Jump to content
Henrik41

change Billing(Invoice) address in Bulk

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

 

 

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More