sc_order_fulfillments

In this article

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

Summary

The sc_order_fulfillments view serves as the centralized location for order-level fulfillment information. In this view, you will find granular information about how an order is fulfilled, the corresponding shipment partner, shipment information, and a breakdown of various metrics to the fulfillment level. 

• View Grain: Order Fulfillment-level details. Each record should have a unique combination of an order and fulfillment identifier
• Primary (Composite) Key(s): 
  • scid
  • source_fulfillment_id 
  • order_id
  • tracking_number
• Foreign Key(s):
  • cuid
  • order_date
  • warehouse_id 

A given order may be broken up into multiple fulfillments. Therefore, there is no guaranteed one-to-one relationship between the order and order fulfillment views. Keep in mind that joining the fulfillment view to others may introduce duplicate values in the fulfillment view (if the joined view is at a lower grain) or in the other view (if the fulfillment view is at a lower grain).

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

• I want to understand which warehouse locations tend to handle most of my fulfillments in a given timeframe. 
• I want to analyze whether certain sku groupings affect the amount of time between when an order is placed and when it is shipped. 
• I want to investigate the effectiveness of my shipping partner and ensure that most of my orders are being delivered on time.

When not to use the view

This view contains order fulfillment-level data. The order fulfillment-level data can be more granular than the typical order-level data. Be aware that joining the fulfillments view with the orders view may cause the resulting orders-related metrics to be duplicated. Similarly, joining item-level data from the items view may cause fulfillment-related metrics to be duplicated as the items view is likely more granular than the fulfillments view. 

The sc_order_fulfillments view does not contain specifics about the following:

• Campaign-related metrics (i.e., clicks, impressions, conversions)
• 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)

Return to SoundCommerce Retail Modules