Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odpovědět
2667 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
čvn 22
3439
6
srp 24
4822
2
říj 23
2058
1
říj 23
2259
0
zář 22
1913