Home Button  Buy Button 

Topic:   Importing new supplier prices

By: treyPosted on: Jun 4 2026 at 02:32:15 PM
Is it possible to import new supplier prices via a CSV file with only the part number (column 1) and the new prices (column 2), so that all the other loaded information stays intact?

By: GuestPosted on: Jun 9 2026 at 02:34:13 PM
Yes. That should work. But you need to be careful with the Revision.

In minimrp the unique key is partnumber + revision

For example the same part number can exist many times as long as they have different revisons. For example

Part number "ABC123" Revison "A"
Part number "ABC123" Revison "B"
Part number "ABC123" Revison "C"

If you import a CSV that contains Part number "ABC123" Revison "D" then that is imported as a new part.
If you import a CSV that contains Part number "ABC123" but do not include any revision then that is also seen as a new part.

So. if your database contains ANYTHING in the revision cell, even a dot or a dash or possibly even a space, then the CSV you import must be exactly the same otherwise how will minimrp know which item you want to update

By: GuestPosted on: Jun 9 2026 at 02:35:15 PM
But if your database contains nothing in the revision cell - ie if you do not use revisions and the cell is completely empty then you do not need to include that column when importing/updating from CSV

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Importing new supplier prices

Your name here is optional