Datenexport aus WooCommerce

Sie nutzen das beliebte E-Commerce Plug-In WooCommerce, um die Aufträge Ihrer Kunden in einem Onlineshop zu erfassen? Diese Aufträge können Sie ganz einfach in Connect-Transport einspielen, um mithilfe unserer Routenoptimierung für optimal geplante Touren zu sorgen.

Export der Aufträge aus WooCommerce

Das WordPress Plug-In Advanced Order Export for WooCommerce installieren. Dieses Plug-In erlaubt den Export der Aufträge aus WooCommerce.
Die Einstellungen für den Export der Aufträge finden sich unter dem Punkt Bestellungen exportieren.
Die Einstellungen für den Export im Connect-Transport Format können über eine Vorlage gesetzt werden. Dazu befindet sich unter dem Reiter Werkzeuge das Feld Importeinstellungen. Kopieren Sie den folgenden Code und fügen Sie ihn dort ein.

Aufklappen und Text kopieren

{
"version": "2.0",
"mode": "cron",
"title": "Connect-Transport Upload",
"skip_empty_file": "on",
"log_results": "",
"from_status": [],
"to_status": [],
"change_order_status_to": "",
"statuses": [],
"from_date": "",
"to_date": "",
"sub_start_from_date": "",
"sub_start_to_date": "",
"sub_end_from_date": "",
"sub_end_to_date": "",
"sub_next_paym_from_date": "",
"sub_next_paym_to_date": "",
"from_order_id": "",
"to_order_id": "",
"shipping_locations": [],
"shipping_methods": [],
"item_names": [],
"item_metadata": [],
"user_roles": [],
"user_names": [],
"user_custom_fields": [],
"billing_locations": [],
"payment_methods": [],
"any_coupon_used": "0",
"coupons": [],
"order_custom_fields": [],
"product_categories": [],
"product_vendors": [],
"products": [],
"product_sku": "",
"exclude_products": [],
"product_taxonomies": [],
"product_custom_fields": [],
"product_attributes": [],
"product_itemmeta": [],
"format": "CSV",
"format_xls_use_xls_format": "0",
"format_xls_sheet_name": "Orders",
"format_xls_display_column_names": "1",
"format_xls_auto_width": "1",
"format_xls_direction_rtl": "0",
"format_xls_force_general_format": "0",
"format_xls_row_images_width": "50",
"format_xls_row_images_height": "50",
"format_csv_enclosure": "\"",
"format_csv_delimiter": "|",
"format_csv_linebreak": "\\r\\n",
"format_csv_display_column_names": "1",
"format_csv_add_utf8_bom": "0",
"format_csv_item_rows_start_from_new_line": "0",
"format_csv_encoding": "iso8859-15",
"format_csv_delete_linebreaks": "0",
"format_tsv_linebreak": "\\r\\n",
"format_tsv_display_column_names": "1",
"format_tsv_add_utf8_bom": "0",
"format_tsv_item_rows_start_from_new_line": "0",
"format_tsv_encoding": "UTF-8",
"format_xml_root_tag": "Orders",
"format_xml_order_tag": "Order",
"format_xml_product_tag": "Product",
"format_xml_coupon_tag": "Coupon",
"format_xml_prepend_raw_xml": "",
"format_xml_append_raw_xml": "",
"format_xml_self_closing_tags": "1",
"format_xml_preview_format": "0",
"format_json_start_tag": "[",
"format_json_end_tag": "]",
"format_json_unescaped_slashes": 0,
"format_json_numeric_check": 0,
"format_pdf_display_column_names": "1",
"format_pdf_repeat_header": "1",
"format_pdf_direction_rtl": 0,
"format_pdf_orientation": "L",
"format_pdf_page_size": "A4",
"format_pdf_font_size": "8",
"format_pdf_header_text": "",
"format_pdf_footer_text": "",
"format_pdf_pagination": "C",
"format_pdf_fit_page_width": "0",
"format_pdf_cols_width": "25",
"format_pdf_cols_align": "L",
"format_pdf_cols_vertical_align": "T",
"format_pdf_page_header_text_color": "#000000",
"format_pdf_page_footer_text_color": "#000000",
"format_pdf_table_header_text_color": "#000000",
"format_pdf_table_header_background_color": "#FFFFFF",
"format_pdf_table_row_text_color": "#000000",
"format_pdf_table_row_background_color": "#FFFFFF",
"format_pdf_logo_source_id": "0",
"format_pdf_logo_source": "",
"format_pdf_logo_width": "0",
"format_pdf_logo_height": "15",
"format_pdf_logo_align": "R",
"format_pdf_row_images_width": "15",
"format_pdf_row_images_height": "15",
"format_pdf_row_images_add_link": "0",
"format_pdf_row_dont_page_break_order_lines": "0",
"format_html_display_column_names": "1",
"format_html_repeat_header_last_line": "0",
"format_html_font_size": "13",
"format_html_header_text": "",
"format_html_footer_text": "",
"format_html_cols_align": "L",
"format_html_header_text_color": "#000000",
"format_html_footer_text_color": "#000000",
"format_html_table_header_text_color": "#000000",
"format_html_table_header_background_color": "#FFFFFF",
"format_html_table_row_text_color": "#000000",
"format_html_table_row_background_color": "#FFFFFF",
"format_html_row_images_width": "100",
"format_html_row_images_height": "100",
"format_html_images_add_link": "0",
"format_html_custom_css": "",
"all_products_from_order": "1",
"skip_refunded_items": "0",
"skip_suborders": "0",
"export_refunds": "0",
"export_matched_items": "0",
"date_format": "Y-m-d",
"time_format": "H:i",
"sort_direction": "DESC",
"sort": "order_id",
"format_number_fields": "0",
"export_all_comments": "0",
"export_refund_notes": "0",
"strip_tags_product_fields": "0",
"cleanup_phone": "0",
"convert_serialized_values": "0",
"enable_debug": "0",
"billing_details_for_shipping": "0",
"custom_php": "1",
"custom_php_code": "add_filter(\u0027woe_get_order_value_order_datum\u0027,function ($value, $order,$fieldname) {\r\n$value = substr($order->{\u0027date_created\u0027},0,10);\r\n return $value.\"_Verladung\";\r\n},10,3);",
"mark_exported_orders": "0",
"export_unmarked_orders": "0",
"summary_report_by_products": "0",
"duplicated_fields_settings": {
"products": {
"repeat": "rows",
"populate_other_columns": "1",
"max_cols": "10",
"group_by": "product",
"line_delimiter": "\\n"
},
"coupons": {
"repeat": "rows",
"max_cols": "10",
"group_by": "product",
"line_delimiter": "\\n"
}
},
"summary_report_by_customers": "0",
"export_rule_field": "modified",
"order_fields": [
{
"segment": "common",
"key": "plain_orders_order_datum",
"label": "order_datum",
"format": "string",
"colname": "TOUR_NAME"
},
{
"segment": "common",
"key": "order_id",
"label": "Order ID",
"format": "number",
"colname": "ORDER_KEY"
},
{
"segment": "billing",
"key": "billing_full_name",
"label": "Full Name (Billing)",
"format": "string",
"colname": "NAME"
},
{
"segment": "billing",
"key": "billing_address_1",
"label": "Address 1 (Billing)",
"format": "string",
"colname": "ADDRESS_STREET"
},
{
"segment": "billing",
"key": "billing_address_2",
"label": "Address 2 (Billing)",
"format": "string",
"colname": "ADDRESS_ADDITIONAL"
},
{
"segment": "billing",
"key": "billing_postcode",
"label": "Postcode (Billing)",
"format": "string",
"colname": "ADDRESS_POSTCODE"
},
{
"segment": "billing",
"key": "billing_city",
"label": "City (Billing)",
"format": "string",
"colname": "ADDRESS_CITY"
},
{
"segment": "billing",
"key": "billing_country",
"label": "Country Code (Billing)",
"format": "string",
"colname": "ADDRESS_COUNTRYCODE"
},
{
"segment": "shipping",
"key": "static_field_2",
"label": "ADDRESS_ONE_STRING",
"format": "string",
"colname": "ADDRESS_ONE_STRING",
"value": ""
},
{
"segment": "billing",
"key": "billing_phone",
"label": "Phone (Billing)",
"format": "string",
"colname": "PHONE"
},
{
"segment": "billing",
"key": "billing_email",
"label": "Email (Billing)",
"format": "string",
"colname": "EMAIL"
},
{
"segment": "common",
"key": "customer_note",
"label": "Customer Note",
"format": "string",
"colname": "ORDER_REMARK"
},
{
"segment": "common",
"key": "order_notes",
"label": "Order Notes",
"format": "string",
"colname": "ORDER_DESCRIPTION"
},
{
"segment": "common",
"key": "static_field_3",
"label": "ORDER_WEIGHT",
"format": "string",
"colname": "ORDER_WEIGHT",
"value": ""
},
{
"segment": "common",
"key": "static_field_4",
"label": "ORDER_TYPE",
"format": "number",
"colname": "ORDER_TYPE",
"value": "20"
},
{
"segment": "common",
"key": "static_field_5",
"label": "ORDER_TIME_EARLIEST",
"format": "string",
"colname": "ORDER_TIME_EARLIEST",
"value": ""
},
{
"segment": "common",
"key": "static_field_6",
"label": "ORDER_TIME_LATEST",
"format": "string",
"colname": "ORDER_TIME_LATEST",
"value": ""
},
{
"segment": "common",
"key": "static_field_7",
"label": "ORDER_SERVICE_TIME",
"format": "string",
"colname": "ORDER_SERVICE_TIME",
"value": ""
},
{
"segment": "products",
"key": "products",
"colname": "Products",
"label": "Products",
"format": "undefined"
},
{
"segment": "products",
"key": "plain_products_static_field_8",
"label": "ITEM_WEIGHT",
"format": "undefined",
"colname": "ITEM_WEIGHT",
"value": " "
},
{
"segment": "products",
"key": "plain_products_item_id",
"label": "Item ID",
"format": "number",
"colname": "ITEM_BARCODE"
},
{
"segment": "products",
"key": "plain_products_name",
"label": "Item Name",
"format": "string",
"colname": "ITEM_DESCRIPTION"
},
{
"segment": "coupons",
"key": "coupons",
"colname": "Coupons",
"label": "Coupons",
"format": "undefined"
}
],
"order_product_fields": [
{
"label": "SKU",
"format": "string",
"colname": "SKU",
"default": 1,
"key": "sku"
},
{
"label": "Item #",
"format": "number",
"colname": "Item #",
"default": 1,
"key": "line_id"
},
{
"label": "Item Name",
"format": "string",
"colname": "Item Name",
"default": 1,
"key": "name"
},
{
"label": "Quantity",
"format": "number",
"colname": "Quantity",
"default": 1,
"key": "qty"
},
{
"label": "Item Cost",
"format": "money",
"colname": "Item Cost",
"default": 1,
"key": "item_price"
}
],
"order_coupon_fields": [
{
"label": "Coupon Code",
"format": "string",
"colname": "Coupon Code",
"default": 1,
"key": "code"
},
{
"label": "Discount Amount",
"format": "money",
"colname": "Discount Amount",
"default": 1,
"key": "discount_amount"
},
{
"label": "Discount Amount Tax",
"format": "money",
"colname": "Discount Amount Tax",
"default": 1,
"key": "discount_amount_tax"
}
],
"id": 1,
"post_type": "shop_order",
"schedule": {
"type": "schedule-2",
"interval": "wp_1_wc_regenerate_images_cron_interval",
"custom_interval": "",
"times": "",
"date_times": "",
"last_run": 1602512151,
"last_report_sent": 1602512151,
"next_run": 1602512451
},
"export_rule": "none",
"export_rule_custom": "3",
"export_filename": "orders-%y-%m-%d-%h-%i-%s.csv",
"destination": {
"type": [
"email",
"http"
],
"email_from": "",
"email_from_name": "",
"email_subject": "TEST",
"email_body": "",
"email_recipients": "IHREEMAIL@bizapp.de",
"email_recipients_cc": "",
"email_recipients_bcc": "",
"ftp_server": "",
"ftp_port": "",
"ftp_user": "",
"ftp_pass": "",
"ftp_path": "",
"ftp_conn_timeout": "",
"ftp_max_retries": "",
"sftp_server": "",
"sftp_port": "",
"sftp_user": "",
"sftp_pass": "",
"sftp_private_key_path": "",
"sftp_path": "",
"sftp_conn_timeout": "",
"sftp_max_retries": "",
"http_post_url": "",
"http_post_conn_timeout": "",
"http_post_max_retries": "",
"path": "",
"zapier_export_order_product_columns": "10",
"zapier_export_order_coupon_columns": "10"
}
}

Unter Verschiedene Einstellungen müssen noch folgende Anpassungen für den Export gemacht werden. (Nachfolgenden Code kopieren und entsprechend einfügen).

Aufklappen und Text kopieren

add_filter('woe_get_order_value_order_datum',function ($value, $order,$fieldname) {
$value = substr($order->{'date_created'},0,10);
return $value;
},10,3);

In der „Pro“ Version des Plug-Ins können die Exporte auch in geplanten Zeitabständen und automatisiert per E-Mail an Connect-Transport übermittelt werden.

Zeitfenster importieren

Sollen Zeitfenster bei der Tourenplanung in Connect-Transport berücksichtigt werden, installieren Sie zusätzlich das Plug-In Delivery & Pickup Date Time für WooCommerce.
In der Konfiguration des Plugins werden Start, Ende und Größe der Lieferzeitfenster definiert, aus denen Kunden schließlich wählen können.

Mehr Tutorials:

Tutorial: LIFO Tourenplanung

| Connect-Transport, Featured, Knowledge Base, Tutorials | No Comments
Auswahl der Ladestrategie Mit Version 9.6.0 können Sie in der Tourenplanung einstellen, welche "Ladestrategie" der Algorithmus bei der Tourenplanung berücksichtigen soll. In bestimmten Szenarien kann…

Fehlende Orte und Adressen auf Google Maps

| Featured, Knowledge Base, Tutorials | No Comments
Fehlenden Ort auf Google Maps hinzufügen Fehlende Orte können auf Google wie folgt hinzugefügt werden: https://www.google.de/maps > Menüsymbol > Fehlenden Ort hinzufügen Korrekturen des Kartenmaterials…

Konfiguration: Mobile Scanner und Smartphones

| Alle Downloads, Connect-Transport, Featured, Hardware, Knowledge Base, Quick Start Guides, Tutorials | No Comments
Hier können Sie das fertig konfigurierte DataWedge Profil für Ihren Zebra Scanner (z.B. TC26 oder TC25) herunterladen. Beachten Sie die Hinweise in dieser Anleitung, um…

Tutorial: Tourenliste sortieren

| Featured, Tutorials | No Comments
Sortierung der Tourenliste Die Anzeige der Tourenliste kann sortiert werden, damit Sie immer die nötige Übersicht bei der Disposition behalten. Gleich unterhalb des Tour-Filters befinden…