Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
importcsvpricelist
7 Odgovori
13265 Prikazi
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
Opusti
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
Opusti
Avatar
Hilar Andikkadavath
Best Answer

Have a look here

Odoo Pricelists 

Avatar
Opusti
Avatar
Elliot Mitchell
Avtor Best Answer

Thanks Dovydas,

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

Avatar
Opusti
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
Opusti
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
Opusti
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
Opusti
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
Opusti
Related Posts Odgovori Prikazi Aktivnost
How to bulk import new prices into a price list using an Excel template
import pricelist
Avatar
Avatar
1
avg. 25
810
How to import a new fixed-price price list from Excel? Solved
import pricelist
Avatar
Avatar
Avatar
3
okt. 24
4167
Disable automatic follow when importing res.partner csv
import csv
Avatar
Avatar
Avatar
3
jun. 20
4182
Enable/disable import rights?
import csv
Avatar
Avatar
1
nov. 18
9657
'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
64011