setting stock tracking for version item on sql Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues https://forum.kartris.com/Topic2084.aspx

Print Topic | Close Window

By erdemalkan - Thu 16 May 2013 Hi,I got more then 10000 product version. i need to set stock track option for preventing customers buying stocked out items. Could'nt find how i can do that on Database side. Could you please help me. Regards Erdem By Medz - Fri 17 May 2013 Hi Erdem, You can try to run the query below -> UPDATE [dbo].[tblKartrisVersions] SET [V_QuantityWarnLevel] = 1 This will set all your versions' Quantity Warn Level to 1. Anything with a quantity warn level greater than 0 is regarded stock tracking enabled. Be reminded though that you also need to set 'frontend.orders.allowpurchaseoutofstock' config setting to 'n' to disable the 'add to basket' button for out-of-stock items. By erdemalkan - Fri 17 May 2013 Ok i changed this setting to 'n' for 'frontend.orders.allowpurchaseoutofstock', but customers still can add items to the basket. If tracking is not selected for the item. for your info