Fetch and display shopping basket of current user

Friday 28 November 2008 2:03:23 am

I used the fetch function as described in the documentation. Have used the following code to display shopping basket of current user on every product page.

{def $basket=fetch( 'shop', 'basket' )}
 
{if $basket.is_empty}
 
    There are no products in the basket.
 
{else}
 
    There are {count( $basket.items )} items in the basket.  <br />
    Total price (ex. VAT) :  {$basket.total_ex_vat|l10n( currency )} <br />
    Total price (inc. VAT):  {$basket.total_inc_vat|l10n( currency )}<br>

     <strong>{$total_inc_shipping_ex_vat|l10n( 'currency', $locale, $symbol )}</strong>
 
{/if}

{undef $basket}

This outputs the result for the first time but when adding more items "i.e after clicking the continue shopping button", the code does not update the count and total from shopping basket.

Please guide me with the code.

Thanks in advance!

Monday 01 December 2008 6:41:42 am

Hi Sejal,

try adding this line at the top of your product template:

{set-block scope=global variable=cache_ttl}0{/set-block}

If this works, it means that the data is cached and therefore not updated...

</Pascal>

Tuesday 02 December 2008 1:03:08 am

Hi Sejal,

If disabling view caching is working, this means that your basket fetch is done in a view template (an override of node/view/*.tpl)... If you don't want to experience some performance issues, you should replace your code in the pagelayout or in a template included in...

Also check SQL queries count in the debug.

Regards

Looking for information about SQLI ?
Looking for a new job in Paris ?
Please contact me at alafon [at] sqli [dot] com

Wednesday 03 December 2008 5:00:52 am

Hi Sejal,

If the product pages represent a large proportion of the visited pages on your site, then they will have an impact on your server load. And If these pages, without caching, generates a lot of MySQL queries, then you'll have serious problems... (how many queries do you have in the ezdebug ?). It's common to say that an ez content page with view caching should generate from 2 to 6 sql queries maximum...

Actually, disabling view caching without adding some cache-block isn't a good solution. As far as you're concerned, adding some cache-block won't be a good solution too, cuz you'll have to expire the cache-block each time something is done in the user basket...

So you have 2 solutions :
- doing your basket fetch in the pagelayout.tpl, and doing this not in a cache-block...
- If you want to do your fetch in the content view template, then how about doing this with some ajax ?

Looking for information about SQLI ?
Looking for a new job in Paris ?
Please contact me at alafon [at] sqli [dot] com

Thursday 04 December 2008 2:12:26 am

Sorry Sejal, I'm really bad in CSS :D

Looking for information about SQLI ?
Looking for a new job in Paris ?
Please contact me at alafon [at] sqli [dot] com