We seem to be having an issue and we need a little more info on how MM works.
We have an equipment table of everything we have for our team (PPE, medical equipment, etc.). Many of our line items don't have a serial number (medical equipment, etc.).
We have 5 trailers full of gear - much of it not serialized, with a small percentage that does have a serial number (generators, etc.).
After importing 2170 items, only 708 items were actually imported.
We need to know what the logic is for how MM decides an item is a 'duplicate' and how it determines if you are updating an existing line vs. adding a new line.
We THINK our issue is the "Name" field is only 30 characters (we are assuming the system is using that field to determine unique items). If we were to try to add in say our trailer number to force the system to identify it as an independent item, we would be left with only 24 characters to describe the item (our trailer numbers are the 5 digit City Vehicle number). That's not really practical for the items we have inside (such as "Adhesive Bandages, Sterile" - 26 characters). We don't have enough room to make a name of "Adhesive Bandages, Sterile 10732" as it goes beyond the 30 character limit.
Sooo...we are not sure how to fix this issue to actually get the import to work. Our old spreadsheets had an "ID Number" that acted like a unique ID...but to integrate that number with the name isn't really practical (a. it chews into the characters needed for the name and b. it is difficult to 'manually' manage).
Can someone provide some info on how the table and import works?