Overwrite/Delete Data with the Excel Import

Overwrite/Delete Data with the Excel Import

If you want to clean out larger portions of your data, Excel Import is an easy approach.

When you Export a full Excel file, it will contain all segments as you see them in your account:

The Excel Import handles every segment individually when importing. You may import Applications for products A, B, and C in the same file as the PartAttributes for products D, E, and F.

When importing, the data in your import file will overwrite the data in your account after comparing it from the Excel sheet to the database. Missing values in Excel are considered to be deleted. Following the same example, only the Applications of the products A, B, and C would be updated. For products D, E, and F, only the Attributes will be updated.

If you want to delete all applications of certain products, simply import those records, including just the Part Number and BrandID. Existing applications will be updated to "nothing".

Remember that all data points of the segment you are importing first get compared and updated/deleted. Example: If you want to change retail pricing, you have to export all prices (including WD, jobber, etc.), then change the retail price and reimport the retail price along with the WD and jobber prices). Importing only the retail price will be considered, and the other prices (WD, jobber, etc.) should get deleted.

    • Related Articles

    • Excel Import & Export Reports

      Your data is validated already while importing it. The Excel Import and Export validations give you valuable feedback. The Excel Import and Export reports give you feedback that helps you to improve your files to get non-ACES compliant data into the ...
    • Excel Import & Export

      Excel Import & Export If you want to make changes in your data in bulk or add products in bulk, you can use Excel Import & Export. Excel Import Select the required Brand and click on Import/Export. Click Import (If you want to get a PDM template, ...
    • Import/Export Bundle Data

      Import/Export Bundle Data You can Import and Export data from the Bundle Feature right from the catalog. Export the Bundle Data Click on a Brand and select All Products. Select the Application segment and select a parent product from the catalog. ...
    • How to delete ParentDigitalAssets via Export/Import

      Parent Digital Assets Parent Digital Assets are all the Digital Assets used across your brands. You can see the full list by going to Company/Digital Assets. If you are no longer using one or more digital assets within your brand, you can export this ...
    • Validations on Excel/XML Qualifiers Import

      Qualifiers Import Validations When you import or re-import Qualifiers into PDM, it's important to know that they should meet certain conditions in order to get successfully imported. PDM provides validations for these imports that will help you ...