Posts by swood85

swood85 · Sep 15th 2019

Hi Hussein,

I don't want to start an argument, but you say, you could of re-asked the question... Is that the refresh values question??

I answered it twice in 2 separate posts..

Quote from swood85

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

SELECT * FROM perch3_shop_cart WHERE cartID=78

Quote from swood85

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

I mentioned on 20th August I hadn't purchased my SSL yet, and a fellow developer Montlewis has mentioned that SSL could be an issue. What are your thoughts?

Too late for me but may help anyone else who gets this issue.

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...

swood85 · Sep 8th 2019

Hi Hussein,

I thought i was getting somewhere with this, but i have noticed that when the user selects a radio button nothing changes anywhere on the front end for me to hinge changes to.

How does the checkout button know the selection?

Not even the product id or slug changes,

Thanks,

Sam

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 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

swood85 · Sep 3rd 2019

Hi Hus-hmd,

Thank you for your reply.

Ok I appreciate there is no JavaScript updating the page, but when the customer makes a selection is anything updated to let the browser know a price could potentially be different. I can build the functionality, but I cannot see how i can get all the prices out for each combination, or how to hinge the update on a customer selection?

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

swood85 · Aug 30th 2019

Hi Drew,

Not sure if you have had a chance to read my response above, but does it look correct, should the price be updating on the front end to my users?

Cheers,

Sam

swood85 · Aug 30th 2019

As this thread seems to have gone cold and I couldn't work out the issue, I have created a new site from scratch using a new SQL database...

Not ideal, but my project is now running late...

I can confirm though that the images are now working (although I have only added one, but i do keep checking it) and I am trying to copy my templates over slowly then checking image upload to see if I can isolate the issue for others that will come across it.

I am still having issues with my cart persisting though, which worries me.

swood85 · Aug 23rd 2019

I didn't set up a local server for this project as it's a new site.

Do you think that is worth testing now?

swood85 · Aug 22nd 2019

I have decided to try and delete all traces of all images uploaded. In case I have a corrupt file somewhere.

I have deleted all the assets from the asset folder in Perch, I have deleted the gallery album I added. I have gone into each component and deleted any image links there was.

I also found a list of images in Perch/Resources and deleted them.

Is there anywhere else, or in any database tables that I should clear?

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 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?

swood85 · Aug 20th 2019

Drew, or anyone, have any help or advice for my issue here?

swood85 · Aug 20th 2019

I think i am using the general product price...

i have this code on my product page php:

PHP

<?php
perch_shop_product($prodSlug, [
'variants' => 'true'
]);
?>

And this is my product template html: (ignore the div markup, i have removed some of it to make it easier to read)

Code

<h1><perch:shop id="title" type="text" label="Title" required="true" order="2" /></h1>
<div>
<perch:shop id="on_sale" type="checkbox" value="1" label="Use sale price" order="11" suppress="true" />
<perch:if id="on_sale" value="1" match="neq">
<span class="current-price">
<perch:shop id="price" type="shop_currency_value" label="Price" size="s" min="0" step="any" order="9" />
</span>
<span class="vatable">
<perch:shop id="tax_group" type="shop_tax_group" label="Tax group" required="true" divider-before="Pricing and VAT" order="8" />
</span>
<perch:else>
<span class="current-price current-price--reduced">
<perch:shop id="sale_price" type="shop_currency_value" label="Sale price" size="s" min="0" step="any" order="10" />
</span>
<span class="was-price">
<perch:shop id="price" type="shop_currency_value" label="Price" size="s" min="0" step="any" order="9" />
</span>
<span class="vatable">
<perch:shop id="tax_group" type="shop_tax_group" label="Tax group" required="true" divider-before="Pricing and VAT" order="8" />
</span>
</perch:if>
</div>
<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">
<div class="options-container">
<perch:productopts>
<div class="option-block">
<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">
<span><perch:productvalue id="valueTitle"></span>
</label>
</li>
<perch:after></ul></perch:after>
</perch:productvalues>
</div>
</perch:productopts>
</div>
</perch:if>
<perch:input id="product" type="hidden" value="<perch:shop id="productID" type="hidden" env-autofill="false">">
<perch:input class="btn" type="submit" value="Add to basket">
</perch:form>
<perch:else>
<p>This item is available in-store only.</p>
</perch:if>
<perch:shop id="sku" type="text" label="SKU" required="true" order="1" />
</div>
<perch:variants>
<perch:variant id="sku" type="text">
<perch:variant id="price" type="shop_currency_value">
</perch:variants>

Display More

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?

swood85 · Aug 11th 2019

Hi All,

A quick 'how would i...'

I have a product, for example a t-shirt, and if when the product page loads the default price is £10, and size options are presented X-Small -> XXX-Large.

If anyone selects, XX-Large or XXX-Large I want the price to increase, for example to £15. (These are purely examples and not my business model!)

So in the Perch products (I have the Shop add on installed) I created my base product and added the size option variants, then went into the XXL and XXXL and have overridden the price, however, when the user selects the size the price shows 10 but in the basket shows 15. Is there a way I can dynamically update the product page so the customer knows before adding to basket?

I can list the variants and their respective prices, but i cannot get the product SKU or price to update on selection change.

Thank you,

Sam

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.

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

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?

Posts by swood85

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

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

Product with different variant options and prices

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

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

Product with different variant options and prices

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

Product with different variant options and prices

'Select or upload an image' not doing anything anymore

'Select or upload an image' not doing anything anymore

'Select or upload an image' not doing anything anymore

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

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

'Select or upload an image' not doing anything anymore

Product with different variant options and prices

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

Product with different variant options and prices

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

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

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