Importing vendors product assosiation and information

Question

Hi!

I am new to Odoo and trying to make initial imports! I have all the products imported correctly. Now I need to import Supplier (vendor) info. I have Excel with
Internal reference (our sku), vendor (supplier), price (supplier price), product code (supplier sku)
I do not have these items in Odoo price list at all so I want to make new price list rows with this info. I can export test product with this info and then change and import it but I do not know how to make new items. I need to match

Mindaugas · Accepted Answer

Hi,
extract imported product external id(name/ref for lookup).
like this:
the simple file can be like this

Go to purchase/configuration/vendor pricelist and import. main fields in print screen.

and yes, you can add multiple vendors to product (so will need sequesnce column), lead time if needed and etc.
but principal is this one.
if you will need to update vendors pricelist, extract external id vendor pricelist and use them to update things like you need (qty/price and etc.).

Mikko Kankaanpää · Answer

Thanks for the detailed answer! That works! I was hoping that I could do it without an external ID (less work if I would not need to match my excels with exported external ID per row) :)

관련 게시물	답글	화면
Import Vendor Pricelist with Vendor Variant data import Odoo13 vendorPricelist	0 8월 20	3336
Print internal Barcode labels purchase barcode vendorPricelist InternalReference	1 10월 24	1449
Issue with import and comma in Excel File (odoo 19) import	0 9월 25	233
Importacion de Atributos y Valores import	2 5월 25	1962
Import from Winbooks 해결 완료 import	4 5월 25	6019

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!