Skip to content

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.