Perch Shop redirect

jade.picseli · Dec 19th 2019

Hi,

I'm trying to get a Perch Shop and running and eveything is working great until I get to the redirect of the Paypal where it's not working.

I've had a look into the debug and I notice that a shipping zone wasn't enabled which I've corrected, however looking at the debug on Shipping it brings up this:

Code

Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company' in 'field list'

Can someone please let me know if this is what is causing the redirect not to work? And how to resolve it

hus_hmd · Dec 21st 2019

Hi,

Quote from jade.picseli

until I get to the redirect of the Paypal where it's not working.

Are you referring to the redirect to the PayPal payment page? Or to the success/failure redirects (back to your site) after a payment attempt on the PayPal payment page?

jade.picseli · Jan 15th 2020

Yes, I'm referring to teh redirect to the Paypal payment page

hus_hmd · Jan 16th 2020

How are you initiating the PayPal checkout? Can you share your master page where you do this?

jade.picseli · Jan 16th 2020

Yes it's

PHP

<?php include('admin/runtime.php'); ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Flood Defences</title>
<meta name="author" content="SA1 Creative">
<meta name="viewport" content="width=device-width, minimum-scale=1, maximum-scale=1">
<link rel="shortcut icon" href="favicon.ico">
<link href="js/vendor/bootstrap/bootstrap.min.css" rel="stylesheet">
<link href="js/vendor/slick/slick.css" rel="stylesheet">
<link href="js/vendor/swiper/swiper.min.css" rel="stylesheet">
<link href="js/vendor/magnificpopup/dist/magnific-popup.css" rel="stylesheet">
<link href="js/vendor/nouislider/nouislider.css" rel="stylesheet">
<link href="js/vendor/darktooltip/dist/darktooltip.css" rel="stylesheet">
<link href="css/animate.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<link href="css/megamenu.css" rel="stylesheet">
<link href="fonts/icomoon-reg/style.css" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Roboto+Slab:300,400,700|Raleway:300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i|Roboto:300,300i,400,400i,500,500i,700,700i,900,900i" rel="stylesheet">
</head>
<body class="boxed">
<?php include('includes/header.php');?>
<main class="page-main">
<div class="block">
<div class="container">
<ul class="breadcrumbs">
<li><a href="/"><i class="icon icon-home"></i></a></li>
<li>/<span>Payment</span></li>
</ul>
<h1>Payment</h1>
</div>
</div>
<div class="block" style="margin-bottom: 40px;">
<div class="container">
<h2 class="post__title text-uppercase" style="text-align:center">PLEASE WAIT...</h2>
<h4 style="text-align: center;">We are redirecting your order to PayPal to complete the payment</h4>
<p style="text-align: center;"><img src="images/spinner.svg"/></p>
<?php
if (perch_member_logged_in()) {
// your 'success' return URL
$return_url = 'http://vibeyouth.web-design.wales/order-complete.php';
$cancel_url = 'http://vibeyouth.web-design.wales/cancel.php';
perch_shop_checkout('paypal-express', [
'return_url' => $return_url,
'cancel_url' => $cancel_url,
]);
}
else{
echo 'NOTLOGGEDIN';
}
?></div>
<?php PerchUtil::output_debug(); ?> </div></main>
<?php include('includes/footer.php');?>
<script src="js/vendor/jquery/jquery.js"></script>
<script src="js/vendor/bootstrap/bootstrap.min.js"></script>
<script src="js/vendor/swiper/swiper.min.js"></script>
<script src="js/vendor/slick/slick.min.js"></script>
<script src="js/vendor/parallax/parallax.js"></script>
<script src="js/vendor/isotope/isotope.pkgd.min.js"></script>
<script src="js/vendor/magnificpopup/dist/jquery.magnific-popup.js"></script>
<script src="js/vendor/countdown/jquery.countdown.min.js"></script>
<script src="js/vendor/nouislider/nouislider.min.js"></script>
<script src="js/vendor/ez-plus/jquery.ez-plus.js"></script>
<script src="js/vendor/tocca/tocca.min.js"></script>
<script src="js/vendor/bootstrap-tabcollapse/bootstrap-tabcollapse.js"></script>
<script src="js/vendor/scrollLock/jquery-scrollLock.min.js"></script>
<script src="js/vendor/darktooltip/dist/jquery.darktooltip.js"></script>
<script src="js/vendor/imagesloaded/imagesloaded.pkgd.min.js"></script>
<script src="js/vendor/instafeed/instafeed.min.js"></script>
<script src="js/megamenu.min.js"></script>
<script src="js/app.js"></script>
</body>
</html>

Display More

hus_hmd · Jan 16th 2020

You need to call perch_shop_checkout() before outputting any HTML or whitespace to the page. In fact, you don't need to output anything. You either redirect to PayPal or perhaps back to the cart or payment confirmation page. This is, more or less, all you need on the page:

PHP

<?php
include('admin/runtime.php');
$return_url = 'http://vibeyouth.web-design.wales/v2/order-complete.php';
$cancel_url = 'http://vibeyouth.web-design.wales/v2/cancel.php';
if(perch_member_logged_in()) {
perch_shop_checkout('paypal-express', [
'return_url' => $paypal_return_url,
'cancel_url' => $paypal_cancel_url,
]);
} else {
PerchSystem::redirect('/cart');
}

Display More

The above only relies on the user being a logged in member before redirecting them to PayPal. You can perform further checks like checking whether the cart has items and/or requiring a form (single button) to be submitted from the previous page.

jade.picseli · Jan 16th 2020

Now I'm just getting a blank page

hus_hmd · Jan 16th 2020

Do you get any errors? You can check your error log or enable Perch debug mode.

And have you added your PayPal config to perch/config/shop.php?

jade.picseli · Jan 16th 2020

I have nothing in the error log and the debug doesn't appear. Yes, I've set up the shop.php

hus_hmd · Jan 16th 2020

If you are on standard Perch, you will also need to add the following at the bottom of the page:

PHP

PerchUtil::output_debug();

You may also need to hold the redirects to see the debug message like so:

PHP

PerchUtil::hold_redirects();
if(perch_member_logged_in()) {
perch_shop_checkout('paypal-express', [
'return_url' => $paypal_return_url,
'cancel_url' => $paypal_cancel_url,
]);
} else {
PerchSystem::redirect('/cart');
}
PerchUtil::output_debug();

Display More

jade.picseli · Jan 16th 2020

Parse error: syntax error, unexpected 'includes' (T_STRING) in P:\EasyPHP\Jade\FLOOD DEFENCES V2\admin\addons\apps\perch_shop\lib\vendor\omnipay\common\src\Omnipay\Common\Message\AbstractResponse.php on line 202

hus_hmd · Jan 16th 2020

Ok it sounds you're getting closer to the issue. I'm not sure what would cause this. If you can share the full debug message and your diagnostics report (Settings > Diagnostics), perhaps drewm can help you further with this.

Perch Shop redirect

Similar Threads

Perch Shop and SCA regulations

Perch Shop Checkout Issue

Cart - requires shipping function

Adding item to cart, URL changes, but its same page