Stockpile Inventory System Tips: Uploading a CSV file of your Current Inventory using the Import Inventory Function


Upload a CSV file of your Current Inventory using the Import Inventory Function

Who has access to Perform this task: Owner.

Steps

  1. Login to the website at https://signup.canvusapps.com/login.
  2. If you have not dismissed the gray notification box or have an active item in the system your home page should display a upload Items button button in the notification box. If the button does not exist or if you have dismissed the notification box then you can access the Import inventory function by clicking on Settings in the Header next to the user's name and clicking on upload Items link from the drop down list.

    Note: If you have already uploaded a CSV file this link will not be available. Import Inventory is a one-time process. If you have an active item in the system you will be redirected back to the home screen with the following message being displayed.

  3. Active Items message when importing

  4. The Import Inventory page will load. Please read the information bullet points before proceeding. Click on sample CSV link link and download the sample csv file. It should look similar to the screenshot below.
  5. sample CSV

  6. Leave the header row in the spreadsheet and start filling out the spreadsheet on line 2 based on the information provided in the matrix in Step 2 provided below and The best way to setup Stockpile Online Inventory Management blog.
  7. Column header and description

  8. Once the spreadsheet has been filled out please save it as a CVS file through the spreadsheet capable application you are using. For most spreadsheet editors, you will need to choose "Save as" and select the ".csv" format. Please note that special characters like currency labels (e.g., $) should NOT be used in the file.
  9. Click on the Browse button button. Locate and select the CSV file you just created on your device. Prior to moving to Step 7 please read the following warning message:
  10. All items deleted removed message

  11. Click on the Import File button button.
  12. The Inventory Import Status page will load. It will look similar to the screenshot directly below.
    Import Inventory Status 1
    If the file was correctly formatted you should see updates similar to the screen shots below
  13. Import Inventory Status 2
    Import Inventory Status 3
    Import Inventory Status 4

  14. If the file loaded successfully you should see the screenshot below. Click on the View your Inventory link link to take you back to the home page. If an error occurred during the loading of the file, please read the message associated with the error, they will be very descriptive, and correct the CSV file and reload it.
  15. Import Inventory Status 5

No Comments Yet.

Leave a comment