As an administrator, you can view and edit product details to control how products are displayed in Crisp dashboards, allowing you to make sure Crisp reflects your current offerings and matches the way your organization internally refers to your products. For more about administrator access: Managing user permissions.

Note: Editing products involves downloading and editing a CSV file, so you will need access to a spreadsheet application (such as Google sheets) to make changes to your products.

Administrators can make the following changes to their products:

Editing, removing, and combining products

Steps:

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

3. Choose how you want to download product data:

  • If you want to download and edit all of your product data, select the Download button.
    MDM_new_001.png
  • If you only want to edit new products that have been added since the last time you updated products, select the Download New Rows button.
    MDM_new_002.png

The spreadsheet downloads and lists the products you specified. 

6. Open the spreadsheet, then edit your product details by entering/changing values in any of the following columns.

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

  • product_name_overrideEnter a new display name for the product so that names in Crisp match your internal naming conventions.
  • category & sub_category: Update or create categories/subcategories, 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) 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. 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. 
    Hint: We recommend adding categories for all your products to ensure they show up correctly in all Crisp dashboards when filtering by category. If a product doesn't have a category, we recommend entering "N/A", so these products still show up in category filters.

    MDM_010.png

7. If you want to remove a product from Crisp dashboards for a specific retailer (e.g., UNFI), such as for a SKU that has been discontinued, change the value in the enable_retailername column to FALSE. 
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.

8. If you want to combine products, enter the same name for the products you want to combine in the product_name_override fields.
MDM_new_008.png

9. To save your changes:

  • Save the CSV file, then return to Crisp and select the Upload button.
    MDM_new_003.png
  • Drag and drop your file to the upload box, or click the box to select a file.
    MDM_new_004.png
    A progress bar appears and indicates the system is validating your file.
  • Once your file is validated by the system, click the Review and Submit button to see a summary of your changes and make sure you approve the changes.
  • To finalize your upload, click the Save button.
    mdm_new_005.png

Your changes are saved and the progress bar indicates we are applying your changes. Once we finish applying your changes, they will appear in your dashboards.

 

Creating store regions

On the Store data tab, you can create store region groups, so you can filter your dashboard by these groups. For example, if you want to focus on stores in the southwest United States and not all your retailers/distributors group their stores that way, you can create your own store grouping.

Hint: You can also create a store grouping for things that are not based on region, such as stores at which you are running a promotion or stores you want to focus on for outreach on supply issues.

Steps:

1. From the main menu on the left side of the screen, select MDM.
MDM_new_006.png

2. Select the Store data tab.
MDM_new_007.png

3. Choose how you want to download product data:

  • If you want to download and edit all of your store data, select the Download button, then choose All rows.
    MDM_new_001.png
  • If you want only want to edit new store data that has been added since the last time you updated store data, select the Download New Rows button.
    MDM_new_002.png

The spreadsheet downloads and lists the products you specified. 

4. In the tool of your choice, open the spreadsheet you downloaded in the previous step.

5. In the Region column of all the stores you want to include in the group, enter a name for the store group (e.g., Northeast or Fall Promotion).

6. To save and add your changes to Crisp:

  • Save the CSV file, then return to Crisp and select the Upload button.
    MDM_new_003.png
  • Drag and drop your file to the upload box or click the box to select the file by location.
    MDM_new_004.png
    A progress bar appears and indicates the system is validating your file.
  • Once your file is validated by the system, click the Review and Submit button to see a summary of your changes and make sure you approve the changes.
  • To finalize your upload, click the Save button.
    mdm_new_005.png

Your changes are saved and the progress bar indicates we are applying your changes. Once we finish applying your changes, the region group you created will appear as a filter in your Crisp dashboards, so you can easily track these stores as a group.
Hint: You can find this new filter by selecting the More option in the filter menu, then selecting your store group from the MDM Store Sales Region filter.
MDM_012.png