Update Items via CSV Import

  1. From the main menu strip at the top, go to Setup > Items.
  2. Click the Options button located at the top right.
  3. Click Import Items CSV from the Options button dropdown menu.
  4. Step 1 - Click the Browse for Items CSV file to locate the csv file on your local hard drive.
  5. Step 2 - Click the Preview Data button to upload the file and preview the data.
  6. Step 3 - Set the Import Mode toggle to the Update option.
  7. Note that to avoid any accidental updating of existing field data, any of the columns that may have been auto-matched based on the column name will now be unmatched, except for the Code column (which is a required match for updating items).
    Step 4 - Now you can manually choose any other columns that you wish to update in the Belongs to... section. Your item data will only update if you have matched the column and there is a value present to import, otherwise your existing data will remain untouched.
  8. Step 5 - Click the Import Data button to complete the process and update your item data.

Did this help?

Powered by HelpDocs (opens in a new tab)