(!) Searching for products on Create order page

[Tinox]

Hi,

Setting up a new shop using 1.7.7.1.

When creating an order in backoffice as administrator, I can choose the customer, but none of the available products are retreived when searching for them the field "Search for product" in the "Cart" section. A blue box is shown stating [ (!) Searching for products. ]. This makes it impossible to create an order from the backoffice, an imperative task in this shop's scenario. Same for "Add a product" on the edit page of an excisting order.

Edit 1: when I search for non excisting string a red box is displayed: [ (!) No products found. ], so something's working in the background.

Edit 2: search paramaters page states: The "indexed" products have been analyzed by PrestaShop and will appear in the results of a front office search. Indexed products 14 / 14.
I also re-built the entire index, but that didn't help.

Thanks for reading and best wishes,
Tinox

Edited January 28, 2021 by Tinox
More info and screenshot added (see edit history)

[JBW]

Check your browser console/network tab in the developere tools. There should be a XHR request - check its response, if there is an error you should be able to see the details here (maybe you need to activate debug mode before)

[Tinox]

Thanks for your response JBW!

This morning I found out that the issue is rrelated to an addon that overrides the /override/classes/tax/TaxCalculator class. This causes an error in the getTotalRate() function of this override, so the search does not work. I have contacted the developer of the addon and will update here later.

[Tinox]

Nicely and swiftly fixed by the addon developer. Issue closed.

[teaguy]

On 2/1/2021 at 12:07 PM, Tinox said:

Nicely and swiftly fixed by the addon developer. Issue closed.

Can I ask what module? I am having the same issue.

[Tinox]

On 6/10/2021 at 2:58 AM, teaguy said:

Can I ask what module? I am having the same issue.

lpsproinvoice
module B2B Invoicing - Remove Tax (without VAT / Tax excl)

[jvicente1971]

I'm having exactly same issue and don't have that module...Please any ideas?

[JBW]

57 minutes ago, jvicente1971 said:

I'm having exactly same issue and don't have that module...Please any ideas?

My ealiert post is still valid:

Check your browser console/network tab in the developer tools. There should be a XHR request - check its response, if there is an error you should be able to see the details here (maybe you need to activate debug mode before)

[jvicente1971]

Hello

I have this error on developer tools:

Oops... looks like an unexpected error occurred
Oops... looks like an unexpected error occurred

Type error: Argument 7 passed to PrestaShop\PrestaShop\Core\Domain\Product\QueryResult\ProductCombination::__construct() must be of the type string, null given, called in ......./src/Adapter/Product/QueryHandler/SearchProductsHandler.php on line 273

[Symfony\Component\Debug\Exception\FatalThrowableError 0]

Enable debug mode
Back to previous page
Learn more about debug mode arrow_right_alt

 

[Michael]

hallo

 

ich habe auch dieses problem

kann bei einer bestellung keine produkte mauell hinzfügen da er mir bei suche für ein prokukt nichts anzeigt,als wenn keine prodikte vorhanden währen.

 

prestashop 1.7.8.7

 

danke im voraus für eure hilfe

[JBW]

Schau mal in der Browser Console ob der Fehler im XHR Request oder Javascript angezeigt werden

[Webo.Agency]

We resolve that issue temporary: https://github.com/PrestaShop/PrestaShop/issues/32950

In your shop there is Product with Combinations that have NULL attributes. You will see "-,-" in title. Remove and add once more - this time properly.
Issue go away in our side

[shacker]

replace this function in  /src/Adapter/Product/QueryHandler/SearchProductsHandler.php on line 273

 

private function getProductCombinations(

        Product $product,

        string $currencyIsoCode,

        int $computingPrecision,

        ?Order $order = null

    😞 array {

        $productCombinations = [];

        $combinations = $product->getAttributeCombinations();

 

        if (false !== $combinations) {

            foreach ($combinations as $combination) {

                $productAttributeId = (int) $combination['id_product_attribute'];

                if ( $combination['attribute_name'] == null) {

                    $attribute = '-';

                } else {

                    $attribute = $combination['attribute_name'];

                }

               

                if (isset($productCombinations[$productAttributeId])) {

                    $existingAttribute = $productCombinations[$productAttributeId]->getAttribute();

                    $attribute = $existingAttribute . ' - ' . $attribute;

                }

 

                $priceTaxExcluded = $this->getProductPriceForOrder((int) $product->id, $productAttributeId, false, $computingPrecision, $order);

                $priceTaxIncluded = $this->getProductPriceForOrder((int) $product->id, $productAttributeId, true, $computingPrecision, $order);

 

                $productCombination = new ProductCombination(

                    $productAttributeId,

                    $attribute,

                    $combination['quantity'],

                    $this->contextLocale->formatPrice($priceTaxExcluded, $currencyIsoCode),

                    $priceTaxExcluded,

                    $priceTaxIncluded,

                    $combination['location'],

                    $combination['reference']

                );

 

                $productCombinations[$productCombination->getAttributeCombinationId()] = $productCombination;

            }

        }

 

        return $productCombinations;

    }

[tank]

Thanks, it fixed my problem with search not working on certain items