Page 1 of 1
Item Quantity Limit - SHORT Int is too short.
Posted: Wed Mar 04, 2009 1:50 am
by bryancapitano
We've developed a number of shopping carts on the Able 7.0 platform, and have had fantastic success. We're recently ran across a deal breaker for on of our carts. A client of ours will be selling large quantities (shipping CONTAINERS) full of copper parts and refrigeration supplies for import/export purposes.
Bottom line is the Item Quantity in Able 7.0 is using the SHORT INT which only allows 32,768. Our customer needs to sell item quantities of at least 7 digits. (millions of items).
Looking through the code, it appears changing Able's SHORT into LONG will require substantial work.
Anybody have any suggestions?
Thanks!
Bryan
Re: Item Quantity Limit - SHORT Int is too short.
Posted: Wed Mar 04, 2009 10:00 am
by mazhar
This would need a change in the source code. You are right there is no simple fix in your case.
Re: Item Quantity Limit - SHORT Int is too short.
Posted: Fri Sep 03, 2010 9:48 am
by isaacdiaz74
Has anyone been able to work around this limitation?
We need to accept orders for quantities grater than 32768 ...................
Re: Item Quantity Limit - SHORT Int is too short.
Posted: Thu Sep 16, 2010 8:33 am
by plugables
As a workaround you should be able to customize the add-to-cart logic in the store and when you see a product being added in quantity more than 32,768 create more than one line items for that product in the basket.
Re: Item Quantity Limit - SHORT Int is too short.
Posted: Tue Sep 21, 2010 11:00 am
by mazhar
plugables wrote:As a workaround you should be able to customize the add-to-cart logic in the store and when you see a product being added in quantity more than 32,768 create more than one line items for that product in the basket.
I don't think so that it will work, actually basket combines same items automatically. So when ever you will try to add two different basket items for same product basket will combine them into one basket item. It only allows multiple basket items for same product if it has some custom product template attribute defined with it. Perhaps this workaround could be extended on this line.
Re: Item Quantity Limit - SHORT Int is too short.
Posted: Tue Sep 21, 2010 11:55 am
by plugables
mazhar wrote:plugables wrote:As a workaround you should be able to customize the add-to-cart logic in the store and when you see a product being added in quantity more than 32,768 create more than one line items for that product in the basket.
I don't think so that it will work, actually basket combines same items automatically. So when ever you will try to add two different basket items for same product basket will combine them into one basket item. It only allows multiple basket items for same product if it has some custom product template attribute defined with it. Perhaps this workaround could be extended on this line.
I think one can have different value in LineMessage field for different basket items to make sure they are treated differently...