Skip to main content

Update your internal catalog

Updated over 3 months ago

Uploading your internal catalog to CommerceIQ helps you organize and analyze your data in a way that aligns with how your business operates. It enables:

  • Smarter filtering across reports and dashboards (e.g., by category, brand, hero SKUs, event assortments)

  • More meaningful KPI drilldowns tied to your internal priorities

  • Unified taxonomy across teams and tools

  • Targeted alerts and automations using your own product tags

By syncing your catalog, you get cleaner insights, better decisions, and less manual work.

Update your Catalog with a Spreadsheet

  1. Navigate to Tools & Settings -> SKUs

  2. Download your catalog as an excel sheet

  3. Make changes in excel and save

  4. Upload your updated catalog to CommerceIQ

  5. Changes will be reflected in ~45 minutes

Note: The catalog update is an override

All uploads will override your existing catalog, if you delete columns, this will delete columns for everyone, if you upload a file that only has 5 rows, it will remove categorization information for all other products. Check in with your team before you make drastic changes to the catalog. If you ever make a mistake, you can reach out to support@commerceiq.ai to request that we roll back our catalog. We recommend saving a version of your catalog every time you download it, so that you can easily roll back any changes.

Note: Catalog updates take ~3 hours to refresh

Check in with your team to ensure this process will not cause any issues for their daily or weekly workflows.

Update your Catalog Directly in the User Interface

Navigate to Tools & Settings -> SKUs

You can also make edits directly in the user interface by clicking edit button. From here you can edit individual attributes.

Or you can bulk search and highlight multiple products to update multiple products at a time.

Maintain Your Catalog over Time

As you add or discontinue products, it’s important to regularly update your catalog in CommerceIQ to ensure accurate tracking and reporting.

A helpful starting point is to filter for products with customer sales year-to-date (YTD) or in the trailing 12 months, but that are missing categorization.

This view helps you:

  • Identify newly launched products that haven’t yet been categorized

  • Ensure your portfolio is fully tagged for accurate insights across reports, automation, and recommendations

Regular catalog maintenance ensures that new products are captured in all relevant workflows, and outdated items don't clutter your reporting.

To quickly pull a list of items that have sales but are uncategorized:

  1. Navigate to CommerceIQ -> Assortment -> SKUs

  2. From the dropdown at the top of the page, select the "Internal Categorization" view

  3. Add "Ordered Revenue" to the report

  4. Set the time range (year to date or trailing 12 months)

  5. Download the report

Did this answer your question?