$id_categ_parent = $creer['id_parent'];
 if ($id_categ_parent == "1") {
     $id_categ_parent = "0";
 }
 $visible = $creer['active'];
 if ($visible == "0") {
     $id_categ_parent = "1";
 }
 $donnees_creer_category_lang = Db::getInstance()->GetRow("select * from " . $prefix_presta . "category_lang where id_category='" . $id_categ . "' and id_lang='{$lang}'");
 $label_creer_category = $donnees_creer_category_lang['name'];
 $chaine = $label_creer_category;
 $chaine = produits_caract("{$chaine}");
 $label_creer_category = $chaine;
 $description_creer_category = $donnees_creer_category_lang['description'];
 $chaine = $description_creer_category;
 $chaine = produits_caract("{$chaine}");
 $description_creer_category = $chaine;
 $link_rewrite_creer_category = $donnees_creer_category_lang['link_rewrite'];
 mysql_connect("{$serveur_doli}", "{$admin_doli}", "{$mdp_doli}");
 mysql_select_db("{$base_doli}");
 mysql_query("SET NAMES UTF8");
 // RECUPERATION DE LA VERSION DE DOLIBARR **************************************************
 $sql_recup_version_dolibarr = "select * from " . $prefix_doli . "const where name='MAIN_VERSION_LAST_UPGRADE'";
 $result_version_dolibarr = mysql_query($sql_recup_version_dolibarr) or die($sql_recup_version_dolibarr . "<br />\n" . mysql_error());
 $donnees_version_dolibarr = mysql_fetch_array($result_version_dolibarr);
 $version_dolibarr = $donnees_version_dolibarr['value'];
 $version_dolibarr = substr($version_dolibarr, 0, 3);
 if ($version_dolibarr == "") {
     $sql_recup_version_dolibarr = "select * from " . $prefix_doli . "const where name='MAIN_VERSION_LAST_INSTALL'";
     $result_version_dolibarr = mysql_query($sql_recup_version_dolibarr) or die($sql_recup_version_dolibarr . "<br />\n" . mysql_error());
     $donnees_version_dolibarr = mysql_fetch_array($result_version_dolibarr);
function synchroProduct($id_product)
{
    echo "<br/>Synchronize product : {$id_product}<br>";
    $product_description = Configuration::get('product_description');
    $use_barcode = Configuration::get('use_barcode');
    if ($product = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "product where id_product = '" . $id_product . "'")) {
        // retrieve params
        $prefix_ref_product = Configuration::get('prefix_ref_product');
        $prefix_ref_product = accents_sans("{$prefix_ref_product}");
        //retrieve product data
        $prix_produit_normal_HT = $product['price'];
        $active = $product['active'];
        $reference = $product['reference'];
        $reference = produits_caract("{$reference}");
        $en_vente = $product['active'];
        $barcode = $product['ean13'];
        //$datec=$product['date_add'];
        //$tms=$product['date_upd'];
        //$weight=$product['weight'];
        // find tva rate
        $id_tax_rules_group = $product['id_tax_rules_group'];
        //var_dump($id_tax_rules_group);
        $donnees_id_tax_rules_group = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "tax_rule where id_tax_rules_group = '" . $id_tax_rules_group . "'");
        //var_dump($donnees_id_tax_rules_group);
        $id_tax = $donnees_id_tax_rules_group['id_tax'];
        //var_dump($id_tax);
        $donnees_tax = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "tax where id_tax = '" . $id_tax . "'");
        $vat_rate = $donnees_tax['rate'];
        $prix_produit_normal_HT = sprintf("%.5f", $prix_produit_normal_HT);
        //find description
        $product_data = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "product_lang where id_product = '" . $id_product . "' AND id_lang = '" . Context::getContext()->language->id . "'");
        if ($product_description == '0') {
            $description = $product_data['description_short'];
        } else {
            $description = $product_data['description'];
        }
        $label = $product_data['name'];
        // RECUPERATION DES DONNEES DU PRODUIT DANS LA BASE ARTICLES *********************************************
        // RECUPERATION ID IMAGE ****************************************************
        //$donnees_id_image = Db::getInstance()->GetRow("select * from ".$prefix_presta."image where id_product='".$product_id."'");
        //$id_image=$donnees_id_image['id_image'];
        // FIN RECUPERATION ID IMAGE ****************************************************
        $dolibarr = Dolibarr::getInstance();
        $product = new DolibarrProduct();
        $product->ref_ext = $prefix_ref_product . $id_product;
        $product->ref = $reference;
        $product->label = $label;
        $product->description = $description;
        $product->price_net = $prix_produit_normal_HT;
        $product->vat_rate = $vat_rate;
        if ($use_barcode == '1') {
            $product->barcode = $barcode;
            $product->barcode_type = '2';
            // 2 = ean13
        }
        // Check if already exists in Dolibarr
        $exists = $dolibarr->getProduct($prefix_ref_product . $id_product);
        if ($exists["result"]->result_code == 'NOT_FOUND') {
            // Create new product
            echo "Create new product : ";
            $result = $dolibarr->createProduct($product);
            echo $result["result"]->result_code . "<br/>";
            if ($result["result"]->result_code != 'OK') {
                echo "Erreur de synchronisation : " . $result["result"]->result_label;
                echo "<br>product : ";
                var_dump($product);
                echo "<br>result : ";
                var_dump($result);
                return FALSE;
            }
        } else {
            if ($exists["result"]->result_code == 'OK') {
                // Update product
                echo "update product : ";
                $oldProduct = $exists["product"];
                $product->id = $oldProduct->id;
                $result = $dolibarr->updateProduct($product);
                echo $result["result"]->result_code . "<br/>";
                if ($result["result"]->result_code != 'OK') {
                    if (strpos($result["result"]->result_label, 'CONSTRAINT `fk_product_barcode_type') !== FALSE) {
                        echo "Synchronisation Error : Looks like you have enabled barcode in this module but not in your Dolibarr installation.";
                    } else {
                        echo "Erreur de synchronisation : " . $result["result"]->result_label;
                        echo "<br>product : ";
                        var_dump($product);
                        echo "<br>result : ";
                        var_dump($result);
                        return FALSE;
                    }
                }
            } else {
                if (strpos($result["result"]->result_label, 'CONSTRAINT `fk_product_barcode_type') !== FALSE) {
                    echo "Synchronisation Error : Looks like you have enabled barcode in this module but not in your Dolibarr installation.";
                } else {
                    echo "Erreur de synchronisation : " . $result["result"]->result_label;
                    echo "<br>product : ";
                    var_dump($product);
                    echo "<br>result : ";
                    var_dump($result);
                    return FALSE;
                }
            }
        }
    }
    return TRUE;
}