Follow

Mass Inventory Adjustment

Preparing for the Count

To perform a full inventory physical count, generate Inventory Cycle Count report 

  1. Inventory New (next to the page header) > Select Inventory Cycle Count > Select Linelist to count (hold down command/CTRL button to select multiple, but we recommend one linelist at a time) > Select Display All Quantities to include items with 0 qty > View Report
  2. Export the report to Excel by clicking the Excel icon, or copy and paste the results into Excel. 
  3. Enter the count (excluding the released items)
  4. Note the difference Count vs. Available
  5. Remove SKUs without difference
  6. Remove columns: Category, Description, Released, Total

 

 

Uploading Adjustment

  1. Go to AdvancedUtilities Upload Inventory Adjustments via copy and paste from excel
  2. Select all the data in your excel spreadsheet excluding the column headers
  3. on your keyboard, CMD (Mac)/CTRL (PCs)+C to copy
  4. in Blast Ramp, paste into the large text box by pressing keys CMD/CTRL+V

  5. Leaving Commit Adjustment unselected, Blast Ramp will provide a Preview
  6. Submit
  7. Click Back to select Commit Adjustment if left unselected previously
  8. Submit to commit to the adjustment

 

Troubleshooting Upload Errors

2 most common errors encountered when performing this task: 

Using the Inventory Count Report will minimizing the chances of running into these errors. Do not change the Location column 

If Quantity was unmatched, it may be caused from data entry into the the wrong column. 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk