Skip to main content

Datenexport aus WooCommerce

By 13. Januar 2021Februar 15th, 2023Knowledge 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: Datenbank für Last Mile Informationen

| Featured, Knowledge Base, Tutorials | No Comments
Last Mile Informationen in Connect-Transport 💡  Bei der Datenbank für „Last Mile Informationen" handelt es sich um ein Zusatzmodul. Dieses muss für Ihre Disposition eingerichtet…

Tutorial: Multi-Tour View

| Connect-Transport, Featured, Knowledge Base, Tutorials | No Comments
Aktualisiert mit Version 13.1.2   Der Multi-Tour View Hinweis: Der "Multi-Tour-View" ist ein Zusatzmodul und muss für Ihre Disposition freigeschaltet werden. Wenden Sie sich hierzu…

Datenexport aus WooCommerce

| 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…