ocpistol

Prestashop 1.6.1.3 So the problem I am having is when group customers view a product the volume discounts don't show up correctly. In this example list price is $7.00, the sell price for under 100 is $4.20, if they purchase 100+ the price should be $2.40. We give a $3.00 discount off list then the group discount is added to that but it doesnt display right in the volume discounts. I have been looking at the product.tpl in the theme but cant seem to fix the problem. Volume discounts Quantity Price You Save 100 $1.20 Up to $300.00

Is it possible to put php code in a CMS page in prestashop?

I modified ps_product. I have it disabled in there but it is still using the price off that other table.

I checked and those tables are empty in ps_product_attribute. But I was looking through the tables and found ps_product_shop has information filled in for all of my products. I am not using multishop is there a way to disable this?

I updated prices on a few thousand products through the database but on the site it is still listing all the previous prices. I have tried clearing cache, resetting server, and modifying a product. None of these have had it show the price from the database. I updated the prices in field ps_product. anyone have any ideas?

adding to cart is taking about 7-9 seconds and some customers are saying its taking mins to add things to cart. I am running version 1.6.0.9 trying to figure out what ?rand is or why it could be taking so long.

When its on http is runs fast switching to https takes about 8 Seconds. Once running in https it runs acceptable slower but still quick. Adding to cart takes about 10-15 seconds in both modes. When looking at server activity during it it uses about 18% cpu on apache for those 10 secs.

I am sorry I am not sure what you are asking me for, Im not sure how to get you more info. kind of why i am having a problem figuring out what is wrong.

# # KeepAlive: Whether or not to allow persistent connections (more than # one request per connection). Set to "Off" to deactivate. # KeepAlive On # # MaxKeepAliveRequests: The maximum number of requests to allow # during a persistent connection. Set to 0 to allow an unlimited amount. # We recommend you leave this number high, for maximum performance. # MaxKeepAliveRequests 100 # # KeepAliveTimeout: Number of seconds to wait for the next request from the # same client on the same connection. # KeepAliveTimeout 100

I have keepAlive enabled.

wait a second I forced SSL on the entire site and everything is having problems loading and is extremely slow.

Ok here is an update, I tried to disable all the stats and everything that is required for the site to run. I Tried optimizing the database with programs. I am running ubuntu Server I tried updating mysql to 5.6, that didnt change anything. I am running it in Windows Server 10 Hyper-V alone with a Hex core Xeon 2.0ghz So I thought maybe it is the actual server not being able to keep up with hard drive speed (raid 6 of 6 re4 1tb drives) so I put a Samsung 850 Pro SSD in for it to run on. I Have the entire server allocated to running just this site at the moment. It is still the same load time when it comes to checkout. There are no errors in logs I am at a loss at what it could be. When I watch "top" and click on add to card I see it running apache and mysql for about 200ms then it stops about 10 seconds later it does it again and finally loads the page.

Thanks for the advice. It cleaned up alot, but its still taking decades to add something to cart or view the cart.

I have had all those setting set to that, I watch Top and it runs a mysql query and then stops doing everything then about 5 seconds later starts to load apache and mysql. Could it be that my database is to large and its taking to long to search it? I have it on a raid 10 of 6 re4 1tb drives.

My Website http://beverageequipmentcompany.com Browsing the catalog runs quick but when add a product to the cart or try to access account settings it goes really slow. anything I can check for?