Hi,

To import variant-specific sales prices into Odoo from Excel, the most reliable method is to include the "External ID" of each product variant in your Excel file, along with a "Price" column for the new sales price. Alternatively, if External IDs are unavailable, use the "Product Name" and separate columns for each attribute (e.g., "Color: Red", "Size: M") to uniquely identify variants.

In Odoo, navigate to the Product Variants list view, initiate the import process, and map the Excel columns to the corresponding Odoo fields (External ID or Product Name/Attributes, and List Price). Test the import before confirming to ensure data accuracy. Using External IDs is highly recommended, and always back up your data before importing.

Reference:-

* https://www.odoo.com/documentation/19.0/applications/sales/sales/products_prices/products/import.html#:~:text=To%20do%20that%2C%20navigate%20to,returns%20to%20the%20Attributes%20page.

* https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/purchase/products/pricelist.html#:~:text=After%20inputting%20everything%2C%20import%20the,that%20appears%2C%20click%20Import%20records.