Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
2615 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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.

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
cze 22
3341
6
sie 24
4679
2
paź 23
1969
1
paź 23
2167
0
wrz 22
1857