Back to Website
Product Documentation PIM Configure PIM Product Maintenance PIM Workflow Updating PIM Settings

Updating PIM Settings

While there are many different configurations you can use in the product grid, we'll be going over information that will specifically help you maintain large or small amounts of data with the Kodaris PIM system, including:

  • PIM Status
  • PIM Category
  • PIM Attribute Status
  • PIM Category Status
  • PIM Reasons

Note: The PIM workflow is only visible internally - it is not customer facing.

PIM Status

PIM Status can be used to show the status of a product. You can also filter on each status to see at which stage products are in your process. PIM Status can be accessed in the Data, Category Assignment, and Attribute Assignment grids or on each product details page.

1710_product_documentation_pim_use_product_maintenance_pim_workflow_updating_pim_settings_pim_status_gen.png

When products are first synced from your ERP, they are automatically assigned with the "ADDED" status. (This is also the case with the PIM Attribute Status and the PIM Category Status.)

The below workflow has been used by the Kodaris team to update thousands of products. However, depending on the amount of your data and the size of your team, you may need to update this flow to suit your needs.

  • ADDED - this is the status automatically assigned when a product is added to the portal from your ERP. You can filter on this status any time to find the products that have been added to your site.
  • UPDATE - this is the status used when choosing to update a product for your commerce site. Team members can filter this status to find the products that need to be updated. When finished with updating product data, the status can be changed from UPDATE to QA1.
  • DO NOT UPDATE - this status is used if the product should not be updated for your commerce site. If it is decided later that this product should be updated, adjust the status to UPDATE.
  • QA1 - this status is used for a first pass check, ensuring the product is updated correctly with all needed info and the correct image. Once it is checked, the QA team member will update the status to QA2.
  • QA2 - this would be a final check on the product. If the product passes QA2, the status would be updated to COMPLETE or CLARIFICATION. Products can also be sent back to UPDATE or QA1 if adjustments are needed.
  • COMPLETE - when the product is marked complete, it is ready for attributes and commerce categories
  • CLARIFICATION - if QA2 cannot resolve questions left in PIM Comments from the UPDATE or QA1 team, the product can be updated with the CLARIFICATION status. Once the questions are resolved, the product needs to be marked COMPLETE.

Updates to the status after the products are synced will need to be done by your team in the Kodaris PIM portal. These status updates can be made directly in the grid, by importing (for large amounts of data or initial workflow setup), or by team members working on products.

Update PIM Status In The Data Grid

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_products_data_tab.png
  • Navigate to “Products” from the PIM section in the Portal
  • Select the "Data" tab
1710_product_document_pim_use_product_maint_pim_workflow_updating_pim_setting_search_options.png
  • Find the product or products you desire to update, by doing one of the following steps:
    • Use the Search option to type in the Code, Name, or other identifying factor
    • Enter in a search term directly to the Filter field in a specific column
    • Use the Filter field to search for a specific term
1710_product_documentation_pim_use_product_maint_pim_workflow_update_pim_settings_update_pim_status.png
  • Scroll to the PIM Status column, then:
    • Double-click a cell to activate the dropdown menu, then select your new status
    • Copy a status by using the quick keys on your keyboard or going to Edit > Copy, then paste that status in the cells you wish to update by using the quick keys to paste or going to Edit > Paste.

Update PIM Status By Importing

Before importing, you will need to create an import template by exporting a header row template from the Data, Category Assignment, or Attribute Assignment grids in the PIM portal. Imports are not reversible - be sure the spreadsheet you are using is the data you want to import. An empty cell will input an empty cell.

Once you have your .CSV file ready, you can import the updated PIM statuses. PIM Status can only be imported on the data grid screen.

1710_1262_settingPimWorkflow_import_Grid_.jpg
  • On the Products screen, select the “Data” tab
  • Choose "File" > "Import" > "Default Product Mapping Update Only"
  • Once you have selected the import type, you will be prompted to select the file you would like to import.

The "Default Product Mapping Update" import matches on the product code, and all product codes will be updated with the values in the spreadsheet.

Important! The import function is quick – once you upload the selected file, the data in the file is created or updated. So please be sure to choose the correct file to import and have your file prepared correctly.

It may take a couple of minutes to complete an import if it is a large file. You may see a time-out notification if the file is large, but this does not mean the import failed. It will still be running in the background.

Once the import has been completed, the products will be updated with the PIM Workflow and will be ready to be assigned to your team for maintenance.

Update PIM Status By Product

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_select_product.png
  • Navigate to “Products” from the PIM section in the Portal
  • Find the product you wish to update, then click the details icon
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_update_status_field.png
  • Under the PIM Workflow section, find the Status field
  • Select the desired status for the product

PIM Category

PIM Categories can be used as internal product buckets or categories – this can help when multiple team members work on products in the portal and are assigned specific PIM Categories to work through. Working on the same types of products can also increase the speed and efficiency of maintaining product data.

PIM Categories could relate to your high-level commerce categories or specialty buckets such as LUMBER, ELECTRICAL, POWER TOOLS, SPECIAL REQUEST, HIGH PRIORITY, and others.

Note: If using the PIM Workflow, the PIM Category should be added when updating the product status from ADDED to UPDATE.

PIM Categories can be accessed on the Data, Category Assignment, and Attribute Assignment tabs or on each product details page.

Assign PIM Category Manually

If you are using the PIM Workflow and would like to update the PIM Category, you can either change it manually or by importing.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_select_pim_category.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select either the "Data", "Category Assignment", or "Attribute Assignment" tab
  • Click the "Show / Hide Columns" icon, then select the "PIM Category" column
1710___product_document_pim_use_product_maint_pim_workflow_update_pim_settings_copy_paste_pim_category.png
  • From this screen, you can either:
    • Double-click the field you want to update in the PIM Category column, then select the new category from the dropdown menu
    • Copy and paste the new PIM Category into a field, either by right clicking or using your quick keys

Assign PIM Category by Importing

Before importing, you will need to create an import template by exporting a header row template from the Data, Category Assignment, or Attribute Assignment grids in the PIM portal. Imports are not reversible - be sure the spreadsheet you are using is the data you want to import. An empty cell will input an empty cell.

Note: the PIM Category name needs to match exactly or it will not be imported.

Once you have your .CSV file ready, you can import the updated PIM Category.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_start_category_import.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select the "Category Assignment" tab
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_file_import_category.png
  • Select File, then click Import
  • Choose the "Default Category Assignment Mapping" option
  • On the following screen, select the .CSV file you created for this import

The import function is quick - once you upload the selected file, the data in the file is created. Please be sure you select the correct file to import, and have your file prepared correctly.

Once the import is processed, your PIM Category fields will be updated. If it is a large file, this may take a few minutes. If the file is very large, you may see a time out notification, but this does not mean the import failed. It will still be running in the background.

PIM Attribute Status

PIM Attribute Status can be used the same way the PIM Status is used. Filtering on both the PIM Attribute status and the PIM Status can also help your team know which products are ready to assign attributes. It can also be helpful to sort products by the PIM Category. PIM Attribute status can be accessed in the Data, Category Assignment, and Attribute Assignment grids.

1710_1258_pimWorkflow_pimAttribute_sort.jpg

The PIM Attribute Status values are entirely customizable and can be adjusted to fit your desired workflow.

  • ADDED - this is the status automatically assigned when a product is added to the portal from your ERP.
  • UPDATE - this is the status used when choosing to update a product for your commerce site. If your team updates the PIM Status to UPDATE on products, they would want to set the PIM Attribute Status to UPDATE simultaneously. After assigning attributes to the product, the status should change from UPDATE to QA.
  • QA - this is a check to ensure the product has been updated with correct attributes. Once the product has been checked, the QA team member would update the attribute status to COMPLETE or CLARIFICATION.
  • COMPLETE - this status is used when the product has been assigned all attributes and is ready for commerce categories.
  • CLARIFICATION - if your team cannot complete the attributes on a product, the attribute status will be updated to CLARIFICATION. Once the issue is resolved, the product should be marked as COMPLETE and ready for category assignment.

Assign PIM Attribute Status Manually

If you are using the PIM Workflow and would like to update the PIM Attribute Status, you can either change it manually or by importing.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_select_attribute_status.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select either the "Data", "Category Assignment", or "Attribute Assignment" tab
  • Click the "Show / Hide Columns" icon, then select the "PIM Attribute Status" column
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_update_attribute_status.png
  • From this screen, you can either:
    • Double-click the field you want to update in the PIM Attribute Status column, then select the new category from the dropdown menu
    • Copy and paste the new PIM Attribute Status into a field, either by right clicking or using your quick keys

Assign PIM Attribute Status by Importing

Before importing, you will need to create an import template by exporting a header row template from the Data, Category Assignment, or Attribute Assignment grids in the PIM portal. Imports are not reversible - be sure the spreadsheet you are using is the data you want to import. An empty cell will input an empty cell.

Note: the PIM Attribute Status name needs to match exactly or it will not be imported.

Once you have your .CSV file ready, you can import the updated PIM Category.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_select_attribute_assignment.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select the "Attribute Assignment" tab
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_import_attribute_status.png
  • Select File, then click Import
  • Choose the "Default Attribute Assignment Mapping" option
  • On the following screen, select the .CSV file you created for this import

The import function is quick - once you upload the selected file, the data in the file is created. Please be sure you select the correct file to import, and have your file prepared correctly.

Once the import is processed, your PIM Attribute Status fields will be updated. If it is a large file, this may take a few minutes. If the file is very large, you may see a time out notification, but this does not mean the import failed. It will still be running in the background.

PIM Category Status

PIM Category Status can be used the same way PIM Attribute Status is used. Filtering on the PIM Attribute Status and PIM Status will help your team know which products are ready to assign to commerce categories. It can also be helpful to sort products by the PIM Category. PIM Category status can be accessed in the Data, Category Assignment, and Attribute Assignment grids.

1710_1258_pimWorkflow_pimCategoryStatus_sort.jpg

The PIM Category Status values are entirely customizable and can be adjusted to fit your desired workflow.

  • ADDED - this is the status automatically assigned when a product is added to the portal from your ERP.
  • UPDATE - this is the status used when choosing to update a product for your commerce site. If your team updates the PIM Status to UPDATE on products, they would want to set the PIM Category Status to UPDATE simultaneously. Once the product has been assigned to categories, the status should be changed from UPDATE to QA.
  • QA - this is a check to ensure the product has been updated with the correct categories. Once the product has been checked, the QA team member would update the category status to COMPLETE or CLARIFICATION.
  • COMPLETE - this status is used when the product has been assigned to all categories and is done.
  • CLARIFICATION - if your team cannot complete category assignments on a product, the attribute status should be updated to CLARIFICATION. Once the issue is resolved, the product should be marked as COMPLETE.

Assign PIM Category Status Manually

If you are using the PIM Workflow and would like to update the PIM Category Status, you can either change it manually or by importing.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_products_to_show_hide.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select either the "Data", "Category Assignment", or "Attribute Assignment" tab
  • Click the "Show / Hide Columns" icon, then select the "PIM Category Status" column
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_copy_paste.png
  • From this screen, you can either:
    • Double-click the field you want to update in the PIM Category Status column, then select the new status from the dropdown menu
    • Copy and paste the new PIM Category Status into a field, either by right clicking or using your quick keys

Assign PIM Category Status by Importing

Before importing, you will need to create an import template by exporting a header row template from the Data, Category Assignment, or Attribute Assignment grids in the PIM portal. Imports are not reversible - be sure the spreadsheet you are using is the data you want to import. An empty cell will input an empty cell.

Note: the Category Status name needs to match exactly or it will not be imported.

Once you have your .CSV file ready, you can import the updated PIM Category Status.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_start_category_import.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select the "Category Assignment" tab
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_file_import_category.png
  • Select File, then click Import
  • Choose the "Default Category Assignment Mapping" option
  • On the following screen, select the .CSV file you created for this import

The import function is quick - once you upload the selected file, the data in the file is created. Please be sure you select the correct file to import, and have your file prepared correctly.

Once the import is processed, your PIM Category Status fields will be updated. If it is a large file, this may take a few minutes. If the file is very large, you may see a time out notification, but this does not mean the import failed. It will still be running in the background.

PIM Reasons

PIM Reasons is another filtering tool that can be helpful if there are reasons why a status was chosen on a product. Again, this is dependent on your use case and the type of data you update. Again, these values are entirely customizable, and the below examples are special use cases. PIM Reasons can be accessed in the Data, Category Assignment, and Attribute Assignment grids or on each product details page.

1710_1258_pimWorkflow_pimReason_status.jpg
  • DISCONTINUED - the manufacturer or your company has discontinued this product
  • INACTIVE - this product is inactive in your ERP
  • NOT FOUND - product information could not be found for this product
  • WAITING INFO - waiting on info before moving ahead with product updating

Assign PIM Reasons Manually

If you are using the PIM Workflow and would like to update the PIM Reasons, you can either change it manually or by importing.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_select_pim_reasons.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select either the "Data", "Category Assignment", or "Attribute Assignment" tab
  • Click the "Show / Hide Columns" icon, then select the "PIM Reasons" column
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_update_pim_reasons.png
  • From this screen, you can either:
    • Double-click the field you want to update in the PIM Category Status column, then select the new status from the dropdown menu
    • Copy and paste the new PIM Category Status into a field, either by right clicking or using your quick keys

Assign PIM Reasons by Importing

Before importing, you will need to create an import template by exporting a header row template from the Data, Category Assignment, or Attribute Assignment grids in the PIM portal. Imports are not reversible - be sure the spreadsheet you are using is the data you want to import. An empty cell will input an empty cell.

Note: the PIM Reasons term needs to match exactly or it will not be imported.

Once you have your .CSV file ready, you can import the updated PIM Reasons.

1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_pim_reasons_import.png
  • Navigate to "Products" in the PIM section of the Portal
  • Select either the "Data", "Category Assignment", or "Attribute Assignment" tab
1710_product_document_pim_use_product_maint_pim_workflow_update_pim_settings_import_pim_reasons.png
  • Select File, then click Import
  • Choose the "Default Category Assignment Mapping" option
  • On the following screen, select the .CSV file you created for this import

The import function is quick - once you upload the selected file, the data in the file is created. Please be sure you select the correct file to import, and have your file prepared correctly.

Once the import is processed, your PIM Reasons fields will be updated. If it is a large file, this may take a few minutes. If the file is very large, you may see a time out notification, but this does not mean the import failed. It will still be running in the background.

In this article