sc_order_fulfillment_items

In this article

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

Summary

The sc_order_fulfillment_items view provides more item-level detail for order fulfillments. In this view, you will find granular information about the items in a given order fulfillment. 

• View Grain: Order Line-Item Fulfillment-level details. Each record should have a unique combination of an order, fulfillment, and item identifier.
• Primary (Composite) Key(s):
  • scid
  • sku
  • tracking_number
• Foreign Key(s): N/A

The sc_order_fulfillment_items view provides more information about specific items within a given fulfillment. You can see the fulfillment of specific items within a fulfillment grouping.

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_order_fulfillment_items and other views. This list should not be assumed to be comprehensive. 

• I want to understand which items in a given fulfillment have not been processed and shipped out.

When not to use the view

This view contains details for the items that make up a given order fulfillment. This grain is one of the lowest grains supported by SoundCommerce. Therefore, most joins with other, less granular, views in SoundCommerce will force duplication of metrics.

The sc_order_fulfillment_items view does not contain specifics about the following:

• Campaign-related metrics (i.e., clicks, impressions, conversions, ad spend)
• Product-related metrics (i.e., warehouse inventory for a given product)
• Customer-related metrics (i.e., customer historical sales, customer CLV)
• Customer PII-related values (i.e., first and last names, emails, phone numbers, addresses)
• Order-related metrics (i.e., sales, profitability)

Return to SoundCommerce Retail Modules