Magento2 - How to increase the maximum price more than 100 million

By default of Magento 2, we can register and display up to 100 million as price. However, this spec can't be acceptable in some countries which adopt large digit currency. In order to allow bigger digit price on Magento, we need to expand some tables on DB.

alter table catalog_product_entity_decimal modify value decimal(24,4);

alter table catalog_product_index_price modify price decimal(24,4);
alter table catalog_product_index_price modify final_price decimal(24,4);
alter table catalog_product_index_price modify min_price decimal(24,4);
alter table catalog_product_index_price modify max_price decimal(24,4);
alter table catalog_product_index_price modify tier_price decimal(24,4);

alter table catalog_product_index_price_tmp modify price decimal(24,4);
alter table catalog_product_index_price_tmp modify final_price decimal(24,4);
alter table catalog_product_index_price_tmp modify min_price decimal(24,4);
alter table catalog_product_index_price_tmp modify max_price decimal(24,4);
alter table catalog_product_index_price_tmp modify tier_price decimal(24,4);

alter table catalog_product_index_price_final_tmp modify price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify orig_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify final_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify min_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify max_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify tier_price decimal(24,4);

alter table  catalog_product_entity_tier_price modify qty decimal(24,4);
alter table  catalog_product_entity_tier_price modify value decimal(24,4);

alter table  catalog_product_index_price_final_idx modify orig_price decimal(24,4);
alter table  catalog_product_index_price_final_idx modify price decimal(24,4);
alter table  catalog_product_index_price_final_idx modify min_price decimal(24,4);
alter table  catalog_product_index_price_final_idx modify max_price decimal(24,4);
alter table  catalog_product_index_price_final_idx modify tier_price decimal(24,4);
alter table  catalog_product_index_price_final_idx modify base_tier decimal(24,4);

alter table  catalog_product_index_price_idx modify price decimal(24,4);
alter table  catalog_product_index_price_idx modify final_price decimal(24,4);
alter table  catalog_product_index_price_idx modify min_price decimal(24,4);
alter table  catalog_product_index_price_idx modify max_price decimal(24,4);
alter table  catalog_product_index_price_idx modify tier_price decimal(24,4);

alter table  catalog_product_index_tier_price modify min_price decimal(24,4);

alter table  catalog_product_index_eav_decimal modify value  decimal(24,4);

alter table  catalog_product_index_eav_decimal_idx modify value decimal(24,4);

alter table  catalog_product_index_eav_decimal_tmp modify value decimal(24,4);

References

http://magento.stackexchange.com/questions/49304/price-more-than-100-million
http://stackoverflow.com/questions/21508397/magento-maximum-price-more-than-100-million

If you liked this article

Let's subscribe the updates of Scuti!

Share on Google Plus

About Tomohide Kakeya

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.