Skip to Content
Menu
This question has been flagged
1 Reply
1586 Views

When starting a new database, I usually import everything with external_id so then I can reference the record.

Works great for products, suppliers, persons etc...

This time, I imported products (as templates) and generated all the boms. Problem is bom takes product.product both for the produce product and the componants.

What would be the normal way to generate my boms import ? Must I export product.product and try to rematch my ids ? And to get access to product.product I must activate variants then ?

Thanks

Avatar
Discard
Best Answer

Hello,

you can try this :

  1. import your products in product.template in inventory app with excel template with fields:


External ID
Product / External ID
Name
Cost
Price
Category
product1
product_product1
Product 1
100150All

External id: refers to product.template id

Product / External id: refers to product.product id

(you do not need to activate product variant configuration)

      2. add your BoMs in excel template with fields

External ID Product/External ID
BoM Lines /Component /External ID
bom1product1
product_product4


product_product5


product_product6

External id: refers to BoM external id

Product/External ID refers to product.template Id of the manufactured product

Bom Lines /Component /External ID : refers to product.product id of the component which basically imported and specified in the first step (product import) 

note : i have not mentioned fields like quantities or operation ....etc, you can add those fields as needed.

Hope it will help you.

Avatar
Discard
Related Posts Replies Views Activity
1
Jun 22
2238
6
Aug 24
3141
2
Oct 23
911
1
Oct 23
1181
0
Sep 22
1037