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, the Excel Import is an easy approach.

Your Excel file contains all segments like 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 data, the data in your import file will overwrite the data in your account after comparing the data from the Excel sheet to the data in the database. Missing values in Excel are considered to be deleted. Looking at the example above, only the Applications of the products A, B, and C would be updated. For the products D, E, and F only the Attributes will be updated.

If you want to delete all applications of certain products, simply import those part numbers with 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 gets 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 that 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. ...
    • 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 ...
    • Import/Export Parent/Child Application Data

      Import/Export Parent/Child Application Data This article will focus on importing and exporting parent-child relationships in application data. For information on creating inheritance relationships for applications between products, see Inherit/Link ...