Skip to Content
This question has been flagged
1 Reply
10533 Views
Avatar
J C

Hi Odoo Community,

We are using pricelists as a base per customer (Odoo CE 10). Most customers get the default pricelist which is basically the price in the product card (unchanged). However, there are some customers who we give a discounted price. I am trying to import this complete discounted pricelist (Excel) into the database (Sales => Pricelists => Import). I fail to find an option to import those values based on Product names or external IDs of the products.

In the below screenshot I added 2 items manually. Since the price list consists of thousands of items this task is not recommended manually.

https://ibb.co/KswvMQt

So how do I add thousands of items by importing from excel? It seems the product name or ID variable is not importable in the price list.

Thx


Avatar
Discard
Avatar
Paresh Wagh
Best Answer

Create a csv template with the following columns and data and import it from the Sales > Products > Pricelists list view.

  • id

  • item_ids/applied_on

  • item_ids/compute_price 

  • item_ids/product_tmpl_id/id 

  • item_ids/fixed_price

The columns should contain the following values:

  • id: External ID of the Pricelist in which you want to import the data

  • item_ids/applied_on: 'Product'

  • item_ids/compute_price: 'Fix Price'

  • item_ids/product_tmpl_id/id: External ID of the Product template (i.e. Product master record)

  • item_ids/fixed_price: The unit price of the Product (the currency is already defined by you at the Pricelist level)

NOTE: 

  1. All the records will get inserted into the pricelist so you need to make sure the pricelist does not currently contain the records you are trying to import - otherwise you may end up with duplicate records.

  2. This example is based on the assumption that you are specifying the actual discounted price (Fix Price).

Here's a sample csv file for your reference:

id,item_ids/applied_on,item_ids/compute_price,item_ids/product_tmpl_id/id,item_ids/fixed_price
__export__.product_pricelist_7_6ff02fce,Product,Fix Price,mrp.product_product_computer_desk_bolt_product_template,10
__export__.product_pricelist_7_6ff02fce,Product,Fix Price,mrp.product_product_computer_desk_screw_product_template,20
__export__.product_pricelist_7_6ff02fce,Product,Fix Price,point_of_sale.whiteboard_pen_product_template,30
Avatar
Discard
J C
Author

My item_ids/product_tmpl_id/id look much different from yours. And I already tried importing those from my template but that doesn't work. Here's my template: https://www.dropbox.com/s/n3mk5drj7marazr/pricelist_test.xls?dl=0

Paresh Wagh

The id's are specific to each environment so they will mostly be different. Do you get any errors when you test the import ?

Paresh Wagh

If you are importing it as an xls file, try converting it into a csv file and see if that fixes things.

I simulated an import using the file structure you provided in your template and it works just fine when I imported the csv file.

J C
Author

Problem persists. Please look at below screenshots. I imported as CSV.

https://ibb.co/gy0kkvZ

https://ibb.co/wWXQP0M

Paresh Wagh

The external id's of the Products need to match the ones in your system. Go to the Product master and export the External Id and Name columns to get the actual id's of the products. Then use these in your csv file.

J C
Author

Solved!

Lindari Solutions

Thanks for this solution! I has helped me also.