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č

Can i switch a product to become a variant of another product, without losing data?

Naroči se

Get notified when there's activity on this post

This question has been flagged
2 Odgovori
6830 Prikazi
Avatar
Zakaria Al-Hakeem

We have products with several variants created on our database as "individual products". We have done several transactions on them as well (Purchase, Receipt, Transfer, SO, Invoices...etc.)

Is it possible to switch these products into "Product Variants" and group them together, without losing the data or at least messing up the previous process?

 

Example:

Our products look like this at the moment:

Product 1: Speaker123-Color Red (Product_Template_1), Barcode:10

Product 2: Speaker123-Color Black (Product_Template_2), Barcode:11

Product 3: Speaker123-Color Blue (Product_Template_3), Barcode:12

 

We need to convert it to:

Product 1: Speaker123

                Product Variant 1:  Speaker123-Color Red  (Product_Template_1), Barcode:10

                Product Variant 1:  Speaker123-Color Black (Product_Template_1), Barcode:11

                Product Variant 1:  Speaker123-Color Blue (Product_Template_1), Barcode:12

 

Is there any way to do this either with an app or without? 

Thanks
2
Avatar
Opusti
George Mountanos

Please let me know if you figured this out!
Thanks in advance

Cycles Treize

Hello,

I want to achieve the same thing here (v16).

But i can't find how to re-import old variants with the new created parent model.

What fields do i need ?


Thanks a lot

Avatar
Ermin Trevisan
Best Answer

I did not try it, but maybe it gives you an idea:

Create the necessary attributes and the attribute values.


Each product.template record also automatically creates a product.product record (variant), even if no variants are created explicitely. You may want to create a new product template with  the  corresponding  variants , then go to the corresponding newly created product variants and export them to  see  the  External  ID  of  the  corresponding  product  template and the  fields  for  the  attribute  values . 

Also export the product variants of the old product templates. Then in the  product  variant  records  replace the External ID of the product template with the External ID of the newly created product template,  add the  attribute  fields  and  reimport  the  product  variants. Then delete  the  automatically  created  product.product  records  of  the  new  product  template.  Maybe it works.

But make a database backup before!

6
Avatar
Opusti
Gross Ricardo

Nice solution but, if I try to import (Odoo v15), in my case 3 variants, I get an import error:
"new row for relation "ir_model_data" violates check constraint "ir_model_data_name_nospaces" DETAIL: Failing row contains"
If I import only one variant, it works!
How to solve this error?

Avatar
Zakaria Al-Hakeem
Avtor Best Answer

This solution worked perfectly!
I'm keeping an eye to see if there are any future hidden consequences. But so far all went well. Thanks a lot.

0
Avatar
Opusti
Rabbit Trade

Did it work well for you, I wnt to try it but I'm bit worried it would ruin my db

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

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

Prijavi
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