Hello guys! I've been setting up my Odoo account and importing my ERP from an Excel spreadsheet. However, I'm having trouble with the color, category, and size attributes. I'm selecting the option to create new records, but I keep getting an error. Also, I'd like to know if it's possible to import a bulk price list for my wholesalers, since from what I've seen, it only allows creating prices for individual products.
This question has been flagged
2
Replies
1182
Views
You can import price lists for multiple products. There's a template available:
You could create the Price List with two products, then export it and add more lines for more products as per the template.
Importing variants can be a bit tricky, there are several questions about this on this forum including: How to import products with variants and attribute prices
Hi,
Yes, you can import price lists for wholesalers in bulk. Odoo allows importing vendor price lists using XLSX or CSV files. The best way to get the correct format is to export a price list first to use as a template. Go to the object view where you want to import the data, click the gear icon, and select "Import records". Upload your file, ensure the fields are correctly mapped, and import.
When importing data, use Excel or CSV files and utilize the provided templates to ensure correct formatting. Pay attention to formatting options, especially date formats, when using CSV. Use unique identifiers like name/code, Database ID, or External ID to relate data to existing records. Always test your import before fully importing to ensure data validity.
Reference:-
* https://www.cybrosys.com/blog/how-to-import-product-attributes-and-product-variants-in-odoo-17
Hope it helps
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Mar 25
|
2859 | ||
|
0
Apr 26
|
698 | ||
|
2
Feb 26
|
1340 | ||
|
1
Aug 25
|
1686 | ||
|
3
Feb 25
|
3477 |
