Skip to Content

Import Customers and Suppliers Excel

4.80 6.00

Technical Name
odoo_customer_supplier_import_csv
Subscribe to download Add to collection

Streamline your contact database management with the Import Customers & Suppliers from CSV module. This essential tool is designed to eliminate the inefficient and error-prone task of manually creating partner records one by one. By allowing you to import comprehensive customer and supplier details including company information, contact persons, addresses, and commercial data in bulk from a single, well-structured CSV file, you can build and maintain a robust contact database with unparalleled speed and accuracy. This module is the ideal solution for migrating data from a legacy system, onboarding a large number of new clients or vendors, or simply keeping your partner information consistently up-to-date.

  • Import both customer and supplier (partner) data from a single, unified CSV file.

  • Flexibility to either create new partner records or update the information of existing ones.

  • Differentiates between individual contacts and company records during the import process.

  • Import a wide range of partner details, including name, address, phone, email, website, and language.

  • Set key commercial information such as salesperson, payment terms, and pricelists.

  • Assign specific accounting details like receivable and payable accounts.

  • Includes a clear, easy-to-use sample CSV file to ensure your data is perfectly formatted.

  • Provides intelligent data validation to prevent duplicates and ensure data integrity.

  • Drastically reduces the time and effort required for contact data entry and management.

  • Ensures a high degree of accuracy and consistency across your entire partner database.

  • Accelerates the setup process for new implementations or company migrations.

  • Streamlines the onboarding of new customers and suppliers, improving business agility.

  • Enables easy and efficient bulk updates to contact information.

  • Improves the quality and completeness of your CRM, sales, and purchasing data.

  • Empowers your teams with accurate and readily available contact information to drive business growth.

This module allows you to import Customers / Vendors / Contacts using excel files.


Main Features
  • Allow you to Import Customers, Suppliers, Contacts and Partners.
  • Make sure you have xlrd python packages installed.
  • For more details please watch the video and check below screenshots.

Menus Available:

  • Sales
    • Imports
      • Import Customers / Suppliers

Sales : Imports/Import Customers/Suppliers

Wizard to Select Excel - Import Customer / Suppliers

Sample Data of Excel- Import Customers

Created Customers after Running Wizard

Form Of Created Customer

Form Of Created Customer - Internal Notes Tab

Form Of Created Customer - Sales & Purchases Tab

Sample Data of Excel -Import Suppliers

Created Suppliers after Running Wizard

Form Of Created Suppliers

Form Of Created Suppliers - Internal Notes Tab

Form Of Created Suppliers - Sales & Purchases Tab