Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

How do I quickly/easily add Payment Terms for 1,000 Customers (Bulk update) in Odoo 8?

By
TVDC
on 12/24/14, 9:00 AM 1,498 views

Hi

 

We have about 1000 customers in Odoo 8, but they do not have a Payment Term assigned. We created these terms, and now we want to assign them to our customer. Is there a way to bulk update them instead of updating one by one?

Can this be done via the web interface or can we do this in the database?

 

Thanks!

yout tilte says Odoo 8 and in your post you say Odoo 9. I guess that (Odoo 9) is a mistake?

gunnar
on 12/24/14, 7:38 PM

Hi Gunnar, indeed I meant Odoo 8. I've edited the original post.

TVDC
on 12/25/14, 7:30 AM
2

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 12/24/14, 10:39 AM

Use the export/import functionality from Odoo itself for this. In the GUI, select all the customers and click "More --> Export". How this is done can be found on this forum (what options need to be ticked etc.). Make sure that at least 1 partner has already got the right ID for the payment term selected. In that way you can easily see which ID needs to be used for all the other records.

Then open your file in Excel or something similair. Assign the right ID to all the records for the partner.

Once that is done, import the updated list in Odoo by clicking the "import" link/button on the list view of the partners. All the records that already exist will not be newly created, but changes will be overriden. Very handy in case you only need to change 1 or 2 fields, like in your example.

Hope this helps.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 12/24/14, 9:00 AM
Seen: 1498 times
Last updated: 12/22/15, 12:58 PM