dnex11

By default the checkout/order-received/ page shows the order number in woocommerce.
In case of this plugin it somehow hides that order number. After selecting the currency we are redirected to order-received page.

• This reply was modified 1 year, 8 months ago by dnex11.

You mean like this

SELECT * FROMwp_optionsWHEREoption_nameLIKE '%woocommerce_stripe_%_settings%'

Will deleting these do.

View post on imgur.com

• This reply was modified 3 years, 8 months ago by dnex11.
• This reply was modified 3 years, 8 months ago by dnex11.

I tried this in misc

add_filter( 'woe_order_export_started',  function ( $order_id ) { 
  $order = new WC_Order($order_id);
  return   ($order->get_comments()) ? $order_id: false;
});

I get this error

Fatal error: Uncaught Error: Call to undefined method WC_Order::get_comments() in C:\xampp\htdocs\wp1\wp-content\plugins\woo-order-export-lite\classes\core\class-wc-order-export-engine.php(345) : eval()'d code:4 Stack trace: #0 C:\xampp\htdocs\wp1\wp-includes\class-wp-hook.php(292): WC_Order_Export_Engine::{closure}('233426') #1 C:\xampp\htdocs\wp1\wp-includes\plugin.php(212): WP_Hook->apply_filters('233426', Array) #2 C:\xampp\htdocs\wp1\wp-content\plugins\woo-order-export-lite\classes\core\class-wc-order-export-engine.php(479): apply_filters('woe_order_expor...', '233426') #3 C:\xampp\htdocs\wp1\wp-content\plugins\woo-order-export-lite\classes\admin\tabs\ajax\trait-wc-order-export-admin-tab-abstract-ajax-export.php(25): WC_Order_Export_Engine::build_file(Array, 'preview', 'browser', 0, '5') #4 C:\xampp\htdocs\wp1\wp-content\plugins\woo-order-export-lite\classes\class-wc-order-export-admin.php(511): WC_Order_Export_Admin_Tab_Abstract->ajax_preview() #5 C:\xampp\htdocs\wp1\wp-includes\class-wp-hook.php(292): WC_Order_Expo in C:\xampp\htdocs\wp1\wp-content\plugins\woo-order-export-lite\classes\core\class-wc-order-export-engine.php(345) : eval()'d code on line 4

• This reply was modified 3 years, 9 months ago by dnex11.

Great. Thank you , its a very good plugin.

• This reply was modified 3 years, 9 months ago by dnex11.

thanks

Last question.
There is an option to export Order Note field. Is there a way to export Order Note date which is the comment_date column in wp_comments table.
Cant find it in commentmeta

• This reply was modified 3 years, 9 months ago by dnex11.
• This reply was modified 3 years, 9 months ago by dnex11.

Thanks

exported orders moved to trash using this code

add_action('woe_order_exported', function ($order_id) {
    $order = new WC_Order($order_id);
    $order->update_status('trash', 'Exported !');
} );

Can you do this with query

UPDATE wp_posts SET post_status = 'trash' FROM wp_posts as p JOIN
wp_postmeta as pm ON p.ID = pm.post_id
WHERE pm.meta_key = 'woe_order_exported'

• This reply was modified 3 years, 9 months ago by dnex11.
• This reply was modified 3 years, 9 months ago by dnex11.

Thanks, seems to work.

Is it possible to trash or delete the exported orders through this plugin or another method.

So which tables do I have to look up in this case I am using woocommerce 4.x but the database exists since 3.x version. I am trying to retrieve order id, customer name, email, product name, payment method, amount.

• This reply was modified 3 years, 9 months ago by dnex11.