Item Quantity Limit - SHORT Int is too short.

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
bryancapitano
Ensign (ENS)
Ensign (ENS)
Posts: 13
Joined: Sun Oct 05, 2008 9:33 am
Location: Portland, Oregon
Contact:

Item Quantity Limit - SHORT Int is too short.

Post by bryancapitano » Wed Mar 04, 2009 1:50 am

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

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Item Quantity Limit - SHORT Int is too short.

Post by mazhar » Wed Mar 04, 2009 10:00 am

This would need a change in the source code. You are right there is no simple fix in your case.

isaacdiaz74
Ensign (ENS)
Ensign (ENS)
Posts: 7
Joined: Fri Dec 19, 2008 2:15 pm

Re: Item Quantity Limit - SHORT Int is too short.

Post by isaacdiaz74 » Fri Sep 03, 2010 9:48 am

Has anyone been able to work around this limitation?

We need to accept orders for quantities grater than 32768 ...................

plugables
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Sat Aug 15, 2009 4:04 am
Contact:

Re: Item Quantity Limit - SHORT Int is too short.

Post by plugables » Thu Sep 16, 2010 8:33 am

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.

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Item Quantity Limit - SHORT Int is too short.

Post by mazhar » Tue Sep 21, 2010 11:00 am

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.

plugables
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Sat Aug 15, 2009 4:04 am
Contact:

Re: Item Quantity Limit - SHORT Int is too short.

Post by plugables » Tue Sep 21, 2010 11:55 am

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...

Post Reply