Hi,
I am using the online demo for evaluation purposes. My first company I created a list of inventory items, a vendor buy price list with those same items and a sales pricelist with those items also.
I wanted to start again so created a new company and wanted to repeat the steps. Inventory import and vendor pricelist item import is easy. However I cannot find how to import items into the sales pricelist. Now import button when in the price list, I have developer mode enabled and I just cannot find how to do it.
Can someone assist please?
Many Thanks!
Gary
Hello,
Can you please mention the version?
Are you talking about Products-> Pricelists, right? Or items in the Price tab in Product?
Sure it’s
19.2+e.
Yes Sales->Products->Pricelists.
So company 1 I imported a file which gives me
I cant remember how I loaded them but there is no import for products within pricelist:
@Chris thanks but that's to import pricelists, not pricelist items.
@Santosh I go to the pricelist but there is no 'Pricelist Items' button anywhere. I only have two views; Sales->Products->Pricelists which shows a table of all pricelists. If I go into a pricelist I can add a rule but no option to import anywhere.
I have a call today with one of the pre-sales guys at Odoo so will ask and report back.
You can't import pricelist items directly. you can achieve this by adding like this columns into excel file
item_ids/id item_ids/applied_on
__export__.product_pricelist_item_14_bd9b3d31 Product
website_sale.item_benelux All Products
Hi Gary - I added an example of an Excel file that should allow you to add products to a price list.
First off, thank you all for prompt and helpful replies, it is appreciated and hopefully as my learning improves I can pay it forward!
OK, so I figured it out. As some of you have suggested you import at the price list level rather than an 'items' level.
So I created a pricelist; Mitel List GBP and then exported it to get the ExternalID. Then my CSV is simply:
product_id/id,fixed_price,pricelist_id
10000,530.0,__export__.product_pricelist_203_53c91775
....
Then on the import I have:
product_id/id mapped to Pricelist Rules / Product /External ID
fixed_price mapped to Pricelist Rules / Fixed Price
pricelist_id mapped to External ID
And that works!
thanks again all!
Gary