{"id":152,"date":"2022-09-27T10:06:24","date_gmt":"2022-09-27T10:06:24","guid":{"rendered":"https:\/\/sqlshipper.com\/?page_id=152"},"modified":"2024-11-18T09:59:25","modified_gmt":"2024-11-18T09:59:25","slug":"home","status":"publish","type":"page","link":"https:\/\/sqlshipper.com\/","title":{"rendered":"Home"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"152\" class=\"elementor elementor-152\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0b48d6d elementor-section-height-min-height elementor-section-boxed elementor-section-height-default elementor-section-items-middle\" data-id=\"0b48d6d\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;background_motion_fx_motion_fx_scrolling&quot;:&quot;yes&quot;,&quot;background_motion_fx_opacity_effect&quot;:&quot;yes&quot;,&quot;background_motion_fx_opacity_direction&quot;:&quot;in-out&quot;,&quot;background_motion_fx_opacity_level&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:7,&quot;sizes&quot;:[]},&quot;background_motion_fx_opacity_range&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:{&quot;start&quot;:52,&quot;end&quot;:80}},&quot;background_motion_fx_blur_effect&quot;:&quot;yes&quot;,&quot;background_motion_fx_blur_direction&quot;:&quot;in-out&quot;,&quot;background_motion_fx_blur_level&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:4,&quot;sizes&quot;:[]},&quot;background_motion_fx_blur_range&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:{&quot;start&quot;:51,&quot;end&quot;:80}},&quot;background_motion_fx_devices&quot;:[&quot;desktop&quot;,&quot;tablet&quot;,&quot;mobile&quot;]}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-548bfdf\" data-id=\"548bfdf\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ca48472 elementor-fixed elementor-widget elementor-widget-heading\" data-id=\"ca48472\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;fixed&quot;}\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">SQL Shipper<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1482767 elementor-align-center elementor-fixed elementor-widget elementor-widget-button\" data-id=\"1482767\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;fixed&quot;}\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-pulse-grow\" href=\"#sql2\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-angle-double-down\"><\/i>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5aaf9b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5aaf9b2\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b81f140\" data-id=\"b81f140\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-caeb9ac elementor-widget elementor-widget-menu-anchor\" data-id=\"caeb9ac\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-menu-anchor\" id=\"sql2\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4c37877 elementor-widget elementor-widget-menu-anchor\" data-id=\"4c37877\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-menu-anchor\" id=\"sql1\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-051835c elementor-widget elementor-widget-heading\" data-id=\"051835c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">SQLShipper \u2013 BarcodeShipping mit Datenbank Direktanbindung\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56287a7 elementor-widget elementor-widget-text-editor\" data-id=\"56287a7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"p1\"><span class=\"s1\">Sie wollen f\u00fcr den Versand Waren und Paketen keine extra Text-, CSV-, XML- oder \u00e4hnliche Dateischnittstelle f\u00fcr Ihre propriet\u00e4re ERP- oder Versand-Software teuer programmieren lassen?<\/span><\/p><p class=\"p1\"><span class=\"s1\">Dann haben wir die ideale L\u00f6sung f\u00fcr Sie, mit der Sie jede beliebige Datenbank an unsere Versandl\u00f6sung f\u00fcr Ihren (Online-)Shop zwecks automatisiertem Versandlabeldruck ganz einfach anbinden k\u00f6nnen.<\/span><\/p><p class=\"p1\"><span class=\"s1\"><br \/>Nutzen Sie BarcodeShipping mit unserem Modul \u201eSQL Datenbank Direktanbindung\u201c!<\/span><\/p><p class=\"p1\"><span class=\"s1\"><br \/>Unser Software-Modul SQLShipper versetzt Sie in die Lage passend zu Ihren Auftr\u00e4gen aus jeglicher Art von Datenbank mittels propriet\u00e4rer und ODBC-Treiber, sofern ein entsprechender JDBC-Treiber verf\u00fcgbar ist, \u00fcber ein einfaches SQL-Mapping die f\u00fcr den Labeldruck notwendigen Datens\u00e4tze zu ziehen und \u00fcber unsere Software BarcodeShipping z.B. das notwendige Versandlabel zu drucken.<br \/>Des Weiteren stehen Ihnen selbstverst\u00e4ndlich alle M\u00f6glichkeiten von BarcodeShipping zur Verarbeitung dieser Daten zur Verf\u00fcgung.<br \/>Auch z.B. Trackingnummern des jeweiligen Versanddienstleisters k\u00f6nnen \u00fcber das Modul SQLShipper an Ihre Datenbank respektive Ihr Shopsystem zur\u00fcckgemeldet und genutzt werden.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-825330c elementor-section-height-min-height elementor-section-boxed elementor-section-height-default elementor-section-items-middle\" data-id=\"825330c\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1f95711\" data-id=\"1f95711\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4ba6ee4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ba6ee4\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ef8e629\" data-id=\"ef8e629\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-547630b elementor-widget elementor-widget-menu-anchor\" data-id=\"547630b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-menu-anchor\" id=\"sqlmeetsbcs\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77f2e6b elementor-widget elementor-widget-heading\" data-id=\"77f2e6b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">SQLShipper \u2013 Einsatzm\u00f6glichkeiten der SQL Datenbank Direktanbindung mit BarcodeShipping\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-db4f2ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"db4f2ab\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-90065f3\" data-id=\"90065f3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-29ef2d4 elementor-widget elementor-widget-text-editor\" data-id=\"29ef2d4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li style=\"list-style-type: none;\"><ul><li class=\"p1\"><span class=\"s1\">BarcodeShipping verbindet\u00a0SQL Datenbank Direktanbindung\u00a0mit Ihren genutzten Versanddienstleistern. Nutzen Sie zahlreiche Funktionen, mit denen Sie den Versandprozess automatisieren und damit vereinfachen:<\/span><\/li><li class=\"p1\"><span class=\"s1\">BarcodeShipping als\u00a0zentrale Schnittstelle: Die Anwendung l\u00e4dt alle notwendigen Daten aus der\u00a0SQL Datenbank Direktanbindung, wie Artikelnummer oder Empf\u00e4ngeradressen. Nachdem alle Artikel eingegeben oder eingescannt wurden und damit der Versand abgeschlossen werden kann, speichert BarcodeShipping den Status der Bestellung sowie Trackingnummer in Ihrer\u00a0SQL Datenbank ab.<\/span><\/li><li class=\"p1\"><span class=\"s1\">BarcodeShipping als\u00a0Automatisierung: Nach der Eingabe der Artikel wird automatisch ein Versandlabel generiert und gedruckt. Sie nutzen verschiedene Versanddienstleister? Sie k\u00f6nnen die Auswahl entweder beim Versand manuell treffen oder ein Skript einstellen. Mit diesem kann BarcodeShipping den passenden Dienstleister nach Ihren Vorgaben automatisch ausw\u00e4hlen.<\/span><\/li><li class=\"p1\"><span class=\"s1\">BarcodeShipping ist Qualit\u00e4tssicherung: Ein Versandetikett wird erst erstellt und die Bestellung damit als \u201evollst\u00e4ndig\u201c markiert, wenn alle enthaltenen Artikel eingegeben oder eine Teilsendung best\u00e4tigt wurde. Damit wird die korrekte Abwicklung sichergestellt.<\/span><\/li><\/ul><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-8be74b8\" data-id=\"8be74b8\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-19b7e99 elementor-widget elementor-widget-heading\" data-id=\"19b7e99\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Anleitung gesucht?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ccf28d elementor-widget elementor-widget-heading\" data-id=\"9ccf28d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Dann klicken sie doch gerne hier!<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7495ee1 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"7495ee1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-shrink\" href=\"https:\/\/www.barcodeshipping.de\/sql\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Zur Anleitung<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-736dafd elementor-section-height-min-height elementor-section-boxed elementor-section-height-default elementor-section-items-middle\" data-id=\"736dafd\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c15c5b4\" data-id=\"c15c5b4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2d2df81 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2d2df81\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3150fe4\" data-id=\"3150fe4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f11d90 elementor-widget elementor-widget-menu-anchor\" data-id=\"1f11d90\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"menu-anchor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-menu-anchor\" id=\"how\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a537049 elementor-widget elementor-widget-heading\" data-id=\"a537049\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Wie funktioniert der SQLShipper?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-63e858d elementor-widget elementor-widget-text-editor\" data-id=\"63e858d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Da Barcodeshipping eine JAVA-basierte Anwendung ist, kann diese mittels der JDBC-API auf jede beliebige Datenbank, welche \u00fcber JDBC-Treiber verf\u00fcgt zugreifen und dort Operationen \u2013 sogenannte SQL-Statements \u2013 ausf\u00fchren. Abh\u00e4ngig von den Befehlen k\u00f6nnen somit die Daten gelesen (select) oder geschrieben bzw. aktualisiert (insert \/ update) werden.<br \/>Auch Datenbank, die lediglich \u00fcber einen nativen oder einen ODBC-Treiber verf\u00fcgen, k\u00f6nnen \u00fcber entsprechende \u201eJDBC ODBC Bridge Driver\u201c bzw. \u201ePartial Java JDBC Driver\u201c erreicht und angebunden werden.<br \/>Sogar Systeme, deren Datenbank z.B. lediglich \u00fcber eine Middleware zugreifbar ist, k\u00f6nnen \u00fcber \u201ePure Java JDBC Driver\u201c verkn\u00fcpft werden.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5864f4c elementor-widget elementor-widget-image\" data-id=\"5864f4c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"674\" src=\"https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle-1024x863.png\" class=\"attachment-large size-large wp-image-89\" alt=\"\" srcset=\"https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle-1024x863.png 1024w, https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle-300x253.png 300w, https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle-768x647.png 768w, https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle-1536x1295.png 1536w, https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle-2048x1726.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fd3a7ad elementor-widget elementor-widget-text-editor\" data-id=\"fd3a7ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ist der JDBC Datenbankzugriff erst definiert k\u00f6nnen Sie nun Abfragen mittels des SQLShippers an Ihre Datenbank senden.<\/p><p>Im Prinzip funktioniert jede Abfrage an Ihre Shop-Datenbank per SQL-Befehl, bei dem die Inhalte- auch kombinierte &#8211; auf das entsprechende Attribut in BarcodeShipping gemappt werden:\u00a0<\/p><p>SELECT ID AS orderID, &#8230;, strasse AS shipToStreet<br \/>FROM Customers;<\/p><p>Es stehen hierzu 5 verschiedene Typen von SQL-Statements im SQLShipper zur Verf\u00fcgung, die im folgenden beschrieben werden.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5af8091 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"5af8091\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ddf640f elementor-widget elementor-widget-text-editor\" data-id=\"ddf640f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>\u00dcber die &#8222;PreviewQuery&#8220; k\u00f6nnen Sie per einfachem SQL-Statement Auftragsdaten aus Ihrer ggf. propriet\u00e4ren Shop-Datenbank ins BarcodeShipping holen und zur Anzeige bringen.\u00a0<\/p><p>Bsp. &#8222;previewQuery&#8220;:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e5ea8d1 elementor-widget elementor-widget-text-editor\" data-id=\"e5ea8d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<pre style=\"font-family: monospace;\"><span style=\"color: #990099; font-weight: bold;\">SELECT<\/span> df_empfstat\n              <span style=\"color: #cc0099;\">||<\/span> \u201a<span style=\"color: #cc0099;\">-<\/span>\u201a\n              <span style=\"color: #cc0099;\">||<\/span> df_niederlas\n              <span style=\"color: #cc0099;\">||<\/span> \u201a<span style=\"color: #cc0099;\">-<\/span>\u201a\n              <span style=\"color: #cc0099;\">||<\/span> df_datauftannahme\n              <span style=\"color: #cc0099;\">||<\/span> \u201a<span style=\"color: #cc0099;\">-<\/span>\u201a\n              <span style=\"color: #cc0099;\">||<\/span> df_lfdnrauftrag                       <span style=\"color: #990099; font-weight: bold;\">AS<\/span> orderid<span style=\"color: #000033;\">,<\/span>\n       df_pod                                          <span style=\"color: #990099; font-weight: bold;\">AS<\/span> ordernumber<span style=\"color: #000033;\">,<\/span>\n       df_empfname1                                    <span style=\"color: #990099; font-weight: bold;\">AS<\/span> shiptoname<span style=\"color: #000033;\">,<\/span>\n       l.df_lkz_iata                                   <span style=\"color: #990099; font-weight: bold;\">AS<\/span> shiptocountry<span style=\"color: #000033;\">,<\/span>\n       \u2019processing\u2018                                <span style=\"color: #990099; font-weight: bold;\">AS<\/span> <span style=\"color: #990099; font-weight: bold;\">status<\/span><span style=\"color: #000033;\">,<\/span>\n       df_datauftannahme                               <span style=\"color: #990099; font-weight: bold;\">AS<\/span> orderedat<span style=\"color: #000033;\">,<\/span>\n       df_datauftannahme                               <span style=\"color: #990099; font-weight: bold;\">AS<\/span> createdat<span style=\"color: #000033;\">,<\/span>\n       df_niederlas                                          <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> paymentmethod<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><br \/>       df_pod_reference ex_hwb from \u201cdba\u201c.tb_auftragsdaten    aleft\n<span style=\"color: #990099; font-weight: bold;\">JOIN<\/span>   dba.tb_laender lon a.df_empflkz <span style=\"color: #cc0099;\">=<\/span> l.df_lkzwheredf_datauftannahme <span style=\"color: #cc0099;\">&gt;<\/span> <span style=\"color: #990099; font-weight: bold;\">CONVERT<\/span><span style=\"color: #ff00ff;\">(<\/span><span style=\"color: #999900; font-weight: bold;\">date<\/span><span style=\"color: #000033;\">,<\/span> <span style=\"color: #000099;\">now<\/span><span style=\"color: #ff00ff;\">(<\/span><span style=\"color: #ff00ff;\">)<\/span> \u2013 <span style=\"color: #008080;\">1<\/span> <span style=\"color: #ff00ff;\">)<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_niederlas <span style=\"font-size: 1em; color: #cc0099;\">=<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> \u201acas\u2019<\/span><span style=\"font-size: 1em; color: #cc0099; font-weight: bold;\">and<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> df_pod_reference <\/span><span style=\"font-size: 1em; color: #cc0099; font-weight: bold;\">IS<\/span> <span style=\"font-size: 1em; color: #9900ff; font-weight: bold;\">NULL<\/span><br \/><span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_auftrags_status <span style=\"color: #990099; font-weight: bold;\">IN<\/span> <span style=\"color: #ff00ff;\">(<\/span><span style=\"color: #008080;\">3<\/span><span style=\"color: #000033;\">,<\/span><span style=\"color: #008080;\">1<\/span><span style=\"color: #ff00ff;\">)<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_empfstat   <span style=\"color: #990099; font-weight: bold;\">IN<\/span> <span style=\"color: #ff00ff;\">(<\/span> \u201ar03\u2018<span style=\"color: #ff00ff;\">)<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    l.df_lkz_iata <span style=\"color: #cc0099;\">!=<\/span> \u201akv\u2019\u201c<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-76b51be elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"76b51be\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-399d7bc elementor-widget elementor-widget-text-editor\" data-id=\"399d7bc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mit der &#8222;OrderQuery&#8220; k\u00f6nnen Sie \u00fcber einen weiteren SQL-Befehl die Daten einzelner Bestellungen aus Ihrem Auftragsvolumen einsehen und zur Verarbeitung innerhalb BarcodeShippings nutzen.\u00a0<\/p><p>Bsp. &#8222;orderQuery&#8220;:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2adafa3 elementor-widget elementor-widget-text-editor\" data-id=\"2adafa3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<pre style=\"font-family: monospace;\">SELECTDF_NDL <span style=\"color: #cc0099;\">||<\/span> \u201a<span style=\"color: #cc0099;\">-<\/span>\u201a <span style=\"color: #cc0099;\">||<\/span> df_datauftannahme <span style=\"color: #cc0099;\">||<\/span> \u201a<span style=\"color: #cc0099;\">-<\/span>\u201a <span style=\"color: #cc0099;\">||<\/span> df_lfdnrauftrag <span style=\"color: #990099; font-weight: bold;\">AS<\/span> ordernumber<span style=\"color: #000033;\">,<\/span>df_pod <span style=\"color: #990099; font-weight: bold;\">AS<\/span> orderid<span style=\"color: #000033;\">,<\/span>df_pod <span style=\"color: #cc0099;\">||<\/span>\n<span style=\"color: #ff00ff;\">(<\/span>\n       <span style=\"color: #990099; font-weight: bold;\">SELECT<\/span> <span style=\"color: #000099;\">char<\/span><span style=\"color: #ff00ff;\">(<\/span><span style=\"color: #008080;\">13<\/span><span style=\"color: #ff00ff;\">)<\/span>\n                     <span style=\"color: #cc0099;\">||<\/span> \u201amfr<span style=\"color: #cc0099;\">-<\/span>\u201a\n                     <span style=\"color: #cc0099;\">||<\/span> z.df_nr_ausfuhranmeldung\n       <span style=\"color: #990099; font-weight: bold;\">FROM<\/span>   dba.tb_zolldaten z\n       <span style=\"color: #990099; font-weight: bold;\">WHERE<\/span>  a.df_datauftannahme <span style=\"color: #cc0099;\">=<\/span> z.df_datauftannahme\n       <span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    a.df_lfdnrauftrag <span style=\"color: #cc0099;\">=<\/span> z.df_lfdnrauftrag\n       <span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    a.df_niederlas <span style=\"font-size: 1em; color: #cc0099;\">=<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> z.<\/span>df_niederlas <span style=\"font-size: 1em; color: #ff00ff;\">)<\/span> <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> \u201areference\u2018<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">\u2019processing\u2018 <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span> <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">status<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span>df_niederlas <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> paymentmethod<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> \u201aeur\u2018 <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> currency<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">df_empfname1 <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptofirstname<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">df_empfname2 <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptomiddlenme<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> df_empfname3 <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptolastname<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">l.df_lkz_iata <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptocountry<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">df_empfstr <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptostreet<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">df_empfhnr <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptohousenumber<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">df_empfhnrzusatz <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptoadditionallines<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> df_empfplz <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptopostcode<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">df_empfort <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptocity<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\">df_ruf_empf <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">AS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> shiptophone <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">FROM<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> dba.tb_auftragsdaten a <\/span><span style=\"font-size: 1em; color: #000099;\">LEFT<\/span> <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">JOIN<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> dba.tb_laender l <\/span><span style=\"font-size: 1em; color: #990099; font-weight: bold;\">ON<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> a.df_empflkz <\/span><span style=\"font-size: 1em; color: #cc0099;\">=<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> l.df_lkz where df_datauftannahme <\/span><span style=\"font-size: 1em; color: #cc0099;\">&gt;<\/span> <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">CONVERT<\/span><span style=\"font-size: 1em; color: #ff00ff;\">(<\/span><span style=\"font-size: 1em; color: #999900; font-weight: bold;\">date<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span> <span style=\"font-size: 1em; color: #000099;\">now<\/span><span style=\"font-size: 1em; color: #ff00ff;\">(<\/span><span style=\"font-size: 1em; color: #ff00ff;\">)<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> \u2013 <\/span><span style=\"font-size: 1em; color: #008080;\">30<\/span> <span style=\"font-size: 1em; color: #ff00ff;\">)<\/span><br \/><span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>\n<span style=\"font-size: 17.6px; color: var( --e-global-color-9e50276 );\">df_niederlas<\/span> <span style=\"color: #cc0099;\">=<\/span> \u201acas\u2018\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>\ndf_pod_reference <span style=\"color: #cc0099; font-weight: bold;\">IS<\/span> nulland df_auftrags_status <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">IN<\/span> <span style=\"font-size: 1em; color: #ff00ff;\">(<\/span><span style=\"font-size: 1em; color: #008080;\">3<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><br \/>                                              <span style=\"color: #008080;\">1<\/span><span style=\"color: #ff00ff;\">)<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>\ndf_empfstat <span style=\"color: #990099; font-weight: bold;\">IN<\/span> <span style=\"color: #ff00ff;\">(<\/span>\u201ar01\u2018<span style=\"color: #000033;\">,<\/span>\n                \u201ar03\u2018<span style=\"color: #ff00ff;\">)<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>\ndf_pod <span style=\"color: #cc0099;\">=<\/span> :orderId\u201c<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b06e621 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b06e621\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e62b23 elementor-widget elementor-widget-text-editor\" data-id=\"8e62b23\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mittels dem SQL-Befehl in der ItemQuery k\u00f6nnen SIe wiederum einzelne Items aus einer Bestellung anzeigen und verarbeiten.\u00a0<\/p><p>Bsp. &#8222;itemQuery&#8220;<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dd37493 elementor-widget elementor-widget-text-editor\" data-id=\"dd37493\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<pre class=\"mysql\" style=\"font-family: monospace;\"><span style=\"color: #990099; font-weight: bold;\">SELECT<\/span> \u201a<span style=\"color: #008080;\">1<\/span>\u2018                               <span style=\"color: #990099; font-weight: bold;\">AS<\/span> itemid<span style=\"color: #000033;\">,<\/span>\n       \u2019<span style=\"color: #008080;\">1<\/span>\u2032                               <span style=\"color: #990099; font-weight: bold;\">AS<\/span> sku<span style=\"color: #000033;\">,<\/span>\n       \u201a<span style=\"color: #008080;\">123<\/span>\u2018                             <span style=\"color: #990099; font-weight: bold;\">AS<\/span> ean<span style=\"color: #000033;\">,<\/span>\n       a.df_inhalt                           <span style=\"color: #990099; font-weight: bold;\">AS<\/span> NAME<span style=\"color: #000033;\">,<\/span>\n       \u201ade\u2018                              <span style=\"color: #990099; font-weight: bold;\">AS<\/span> country<span style=\"color: #000033;\">,<\/span>\n       \u2019<span style=\"color: #008080;\">123456789<\/span>\u2032                       <span style=\"color: #990099; font-weight: bold;\">AS<\/span> commoditycode<span style=\"color: #000033;\">,<\/span>\n       a.df_warenwert                        <span style=\"color: #990099; font-weight: bold;\">AS<\/span> price<span style=\"color: #000033;\">,<\/span>\n       <span style=\"color: #000099;\">Replace<\/span><span style=\"color: #ff00ff;\">(<\/span>a.df_real_kg<span style=\"color: #000033;\">,<\/span>\u2018<span style=\"color: #000033;\">,<\/span>\u2018<span style=\"color: #000033;\">,<\/span>\u2018.\u2018<span style=\"color: #ff00ff;\">)<\/span> <span style=\"color: #990099; font-weight: bold;\">AS<\/span> weight<span style=\"color: #000033;\">,<\/span>\n       a.df_anzpack                          <span style=\"color: #990099; font-weight: bold;\">AS<\/span> quantityinvoiced<span style=\"color: #000033;\">,<\/span>\n       a.df_anzpack                          <span style=\"color: #990099; font-weight: bold;\">AS<\/span> quantityordered<span style=\"color: #000033;\">,<\/span>\n       \u201a<span style=\"color: #008080;\">0<\/span>\u2018                               <span style=\"color: #990099; font-weight: bold;\">AS<\/span> quantityshipped from \u201cdba\u201c.tb_auftragsdaten a where df_datauftannahme <span style=\"color: #cc0099;\">&gt;<\/span> <span style=\"color: #990099; font-weight: bold;\">CONVERT<\/span><span style=\"color: #ff00ff;\">(<\/span><span style=\"color: #999900; font-weight: bold;\">date<\/span><span style=\"color: #000033;\">,<\/span> <span style=\"color: #000099;\">now<\/span><span style=\"color: #ff00ff;\">(<\/span><span style=\"color: #ff00ff;\">)<\/span> \u2013 <span style=\"color: #008080;\">30<\/span> <span style=\"color: #ff00ff;\">)<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_niederlas <span style=\"font-size: 1em; color: #cc0099;\">=<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> \u201acas\u2019<\/span><span style=\"font-size: 1em; color: #cc0099; font-weight: bold;\">and<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> df_pod_reference <\/span><span style=\"font-size: 1em; color: #cc0099; font-weight: bold;\">IS<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> nulland <\/span>df_auftrags_status <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">IN<\/span> <span style=\"font-size: 1em; color: #ff00ff;\">(<\/span><span style=\"font-size: 1em; color: #008080;\">3<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: #008080;\">1<\/span><span style=\"font-size: 1em; color: #ff00ff;\">)<\/span><br \/><span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_empfstat                                                     <span style=\"color: #990099; font-weight: bold;\">IN<\/span> <span style=\"color: #ff00ff;\">(<\/span>\u201ar01\u2018<span style=\"color: #000033;\">,<\/span>\n                                                                           \u201ar03\u2018<span style=\"color: #ff00ff;\">)<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_pod <span style=\"color: #cc0099;\">=<\/span> :orderId\u201cIGNOREGENERATEDKEYS: <span style=\"color: #9900ff; font-weight: bold;\">true<\/span><\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3847d21 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3847d21\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-07daef6 elementor-widget elementor-widget-text-editor\" data-id=\"07daef6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Damit Informationen wie z.B. die Trackingnummer zu einer Bestellung an die gew\u00fcnschte Stelle Ihrer Datenbank zur\u00fcckgeschrieben wird, steht das \u201eUpdateOrderStatement\u201c zur Verg\u00fcgung.<br \/>Somit werden die ben\u00f6tigten Versandinformation auch in Ihrem Shopsystem verf\u00fcgbar gemacht.<\/p><p>Bsp. &#8222;updateOrderStatements\u201c:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d661c6 elementor-widget elementor-widget-text-editor\" data-id=\"1d661c6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<pre style=\"font-family: monospace;\"><span style=\"color: #990099; font-weight: bold;\">UPDATE<\/span> \u201edba\u201c.tb_auftragsdaten\n<span style=\"color: #990099; font-weight: bold;\">SET<\/span>    df_pod_reference <span style=\"color: #cc0099;\">=<\/span> :shipment.trackingnumber\n<span style=\"color: #990099; font-weight: bold;\">WHERE<\/span>  df_pod <span style=\"color: #cc0099;\">=<\/span> :orderId\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_niederlas<br>\n              <span style=\"color: #cc0099;\">||<\/span> \u201a<span style=\"color: #cc0099;\">-<\/span>\u201a\n              <span style=\"color: #cc0099;\">||<\/span> df_datauftannahme\n              <span style=\"color: #cc0099;\">||<\/span> \u201a<span style=\"color: #cc0099;\">-<\/span>\u201a\n              <span style=\"color: #cc0099;\">||<\/span> df_lfdnrauftrag <span style=\"color: #cc0099;\">=<\/span> :orderNumber\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_niederlas <span style=\"font-size: 1em; color: #cc0099;\">=<\/span><span style=\"font-size: 1em; color: var( --e-global-color-9e50276 );\"> \u201acas\u2018<\/span><br><span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_pod_reference <span style=\"color: #cc0099; font-weight: bold;\">IS<\/span> <span style=\"color: #9900ff; font-weight: bold;\">NULL<\/span>\n<span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_auftrags_status <span style=\"font-size: 1em; color: #990099; font-weight: bold;\">IN<\/span> <span style=\"font-size: 1em; color: #ff00ff;\">(<\/span><span style=\"font-size: 1em; color: #008080;\">3<\/span><span style=\"font-size: 1em; color: #000033;\">,<\/span><span style=\"font-size: 1em; color: #008080;\">1<\/span><span style=\"font-size: 1em; color: #ff00ff;\">)<\/span><br><span style=\"color: #cc0099; font-weight: bold;\">AND<\/span>    df_empfstat   <span style=\"color: #990099; font-weight: bold;\">IN<\/span> <span style=\"color: #ff00ff;\">(<\/span>\u201ar01\u2018<span style=\"color: #000033;\">,<\/span>\n                         \u201ar03\u2018<span style=\"color: #ff00ff;\">)<\/span>\u201cUPDATEORDERITEMSTATEMENTS: <span style=\"color: #ff00ff;\">[<\/span><span style=\"color: #ff00ff;\">]<\/span><\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a91c5f6 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"a91c5f6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a451ec4 elementor-widget elementor-widget-text-editor\" data-id=\"a451ec4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"p1\"><span class=\"s1\">Bsp \u201eOrderItemUpdateStatement\u201c<\/span><\/p><p class=\"p1\"><span class=\"s1\">Kann frei formuliert und genutzt werden, um ein UPDATE oder INSERT Statement auszuf\u00fchren. Beispielsweise, um den Bestand eines Artikels oder den Versandstatus zu aktualisieren.<\/span><\/p><p class=\"p1\"><span class=\"s1\">Beispielkonfiguration SQLShipper innerhalb BarcodeShippings:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f6057e3 elementor-widget elementor-widget-text-editor\" data-id=\"f6057e3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<pre class=\"mysql\" style=\"font-family: monospace;\"><span style=\"color: #990099; font-weight: bold;\">UPDATE<\/span> kbestellpositionen\n<span style=\"color: #990099; font-weight: bold;\">SET<\/span>    shipped_qantity <span style=\"color: #cc0099;\">=<\/span> :item.quantitycomplete\n<span style=\"color: #990099; font-weight: bold;\">WHERE<\/span>  bestellpost_id <span style=\"color: #cc0099;\">=<\/span> :item.id<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>SQL Shipper SQLShipper \u2013 BarcodeShipping mit Datenbank Direktanbindung Sie wollen f\u00fcr den Versand Waren und Paketen keine extra Text-, CSV-, XML- oder \u00e4hnliche Dateischnittstelle f\u00fcr Ihre propriet\u00e4re ERP- oder Versand-Software teuer programmieren lassen? Dann haben wir die ideale L\u00f6sung f\u00fcr Sie, mit der Sie jede beliebige Datenbank an unsere Versandl\u00f6sung f\u00fcr Ihren (Online-)Shop zwecks automatisiertem [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-152","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Home - SQL Shipper<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlshipper.com\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Home - SQL Shipper\" \/>\n<meta property=\"og:description\" content=\"SQL Shipper SQLShipper \u2013 BarcodeShipping mit Datenbank Direktanbindung Sie wollen f\u00fcr den Versand Waren und Paketen keine extra Text-, CSV-, XML- oder \u00e4hnliche Dateischnittstelle f\u00fcr Ihre propriet\u00e4re ERP- oder Versand-Software teuer programmieren lassen? Dann haben wir die ideale L\u00f6sung f\u00fcr Sie, mit der Sie jede beliebige Datenbank an unsere Versandl\u00f6sung f\u00fcr Ihren (Online-)Shop zwecks automatisiertem [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlshipper.com\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Shipper\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-18T09:59:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2196\" \/>\n\t<meta property=\"og:image:height\" content=\"1851\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"6\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/\",\"url\":\"https:\\\/\\\/sqlshipper.com\\\/\",\"name\":\"Home - SQL Shipper\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlshipper.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Tablelle-1024x863.png\",\"datePublished\":\"2022-09-27T10:06:24+00:00\",\"dateModified\":\"2024-11-18T09:59:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlshipper.com\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlshipper.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Tablelle.png\",\"contentUrl\":\"https:\\\/\\\/sqlshipper.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Tablelle.png\",\"width\":2196,\"height\":1851},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/sqlshipper.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Home\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlshipper.com\\\/#website\",\"url\":\"https:\\\/\\\/sqlshipper.com\\\/\",\"name\":\"SQL Shipper\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlshipper.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Home - SQL Shipper","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sqlshipper.com\/","og_locale":"de_DE","og_type":"article","og_title":"Home - SQL Shipper","og_description":"SQL Shipper SQLShipper \u2013 BarcodeShipping mit Datenbank Direktanbindung Sie wollen f\u00fcr den Versand Waren und Paketen keine extra Text-, CSV-, XML- oder \u00e4hnliche Dateischnittstelle f\u00fcr Ihre propriet\u00e4re ERP- oder Versand-Software teuer programmieren lassen? Dann haben wir die ideale L\u00f6sung f\u00fcr Sie, mit der Sie jede beliebige Datenbank an unsere Versandl\u00f6sung f\u00fcr Ihren (Online-)Shop zwecks automatisiertem [&hellip;]","og_url":"https:\/\/sqlshipper.com\/","og_site_name":"SQL Shipper","article_modified_time":"2024-11-18T09:59:25+00:00","og_image":[{"width":2196,"height":1851,"url":"https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"6\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sqlshipper.com\/","url":"https:\/\/sqlshipper.com\/","name":"Home - SQL Shipper","isPartOf":{"@id":"https:\/\/sqlshipper.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlshipper.com\/#primaryimage"},"image":{"@id":"https:\/\/sqlshipper.com\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle-1024x863.png","datePublished":"2022-09-27T10:06:24+00:00","dateModified":"2024-11-18T09:59:25+00:00","breadcrumb":{"@id":"https:\/\/sqlshipper.com\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlshipper.com\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/sqlshipper.com\/#primaryimage","url":"https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle.png","contentUrl":"https:\/\/sqlshipper.com\/wp-content\/uploads\/2022\/06\/Tablelle.png","width":2196,"height":1851},{"@type":"BreadcrumbList","@id":"https:\/\/sqlshipper.com\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/sqlshipper.com\/"},{"@type":"ListItem","position":2,"name":"Home"}]},{"@type":"WebSite","@id":"https:\/\/sqlshipper.com\/#website","url":"https:\/\/sqlshipper.com\/","name":"SQL Shipper","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlshipper.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"}]}},"_links":{"self":[{"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/pages\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/comments?post=152"}],"version-history":[{"count":92,"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/pages\/152\/revisions"}],"predecessor-version":[{"id":1011,"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/pages\/152\/revisions\/1011"}],"wp:attachment":[{"href":"https:\/\/sqlshipper.com\/index.php\/wp-json\/wp\/v2\/media?parent=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}