Price on Product

Miswanto

Why can't the price setting be more than one hundred million rupiah, where can I set it so that the price can be more than one hundred million rupiah?

vaibahv_bagisto

@Miswanto Why can't the price be more than one hundred million rupiah?

This limitation is not controlled by a setting in the Bagisto admin panel. It is usually caused by the database schema used to store price values.

If the price-related columns in your Bagisto installation are defined as DECIMAL(12,4), the database can store a maximum value of:

99,999,999.9999

This is because DECIMAL(12,4) allows:

12 total digits
4 digits after the decimal point
8 digits before the decimal point

A price of 100,000,000.0000 requires 9 digits before the decimal point, so it exceeds the column's capacity and the database rejects the value.

Where can I change it?

There is no configuration or admin setting in Bagisto to increase the maximum price. The limit comes from the database column definitions.

To support prices greater than 100 million rupiah, increase the precision of the relevant price columns, for example from DECIMAL(12,4) to DECIMAL(18,4), by creating a database migration and then running:

php artisan migrate

Make sure all price-related database columns use the same precision. Updating only the product price column may not be enough, as price values are also used in carts, orders, invoices, and refunds.

Summary

The 100 million rupiah limit is a database schema limitation, not a Bagisto configuration setting. Updating the relevant price columns to a larger precision such as DECIMAL(18,4) through a database migration will allow prices above 100 million rupiah to be stored and processed correctly.