Themespress - Plugins, tutoriels et ressources WordPress

Bilingual WordPress Tutorials and Resources

Posted on 28 February 2016 by Daniel

Founded in Trois-Rivières, Quebec, Canada by a team of WordPress developers, themespress.ca is a website with various WordPress tutorials, plugins and resources. We will help you understand the core of

B2B PayTerm for WooCommerce – Deferred Payments for WooCommerce

Posted on 25 August 2026 by Themespress

Deferred payments on WooCommerce: Your business customers don’t pay the same way as individual consumers. In B2B commerce, paying by credit card at the time of order is not the

Plugin TBLC – Broken link checker WordPress

Posted on 20 August 2026 by Themespress

Broken Link Checker WordPress : Simplify Your Link Checks with Themespress Broken Link Checker Links that no longer work can quickly hurt the overall quality of a website. A deleted

ThemesPress Query For Woocommerce

Posted on 19 August 2026 by Themespress

Advanced WooCommerce Search Filter: Modern, Fast, and Elegant Search Finding the right product quickly can make all the difference in an online store. ThemesPress Query for WooCommerce was designed to

Add an audio version to your WordPress posts

Posted on 11 August 2026 by Themespress

Add an audio version to your WordPress posts: The way people consume content online is evolving. Some visitors prefer to read an article at their own pace, while others appreciate

Afficher le total des produits WooCommerce

function mon_site_afficher_total_produits() {
	if ( ! post_type_exists( 'product' ) ) {
		return '';
	}

	$product_counts = wp_count_posts( 'product' );
	$total_products = isset( $product_counts->publish ) ? (int) $product_counts->publish : 0;

	return esc_html( number_format_i18n( $total_products ) );
}
add_shortcode( 'total_produits', 'mon_site_afficher_total_produits' );

Rapport CA 3 Dernières Années – Dashboard WP

// 1. Ajouter un widget personnalisé au tableau de bord WordPress
add_action( 'wp_dashboard_setup', 'ajouter_widget_statistiques_3_ans' );

function ajouter_widget_statistiques_3_ans() {
    wp_add_dashboard_widget(
        'statistiques_ventes_3_ans',
        '📊 Bilan des Ventes (3 Dernières Années)',
        'afficher_contenu_widget_statistiques'
    );
}

// 2. Requête SQL directe et affichage des résultats
function afficher_contenu_widget_statistiques() {
    global $wpdb;

    $annee_actuelle = (int) date( 'Y' );
    $annee_depart   = $annee_actuelle - 2; // Inclus l'année en cours + les 2 précédentes

    // Requête SQL compatible avec les tables WooCommerce modernes (HPOS) et classiques (wp_posts)
    $sql = "
        SELECT 
            YEAR(p.post_date) AS annee,
            COUNT(p.ID) AS total_commandes,
            SUM(pm.meta_value) AS chiffre_affaires
        FROM {$wpdb->posts} p
        INNER JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id
        WHERE p.post_type = 'shop_order'
          AND p.post_status IN ('wc-completed', 'wc-processing')
          AND pm.meta_key = '_order_total'
          AND YEAR(p.post_date) >= %d
        GROUP BY YEAR(p.post_date)
        ORDER BY annee DESC
    ";

    $resultats = $wpdb->get_results( $wpdb->prepare( $sql, $annee_depart ) );

    if ( empty( $resultats ) ) {
        echo '<p>Aucune commande terminée ou en cours de traitement trouvée pour ces 3 dernières années.</p>';
        return;
    }

    echo '<table style="width:100%; border-collapse: collapse; text-align: left;">';
    echo '<tr style="border-bottom: 2px solid #ccc; font-weight: bold;">
            <th style="padding: 8px;">Année</th>
            <th style="padding: 8px;">Commandes</th>
            <th style="padding: 8px;">Total CA</th>
          </tr>';

    foreach ( $resultats as $ligne ) {
        echo '<tr style="border-bottom: 1px solid #eee;">';
        echo '<style>td { padding: 8px; }</style>';
        echo '<td><strong>' . esc_html( $ligne->annee ) . '</strong></td>';
        echo '<td>' . esc_html( number_format_i18n( $ligne->total_commandes ) ) . '</td>';
        echo '<td>' . wc_price( $ligne->chiffre_affaires ) . '</td>';
        echo '</tr>';
    }

    echo '</table>';
}

Définir un montant minimum de commande obligatoire

// 1. Afficher l'avertissement sur la page panier et le checkout
add_action( 'woocommerce_before_cart', 'afficher_notice_montant_minimum' );
add_action( 'woocommerce_checkout_process', 'afficher_notice_montant_minimum' );

function afficher_notice_montant_minimum() {
    $minimum = 100; // Montant minimum requis
    
    if ( WC()->cart->subtotal < $minimum ) {
        $message = sprintf( 
            'Le montant minimum de commande est de %s. Votre sous-total actuel est de %s.', 
            wc_price( $minimum ), 
            wc_price( WC()->cart->subtotal ) 
        );

        if ( is_cart() ) {
            wc_print_notice( $message, 'error' );
        } else {
            wc_add_notice( $message, 'error' );
        }
    }
}

// 2. Retirer le bouton "Commander" de la page panier sous le seuil
add_action( 'woocommerce_proceed_to_checkout', 'masquer_bouton_commander_si_seuil_non_atteint', 1 );

function masquer_bouton_commander_si_seuil_non_atteint() {
    $minimum = 100; // Montant minimum requis
    
    if ( WC()->cart->subtotal < $minimum ) {
        // Supprime l'action par défaut qui affiche le bouton "Valider la commande"
        remove_action( 'woocommerce_proceed_to_checkout', 'woocommerce_button_proceed_to_checkout', 20 );
    }
}