PrestaShop Marketing with Google does not sync all the products

[Jorge Miguel]

Hi all,

 

I'm using PrestaShop Marketing with Google module version 1.61.1 and my store is 8.1.2.

I'm trying to syncronize the catalog to Google Merchant but it's not working  In the end of the configuration it shows 337 produts to be sync, but in Google Merchant only shows 124.

I cannot find a pattern and I was expecting to syncronize all. The issues should be then on Google Merchant. My Google Merchant account it shows now issues to fix.

Is there any way to see the sync errors or report to try to figure it out? Any Idea how to solve it?

I have also deleted the feed and create a new one, uninstall the module and install it again, etc, etcm but no luck so far    

Thank you for any support!

Jorge

[Nickz]

  On 10/19/2023 at 8:49 PM, Jorge Miguel said:

I'm trying to syncronize the catalog to Google Merchant but it's not working  In the end of the configuration it shows 337 produts to be sync, but in Google Merchant only shows 124.

Expand  

Have you put that question before the Google Support forum?
If Google does not accept 50+ % of your products there should be a error file somewhere and I bet its at Googles

[Jorge Miguel]

  On 10/19/2023 at 8:54 PM, Nickz said:

Have you put that question before the Google Support forum?
If Google does not accept 50+ % of your products there should be a error file somewhere and I bet its at Googles

Expand  

Thank you for quick reply.

I will do it, thank you for the tip, but I thought I could understand if the problem is on prestashop side or not.

[Zohaib-fk]

Hi,

You can try my or any other module of Google merchant centre to add all PS products into the merchant centre account.

https://addons.prestashop.com/en/seo-natural-search-engine-optimization/91512-automatic-google-merchant-center-google-shopping.html

[Nickz]

  On 10/19/2023 at 9:06 PM, Jorge Miguel said:

I will do it, thank you for the tip, but I thought I could understand if the problem is on prestashop side or not.

Expand  

What did they say, did you see errors piled up in those error logs?

[@diegofrancesco]

  On 10/19/2023 at 9:06 PM, Jorge Miguel said:

Thank you for quick reply.

I will do it, thank you for the tip, but I thought I could understand if the problem is on prestashop side or not.

Expand  

What is the total number of synchronized products in Feed (in GMC) ?

In Google Merchant Center under Products -> Diagnostics what do you see? Products have an approval problem?

[kamppa]

Same problem here. More than 50 % of products are not synced to Merchant Center. Only products with EAN are synced but the products that do not have EAN are not synced. I would like them to be synced regardless of missing EAN and let Google decide to approve them or not. Now Prestashop makes the decision.

[Nickz]

  On 6/18/2024 at 7:11 PM, kamppa said:

. Only products with EAN are synced but the products that do not have EAN are not synced.

Expand  

you found the solution. Give them EAN Numbers.
Out of curiosity: How good is the merchant center from Google?

[kamppa]

  On 6/18/2024 at 11:28 PM, Nickz said:

you found the solution. Give them EAN Numbers.
Out of curiosity: How good is the merchant center from Google?

Expand  

That is not a solution. Not all the products have EAN and applying for it costs a lot of money and time.

[@diegofrancesco]

  On 6/18/2024 at 7:11 PM, kamppa said:

Same problem here. More than 50 % of products are not synced to Merchant Center. Only products with EAN are synced but the products that do not have EAN are not synced. I would like them to be synced regardless of missing EAN and let Google decide to approve them or not. Now Prestashop makes the decision.

Expand  

You must check if there is an option in the module to force the sending of products without EAN code, via the "identifier_exists" attribute. Which is the system adopted by Google Merchant Center. If you can't find it, try asking the module developer since you probably have an active subscription and support is included. (I use another module for GMC)

Google Merchant Center accepts products without an EAN code but they must have the attribute identifier_exists with a value of no [no] or false [false].

[kamppa]

The official Google Marketing by Prestashop is a free module. There is no setting to send products without EAN.

I switched to using excellent free module Google Shopping Flux which also works with Prestashop 8.1:
https://github.com/d1m007/gshoppingflux

I made minor changes to code so that it works perfectly with Multistore and different currencies. 

 

        // Price(s)
        $currency = new Currency((int) $id_curr);
        $use_tax = ($product['tax_included'] ? true : false);
        $no_tax = (!$use_tax ? true : false);
        $product['price'] = (float) $p->getPriceStatic($product['id_product'], $use_tax, $combination);
        $product['price_without_reduct'] = (float) $p->getPriceWithoutReduct($no_tax, $combination);
        $product['price'] = Tools::ps_round($product['price'], _PS_PRICE_DISPLAY_PRECISION_);
        $product['price_without_reduct'] = Tools::ps_round($product['price_without_reduct'], _PS_PRICE_DISPLAY_PRECISION_);
        if ((float) ($product['price']) < (float) ($product['price_without_reduct'])) {
            $xml_googleshopping .= '<g:price>'.$product['price_without_reduct'].' '.$currency->iso_code.'</g:price>'."\n";
            $xml_googleshopping .= '<g:sale_price>'.$product['price'].' '.$currency->iso_code.'</g:sale_price>'."\n";
        } else {
            $xml_googleshopping .= '<g:price>'.$product['price'].' '.$currency->iso_code.'</g:price>'."\n";
        }

 

 

// Shipping
if ($this->module_conf['shipping_mode'] == 'fixed') {
    $xml_googleshopping .= '<g:shipping>' . "\n";
    $xml_googleshopping .= "\t" . '<g:country>' . $this->module_conf['shipping_country'] . '</g:country>' . "\n";
    $xml_googleshopping .= "\t" . '<g:service>Standard</g:service>' . "\n";
    $xml_googleshopping .= "\t" . '<g:price>' . $this->module_conf['shipping_price'] . ' ' . $this->context->currency->iso_code . '</g:price>' . "\n";
    $xml_googleshopping .= '</g:shipping>' . "\n";
} elseif ($this->module_conf['shipping_mode'] == 'full' && count($this->module_conf['shipping_countries[]'])) {
    $this->id_address_delivery = 0;
    $countries = [];
    if (in_array('all', $this->module_conf['shipping_countries[]'])) {
        $countries = Country::getCountries($this->context->language->id, true);
    } else {
        foreach ($this->module_conf['shipping_countries[]'] as $id_country) {
            $countries[] = (new Country((int)$id_country))->getFields();
        }
    }

 

 

foreach ($countries as $country) {
    $xml_googleshopping .= '<g:shipping>' . "\n";
    $xml_googleshopping .= "\t" . '<g:country>' . $country['iso_code'] . '</g:country>' . "\n";
    $xml_googleshopping .= "\t" . '<g:service>' . $shipping['delay'] . '</g:service>' . "\n";
    $xml_googleshopping .= "\t" . '<g:price>' . $shipping['price'] . ' ' . $this->context->currency->iso_code . '</g:price>' . "\n";
    $xml_googleshopping .= '</g:shipping>' . "\n";
}

            }
        }

 

 

 

 

 

 

 

You can use the same feed.xml with Facebook marketing.

Edited June 19, 2024 by kamppa (see edit history)