Bulk removal of text in fields from SIMS using Excel

How to remove text and numbers from SIMS in bulk with Excel

With this method, the user can delete multiple text or numerical fields at one go using an imported Excel sheet.

  1. Go to Support > Stock Cards.
  2. In the grid menu, select 'Export to Microsoft Excel'.

  3. In the next modal, select the fields you would like to amend by highlighting the field name in 'Available Fields' and clicking the 'Add' arrow to add them to 'Fields to Export'. IMP: Stock Code is mandatory. When you have finished, press Ok.

  4. This will open an Excel spreadsheet with columns for the fields you selected.
  5. To remove text from a field and leave it blank, type [REMOVE] in the cell.

  6. To zero out (0.00) a numerical field, type -1 in the respective cell.

Use the Remove option ONLY on those fields that are NOT mandatory.

Please note that Barcodes cannot be deleted with this method. If the user needs to clear barcodes in bulk please contact Support for help.

    • Related Articles

    • How to Change a Stock Code in SIMS

      To change a stock code: Open SIMS. Click on Admin > Change/Delete Stock Card > Change/Delete Stock Card. 3. Input the old stock code, leave the Delete box unchecked, and input the new stock code. 4. Click on the Save button (floppy disk icon) to ...
    • How to import and export data through Excel

      You can export data to Excel by going to Support > Stock cards and right-clicking the blue box button in the top-left corner of the data grid (near the column headers). Then navigate to Export to Microsoft Excel and select the required fields (note ...
    • Can I change or delete stock codes in SIMS?

      SIMS provides the option to change or delete a stock code, as detailed below.  Both options can be accessed from Admin > Change/Delete Stock Cards.   Change a stock code When you access this function, click on the insert button to add the stock code ...
    • Creating and Updating Contracted Prices in SIMS using Excel

      Creating New Contacted Prices Scenario 1: Adding a new contracted price for an existing client Go to Support > Clients and choose the client. Click on the Contracted Prices tab. Press + or 'Insert' on the keyboard. Enter the stock code and choose a ...
    • How to post an Adjustment in SIMS

      To post an Adjustment of Stock in SIMS: Go to Main > Adjustments > Adjustment Add or Deduct. Press the + Sign to input a Stock Card. Type ? in the 'Stock Code' field. Another window will pop up to search the Stock Card, double-click on the Stock ...