kellyriverstone

Huge THANK YOU for this! Finding a solution to this issue has been driving me crazy since upgrading to 1.7 a couple of years ago. I never dreamed of looking at the robots.txt blocking the style sheets! My god! Such a simple solution to a frustrating issue! Thank you again :)

Scott, This is what I posted a couple years back. This patch job worked for me and a lot of others. Just remember that you're modifying template files so in order to see your changes, the templates need to be recompiled in the back office. I suggest using Incognito or private pages to test so you don't end up seeing caching of unmodified templates in your webbrowser. This patch should have worked for rmx333. If you make modifications like this and don't see any changes - I guarantee the templates either aren't getting recompiled or cache isn't flushed either in the back office or webbrowser or both. Good luck! - K Posted November 17, 2017 I don't know if this will help anyone in this post, but we did a patch job and for the most part fixed totals not showing taxes included. It's been frustrating because clients paying by cheque have been submitting the total without taxes and other clients paying by credit card are questioning why the charged amount is more than the total shown (Total should mean TOTAL OWING including shipping, taxes, and any other charges owing) Under themes\classic\templates\checkout\_partials\cart-summary-totals.tpl near the bottom of the file, find the {block name='cart_summary_total'} and remark out the 2 lines shown and add the 2 lines as shown below the remarked lines: {block name='cart_summary_total'} <div class="cart-summary-line cart-total"> {** <span class="label">{$cart.totals.total.label} {$cart.labels.tax_short}</span> *} {** <span class="value">{$cart.totals.total.value}</span> *} <span class="label">Total (tax + shipping incl.)</span> <span class="value">{$currency.iso_code}{$currency.sign}{$cart.totals.total.amount+$cart.subtotals.tax.amount}</span> </div> {/block} You can also move this whole block down to be under the taxes display block so that the grand total to be paid is the last thing the customer sees rather than the tax line below the total. Then in file order-confirmation-table.tpl, at the bottom of the file find the 2 lines and remarked them out as shown then add the 2 lines below: {** <td><span class="text-uppercase">{$totals.total.label}</span> {$labels.tax_short}</td> *} {** <td>{$totals.total.value}</td> *} <td><span>TOTAL (tax + shipping incl.)</span></td> <td>{$currency.iso_code}{$currency.sign}{$cart.totals.total.amount+$cart.subtotals.tax.amount}</td> Hope this can help others. If anyone can pretty the code on this patch job - it would be appreciated as it doesn't look like a major rush for the Prestashop Team to address. The Forge still doesn't have it assigned for fixing and it has been 9 months since it was noted and reported. Understandably, there are still a lot of major other issues to deal with overall. Cheers, Kelly

Truncating those tables won't change the AUTO INCREMENT value. It just destroys your order history and can possibly break your database. The tables will be empty, but the AUTO INCREMENT operand will still be left at the last known value so truncating will only delete carts and orders and breaks links to other tables that use that information. If you are at this point and willing to delete histories by truncating, you might be better off just doing a fresh install of 1.7.x and starting over clean. Use a migration module to import just your customer information and not the order history. (There should be a few modules available to do this in the PrestaShop add-ons shop). The issue you are dealing with is typically caused by importing order information from a different version into a new database. The table cells are brought over, but the AUTO INCREMENT values of those tables are not. The operands need to be adjusted as Pechy.cz noted in the above threads.

Please see Sebastien MAS and Pechy.cz quotes above. I still maintain you have an issue from migrating. I am not an expert on the versions, but I know there are differences in the database structure between 1.6 and 1.7 and it still sounds like PS_Orders not matching with PS_Carts. If it works sometimes and not others to build a cart - I guarantee this is the problem. Your configuration looks good for 1.7. This confirms you're cart IS being built - but your checkout IS NOT pulling the right cart information. It only makes sense that PS_Orders is not synced with PS_Carts. If you find a solution outside of this post, please update here so others can also benefit.

Just setting the operand of AUTOINCREMENT in ps_cart table 1 or 2 numbers higher than the id_cart in ps_orders table did not work for us. We actually set the AUTOINCREMENT in ps_cart table way further ahead. Our imported database was showing something like a cart value of 1015 so we just started new cart ids at 3000 autoincrementing by 1 after that. THAT fixed our problem. If you are importing data from an older 1.6 store - I challenge your cart number only being at 30. That number sounds really small unless you don't get much traffic on your site. I think you might be looking at a wrong column in the table. I should also mention, when you're doing testing and having issues, its a good practice to do test carts using a private or incognito tab or page. Especially with Google Chrome browser, we've seen some pretty frustrating issues caused by the browser not letting go of cached pages as well as elements from pages. Hope this helps. K

It doesn't matter if you make the file changes from C-Panel, Plesk, or FTP. The changes just need to be done on the current theme installed that is live (if you have more than 1 theme - it has to be done on the theme currently being used). If the changes don't show up on the checkout, there are only two possibilities: 1. You have a different checkout page installed that isn't using the current theme checkout or your shop is possibly pulling templates from the original default Classic theme. or 2. You have a caching issue. The checkout page template MUST be recompiled after the changes are made to the partials (cart-summary-totals.tpl and order-confirmation-table.tpl). After recompiling, you must be sure to flush all caches from your shop AND your web browser. No changes showing means the front end is still grabbing old information from somewhere. It is impossible to make changes and not see them UNLESS, those files are not being read and used.

Anyone else got suggestions? rmx333's issue still points toward the template not recompiling and then cache being flushed. I don't have anything else.

If no change is visible, it sounds like it's still a caching problem. After you clear cache, did you try to "Force Compilation" under Advanced Parameters / Performance - Smarty settings? I usually have to select Smarty Cache "OFF", select "Force Compilation" and then "Save" in order to see changes when you make a change to any _partials templates. If you still don't see any changes, try turning off ALL of your caches on that page, save changes and then clear cache again. I've had issues with caches not getting cleared before with Prestashop. Most important, you have to FORCE compilation in order for that cart template to update. Just selecting "recompile after changes" has never worked for me. Also, when you're testing changes, I typically open the front side of the shop in a private or incognito window when I'm doing testing or designing and need to see the changes. I don't know about any other browser, but Google Chrome is notorious for not clearing caches completely. Opening the shop in a private window often helps prevent caching issues on the browser side when small changes are being made. Hope this helps. - Kelly

Same issue auto upgrading from 1.7.2.4 to 1.7.3.2. Not an issue with PHP. I'm running PHP 5.4 and getting the same error. There is an issue with the update not setting correct permissions on file folders on unix installations running cpanel. 777 -> change to 755 and files from 666 -> 644. I did this and still ran into issues with blowing up the database. Also failed on the restore so I had to use webhosting restore feature from an autobackup done the day before. Anyone have any other suggestions?

Hey sabaqahmad Regarding the issue about How to modify cart details - totals in cart. I'm not that great of a programmer and haven't found a work around for displaying the .00$ when the total ends up being an even amount. I'm following an open ticket showing that the issue is supposed to be addressed in upcoming versions. Please see: PrestaShop 1.7 / BOOM-2330 Cart subtotals issues as setting prices VAT excl. per all clients groups Change By: Vincent Beudez Fix Version/s: 1.7.3.x Fix Version/s: 1.7.1.1 I was hoping that this latest release of 1.7.3 will have a fix - but I haven't had time to look through the changelog yet and am a little nervous about upgrading my version until I hear some feedback from others. If the Prestashop team hasn't fixed the issue in this last upgrade, I'll try my hacker hand at prettying up the code a bit more and finding a fix for the .00 not showing up. Cheers, Kelly

I don't know if this will help anyone in this post, but we did a patch job and for the most part fixed totals not showing taxes included. It's been frustrating because clients paying by cheque have been submitting the total without taxes and other clients paying by credit card are questioning why the charged amount is more than the total shown (Total should mean TOTAL OWING including shipping, taxes, and any other charges owing) Under themes\classic\templates\checkout\_partials\cart-summary-totals.tpl near the bottom of the file, find the {block name='cart_summary_total'} and remark out the 2 lines shown and add the 2 lines as shown below the remarked lines: {block name='cart_summary_total'} <div class="cart-summary-line cart-total"> {** <span class="label">{$cart.totals.total.label} {$cart.labels.tax_short}</span> *} {** <span class="value">{$cart.totals.total.value}</span> *} <span class="label">Total (tax + shipping incl.)</span> <span class="value">{$currency.iso_code}{$currency.sign}{$cart.totals.total.amount+$cart.subtotals.tax.amount}</span> </div> {/block} You can also move this whole block down to be under the taxes display block so that the grand total to be paid is the last thing the customer sees rather than the tax line below the total. Then in file order-confirmation-table.tpl, at the bottom of the file find the 2 lines and remarked them out as shown then add the 2 lines below: {** <td><span class="text-uppercase">{$totals.total.label}</span> {$labels.tax_short}</td> *} {** <td>{$totals.total.value}</td> *} <td><span>TOTAL (tax + shipping incl.)</span></td> <td>{$currency.iso_code}{$currency.sign}{$cart.totals.total.amount+$cart.subtotals.tax.amount}</td> Hope this can help others. If anyone can pretty the code on this patch job - it would be appreciated as it doesn't look like a major rush for the Prestashop Team to address. The Forge still doesn't have it assigned for fixing and it has been 9 months since it was noted and reported. Understandably, there are still a lot of major other issues to deal with overall. Cheers, Kelly

Same issue. Real problem for being in Canada and having to show separate tax lines and Total to be paid (including shipping and taxes). Running 1.7 as well and can not find the variable value to display total with tax and shipping included. Frustrating!

Genius! Many thanks. Just cross checked carts missing in action against carts that actually got built and you are correct. There is a conflict between old orders created from carts in our last PS installation and our new store. Thank you! Setting the operand of AUTOINCREMENT past highest number showing in orders looks like it solved the issue and makes sense as to why it seemed random.

Same issue here. We even deleted and re-installed a fresh installation of 1.7.2...still having the issue, but can't replicate consistently or narrow down the exact cause. Some notes: 1. Only happens when the cart is empty. 2. Sometimes turning ajax cart on and off in module settings will work but I don't understand why that would be. 3. Using Dev Console - Cart shows post to cart as "True" and ajax shows "sucessfully added to cart"...but no picture/price/qty shows in the cart display. Clicking to checkout shows you have an empty cart. This is output when it works: Cart Output: success: true, id_product: 1, id_product_attribute: 0, quantity: 1,…} cart:{products: [,…], totals: {total: {type: "total", label: "Total", amount: 15.75, value: "CA$15.75"},…},…} id_product:1 id_product_attribute:0 quantity:1 success:true Ajax output: {,…} modal:"<div id="blockcart-modal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">↵ <div class="modal-dialog" role="document">↵ <div class="modal-content">↵ <div class="modal-header">↵ <button type="button" class="close" data-dismiss="modal" aria-label="Close">↵ <span aria-hidden="true">×</span>↵ </button>↵ <h4 class="modal-title h6 text-sm-center" id="myModalLabel"><i class="material-icons"></i>Product successfully added to your shopping cart</h4>↵ </div>↵ <div class="modal-body">↵ <div class="row">↵ <div class="col-md-5 divide-right">↵ <div class="row">↵ <div class="col-md-6">↵ <img class="product-image" src="https://myshopnamehere.com/shop/1-home_default/laundry-soap.jpg" alt="" title="" itemprop="image">↵ </div>↵ <div class="col-md-6">↵ <h6 class="h6 product-name">Laundry Soap</h6>↵ <p>CA$10.50</p>↵ ↵ <p><strong>Quantity:</strong> 1</p>↵ </div>↵ </div>↵ </div>↵ <div class="col-md-7">↵ <div class="cart-content">↵ <p class="cart-products-count">There is 1 item in your cart.</p>↵ <p><strong>Total products:</strong> CA$10.50</p>↵ <p><strong>Total shipping:</strong> CA$5.25 </p>↵ <p><strong>Included taxes</strong> CA$0.75</p>↵ <p><strong>Total:</strong> CA$15.75 (tax incl.)</p>↵ <div class="cart-content-btn">↵ <button type="button" class="btn btn-secondary" data-dismiss="modal">Continue shopping</button>↵ <a href="//myshopnamehere.com/shop/en/cart?action=show" class="btn btn-primary"><i class="material-icons"></i>Proceed to checkout</a>↵ </div>↵ </div>↵ </div>↵ </div>↵ </div>↵ </div>↵ </div>↵</div>↵" preview:"<div id="_desktop_cart">↵ <div class="blockcart cart-preview active" data-refresh-url="//myshopnamehere.com/shop/en/module/ps_shoppingcart/ajax">↵ <div class="header">↵ <a rel="nofollow" href="//myshopnamehere.com/shop/en/cart?action=show">↵ <i class="material-icons shopping-cart">shopping_cart</i>↵ <span class="hidden-sm-down">Cart</span>↵ <span class="cart-products-count">(1)</span>↵ </a>↵ </div>↵ </div>↵</div>↵" Output when it doesn't: Cart Output: {success: true, id_product: 1, id_product_attribute: 0, quantity: 1,…} cart:{products: [,…], totals: {total: {type: "total", label: "Total", amount: 15.75, value: "CA$15.75"},…},…} id_product:1 id_product_attribute:0 quantity:1 success:true Ajax output: {,…} modal:"<div id="blockcart-modal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">↵ <div class="modal-dialog" role="document">↵ <div class="modal-content">↵ <div class="modal-header">↵ <button type="button" class="close" data-dismiss="modal" aria-label="Close">↵ <span aria-hidden="true">×</span>↵ </button>↵ <h4 class="modal-title h6 text-sm-center" id="myModalLabel"><i class="material-icons"></i>Product successfully added to your shopping cart</h4>↵ </div>↵ <div class="modal-body">↵ <div class="row">↵ <div class="col-md-5 divide-right">↵ <div class="row">↵ <div class="col-md-6">↵ <img class="product-image" src="" alt="" title="" itemprop="image">↵ </div>↵ <div class="col-md-6">↵ <h6 class="h6 product-name"></h6>↵ <p></p>↵ ↵ <p><strong>Quantity:</strong> </p>↵ </div>↵ </div>↵ </div>↵ <div class="col-md-7">↵ <div class="cart-content">↵ <p class="cart-products-count">There is 0 item in your cart.</p>↵ <p><strong>Total products:</strong> CA$0.00</p>↵ <p><strong>Total shipping:</strong> Free </p>↵ <p><strong>Included taxes</strong> CA$0.00</p>↵ <p><strong>Total:</strong> CA$0.00 (tax incl.)</p>↵ <div class="cart-content-btn">↵ <button type="button" class="btn btn-secondary" data-dismiss="modal">Continue shopping</button>↵ <a href="//myshopnamehere.com/shop/en/cart?action=show" class="btn btn-primary"><i class="material-icons"></i>Proceed to checkout</a>↵ </div>↵ </div>↵ </div>↵ </div>↵ </div>↵ </div>↵ </div>↵</div>↵" preview:"<div id="_desktop_cart">↵ <div class="blockcart cart-preview inactive" data-refresh-url="//myshopnamehere.com/shop/en/module/ps_shoppingcart/ajax">↵ <div class="header">↵ <i class="material-icons shopping-cart">shopping_cart</i>↵ <span class="hidden-sm-down">Cart</span>↵ <span class="cart-products-count">(0)</span>↵ </div>↵ </div>↵</div>↵" Any ideas??? Fighting this ghost for 2 weeks now.

Not sure about removing just 1 sort option...but the entire drop down menu can be removed by editing the file: ../themes/classic/templates/catalog/_partials/sort-orders.tpl modify the line: <span class="col-sm-3 col-md-3 hidden-sm-down sort-by">{l s='Sort by:' d='Shop.Theme'}</span> to be <span class="col-sm-3 col-md-3 hidden-sm-down sort-by">{l s=' ' d='Shop.Theme'}</span> then delete the rest of the file below this line. Make a backup of your original file 1st just in case.