Vouchers won't work after upgrading to prestashop 1.4

zoveress · March 26, 2011

Hi,

I am trying to create a voucher but event though I have it correctly defined I am unable to add the voucher to the order at checkout.
I type in the voucher code, click on ADD and nothing actually happens. Anyone had the same issue?

This was working perfectly from 1.3.1 :S

Regards
Z.

jamiedickinson · March 26, 2011

I have same issue!

zoveress · March 26, 2011

I found this error in the log when I try to add the voucher:

[26-Mar-2011 17:27:13] PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zoveress/public_html/megaperfumeshop.com/classes/MySQL.php on line 167

I think there is something missing from the database. Anyone can help debugging this? Is there a debug option in prestashop?

jamiedickinson · March 27, 2011

Had to upgrade with a new 1.4 theme which wasn't ideal. Soooo many bugs i'm experiencing in 1.4 really needs to try and get back to 1.3.7 if anyone know if this is possible!?

salko · March 28, 2011

I have Prestashop 1.4 and I have same issue, when adding voucher to the Shopping cart summary nothing happens. Please help!

prt · March 29, 2011

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***/public_html/***/classes/MySQL.php on line 167

i am getting this msg, every time i go to the Categories on the home page, and choose one of the, so i get this notice.
as well, in some parts i can not see images, they appear as broken view. And it happened not long time ago, as even some hours ago it was all good, and i have not done any changes.
So, this is really strange..
i hope to get the answer too, as soon as it is possible.
Hope it could be solved... Thanks

prt · March 29, 2011

just to let you know all, i have found the problem for my self. on prestashop 1.4.017 i have installed the Layered navigation block v1.3 PrestaShop which displays a block with layered navigation filters, and now i tried to delete it, and it worked! i dont have this problem any more.
This module was in 1.4.017, but looks like it is not working... so, i hope you guys will figure it out too.

salko · March 31, 2011

just to let you know all, i have found the problem for my self. on prestashop 1.4.017 i have installed the Layered navigation block v1.3 PrestaShop which displays a block with layered navigation filters, and now i tried to delete it, and it worked! i dont have this problem any more.
This module was in 1.4.017, but looks like it is not working... so, i hope you guys will figure it out too.

Can you describe exactly what you did step-by-step to make vouchers work in 1.4?? I have a webshop opening in a less than a month and I would like to offer opening discount with vouchers so I really need this vouchers function working ... Thank you!

salko · April 3, 2011

just to let you know all, i have found the problem for my self. on prestashop 1.4.017 i have installed the Layered navigation block v1.3 PrestaShop which displays a block with layered navigation filters, and now i tried to delete it, and it worked! i dont have this problem any more.
This module was in 1.4.017, but looks like it is not working... so, i hope you guys will figure it out too.

Can you describe exactly what you did step-by-step to make vouchers work in 1.4?? I have a webshop opening in a less than a month and I would like to offer opening discount with vouchers so I really need this vouchers function working ... Thank you!

Bump!

zoveress · April 8, 2011

I found a solution... The 5 page standard checkout wont throw an error. My problem was that products marked "on sale" won't avail to reduction unless you check "Cumulative with price reductions" option in at your voucher. Since there was no error message I couldnt figure this out. I switched to one page checkout from the general settings and voila. I could easily figure this out. The only question I have here is why is the SQL error??? So before you try anything else try this!

airelibre · April 11, 2011

If this can help : I had the same problem, and it came from the theme. You should copy/paste all the <form></form> code from the original prestashop theme, file : shopping-cart.tpl

troyrob · April 13, 2011

Did that work for you?

I'll have to try that later.

airelibre · April 14, 2011

Yes it did. Lots of theme scripts changed since Prestashop 1.4, and this shopping cart problem is only one example...

DenisDenis · April 24, 2011

This didn't seem to work for me... anyone had any luck with this?
When i look in shopping-cart.tpl of my theme it seems to be the same as the original shoping-cart.tpl...

ysco · May 12, 2011

Seems that it has something to do with OrderOpcController.php from the controller folder.

Rename the OrderOpcController.php to OrderOpcController.php.bak and add the latest OrderOpcController.php from SVN and see if that is working for you.

Always make sure you have a backup before testing and changing things in case you screw up

ysco..

BWT · May 23, 2011

If your using a custom theme and can't get the voucher code to work in the shopping cart after you have updated your version of prestashop check your shopping-cart.tpl file in your theme folder and make sure that the code contains the full form code for the newest version 1.4.

download the code from the newest version of prestashop if you have a custom theme try adding this in place of the <form> code in your custom theme. only replace the "form" portion of the code in the shopping-cart.tpl file! The download and the code posted to this topic are the same

     <form action="{if $opc}{$link->getPageLink('order-opc.php', true)}{else}{$link->getPageLink('order.php', true)}{/if}" method="post" id="voucher">

{l s='Vouchers'}


{l s='Code:'}
               <input type="text" id="discount_name" name="discount_name" value="{if isset($discount_name) && $discount_name}{$discount_name}{/if}" />


<input type="hidden" name="submitDiscount" /><input type="submit" name="submitAddDiscount" value="{l s='Add'}" class="button" />
       {if $displayVouchers}
{l s='Take advantage of our offers:'}

           {foreach from=$displayVouchers item=voucher}
{$voucher.name} - {$voucher.description} 

           {/foreach}

       {/if}

   </form>

copy-form-code-and-replace-with-this.txt

bozor2 · July 31, 2013

Hi T-Bone,

I've prestashop version 1.4.6

I've checked your post file and I've matched with my shopping-cart and are the same lines codes.

My voucher code (example 10% off) don't apply at cart summary and tell me the error "don't possible applied this voucher or don't valid"

can you help me?

Attached my shopping-cart.tpl

bozor2 · July 31, 2013

Sorry, my file it's here...

{capture name=path}{l s='Your shopping cart'}{/capture}

{include file="$tpl_dir./breadcrumb.tpl"}

<h1 id="cart_title">{l s='Shopping cart summary'}</h1>

{assign var='current_step' value='summary'}

{include file="$tpl_dir./order-steps.tpl"}

{include file="$tpl_dir./errors.tpl"}

{if isset($empty)}

<p class="warning">{l s='Your shopping cart is empty.'}</p>

{elseif $PS_CATALOG_MODE}

<p class="warning">{l s='This store has not accepted your new order.'}</p>

{else}

// <![CDATA[

var currencySign = '{$currencySign|html_entity_decode:2:"UTF-8"}';

var currencyRate = '{$currencyRate|floatval}';

var currencyFormat = '{$currencyFormat|intval}';

var currencyBlank = '{$currencyBlank|intval}';

var txtProduct = "{l s='product'}";

var txtProducts = "{l s='products'}";

// ]]>

</script>

<p style="display:none" id="emptyCartWarning" class="warning">{l s='Your shopping cart is empty.'}</p>

{if isset($lastProductAdded) AND $lastProductAdded}

{foreach from=$products item=product}

{if $product.id_product == $lastProductAdded.id_product AND (!$product.id_product_attribute OR ($product.id_product_attribute == $lastProductAdded.id_product_attribute))}

<div class="left">{l s='Last added product'}</div>

</div>

<a class="cart_last_product_img" href="{$link->getProductLink($product.id_product, $product.link_rewrite, $product.category)|escape:'htmlall':'UTF-8'}"><img src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'small')}" alt="{$product.name|escape:'htmlall':'UTF-8'}"/></a>

<h5><a href="{$link->getProductLink($product.id_product, $product.link_rewrite, $product.category)|escape:'htmlall':'UTF-8'}">{$product.name|escape:'htmlall':'UTF-8'}</a></h5>

{if isset($product.attributes) && $product.attributes}<a href="{$link->getProductLink($product.id_product, $product.link_rewrite, $product.category)|escape:'htmlall':'UTF-8'}">{$product.attributes|escape:'htmlall':'UTF-8'}</a>{/if}

</div>

</div>

{/if}

{/foreach}

{/if}

<p>{l s='Your shopping cart contains'} <span id="summary_products_quantity">{$productNumber} {if $productNumber == 1}{l s='product'}{else}{l s='products'}{/if}</span></p>

<thead>

<tr>

<th class="cart_product first_item">{l s='Product'}</th>

<th class="cart_description item">{l s='Description'}</th>

<th class="cart_availability item">{l s='Avail.'}</th>

<th class="cart_unit item">{l s='Unit price'}</th>

<th class="cart_total last_item">{l s='Total'}</th>

</tr>

</thead>

<tfoot>

{if $use_taxes}

{if $priceDisplay}

<td colspan="6">{l s='Total products'}{if $display_tax_label} {l s='(tax excl.)'}{/if}{l s=':'}</td>

<td class="price" id="total_product">{displayPrice price=$total_products}</td>

</tr>

{else}

<td colspan="6">{l s='Total products'}{if $display_tax_label} {l s='(tax incl.)'}{/if}{l s=':'}</td>

<td class="price" id="total_product">{displayPrice price=$total_products_wt}</td>

</tr>

{/if}

{else}

<td colspan="6">{l s='Total products:'}</td>

<td class="price" id="total_product">{displayPrice price=$total_products}</td>

</tr>

{/if}

{if $use_taxes}

{if $priceDisplay}

{l s='Total vouchers'}{if $display_tax_label} {l s='(tax excl.)'}{/if}{l s=':'}

{else}

{l s='Total vouchers'}{if $display_tax_label} {l s='(tax incl.)'}{/if}{l s=':'}

{/if}

{else}

{l s='Total vouchers:'}

{/if}

</td>

{if $use_taxes}

{if $priceDisplay}

{displayPrice price=$total_discounts_tax_exc}

{else}

{displayPrice price=$total_discounts}

{/if}

{else}

{displayPrice price=$total_discounts_tax_exc}

{/if}

</td>

</tr>

{if $use_taxes}

{if $priceDisplay}

{l s='Total gift-wrapping'}{if $display_tax_label} {l s='(tax excl.)'}{/if}{l s=':'}

{else}

{l s='Total gift-wrapping'}{if $display_tax_label} {l s='(tax incl.)'}{/if}{l s=':'}

{/if}

{else}

{l s='Total gift-wrapping:'}

{/if}

</td>

{if $use_taxes}

{if $priceDisplay}

{displayPrice price=$total_wrapping_tax_exc}

{else}

{displayPrice price=$total_wrapping}

{/if}

{else}

{displayPrice price=$total_wrapping_tax_exc}

{/if}

</td>

</tr>

{if $use_taxes}

{if $priceDisplay}

<td colspan="6">{l s='Total shipping'}{if $display_tax_label} {l s='(tax excl.)'}{/if}{l s=':'}</td>

<td class="price" id="total_shipping">{displayPrice price=$shippingCostTaxExc}</td>

</tr>

{else}

<td colspan="6">{l s='Total shipping'}{if $display_tax_label} {l s='(tax incl.)'}{/if}{l s=':'}</td>

<td class="price" id="total_shipping" >{displayPrice price=$shippingCost}</td>

</tr>

{/if}

{else}

<td colspan="6">{l s='Total shipping:'}</td>

<td class="price" id="total_shipping" >{displayPrice price=$shippingCostTaxExc}</td>

</tr>

{/if}

{if $use_taxes}

{if $display_tax_label}

{l s='Total (tax excl.):'}

{else}

{l s='Subtotal:'}

{/if}

</td>

<td class="price" id="total_price_without_tax">{displayPrice price=$total_price_without_tax}</td>

</tr>

{if $display_tax_label}

{l s='Total tax:'}

{else}

{l s='Estimated Sales Tax:'}

{/if}

</td>

<td class="price" id="total_tax">{displayPrice price=$total_tax}</td>

</tr>

{if $display_tax_label}

{l s='Total (tax incl.):'}

{else}

{l s='Total:'}

{/if}

</td>

<td class="price" id="total_price">{displayPrice price=$total_price}</td>

</tr>

{else}

<td colspan="6">{l s='Total:'}</td>

<td class="price" id="total_price">{displayPrice price=$total_price_without_tax}</td>

</tr>

{/if}

<td colspan="6" style="white-space: normal;">{l s='Remaining amount to be added to your cart in order to obtain free shipping:'}</td>

<td id="free_shipping" class="price">{displayPrice price=$free_ship}</td>

</tr>

</tfoot>

<tbody>

{foreach from=$products item=product name=productLoop}

{assign var='productId' value=$product.id_product}

{assign var='productAttributeId' value=$product.id_product_attribute}

{assign var='quantityDisplayed' value=0}

{* Display the product line *}

{include file="$tpl_dir./shopping-cart-product-line.tpl"}

{* Then the customized datas ones*}

{if isset($customizedDatas.$productId.$productAttributeId)}

{foreach from=$customizedDatas.$productId.$productAttributeId key='id_customization' item='customization'}

{foreach from=$customization.datas key='type' item='datas'}

{if $type == $CUSTOMIZE_FILE}

{foreach from=$datas item='picture'}<li><img src="{$pic_dir}{$picture.value}_small" alt="" class="customizationUploaded" /></li>{/foreach}

</ul>

</div>

{elseif $type == $CUSTOMIZE_TEXTFIELD}

{foreach from=$datas item='textField' name='typedText'}<li>{if $textField.name}{$textField.name}{else}{l s='Text #'}{$smarty.foreach.typedText.index+1}{/if}{l s=':'} {$textField.value}</li>{/foreach}

</ul>

{/if}

{/foreach}

</td>

<a rel="nofollow" class="cart_quantity_delete" id="{$product.id_product}_{$product.id_product_attribute}_{$id_customization}" href="{$link->getPageLink('cart.php', true)}?delete&id_product={$product.id_product|intval}&ipa={$product.id_product_attribute|intval}&id_customization={$id_customization}&token={$token_cart}"><img src="{$img_dir}icon/delete.gif" alt="{l s='Delete'}" title="{l s='Delete this customization'}" width="11" height="13" class="icon" /></a>

</div>

<a rel="nofollow" class="cart_quantity_up" id="cart_quantity_up_{$product.id_product}_{$product.id_product_attribute}_{$id_customization}" href="{$link->getPageLink('cart.php', true)}?add&id_product={$product.id_product|intval}&ipa={$product.id_product_attribute|intval}&id_customization={$id_customization}&token={$token_cart}" title="{l s='Add'}"><img src="{$img_dir}icon/quantity_up.gif" alt="{l s='Add'}" width="14" height="9" /></a><br />

{if $product.minimal_quantity < ($customization.quantity -$quantityDisplayed) OR $product.minimal_quantity <= 1}

<a rel="nofollow" class="cart_quantity_down" id="cart_quantity_down_{$product.id_product}_{$product.id_product_attribute}_{$id_customization}" href="{$link->getPageLink('cart.php', true)}?add&id_product={$product.id_product|intval}&ipa={$product.id_product_attribute|intval}&id_customization={$id_customization}&op=down&token={$token_cart}" title="{l s='Subtract'}">

</a>

{else}

</a>

{/if}

</div>

</td>

</tr>

{assign var='quantityDisplayed' value=$quantityDisplayed+$customization.quantity}

{/foreach}

{* If it exists also some uncustomized products *}

{if $product.quantity-$quantityDisplayed > 0}{include file="$tpl_dir./shopping-cart-product-line.tpl"}{/if}

{/if}

{/foreach}

</tbody>

{if sizeof($discounts)}

<tbody>

{foreach from=$discounts item=discount name=discountLoop}

<td class="cart_discount_name" colspan="2">{$discount.name}</td>

<td class="cart_discount_description" colspan="3">{$discount.description}</td>

<td class="cart_discount_delete"><a href="{if $opc}{$link->getPageLink('order-opc.php', true)}{else}{$link->getPageLink('order.php', true)}{/if}?deleteDiscount={$discount.id_discount}" title="{l s='Delete'}"><img src="{$img_dir}icon/delete.gif" alt="{l s='Delete'}" class="icon" width="11" height="13" /></a></td>

{if $discount.value_real > 0}

{if !$priceDisplay}{displayPrice price=$discount.value_real*-1}{else}{displayPrice price=$discount.value_tax_exc*-1}{/if}

{/if}

</span></td>

</tr>

{/foreach}

</tbody>

{/if}

</table>

</div>

{if $voucherAllowed}

{if isset($errors_discount) && $errors_discount}

{foreach from=$errors_discount key=k item=error}

<li>{$error|escape:'htmlall':'UTF-8'}</li>

{/foreach}

</ul>

{/if}

<form action="{if $opc}{$link->getPageLink('order-opc.php', true)}{else}{$link->getPageLink('order.php', true)}{/if}" method="post" id="voucher">

<h4>{l s='Vouchers'}</h4>

<p>

</p>

{if $displayVouchers}

<h4>{l s='Take advantage of our offers:'}</h4>

{foreach from=$displayVouchers item=voucher}

<span onclick="$('#discount_name').val('{$voucher.name}');return false;" class="voucher_name">{$voucher.name}</span> - {$voucher.description} <br />

{/foreach}

</div>

{/if}

</fieldset>

</form>

</div>

{/if}

<div id="HOOK_SHOPPING_CART">{$HOOK_SHOPPING_CART}</div>

{* Define the style if it doesn't exist in the PrestaShop version*}

{* Will be deleted for 1.5 version and more *}

{if !isset($addresses_style)}

{$addresses_style.company = 'address_company'}

{$addresses_style.vat_number = 'address_company'}

{$addresses_style.firstname = 'address_name'}

{$addresses_style.lastname = 'address_name'}

{$addresses_style.address1 = 'address_address1'}

{$addresses_style.address2 = 'address_address2'}

{$addresses_style.city = 'address_city'}

{$addresses_style.country = 'address_country'}

{$addresses_style.phone = 'address_phone'}

{$addresses_style.phone_mobile = 'address_phone_mobile'}

{$addresses_style.alias = 'address_title'}

{/if}

{if (($carrier->id AND !isset($virtualCart)) OR $delivery->id OR $invoice->id) AND !$opc}

{if !isset($formattedAddresses)}

{if $delivery->id}

<li class="address_title">{l s='Delivery address'}</li>

{if $delivery->company}<li class="address_company">{$delivery->company|escape:'htmlall':'UTF-8'}</li>{/if}

<li class="address_name">{$delivery->firstname|escape:'htmlall':'UTF-8'} {$delivery->lastname|escape:'htmlall':'UTF-8'}</li>

<li class="address_address1">{$delivery->address1|escape:'htmlall':'UTF-8'}</li>

{if $delivery->address2}<li class="address_address2">{$delivery->address2|escape:'htmlall':'UTF-8'}</li>{/if}

<li class="address_city">{$delivery->postcode|escape:'htmlall':'UTF-8'} {$delivery->city|escape:'htmlall':'UTF-8'}</li>

<li class="address_country">{$delivery->country|escape:'htmlall':'UTF-8'} {if $delivery_state}({$delivery_state|escape:'htmlall':'UTF-8'}){/if}</li>

</ul>

{/if}

{if $invoice->id}

<li class="address_title">{l s='Invoice address'}</li>

{if $invoice->company}<li class="address_company">{$invoice->company|escape:'htmlall':'UTF-8'}</li>{/if}

<li class="address_name">{$invoice->firstname|escape:'htmlall':'UTF-8'} {$invoice->lastname|escape:'htmlall':'UTF-8'}</li>

<li class="address_address1">{$invoice->address1|escape:'htmlall':'UTF-8'}</li>

{if $invoice->address2}<li class="address_address2">{$invoice->address2|escape:'htmlall':'UTF-8'}</li>{/if}

<li class="address_city">{$invoice->postcode|escape:'htmlall':'UTF-8'} {$invoice->city|escape:'htmlall':'UTF-8'}</li>

<li class="address_country">{$invoice->country|escape:'htmlall':'UTF-8'} {if $invoice_state}({$invoice_state|escape:'htmlall':'UTF-8'}){/if}</li>

</ul>

{/if}

{else}

{foreach from=$formattedAddresses item=address name=myLoop}

<li class="address_title">{$address.object.alias}</li>

{foreach from=$address.ordered name=adr_loop item=pattern}

{assign var=addressKey value=" "|explode:$pattern}

<li>

{foreach from=$addressKey item=key name="word_loop"}

{$address.formated[$key]|escape:'htmlall':'UTF-8'}

</span>

{/foreach}

</li>

{/foreach}

</ul>

{/foreach}

{/if}

{if $carrier->id AND !isset($virtualCart)}

<h4>{l s='Carrier:'}</h4>

{if isset($carrierPicture)}<img src="{$img_ship_dir}{$carrier->id}.jpg" alt="{l s='Carrier'}" />{/if}

<span>{$carrier->name|escape:'htmlall':'UTF-8'}</span>

</div>

{/if}

</div>

{/if}

{if !$opc}<a href="{$link->getPageLink('order.php', true)}?step=1{if $back}&back={$back}{/if}" class="exclusive" title="{l s='Next'}">{l s='Next'} »</a>{/if}

<a href="{if (isset($smarty.server.HTTP_REFERER) && strstr($smarty.server.HTTP_REFERER, $link->getPageLink('order.php'))) || !isset($smarty.server.HTTP_REFERER)}{$link->getPageLink('index.php')}{else}{$smarty.server.HTTP_REFERER|escape:'htmlall':'UTF-8'|secureReferrer}{/if}" class="button_large" title="{l s='Continue shopping'}">« {l s='Continue shopping'}</a>

</p>

<span id="HOOK_SHOPPING_CART_EXTRA">{$HOOK_SHOPPING_CART_EXTRA}</span>

</p>

{/if}

Vouchers won't work after upgrading to prestashop 1.4

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in