[Resolved] Error while geting product variations

Hello again,

At first the update didn't solve the problem.

About the third answer you gave, we have to say that we are only querying the default language products (Greek) so we don't export their translation. So in the lines of our custom code that we have shared in the foreach loop we get only the default variation ID. We can understand that you can not provide support for custom coding problems, but the function we are using to get the variation based on its ID is a woocommerce function that is working properly for simple and variable products. Only in product variations we get this problem.

We don't want to do the export with a plugin, because we want to export the product attributes and the free versions of export plugins do not provide that or if any of them provides it they only export simple products. That is why we came up with a custom code solution to export products in a csv file using simple PHP and woocommerce integrated functions. As you can see, we are not in need of any plugin.

Thanks!

We have added the content in the demo site as it is in our e-shop. We can not add custom coding because we need access to public_html folder.

The way we are trying to export the products is by creating a file export-products.php in the public_html folder and we run it in the frontend. Please provide us with access to this filder or add this lines to a file in public_html flder.

require_once($_SERVER['DOCUMENT_ROOT'].'/wp-load.php'); //to be able to use woocommerce functions

//get only greek published products
global $sitepress;
$sitepress->switch_lang('el');

$products = get_posts( array(
'post_type' => 'product',
'numberposts' => -1,
'post_status' => 'publish',
'suppress_filters' => false
));

foreach($products as $product){
$newProduct = wc_get_product($product->ID);

if($newProduct->get_type() == 'variable'){
$variationsIDs = $newProduct->get_children();

foreach($variationsIDs as $variationID){
$variation = new WC_Product_Variation($variationID); //this is were the problem
occurs so the var_dump is not showing anything
var_dump($variation);
}
}
}

The above code is supposed to return each variation as a product object.

Thanks!

Well, we deactivated WPML Multilingual CMS and the export worked just fine. We used the code below to export the variations.

$products = get_posts( array(
'post_type' => 'product',
'numberposts' => -1,
'post_status' => 'publish',
));

foreach($products as $product){
$newProduct = wc_get_product($product->ID);

if($newProduct->get_type() == 'variable'){
$variationsIDs = $newProduct->get_children();

foreach($variationsIDs as $variationID){
$variation = new WC_Product_Variation($variationID);
var_dump($variation);
}
}
}

So it is not a problem with the custom code. The problem is caused because of your plugin. We want to know why the plugin is not allowing product variations to be exported manually with code. Also as we asked before what is the meaning of this error

WCML_WC_Strings->translated_attribute_label('\xCE\x97\xCE\xBB\xCE\xB9\xCE\xBA\xCE\xAF\xCE\xB1', 'pa_ilikia', Object(WC_Product_Variation)).

We will try to create a demo site. We will need some time to do this since it is a verry big site.

Hello again,

the demo site is ready. Can you activate a private answer to send you the credentials?

Thanks!