Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » setting stock tracking for version item on sql

setting stock tracking for version item on sql

Posted By erdemalkan Thu 16 May 2013
Add to Favorites0

setting stock tracking for version item on sql

Topic View Topic View Topic Options Topic Options
Author Message
erdemalkan
Posted Thu 16 May 2013
Supreme Being

Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)

Group: Awaiting Activation
Last Active: Mon 30 Sep 2013
Posts: 0, Visits: 95
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
Post Information
Medz Marked As Answer
Posted Fri 17 May 2013
Kartris Expert

Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)Kartris Expert - (58,808 reputation)

Group: Administrators
Last Active: Tue 3 Dec 2013
Posts: 99, Visits: 1,400
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.
Post Information
erdemalkan
Posted Fri 17 May 2013
Supreme Being

Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)Supreme Being - (9,176 reputation)

Group: Awaiting Activation
Last Active: Mon 30 Sep 2013
Posts: 0, Visits: 95
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
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.156. 11 queries. Compression Enabled.