Import Error: Part matching query does not exist

[motusRP]

I'm trying to set up a new Inventree system and migrate some existing spreadsheet-based parts lists. Working on 0.14.4.

So far i've been using Google Sheets to reformat our current parts lists into importable tables that i'm saving to CSV and then using the Admin pages to import in bulk. I've been able to:

• import a Categories breakdown that matches our current system
• import Companies, and correctly flag them as Manufacturers and/or Suppliers
• import the Parts themselves

Now i'm trying to import a list of Manufacturer Parts, and while i've managed to create a CSV with the correct ID numbers for the part and manufacturer, when I try to import i'm getting this error:

In this case the Part already exists in the Parts table (yes, the Name and IPN are the same):

And the Company is in the Companies table as well:

I'm sure i'm doing something wrong here but I can't figure out what. My import CSV for the Manufacturer Parts doesn't generate any errors (I corrected the ones it detected) this error about a part matching query is new.

Any help appreciated!

[SchrodingersGat]

@motusRP this feels like an issue with the underlying "parts" are not marked as "purchaseable". In the underlying model for the ManufacturerPart table, we have this:

This will likely throw the (very unhelpful) error message you are seeing.

Can you confirm if the parts you are trying to link to are designed as "purchaseable"?

[motusRP]

Bingo! That's it. I knew I was missing something fundamental. With that corrected, it imports correctly. Thanks very much!

[HamzaF-m]

Hello MotusRP,

I'm having the same issue while migrating the data, where and what file i should make changes to, please advise?