Carl M.

It seems to have worked. I was able to export all the orders with nothing missing. Thank you so much!

{
"now": {
"version": "2.0",
"mode": "now",
"title": "",
"skip_empty_file": true,
"log_results": false,
"from_status": [],
"to_status": [],
"change_order_status_to": "",
"statuses": [],
"from_date": "2020-05-01",
"to_date": "2020-06-05",
"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": "XLS",
"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": "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_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": "0",
"skip_refunded_items": "1",
"skip_suborders": "0",
"export_refunds": "0",
"export_matched_items": "0",
"date_format": "Y-m-d",
"time_format": "H:i",
"sort_direction": "DESC",
"sort": "_shipping_postcode",
"format_number_fields": "0",
"export_all_comments": "0",
"export_refund_notes": "0",
"strip_tags_product_fields": "0",
"strip_html_tags": "0",
"round_item_tax_rate": "0",
"cleanup_phone": "0",
"convert_serialized_values": "0",
"enable_debug": "0",
"billing_details_for_shipping": "0",
"custom_php": "0",
"custom_php_code": "",
"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": "1",
"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": "common",
"key": "customer_note",
"label": "Customer Note",
"format": "string",
"colname": "Customer Note"
},
{
"segment": "billing",
"key": "billing_first_name",
"label": "First Name (Billing)",
"format": "string",
"colname": "First Name (Billing)"
},
{
"segment": "billing",
"key": "billing_last_name",
"label": "Last Name (Billing)",
"format": "string",
"colname": "Last Name (Billing)"
},
{
"segment": "billing",
"key": "billing_company",
"label": "Company (Billing)",
"format": "string",
"colname": "Company (Billing)"
},
{
"segment": "billing",
"key": "billing_address",
"label": "Address 1&2 (Billing)",
"format": "string",
"colname": "Address 1&2 (Billing)"
},
{
"segment": "billing",
"key": "billing_city",
"label": "City (Billing)",
"format": "string",
"colname": "City (Billing)"
},
{
"segment": "billing",
"key": "billing_state",
"label": "State Code (Billing)",
"format": "string",
"colname": "State Code (Billing)"
},
{
"segment": "billing",
"key": "billing_postcode",
"label": "Postcode (Billing)",
"format": "string",
"colname": "Postcode (Billing)"
},
{
"segment": "billing",
"key": "billing_country",
"label": "Country Code (Billing)",
"format": "string",
"colname": "Country Code (Billing)"
},
{
"segment": "billing",
"key": "billing_email",
"label": "Email (Billing)",
"format": "string",
"colname": "Email (Billing)"
},
{
"segment": "billing",
"key": "billing_phone",
"label": "Phone (Billing)",
"format": "string",
"colname": "Phone (Billing)"
},
{
"segment": "shipping",
"key": "shipping_first_name",
"label": "First Name (Shipping)",
"format": "string",
"colname": "First Name (Shipping)"
},
{
"segment": "shipping",
"key": "shipping_last_name",
"label": "Last Name (Shipping)",
"format": "string",
"colname": "Last Name (Shipping)"
},
{
"segment": "shipping",
"key": "shipping_address",
"label": "Address 1&2 (Shipping)",
"format": "string",
"colname": "Address 1&2 (Shipping)"
},
{
"segment": "shipping",
"key": "shipping_city",
"label": "City (Shipping)",
"format": "string",
"colname": "City (Shipping)"
},
{
"segment": "shipping",
"key": "shipping_state",
"label": "State Code (Shipping)",
"format": "string",
"colname": "State Code (Shipping)"
},
{
"segment": "shipping",
"key": "shipping_postcode",
"label": "Postcode (Shipping)",
"format": "string",
"colname": "Postcode (Shipping)"
},
{
"segment": "shipping",
"key": "shipping_country",
"label": "Country Code (Shipping)",
"format": "string",
"colname": "Country Code (Shipping)"
},
{
"segment": "cart",
"key": "payment_method_title",
"label": "Payment Method Title",
"format": "string",
"colname": "Payment Method Title"
},
{
"segment": "cart",
"key": "cart_discount",
"label": "Cart Discount Amount",
"format": "money",
"colname": "Cart Discount Amount"
},
{
"segment": "cart",
"key": "order_subtotal",
"label": "Order Subtotal Amount",
"format": "money",
"colname": "Order Subtotal Amount"
},
{
"segment": "ship_calc",
"key": "shipping_method_title",
"label": "Shipping Method Title",
"format": "string",
"colname": "Shipping Method Title"
},
{
"segment": "ship_calc",
"key": "order_shipping",
"label": "Order Shipping Amount",
"format": "money",
"colname": "Order Shipping Amount"
},
{
"segment": "totals",
"key": "order_refund",
"label": "Order Refund Amount",
"format": "money",
"colname": "Order Refund Amount"
},
{
"segment": "totals",
"key": "order_total",
"label": "Order Total Amount",
"format": "money",
"colname": "Order Total Amount"
},
{
"segment": "totals",
"key": "order_total_tax",
"label": "Order Total Tax Amount",
"format": "money",
"colname": "Order Total Tax Amount"
},
{
"segment": "products",
"key": "products",
"colname": "Products",
"label": "Products",
"format": "undefined"
},
{
"segment": "products",
"key": "plain_products_sku",
"label": "SKU",
"format": "string",
"colname": "SKU"
},
{
"segment": "products",
"key": "plain_products_line_id",
"label": "Item #",
"format": "number",
"colname": "Item #"
},
{
"segment": "products",
"key": "plain_products_name",
"label": "Item Name",
"format": "string",
"colname": "Item Name"
},
{
"segment": "products",
"key": "plain_products_qty",
"label": "Quantity",
"format": "number",
"colname": "Quantity"
},
{
"segment": "products",
"key": "plain_products_item_price",
"label": "Item Cost",
"format": "money",
"colname": "Item Cost"
},
{
"segment": "coupons",
"key": "coupons",
"colname": "Coupons",
"label": "Coupons",
"format": "undefined"
},
{
"segment": "coupons",
"key": "plain_coupons_code",
"label": "Coupon Code",
"format": "string",
"colname": "Coupon Code"
},
{
"segment": "coupons",
"key": "plain_coupons_discount_amount",
"label": "Discount Amount",
"format": "money",
"colname": "Discount Amount"
},
{
"segment": "coupons",
"key": "plain_coupons_discount_amount_tax",
"label": "Discount Amount Tax",
"format": "money",
"colname": "Discount Amount Tax"
},
{
"segment": "user",
"key": "summary_report_total_count",
"label": "Summary Report Total Orders",
"format": "number",
"colname": "Summary Report Total Orders"
},
{
"segment": "user",
"key": "summary_report_total_count_items",
"label": "Summary Report Total Items",
"format": "number",
"colname": "Summary Report Total Items"
},
{
"segment": "user",
"key": "summary_report_total_count_items_exported",
"label": "Summary Report Total Items (Exported)",
"format": "number",
"colname": "Summary Report Total Items (Exported)"
},
{
"segment": "user",
"key": "summary_report_total_amount",
"label": "Summary Report Total Amount",
"format": "money",
"colname": "Summary Report Total Amount"
},
{
"segment": "user",
"key": "summary_report_total_amount_paid",
"label": "Summary Report Total Amount Paid",
"format": "money",
"colname": "Summary Report Total Amount Paid"
},
{
"segment": "user",
"key": "summary_report_total_shipping",
"label": "Summary Report Total Shipping",
"format": "money",
"colname": "Summary Report Total Shipping"
},
{
"segment": "user",
"key": "summary_report_total_discount",
"label": "Summary Report Total Discount",
"format": "money",
"colname": "Summary Report Total Discount"
},
{
"segment": "user",
"key": "summary_report_total_refund_count",
"label": "Summary Report Total Refunds",
"format": "number",
"colname": "Summary Report Total Refunds"
},
{
"segment": "user",
"key": "summary_report_total_refund_amount",
"label": "Summary Report Total Refund Amount",
"format": "money",
"colname": "Summary Report Total Refund Amount"
}
],
"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": 0,
"post_type": "shop_order",
"export_rule_field": "date",
"export_filename": "orders-%y-%m-%d-%h-%i-%s.xlsx",
"summary_row_title": "Total"
},
"profiles": [],
"cron": [],
"order-action": []
}

Hi @algolplus, thanks for responding

Here you go, I’m exporting order via woocommerce orders

Hi, despite implementing the database cleanup we are still getting failed orders due to no customer found after stripe account change.. Please advise as this is a very bad experience for our customers.

Hi,

Thanks for getting back to me

Here’s one error log from stripe logs, hope this is sufficient

2024-04-19T01:55:28+00:00 Debug ====Stripe Version: 8.2.0==== ====Stripe Plugin API Version: 2019-09-09==== ====Start Log==== Error: stdClass Object ( [error] => stdClass Object ( [code] => resource_missing [doc_url] => https://stripe.com/docs/error-codes/resource-missing [message] => No such customer: 'cus_OQh8Of7PhU6S20' [param] => customer [request_log_url] => https://dashboard.stripe.com/logs/req_pheqlwbjT8Yh7N?t=1713491728 [type] => invalid_request_error ) )

The error log above was triggered today. Do you think this is adviseable?

https://woocommerce.com/document/stripe/customization/database-cleanup/

This happened after changing a stripe account.

Hi @waseem_senjer,

Which version will work of the paid plugin is sufficient? Pro? or Pro Label?

• This reply was modified 8 months, 1 week ago by Carl M..

Thanks for getting back to @waseem, so to confirm we need the pro version so order sync up to AUST POST account?

Hi @khungate,

I have enabled remote diagnostics – the URL is

https://paddock2porch.com.au/

Hi,

Thanks for getting back to me. I just got back from a holiday break.

Anyways, I’d love to get this sorted out

So I tried resyncing it again but it seems to be stuck in syncing for about an hour now.

See here: https://prnt.sc/KvFTbc5vwMqR what should I do if this is still stuck?

Please advise.

• This reply was modified 10 months, 3 weeks ago by Carl M..

Thanks for the tip @darren

I got it sorted out ?? Appreciate the response

Hi @shameem

Thanks for responding back. Appreciate it.

I can confirm that the card is still active and not expired and is present in Braintree vault, and customer is still using the same payment method in their account in our site.

So it seems to be an issue with the tokenization process? how do we resolve that?

To confirm, how many characters is set for the payment token? 8 characters of 15?

Hi! You are correct. I’m in the wrong plugin forum. My apologies. Have a great day ??

@witcher83

I have disabled and deleted the plugin and it seems the hook is still recurring in action scheduler.

What’s happening here?

Hi @witcher83

Thanks, I had to clear like 1.7m entries of ywctm_update_callback that was bloating up our database.

I did update the plugin to the latest version but it seems its keeps adding entries into the database.

Please advise

Hi @wpo365

Thanks for getting back to me quickly. Sorry for the confusion! Yes, that’s what I need to know. I thought website domain is of importance when setting it up.

Thank you!

Note: only secondarydomain.com email is hosted in microsoft.