Export not generating data
-
Hi,
When running the exporter, i can’t get any data out of the system. This was working in staging and we tested it when going live. I know there are new sales in the WC that haven’t been exported yet.
Can you let me know what tables are used to store the .’mark as exported’ data? Then i can check the records to see if there are no records that need exporting. Also is there a way to see what filters are running in the SQL or via the interface to see what other items might be factors in not getting data?
Thanks,
Bastien Koert
-
Hi Bastien
We add new record to wp_postmeta, meta_key = woe_order_exported.
Please, open section “Misc Settings”, mark “Enable debug output” and press Preview.
Hi
We did try the debug option, it provided no output. There was nothing in the wc logs
Thanks,
Bastien
Could you please switch format to XLS and press Preview?
no results after changing it to xls from xml
What do you see when you press Preview?
Please, use browser to check JS errors too.
Short guide – https://www.ads-software.com/support/article/using-your-browser-to-diagnose-javascript-errors/#step-3-diagnosis<?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/Please, submit your settings as new ticekt to https://algolplus.freshdesk.com/
Use tab Tools to get them
Just to let you know this works in our staging environment with the same settings
Ok.
What do you see when you press Preview?
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": [] }Would you like access to the backend?
Yes, everything is ok with settings.
What do you see when you press Preview ?
For XML format.My bad, the settings is NOT ok.
Please, go to section “Orders Range” and remove space in each field.
thanks, that did it.
Can i suggest maybe a trim() on those two fields to prevent similar situations in the future?
Thanks,
Bastien
yes, we did it just now ??
- The topic ‘Export not generating data’ is closed to new replies.
