Unit Price Feature (backend)

[sheenazien8]

We need API to handle this feature

Issues

Sometimes merchants need to sell products that are not only 1 unit, but sometimes they are using each unit with different prices, e.g.:
The basic unit of the product is PCS, and the price is IDR 1000; then they want to sell this product at a different price if the customer buys it per 10 PCS (box), so the merchant needs to set the price like this:

Product A needs to have unit BOX that contains 10 PCS with prices IDR 8000

How can we solve this issue?

IMO, we need to add a unit_prices table that relates to the product with columns:

• unit (String)
• contains (Int)
• price (Double)

Then, when the product is sold by using the unit price, we need to add the flag to know whether this is using the feature or not; then, in table transactions, we need to use this price as well, and we can discuss it to have the better solution for this feature