Star Repo
Can not order quantities 0.35 (mshop_stock.stocklevel = integer)
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Can not order quantities 0.35 (mshop_stock.stocklevel = integer)
Hi,
Some of our products can also be ordered in quantities <1, e.g. 0.08kg, 0.75kg etc.
already set product.scale and price.quantity to 0.01.
Adding products to the basket works fine, but when submitting the basket we get the error Invalid text representation: 7 ERROR: Invalid input syntax for type integer: '0.75'.
UPDATE 'mshop_stock
SET 'stocklevel' = 'stocklevel' - ?, 'mtime' = ?, 'editor' = ?
WHERE 'prodid' = ? AND 'type' = ? AND ('siteid' IN ('','1.') )
[0.75,„2024-06-01 14:08:54“,„Test“,17557,„default“]
setup/default/schema/stock.php
stocklevel is defined as integer, shouldn't it be decimal?
Or what other setting is wrong?
Thank you!
Some of our products can also be ordered in quantities <1, e.g. 0.08kg, 0.75kg etc.
already set product.scale and price.quantity to 0.01.
Adding products to the basket works fine, but when submitting the basket we get the error Invalid text representation: 7 ERROR: Invalid input syntax for type integer: '0.75'.
UPDATE 'mshop_stock
SET 'stocklevel' = 'stocklevel' - ?, 'mtime' = ?, 'editor' = ?
WHERE 'prodid' = ? AND 'type' = ? AND ('siteid' IN ('','1.') )
[0.75,„2024-06-01 14:08:54“,„Test“,17557,„default“]
setup/default/schema/stock.php
stocklevel is defined as integer, shouldn't it be decimal?
Or what other setting is wrong?
Thank you!
Re: Can not order quantities 0.35 (mshop_stock.stocklevel = integer)
Yes, you are right, integer makes no sense if fractional quantities can be bought. This has been fixed in dev-master now and will be part of the next release:
https://github.com/aimeos/aimeos-core/c ... 438724a34a
https://github.com/aimeos/aimeos-core/c ... 438724a34a
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
give us a star