Excel Import & Export

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 the Excel Import & Export.

Excel Import

  1. Select the required Brand and click in Import/Export.
  2. Click Import (If you want to get a PDM template, simply configure one product in the tool and export that product to get the template, then fill the new data into the template).
  3. Choose the required Segments to import the excel.
  4. Click the Upload Excel button or Drag and Drop the excel to import.
           

      5. Click Import Reports. Every import is listed, and whether it failed or was successful. Errors that may have occurred are displayed and can be downloaded by clicking in Show error log.



      6. Click in Download Errors to get the file.
           

Excel Export

  1. Select the required Brand and click on Import/Export.
  2. Click Export.
  3. Select a Parts option and a Database.


      4. Select Excel (Full) format.
          


      5. Configure the Formatting options.
      6. Click Export.


          
      7. Click Export Reports,  All exports that have been made are listed here.
 

    • Related Articles

    • 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 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 ...
    • 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 ...
    • 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 ...
    • Add products in bulk using the Excel Import

      You can add new products to your catalog by simply adding those in the Item tab in your excel sheet. The minimum field requirements are: Part number Brand ID Population Status You see the brand ID in your excel Export after creating your own ...