Importing Inventory Items from Excel

  1. Click Batch Update
  2. Copy the text that you see on that page
  3. Paste it into spreadsheet
  4. Then, modify the data to match what it should be.
  5. Copy from spreadsheet and paste back into Manager
  6. Click Next
  7. Review the list of changes. It should only show the columns modified that you tried to modify in the spreadsheet.
  8. Click Batch Update if you’re happy.

Note: Do not use your original spreadsheet. Create a new spreadsheet (or new tab on existing spreadsheet) and use the data copied from Manager screen if you’re doing a Batch Update.