Administrators can use the Edit Products feature, also known as Master Data Manager (MDM) to edit details about products to control how they are displayed in Crisp dashboards. This allows them to make sure the way data displays matches the way your organization internally refers to your product offerings. For more about administrator access: Managing user permissions.

Note: Editing products involves using Google sheets, so you will need access to Google Sheets to use this feature. 

If you have admin access, you can:

Note: Crisp utilizes Google Sheets to allow you to edit your products. To complete the following steps, you will need to use an email tied to a Google account. For instructions on linking your email to Google, see Google Account Help.

Customizing product display names and categories

Steps:

  1. Log into your Crisp account.
  2. From the main menu on the left side of the screen, select Products.
    managing_products_001.png

3. In the Name field, enter a descriptive name for the spreadsheet where you will update your products. 

MDM_006.png

4. Select the Save button. 

MDM_007.png

Note: Only create and save one spreadsheet, if you need to make additional changes, you can update the original Google sheet you created by selecting the Edit Products button at the top of the screen. 

The page reloads and a link to the Google sheet you created appears. 

5. Select the Edit Products button at the top of the page.

 

The spreadsheet opens and lists your existing products. 

Note: By default this spreadsheet is only accessible to the original creator. To give access to others, please select the Share button in Google sheets and add the users you want to have access. 

For more on sharing: Google Workspace Learning Center > Share files in Drive , Docs, Sheets, and Slides

6. To edit your products, enter values in any of the following columns.

Note: Do not add tabs or sheets to the spreadsheet as this will cause errors when you submit your changes.
MDM_008.png

  • Display Name: Enter a new display name for the product so that names in Crisp match up with your internal naming conventions.
  • Category & Subcategory: Create categories, so you can filter your dashboards by groupings important to you. For example, you can divide your products by type (such as popcorn or nuts) and/or by flavor profile (such as sweet or savory). Once you create categories, you can access them in the More filters menu on your dashboards, to the right of the main filters.

    MDM_010.png
    Note: Category and subcategory do not create a hierarchy (i.e., subcategories do not roll up into categories), and they appear on your dashboards as separate filters. 

7. To save your changes and finalize the update in Crisp, hover over the FINALIZE PRODUCT MASTER DATA text at the top of the spreadsheet, then select the link that appears. 

MDM_005.png

The Submit Master Data screen appears and displays a list of your changes for review.

8. Confirm the changes, then select the Submit button.

MDM_004.png

Your changes are saved and a pop-up appears confirming your changes and provides a link to view your dashboards, so you can see your changes in action.

 

Removing products from Crisp

You can remove a product that you no longer want to appear in your dashboards, such as when a SKU has been discontinued.  

Steps: 

1. From the main menu on the left side of the screen, select Products.

managing_products_001.png

2. Select the Edit Products button at the top of the page.

managing_products_002.png

The spreadsheet opens and lists your existing products. 

3. For each product you want removed, deselect the checkbox in the corresponding retailer column (e.g., Enabled for UNFI). Repeat this process for all the retailers for which you want to remove the product. 
MDM_009.png

Note: If a product has had a GTIN change but kept the same name, it may appear twice in the spreadsheet. Both will need to be unchecked in order to remove the product.

5. Select the FINALIZE PRODUCT MASTER DATA link at the top of the spreadsheet, then submit your changes.

Combining products

When you want to combine data for products, such as when you want to combine the sales of two products after a packaging change, you can "roll up" those products by editing your product display names.

Steps:

1. From the main menu on the left side of the screen, select Products.

managing_products_001.png

2. Select the Edit Products button at the top of the page.

managing_products_002.png

The spreadsheet opens and lists your existing products. 

2. For the products you want to combine, enter the same name in the Display name fields.

Rolling_Up_Products_in_MDM.png

3. Select the FINALIZE PRODUCT MASTER DATA link at the top of the spreadsheet, then submit your changes. 

The data for the products you updated appears combined in your dashboards. 

Managing products for destination connections

If you rename products using the master data manager (MDM) and export data to destination connectors, the value in the product column of normalized Product tables (such as this Walmart product table) will be overwritten with the new display name for the following connectors: Amazon, C&S, Dollar General, DOT, Kroger, Loblaws Data Share, Publix, Sam's Club, Shopify, SuperValu, Target, UNFI, Walmart, Walmart Luminate, Whole Foods.