Forum

Thread tagged as: Question, Shop

Need a little help with manual checkout...

So I have a perch shop installation that works great! I and the client love it... we're successfully selling tickets for a regional symphony orchestra... both individual and season ticket packages... Perch Shop is awesome!

We run the purchases through Braintree and that works very well.

Now I need to a checkout process for when the order is has a grand_total of zero and so I can redirect the user to the manual checkout.

I'm successfully getting the manual checkout and register pages to kick in when needed, but my submit button is not submitting the order to the system...

Here's my code:

checkout-manual.php:

at the top:

    if (perch_member_logged_in() && perch_post('payment_method_nonce'))  {


          // your 'success' return URL
          $return_url = '/';
          $cancel_url = '/';

          perch_shop_checkout('manual', [
            'status' => 'manual_order',
            'return_url' => $return_url,
            'cancel_url' => $cancel_url,
          ]);


        }

then at where the checkout button is:

        perch_shop_form('checkout/confirm.html');

where checkout/confirm.html is:

<div class="box shop minor">
<perch:form id="confirm" app="perch_shop" class="order-confirm">
    <perch:label for="terms">
        <perch:input type="checkbox" value="true" id="terms" cart-property="terms_agreed" required="true" />
        I agree to the terms and conditions.
    </perch:label>
    <div>
        <perch:input type="submit" value="Pay now" class="button" />
    </div>
</perch:form>
</div>

manual_order is an active status with an index of 101.

When I click the button, the page just refreshes... Can you see what might be wrong?

and then two side questions....

What is perch_post('payment_method_nonce')? Do I only need that for Braintree?

Do I need an entry for manual checkout in config/shop.php for manual checkout?

Thank you!

Monty Lewis 2 points

4 years ago

Drew McLellan 2638 points
Perch Support

4 years ago

payment_method_nonce is only set by the Braintree JS, so if you're not using Braintree, don't check for it.

Monty Lewis 2 points

4 years ago

Ok, thanks. Do I need an entry for manual checkout in config/shop.php?

Drew McLellan 2638 points
Perch Support

4 years ago

No - what problem are you seeing?

Monty Lewis 2 points

4 years ago

so: When I click the button, the page just refreshes... Can you see what might be wrong?

by button I mean the button on the checkout/confirm.html template which is called into my manual checkout page.

I guess I'm confused about when the manual orders get submitted... Does it get submitted when the user presses the button presented by checkout/confirm.html?

Drew McLellan 2638 points
Perch Support

4 years ago

Have you removed the nonce check?

If so, turn on debug and see what's happening.

Monty Lewis 2 points

4 years ago

oh. Hold on...

I have this:

    if (perch_member_logged_in())  {

          // your 'success' return URL
          $return_url = '/';
          $cancel_url = '/contact-us';

          perch_shop_checkout('manual', [
            'status' => 'manual_order',
            'return_url' => $return_url,
            'cancel_url' => $cancel_url,
          ]);


        }

If I remove'status' => 'manual_order' it works... But I should be able to pass in the status, no?

Drew McLellan 2638 points
Perch Support

4 years ago

Is that a valid status? Have you checked debug?

Monty Lewis 2 points

4 years ago

it's valid (using key, right?) and enabled and index 101...

Nothing that looks abnormal to me... Don't actually see any reference to status in the debug...

It advances to the success page ('/') but does not add the record to perch if I use'status' => 'manual_order',

Debug seems to be listed twice?

Debug Message - Perch Runway 3.0.8
[32] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /, so not using routes.
Using master page: /templates/pages/home.php
[1] SELECT * FROM perch2_members_sessions WHERE sessionID='352315665fb9edc6ca82927f4dd5843b3ddc7300' AND sessionHttpFootprint='903672353e70b1a5d00aedfb8cde7912ab583358' AND sessionExpires>'2017-07-02 09:27:30' LIMIT 1
User is logged in
[1] SELECT * FROM perch2_pages WHERE pagePath='/' LIMIT 1
[1] SELECT * FROM perch2_shop_cart WHERE cartID=51988
[1] SELECT * FROM perch2_shop_cart WHERE cartID=51988
[nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2017-07-02 13:27:00' AND saleTo>'2017-07-02 13:27:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
[4] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/' OR regionPage='*' ORDER BY regionPage DESC
[12] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/' LIMIT 1
[1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/navigation-main.html
[5] Using template: /templates/navigation/navigation-main-2.html
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch2_shop_cart WHERE cartID=51988
[1] SELECT * FROM perch2_shop_cart WHERE cartID=51988
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_customers WHERE memberID=37
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=51988
[43] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Tax mode: exc
[1] SELECT * FROM perch2_shop_cart_items WHERE cartID=51988 ORDER BY itemID ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=187 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[0] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[0] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=51988
[1] SELECT * FROM perch2_shop_addresses WHERE customerID='37' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
[1] SELECT z.* FROM perch2_shop_shipping_zones z LEFT JOIN perch2_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=237 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[1] SELECT * FROM perch2_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[2] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
Qualifying shipping method ‘Ticket Mailing’
[1] SELECT * FROM perch2_shop_shippings WHERE shippingID='1' AND shippingDeleted IS NULL LIMIT 1
Using shipping zone: Local Ship
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[0] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[4] SELECT * FROM perch2_shop_promotions WHERE promoFrom<='2017-07-02 13:27:00' AND promoTo>'2017-07-02 13:27:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
Promo (SPONSOR-COMP) skipped: discount code not applied.
Promo (Symphony Member) skipped: discount code not applied.
Promo (Comp Tickets) skipped: discount code not applied.
Promo (Paid by Check) qualifies!
Percentage discount promo
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] Using template: /templates/shop/cart/mini.html
Missing variant.
[4] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/subscription-concert/')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[4] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='product_order' AND idx.itemID IN ('102', '106', '84', '95') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[4] Using template: /templates/shop/products/2-column-listing_front.html
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=84 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=84 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='84' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='84' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[13] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=102 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=102 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[5] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='102' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=106 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=106 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[11] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='106' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/season-package%' OR idx.indexKey='_category' AND idx.indexValue='products/season-package'))
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('59') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/products/list.html
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productSlug='201718-season-series-2018season' AND productDeleted IS NULL LIMIT 1
[49] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[10] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='parentID' AND idx.indexValue='')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[8] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('102', '106', '110', '141', '142', '143', '144', '145', '146', '147', '148', '170', '172', '173', '174', '175', '176', '177', '178', '179', '180', '181', '183', '184', '185', '186', '187', '188', '189', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '200', '201', '202', '203', '204', '205', '206', '59', '84', '95') AND idx.itemID NOT IN ('102', '106', '110', '170', '207', '217', '224', '59', '84', '95') WHERE 1=1 AND ((idx.indexKey='parentID' AND idx.indexValue=59)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /addons/apps/perch_shop/templates/shop/products/variant_list.html
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=59 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=59 AND productDeleted IS NULL ORDER BY productOrder ASC
[3] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=59 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=6 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='6' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=7 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='7' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='59' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/' OR regionPage='*')
[6] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=18 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/sponsors/_footer_logos.html
Using template: /templates/mailchimp/subscribe_email_address.html
[5] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/' LIMIT 1
[1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/navigation-footer.html
Using cart from cache.
[1] SELECT * FROM perch2_shop_products WHERE productID=95 AND productDeleted IS NULL LIMIT 1
[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=95 AND productDeleted IS NULL ORDER BY productOrder ASC
[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=95 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=8 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='95' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='8' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
Using template: /templates/shop/cart/your_cart.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=5)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/globals/_phone_number.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=5)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/globals/_email_address_main.html
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=5)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/globals/_social_footer.html

Drew McLellan 2638 points
Perch Support

4 years ago

Is that after calling the checkout function?

Monty Lewis 2 points

4 years ago

So sorry. It was manual_order, not manual-order. Can I buy you a beer? (feel stupid)

Forum

Need a little help with manual checkout...

Monty Lewis 2 points

Drew McLellan 2638 points Perch Support

Monty Lewis 2 points

Drew McLellan 2638 points Perch Support

Monty Lewis 2 points

Drew McLellan 2638 points Perch Support

Monty Lewis 2 points

Drew McLellan 2638 points Perch Support

Monty Lewis 2 points

Drew McLellan 2638 points Perch Support

Monty Lewis 2 points

Drew McLellan 2638 points
Perch Support

Drew McLellan 2638 points
Perch Support

Drew McLellan 2638 points
Perch Support

Drew McLellan 2638 points
Perch Support

Drew McLellan 2638 points
Perch Support