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

    • Delete Products

      Delete Products You can delete products in two ways, in the Actions drop-down list and in the Item Segment Delete Products through Actions Drop-down List Select a Brand and choose All Products Select one or more product(s) from the catalog Click ...
    • Excel Import & Export Reports

      Your data is validated already while importing it. The Excel Export and Import validations give you valuable feedback. The Excel Export and Import reports give you feedback that helps you to improve your import files to get non ACES compliant 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 application data. The parent/child ...
    • 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 In a Brand tab click All Products Select Application segment and select a parent product from the catalog Child ...
    • Create your own template for Excel bulk import

      Every brand has its own demand for data. Create your custom template to define what you want to have imported. You can use the Excel Export & Import to easily add new products in bulk. To make adding new products yet easier and also for your own data ...