Show data on product loop woocommerce

add_action( 'woocommerce_after_shop_loop_item', 'wc_shop_page_product_date', 100 );
function wc_shop_page_product_date() {
$single_product_obj = get_wc_product_appointment( $single_product->post->ID );
echo '<span class="product">AVAILABLE at: ' . get_wc_product_appointment('d-m-Y', $single_product->post->ID) . '</span>';
}

Click to expand...

get_wc_product_appointment

Click to expand...

-<wpml-config>
-<custom-types>
<custom-type translate="0">wc_appointment</custom-type>
</custom-types>
-<custom-fields>
<custom-field action="copy">_wc_appointment_availability</custom-field>
<custom-field action="copy">_wc_appointment_availability_autoselect</custom-field>
<custom-field action="copy">_wc_appointment_availability_span</custom-field>
<custom-field action="copy">_wc_appointment_cal_color</custom-field>
<custom-field action="copy">_wc_appointment_cancel_limit</custom-field>
<custom-field action="copy">_wc_appointment_cancel_limit_unit</custom-field>
<custom-field action="copy">_wc_appointment_duration</custom-field>
<custom-field action="copy">_wc_appointment_duration_unit</custom-field>
<custom-field action="copy">_wc_appointment_has_price_label</custom-field>
<custom-field action="translate">_wc_appointment_price_label</custom-field>
<custom-field action="copy">_wc_appointment_has_pricing</custom-field>
<custom-field action="copy">_wc_appointment_interval</custom-field>
<custom-field action="copy">_wc_appointment_interval_unit</custom-field>
<custom-field action="copy">_wc_appointment_max_date</custom-field>
<custom-field action="copy">_wc_appointment_max_date_unit</custom-field>
<custom-field action="copy">_wc_appointment_min_date</custom-field>
<custom-field action="copy">_wc_appointment_min_date_unit</custom-field>
<custom-field action="copy">_wc_appointment_padding_duration</custom-field>
<custom-field action="copy">_wc_appointment_padding_duration_unit</custom-field>
<custom-field action="translate">_wc_appointment_price_label</custom-field>
<custom-field action="copy">_wc_appointment_pricing</custom-field>
<custom-field action="copy">_wc_appointment_has_restricted_days</custom-field>
<custom-field action="copy">_wc_appointment_restricted_days</custom-field>
<custom-field action="copy">_wc_appointment_qty</custom-field>
<custom-field action="copy">_wc_appointment_qty_min</custom-field>
<custom-field action="copy">_wc_appointment_qty_max</custom-field>
<custom-field action="copy">_wc_appointment_requires_confirmation</custom-field>
<custom-field action="copy">_wc_appointment_staff_assignment</custom-field>
<custom-field action="translate">_wc_appointment_staff_label</custom-field>
<custom-field action="copy">_wc_appointment_user_can_cancel</custom-field>
<custom-field action="copy">_wc_appointment_customer_timezones</custom-field>
</custom-fields>
</wpml-config>

Click to expand...

https://babiato.tech/resources/bookingwp-woocommerce-appointments.6106/updates

Click to expand...

Knights said:

This should help point you in the right direction. Set your priority to ''1'' and Available = ''yes''. This will display the next available date on your product on the shop page and is pulled from the Custom Availability tab from your database.

I tried this with ''WHERE appointable = yes'' within the $wpdb->prepare, but for some reason the array wouldn't work. I didn't have time to dig further into it. You might also want to use the code for a specific product.

Code:

global $product;
if ( $product->get_id() != 1514 ) {
 
// rest of code etc.
 
}

You can edit and change to meet your needs:

Code:

// Add Availability to Product
add_action( 'woocommerce_after_shop_loop_item', 'show_next_availability_wc_appointments', 5 );
 
    function show_next_availability_wc_appointments() {
    if ( ! defined( 'ABSPATH' ) ) {
        exit; // Exit if accessed directly
    }
 
    global $product, $wpdb;
    
    $product_id = $product->get_id();
 
    //echo $product_id;
 
    $current_date = date("Y-m-j");
    $date1 = new DateTime('today');
 
    //echo $current_date;
 
    $result = $wpdb->get_results(
        $wpdb->prepare(
            "SELECT * FROM {$wpdb->prefix}wc_appointments_availability WHERE priority=1 AND kind_id = %d ORDER BY `from_range` ASC LIMIT 10", $product_id        )
    );
 
    $resultTable = [];
 
    foreach ($result as $terms) {
        array_push($resultTable, $terms->from_range, 'from_range');
    }
 
    // print_r($resultTable);
 
    $resultTable = array_filter($resultTable,function($date){
    return strtotime($date) >= strtotime('today');
    });
 
    if (!$resultTable) {
        // echo '<span class="product">No Dates Available</span><p></p>';
    } else {
        echo '<span class="product">Available at: ' . array_values($resultTable)[0] . '</span><p></p>';
    }
 
    // print_r($resultTable);
}

Click to expand...

@media only screen and (max-width: 400px) {
.woocommerce ul.products {
margin-left: -10px;
margin-right: -80%;
}
@media only screen and (max-width: 400px) {
.woocommerce ul.products:not(.slick-slider) {
display: list-item;
flex-wrap: wrap;
overflow: scroll;
}

Click to expand...