Andrew Watson

I gave up. Start form scratch with a new install. It just seamed easier (of course I checked the shopping cart functionality worked first).

Hi. I have a new install of the latest version of Prestashop (1.6.1.1). I cant put anything in the shopping cart, all I get if I try is and error: "You already have the maximum quantity available for this product" I have tried: 1) turned off maintenance mode. 2) turned off stock control 3) Turn on stock control and set the number of stock to 999999 (then when it didn't work I turned it off again) 4) Repair the database in phpmy admin 5) Executed correctly sql query: ALTER TABLE `ps_cart_product` DROP PRIMARY KEY; 6) Not in Catalogue mode. 7) Checked in ps_stock_available - both "id_shop" and "id_shop_group" seam to be correct Oh yes, I have cache turn off (from the beginning) and Force compilation set to on so that I can test changes. I originally posted in another thread but it was in the wrong category, so I am posting again. I can't see where the problem is and I'm tearing my hear out trying to fix it because at the moment the shop just does not work. Can anyone help me troubleshoot it? Many thanks.

Thanks anyway for your help... (..I can't change the category because I didn't post it originally).

Ok. Good news, I made a super noob mistake. I have been a web dev for over 7 years, (very new to Prestashop though), clearly I never used a CMS with so many tables.... I neve knew that PHPmyadmin had... a page two! Ok. On page two I found ps_stock_available and I can see both "id_shop" and "id_shop_group" seams to be correct (1 and 0 respectively). So I still cant work out how to get rid of: "You already have the maximum quantity available for this product" So here is a question. If I have stock turned off, what would be the expected value for: id_shop_group quantity depends_on_stock out_of_stock Or do you have any other suggestions?

Yes. You are right. What do I do if there is no ps_stock_available table? Any idea if there is a way to rebuild the database tables without affecting existing data? I have not tables below ps_specific_price whatsoever...

Multifunction is not enabled. "ps_stock_available" doesn't seam to exist! (or at least I cant see one). I checked ps_product and saw that "id_shop" is correct. I can't find any "id_shop_group". Still stuck (but thanks for the help). Any other ideas?

bump. I see a lot of people with this problem and threads marked as solved when really it really isn’t. I am using Prestashop 1.6.1.1 (as of now the latest version). I have a new install. If I try adding a product to the cart I get the error: "You already have the maximum quantity available for this product" I have seen numerous threads on this and tried all the “solutions” to no avail. I have tried: 1) turned off maintenance mode. 2) turned off stock control 3) Turn on stock control and set the number of stock to 999999 4) Repair the database in phpmy admin 5) Executed correctly sql query: ALTER TABLE `ps_cart_product` DROP PRIMARY KEY; 6) Not in Catalogue mode. I’m going nuts, I’m totally stuck. Any thoughts?

Great! Now you just made me feel dumb Actually, I have the backend installed in Spanish which is not my native language (probably why I overlooked it). Thanks again!

Great. Thanks you! Yes I wanted to do the translation through Localization > Translations, I just couldn't find the right place. Regsarding translations I think it would be great if there was and option to expand all the sub headings so that it was possible to seach on the page to find what you want to change. Believe it or not I went thorugh and expanded most of the headings to try and find what I was looking for, but didn't do it with ALL of them (and therefore couldn't find it). Thanks again!

I'm a bit stuck. I want to change the front end translation of the cash on delivery module in Spanish. I tried going to languages>translations and choosing modules and then the spanish language, but it only give me three things I can translate that are all from the back end. The I tried take a look at payment.tpl but that will only change the English. So in the end I found modules/cashondelevery/translations/es.php which I edited to reflect the changes I wanted, but they do not appear on the front end. I cleared the cache on the browser and then tried other borwsers. No go, still not updated on the front end. I double checked the change was updated on the server. So then I went to advanced preferences>perfomance and chose force recompile cache and saved. Check the frond end again. Stil no. Then I turned recompile off and smarty cache wasn't being used anyway. Oh yea, and I deleted the prestashop cache too. Relload the front page, still not updted.... What did I miss?

<<<< oooops I just noticed this thread was talking about the new cloud version...search brought me in at the bottom, should have checked. ooops. I'll leave this here in case it help somone with the download version (and also because I can't see how to delete it) >>>>>>>> @Ralph. Not correct. You can install themes via the backoffice. Go to preferences>themes and then look for a button at the top right to install a them. You can find free themes on the internet, but if you are a noob, steer clear of Leo themes and apollo themes as they have thier own framework and require more fiddling with not very good documentation (I'm not complaining they have some good themes). You could however try one of thier quickstart installtions if you hevn't already started your shop. Yo can find some here: http://prestadevelop.com/en/ Or prestabrain have a couple of good ones free (very similar to the default but not to hard to configure). http://www.prestabrain.com/ Or this minimal one is quite nice: https://www.prestashop.com/forums/topic/334322-free-prestashop-16-theme-minimal/ Hope that helps.

It's ok. I fixed it. It turns out that the price that the product changed to was the USD price. So once I discovered that I just made New Zealand dollars my default and turned off USD and all my pricing was correct. So I'll just leave this here in case that helps.

I recently built an online school uniform shop for my parents. I put in about 80 products with a bunch of atribute (a toatal of 500 all up) before I notice the currency was wrong. I found when I changed the currency all my prices changed. So I looked on this forum and follewd a suggestion form a forum member to update the prices through mysql. I did something like: UPDATE fph_product_attribute set price =price*1.28292849811840 but I din't know I had to also update: fph_product_attribute_shop (or it might have been the other way around). Anyway. I got the prices right for the school uniforms as you can see here: http://www.distributorsdirect.co.nz Find your way to a product and it appears correctly. The price is right. But here is my problem: When you click an item and then go to the item description and look at the price, the correct price flashes quickly correct and then changes to an incorrect price. If you add the item to the checkout, then it appears correct in the checkout. I think I need to copy the fph_product_attribute_shop "price" directly over to the ph_product_attribute "price" something like that. Help would be appreciated.

@cistech. You're right! I think the problem was, I used a Spanish hosting company and their "click and build" to install the shop in Spanish. I then created a ne Admin user and set that user to the English language (for me), but for some reason the back-office still appeared in Spanish and the word for state (estado) appeared. When I login in as a user set to Spanish, the word provincia appears correctly. Sorry about that comment (and thanks for helping me find the errror).

Boom. Turns out my code was spot on. It's just that if you accidentally run it twice, then it doesn't update the fields because they are already set with the desired string. UPDATE `mydatabase`.`customers` SET `passwd` = MD5(’cookie-key+password’) WHERE `customers`.`id_customer` <= 53553;