Skip to Content
Menu
This question has been flagged
3 Replies
332 Zobrazenia

Hello Odoo Community,

I need help with importing products into a new Odoo database.

Here is my situation:

  • I already created the same companies in the new database as in the old one.
  • The same product categories are also created.
  • Some products must belong to more than one company.
  • Some products have multiple barcodes.

I exported the products (screenshot attached) with fields like:

  • Name
  • Can be Sold / Purchased / Available in POS
  • Product Type
  • Invoicing Policy
  • Unit of Measure / Purchase UoM
  • Sales Price / Cost
  • Internal Reference
  • Barcodes
  • Companies


I want to make sure I follow the right method and avoid errors.

Thank you for your guidance!

Avatar
Zrušiť
Best Answer

Hello,

Please Refer the Video:


Avatar
Zrušiť
Best Answer

Hi,

To import the product, please refer to the following link.

https://www.cybrosys.com/blog/how-to-import-products-and-product-categories-in-odoo-17

https://www.odoo.com/documentation/18.0/applications/sales/sales/products_prices/products/import.html

https://www.youtube.com/watch?v=Kn2P71Q3-o0


Hope it helps

Avatar
Zrušiť
Autor

I have a problem with the barcode and the company field because some items have more than 2 barcode codes

Best Answer

A single Product neither can have multiple Companies assigned to it nor can it hold multiple Barcodes*.

A product can either be assigned to a single or none (all) Companies. If you have multiple Companies, each one allowed to access a subset of your catalog, you either need to go for customization or create the distinct Product for each Company.

About Barcodes: Please reconsider your approach since the point of using a Barcode is to identify a specific product, thus, different Barcodes => different Products. You could, cover this with Product Variants though (what the differentiating Attribute and Value on these Products would be is up to you) - yet, these would still be different Products. Alternatively, and I would assume that's where this stems from, you could define multiple Supplier Codes for a single Product (under the Purchase-tab of a Product [when the Purchase App is installed]) in case these different 'Barcode' originate from them.
Alternatively, you may set up a custom Barcode Nomenclature (even though, I would not advice you to do so given the limited information at hand) so you could, theoretically at least (depends on what you need them for later on) - or simply comma separate them in your import file.

Also, in general: Create a few Products in Odoo manually and export them to have a relevant example set from which you can work your way to the full catalog.

Avatar
Zrušiť
Autor

Thank you for the explanation. Let me clarify my case with examples:

About Barcodes:

In the first purchase, I bought Product A with one barcode.

In the second purchase, I bought the same Product A but the supplier used a different barcode.

This is my problem: how to manage when the same product comes with multiple barcodes from different purchases.

About Multi-Company/Branches:

I have a setup with multiple companies and multiple branches.

Some products I want to be visible/available in certain branches, but I don’t want them to be visible in other branches.

What is the correct way to configure or handle this?

"Some products I want to be visible/available in certain branches, but I don’t want them to be visible in other branches." - as said, this is not possible. Its a "Many2one" Relationship - either one Company can be selected or none.