There are two main uses for the Import / Export of spares in Alldevice, and it is important that when importing you ensure that you follow one of the two below.
Initial Importing of spares - This can be use ONLY ONCE, if you import spares without any part ID multiple times, then it will be seen as a new spare part, and could result in duplicates which require manually removing one by one to undo.
Updating on mass spares - Here you need to follow the export current and import, as the Spares ID MUST be include in the file, then any other changes will be made as per the file.
So for initial import ONE TIME only you should ensure:-
The Spare Parts Additional fields, Categories, Manufactures and Stocks have been setup as needed.
You can download the example template file from Spares - Then click "Import" then "Import example file" this will download a file, the location may depend on the browser you are using.
Open the File and copy your spares data, or add the data as needed.
NOTE the 1st ID column shouldn't be filled in, this is generated on import.
The file should look like this this, depending on the custom fields added:-
To Update spares data you should:-
Export the data from the "Spares" menu, which should look like below. Make the updates as needed, but do not change the 1st column ID.
Import WITH the ID the columns you want to update, this will only update descriptions etc
NOTE: If you want to Increase or Add Quantities of spares in stock you need to use the Import from the "Purchase" section accessed from the down arrow beside spares and select Purchase, the use the import from there. If the current quantity shows -5 and you actually have in stock 4 you need to purchase 9 in that stock. The Purchase only takes values of +1 or more.
If you wish to reduce quantantaties you need to write off stock, and then you need to use a negative number for example -3. The file needs to be imported to the write off section.
The Stock Add (Purchase) od Reduction (Write off) can be the same file, with the column "In stock_PIS" being the changes required ie a positive number for adding, and negative for reducing. Import in Purchase, then Write off and all updates have been made as needed.
