Datenexport aus WooCommerce

Von 13. Januar 2021 April 6th, 2021 Connect-Transport, Knowledge Base, Tutorials
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 in der Pro-Version den automatisierten 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: Multi-Tour View

| Connect-Transport, Featured, Knowledge Base, Tutorials | No Comments
Der Multi-Tour View Seit Version 10.8.2 können mehrere Touren in der CT Dispo gleichzeitig dargestellt und bearbeitet werden. Den Multi-Tour View aktivieren Sie mit einem…

Datenexport aus WooCommerce

| Connect-Transport, Knowledge Base, Tutorials | No Comments
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…

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…