Go to scheduled task in Plesk
Click on add new
Choose run a php script
If you click the folder icon you can select the bin/magento folder
You then need to add an argument of cron:run
Choose cron style from the run dropdown and add */1 * * * *
Give it a description and click save.
Your Magento 2 cronjob should now be running
Need to install a module but don’t have command line tools? I found this handy script that will do the leg work for you.
Create a file I called mine upgrade.php in the file place the following script you can change what command you want to run by changing the variable $k[1]= ”; all you then need to do is run the file from your browser.
<?php
use Magento\Framework\App\Bootstrap;
require __DIR__ . '/app/bootstrap.php';
$bootstrap = Bootstrap::create(BP, $_SERVER);
$obj = $bootstrap->getObjectManager();
$state = $obj->get('Magento\Framework\App\State');
$state->setAreaCode('frontend');
$k[0]='bin/magento';
$k[1]='cache:status'; // write your proper command like setup:upgrade,cache:enable etc...
$_SERVER['argv']=$k;
try {
$handler = new \Magento\Framework\App\ErrorHandler();
set_error_handler([$handler, 'handler']);
$application = new Magento\Framework\Console\Cli('Magento CLI');
$application->run();
} catch (\Exception $e) {
while ($e) {
echo $e->getMessage();
echo $e->getTraceAsString();
echo "\n\n";
$e = $e->getPrevious();
}
}When trying to checkout I get the following error
‘Unable to save address please check input data’
This was due to a php setting in plesk, please see this link for more info https://github.com/magento/magento2/issues/10821#issuecomment-334525946
Read MoreAdd the following line in Content > Pages > Home then find the Design section
<referenceBlock name=”page.main.title” remove=”true” />
This will remove the H1 title from the page
Read MoreHopefully I’m going to cover the things I’ve been unable to find out so far.
To create your own theme you need the following structure app/design/frontend/Somename/Somename1/
From here you then need Magento_Theme/layout/ and Magento_Theme/templates/ for your layout.xml files and template.phtml files
Back in app/design/frontend/Somename/Somename1/ you need a web/ folder with the following structure
css/
js/
images/
fonts/
In app/design/frontend/Somename/Somename1/ you will also need registration.php and theme.xml.
Your registration file should contain the following where the somename and somename1 match your folder structure
<?php
/**
* Copyright © 2015 Magento. All rights reserved.
* See COPYING.txt for license details.
*/
\Magento\Framework\Component\ComponentRegistrar::register(
\Magento\Framework\Component\ComponentRegistrar::THEME,
‘frontend/somename/somename1’,
__DIR__
);
Your theme.xml file should contain the following where <parent> is if you are extending another theme
<theme xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”urn:magento:framework:Config/etc/theme.xsd”>
<title>A NAME</title> <!– your theme’s name –>
<parent>Magento/blank</parent> <!– the parent theme, in case your theme inherits from an existing theme –>
<media>
<preview_image>media/preview.jpg</preview_image> <!– the path to your theme’s preview image –>
</media>
</theme>
We have been quiet on here for a while due to launching a new website. We have just launched Not In The Dog House selling premium dog products and premium dog treats. Go check it out and get 20% off your first order.
Read MoreI have used this slightly messy way of displaying the minimum order amount on any phtml file. I used it in the header but could easily go in any template file. Obviously you could also use the Magento subtotal for many other calculations too!
<div>
<? if(Mage::getSingleton(‘checkout/session’)->getQuote()->getSubtotal() > 50) { ?>
<? } else { ?>
<p>We have a minimum order of £50</p>
<p>Please continue shopping</p>
<? } ?>
</div>
Read MoreFirst we need to get the total number of orders:
$result = mysqli_query($con,”
SELECT count(mg_sales_flat_order.status) as grand_count
FROM mg_sales_flat_order
WHERE mg_sales_flat_order.status NOT LIKE ‘canceled’
AND mg_sales_flat_order.status NOT LIKE ‘closed’
AND mg_sales_flat_order.status NOT LIKE ‘fraud’
AND mg_sales_flat_order.status NOT LIKE ‘holded’
AND mg_sales_flat_order.status NOT LIKE ‘paypal_canceled_reversal’
$totalorders1 = $row[‘grand_count’];
“);
while($row = mysqli_fetch_array($result)) {
$totalorders = $row[‘grand_count’];
echo $totalorders;
}
Then we need to get the total number of customers:
$result = mysqli_query($con,”
SELECT COUNT(*) AS grand_count FROM(
SELECT customer_email FROM mg_sales_flat_order
WHERE mg_sales_flat_order.status NOT LIKE ‘canceled’
AND mg_sales_flat_order.status NOT LIKE ‘closed’
AND mg_sales_flat_order.status NOT LIKE ‘fraud’
AND mg_sales_flat_order.status NOT LIKE ‘holded’
AND mg_sales_flat_order.status NOT LIKE ‘paypal_canceled_reversal’
GROUP BY customer_email
) s”);
while($row = mysqli_fetch_array($result)) {
$totalcustomers = $row[‘grand_count’];
echo $totalcustomers1;
}
We then need to do total orders divided by total customers to give us the average number of orders per customer
$decimal_places = 2;
echo number_format($totalorders/$totalcustomers, $decimal_places);
Read MoreFirst off get the total number of customers:
SELECT COUNT(*) AS grand_count FROM(
SELECT customer_email FROM mg_sales_flat_order
WHERE mg_sales_flat_order.status NOT LIKE ‘canceled’
AND mg_sales_flat_order.status NOT LIKE ‘closed’
AND mg_sales_flat_order.status NOT LIKE ‘fraud’
AND mg_sales_flat_order.status NOT LIKE ‘holded’
AND mg_sales_flat_order.status NOT LIKE ‘paypal_canceled_reversal’
GROUP BY customer_email
Then get the number of new customers:
SELECT COUNT(*) AS grand_count FROM(
SELECT customer_email FROM mg_sales_flat_order
WHERE mg_sales_flat_order.status NOT LIKE ‘canceled’
AND mg_sales_flat_order.status NOT LIKE ‘closed’
AND mg_sales_flat_order.status NOT LIKE ‘fraud’
AND mg_sales_flat_order.status NOT LIKE ‘holded’
AND mg_sales_flat_order.status NOT LIKE ‘paypal_canceled_reversal’
GROUP BY customer_email HAVING COUNT(*) = 1
) s
Then get the number of repeating customers:
SELECT COUNT(*) AS grand_count FROM(
SELECT customer_email FROM mg_sales_flat_order
WHERE mg_sales_flat_order.status NOT LIKE ‘canceled’
AND mg_sales_flat_order.status NOT LIKE ‘closed’
AND mg_sales_flat_order.status NOT LIKE ‘fraud’
AND mg_sales_flat_order.status NOT LIKE ‘holded’
AND mg_sales_flat_order.status NOT LIKE ‘paypal_canceled_reversal’
GROUP BY customer_email HAVING COUNT(*) > 1
) s
You can then get the outputs of the SQL to calculate your percentages with something like the below:
echo ($repeatcustomers/$totalcustomers)*100 . “%”;
echo ($newcustomers/$totalcustomers)*100 . “%”;
Read MoreI need to get the AOV from our store.
Simple SQL code is as follows:
SELECT SUM( grand_total ) / COUNT( * )
FROM `mg_sales_flat_order`
WHERE mg_sales_flat_order.status NOT LIKE ‘canceled’
AND mg_sales_flat_order.status NOT LIKE ‘closed’
AND mg_sales_flat_order.status NOT LIKE ‘fraud’
AND mg_sales_flat_order.status NOT LIKE ‘holded’
AND mg_sales_flat_order.status NOT LIKE ‘paypal_canceled_reversal’
Instead of using grand_total there are a couple of other things you can do which are as follows:
grand_total = product rev + ship – discount inc tax
base_subtotal & subtotal = product revenue exc tax
base_subtotal_incl_tax & subtotal_incl_tax = product revenue inc tax
Read More