Plugin woocommerce wp adverts , return only paid adverts in query

Hi, i am afraid this might not be possible to do as the the Ad itself does not have any meta data indicating that it as posted using premium ads.

One thing you can try is to transition post status, see the code below

function on_publish_wc_pending_post( $post ) {
    add_post_meta( $post->ID, "premium", 1 );
}
add_action(  'wc_pending_to_publish',  'on_publish_wc_pending_post', 10, 1 );

This should be fired when Ad is changing its status from wc_pending to publish (basically when payment is accepted or when admin approves the payment) and it adds ‘premium’ meta field to the post.

You can check if this will appear in wp_postmeta table when you approve and Ad, if it does then you should be able to query paid posts with

'key' => 'premium',
'value' => 1

problem is i have 3 paid adverts:

1) Premium – 7 days advert show
2) Gold – 14 days show
and Last) Company – 28 days advert show

I want to select for WP_QUERY only paid ads Company on the left of the grid, also want to select the ads paid Premium and Gold on the grill above.
With this code I think it does not filter the various types of paid ads .

And in what file i can add that code?

function on_publish_wc_pending_post( $post ) {
    add_post_meta( $post->ID, "premium", 1 );
}
add_action(  'wc_pending_to_publish',  'on_publish_wc_pending_post', 10, 1 );

The code i pasted will add “premium” meta value if post required payment using WooCommerce, it is however not possible with this filter to tell what pricing was used.

The code you can add in your theme functions.php