Magento2 Products on Category after deployment

I recently did a release on my magento2 instance on production. Everything looked good for a day, then enabled some configuration and styling went away from all product pages. So I reverted that and rebuilt (di, static files, setup:upgrade, etc). Now all our category pages have no products and seeing an error like the following:

Uncaught exception ‘TypeError’ with message ‘Argument 8 passed to Magento\Catalog\Model\ProductRenderList::__construct() must be of the type array, null given, called in /var/www/vhosts/ on line 111’ in /var/www/vhosts/

I follow the entire stack trace and it is all core magento files. Any ideas on this?

After updating from Community Edition 2.3.1 to 2.3.2, Catalog Products page takes 4-5 minutes to load

After updating from community edition version 2.3.1 to 2.3.2, both my development site and my live site take 4-5 minutes to load the page Catalog-Products. The page seems to hang just after the main page framework is loaded, including the grid for products, but the line for active filters has yet to load. This happens in both Firefox and Chrome from multiple computers. In version 2.3.1 this page load took 3-5 seconds.

Once loaded, the page acts normally until I navigate away (say, to edit a product), then another 4-5 minute wait.

I read several articles on page speed, and nothing described in any article has any effect on this page.

As far as I can tell, all other functions on the web site are working at least as fast as version 2.3.1.

Magento CE 2.2.2 Elastic Search No Products Front End Category / Listing Pages

Magento CE 2.2.2 ElasticSearch 6.4 PHP 7.1 Apache 2.4

Magento CE 2.2.2 Elastic Search No Products Front End Category / Listing Pages

We have installed

Amasty Layered Navigation Amasty ElasticSearch

When we enable in admin Amasty Elasticsearch – chaged it from Mysql to Amasty Elasticsearch – our products on the front end – category / listing pages dissapear –

Magento admin -> Configuration -> Catalog -> Catalog Search

If I then RESAVE in admin same product they appear in front end.

I spent along time researching and notice other people with similar issues when enabling ElasticSearch but no fixes. This is same problem with other company elasticsearch extension.

Uploading ECommerce products into your Website for $20

If you are looking for someone to add woocommerce I’m here to help you!!!  My Priority is to provide you fast and Quality service.I will add woocommerce products on your store. My first priority is your 100% satisfaction. I will Provide Services of: * 100 woocommerce Products with Pictures, Price and Description etc.  * Woocommerce Product Title  * Long Description and Short Description   * Price/special price  * Category/sub-categories  * Tags/Key words  * SKU Some reason why you hire me?? Quick ResponseDelivery before deadlineExperience100 % Quality and time Guaranteed100% Moneyback Guarantee If you do not get the satisfaction with my work .

by: SwarupMajumder
Created: —
Category: Data Entry
Viewed: 32

Magento 1. Get downloadable link for downloadable products with samples

The following piece of code is supposed to get the download link only for downloadable products with uploaded samples at the Magento backend.

if($  _product->getTypeId() == 'downloadable') {     /** @var Mage_Downloadable_Model_Resource_Sample_Collection $  samples */     $  samples = Mage::getModel('downloadable/sample')->getCollection()->addProductToFilter($  product_id);     if ($  samples) {         $  _myprodsamples = Mage::getModel('downloadable/link');         $  _mySampleCollection = $  _myprodsamples->getCollection()->addProductToFilter($  _product->getId());         foreach ($  _mySampleCollection as $  _sample){             $  _samplelink = $  this->getUrl('downloadable/download/linkSample/link_id/'.$  _sample ->getId());         }        }    }   <?php if($  _samplelink): ?>   <a href="<?php echo $  _samplelink ?>" class="button btn-cart piwik_download" target="_blank">Downnload</a> <?php else: ?> 

However, all downloadable products are showing the download links, and this should only happen for downloadable products with uploaded samples at the backend.

Has anybody an idea of what is still going wrong?

No products on site after backup/restore database from one server to another

I’m trying to copy the database data from my production Magento 2.3.2 site to a local development site.

I created a backup of my production MySQL database with phpmyadmin like in the screenshot below.

enter image description here

Then on my local server, I created a new database named magento and restored my production database (named ad2f5134_newlive) into it with mysql -u root -p magento < ad2f5134_newlive.sql

Then I updated the URLs in core_config_data for my local development site.

The problem is that no products show up on my local development site. When I go to Catalog > Products in the Admin section, I get this message:

enter image description here

I checked catalog_product_entity on my local development site, and all the products from my production site are in the table.

One thought I had is that it is an indexer problem, so I ran bin/magento indexer:reindex. That gives me the following error:

General error: 1449 The user specified as a definer ('ad2f5134_newlive'@'%' does not exist... 

So my two questions are:

  • Why are no products on the site — even though they are in the database — and why don’t any products show up in the Admin section under Catalog > Products?
  • The user ad2f5134_newlive is the database user from my production site. Something in the database must now be telling my local development site to be using the ad2f5134_newlive user to run those reindexing queries. How do I change that user to by my local user?

Magento 2.2.2 Products Not Showing Category and List Page

I have a real hard time solving this issue.

Issue is products Not showing on front end Category Pages and Product Listing Pages after import via csv –

Just shows We can’t find products matching the selection.

However if I go to the product in Admin and then RE SAVE without Any changes – and clear cache that product

will show in front end – on product listing pages and category pages – and shows in Layered Navigation

One thing I noticed is that After resaving the product in Admin – it automatically is adding Color Black to the

product – even if i havent selected it –

I then tested my import file by adding color Black to the products in the import file to check if they show on

front end – but this did not fix the issue

In the database table I also noticed for the resaved products and after it adds Black to the color_value column

and color column 49

I tried to match these settings for the products which were not resaved in admin but again these still did not

show on front end

I imported over 30000 via csv – all

1.are showing in Admin

  1. are showing under the correct categories in Admin

  2. Can be seen on front end by going direct to product page itself

  3. Tested with making products in stock with qty 10 and out of stock with qty 0 – both will not show in

product listing / category pages until they have been resaved in admin

  1. Run reindex and cleared all caches

I have set Magento to Display out of Stock Products

The Qty for the products and is_in_stock values are set correctly after import and also the producta are


I have tried to export the products which I have resaved and show in product listing pages and then match each

attribute for the import – however after import again the products NOT saved in Admin dont show on front end

category and product listing pages.

Spent over 4 weeks on this and tried alot of things and trial and error.

I checked the database table catalog_product_flat_1 and checked all attributes imported and compared the ones

showing on front end and the ones which are not – and they made them identical however they still will not show

on front end unless the product has been resaved in admin.

This is same case when importing via another extension or application for Magento for example Firebear – this

issue is happening whenever or whatever I use a csv import.

Another issue is that if I resave the products and they then show on front end – when i update those same

products via csv import – the values for example price and qty and is_in_stock only change in admin and not

in front end – on product listing category pages – I then have to resave again and clear cache then the

updated changes are reflected on the front end

I am really stuck on

Configurable Products Import Issue

I am trying to upload this csv file for the configurable products.

Unfortunately, the error I am facing is “1. Column configurable_variations: Attribute with code “sizechanged” does not exist or is missing from product attribute set in row(s): 2

However, when I checked my additional_attributes and configurable_variations attributes, it seems like I got all of the attributes definition there already.

I hope someone please have a look into the file and help me with the answer. Much appreciate it.

How to skip this error ” Not all of your products are available in the requested quantity.”

I am new in magento 2 and I have products in stock with qty 0, all of them. If I have an order when shipping of course this error showed up Not all of your products are available in the requested quantity. I need to edit each product’s qty to equal to the qty in the cart. where should I modify to do so?