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:
