This article will guide you through using the bulk inventory adjust upload tool. This tool allows you to make bulk adjustments to inventory. All changes are logged in inventory adjustment history.
Step 1: Download Current Inventory Report
Navigate to Reports/Setup > Products > Current Inventory. Use the dropdown box to Filter By Product Category and use checkbox options if needed.
To create an Excel export with all products listed then leave the drop down menu blank and uncheck Don't Show Products That Have Never Been Sold And Have No Stock Level.
Click on the Excel export (also used as template for bulk adjust tool) link.
Step 2: Make Adjustments in Excel File
Once the Excel file has been downloaded, please open it without making any modifications to the columns or rows. It is essential to maintain the original formatting to ensure the upload process functions correctly. The Excel file will include the following information:
- Product ID: ID number of the product.
- Product Code: Product code number.
- Other Product Code: Third-party product code.
- Product Name: Name or description of the product.
- Current Inventory: Current total of inventory on hand.
- Inventory Value: What the current inventory is valued at.
- Set Inventory To: Set the total inventory count to this number.
- Increase Inventory By:Add a specific amount of this product to your inventory.
- Decrease Inventory By: Remove a specific amount of this product to your inventory.
The green columns are utilized for making bulk adjustments. Enter the amounts to either Set Inventory To, Increase Inventory By, or Decrease Inventory By. Please do not include any commas. Adjusting inventory by increasing or decreasing will override any values entered in Set Inventory To, so it is unnecessary to fill in multiple columns for the same product. Save the Excel file in .CSV format.
Step 3: Upload Inventory File to ClubReady
Navigate to Tools > Products > Bulk Inventory Adjust. Click on Choose file and find the .CSV file saved in the computer. Then click on Upload CSV File.
The file will be uploaded and inspected. If it is in the correct format and ready to be processed you can click on Do Bulk Adjustment.
All adjustments will appear on screen and the inventory has now been changed. These changes are logged and can be found in Reports > Products > Inventory Change Log.
Requirements - A 'Master Admin' login or a staff login with the following permissions.
- Tools: can access tools
- Tools: Can access products tools