Skip to Content
This question has been flagged
importcsvpricelist
7 Replies
12392 Views
Avatar
Elliot Mitchell

Hello I've been trying to import some Price Lists using a .csv file but I've been having no luck. I was wondering if anyone could give me some hints or even a template to layout the file. I need to be able to have a name, start date, end date, the rules to apply, which products they apply to, which prices this rule applies to and also the customers I want to use this price listwq. Any help would be greatly appreciated. 

Avatar
Discard
Avatar
Dovydas Bagdonas, UK
Best Answer

Dear Elliot,

The easiest way to get a correct template for importing pricelists is to create one example of pricelist manually in Odoo and then to export the pricelist as CSV file. After you do this, you will have a correct template for data import and you will be able to modify your template and import it back into system. Write back if you face any further problems

Avatar
Discard
Avatar
Hilar Andikkadavath
Best Answer

Have a look here

Odoo Pricelists 

Avatar
Discard
Avatar
Elliot Mitchell
Author Best Answer

Thanks Dovydas,

I made the template and got the fields names I needed. 

Avatar
Discard
Avatar
Thuy Ngoc
Best Answer

Hi Enki Denys and Abou Bakr,


I think this video can help you: https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1 (starting at 55:00 in this video)

Avatar
Discard
Avatar
Enki Denys
Best Answer

I can export the price list, but its line items contain only the product name. There seems to be no option to upload the price, which is odd, given that it is a "price"list after all.

Avatar
Discard
Abou Bakr Seck

I'm having the same issue. Any solution ?

Avatar
ANGEL ADAN RAMIREZ ISEA
Best Answer

@Tim Turnquist: I used a database manager and looked at the table product_pricelist_item.

Avatar
Discard
Avatar
Tim Turnquist
Best Answer

I know this is an old thread, but in version 11 there is no Export function for Pricelists to see what fields and values need to be passed. Can anyone point me in the right direction to find the file format to import Pricelists based on a fixed price by Product Variant?

Avatar
Discard
Related Posts Replies Views Activity
How to import a new fixed-price price list from Excel? Solved
import pricelist
Avatar
Avatar
Avatar
3
Oct 24
3049
Disable automatic follow when importing res.partner csv
import csv
Avatar
Avatar
Avatar
3
Jun 20
3115
Enable/disable import rights?
import csv
Avatar
Avatar
1
Nov 18
8565
'utf8' codec can't decode byte error when importing a list of products as a CSV file Solved
import csv
Avatar
Avatar
Avatar
Avatar
Avatar
11
Feb 17
62497
Import contacts through CSV Solved
import csv
Avatar
Avatar
2
Mar 15
10289