Staging-Datapool nachvollziehbar inspizieren
Diese Ansicht verbindet Herkunft, Spaltenschema, Zeilenstichprobe und Metadaten eines nativen Datapools. Große Datensätze werden bewusst standardmäßig nur als Stichprobe angezeigt.
Origin
Datapool-Kontext
Rows
Alle Zeilen
Standardmäßig werden maximal 25 Beispielzeilen gezeigt. Vollansicht ist nur für kleinere Datapools freigegeben.
| # | id | sku | item_group_id | title | description | link | canonical_link | image_link | additional_image_link | availability | condition | price | sale_price | currency | sale_price_effective_date | tax_rate | net_price | gross_price | cost_price | min_margin_percent | brand | manufacturer | supplier | gtin | mpn | pzn | identifier_exists | product_type | google_product_category | color | size | gender | age_group | material | pattern | shipping_weight | shipping_label | delivery_time_days | quantity | stock_available | stock_reserved | stock_minimum | warehouse | adult | erp_sku | erp_product_type | erp_status | shop_active | channel_exclusions | compliance_notes | custom_label_0 | custom_label_1 | custom_label_2 | custom_label_3 | custom_label_4 | source_system | source_updated_at | data_quality_status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | erp:ORTH-DEMO-1-KAPSELN | ORTH-DEMO-1-KAPSELN | ORTH-DEMO-1 | Orthomed Demo Complex - Kapseln | Demo-Produkt für die ERP-basierte DataEngine-Verarbeitung. | https://www.ortho-vertrieb.de/Orthomed_Demo_Complex.html | https://www.ortho-vertrieb.de/Orthomed_Demo_Complex.html | https://www.ortho-vertrieb.de/images/Orthomed-big/Orthomed Demo Complex.jpg | in stock | new | 29.95 EUR | EUR | 19 | 25.1681 | 29.95 | 14.2 | 18 | Orthomed | Orthomed | ORTH-DEMO-1 | 00000001 | yes | Orthomed Produkte > Demo | Health & Beauty > Health Care > Fitness & Nutrition > Vitamins & Supplements | Kapseln | DE standard | 1-3 | 10 | 12 | 2 | 3 | Hauptlager | no | ORTH-DEMO-1 | simple | active | yes | Demo | erp_active | stock_positive | erp_master | commerceops-erp | 2026-05-07T10:16:39+00:00 | erp_imported | ||||||||||||||
| 2 | erp:ORTH-DEMO-2 | ORTH-DEMO-2 | ORTH-DEMO-2 | Orthomed Demo Balance | Zweites Demo-Produkt für Shop-, Google- und Repricing-Pipelines. | https://www.ortho-vertrieb.de/Orthomed_Demo_Balance.html | https://www.ortho-vertrieb.de/Orthomed_Demo_Balance.html | https://www.ortho-vertrieb.de/images/Orthomed-big/Orthomed Demo Balance.jpg | in stock | new | 39.98 EUR | EUR | 19 | 33.5981 | 39.98 | 19.5 | 20 | Orthomed | Orthomed | ORTH-DEMO-2 | yes | Orthomed Produkte > Demo | Health & Beauty > Health Care > Fitness & Nutrition > Vitamins & Supplements | DE standard | 1-3 | 4 | 4 | 0 | 2 | Hauptlager | no | ORTH-DEMO-2 | simple | active | yes | amazon_marketplace | erp_active | stock_positive | erp_master | commerceops-erp | 2026-05-07T10:16:39+00:00 | erp_imported |
Metadata
Metadaten
{
"source": "erp.domgan.de",
"columns": [
"id",
"sku",
"item_group_id",
"title",
"description",
"link",
"canonical_link",
"image_link",
"additional_image_link",
"availability",
"condition",
"price",
"sale_price",
"currency",
"sale_price_effective_date",
"tax_rate",
"net_price",
"gross_price",
"cost_price",
"min_margin_percent",
"brand",
"manufacturer",
"supplier",
"gtin",
"mpn",
"pzn",
"identifier_exists",
"product_type",
"google_product_category",
"color",
"size",
"gender",
"age_group",
"material",
"pattern",
"shipping_weight",
"shipping_label",
"delivery_time_days",
"quantity",
"stock_available",
"stock_reserved",
"stock_minimum",
"warehouse",
"adult",
"erp_sku",
"erp_product_type",
"erp_status",
"shop_active",
"channel_exclusions",
"compliance_notes",
"custom_label_0",
"custom_label_1",
"custom_label_2",
"custom_label_3",
"custom_label_4",
"source_system",
"source_updated_at",
"data_quality_status"
],
"skipped": [],
"imported_at": "2026-05-07T10:16:39+00:00",
"source_type": "commerceops_erp",
"write_back_note": "ERP ist führend. DataEngine erzeugt daraus channel-spezifische Projektionen und Sync-Pläne; Änderungen an Stammdaten müssen im ERP erfolgen.",
"quality_warnings": [
{
"sku": "ORTH-DEMO-1-KAPSELN",
"field": "gtin",
"message": "GTIN fehlt; nur belegte Hersteller-/GS1-Werte nachpflegen."
},
{
"sku": "ORTH-DEMO-2",
"field": "gtin",
"message": "GTIN fehlt; nur belegte Hersteller-/GS1-Werte nachpflegen."
}
],
"variant_row_count": 2,
"canonical_standard": "dataengine_commerce_product_v2",
"raw_stock_datapool": "erp_stock_raw_v1",
"raw_stock_metadata": {
"source": "erp.domgan.de",
"endpoint": "/api/v1/stock",
"imported_at": "2026-05-07T10:16:39+00:00"
},
"source_stock_count": 2,
"write_back_enabled": false,
"source_product_count": 2,
"raw_products_datapool": "erp_products_raw_v1",
"raw_products_metadata": {
"source": "erp.domgan.de",
"endpoint": "/api/v1/products",
"imported_at": "2026-05-07T10:16:39+00:00"
}
}