Using an Excel file to delete entities

The entities that you specify must share the same top-level entity type.
  1. Create an Excel file.
  2. Prepare the first row:
    1. In cell A1, specify Operation.
    2. In cell B1, specify DeleteEntities.
  3. In cell A3, specify EntityId.
  4. Starting with cell A4, specify the ID of the entity to delete. For example, specify entity1 in A4, entity2 in A5, and so on. Entity IDs are case-sensitive.
    For information about locating entity IDs, see Identifying IDs used in imported files.
  5. Save the Excel file.
  6. Import the Excel file.
    1. Sign in to PIM.
    2. On the dashboard, click Import / Export.
    3. If multiple accounting entities are available in PIM, ensure that you have selected the accounting entity that you want to use.
    4. Click Import.
    5. In the Import to Entity Type field, select the top-level entity type of the entities in the import file.
    6. In the Attach File field, click the browse button and select the Excel file that you are importing.
    7. Click Import.