Currency conversion

[Jamie]

One of our customers mentioned a free currency conversion utility that some of you may be interested in:
http://dynamicconverter.com/

I just tried it in Squirrelcart, and it works OK. You need to follow their instructions, and paste their code directly before the closing </body> tag in your storefront page (store.php by default).

It doesn't seem to convert prices in drop down product option fields (select tags) by default. Their documentation indicates that to do so, you need to add an "id" attribute set to "convert". This is bad practice as id attributes must only be used once per page. I sent them an email to see if there is another way to handle that.

[Jamie]

We've done some more testing, and have it fully working. Here are the setup instructions for this:

1. Copy the Javascript code for Dynamic Converter that they provide you to your clipboard

2. In version 3.x:
open the template file store_main.tpl.php (see this page for instructions on modifying template files).

In version 2.x:
Open your storefront page (store.php by default)

3. Locate the closing body tag:

</body>

4. Paste their Javascript directly befopre that closing body tag

5. Save the file

6. Open the template file option_select.tpl.php in an editor
Important - See this page for instructions on modifying templates:
http://squirrelcart.com/help/?Modify...Templates.html

7. Locate the select tag, and find the class attribute:

class="<?=$Missing_BG_Class?>"

Add a "dcconvert" class inside the quotes:

class="<?=$Missing_BG_Class?> dcconvert"

8. Save the file

If you aren't using the QuickTotal module, stop here.

9. Open squirrelcart/modules/quick_total/quick_total.js.php in an editor

10. Scroll to the very bottom of the file, and find this code:

    // update item total on product page
    prodTotalTag.innerHTML = '<?php print $SC['settings']['Currency_Symbol']?>' + prodTotal;
    
}

</script>

11. Before the closing brace } add this:

    // call dynamic convertor
    if  (window.dc_convert_now) dc_convert_now();

The bottom of that file should now look like this:

    // update item total on product page
    prodTotalTag.innerHTML = '<?php print $SC['settings']['Currency_Symbol']?>' + prodTotal;
    
    // call dynamic convertor
    if  (window.dc_convert_now) dc_convert_now();
}

</script>

12. Save the file

[welshandy]

This is great Jamie. Thanks for letting us know about this. Works a treat!

[elyptic]

Excellent find, thanks Jamie.

[SketchWork]

Hi Jamie,

Does this still work in the current version of SquirrelCart or has the code changed too much?

Many thanks,

Justin

[Jamie]

Yes, the instructions above include instructions for version 3.x.

[Jamie]

I just added this for someone. The currency conversion script was not detecting the prices because we wrap the currency prefix and suffix in span tags so you could target them via CSS. If you have trouble getting this script to work, try changing the content of the price_html.tpl.php template file from this:

<?php /* This line prevents direct access to template. Don't remove it. */ if (!defined('SC_INCLUDE_OK')) die; ?>
<!-- Template: <?php print basename(__FILE__) ?> -->

<span class="sc_amount">
    <?php if (SC_CURRENCY_PREFIX): ?>
        <span class="currency_prefix"><?php print SC_CURRENCY_PREFIX ?></span>
    <?php endif; ?>
    <?php print $Amount ?>
    <?php if (SC_CURRENCY_SUFFIX): ?>
        <span class="currency_suffix"><?php print SC_CURRENCY_SUFFIX ?></span>
    <?php endif; ?>
</span>

to this:

<?php /* This line prevents direct access to template. Don't remove it. */ if (!defined('SC_INCLUDE_OK')) die; ?>
<!-- Template: <?php print basename(__FILE__) ?> -->

<span class="sc_amount">
    <?php if (SC_CURRENCY_PREFIX): ?><?php print SC_CURRENCY_PREFIX ?><?php endif; ?><?php print $Amount ?><?php if (SC_CURRENCY_SUFFIX): ?> <?php print SC_CURRENCY_SUFFIX ?><?php endif; ?>
</span>

[bgjbgj]

The code I have for the file "option_select.tpl.php" is different from the above (I'm using 3.4.1).
Jamie, would you clarify the changes please.

[Jamie]

I updated that step above.