Skip to Content
Odoo Menu
  • Sign in
  • 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
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Contradictory error message about ambiguous specification for field

Subscribe

Get notified when there's activity on this post

This question has been flagged
v8importinventoryquantities
3 Replies
9592 Views
Avatar
Jeff Beidler

I'm still trying to import product quantities through the Inventory Adjustments screen. (This is how we did it in v7.)  I created an inventory adjustment record for a stock location, then exported the record to get the ID.  When I try to import product quantities using this ID, I get the following error message:

  • Ambiguous specification for field 'Inventoried Product', only provide one of name, external id or database id at row 2 (60 more)
  • Missing required value for the field 'Inventoried Product' (product_id) at row 2 (60 more)

If I only supply the name of the product, the validator complains that it wants the product_id. If I supply both the product_id and the name (as "Inventoried Product"), then I get the above message.  If I drop the name and only use the product_id, then it complains that there is no "Inventoried Product"!!!  It's like the system wants it both ways, but also dislikes both ways.  What gives?

Any help toward importing initial QoH from a different system would be much appreciated!

1
Avatar
Discard
Avatar
Dennis Ndegwa
Best Answer

Did you ever find a solution to this? I have been stuck here for the longest time. I am avoiding a scenario where i will have to do the adjustment manually per product. I have about 600 entries to make.

0
Avatar
Discard
Avatar
Thomas Guénard
Best Answer

I have the same difficulty/impossibility to import an inventory from a csv file: the inventoried location I am providing is not accepted by the system; whatever value I am trying.


This seems to be a bug for the V8 I am Using (Odoo Saas option)

0
Avatar
Discard
Avatar
Damodar D.
Best Answer

If you import three products with no data for one of them you will get this exact error for that row.

name seller_ids/name/id

product1 __export__.res_partner_100

product2

product3 __export__.res_partner_101

It seems that if you have the field id listed as something you want to import, it must be fully populated for each row.

To work with this as it is, simply remove the rows from your import if they don't have the location_ids/name/id info available for that product. Then do another import of the those missing items without that field being imported.

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

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

Sign up
Related Posts Replies Views Activity
opening stock
import inventory
Avatar
Avatar
1
Apr 25
2578
Receipt Transfer import record issue
import inventory
Avatar
Avatar
Avatar
Avatar
3
Oct 23
3579
Error when importing inventory line
import inventory
Avatar
Avatar
1
Feb 20
4017
Inventory ageing report
v8 inventory
Avatar
Avatar
Avatar
Avatar
Avatar
21
Apr 18
16431
Where are the rest of the records? Solved
v8 import
Avatar
1
Mar 15
4166
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