Symfony Profiler

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_367af465ca304630cf45a2132778bed1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/webhook/shopify/leomat/' AND `key` = BINARY 'order';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook/shopify/leomat/order';

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/webhook/shopify/' AND `key` = BINARY 'leomat';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook/shopify/leomat';

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/webhook/' AND `key` = BINARY 'shopify';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook/shopify';

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'webhook';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook';

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1');

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = 1
                             ) AND ctype='document';

SELECT
  object_shopifyconfig.id as id,
  object_shopifyconfig.type as `type`
FROM
  object_shopifyconfig
WHERE
  (
    active = 1
    AND object_shopifyconfig.type IN ('object', 'variant', 'folder')
  )
  AND object_shopifyconfig.published = 1

SELECT object_shopifyconfig.id as id, object_shopifyconfig.type as `type` FROM object_shopifyconfig WHERE (active = 1 AND  object_shopifyconfig.type IN ('object','variant','folder')) AND object_shopifyconfig.published = 1;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_263');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_263
tags
', 'class_shopifyconfig
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4654');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4654
tags
', 'class_shopifyconfig
tags
');

SELECT
  object_orders.id as id,
  object_orders.type as `type`
FROM
  object_orders
WHERE
  (
    orderId = ?
    AND object_orders.type IN ('object', 'variant', 'folder')
  )
  AND object_orders.published = 1

SELECT object_orders.id as id, object_orders.type as `type` FROM object_orders WHERE (orderId = 7715650732370 AND  object_orders.type IN ('object','variant','folder')) AND object_orders.published = 1;

SELECT
  object_orders.id as id,
  object_orders.type as `type`
FROM
  object_orders
WHERE
  (
    orderId = ?
    AND object_orders.type IN ('object', 'variant', 'folder')
  )
  AND object_orders.published = 1

SELECT object_orders.id as id, object_orders.type as `type` FROM object_orders WHERE (orderId = 7715650732370 AND  object_orders.type IN ('object','variant','folder')) AND object_orders.published = 1;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19177');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_19177');

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 19177;

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 19177;

SELECT
  *
FROM
  object_store_orders
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_orders WHERE oo_id = 19177 FOR UPDATE;

SELECT
  `id`,
  `name`
FROM
  classes
WHERE
  id = ?

SELECT `id`, `name` FROM classes WHERE id = 'orders' ;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('quantityvalue_units_table');

SELECT
  *
FROM
  object_collection_ShopifyPayload_orders
WHERE
  id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = 19177 AND fieldname = 'payload' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_relations_orders
WHERE
  src_id = ?

SELECT * FROM object_relations_orders WHERE src_id = 19177;

SELECT
  `id`,
  `name`
FROM
  classes
WHERE
  id = ?

SELECT `id`, `name` FROM classes WHERE id = 'product' ;

SELECT
  object_localized_product_de.id as id,
  object_localized_product_de.type as `type`
FROM
  object_localized_product_de
WHERE
  (
    `sku` = '2521'
    AND object_localized_product_de.type IN ('variant', 'object')
  )
  AND object_localized_product_de.published = 1
LIMIT
  1

SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2521'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_18225');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_18225
tags
', 'class_product
tags
', 'asset_806
tags
', 'asset_807
tags
');

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 18225;

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 18225;

SELECT
  *
FROM
  object_store_product
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_product WHERE oo_id = 18225 FOR UPDATE;

SELECT
  *
FROM
  object_localized_data_product
WHERE
  ooo_id = ?
  AND language IN ('de', 'fr')

SELECT * FROM object_localized_data_product WHERE ooo_id = 18225 AND language IN ('de','fr');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_806');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_807');

SELECT
  *
FROM
  object_relations_product
WHERE
  src_id = ?

SELECT * FROM object_relations_product WHERE src_id = 18225;

SELECT
  object_vendor.id as id,
  object_vendor.type as `type`
FROM
  object_vendor
WHERE
  (
    shopifyVendorId = ?
    OR name = ?
    AND object_vendor.type IN ('object', 'variant', 'folder')
  )
  AND object_vendor.published = 1

SELECT object_vendor.id as id, object_vendor.type as `type` FROM object_vendor WHERE (shopifyVendorId = 'Leomat' OR name = 'Leomat' AND  object_vendor.type IN ('object','variant','folder')) AND object_vendor.published = 1;

SELECT
  object_vendor.id as id,
  object_vendor.type as `type`
FROM
  object_vendor
WHERE
  (
    shopifyVendorId = ?
    OR name = ?
    AND object_vendor.type IN ('object', 'variant', 'folder')
  )
  AND object_vendor.published = 1

SELECT object_vendor.id as id, object_vendor.type as `type` FROM object_vendor WHERE (shopifyVendorId = 'Leomat' OR name = 'Leomat' AND  object_vendor.type IN ('object','variant','folder')) AND object_vendor.published = 1;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6002');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6002
tags
', 'class_vendor
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19176');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_19176');

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 19176;

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 19176;

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 19176;

SELECT
  id
FROM
  objects
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM objects WHERE `path` = BINARY '/Orders/Leomat/2026/04/16/' AND `key` = BINARY '1040';

SELECT
  id
FROM
  objects
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM objects WHERE `path` = BINARY '/Orders/Leomat/2026/04/16/' AND `key` = BINARY '1040';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 19177;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 19177 FOR UPDATE;

SELECT
  MAX(versionCount)
FROM
  versions
WHERE
  cid = ?
  AND ctype = 'object'

SELECT MAX(versionCount) FROM versions WHERE cid = 19177 AND ctype = 'object';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_objects');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776664859 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_objects');

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SELECT
  type,
  classId,
  className
FROM
  objects
WHERE
  id = ?

SELECT type,classId,className FROM objects WHERE id = 19177;

INSERT INTO objects (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `key`, `index`,
  `childrenSortBy`, `childrenSortOrder`,
  `classId`, `published`, `className`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES ('/Orders/Leomat/2026/04/16/', 19177, 1776321113, 1776664859, 197, 0, 0, 19176, 'object', '1040', 0, NULL, NULL, 'orders', 1, 'Orders');

UPDATE
  objects
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `key` = ?,
  `index` = ?,
  `childrenSortBy` = ?,
  `childrenSortOrder` = ?,
  `classId` = ?,
  `published` = ?,
  `className` = ?
WHERE
  `id` = ?

UPDATE objects SET `path` = '/Orders/Leomat/2026/04/16/', `id` = 19177, `creationDate` = 1776321113, `modificationDate` = 1776664859, `versionCount` = 197, `userOwner` = 0, `userModification` = 0, `parentId` = 19176, `type` = 'object', `key` = '1040', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'orders', `published` = 1, `className` = 'Orders' WHERE `id` = 19177;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

DELETE FROM tree_locks WHERE id = 19177 AND type = 'object';

SELECT
  `id`
FROM
  `object_collection_LineItems_orders`
WHERE
  `id` = '19177'
  AND `fieldname` = 'lineItems'
LIMIT
  1

SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '19177' AND `fieldname` = 'lineItems' LIMIT 1;

DELETE FROM
  object_collection_LineItems_orders
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_LineItems_orders WHERE id = 19177 AND fieldname = 'lineItems';

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'fieldcollection'
    AND ownername = 'lineItems'
    AND src_id = '19177'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '19177');

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'localizedfield'
    AND ownername LIKE '/fieldcollection~lineItems/%'
    AND src_id = '19177'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '19177');

INSERT INTO object_relations_orders (
  `dest_id`, `type`, `fieldname`, `src_id`,
  `ownertype`, `ownername`, `position`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (18225, 'object', 'product', 19177, 'fieldcollection', 'lineItems', '0');

INSERT INTO object_relations_orders (
  `dest_id`, `type`, `fieldname`, `src_id`,
  `ownertype`, `ownername`, `position`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (6002, 'object', 'vendor', 19177, 'fieldcollection', 'lineItems', '0');

INSERT INTO object_collection_LineItems_orders (
  `id`, `index`, `fieldname`, `title`,
  `sku`, `quantity`, `price__value`,
  `price__unit`, `fulfillmentStatus`,
  `taxable`, `metaData`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (19177, 0, 'lineItems', 'Kambly Bretzeli', '2521', 2, 25.6, 'CHF', '', 0, '[]');

SELECT
  `id`
FROM
  `object_collection_ShopifyPayload_orders`
WHERE
  `id` = '19177'
  AND `fieldname` = 'payload'
LIMIT
  1

SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '19177' AND `fieldname` = 'payload' LIMIT 1;

DELETE FROM
  object_collection_ShopifyPayload_orders
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_ShopifyPayload_orders WHERE id = 19177 AND fieldname = 'payload';

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'fieldcollection'
    AND ownername = 'payload'
    AND src_id = '19177'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '19177');

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'localizedfield'
    AND ownername LIKE '/fieldcollection~payload/%'
    AND src_id = '19177'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '19177');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 0, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T08:31:51+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:31:51+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 08:31:53');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 1, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T08:31:51+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:31:51+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/create', '2026-04-16 08:31:53');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 2, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:pending\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T09:00:51+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:47:00+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 09:00:52');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 3, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:pending\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T10:01:12+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:47:00+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 10:01:15');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 4, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:pending\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T11:01:13+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:47:00+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 11:01:16');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 5, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:pending\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T12:01:00+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:47:00+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 12:01:03');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 6, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:pending\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T13:00:53+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:47:00+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 13:00:55');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 7, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:pending\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T14:00:54+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:47:00+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 14:00:56');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19177, 8, 'payload', '{\"id\":7715650732370,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7715650732370\",\"app_id\":580111,\"browser_ip\":\"212.55.200.181\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNB0NQVslJfq09i0hmGhbvv\",\"checkout_id\":48275599130962,\"checkout_token\":\"2684aa51cae080b3a4a8c86547c321eb\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"212.55.200.181\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36 Edg\\/147.0.0.0\"},\"closed_at\":null,\"company\":null,\"confirmation_number\":\"KU1NQ5LL1\",\"confirmed\":true,\"contact_email\":\"info@schoch-vending.ch\",\"created_at\":\"2026-04-16T08:31:50+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"51.20\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"51.20\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-CH\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"info@schoch-vending.ch\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/account\\/login?return_url=\\/account\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1040\",\"note\":\"iris  Reichle Wetzikon\",\"note_attributes\":[],\"number\":40,\"order_number\":1040,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/605c065be619fbb047111f44cf3ef605\\/authenticate?key=e3895a383150d3f070a697afdc629f56\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-16T08:31:49+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"51.20\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:pending\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"605c065be619fbb047111f44cf3ef605\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"51.20\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"51.20\",\"total_price\":\"51.20\",\"total_price_set\":{\"shop_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"51.20\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-16T15:00:55+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155365499218,\"created_at\":\"2026-03-19T06:45:04+01:00\",\"updated_at\":\"2026-04-16T08:47:00+02:00\",\"first_name\":null,\"last_name\":\"2020130000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"info@schoch-vending.ch\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155365499218\",\"default_address\":{\"id\":12261477613906,\"customer_id\":10155365499218,\"first_name\":\"Urs\",\"last_name\":\"Berger\",\"company\":null,\"address1\":\"Hofstrasse\",\"address2\":null,\"city\":\"Wetzikon\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"8620\",\"phone\":null,\"name\":\"Urs Berger\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18145519141202,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18145519141202\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":2,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Kambly Bretzeli\",\"price\":\"25.60\",\"price_set\":{\"shop_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"25.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687810732370,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"2521\",\"taxable\":true,\"title\":\"Kambly Bretzeli\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072795763026,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":\"Urs\",\"address1\":\"Hofstrasse\",\"phone\":null,\"city\":\"Wetzikon\",\"zip\":\"8620\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Berger\",\"address2\":null,\"company\":null,\"latitude\":47.3109102,\"longitude\":8.7961886,\"name\":\"Urs Berger\",\"country_code\":\"CH\",\"province_code\":null},\"shipping_lines\":[{\"id\":6071674175826,\"carrier_identifier\":null,\"code\":\"teest\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"discounted_price\":\"0.00\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"is_removed\":false,\"phone\":null,\"price\":\"0.00\",\"price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"teest\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-04-16 15:00:58');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)