How to remove a module package by PHP composer?

You can remove the specific module package from the composer by using composer syntax.

Run the given command from the root of your project.

composer remove <vendor-name>/<package-name> Continue reading “How to remove a module package by PHP composer?”

How Abandoned Carts report works in Magento 2?

Magento supports the out-of-the-box Abandoned Carts Reports feature.

You can able to see Abandoned Carts reports from the Navigation menu by clicking on,

      • Reports -> Marketing -> Abandoned Carts.

You can able to see a list of abandoned carts for a customer in the grid. Continue reading “How Abandoned Carts report works in Magento 2?”

How to use SQL distinct Query in Magento 2?

Magento 2 distinct SQL Query is used to return results as unique records for the given field by skipping duplicate values from the SQL Response.

If a Specific Column in a table contains, multiple duplicate values and you want to skip it and fetch only single records for the same column, You can use distinct keywords in a query to filter out duplicate values.

You can Learn about, A List of Direct SQL Queries in Magento 2.

Just use distinct keywords on a query like, $connection->select()->distinct()

Continue reading “How to use SQL distinct Query in Magento 2?”