[Solved] PS 1.4.6.1 Bug - Multiple combinations of same product in cart (maximum quantity reached)

[tim967]

When attempting to create a clothing product with 3 combinations available to the user(sizes small, medium and large) if i want to add 2 different sizes of the same product to the cart(2 combinations) it displays the error:

 

"You already have the maximum quantity available for this product."

 

Also attached image of the error. As you can see i already have a medium version of the product in the cart but this occurs when i also try to add a small.

 

If there is another way i can do it please let me know or if anyone knows of a fix it would be greatly appreciated!

[aguilhon]

same problem here, with version 1.4.6.1.

 

Anybody ?

[tomerg3]

This was a bug in 1.4.6.1, you can upgrade to 1.4.6.2 which had that issue fixed, or you can run the following 2 queries in phpMyAdmin (replace ps_ with your DB prefix if it is different).

 

ALTER TABLE `ps_cart_product` DROP PRIMARY KEY;

And

ALTER TABLE `ps_cart_product` ADD INDEX ( `id_cart` , `id_product` ) ;

[tim967]

This was a bug in 1.4.6.1, you can upgrade to 1.4.6.2 which had that issue fixed, or you can run the following 2 queries in phpMyAdmin (replace ps_ with your DB prefix if it is different).

 

ALTER TABLE `ps_cart_product` DROP PRIMARY KEY;

And

ALTER TABLE `ps_cart_product` ADD INDEX ( `id_cart` , `id_product` ) ;

Thank you so much! I've been looking all over the web today and couldn't find it anywhere. Had to do it manually with the queries as i had upgraded to 1.4.6.2 but it hadn't worked. thanks again!

[jsherk]

thanks

[emidelight]

same for me.

 

upgrade to 1.4.6.2 didn't solve.

 

running sql queries works fine.

 

i'm using attibute assitant pro module and i love it !

 

thanks

[shellxie]

I come across the problem. I have 8 options and 3905 lines of combination. The front page display blank when I finished import the csv file. If there any solution?

[tomerg3]

Prestashop is not able to handle more than 1,000-3,000 combinations, it creates out of memory errors.

 

You can check out this module, which has a way around the problem http://www.prestashop.com/forums/index.php?/topic/47363-module-attribute-wizard-pro-create-an-unlimited-number-of-attributes-and-display-as-radio-button-checkbox-dropdown-textbox-teaxtarea-files/

[tivicrdotcom]

Prestashop is not able to handle more than 1,000-3,000 combinations, it creates out of memory errors.

 

You can check out this module, which has a way around the problem http://www.prestasho...eaxtarea-files/

 

But it should display more than 11 attributes on a single product right? I have created 19 different fragance attributes but it only displays 11 on the drop dwon menu. Site @ virtualitycr.com/tienda

[tomerg3]

Can you link to the exact product?

[alexredwood]

I have this problem aswell, can't seem to get it solved.

I did what Tomerg3 suggested, but the sql command;

ALTER TABLE `ps_cart_product` DROP PRIMARY KEY;

doesnt' work. Getting "#1091 - Can't DROP 'PRIMARY'; check that column/key exists"

 

I've updated my prestashop installation to 1.4.7 but that doesn't work either.

 

On my particular shop i've disabled the Stock funtctions, since i won't need it. All my products are handmade.

Still getting the " You already have the maximum quantity available for this product." error.

 

I have no clue what to do next....

[Kerm]

Have 1.4.7.0 and same problem too

[Kerm]

I change all tables to MyISAM bc InnoDB don't support repair table and after I select all tables and do repair them, now all work fine.

[benjamin utterback]

Hello all, this 1.4.6 bug is solved in current versions. Please post your questions in an new topic if you are not using the 1.4.6 version. Thank you! I will unPin

[marcis]

Same problem with PS1.5.3.1:

 

You already have the maximum quantity available for this product.

 

Any idea?

 

P.D.: Stock management is disabled

 

Note: solved, there was an error with the combination id... but the error message is confusing

Edited April 13, 2013 by marcis (see edit history)

[navjotk]

Same problem as above on 1.5.0.17

Certain products can't be added to cart from the front-end even though Stock management is disabled and product is set as available etc. Trying to add the same product to a cart from the backend gives this error: "You already have the maximum quantity available for this product."

Seems like the same problem as marcis above. What was the error with the combination id that you solved here?

[A2Lux]

Hi,

 

I also have the problem with the error message: You already have the maximum quantity available for this product. I use the version 1.5.4.1.

 

I used prestashop store manager to upload new products and when I add one of the new products to my cart, I get the error message.

 

Anybody an Idea?

 

Thank you

Edited June 30, 2013 by A2Lux (see edit history)

[MAKER]

Hi,

 

the same problem !

 

Error message, when ordering porducts which have some combinations:

 

"You already have the maximum quantity available for this product. "

 

I use the version 1.5

 

Little solution is to regenerate combinations for product. Than it is working. But it is not easy to regenerate combinations for more than 1000 products.

 

Any solution ? Or some bulk action for regenerating combinations?

 

Thank you !

[benjamin utterback]

Hi,

 

the same problem !

 

Error message, when ordering porducts which have some combinations:

 

"You already have the maximum quantity available for this product. "

 

I use the version 1.5

 

Little solution is to regenerate combinations for product. Than it is working. But it is not easy to regenerate combinations for more than 1000 products.

 

Any solution ? Or some bulk action for regenerating combinations?

 

Thank you !

 

You do need to regenerate the combinations once you updated the combinations. It will update the quantities along with it. If you are having trouble with that then take a look at this blog post about the php.ini file. It will help with generating Combinations, especially with the input time and max execution time. . http://www.prestasho...commerce-store/

[david.bonntech]

I'm having this issue with 1.5.4.1. Tried the queries suggested above and had no luck.

Tried repairing database tables and had no luck.

 

Anyone have any ideas?

[Attila Bogozi]

Hello.

Why is this marked as Solved if there is no solution...

 

I am using 1.5.6.2 version and get the same error. Is there a good solution to solve this issue?

I guess regenerating the combinations could work, but is there any faster way to do that? I have too many products to update.

Thanks

[Eric@SCSi]

Hello everybody and Experts,

 

I am running a 1.5.6.2 PS and got the same problem with all products... Impossible to create an order fron the BO.

 

Can someone help please?

 

Many thanks.

[agomez_1]

This is a strange error, I very confused about where is the real error.... I only have this error in one of my items

http://www.thepinkrobin.com/shop/es/despedida/5-vintage-bride.html

When i try to add to cart this item is showing me the error, and the fact is the almost everything is configure on Pre Order and is out of stock, but neither any other item shows me this error except this item above.

 

I already try: fixing the data base, clearing cache, editing CartController.php, but i haven't found the error yet. If somebody solve it please post it... i will post it if I solve be it first.

[Eric@SCSi]

Hi AGomez_1,

 

Solution: when the shop is in CATALOG mode, everything can happen! Including this error, triggered by "we don't know what"...

 

Also in Maintenance mode, be aware that the shop/some modules may react on a non predictable way!

 

Regards

[breda_Mcg]

I have the same problem, shop is not in catalog mode or maintenance mode.

Did anyone find a solution?

Thanks,

Breda

[Elixe]

Prestashop is not able to handle more than 1,000-3,000 combinations, it creates out of memory errors.

 

You can check out this module, which has a way around the problem http://www.prestashop.com/forums/index.php?/topic/47363-module-attribute-wizard-pro-create-an-unlimited-number-of-attributes-and-display-as-radio-button-checkbox-dropdown-textbox-teaxtarea-files/

So, If I have a catalogue with more than 3,000 I can't have any combination product, can I?

[Megamack]

Running 1.6.0.14 and still the same problem. Certain products with combinations cant be purchased because of this. Cant be added to manual order either even though in stock.

[markop1]

I had a problem with the "You already have the maximum quantity available for this product." error when trying to order a product from Back Office. The solution was simple: I just had to make the product available for ordering again at Back Office > Products > Product > Information. Just tick the option for "Available for order".

[camandrew]

I had the same issue for combination products and had to add quantities, even though i had allow orders when out of stock activated. ps 1.6.1

[BenC]

I had a problem with the "You already have the maximum quantity available for this product." error when trying to order a product from Back Office. The solution was simple: I just had to make the product available for ordering again at Back Office > Products > Product > Information. Just tick the option for "Available for order".

 

This also worked for me, unsure how this has happened though or how many of my products are effected.

[yasser58]

Hi Guys!

 

I think this is a good solution for this issue, It works for me.

 

1- use this query:

UPDATE `ps_product_attribute_shop` As A SET `id_product`= (SELECT id_product AS Main_ID
FROM `ps_product_attribute` As B WHERE B.`id_product_attribute` = A.`id_product_attribute`)
WHERE A.id_product=0

 

2- Clear all files in:

public_html/cache/cachefs

 

Regards,

[scolink]

Hi Guys!

 

I think this is a good solution for this issue, It works for me.

 

1- use this query:

UPDATE `ps_product_attribute_shop` As A SET `id_product`= (SELECT id_product AS Main_ID

FROM `ps_product_attribute` As B WHERE B.`id_product_attribute` = A.`id_product_attribute`)

WHERE A.id_product=0

 

2- Clear all files in:

public_html/cache/cachefs

 

Regards,

 

Where i should put that query ?

What file can you tell me please ?

[yasser58]

Where i should put that query ?

What file can you tell me please ?

Dear scolink,

 

This correction should use in your database.

If you are using a regular host with CPanel control, use these steps:

1- Log in to your host CPanel. (or other panels like Plesk or DirectAdmin or ...)

2-click on "phpmyadmin" icon. (or any similar icons in other panels)

3-when phpmyadmin web control appears, go to your database.

4-choose SQL tab

5-paste this query in the SQL text area and select RUN.

 

UPDATE `ps_product_attribute_shop` As A SET `id_product`= (SELECT id_product AS Main_ID

FROM `ps_product_attribute` As B WHERE B.`id_product_attribute` = A.`id_product_attribute`)

WHERE A.id_product=0

 

pay attention that this query just fix the combination product that already saved and for any new combination product, you should run this query again.

I will work on the permanent solution and will inform you as soon as I find it!

 

Regards.

[Campa]

Dear scolink,

 

This correction should use in your database.

If you are using a regular host with CPanel control, use these steps:

1- Log in to your host CPanel. (or other panels like Plesk or DirectAdmin or ...)

2-click on "phpmyadmin" icon. (or any similar icons in other panels)

3-when phpmyadmin web control appears, go to your database.

4-choose SQL tab

5-paste this query in the SQL text area and select RUN.

 

UPDATE `ps_product_attribute_shop` As A SET `id_product`= (SELECT id_product AS Main_ID

FROM `ps_product_attribute` As B WHERE B.`id_product_attribute` = A.`id_product_attribute`)

WHERE A.id_product=0

 

pay attention that this query just fix the combination product that already saved and for any new combination product, you should run this query again.

I will work on the permanent solution and will inform you as soon as I find it!

 

Regards.

 

Hello,

I have PS 1.5.6.2 and It does not work.

The query runs but it does not edit anything.

'ps_product_attribute_shop' does not exist in my tables list.

 

Help please

 

thanks!

Edited May 30, 2016 by Campa (see edit history)

[MNBY]

I've just updated from 1.6.1.7 to 1.6.1.11 and this error appears from nowhere.

Now I have to deactivate this function event though it worked before with no issue.

What happend?

[develu]

1.5.3 doesn't work, both queries fails.

****NOT solved******

Edited May 29, 2017 by develu (see edit history)

[jmac00]

This was a bug in 1.4.6.1, you can upgrade to 1.4.6.2 which had that issue fixed, or you can run the following 2 queries in phpMyAdmin (replace ps_ with your DB prefix if it is different).

 

ALTER TABLE `ps_cart_product` DROP PRIMARY KEY;

And

ALTER TABLE `ps_cart_product` ADD INDEX ( `id_cart` , `id_product` ) ;

 

It worked for me!! Thank you man. I am using 1.6.1.10

[shobhitverma]

On 8/17/2015 at 1:38 PM, markop1 said:

I had a problem with the "You already have the maximum quantity available for this product." error when trying to order a product from Back Office. The solution was simple: I just had to make the product available for ordering again at Back Office > Products > Product > Information. Just tick the option for "Available for order".

Worked For me