setting stock tracking for version item on sql

Posted By erdemalkan Thu 16 May 2013
Add to Favorites0
Author Message
erdemalkan
 Posted Fri 17 May 2013
Supreme Being

Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 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
Medz Marked As Answer
 Posted Fri 17 May 2013
Kartris Expert

Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 reputation)Kartris Expert - (66,108 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.
erdemalkan
 Posted Thu 16 May 2013
Supreme Being

Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 reputation)Supreme Being - (10,254 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

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top