Import and Export
      Back to home
      1. Help Center
      2. 2 - Product management in Bluestone PIM
      3. Import and Export

      Export product information

      You can export product information from PIM if you have the PIM write, PIM Admin, or System Admin role. 

      Overview       Quick export       Advanced export

      Overview

      Executed export jobs can be viewed by selecting Import and export from the main navigation bar. The current status of each job is presented, and when completed, the file can be downloaded by selecting the Download file from the drop-down menu on the right-hand side.

      Export_Overviews

      Please note: Export supports attributes, assets, relations, and categories. Use Advanced export and column setup to configure your export.

      Quick export

      • Select Products from the main navigation bar.
      • Filter the products you want to export or choose a catalog or category. Then select some or all products by using the checkboxes.

      Please note: The total number of cells that can be exported in one session is 50.000.000. The maximum number of products/rows is 500.000 and the maximum number of columns is 500.

      The number of selected products is presented at the top. You can move between the pages and still keep the current selection. 

       

      • Click Export.
      • Enter the desired file name and select the relevant context and file format. Click Generate file to start the export.

      • When the export has been completed, click Download to view the result. 

      Please note: The export file can also be downloaded later from Import and export in the main navigation bar.



      Advanced Export
      • Click Products from the main navigation bar.
      • Filter the products you want to export or choose a catalog or category. Then select some or all products by using the checkboxes.

      Please note: The total number of cells that can be exported in one session is 50.000.000. The maximum number of products/rows is 500.000 and the maximum number of columns is 500.

      The number of selected products is presented at the top. You can move between the pages and still keep the current selection.  


      • Click Export.
      • Enter the desired file name and select the relevant context and file format.
      • Click Advanced export.
      • Choose Product range and Column setup.

      Please note: Name and Number columns are required and are added automatically. If removed prior to starting the export, they will be added automatically. 

      • Select which columns to be included in the exported file by clicking one-by-one or adding all columns from a group.
      • When including the Category column, all categories a product belongs to will be exported in a separate column. 

      Export_Category-Column_Expot-All-Categories

      Please note: Each category (full path) is divided by a semicolon (;), and each category level is divided by an angled bracket (>).

      • Add one-way or two-way relations by selecting Relations and clicking the relevant specific relations.  

      Export_Relation-Column_Expot-Two-Way-Relations

      • An example CSV file after exporting two-way relations.

      Export_Relation-Column_Expot-Two-Way-Relations_View-In-Xls-Or-CSV

      Please note: A two-way relation's export will result in separate columns for each direction.

      • Optionally rearrange the columns by using drag-and-drop in the Selected Columns list.
      • Click Generate file to start the export.

      Please note: The export progress can be viewed by selecting Import and export from the main navigation bar. The exported file can be downloaded from here at a later stage.

      Back to the top