Embroidery Hit¶
Table name:
- referenced in Insights SQL queries:
"EMBROIDERY_HIT" - in data catalog export:
marts_mdc__embroidery_hit
Embroidery work done on your orders, one row per embroidery hit: one design stitched once at one position (e.g. chest_left) on one unit of a product. A unit can carry several hits. Use it for product-wise stitch counts: sum stitch_count grouped by sku (and optionally embroidery_hit_position or a date), filtering on embroidery_hit_completed_at_utc for hits that were actually stitched out. stitch_count comes from the digitized design artwork the hit was stitched from and is null for the few hits without a tracked artwork. Hits of cancelled warehouse orders are not included.
Columns¶
| Column | Type | Description |
|---|---|---|
embroidery_hit_id |
varchar |
Unique identifier of the embroidery hit (hex-encoded UUID). One row per hit. |
account_id |
number |
Identifier of the account (merchant) that owns the order. |
order_id |
number |
Unique identifier for the order within the system. |
order_number |
varchar |
The primary order identifier as defined by the order source. Typically the customer-facing order number, but is also commonly set to an internal reference such as a shipment or fulfillment number when sent from an ERP. |
order_submitted_at_utc |
timestamp_ntz |
UTC timestamp when the order was submitted for fulfillment. |
embroidery_unit_id |
number |
Identifier of the embroidered unit (one physical product unit with an embroidery instruction on the warehouse order). Count distinct to measure embroidered units; all hits of a unit share it. |
product_id |
number |
Unique identifier of the product the hit is stitched on. |
sku |
varchar |
SKU of the product the hit is stitched on. Group by it for product-wise stitch counts. |
product_name |
varchar |
Name of the product the hit is stitched on. |
warehouse_name |
varchar |
Name of the warehouse that embroidered the unit. |
embroidery_hit_type |
varchar |
Type of the embroidery hit, e.g. text, image_file, text_with_image_file, design_identifier. |
embroidery_hit_position |
varchar |
Position on the product where the hit is stitched, e.g. chest_left, chest_right, sleeve_left. |
embroidery_design_id |
varchar |
Identifier of the embroidery design (logo or text) stitched by the hit (hex-encoded UUID). Null for hits without a tracked design artwork. |
embroidery_design_identifier |
varchar |
Your identifier of the design: the Google Drive URL of the image file for image designs, a content hash of the text, font and color for text designs. Null for hits without a tracked design artwork. |
embroidery_design_source |
varchar |
How the design was digitized: 'manual-digitizing' (digitized by ShipMonk's embroidery team) or 'merchant' (machine file supplied by you). Null for hits without a tracked design artwork. |
stitch_count |
number |
Number of stitches of the hit, taken from the digitized design artwork it was stitched from. Sum it for stitch-out totals per product, order or period. Null for hits without a tracked artwork or whose artwork has no stitch count. |
color_count |
number |
Number of thread colors of the hit's design artwork. Null when not available. |
embroidery_hit_started_at_utc |
timestamp_ntz |
UTC timestamp when stitching of the hit started. Null if not started yet. |
embroidery_hit_completed_at_utc |
timestamp_ntz |
UTC timestamp when the hit was stitched out (completed). Null if not completed yet; filter on it being not null to count only stitched-out hits. |
embroidery_unit_completed_at_utc |
timestamp_ntz |
UTC timestamp when all embroidery on the unit was completed. Null if the unit is still open. |