Bulk Product CSV import error: "Quants cannot be created for consumables or services. at multiple rows Resolve other errors first"

Question

I'm using an exported template to format and add around 400 products.  All my columns are empty except for the "Product" Column, and importing is turned off for all other columns.

Here is the full error message: "

*Unknown error during import: : Quants cannot be created for
consumables or services.*

at multiple rows

Resolve other errors first

"

Here is an example row

Product Lot/Serial Number Quantity Counted Quantity Difference Scheduled Date Assigned To
Cao 017 4/4 Violin

thanks for

Jordan Henc · Accepted Answer

I had this Issue for a while trying to bulk import quantities, I thought it was some of the products were marked with "Service" or "Consumables".
It actually ended up being 2 items that caused the issue, they didn't have the "Track Quantity" box checked in both of them.
I went to Products, then clicked on the search bar and made a "Custom Filter", typed in "Track Inventory" then selected as "not set". Clicking "add" I was able to see the 2 items and changed them to Track Inventory.
This fixed my

Geoffroy Bléry - Sword Group · Answer

Hello, I am facing the same issue I checked the my Excel file and do not have any Product set as consummable or service in it.

Ray Carnes (ray) · Answer

Remove all products from your file that are configured in Odoo as Consumable products.

No inventory is managed for these product types as they have no value and are used for products you internally consume: Office Supplies, Break Room Supplies, Janitorial Supplies, etc.

Remove all products from your file that are configured in Odoo as Service products.

No inventory is managed for Services. They are used for Consulting, Cleaning, Design, Engineering, etc.

المنشورات ذات الصلة	الردود	أدوات العرض
error when starting inventory error inventory	1 يونيو 19	4613
Import initial inventory stock with lot nos via inventory adjustment for multicompany. error inventory lot	3 أغسطس 25	7117
Inventory Adjustment with lot issue error inventory InventoryAdjustment	0 ديسمبر 22	3192
?"Your country might be blocked by our hosting provider" error when I create new website error	0 أكتوبر 25	584
Odoo Inventory Valuation Report inventory	3 نوفمبر 25	7352

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

Product	Lot/Serial Number	Quantity	Counted Quantity	Difference	Scheduled Date	Assigned To
Cao 017 4/4 Violin