Blog Post

  • Home
  • Blogs
  • Import Bill of Materials from CSV/Excel file v16
logo
Community Enterprise Odoo.sh

Import Bill of Materials from CSV/Excel file

heading

This module useful to import bill of materials from CSV/Excel file.

Hot Features

heading
Import Bill Of Materials
Import From CSV
Import From XLS/Excel

Features

heading
  • Easy to import.
  • import csv or excel.
  • import product by Name, Barcode, Internal Reference.
  • Very well formated Excel and CSV files.
  • Easy to install and use it, No more configuration required.
  • This module saves your important time.

First you need to tick "Import Bill of Materials" group in order to import Bill of Materials.


"Import Bill of Materials" menu in master data


When you click "Import Bill of Materials" menu, wizard will open that looks like below


Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.


following fields are imported.


About Fields

heading
Column Mrp Model Field Name Description Required
A Bill Of Materials (mrp.bom) Reference You have to enter the product internal reference number. No
B Bill Of Materials (mrp.bom) Product Define the product name. Yes
C Bill Of Materials (mrp.bom) Product variant Define the product variant. No
D Bill Of Materials (mrp.bom) Quantity You have to enter the product quantity. Yes
E Bill Of Materials (mrp.bom) Unit of Measure Take the same name as ERP in the "UOM". No
F Bill Of Materials (mrp.bom) Material Product Define the Material of Internal Reference or Barcode. no
G Bill Of Materials (mrp.bom) Material Product Quantity You have to enter the product quantity. No
H Bill Of Materials (mrp.bom) Material Product Unit of Measure Take the same name as ERP in the "UOM". No

General Notes:

heading

1) Don't remove the column from the sample sheet given, you can leave an empty column if the column is not the required type. You can see the table above for that.

2) Don't change the sample sheet column sequence.

3) Please don't use excel if you don't know the very well sheet formatting which is given in the sample sheet. Use CSV for hassle-free import without format issue. If you want to use excel and want to clear the format then please check this video.
Watch Video


Your CSV file format must match like below.


following Your Excel file format must match like below.


Version 16.0.1 | Released on : 28thOctober 2022

Initial Initial Release.
  • Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & Premise) as well as Community.
  • No, this application is not compatible with odoo.com(odoo saas).
  • Yes, we provide free support for 100 days.
  • Yes, you will get free update for lifetime.
  • Yes, You have to download module for each version (13,14,15) except in version 12 or lower.
Schedule Import | Import Base v16

Transforming Businesses with Next-Gen Solutions

Our next-generation solutions are built to transform businesses and drive growth in the digital era.

Find Us

905, Corporate Levels, 150 Ft. Ring RD
Nr. Ayodya Chowk, Opp Synergy Hospital
Rajkot 360006

Contact No.

HR : +91 90232 46069
Sales : +91 93288 25451

Reach Us Read Blog Contact Us Submit Support Ticket Watch Video Tutorial