Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to create BOM using .csv import/export?

export import bom .csv

2 Odpowiedzi

27977 Widoki

joyal

I want to create BOM with BOM Lines, using .CSV files. Can any one susggest how to add BOM lines in .CSV files. I want to configure 1 BOM with->4 BOM lines using .csv files.

Patrik B

Najlepsza odpowiedź

Create a BoM with 2 or more lines (products) selected from available products in the database. This will be your template.
Select all necessary fields including all the mandatory blue fields. Create an Import Compatible Export csv file. In addition to the BOM fields, you will probably need the following fields, bom_lines/name, bom_lines/product_id/id and bom_lines/product_uom/id for each line added.
Modify the csv file as needed add new BOM and new lines. OpenERP will link each product_id to a product in its database.
Save the csv file then import back in.

Note: If the added lines (products) in BOM don't already exist in OpenERP, then you must first import all products into the products database then export them to csv format. Using the product_id in the Products csv file, create the BOMs in the BOM csv file then import them to OpenERP BOMs.

Mustufa Rangwala (mra)

You can export one one of your already created BOM with its BOM line in csv format. And you can use same csv file to import with your BOM and BOM Lines.

Regards, Mustufa Rangwala

joyal

Autor

I am getting errors. can you please provide any BOM import .csv tested template if you have... Thanks for your assistance in advance.

Mustufa Rangwala (mra)

Can you tell me which error you are getting ? There is not specific template I am having..

Ray Carnes

Export the products (Warehouse -> Products) that you are using in your BOM first (before trying to export the BOM). This makes sure that OpenERP generates an XML ID for them. If you don't do this, OpenERP will fill this value in and, often, gets it wrong. After you have done this, follow Patrik B's answer.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Import-Compatible Export export import bom bom_import	1 lut 19	5068
Price Update export import	2 lis 24	2328
Export/Import Issue: "Root articles must have internal permission" Rozwiązane export import	1 lis 24	3204
Import exported CSV on module load export import	1 paź 23	3940
How to import and export with woocommerce? Rozwiązane export import	3 gru 23	21735

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!