Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
3 Trả lời
340 Lượt xem

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!

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Hello,

Please Refer the Video:


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Tác giả

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

Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Tác giả

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.