Forum Replies Created

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter bastienkoert

    (@bastienkoert)

    thanks, that did it.

    Can i suggest maybe a trim() on those two fields to prevent similar situations in the future?

    Thanks,

    Bastien

    Thread Starter bastienkoert

    (@bastienkoert)

    Would you like access to the backend?

    Thread Starter bastienkoert

    (@bastienkoert)

    in live or staging?

    live setings

    {
        "now": {
            "version": "2.0",
            "mode": "now",
            "title": "",
            "skip_empty_file": true,
            "log_results": false,
            "from_status": [],
            "to_status": [],
            "change_order_status_to": "",
            "statuses": [
                "wc-pending",
                "wc-processing",
                "wc-on-hold",
                "wc-completed"
            ],
            "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": "XML",
            "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_remove_emojis": "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": "UTF-8",
            "format_csv_delete_linebreaks": "0",
            "format_csv_remove_linebreaks": "0",
            "format_csv_force_quotes": "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": "item",
            "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_json_encode_unicode": 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",
            "round_item_tax_rate": "0",
            "cleanup_phone": "0",
            "convert_serialized_values": "0",
            "enable_debug": "0",
            "billing_details_for_shipping": "0",
            "custom_php": "1",
            "custom_php_code": "",
            "mark_exported_orders": "1",
            "export_unmarked_orders": "1",
            "summary_report_by_products": "0",
            "duplicated_fields_settings": [],
            "summary_report_by_customers": "0",
            "order_fields": [
                {
                    "segment": "common",
                    "key": "order_number",
                    "label": "Order Number",
                    "format": "string",
                    "colname": "order_number"
                },
                {
                    "segment": "common",
                    "key": "order_status",
                    "label": "Order Status",
                    "format": "string",
                    "colname": "order_status"
                },
                {
                    "segment": "common",
                    "key": "order_date",
                    "label": "Order Date",
                    "format": "date",
                    "colname": "order_date"
                },
                {
                    "segment": "ship_calc",
                    "key": "order_shipping",
                    "label": "Order Shipping Amount",
                    "format": "money",
                    "colname": "order_shipping"
                },
                {
                    "segment": "totals",
                    "key": "order_total",
                    "label": "Order Total Amount",
                    "format": "money",
                    "colname": "order_total"
                },
                {
                    "segment": "totals",
                    "key": "plain_orders__purchase_order_number",
                    "label": "_purchase_order_number",
                    "format": "string",
                    "colname": "po_number"
                },
                {
                    "segment": "misc",
                    "key": "_shipping_trading_partner_code",
                    "label": "_shipping_trading_partner_code",
                    "format": "string",
                    "colname": "csi_code"
                },
                {
                    "segment": "products",
                    "key": "products",
                    "label": "Products",
                    "format": "undefined",
                    "colname": "items"
                },
                {
                    "segment": "coupons",
                    "key": "coupons",
                    "label": "Coupons",
                    "format": "undefined",
                    "colname": "coupons"
                },
                {
                    "segment": "shipping",
                    "key": "plain_orders_shipping_phone_number",
                    "label": "shipping_phone_number",
                    "format": "string",
                    "colname": "shipping_telephone"
                }
            ],
            "order_product_fields": [
                {
                    "label": "SKU",
                    "key": "sku",
                    "segment": "products",
                    "format": "string",
                    "colname": "sku"
                },
                {
                    "label": "Item Name",
                    "key": "name",
                    "segment": "products",
                    "format": "string",
                    "colname": "name"
                },
                {
                    "label": "Quantity",
                    "key": "qty",
                    "segment": "products",
                    "format": "number",
                    "colname": "qty"
                },
                {
                    "label": "Item Cost",
                    "key": "item_price",
                    "segment": "products",
                    "format": "money",
                    "colname": "price"
                },
                {
                    "label": "box_size",
                    "key": "box_size",
                    "segment": "products",
                    "format": "string",
                    "colname": "box_size"
                },
                {
                    "label": "Item Discount Amount",
                    "key": "discount_amount",
                    "segment": "products",
                    "format": "money",
                    "colname": "item_discount"
                }
            ],
            "order_coupon_fields": [
                {
                    "label": "Coupon Code",
                    "key": "code",
                    "segment": "coupons",
                    "format": "string",
                    "colname": "code"
                }
            ],
            "id": 0,
            "post_type": "shop_order",
            "export_rule_field": "date",
            "export_filename": "850_EXT.xml",
            "summary_row_title": "Total"
        },
        "profiles": [],
        "cron": [],
        "order-action": []
    }
    Thread Starter bastienkoert

    (@bastienkoert)

    Just to let you know this works in our staging environment with the same settings

    Thread Starter bastienkoert

    (@bastienkoert)

    <?xml version=”1.0″ encoding=”UTF-8″?>
    <orders>
    </orders>

    is all that appears. no JS console errors.

    I was getting an error about not being able to read the traits file

    [Tue Jun 14 15:16:56.386556 2022] [proxy_fcgi:error] [pid 10386:tid 140453500393216] [client 76.64.206.160:58238] AH01071: Got error 'PHP message: PHP Warning: include(classes/admin/tabs/ajax/trait-wc-order-export-ajax-helpers.php): failed to open stream: No such file or directory in /var/www/vhosts/shopjetersystems.com/httpdocs/wp-content/plugins/woo-order-export-lite/woo-order-export-lite.php on line 65PHP message: PHP Warning: include(classes/admin/tabs/ajax/trait-wc-order-export-ajax-helpers.php): failed to open stream: No such file or directory in /var/www/vhosts/shopjetersystems.com/httpdocs/wp-content/plugins/woo-order-export-lite/woo-order-export-lite.php on line 65PHP message: PHP Warning: include(): Failed opening 'classes/admin/tabs/ajax/trait-wc-order-export-ajax-helpers.php' for inclusion (include_path='.:/opt/plesk/php/7.4/share/pear') in /var/www/vhosts/shopjetersystems.com/httpdocs/wp-content/plugins/woo-order-export-lite/woo-order-export-lite.php on line 65PHP message: PHP Fatal error: Trait 'WC_Order_Export_Ajax_Helpers' not found in /var/www/vhosts/shopjetersystems.com/httpdocs/wp-content/plugins/woo-order-export-lite/classes/admin/tabs/ajax/trait-wc-order-export-admin-tab-abstract-ajax-export.php on line 6', referer: https://shopjetersystems.com/

    But i dont see that anymore. The only other error is this one
    [Tue Jun 14 16:43:14.881954 2022] [proxy_fcgi:error] [pid 21446:tid 140453627664128] [client 67.213.92.222:54402] AH01071: Got error ‘PHP message: billing_email was called incorrectly. Order properties should not be accessed directly. Backtrace: do_action(‘wp_ajax_getswp’), WP_Hook->do_action, WP_Hook->apply_filters, getswp, WC_Abstract_Legacy_Order->__get, wc_doing_it_wrong. This message was added in version 3.0.’, referer: https://shopjetersystems.com/

    Thread Starter bastienkoert

    (@bastienkoert)

    no results after changing it to xls from xml

    Thread Starter bastienkoert

    (@bastienkoert)

    Hi

    We did try the debug option, it provided no output. There was nothing in the wc logs

    Thanks,

    Bastien

    Thread Starter bastienkoert

    (@bastienkoert)

    Placed the code in the plugin’s main file. This now works

    • This reply was modified 8 years, 8 months ago by bastienkoert. Reason: resolved
Viewing 8 replies - 1 through 8 (of 8 total)