[Skip to main content](#vessel-content) # 0 in DB for minimum quantity that is 1 after imprt ## - **[SG](/forum/user/12204-sg "View SG's Profile")** - [![SG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12204-sg "View SG's Profile") Topic Author - [ Offline](/forum/user/12204-sg) Less More - Posts: 101 - Thank you received: 12 - - 13 years 5 months ago - 13 years 5 months ago [\#106678](#106678) by [SG](/forum/user/12204-sg "View SG's Profile") *[0 in DB for minimum quantity that is 1 after imprt](/forum/3-bug-report/83040-0-in-db-for-minimum-quantity-that-is-1-after-imprt#106678 "Hi, When I import products with for example : price_value; price_min_quantity 2.66|2.66;|4 I get in the product details page as you can see in the first picture below. In the second picture you can see that in the database it's also . And in the backend number is shown. [image] [image] [image] It seems that 1 as minimum quantity is not appreciated and converted to in the database. This is a problem for us. Thanks. Cheers.")* was created by *[SG](/forum/user/12204-sg "View SG's Profile")* Hi, When I import products with for example : price_value; price_min_quantity 2.66|2.66;1|4 I get 0 in the product details page as you can see in the first picture below. In the second picture you can see that in the database it's also 0. And in the backend number 1 is shown. image missing http://i43.tinypic.com/33uzmh5.jpg image missing http://i44.tinypic.com/3509xrp.jpg image missing http://i40.tinypic.com/2uh7d40.jpg It seems that **1** as minimum quantity is not appreciated and converted to 0 in the database. This is a problem for us. Thanks. Cheers. Last edit: 13 years 5 months ago by [SG](/forum/user/12204-sg "View SG's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzA0MC0wLWluLWRiLWZvci1taW5pbXVtLXF1YW50aXR5LXRoYXQtaXMtMS1hZnRlci1pbXBydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14276 - - 13 years 5 months ago [\#106679](#106679) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[0 in DB for minimum quantity that is 1 after imprt](/forum/3-bug-report/83040-0-in-db-for-minimum-quantity-that-is-1-after-imprt#106679 "Hi, When I import products with for example : price_value; price_min_quantity 2.66|2.66;|4 I get in the product details page as you can see in the first picture below. In the second picture you can see that in the database it's also . And in the backend number is shown. [image] [image] [image] It seems that 1 as minimum quantity is not appreciated and converted to in the database. This is a problem for us. Thanks. Cheers.")* Yes. That's normal. 0 and 1 are treated the same for the min quantity since you can't add a product with a quantity of 0 in the cart. So HikaShop always use 0 in the database while it displays 1 in the interface for historical questions. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzA0MC0wLWluLWRiLWZvci1taW5pbXVtLXF1YW50aXR5LXRoYXQtaXMtMS1hZnRlci1pbXBydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[SG](/forum/user/12204-sg "View SG's Profile")** - [![SG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12204-sg "View SG's Profile") Topic Author - [ Offline](/forum/user/12204-sg) Less More - Posts: 101 - Thank you received: 12 - - 13 years 5 months ago [\#106687](#106687) by [SG](/forum/user/12204-sg "View SG's Profile") Replied by *[SG](/forum/user/12204-sg "View SG's Profile")* on topic *[0 in DB for minimum quantity that is 1 after imprt](/forum/3-bug-report/83040-0-in-db-for-minimum-quantity-that-is-1-after-imprt#106687 "Hi, When I import products with for example : price_value; price_min_quantity 2.66|2.66;|4 I get in the product details page as you can see in the first picture below. In the second picture you can see that in the database it's also . And in the backend number is shown. [image] [image] [image] It seems that 1 as minimum quantity is not appreciated and converted to in the database. This is a problem for us. Thanks. Cheers.")* Hi Nicolas, I can understand that you can't add a quantity of 0 to a cart ![:-)](/media/kunena/emoticons/3.png ":-)") But why did it become zero in the first place since I had 1 in the import csv file. It shouldn't have altered the values. The main problem now for the client is that the min. quantity in the product page is now 0 which should be 1. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzA0MC0wLWluLWRiLWZvci1taW5pbXVtLXF1YW50aXR5LXRoYXQtaXMtMS1hZnRlci1pbXBydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14276 - - 13 years 5 months ago [\#106720](#106720) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[0 in DB for minimum quantity that is 1 after imprt](/forum/3-bug-report/83040-0-in-db-for-minimum-quantity-that-is-1-after-imprt#106720 "Hi, When I import products with for example : price_value; price_min_quantity 2.66|2.66;|4 I get in the product details page as you can see in the first picture below. In the second picture you can see that in the database it's also . And in the backend number is shown. [image] [image] [image] It seems that 1 as minimum quantity is not appreciated and converted to in the database. This is a problem for us. Thanks. Cheers.")* As I said, it's for historical reasons. HikaShop always set it to 0 in the database so that it works properly. The min quantity is not displayed on the product page. If you display it yourself, then simply add a check before...It's not complex: if($price->price_min_quantity==0) $price->price_min_quantity=1; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzA0MC0wLWluLWRiLWZvci1taW5pbXVtLXF1YW50aXR5LXRoYXQtaXMtMS1hZnRlci1pbXBydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.127 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)