30knees

$result = Db::readOnly()->getArray( ' SELECT c.*, cl.* FROM `'._DB_PREFIX_.'category` c '.($useShopRestriction ? Shop::addSqlAssociation('category', 'c') : '').' LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON c.`id_category` = cl.`id_category`'.Shop::addSqlRestrictionOnLang('cl').' '.(isset($groups) && Group::isFeatureActive() ? 'LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON c.`id_category` = cg.`id_category`' : '').' '.(isset($rootCategory) ? 'RIGHT JOIN `'._DB_PREFIX_.'category` c2 ON c2.`id_category` = '.(int) $rootCategory.' AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`' : '').' WHERE 1 '.$sqlFilter.' '.($idLang ? 'AND `id_lang` = '.(int) $idLang : '').' '.static::getActiveColumnCondition($active, $useShopRestriction).' '.(isset($groups) && Group::isFeatureActive() ? ' AND cg.`id_group` IN ('.implode(',', $groups).')' : '').' '.(!$idLang || (isset($groups) && Group::isFeatureActive()) ? ' GROUP BY c.`id_category`' : '').' '.($sqlSort != '' ? $sqlSort : ' ORDER BY c.`level_depth` ASC').' '.($sqlSort == '' && $useShopRestriction ? ', category_shop.`position` ASC' : '').' '.($sqlLimit != '' ? $sqlLimit : '') ); I can't help unfortunately but if you want to try what ChatGPT suggests until someone competent answers, use the code above. Maybe it'll work and we can also test 4o's debugging skills like this. :-)

Is there any service that lets you simultaneoulsy create ads for eg Google, Facebook, Microsoft? I've only found services for individual platforms but nothing that acts as a hub Prestashop to Various

Sorry for all the clarification requests but I do not see where to disable delivery delay. The input field for the delay will not accept 0 (it accepts -1).

@datakick in case you missed this one (because you kindly replied elsewhere in the meantime). :)

Thank you for this solution. I've not heard back regarding the webservice. But I changed the delay in Revws to 1 day each and added the dedicated mail queue with a delay of 15 days. There is no condition "order status" in mailqueue, so this would now just be based on the order + 1 day. Is this correct? I don't understand why this would work to fix the delay in Revws, though. Won't mailqueue module only take over once Revws wants to send? Because Revws will still keep the emails pending.

Thank you for checking. It could only be the fulfillment center's webservice. I will ask them. Is there any way to have the review request sent X days after a certain status is set?

Yes, it shows up in the order, together with the invoice.

@the.rampage.radoNo, they are being sent, so the cron is working. @datakick That's the thing, the status has shipped. Both shipped and delivered have these settings.

These are my settings: And yet I have an order that was marked shipped 08.04.2024 where the request is still pending to be sent to the customer. The status "shipped" gives me in the automation queue the information "Merchandise hasn't been delivered yet" even though the status for "Shipped" has a delivery checkmark. Only when I mark the order as "delivered" does Revws say "Waiting for order to be delivered" for the period specified as the "delivery delay" (I am assuming). Does Revws have its own status interpretations or what is the cause of the above? Also, is there any way to simply have the review request sent X days after a certain status is set?

Ok, thanks. Yes, Google should have permit some "no ratings yet" value. Will try to get customers to review. :)

Google Search Console tool shows me this: Either "offers", "review", or "aggregateRating" should be specified Items with this issue are invalid. Invalid items are not eligible for Google Search's rich results Learn more: https://developers.google.com/search/docs/appearance/structured-data/product I use the Revws module: https://store.getdatakick.com/en/modules/revws @datakick Would you have an idea?

I'd like to revisit this. I have {categories:/}{id:/}{rewrite} as the product rewrite. Shouldn't domain.com/en/cat/123/typo automatically rewrite to domain.com/en/cat/123/correct? Because currently it doesn't. If I'm not mistaken, it used to work. Maybe I also just forgot to test last time.

I have the meta description field filled in but I see that search engines don't show this as the snippet in the search results. What is being shown is random. Some of it makes sense, other text not (eg a "thank you" from a reply to a review).

If people still choose the wrong country we know it's on purpose.

Good solution. How did you do that?

Perhaps the only way to minimise this would be to use some address verification / autocomplete system, at the very least for the postal code and city. Shouldn't be too difficult to implement, I'm assuming. Any thoughts on the solution?

I've noticed a couple of times now that customers from Spain mistakenly select Germany as the country (Germany is where the shop is based). This impacts the shipping price, the rate, and requires a manual correction of the address. I'm hoping this isn't some shipping fee scam but just a mistake by the customer. Is there any way to prevent this mismatch?

Is anybody using Zapier and thirtybees? I see there's a module to connect the two: https://addons.prestashop.com/en/third-party-data-integrations-crm-erp/24308-zapier-integration.html I am particularly curious about how good it is in fetching order invoices and integrating with Amazon Sellercentral.

I've not had any spam since using Turnstile. It's great!

D.h. ob es einen Update vom Modul geben wird? Vielleicht eher auf English datakick fragen?

@DRMasterChiefI wouldn't worry too much about maintenance mode. The risk that someone is going to get you for Google Fonts during maintenance mode is so small. Even if: an authority would just tell you off. 99.99% sure no fine.

I have a delay of 0, which means that the delay will depend on the cron job. Is this correct? Because at the moment the default queue isn't delaying anything, as far as I can tell.

Perhaps you need to test by disabling modules one by one?

We also load locally and nothing changed after the update. I just checked.

Yes, it works!