[Doesn't round the gross price - mismatch in Google Merchant]

I am facing problems with rejected products by Google Merchant.

There is a mismatch in price due to too long gross price. It should be rounded to maximum 2 decimal places. I import my products with net price. Do I have to change all the prices and settings in the database and end with not rounded net price?

Merchant:

 

 

Back office:

Marta

[google search console - no canonical urls for category pages]

On 3/23/2023 at 2:05 PM, x97wehner said:

I just checked my site and I do not have the same issue. The only setting that I can see different is the last checkbox to disable Apache mod_security. Mine is set to yes. Not sure that this will resolve your issue though.

It didn't I'm afraid.

[google search console - no canonical urls for category pages]

Is there anything I can do to fix this issue?

[google search console - no canonical urls for category pages]

It was enabled.

[google search console - no canonical urls for category pages]

Hi, I 've got a problem with google search console. It warns me that there are no canonical pages set for the following pages (category pages). I have got my urls set to the friendly ones.

Is there anything I can do ?

Thx,

Marta

[database importing product_attribute table - problems with product_default key]

Hello, as my shop is far slower than a toaster I've decided to install it from scratch.

I'm importing tables at the moment and I've got problems with tb_product_attribute. I am getting the following error:

INSERT INTO `tb_product_attribute` VALUES ('76', '451', '67250', '', '0', '5905001672506', '', '0.000000', '114.950000', '0.000000', '0', '0.000000', '0.000000', '0', '1', '0000-00-00');

 

Quote

 

MySQL zwrócił komunikat:

#1062 - Duplicate entry '451-0' for key 'product_default'

 

 

There are 5 attributes for this id_product and only one of them is set to 1 in the default_on field.

MySQL imports only two of them. 😞

 

Is everything all right with the table configuration?

[Warning about homeslider update to 2.1.0]

Thank you very much 🙂

[Warning about homeslider update to 2.1.0]

There is no such a directory. I updated automatically. When I'm trying to upload the images as usual nothing is happening.

And then:

There is no image.

[Warning about homeslider update to 2.1.0]

I can't upload the images. I've altered the homeslider.tpl in the Community Theme Default according to your changes to Niara:

Quote

{if $page_name =='index'}
  {if isset($homeslider_slides)}
    <div id="homepage-slider" class="col-xs-12">
      {if isset($homeslider_slides[0]) && isset($homeslider_slides[0].sizes.1)}{capture name='height'}{$homeslider_slides[0].sizes.1}{/capture}{/if}
      <ul id="homeslider"{if isset($smarty.capture.height) && $smarty.capture.height} style="max-height:{$smarty.capture.height}px;"{/if}>
        {foreach from=$homeslider_slides item=slide}
          {if $slide.active}
            {if isset($slide.imageUrl)}
              {$slideImageUrl = $slide.imageUrl}
            {else}
              {$slideImageUrl = "`$smarty.const._MODULE_DIR_`homeslider/images/`$slide.image`"}
            {/if}
            <li class="homeslider-container">
              <a href="{$slide.url|escape:'html':'UTF-8'}" title="{$slide.legend|escape:'html':'UTF-8'}">
                <img  class="img-responsive"
                       src="{$link->getMediaLink($slideImageUrl)|escape:'htmlall':'UTF-8'}"
                      {if isset($slide.size) && $slide.size} {$slide.size}{/if}
                      alt="{$slide.legend|escape:'htmlall':'UTF-8'}"
                      style="width: 100%; height: 100%"
                >
              </a>
              {if isset($slide.description) && trim($slide.description) != ''}
                <div class="homeslider-wrapper hidden-xs">
                  <div class="homeslider-description">{$slide.description}</div>
                </div>
              {/if}
            </li>
          {/if}
        {/foreach}
      </ul>
      <div id="homeslider-pager">
        <span>{l s='More offers:' mod='homeslider'}</span>
        <span id="homeslider-pages"></span>
      </div>
    </div>
  {/if}
{/if}

 

There is no Homeslider folder in the img folder.

I can see the name of the img file in the database but I can't find the file anywhere 😞

[Coreupdater errors]

Great! I can see the settings. 🙂

[Coreupdater errors]

I am not able to do it because I can't enter the Core updater

When I click "configure" I get the list of errors listed above.

[Coreupdater errors]

The problem still exists. 😞

[Coreupdater errors]

Hello,

When I click on "configure" button in the Coreupdater module on the list of modules in the BO I get the following:

(Thirtybees 1.3)

Quote

GuzzleHttp\Exception\RequestException: cURL error 60: SSL certificate problem: certificate has expired (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) in /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php:201
Stack trace:
#0 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php(155): GuzzleHttp\Handler\CurlFactory::createRejection(Object(GuzzleHttp\Handler\EasyHandle), Array)
#1 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php(105): GuzzleHttp\Handler\CurlFactory::finishError(Object(GuzzleHttp\Handler\CurlHandler), Object(GuzzleHttp\Handler\EasyHandle), Object(GuzzleHttp\Handler\CurlFactory))
#2 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php(43): GuzzleHttp\Handler\CurlFactory::finish(Object(GuzzleHttp\Handler\CurlHandler), Object(GuzzleHttp\Handler\EasyHandle), Object(GuzzleHttp\Handler\CurlFactory))
#3 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(28): GuzzleHttp\Handler\CurlHandler->__invoke(Object(GuzzleHttp\Psr7\Request), Array)
#4 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(51): GuzzleHttp\Handler\Proxy::GuzzleHttp\Handler\{closure}(Object(GuzzleHttp\Psr7\Request), Array)
#5 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php(66): GuzzleHttp\Handler\Proxy::GuzzleHttp\Handler\{closure}(Object(GuzzleHttp\Psr7\Request), Array)
#6 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Middleware.php(29): GuzzleHttp\PrepareBodyMiddleware->__invoke(Object(GuzzleHttp\Psr7\Request), Array)
#7 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php(70): GuzzleHttp\Middleware::GuzzleHttp\{closure}(Object(GuzzleHttp\Psr7\Request), Array)
#8 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Middleware.php(57): GuzzleHttp\RedirectMiddleware->__invoke(Object(GuzzleHttp\Psr7\Request), Array)
#9 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/HandlerStack.php(71): GuzzleHttp\Middleware::GuzzleHttp\{closure}(Object(GuzzleHttp\Psr7\Request), Array)
#10 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Client.php(351): GuzzleHttp\HandlerStack->__invoke(Object(GuzzleHttp\Psr7\Request), Array)
#11 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Client.php(162): GuzzleHttp\Client->transfer(Object(GuzzleHttp\Psr7\Request), Array)
#12 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Client.php(182): GuzzleHttp\Client->requestAsync('post', Object(GuzzleHttp\Psr7\Uri), Array)
#13 /home/users/lampadina/public_html/lampy17/vendor/guzzlehttp/guzzle/src/Client.php(95): GuzzleHttp\Client->request('post', '/coreupdater/v2...', Array)
#14 /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/api/ThirtybeesApiGuzzle.php(252): GuzzleHttp\Client->__call('post', Array)
#15 /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/api/ThirtybeesApiGuzzle.php(239): CoreUpdater\Api\ThirtybeesApiGuzzle->performPost(Array)
#16 /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/api/ThirtybeesApiGuzzle.php(215): CoreUpdater\Api\ThirtybeesApiGuzzle->callApi('check-module-ve...', Array)
#17 /home/users/lampadina/public_html/lampy17/modules/coreupdater/controllers/admin/AdminCoreUpdaterController.php(830): CoreUpdater\Api\ThirtybeesApiGuzzle->checkModuleVersion('1.4.0')
#18 /home/users/lampadina/public_html/lampy17/modules/coreupdater/controllers/admin/AdminCoreUpdaterController.php(328): AdminCoreUpdaterController->checkModuleVersion()
#19 [internal function]: AdminCoreUpdaterController->performInitContent()
#20 /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/ErrorHandler.php(56): call_user_func_array(Array, Array)
#21 /home/users/lampadina/public_html/lampy17/modules/coreupdater/controllers/admin/AdminCoreUpdaterController.php(318): CoreUpdater\ErrorHandler->handleErrors(Array)
#22 /home/users/lampadina/public_html/lampy17/classes/controller/Controller.php(210): AdminCoreUpdaterController->initContent()
#23 /home/users/lampadina/public_html/lampy17/classes/Dispatcher.php(852): ControllerCore->run()
#24 /home/users/lampadina/public_html/lampy17/admin605ombtle/index.php(63): DispatcherCore->dispatch()
#25 {main}

Next CoreUpdater\Api\ThirtybeesApiException: Transport exception in /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/api/ThirtybeesApiGuzzle.php:256
Stack trace:
#0 /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/api/ThirtybeesApiGuzzle.php(239): CoreUpdater\Api\ThirtybeesApiGuzzle->performPost(Array)
#1 /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/api/ThirtybeesApiGuzzle.php(215): CoreUpdater\Api\ThirtybeesApiGuzzle->callApi('check-module-ve...', Array)
#2 /home/users/lampadina/public_html/lampy17/modules/coreupdater/controllers/admin/AdminCoreUpdaterController.php(830): CoreUpdater\Api\ThirtybeesApiGuzzle->checkModuleVersion('1.4.0')
#3 /home/users/lampadina/public_html/lampy17/modules/coreupdater/controllers/admin/AdminCoreUpdaterController.php(328): AdminCoreUpdaterController->checkModuleVersion()
#4 [internal function]: AdminCoreUpdaterController->performInitContent()
#5 /home/users/lampadina/public_html/lampy17/modules/coreupdater/classes/ErrorHandler.php(56): call_user_func_array(Array, Array)
#6 /home/users/lampadina/public_html/lampy17/modules/coreupdater/controllers/admin/AdminCoreUpdaterController.php(318): CoreUpdater\ErrorHandler->handleErrors(Array)
#7 /home/users/lampadina/public_html/lampy17/classes/controller/Controller.php(210): AdminCoreUpdaterController->initContent()
#8 /home/users/lampadina/public_html/lampy17/classes/Dispatcher.php(852): ControllerCore->run()
#9 /home/users/lampadina/public_html/lampy17/admin605ombtle/index.php(63): DispatcherCore->dispatch()

 

I've contacted my hosting crew and they claim that CURL has no problem with my webpage (TLS 1.3/1.2). There  arent' any problems with the certificate. The problem may be with guzzlehttp which uses the old TLS protocol.

Could you help me?

The other issue is that my shop has been running very slowly since the installation and it hasn't been solved.

Thx,

Marta

 

[Email notifications - encoding problem]

I haven't got such problems with my 1.3 Polish version. As soon as I finish updating to 1.4 I'll let you know.

[Layered navigation - very slow category page loading]

Thank you @datakickand @zen for your help. The TB store has been published. 🙂

The shop started to work faster after I had disabled and then enabled the newproducts, featured and bestsellers blocks.

The filtering module by Presteamshop is great, perhaps not perfect but almost there 😉 https://www.lampadina.com.pl

[Layered navigation - very slow category page loading]

I know. Changed.

I think the list of categories at the bottom is useful for mobile users.

[Layered navigation - very slow category page loading]

Just change double dots into single dots in the address. (I don't need any robots crawling in there)

I've just disabled the cache besides the smarty one. I've also set the default sorting by position in the category. Seems to work a bit faster.

The filter module is looking good. Thx

[Layered navigation - very slow category page loading]

This query takes 77 seconds when I test it in phpmyadmin. However, the result is correct. (blocklayered off)

The tb_stock table is empty and so it is in my old Presta.

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2022-09-28 00:00:00",
INTERVAL 210 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `tb_category_product` cp
LEFT JOIN `tb_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `tb_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN tb_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `tb_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `tb_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `tb_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `tb_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` IN (22) AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY pl.`name` ASC
LIMIT 0,60

 

[Layered navigation - very slow category page loading]

Definitely too advanced but perhaps I could try if somebody told me how. 😉

I don't know what I have done wrong so installing from scratch and importing the data form my Presta table by table may not help. What would you say to that?

[Layered navigation - very slow category page loading]

#1146 - Table 'baza_thirtybees.tb_cat_filter_restriction' doesn't exist

 

[Layered navigation - very slow category page loading]

Thx, I've changed PHP to 7.4 and set the cache for 10 minutes in newproducts and bestsellers modules.

The home page is working much better now.

 

The problem with the categories and blocklayered still not solved. 😞

 

  

 

 

 

[Layered navigation - very slow category page loading]

Could you have a look, please? Profiling is set to true at the moment.

lampadina..kei..pl/22-zyrandole

Tables stress

192 product_shop

130 product

79 product_attribute_shop

78 stock_available

76 smarty_lazy_cache

67 feature_lang

67 specific_price

66 feature_product

66 feature_value_lang

66 product_lang

65 tbhtmlblock_hook

65 tbhtmlblock

65 tbhtmlblock_lang

61 feature

61 product_group_reduction_cache

61 specific_price_priority

61 feature_shop

16 product_attribute

13 category

12 category_lang

7 image_type

6 category_shop

5 layered_indexable_feature_value_lang_value

5 layered_indexable_feature_lang_value

5 feature_value

5 cat_restriction

5 module

5 currency_shop

4 hook

4 module_shop

4 shop_url

4 shop

4 layered_friendly_url

4 lang_shop

4 category_product

4 currency

3 customer

3 customer_group

3 lang

3 theme

3 category_group

3 image_lang

3 image_shop

2 cat_filter_restriction

2 smarty_last_flush

2 tax_rule

2 tax_rules_group

2 configuration

2 layered_indexable_feature

2 group

2 shop_group

2 country

2 country_lang

2 country_shop

2 hook_module

2 hook_alias

2 layered_indexable_attribute_group

2 meta

2 group_shop

2 layered_category

2 address

1 attribute_group

1 attribute_lang

1 attribute

1 product_attribute_combination

1 attribute_group_lang

1 manufacturer

1 configuration_lang

1 hook_module_exceptions

1 module_currency

1 group_lang

1 tax_lang

1 tax

1 module_group

1 image

1 meta_lang

1 theme_meta

1 product_reductions

1 themeconfigurator

[Layered navigation - very slow category page loading]

 

 

Main page:

 

One of the category pages:

What should I do now?

Thanks

[Layered navigation - very slow category page loading]

Hello everyone!

I've got a shop running on 1.6.0.9 Presta and I've finally decided to upgrade it a bit 😉

I've chosen the Thirty Bees instead of 1.7 Presta and I am having a lot of doubts at the moment.

When I turn on the layered navigation module I have to wait almost a minute until the category with the highest amount of products gets displayed. (I've got about 15000 products)

The old Prestashop is working all right.

I've set the cache according to the TB blog article.

Has anyone faced a problem like mine?

 

My temporary address (TB) lampadina..kei..pl

My current Prestashop  https://www.lampadina.com.pl/lampy

 

You may try this category:

lampadina..kei..pl/22-zyrandole

https://www.lampadina.com.pl/lampy/22-zyrandole

 

(sorry for the double dots 😉 )

Thanks

[uBlock Origin hides most of the images]

Hello, I've recently installed Thirty Bees 1.3.0.

In Firefox and Chrom with uBlock Origin addon installed you cannot see most of the images including products.