[Skip to main content](#vessel-content) # Option to leave product stock counter on purchase ## - **[Bruno](/forum/user/34720-bruno "View Bruno's Profile")** - [![Bruno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34720-bruno "View Bruno's Profile") Topic Author - [ Offline](/forum/user/34720-bruno) Less More - Posts: 16 - Thank you received: 0 - - 11 years 9 months ago [\#186686](#186686) by [Bruno](/forum/user/34720-bruno "View Bruno's Profile") *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186686 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* was created by *[Bruno](/forum/user/34720-bruno "View Bruno's Profile")* -- url of the page with the problem -- : [ www.schmuckdesign24.de/](http://www.schmuckdesign24.de/) -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")** - [![lousyfool's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28604.jpg)](/forum/user/28604-lousyfool "View lousyfool's Profile") - [ Offline](/forum/user/28604-lousyfool) Less More - Posts: 2143 - Thank you received: 747 - - [](http://www.inphase.one) - 11 years 9 months ago [\#186705](#186705) by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile") Replied by *[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")* on topic *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186705 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* > Bruno wrote: I manage a shop where all products get manufactured on demand /purchase. ... and once one is sold, it is still available = getting manufactured on demand again upon next order? If so, why not set the quantity to unlimited (Unbegrenzt)? No stock maintenance necessary then. Or did I get something wrong... in that case sorry... --- Need help with customisations of layouts, style or other site development? [ PM me!](/component/uddeim/?task=new) (Don't forget to turn on [ "E-mail notification of new messages"](/component/uddeim/?task=settings)) The following user(s) said Thank You: [Bruno](/forum/user/34720-bruno "View Bruno's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bruno](/forum/user/34720-bruno "View Bruno's Profile")** - [![Bruno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34720-bruno "View Bruno's Profile") Topic Author - [ Offline](/forum/user/34720-bruno) Less More - Posts: 16 - Thank you received: 0 - - 11 years 9 months ago [\#186712](#186712) by [Bruno](/forum/user/34720-bruno "View Bruno's Profile") Replied by *[Bruno](/forum/user/34720-bruno "View Bruno's Profile")* on topic *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186712 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* You got it right! So where can I set the quantity to unlimited? Checkbox or anything like this. ... I tried to enter unlimited (Unbegrenzt) into the quantity field ... and it keeps the value. If this is the correct way, it is not very sugestiv. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bruno](/forum/user/34720-bruno "View Bruno's Profile")** - [![Bruno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34720-bruno "View Bruno's Profile") Topic Author - [ Offline](/forum/user/34720-bruno) Less More - Posts: 16 - Thank you received: 0 - - 11 years 9 months ago [\#186713](#186713) by [Bruno](/forum/user/34720-bruno "View Bruno's Profile") Replied by *[Bruno](/forum/user/34720-bruno "View Bruno's Profile")* on topic *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186713 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* I just found out: empty field or anything else than a number is the same as unlimited (Unbegrenzt) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")** - [![lousyfool's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28604.jpg)](/forum/user/28604-lousyfool "View lousyfool's Profile") - [ Offline](/forum/user/28604-lousyfool) Less More - Posts: 2143 - Thank you received: 747 - - [](http://www.inphase.one) - 11 years 9 months ago - 11 years 9 months ago [\#186714](#186714) by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile") Replied by *[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")* on topic *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186714 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* > Bruno wrote: I just found out: empty field or anything else than a number is the same as unlimited (Unbegrenzt) Ah, sehr gut! ![:)](/media/kunena/emoticons/8.png ":)") --- Need help with customisations of layouts, style or other site development? [ PM me!](/component/uddeim/?task=new) (Don't forget to turn on [ "E-mail notification of new messages"](/component/uddeim/?task=settings)) Last edit: 11 years 9 months ago by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bruno](/forum/user/34720-bruno "View Bruno's Profile")** - [![Bruno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34720-bruno "View Bruno's Profile") Topic Author - [ Offline](/forum/user/34720-bruno) Less More - Posts: 16 - Thank you received: 0 - - 11 years 9 months ago - 11 years 9 months ago [\#186720](#186720) by [Bruno](/forum/user/34720-bruno "View Bruno's Profile") Replied by *[Bruno](/forum/user/34720-bruno "View Bruno's Profile")* on topic *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186720 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* After inspecting the hikashop database tables with phpAdmin I found out that unlimited (Unbegrenzt) means that the value of product_quantity in the table jos_hikashop_product is "-1" Now I changed all products of the shop with this SQL statement: Code: UPDATE `jos_hikashop_product` SET `product_quantity`=-1; to unlimited ![;)](/media/kunena/emoticons/11.png ";)") Last edit: 11 years 9 months ago by [Bruno](/forum/user/34720-bruno "View Bruno's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#186732](#186732) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186732 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* Hi, That's right, "-1" is the special number for "unlimited". Please note that you can also use the mass-action system if you want to update all your products in your database. [ www.hikashop.com/support/support/documen...massaction-form.html](http://www.hikashop.com/support/support/documentation/167-massaction-form.html) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bruno](/forum/user/34720-bruno "View Bruno's Profile")** - [![Bruno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34720-bruno "View Bruno's Profile") Topic Author - [ Offline](/forum/user/34720-bruno) Less More - Posts: 16 - Thank you received: 0 - - 11 years 9 months ago - 11 years 9 months ago [\#186845](#186845) by [Bruno](/forum/user/34720-bruno "View Bruno's Profile") Replied by *[Bruno](/forum/user/34720-bruno "View Bruno's Profile")* on topic *[Option to leave product stock counter on purchase](/forum/35-orders-management/874261-option-to-leave-product-stock-counter-on-purchase#186845 "-- url of the page with the problem -- : www.schmuckdesign24.de/ -- HikaShop version -- : 2.3.5 Bussines -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 I manage a shop where all products get manufactured on demand /purchase. When somone purchases a product I want to leave the on stock counter untouched. I have tried some options but didn't find the right option. Is there a possibility to change the shops behavior as described? Just now I always have to set the stock counter back to 1 if someone purchses a product.")* Thanks for the hint, I will try the mass-action system next time Last edit: 11 years 9 months ago by [Bruno](/forum/user/34720-bruno "View Bruno's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NDI2MS1vcHRpb24tdG8tbGVhdmUtcHJvZHVjdC1zdG9jay1jb3VudGVyLW9uLXB1cmNoYXNlP3RtcGw9bWFya2Rvd24=) 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.324 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)