Problem: The client reported inconsistencies in product sorting across different language pages on their WooCommerce site, even after previous code adjustments. Solution: We provided custom code to ensure consistent sorting by date, SKU, price, and popularity across all language versions of the site. Here are the steps we recommended:
//Use the below snippet when sorting by price and popularity, so that SKU is used as the secondary sort option:
add_filter('posts_clauses', 'custom_orderby_with_secondary_sku', 20, 2);
function custom_orderby_with_secondary_sku($clauses, $query) {
if (!is_admin() && $query->is_main_query() && is_woocommerce() && isset($_GET['orderby'])) {
$orderby = $_GET['orderby'];
// Define primary column and direction based on ordering
switch ($orderby) {
case 'price':
$primary_column = 'wc_product_meta_lookup.min_price';
$primary_direction = 'ASC';
break;
case 'price-desc':
$primary_column = 'wc_product_meta_lookup.max_price';
$primary_direction = 'DESC';
break;
case 'popularity':
$primary_column = 'wc_product_meta_lookup.total_sales';
$primary_direction = 'DESC';
break;
default:
return $clauses; // Not a target orderby value, leave alone
}
// Set ORDER BY with SKU as secondary sort
$clauses['orderby'] = "
{$primary_column} {$primary_direction},
wc_product_meta_lookup.sku ASC
";
}
return $clauses;
}
If this solution does not resolve your issue or seems irrelevant due to updates or specific circumstances, we recommend opening a new support ticket. Additionally, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. For further assistance, please visit our support forum at WPML Support Forum.
You are trying to make the product ranking on the English page consistent with the product ranking on the Chinese page. The sorting is consistent on the homepage but varies when selecting a category to view products.
Solution:
To achieve consistent product order across languages, we recommend defining a secondary sorting condition. If sorting by SKU is your preferred method, you can add a custom code snippet to your theme's
functions.php
file. Here is the code you need:
function custom_modify_shop_query($query) {
// Only modify the shop order if an order has not been specified
//if ( !isset($_GET['orderby']) && !is_admin() && $query->is_main_query() && is_shop()) {
if (
!is_admin() &&
$query->is_main_query() &&
(is_shop() || is_product_category() || is_product_tag())
) {
// Set meta_key so SKU ordering works
$query->set('meta_key', '_sku');
// Set orderby to array: first by date, then by SKU
$query->set('orderby', array(
'date' => 'DESC',
'meta_value' => 'ASC',
));
}
}
This code ensures that products are first sorted by date and then by SKU, applying across shop, category, and tag pages. Please check your staging site to confirm the sorting behaves as expected.
If this solution does not resolve your issue or seems outdated, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket at WPML support forum.
Problem: You are trying to synchronize products from an ERP system to your WordPress website and want to add English translations simultaneously to avoid manual translation later. Solution: We recommend using the WordPress REST API in conjunction with WooCommerce Multilingual to automate the process of creating both the original product and its translation. You can find more details on how to implement this here. Please note, this type of custom integration is outside our standard support scope. If you need further assistance, consider reaching out to a WPML-certified developer here.
If this solution does not apply to your case, or if it seems outdated, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. Should you need further assistance, please do not hesitate to open a new support ticket here.
Problem: You are an administrator trying to manage WPML settings on your site but notice that some settings are missing, and you receive a permission error when attempting to translate WooCommerce products. Solution: We recommend you try the following steps to resolve the issue: 1. Add the following code to your active theme's
functions.php
file:
function wpmlsupp_1706_reset_wpml_capabilities() {
if ( function_exists( 'icl_enable_capabilities' ) ) {
icl_enable_capabilities();
}
}
add_action( 'shutdown', 'wpmlsupp_1706_reset_wpml_capabilities' );
2. Open a page in the back and/or front-end once. 3. Remove the code added in step #1.
If the issue persists, it might be helpful to check if this is the first time you have installed WPML on this site or if you already have translated data by WPML.
If this solution does not resolve your issue or seems irrelevant due to being outdated or not applicable to your case, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. Additionally, please feel free to open a new support ticket for further assistance at WPML support forum.
Issue: When you try to translate categories on your site using WPML, you notice that the categories display an incorrect total number of products when you switch to English. Solution: We have found that the problem occurs because the products are not translated, and the default language products are displayed instead. If you wish to use the translated categories/filters, you will need to translate the products.
If this solution is outdated or does not apply to your situation, please visit the Related Known Issues, verify that you have the latest versions of your themes and plugins installed, and check for permanent fixes. If the problem persists, we recommend that you open a new support ticket.
Problem: You are using WPML multilingual on your website and are trying to translate a template, but the template does not show a translation button. Solution: If you're experiencing this issue, we recommend you navigate to WPML > Settings > Post Types Translation section. Here, find the post type "Headers Builder" and set it as "Translatable." It is likely currently marked as "Not translate," which is why the translation options are not visible.
This solution might be irrelevant if it's outdated or not applicable to your case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket at WPML support forum for further assistance.
