magento2 – Grouped Product Reviews – View and view related simple product reviews

It is frustrating that Magento has a mechanism that deals with checking configurable options for a configurable product, but NOT simple products for grouped products.

My website uses grouped products. Since all orders are simple products, the ratings are ultimately simple products, but they are not displayed on the grouped product page. I would like to a) expand the rating block to add simple product ratings, and (ideally) b) extend the rating calculation to include simple product ratings.

I searched everywhere for a review extension that supports grouped products and couldn't find one. So I try to punch it myself.

The first attempt was to try to expand that MagentoReviewBlockProductViewListView Block to get the list of associated product IDs and pass that list to the collection classes. Then the collection classes somehow have to query for a list of products instead of a single one.

The collection classes MagentoReviewModelResourceModelReviewProductCollection and MagentoReviewModelResourceModelReviewCollection Create a method query AddEntityFilter If there is an exact match, this must be changed by entity_pk_value=? to entity_pk_value in (?).

This is a tiny change that is technically backward compatible, so I first tried using a plugin. Unfortunately, query building is all protected methods so plugins cannot work. So I seem to have to bypass or expand the collection classes as a whole to make this change.

Do I even get it right? Is there a better one?

magento2.3 – Update related products of a configurable product – Magento 2.3.4

I am looking for a solution to change related products if the customer chooses another attribute / simple product of this configurable product.

For example, I have a configurable product with the attribute colors red and black. Both simple products (red and black) have different related products.

When I enter the configurable product and change the color, only the associated product that is connected to the configurable main product is displayed. The associated products are not updated depending on the selection.

Do you have a solution for this?

Thanks a lot.

linear algebra – upper limit for the condition number of the product of a random sparse matrix and a semi-orthogonal matrix

To let $ G in mathbb {R} ^ {n times m} $ (m> n, m = O (n)), whose all entries i. distributed as $ mathcal {N} (0, 1) * text {Ber} (p) $. To let $ V in mathbb {R} ^ {m times n} $ be a solid semi-orthogonal matrix, d. H. the columns of $ V $ are orthonormal vectors. Define $ A = GV $, For what $ p $ Can we give a polynomial cap for the condition number of? $ A $ i.e. $ kappa (A) leq text {poly} (n) $?

Interesting cases / related problems:

  1. To let $ V $ can be defined as $ V_ {i, j} = 1 $ if $ i = j $ and $ V_ {i, j} = 0 $ Otherwise. To let $ G = (g_1, g_2, ldots, g_m) $, in this case $ A = GV = (g_1, g_2, ldots, g_n) $. Hence in this case $ A $ has the same distribution as $ G $ except $ m = n $. This has been investigated by Basak and Rudelson, who have proven this $ kappa (A) leq text {poly} (n) $ to the $ p = Omega ( log n) / n $.

  2. To the $ p = 1 $, $ G $ is just a random Gaussian matrix and $ A = GV $ can also be considered a random Gaussian matrix if Gaussian vectors are isotropic. This is only a sub-case of 1.

magento2 – Product attributes cannot be updated after a bulk import in M2.3.4 (single or bulk product attributes)

I uploaded some products using the import option on my M2.3.4 site hosted on the web server. If I need to change / update some attributes now, I can't do that because I cannot save my changes. I have gone through various posts but cannot find a solution.
My cron are doing well. I have a ps aux | grep (c) made onsumer & the results are;

> gadgetwi  614593  0.1  0.0 517400 94428 ?        S    13:51   0:01
> /opt/alt/php72/usr/bin/php /home/gadgetwi/public_html/bin/magento
> queue:consumers:start product_action_attribute.update --single-thread
> --max-messages=10000 gadgetwi  614596  0.1  0.0 517400 94424 ?        S    13:51   0:01 /opt/alt/php72/usr/bin/php
> /home/gadgetwi/public_html/bin/magento queue:consumers:start
> --single-thread
> --max-messages=10000 gadgetwi  614598  0.1  0.0 517396 93472 ?        S    13:51   0:01 /opt/alt/php72/usr/bin/php
> /home/gadgetwi/public_html/bin/magento queue:consumers:start
> exportProcessor --single-thread --max-messages=10000 gadgetwi  614600 
> 0.1  0.0 517400 93604 ?        S    13:51   0:01 /opt/alt/php72/usr/bin/php /home/gadgetwi/public_html/bin/magento
> queue:consumers:start codegeneratorProcessor --single-thread
> --max-messages=10000 gadgetwi  655587 17.5  0.0 501876 78844 ?        R    14:07   0:00 /opt/alt/php72/usr/bin/php
> /home/gadgetwi/public_html/bin/magento cron:run --group=consumers
> --bootstrap=standaloneProcessStarted=1 (gadgetwi@webhosting2042 public_html)$ php bin/magento queue:consumers:start exportProcessor

One observation: If I run in the CLI (PHP Bin / Magento Queue: Consumer: Start ExportProcessor), I get no results. Basically nothing happens.
Most of the solutions that people used to offer are about cron, and in my case, I don't know how to fix it. The basic ones like max-message = 10000 already exist.

Any insight into my problem would be greatly appreciated.

Thanks a lot

Permalinks – How can I edit the image URL in the presented image and product description in large quantities?

I tried a few plugins (free of charge), but none updated the URL in the product image and in the product descriptions.

How can I update in bulk instead of running them individually? If there is a plugin (preferably free) that can edit the image url, please let me know.

Thanks a lot

Article writing, copywriting, blog content, website content, product description, landing page, etc. for $ 15

Article writing, copywriting, blog content, website content, product description, landing page etc.

– You will receive content that is as interesting as you expected because I have experience writing content and have worked on projects with large companies several times.

– You will get the speed and suitability of the desired deadline

– If the content you receive is less interesting, you are entitled to revisions from us

– and finally, if your content doesn't match your intentions at all, your money will return

magento2 – Magento 2 free downloadable product order status is automatically closed

I have free downloadable products in my Magento 2 shop (Magento 2.3.4, migrated from Magneto 1). If a customer buys this free downloadable product, he receives an order without subtotal, which I have automatically set to status processing via the Magento payment settings. The order is also automatically billed, but the order always has the status "closed" with a correctly assigned invoice, so that the download does not work. No credit was created! This should be the only way to get to the status that is closed according to the Magento status scheme.

This behavior was not observed in Magento 1 because it always ended with the status "completed" and the download was automatically activated.

Any ideas?