---
schema_version: "1"
id: 27605764343d973d9b14fad4b495bff57838097a609855de68a0c0e9d024a122
title: Soft-Delete Imported Records in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_import_soft_delete.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_import_soft_delete.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b52c9b1bce3f00d62f77c49e1ec22fda30012128aa56b6ef75deb28aa0f8a749
description: To exclude imported records from commission calculations in Salesforce Spiff but keep the records available and searchable, you can soft-delete the records. For example, maybe you want to keep some records available for audit purposes, so you don't want to delete them permanently.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Soft-Delete Imported Records in Salesforce Spiff

To exclude imported records from commission calculations in Salesforce Spiff but keep the records available and searchable, you can soft-delete the records. For example, maybe you want to keep some records available for audit purposes, so you don't want to delete them permanently.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d10236e76">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d10236e76 ">To soft-delete imported records:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d10236e76 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with this permission turned on.</p>
              <p style="margin-bottom:0;">Data Sources: Edit</p>
            </td>

          </tr>
        </tbody>
      </table>

1. Add a soft\_deleted column to an upload file that contains all records, including the records you want to delete.
2. For records that you want to soft-delete, enter true in the column. Otherwise, enter false.
    
    You can upload new records in the same file as records that you want to soft-delete. For new records, the value of the soft\_deleted column must be false.
3. Upload the file in Spiff.
    
    See [Upload Data in the Data Sources Page in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_upload.htm&release=264.0.0&type=5 "To manually upload records into Salesforce Spiff, import .xlsx or .csv files that represent users, deals, accounts, or other objects.").
    
    1. On the Configure Fields step, select **Boolean** for Data Type.
    2. On the Fix Duplicates step, select **Override existing fields** or **Update missing fields**.
4. To ensure that soft-deleted records remain searchable after the upload is complete, go to the Data Imports section of the Data Sources page and select **Show Soft Deleted Records**.
    
    If this option is turned off, soft-deleted records don't appear in the Data Sources page and don't appear in any search results.