Developers
Quable Guide

Import, Export, and Manage the PIM Data Model

📘

Learning Objectives

  • Know how to import and export a data model in the PIM.
  • Learn how to reset a data model with different levels of impact.
  • Master best practices to secure your data before making any modifications.

Overview

The PIM data model can be imported and exported as an .xlsx file. This feature allows you to adapt the structure of your PIM to your organization and retrieve your data model for modification or backup.

This course will guide you step-by-step to:

  • Import a data model
  • Export a data model
  • Reset a data model

❗️

Irreversible Actions

Importing a data model and resetting a data model:

  • are irreversible processes,
  • permanently delete the existing data model on the PIM Quable,

Import a Data Model

Importing a data model means uploading an .xlsx file containing the structure of your PIM data.

Accessing the Import

  • From the admin menu, under the System section go to Data Model,
Capture d’écran 2025-02-10 à 10.12.36.png
  • Click on Import the Data Model.
Capture d’écran 2025-02-10 à 10.12.20.png

Select a File to Import

  • A window will open allowing you to select an .xlsx file from your computer.
  • A warning window Resetting Data and Data Model will open. Confirm the action by entering the required text in the dialog box.
  • Click on Reset to start the import.

⚠️

Caution:

Import into an empty PIM: If your PIM does not yet contain a data model, a warning will appear informing you that the import will delete the default objects and settings.

Caution: Import into an existing PIM: If your PIM already has a data model in place, the import will permanently replace the existing one. You will need to confirm your action by entering a validation message before clicking on Reset.

❗️

This action is irreversible


Finalizing the Import

  • The import may take a few minutes.
  • Once completed, a confirmation will appear.
  • You can now start importing your product data.

Export a Data Model

The export allows you to retrieve an .xlsx file containing the structure of your data model.

Accessing the Export

  • From the administration menu, go to Data Model,
  • Click on Export the Data Model.
Capture d’écran 2025-02-10 à 10.12.25.png

Retrieve the Exported File

  • The export generates an .xlsx file available in Data > Downloads.
  • Click on Download to retrieve the file to your computer.
  • You can also click on Delete if you want to remove the file from Quable PIM.

Structure of the Data Model File

The exported .xlsx file contains several sheets describing the structure of your PIM:

  • Data Languages: Available languages for product information.
  • Objects and Attributes: Data types and their properties.
  • Attribute Sets: Groupings of attributes.
  • Link Types: Relationships between objects.
  • Assets: Attributes specific to assets files.
    Each sheet follows a specific and detailed structure to ensure compatibility with the PIM in case of a new import.

Resetting the Data Model

This section explains how to reset and reinstall a data model in the PIM Quable.

Understanding the Reset Levels

The PIM offers three reset levels, each with a different impact on data and structure:

Reset OptionImpact
Reset the DataDeletes only the products and assets data. The data model structure remains intact.
Reset of data and data modelDeletes both the data and the data model structure. Users remain unchanged.
Complete reset of the PIMDeletes all data, the data model structure, users, and all customization settings. The PIM returns to its initial state.

⚠️

Caution

Any reset is final and irreversible. It is strongly recommended to export the data and model before any deletion.

❗️

This action is irreversible


Export a Data Model Before Reset

Before resetting your PIM, download your data model to keep a backup copy and reinstall it later. Access the data model export as detailed above. Download and store this file locally on your machine.

Reset the PIM

Once the export is done, proceed to reset according to your needs.

Accessing the Reset Options

  • From the administration menu, under the System section go to the Reset page.
Capture d’écran 2025-02-10 à 10.35.26.png
  • Select the option that corresponds to your needs:
    • Reset the Data (only the data).
      Capture d’écran 2025-02-10 à 10.36.16.png
    • Reset of data and data model (data + structure).
      Capture d’écran 2025-02-10 à 10.36.22.png
    • Complete reset of the PIM (delete everything).
      Capture d’écran 2025-02-10 à 10.36.28.png
  • Confirm the action by entering the required text in the dialog box.
  • Click on Reinitialize to execute the operation.

⚠️

Warning

When performing a Complete reset of the PIM, an email address and a new password will be required to access the empty instance.

Capture d’écran 2025-02-10 à 10.26.35.png

Reinstall a Data Model

After a reset, you can re-import a data model to recreate a new PIM structure. Go to the Data Model menu and proceed with importing the data model as detailed above.


Verify and Adjust the Configuration

After importing the data model:

  • Verify that all entities and attributes have been recreated properly.
  • Reactivate business rules, users, and collaboration settings if necessary.
  • Test the import on a few products to validate the data consistency.

📘

In Summary

  • Import a data model: Upload an .xlsx file containing the PIM data structure.
  • Export a data model: Generate an .xlsx file containing the current PIM structure.
  • Reset the PIM with 3 available options:
    • Delete only product data.
    • Delete product data and the data model structure.
    • Complete reset (reset PIM, including users and settings).
  • Best Practices: Always export and back up the data model before any reset.

Next Chapter

Congratulations! You have completed the "Import, Export, and Manage the Data Model" course. Continue your learning by exploring the next module in the Administrator Training.

Updated 8 days ago