magento
How to Retrieve Total Orders Per Day in Magento 2 for the Last Month
How to Retrieve Total Orders Per Day in Magento 2 for the Last Month
When managing a Magento 2 store, analyzing daily order trends is crucial for tracking business performance. This guide explains how to retrieve the total number of orders per day for the last month using a MySQL query.
Step 1: Understanding the Query
The query leverages Magento’s sales_order
table, which stores details about each order placed on your website. By grouping orders by their creation date, you can calculate the total number of orders for each day.
Unblocking Customers in Magento After Too Many Failed Login Attempts
Magento provides robust security features to protect customer accounts from unauthorized access.
Programmatically Assign Attribute to All Attribute Sets in Magento 2
I will put here the way to add an attribute group then assign an attribute into all attribute set with this group, please note I am using the dirty way to add it so you will need to follow the Dependency injection in your code to have the same result
Error after upgrade Magento into version 2.4.4 with PHP 8.1
After upgrading Magento to version 2.4.4 and PHP 8.1, you might have this error
Type Error occurred when creating object: Magento\Framework\Communication\Config\Data, Magento\Framework\Reflection\TypeProcessor::resolveFullyQualifiedClassName(): Argument #2 ($typeName) must be of type string, null given, called in /{magento_root}/vendor/magento/framework/Reflection/TypeProcessor.php on line 550
Magento 2 – How to identify current page in phtml file?
Magento 2 – How to identify current page in phtml file?
$currentFullAction = $block->getRequest()->getFullActionName();
$catpages= array('catalog_category_view','catalog_product_view');
if(in_array($currentFullAction, $catpages)){
//Catalog page
}
How do you add translation for extensions in Magento2?
How do you add translation for extensions in Magento2?
Then generate the dictionary with magento shell tool; from :
php bin/magento i18n:collect-phrases -o app/code/{Vendor}/{Module}/i18n/en_US.csv app/code/{Vendor}/{Module}/
do not forget to replace {Vendor} and {Module} with your correct information
Disable Coupon in Magento2 in the cart and in the checkout
The best approche is to add these files "checkout_cart_index.xml" and "checkout_index_index.xml" in this directory
app/design/frontend/{Vendor}/{theme}/Magento_Checkout/layout/
with this content
checkout_cart_index.xml
Magento 2 static files are not working
How many times you tried to install Magento 2 and later you could not see the website working !!, How many times you tried to search for these sentences
"Magento 2 css not working"
"Magento 2 js not working"
"Magento 2 404 page not found" because of the static files?
Now here is the solution, and easily it is the missed .htaccess (for apache)
by quick look at this path "{magento root}/pub/static", you will see that you missed the .htaccess file
Magento 2 how to configure Nginx to allow execute phpinfo.php files in root folder
Go to the Nginx configuration then you need to edit the line similar to this line
location ~ (index|get|static|report|404|503)\.php$ {
to be like this
location ~ (index|get|static|report|404|503|phpinfo)\.php$ {
then restart Nginx
Change Magento search engine using CLI
You can use the Magento 2 CLI to do it, you can check your current search engine using:
php -f bin/magento config:show catalog/search/engine
if you want to change the engine to Elasticseach version 6 then use this command
php -f bin/magento config:set catalog/search/engine 'elasticsearch6'