Developer forum

Forum » Ecommerce - Standard features » product stock base pricing enter with decimals

product stock base pricing enter with decimals

Shiwanka Chathuranga
Shiwanka Chathuranga
Reply

we have customer who is selling 1000x prints as 1 qty. they want to sell with decimal quantity

15.5qty sell means 15500 prints

they want to configure prices for 52.5, 112.5 likewise, but current quantity field is integer

anyway to change quantity into decimals?


Replies

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

try to use the quantity via Stock matrix allows to input-save decimal values (the field has float type in db table). Please, find the attachment for details.

 

Oleg QA 

Screenshot_2026-09-02_084854.png Screenshot_2026-09-02_084952.png
 
Shiwanka Chathuranga
Shiwanka Chathuranga
Reply

Hi Oleg

Can price configure with the sock in decimals, my requirement is like this

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

Hi,

I see Inconsistency among the product price matrix's Quantity value in UI and db. It's possible to input-show decimal number but it's transformed to integer after cache refrech, since the field type is integer as you have written above in fact. I've submitted new task #29326 to rise the issues to fix if possible. Thanks.  

BR, Oleg QA

 
Shiwanka Chathuranga
Shiwanka Chathuranga
Reply

Hi Oleg

Do we have any update on this task?

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

Hi,

Not yet fixed.

Oleg 

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply
This post has been marked as an answer

It seems like the API and the UI both supports doubles. So if you change the field in the DB, you can try and see. EcomPrices.PriceQuantity field is defined as [PriceQuantity] [int] NULL, Change it to float and it should work

Votes for this answer: 1
 
Shiwanka Chathuranga
Shiwanka Chathuranga
Reply

That works, Thanks Nicolai

 

You must be logged in to post in the forum