Problem: If you're trying to activate Multicurrency in WooCommerce with the WPML plugin and encounter a WordPress database error stating 'Unknown column 'posts.ID'', this issue typically arises when the SQL query fails to correctly join tables in the database. Solution: We recommend modifying the SQL query used by WooCommerce Multilingual. Here's how you can do it: 1. Navigate to
public function filter_dashboard_status_widget_sales_query( $query ) {
$currency = $this->woocommerce_wpml->multi_currency->admin_currency_selector->get_cookie_dashboard_currency();
if ( isset( $query["select"] ) && ( ( strpos( $query["select"], "SELECT COUNT" ) !== false ) || ( strpos( $query["select"], "SELECT SUM" ) !== false ) ) ) {
$query['join'] .= " INNER JOIN {$this->wpdb->postmeta} AS currency_postmeta ON posts.ID = currency_postmeta.post_id";
} else {
$query['join'] .= " INNER JOIN {$this->wpdb->postmeta} AS currency_postmeta ON orders.ID = currency_postmeta.post_id";
}
$query['where'] .= $this->wpdb->prepare( " AND currency_postmeta.meta_key = '_order_currency' AND currency_postmeta.meta_value = %s", $currency );
return $query;
}
}
This modification should resolve the error. Please note that this solution will be included in a future release of the WCML plugin.
If this solution does not apply to your situation, 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. If the issue persists, please open a new support ticket.
Problem:
I duplicated my products from a secondary language, this works great. But how do I duplicate the attributes of this products, so they appear also in this secondary language and not in my default language. Solution:
we do not recommend duplicating from a secondary language, as this might cause unpredictable issues in the synchronization between languages.
This doesn't mean it is not possible, but rather tricky.
But if this didn't solve the issue with attributes duplication, I would recommend duplicating the content from the default language > Translate that duplication
PS : If you are using the Advanced Translation Editor, you won't have to translate it from scratch, as this editor contains “translation memory” that saves your previous translations in a given language. Relevant Documentation:
