delacour.corp

Ok problem found and solved, I thought I shouldn’t deactivate the woocommerce dependent plugins for the tests, deactivated them ALL including woocommerce B2B which was the guilty with its latest update.

Well, only the by price / ascending is a problem, in fact, as the by price / descending is correct… sooo weird.

Here is the System status log (and nothing in the error log) :

### WordPress Environment ###

WordPress address (URL): https://www.fakefurshop.com
Site address (URL): https://www.fakefurshop.com
WC Version: 6.6.1
REST API Version: ? 6.6.1
WC Blocks Version: ? 7.6.2
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: ? 6.0 - There is a newer version of WordPress available (6.0.1)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.30
PHP Post Max Size: 32 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.15-MariaDB-cll-lve-log
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.6.1
WC Database Prefix: wp_
Total Database Size: 297.82MB
Database Data Size: 231.89MB
Database Index Size: 65.93MB
wp_woocommerce_sessions: Data: 1.36MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 2.52MB + Index: 0.30MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 10.52MB + Index: 8.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 3.48MB + Index: 2.38MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 2.50MB + Index: 3.03MB + Engine InnoDB
wp_commentmeta: Data: 0.42MB + Index: 0.19MB + Engine InnoDB
wp_comments: Data: 4.52MB + Index: 1.53MB + Engine InnoDB
wp_failed_jobs: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_login_security_solution_fail: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailchimp_carts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 8.50MB + Index: 0.69MB + Engine InnoDB
wp_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pmxe_exports: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 139.66MB + Index: 18.06MB + Engine InnoDB
wp_posts: Data: 12.52MB + Index: 6.91MB + Engine InnoDB
wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.20MB + Index: 0.22MB + Engine InnoDB
wp_terms: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_term_taxonomy: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
wp_usermeta: Data: 10.52MB + Index: 9.02MB + Engine InnoDB
wp_users: Data: 1.52MB + Index: 0.72MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.20MB + Index: 0.16MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
wp_wc_order_stats: Data: 0.25MB + Index: 0.20MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.16MB + Index: 0.14MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.38MB + Index: 0.55MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfConfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileMods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfHits: Data: 2.17MB + Index: 0.22MB + Engine InnoDB
wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfIssues: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_wfKnownFileList: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfLogins: Data: 0.41MB + Index: 0.13MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfNotifications: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wfPendingIssues: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfStatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmelon_advbedit_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_campaign: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_campaign_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_custom_field: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_email: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wysija_email_user_stat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_email_user_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wysija_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wysija_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_url_mail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_user: Data: 0.14MB + Index: 0.05MB + Engine InnoDB
wp_wysija_user_field: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_user_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wysija_user_list: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_yarpp_related_cache: Data: 0.28MB + Index: 0.31MB + Engine InnoDB
wp_yith_wcwl: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_yoast_indexable: Data: 10.52MB + Index: 6.84MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.19MB + Index: 0.25MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.27MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_mi-lite: 3
attachment: 7498
avada_faq: 32
avada_portfolio: 41
fusion_element: 1
nav_menu_item: 50
oembed_cache: 11
page: 29
popup: 1
popup_theme: 6
post: 23
product: 1195
product_variation: 2237
project: 20
revision: 206
shop_coupon: 63
shop_order: 2070
shop_order_refund: 30
shortcoder: 4
slide: 19
testimonial: 3
testimonial_rotator: 1
vc_settings_preset: 3
was: 98
wcb2b_group: 2
wpcf7_contact_form: 1
wphb_minify_group: 8
wysijap: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (33) ###

CAPTCHA 4WP: by WP White Security – 7.1.0
Akismet Anti-Spam: by Automattic – 4.2.4
Code Snippets: by Code Snippets Pro – 3.1.1
Comet Cache: by WP Sharks – 170220
Contact Form 7: by Takayuki Miyoshi – 5.6
Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.3.1
Customer Reviews for WooCommerce: by CusRev – 4.44
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
Avada Builder: by ThemeFusion – 3.6.1
Avada Core: by ThemeFusion – 5.6.1
Mailchimp for WooCommerce: by Mailchimp – 2.6.2
Menu Social Icons: by Paul Clark – 1.3.10
PW WooCommerce Gift Cards: by Pimwick
LLC – 1.211

Really Simple SSL: by Really Simple Plugins – 5.3.2
Shortcoder: by Aakash Chakravarthy – 5.8
Woocommerce Sisow Payment Methods: by Sisow – 5.5.8
SOFT79 Cart Links for WooCommerce: by Soft79 – 1.1.4
Woo Image SEO: by Danail Emandiev – 1.3.0
WooCommerce Advanced Bulk Edit: by George Iron & Yas G. – 5.1
WooCommerce Advanced Shipping: by Jeroen Sormani – 1.1.0
WooCommerce B2B: by Code4Life – 3.0.8
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.11
WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 3.0.0
WooCommerce PDF Invoices & Packing Slips Premium Templates: by Ewout Fernhout – 2.1.7
WooCommerce Shortcodes: by WooThemes
Claudio Sanches – 1.0.0

WooCommerce Stock Synchronization: by Pronamic – 2.1.0
WooCommerce: by Automattic – 6.6.1 (update to version 6.7.0 is available)
Wordfence Security: by Wordfence – 7.5.11
Yoast SEO: by Team Yoast – 19.2
Smush: by WPMU DEV – 3.10.2
Yet Another Related Posts Plugin (YARPP): by YARPP – 5.27.8
YITH WooCommerce Wishlist: by YITH – 3.10.0

### Inactive Plugins (6) ###

Contact Form 7 Captcha: by 247wd – 0.1.2
Themify - WooCommerce Product Filter: by Themify – 1.3.9
WooCommerce No Shipping Message: by dangoodman – 2.0.15
WP All Export Pro: by Soflyy – 1.6.2
WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.2.6
WP All Import Pro: by Soflyy – 4.6.5

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: ?
Force SSL: –
Currency: EUR (€)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
pw gift card (pw-gift-card)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #7 - /shop/
Cart: #8 - /cart/
Checkout: #9 - /checkout/
My account: #10 - /my-account/
Terms and conditions: #4559 - /terms-and-conditions/

### Theme ###

Name: Avada
Version: 7.6.1
Author URL: https://themeforest.net/user/ThemeFusion
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: Avada/woocommerce/cart/cart.php
Avada/woocommerce/checkout/form-pay.php
Avada/woocommerce/checkout/review-order.php
Avada/woocommerce/checkout/thankyou.php
Avada/woocommerce/loop/loop-start.php
Avada/woocommerce/single-product/add-to-cart/variable.php
Avada/woocommerce/single-product/short-description.php
Avada/woocommerce/single-product/tabs/additional-information.php
Avada/woocommerce/single-product/tabs/description.php

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-07-17 07:29:14 +02:00
Options: ?
Notes: 91
Onboarding: completed

### Action Scheduler ###

Canceled: 1
Oldest: 2022-07-12 22:27:50 +0200
Newest: 2022-07-12 22:27:50 +0200

Complete: 9,078
Oldest: 2022-06-15 11:20:10 +0200
Newest: 2022-07-16 10:15:09 +0200

Pending: 1
Oldest: 2022-07-17 06:07:58 +0200
Newest: 2022-07-17 06:07:58 +0200

### Status report information ###

Generated at: 2022-07-16 10:56:03 +02:00

Hi, thanks for the help, I closed the topic by error as I realized I badly described the problem. The point is when watching the linked page, the price sorting from high to low is working well, but once you click on the arrow in order to sort them from low to high (product_order=asc), the listing is messed in kind of a random sorting which seems to be the same as the “sort by date” sorting. So strange that the by price sorting would work in one way but not the other… So that’s my problem…

Thanks for your help, indeed I have that extension, but unfortunately the generated PDF invoice keeps the placeholder contents with its code instead of displaying its data. That would solve my problem so much, so close to a solution !

Of course, I understand, otherwise for other purposes, is it possible to insert order’s related datas via the custom block ? I see there is an option to input text or “custom field” with a “Field name / meta key” field, what kind of data may I use there ? Something like total weight of the order or whatsoever ?

Yes it is, I’d like to add the shipping title of the selected shipping method, but… meanwhile I realize that we are using the plugin Woocommerce Advanced Shipping which may be too specific to get some help (https://codecanyon.net/item/woocommerce-advanced-shipping/8634573)…

Oh @mnelson4, that’s way more than helpful !
Thanks a million as this allows me to fully rely on YARPP + your code snippet to manage my related products basing on teir tags, that’s just huuuuge. Thanks a lot again for taking that time, I’ll implement this asap ??

Yes it is !
I’ve worked on a bit of code I’m already using, that displays only the maximum price in case of variable products and added my price unit there, that makes the job even if this might be improved I guess, as I would prefer a filter on categories, maybe a good starting point…

add_filter( 'woocommerce_variable_sale_price_html', 'con_show_max_variation_price_only', 10, 2 );
add_filter( 'woocommerce_variable_price_html', 'con_show_max_variation_price_only', 10, 2 );
 
function con_show_max_variation_price_only( $price, $product ) {
 
// Main Variation Price
$prices = array( $product->get_variation_price( 'max', true ), $product->get_variation_price( 'min', true ) );
 
$price = $prices[0] !== $prices[1] ? sprintf( __( '%1$s', 'woocommerce' ), wc_price( $prices[0] ) ) : wc_price( $prices[0] );
 
// Sale Variation Price
$prices = array( $product->get_variation_regular_price( 'max', true ), $product->get_variation_regular_price( 'min', true ) );
sort( $prices );
 
$saleprice = $prices[0] !== $prices[1] ? sprintf( __( '%1$s', 'woocommerce' ), wc_price( $prices[0] ) ) : wc_price( $prices[0] );
 
//Output
if ( $price !== $saleprice ) {
    
    $price = '<span style="display:none;">' . $saleprice . '</span> <ins>' . $price . '</ins><span class="woocommerce-Price-amount amount">per meter</span>';
    
    }
    
    return $price;
 
}

Same issue, I’ve tried to “hide” it via CSS…

Solved ! The bug came from the B2B plugin I’m using ;p

Thanks for that prompt answer ! Well after checking, nope, my theme doesn’t overide any email’s template…

And under WooCommerce ? Settings ? Tax Options
Enable tax rates and calculations is checked
Yes, I will enter prices inclusive of tax checked
Display prices in the shop Including tax
Display prices during cart and checkout Including tax
Display tax totals As a single total

No problems found via the Health Check & Troubleshooting plugin… What is weird is just that it -sometimes- happens that only the first line item is displayed without VAT. For the moment I cannot find a way to understand when… If this is not an already known issue I guess I’ll have to wait to see it again to understand better…

Thanks for that quick help, that’s perfect !

I used that plugin a lot and was sorry to see it working less and less despite it was very useful. As it seems not updated anymore, as I did I would advice you to switch from using that plugin to creating variable products for your samples. It’s quite easy to set up once you have made some tests, every variation may have its own caracteristics and price, and this will allow you to let that plugin aside.

I searched A LOT for an alternative, made A LOT of tries to update the code of the plugin, making it work as much as possible, and at the end I don’t have any regret for forgetting that idea and switch to variable products.

Well, you’re right, let’s try this, I’ll see if it works ??

Same question for me, I’m willing to display in Google serach results the total number of ratings and average rating for my homepage, but I am lost in reading things about Google Snippets etc…. If someone can help…

• This reply was modified 5 years, 7 months ago by delacour.corp.