Bulk updating stock numbers in MechanicDesk is straightforward, but there are a few important rules to follow, especially when dealing with existing items.
How Stock Numbers Work
The system uses the stock number and the (UUID) to identify which stock record is being updated. Because of this:
You cannot overwrite the stock number directly for existing items.
Instead, the import file must include an additional column:
Column header:
New stock number,New Stock Numberornew stock number
During import, the system will use this header and values to update the stock numbers for any matching existing items. You can set whatever values you want for these items just make sure the values are unique.
Using a New Pricing File (New and Existing Items)
If you are uploading a new pricing file from a supplier that contains both new and existing items:
New items:
The
stock Numberfields can be set to any value you wish (just make sure the values are unique)These items will be added to the system as new records.
Existing items:
Only the
New stock number,New Stock Numberornew stock numberneeds to be included with unique values if the stock number requires being updated.