Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
会計
在庫
PoS
プロジェクト
MRP

All apps

全てのポスト人々バッジ

タグ (全て表示)

odoo accounting v14 pos v15

このフォーラムについて

ヘルプ

How to import hundreds of product categories without ids?

product import supplier categories importing

1 返信

8556 ビュー

Sean Samborski

So I have hundreds of product categories, hundreds of suppliers, and so on. I have thousands of products to import and have no way of knowing how to do this. It appears as though OpenERP wants only ids, never names. This would be an impossible task to somehow (I wouldn't even know where to begin) figure out all the ids for each supplier, category, etc.

I have tried categ_id/string as the value and when importing I've tried anything on Categories and Suppliers. For example, importing the supplier column and trying Supplier/Company returns "No matching record found in field Supplier" etc. I must be missing something as importing should be this difficult to figure out.

Thanks for any advice.

Nicolas Flamen

I'm in the same boat - did you get this figured out and if so, how?

Sean Samborski

著作者

I haven't made it back around, but I'm no closer now than before. It's frustrating and there isn't much documentation on the matter.

Fabien Pinckaers (fp)

最善の回答

The import tool support string or IDs. It's more reliable to use ID if you can, but if you can not you can use strings. To import with string, just set "categ_id", instead of "categ_id/..."

Sean Samborski

著作者

It's not that I don't want to use IDs, I would if I could, but it's impossible to get all the relationships between-> Name -> product.product_category_17. That's what my export prints out when I do a test and there's no way I can know what id is what for the suppliers and the categories.

Sean Samborski

著作者

I also don't know what you mean by use just categ_id...I have only three options to choose from when trying an import (Category, Category/External ID, and one more but it says ID). I've tried all three and none work with a string.

Ray Carnes

The Categories and Suppliers have to be imported first, before products - have you done that?

Sean Samborski

著作者

These are already created and available when editing or adding new products.

Ray Carnes

OK. Create one record manually, via the UI, and then export it. You will see from the CSV what format the data needs to be in and how you can set categories.

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！

今すぐアカウントを作成して、限定機能を利用したり、素晴らしいコミュニティと交流しましょう！

登録

関連投稿	返信	ビュー
Importing products and suppliers 解決済 product import supplier	4 12月 23	22925
Import product and supplier using CSV 解決済 product import csv supplier	5 12月 23	18172
What should be used in "seller_ids" field to specify a given supplier while importing products? Is it possible to use the "external id"? product import csv supplier	2 5月 15	7258
Importing Products with Supplier Info product supplier importing python2.7	1 3月 15	10922
Importing Product Images product import image importing importing data from excel file	1 4月 19	7389

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！