Cart won't persist, and seems to be on a different url

swood85 · Aug 7th 2019

Good Evening,

I am sorry (Drew) for all the forum posts, I believe this is my last issue now.

So on my product page, I have a product with a few different variants, and an add to cart button. I think it is pretty much the out of the box template, although i changed the url from '/shop/cart' to just '/cart':

Code

<div class="product-block product-block__shop">
<perch:if id="catalog_only" value="0">
<perch:form id="add_to_cart" app="perch_shop" action="/cart">
<perch:if exists="has_variants">
<perch:productopts>
<div class="choose-option">Choose Your <perch:productopt id="title"></div>
<perch:productvalues>
<perch:before><ul></perch:before>
<li>
<label>
<perch:input id="options" name="opt-<perch:productvalue id="optionID">[]" value="<perch:productvalue id="valueID">" type="radio" required="required">
<perch:productvalue id="valueTitle">
</label>
</li>
<perch:after></ul></perch:after>
</perch:productvalues>
</perch:productopts>
</perch:if>
<perch:input id="product" type="hidden" value="<perch:shop id="productID" type="hidden" env-autofill="false">">
<perch:input type="submit" value="Add to cart">
</perch:form>
<perch:else>
<p>This item is available in-store only.</p>
</perch:if>
</div>

Display More

When i make my selection, and click add to cart, i am taken to the cart page (/cart), and the item is displayed. However, the basket link in my header still shows 0 items, using this code:

PHP

<?php perch_shop_cart_item_count(); ?>

But the biggest issue is that if I refresh the page, the item will stay there, but if I leave and come back, or click the basket link in my header:

PHP

<a href="/cart">
<i class="material-icons">shopping_cart</i>
<?php perch_content('Header Basket Text'); ?>
<span><?php perch_shop_cart_item_count(); ?></span>
</a>

The page loads with a 'basket empty' message.

I haven't strayed too far from the docs, so not sure what I could have implemented incorrectly?

Thank you in advance,

Sam

swood85 · Aug 7th 2019

Just to add, I think it has something to do with the cart number which keeps increasing!

I have added debug info to the bottom of the cart page...

When I add to basket, i get this info:

Code

Debug Message - Perch 3.1.5
[1] SELECT * FROM perch3_pages WHERE pagePath='/cart.php' LIMIT 1
[34] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1901
[1] SELECT * FROM perch3_shop_products WHERE productID='5' AND productDeleted IS NULL LIMIT 1
[2] SELECT valueSKUCode FROM perch3_shop_option_values WHERE valueID IN ('6', '14') AND optionID IN (1, 2)
[1] SELECT productID FROM perch3_shop_products WHERE parentID=5 AND productDeleted IS NULL AND (sku REGEXP "[[:<:]]small[[:>:]]") AND (sku REGEXP "[[:<:]]navy[[:>:]]") LIMIT 1
[1] SELECT itemID, itemQty FROM perch3_shop_cart_items WHERE cartID=1901 AND productID=8
[1] SELECT * FROM perch3_shop_products WHERE productID=8 AND productDeleted IS NULL LIMIT 1
INSERT INTO perch3_shop_cart_items(productID,itemQty,cartID) VALUES('8',1,'1901')
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1901
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1901
etc...

Display More

Then when i click the basket link which should link to and basically refresh the same page I am on I get this info:

Code

Debug Message - Perch 3.1.5
[1] SELECT * FROM perch3_pages WHERE pagePath='/cart.php' LIMIT 1
[34] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1902
[4] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/cart.php' OR regionPage='*' ORDER BY regionPage DESC
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1902
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1902
etc...

Display More

It seems it has auto-incremented the basket ID... Do I need to set a cookie?

drewm · Aug 8th 2019

The cart should be maintaining its own cookies as part of the PHP session. Can you post your diagnostics report?

swood85 · Aug 8th 2019

Hi Drew,

Here is my diagnostics report:

PHP

Health check
Perch is up to date
PHP 7.2.20 is up to date
MySQL 5.7.27-log is up to date
Image processing available
Memory limit is low. Memory use is limited to -9.5367431640625E-7M, which could cause problems manipulating large images.
Summary information
Perch: 3.1.5, PHP: 7.2.20, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $, with PDO
Server OS: Linux, cgi-fcgi
Installed apps: content (3.1.5), assets (3.1.5), categories (3.1.5), perch_forms (1.12), perch_gallery (2.8.9), perch_shop_orders (1.2.6), perch_shop_products (1.2.6), perch_shop (1.2.6), perch_members (1.6.4)
App runtimes: <?php $apps_list = [ 'perch_members', 'perch_shop', 'perch_forms', 'perch_gallery', ];
PERCH_LOGINPATH: /perch
PERCH_PATH: /homepages/30/d711140345/htdocs/shipshape/perch
PERCH_CORE: /homepages/30/d711140345/htdocs/shipshape/perch/core
PERCH_RESFILEPATH: /homepages/30/d711140345/htdocs/shipshape/perch/resources
Image manipulation: GD
PHP limits: Max upload 64M, Max POST 64M, Memory: -9.5367431640625E-7M, Total max file upload: -9.5367431640625E-7M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
HTTP_HOST: www.shipshape.online
DOCUMENT_ROOT: /kunden/homepages/30/d711140345/htdocs/shipshape
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

Display More

drewm · Aug 9th 2019

Can you show us the full code for your cart page?

swood85 · Aug 11th 2019

Good evening Drew,

Sure, my cart is simply my site header, then my body containing this:

PHP

<section class="main-content cart">
<?php perch_shop_cart(); ?>
</section>

Then my footer.

drewm · Aug 12th 2019

Is there anything you're aware of on your site that would prevent cookies being set?

swood85 · Aug 20th 2019

Sorry for the delay Drew, been on holiday.

Not that i can think of, I can see Google Analytics etc using cookies.

I haven't purchased my SSL yet, but that shouldn't stop it?

drewm · Aug 21st 2019

Do you have PERCH_SSL set when it's not in place?

swood85 · Aug 21st 2019

No i haven't set perch_ssl true or false anywhere, so it will be as default.

A quick thought, even though the cookie isn't being set, as there is an item in the basket, shouldn't

<?php perch_shop_cart_item_count(); ?>

show 1 item?

Or does this pull from the cookie?

drewm · Aug 22nd 2019

It identifies the correct basket using a session cookie, yes.

swood85 · Aug 22nd 2019

It's really odd. there is nothing showing in local storage or session storage, and there are 4 cookies for my site:

PHPSESSID = 2760f90c91bdd4b1c5

_ga = GA1.2.

_gid = GA1.2.

cmsa = 1

Does Perch suppress console errors? I would expect it to tell me if it tried to set a cookie and failed.

This is happening in chrome and firefox, so can't be a browser setting. It must be something i have done in Perch or on my server...

swood85 · Aug 30th 2019

So as I have now got a fresh install, i have only tried to add the basic to see if i can get this working...

But I am still having the same issue...

This only thing I have changed from the 'default template' is the cart url from /shop/cart to just /cart

Do i need to update this somewhere in my perch settings? I cannot think what else could be wrong, as my server cannot block cookies, and i have tried on several browsers. I can see the url is set in PerchShop_Cart.class.php incorrectly with /shop/.. is this a problem?

PHP

<?php
class PerchShop_Cart extends PerchShop_Factory
{
public $static_fields = [];
protected $table = 'shop_cart';
protected $pk = 'cartID';
public $singular_classname = 'PerchShop_Cart';
protected $index_table = '';
protected $master_template = 'shop/cart/cart.html';
protected $default_sort_column = '';
protected $created_date_column = '';

Display More

hus_hmd · Aug 31st 2019

Quote from swood85

This only thing I have changed from the 'default template' is the cart url from /shop/cart to just /cart

The cart page URL is not significant. You can set it to whatever you need.

Quote from swood85

I can see the url is set in PerchShop_Cart.class.php incorrectly with /shop/.. is this a problem?

This is a path to the template (not a URL) and is also not significant to your cart page URL.

Quote from swood85

Does Perch suppress console errors?

It does not.

Quote from swood85

Just to add, I think it has something to do with the cart number which keeps increasing!

I think Perch Shop automatically instantiate a new cart if the current PHP session has no cart linked to it. So this sounds like the PHP session expires prematurely and a new session is started, hence Perch Shop creating a new instance of the cart when you reload the page.

If you turn on debug and add the following to your page, you will see the session ID in the debug message (highlighted blue):

PHP

PerchUtil::mark(session_id());

Do you keep getting different values when you refresh the page?

swood85 · Sep 4th 2019

Hi Again,

Thank you for helping, I really appreciate it...

I have enabled debugging but your code snippet on my cart page didn't return anything.. If I use the other debug code on cart:

<?php PerchUtil::output_debug(); ?>

I can see the cart id going up every time i refresh.

SELECT * FROM perch3_shop_cart WHERE cartID=78

hus_hmd · Sep 5th 2019

The function PerchUtil::mark() does not output the debug message, It adds a highlighted message. If you are using standard Perch, you need to manually output it PerchUtil::output_debug(). So use both:

PHP

PerchUtil::mark(session_id());
PerchUtil::output_debug();

swood85 · Sep 5th 2019

This is the debug messaging at the bottom of the page:

Code

Debug Message - Perch 3.1.5
[1]SELECT * FROM perch3_pages WHERE pagePath='/cart.php' LIMIT 1
[32]SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1]SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
[1]SELECT * FROM perch3_shop_cart WHERE cartID=128
[1]SELECT itemID, itemQty FROM perch3_shop_cart_items WHERE cartID=128 AND productID=1
[1]SELECT * FROM perch3_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
INSERT INTO perch3_shop_cart_items(productID,itemQty,cartID) VALUES('1',1,'128')
------------------------------ Calculating cart ------------------------------
[1]SELECT * FROM perch3_shop_cart WHERE cartID=128
[1]SELECT * FROM perch3_shop_cart WHERE cartID=128
[1]SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1]SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1]SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_currencies WHERE currencyID=47 LIMIT 1
[1]SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=128
Tax mode: inc
[1]SELECT * FROM perch3_shop_cart_items WHERE cartID=128 ORDER BY itemID ASC
[1]SELECT * FROM perch3_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1]SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1]SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1]SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[nil]SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2019-09-05 20:15:00' AND promoTo>'2019-09-05 20:15:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
UPDATE perch3_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='0.00', cartTotalWithoutTax='0.00' WHERE cartID='128'
INSERT INTO perch3_shop_cart_data(cartID,productID,cartData) VALUES('128','1','{\"product\":\"1\"}')
[1]Using template: /addons/apps/perch_shop/templates/shop/cart/cart.html
------------------------------ ------------------------------
Array
(
[type] => 2
[message] => Cannot modify header information - headers already sent by (output started at /homepages/30/htdocs/cart.php:1)
[file] => /homepages/30/htdocs/perch/addons/apps/perch_shop/lib/PerchShop_Session.class.php
[line] => 34
)

Display More

If i refresh, the product stays but the cart ID increments:

SELECT * FROM perch3_shop_cart WHERE cartID=129

And if I navigate to /cart from this page, the page reloads empty with the next cart id:

SELECT * FROM perch3_shop_cart WHERE cartID=130

swood85 · Sep 12th 2019

Hi Hussein, Drew,

It really saddens me to tell you this, but due to the lack of support I have had to switch from Perch to CubeCart!

I have fallen way behind on the delivery of my website and without being able to keep a product in my basket and proceed to checkout is a huge blocker.

I will reuse my licence for another site as I do feel Perch is a fantastic CMS, I just will not use it for any of my transactional sites.

I would like to ask, when you start charging for support with the next version, are you going to be stepping up your support model? As I would not be happy if I had paid anymore for my license including support and this is what I received.

All I received was questions to help identify my issue, which is completely understandable, but then silence! Not one suggestion on how to resolve.

Like I said, I am not trying to act like a moody customer, I love Perch as a CMS, but i just feel the documentation and support is not quite there for a shop and I hope my feedback will help. Maybe Runway is better for that... and that should be the only shopping platform...

drewm · Sep 13th 2019

Shop is generally designed for use with Perch Runway. We don't prevent it being used with Perch, but that's not what it's designed for.

montlewis · Sep 13th 2019

I've seen this happen when I was not enforcing SSL on some pages on a site. In other words, a visit to a non-ssl page would empty the cart of it's contents. So check that your all your pages are visited through SSL