Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Odobritve
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Estate Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
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
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
Pomoč

Too Many Products Get Accidentally Created

Naroči se

Get notified when there's activity on this post

This question has been flagged
creationquotationproducts
15 Odgovori
12193 Prikazi
Avatar
Michael C

I've found that my users are accidentally creating way too many garbage product records directly from the sales order/quote form. I'd like to curb this.

Odoo makes it pretty easy to create a new product record from the quotation/sales order form. If you start searching for a product and don't find it, the default option is to create it if you press "enter". Many users are in a hurry and just press "enter" mindlessly, creating the new product record. This leaves a lot of cleanup to be done later. I can usually find the products because they are "Consumables" by default, with a $1.00 price, no internal reference, no description, etc.

I've tried marking the Internal Reference field as required. I thought this would help because you can't enter the internal reference from the product form, so therefore users wouldn't be able to create records mindlessly. This didn't work. It seems that products created from sales orders/quotes completely skip model validation (!). As long as there is something in the product field Odoo will blindly create the product.

Does anybody have a solution to prevent users from blindly creating product records from the sales order/quotes form?

1
Avatar
Opusti
Thomas Guénard

The question remains whatever bypass or blocking rules are: why do the users "accidentally" create new products instead of refering to approprite existing ones?

I can imagine 2 causes

1 the users do not well know the way the products are named into the system (name or reference or any other form of index) >>> make sure the naming conventions are the cleanest possible and train users

2 the searching function is using "brute force" i.e not accepting alternative orthograph, or not refering to additional fields >>> allow developpers to improve the searching function.

Avatar
Ray Carnes
Best Answer

Remove the ability to create products on the sale.order form view:

<field name="product_id" options="{'no_create': True}"/>
1
Avatar
Opusti
Michael C
Avtor

This ended up being the simplest solution. Thank you.

Lima Saudara

Where is the path for the sales.order?

I tried it on odoo13/addons/sale/view/sale_views.xml

but it does not have any effect.

Avatar
Chris TRINGHAM
Best Answer

It turns out to be not quite so straightforward to do this in Odoo Studio (Odoo 13):

  1. The widget is product_configurator
  2. No checkboxes for “Disable creation” and “Disable opening”

The workaround is to change the widget

Now those two checkboxes are visible, so:

  1. Click on both checkboxes
  2. Exit Studio
  3. Now there’s no option to add a product:

This is the Extension View:

This is the XML

<data>
   <xpath expr="//field[@name='product_template_id']" position="attributes">
    <attribute name="options">{"no_open":true,"no_create":true}</attribute>
<attribute name="widget">many2one</attribute>
</xpath>
</data>

If you don’t have Odoo Studio you could achieve the same effect by creating an Extension View manually.

I think you can remove the line that changes the widget

https://odootricks.tips/prevent-users-create-products-on-the-fly/

1
Avatar
Opusti
Avatar
Seth
Best Answer

Is there any way this solution (<field name="product_id" options="{'no_create': True}"/>) can be implemented through the "Studio" app?  I've tried various ways of entering this option in both the "domain" and "context" fields, to no avail.

If not possible, can someone please walk me through where to enter the <field name="product_id" options="{'no_create': True}"/>? ...preferably starting from the odoo dashboard.

1
Avatar
Opusti
Lima Saudara

I also tried it on odoo13/addons/sale/view/sale_views.xml

but it does not have any effect.

so, someone please give us information where should we put that code?

Chris TRINGHAM

I added information about doing this in Studio (https://www.odoo.com/forum/help-1/question/re-too-many-products-get-accidentally-created-170519/#answer-170519

Avatar
Raaj Mishra
Best Answer

HI Michael, you can use the below syntax at sale.order.line view for product_id field to prevent users to create the product from Sale Order/Quote form view.

<field name="product_id" options="{'no_quick_create': True,'no_create_edit':True}"/>
1
Avatar
Opusti
Avatar
Arnaud ATIR
Best Answer

Thanks ray Carnes,

it helped me so much

i did it for sale.order.form, purchase.order.form and stock.picking.form

the difficulty is to find the right line to add this option but after several trials, i got it and it was a different line for each form

0
Avatar
Opusti
Lima Saudara

Where is the path for the sales.order?

I tried it on odoo13/addons/sale/view/sale_views.xml

but it does not have any effect.

Arnaud ATIR

Hi LIma

the simple way i found is to modify it by the web interface

It is surely not the right way but it worked for me. You can do as below :

1/ connection in developper mode

2/ open a sale order

3/ cilck on develpment tools ( top right corner )

4/ select the item ' modify the view : form '

and then you can modifiy the model form

hope it will help

kind regards

Ermin Trevisan

@Arnaud You will loose these amendments as soon as you update Odoo or the corresponding module.

Arnaud ATIR

Hi Ermin,

I know the risk yes but as i'm not a programer, it was a simple way.

We don't plan any upgrade and it is the lonely one amendment done so it is noticed in our software guide

Avatar
Mohammed Amal N
Best Answer

You can set some validation on create function of the product

example:

def create(self, vals):

     if not description: # get description value from vals

         #some warning code

0
Avatar
Opusti
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
Difficulty in Product Creation
project creation products
Avatar
0
avg. 23
1828
Create Date / Date Order option not available in Quotation 9.0c
creation quotation 9.0c
Avatar
Avatar
2
maj 16
6179
V16: "show more" choice on product line is not visible in the quotation
selection quotation products show-more
Avatar
1
nov. 22
2257
Creating Products From POS Interface?
pos creation products odoo
Avatar
Avatar
1
maj 21
4380
Ask for a Product Category on Sales Orders and restrict products that can be added to that Category? Solved
quotation category products restrict
Avatar
Avatar
1
jul. 20
5722
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now