Philip Rosing

@cybr Thank you so much!
I was sure there must be some reason it wouldn’t “work”.

Cheers!

@rmitch3012 my bad, it was the wrong version i uploaded. I have updated the repo.
In version 1.1.0 you don’t have to do anything

OR you can keep the one you have now, version 1.0.0, and add this code to your functions.php:

add_filter( 'wfobp_filter_post_types', function( $post_types ) {
    return ['product', 'product_variation']
} );

@americanknight I added a modified version in the comment above this one

@89garvhf23 @rmitch3012
https://github.com/VoroDk/wc-filter-orders-by-product-and-variations

@89garvhf23 I removed the comment because i found a mistake in my own code, but there is also an error in the plugin where it shows orders that doesn’t have the selected product. So i decided to investigate that first.
I think i will make my own plugin based on this one, where i fix the issue i found and add the variation part. I will message you here in the weekend where i have time.

There was an error in the code. I’ll jus review it and get back

• This reply was modified 3 years, 8 months ago by Philip Rosing. Reason: Error in code

Hi @kowsar89,

Would you reconsider implementing a filter?
I made this, where all you have to do is change 2-3 lines in the Filter_By_Product class.

$status    = apply_filters( 'wfobp_product_status', 'publish' );
		$post_type = apply_filters('wfobp_product_filter_product_variation', false);
		$sql       = "SELECT ID,post_title FROM $wpdb->posts WHERE ";
		$sql      .= ! $post_type ? "post_type = 'product'" : "(post_type = 'product' OR post_type = 'product_variation')";
		$sql      .= ( $status == 'any' ) ? '' : " AND post_status = '$status'";
		$all_posts = $wpdb->get_results( $sql, ARRAY_A );

And users can add the filter add_filter( 'wfobp_product_filter_product_variation', '__return_true' );

Great plugin!

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

Hi @marcods,
In your database, in the options table, the plugin creates 2 rows one named woocommerce_facebookcommerce_settings and the other facebook_config.

You can delete those and re-activate the plugin.