sc_sku_categories

In this article

• Summary
• Supported Use Cases
• When not to use the view

Summary

The sc_sku_categories view is a small view that aims to provide a separate and analysis-friendly breakdown of product categories. The view effectively flattens categorical information for a given product. 

• View Grain: product-level
• Primary (Composite) Key(s): 
  • sku
  • updated_at
• Foreign Key(s): 
  • common_sku

Supported Use Cases

The following use cases are examples and only provide a subset of all potential use cases that can be addressed with data found in sc_sku_categories and other views. This list should not be assumed to be comprehensive. 

• Which categories tend to be purchased together?
• What is the likelihood that a customer purchasing products from category A will NOT purchase products from category B?

When not to use the view

This view should only be used to enrich data that requires product information. Category analysis is the primary use case.

Return to SoundCommerce Retail Modules