Bulk Updating Stock Quantities in MechanicDesk

1. Prepare Your Spreadsheet

1. Keep only the following columns:

   • UUID

   • Stock Number

   • Quantity

2. Update the quantity values for each item as needed.

3. Remove all other columns and data.

⚠️ Important: The system uses the UUID and Stock Number to identify existing stock items. Do not modify these.

4. Save your spreadsheet once all updates are complete.
   
   

---

2. Submit the Import Request

1. Log in to MechanicDesk and go to:
   Settings > Data Export/Import

2. Click the Import tab.

3. Click the Make a Request button.

4. Upload your updated spreadsheet.

5. Select the Stock category.

6. Add a comment to describe the update (e.g., “Stock quantity update”).

7. Tick the Is Update checkbox.

8. Click Submit. We will then process the request.