Fixed issue: Products are duplicated if we do not import the "item_ids/id" field.

make sure you have it!

Hi,

The issue of duplicate pricelist items when updating prices in Odoo arises because Odoo identifies records by their unique external ID. If the import file lacks or has incorrect IDs, Odoo creates new items instead of updating existing ones.

To fix this, export the pricelist items, ensuring you include the "ID (External ID)" field. Modify the prices in the exported file, but do not change the external IDs. Import the updated file, verifying that you're mapping the columns correctly, especially the "ID (External ID)" field. Double-check IDs, use the correct import option, test with a subset, and ensure proper encoding and decimal separators. The key is to maintain accurate external IDs for Odoo to recognize and update existing records.

Hope it helps

Could you explain how exactly you accomplished this? I am having trouble finding the item external ID to link. Currently, when I import my pricelist, the "Pricelist Item" is duplicated. I have tried using the DatabaseID integer in the import, but that doesn't seem to work and still creates a new record.

EDIT: I figured it out! Below is a quick video on how to export Odoo Pricelists with the individual "Pricelist Rule" External ID so you can overwrite or update records when importing.