Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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č

pos order duplicated issue

Naroči se

Get notified when there's activity on this post

This question has been flagged
posodoov17
2 Odgovori
2047 Prikazi
Avatar
Oussama KHAFOU

Hello,

I am experiencing an issue in the POS module where certain orders appear twice with identical details (same articles, table, order number, etc.). The only difference is the timestamp, and as a result, the cashier ends up processing the payment twice, causing accounting discrepancies.

I would like to understand how to prevent this issue from occurring.


I'm using odoo v17 Community edition

0
Avatar
Opusti
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

This is a known issue that can happen in community setups due to network instability, client-side retries, or failure handling bugs.

Root Causes (Common in POS Community):

    Offline or unstable network

        If the POS goes temporarily offline, the order stays in the browser’s local storage and can be resent when back online, causing duplicates.

    Manual browser refresh or crash recovery

        The order may re-submit automatically from cache/local storage.

    No unique_order_id check on backend

        Odoo Community lacks built-in validation to reject duplicate orders based on unique POS order reference (unlike Enterprise with proper sync protections).

Recommended Fixes

1. Enable and enforce unique order identifiers

Modify your POS order model to reject duplicate orders based on a unique ID.

Step-by-step:

    Each order has a pos_reference (e.g., SHOP/0012).

    Add a constraint on pos.order to prevent duplicates.from odoo import models, api, exceptions

    class PosOrder(models.Model):

        _inherit = 'pos.order'

        @api.model

        def create(self, vals):

            if vals.get('pos_reference'):

                existing = self.search([('pos_reference', '=', vals['pos_reference'])], limit=1)

                if existing:

                    raise exceptions.ValidationError("Duplicate POS order detected: %s" % vals['pos_reference'])

            return super().create(vals)


Hope it helps

0
Avatar
Opusti
Avatar
Andreas Bichinger
Best Answer

Hi,

If both orders have the same uuid, you can prevent this issue by setting up a unique constraint for the uuid.

from odoo import models 

class PosOrder(models.Model):
     _inherit = "pos.order"
    _sql_constraints = [('uuid_unique', "unique(uuid)", "An order with the same UUID already exists.")]

Note: The database must not contain duplicate UUID numbers in order for the SQL constraint to be created. This means you need to delete duplicate orders (or change the uuid) first before creating the constraint.

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
Since 17.0, the "attrs" and "states" attributes are no longer used. Solved
odoo v17
Avatar
Avatar
Avatar
Avatar
Avatar
7
okt. 25
31637
How to Remove powered by odoo from online invoice footer ?
odoo v17
Avatar
Avatar
Avatar
2
jul. 25
2877
Restrict employee from cancelling pos order
pos v17
Avatar
0
jun. 25
1283
Payment methods in POS V17 Solved
pos v17
Avatar
Avatar
Avatar
2
jul. 25
2890
UncaughtPromiseError after insert and apply embeded code in the footer
odoo v17
Avatar
0
mar. 25
1850
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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