Author |
Topic |
|
vaheh
VP-CART New User
USA
115 Posts |
Posted - May 06 2013 : 13:07:42
|
Hi Everyone,
I am checking the stock level and working fine. I want to do another mod which will check the stock live with customer POS system through another SQL database.
I have written the SQL procedure code to send "ccode" and get a Integer value as stock level to that SQL database.
My probelm is this and really appreciate your help and I am very thankful for your thoughts and ideas.
at shopdiplayproducts.asp where is the function/sub name that checks stock level so I can add my code there. Also when I am clicking on add to cart what is the page and sub name that checks for stock level.
Thanks, Vaheh
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - May 07 2013 : 00:48:10
|
from my look, you should use code to check example is : if lcase(getconfig("xcheckstocklevel")) = "yes" then checkupdatedstocklevels and this sub checkupdatedstocklevels stored in file called shopstocknotification.asp.
Diego |
|
|
vaheh
VP-CART New User
USA
115 Posts |
Posted - May 07 2013 : 11:22:55
|
Hi Diego,
Thanks for your reply.
shopstocknotification.asp is only for notification and cart recalculation. All of this items are unique and they can''t order more than 1 so I am not worried about that part.
All I want to do is to check the stock level with VPASP DB which it is doing perfectly right now and also check stock level with another database and if either of those are 0 then do not display the items.
Where can I found the code for the shopdisplayproducts.asp the page that is listing all items so I want to hide it there.
Once again thank you so much for your help. Vaheh
|
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - May 11 2013 : 03:17:20
|
ok i think i found it just now, i open file shopstock.asp, and i see this :
sub UpdateStock (orderid) etc... UpdateStockDetails end sub
sub UpdateStockLevels (CatalogId, quantity) etc...
that inside routine are used to update stock levels , and this routine called on end of completion orders (i think is shopthanks.asp) which is the page that usually we arrive after purchase:
UpdateStock ordernumber
running that routine will adjust the stock level after each purchase. i think i hit the target now, hopefully this time its true. Diego. |
|
|
vaheh
VP-CART New User
USA
115 Posts |
Posted - May 13 2013 : 14:08:11
|
Hi Diego,
Thank you so much for your reply. I will check and keep you posted about the result.
Thanks, |
|
|
diegomilito
VP-CART Expert
Argentina
779 Posts |
Posted - June 15 2013 : 03:43:10
|
vaheh, hey , how s with ur result ? im just have time to browse the forum. Diego. |
|
|
vaheh
VP-CART New User
USA
115 Posts |
Posted - June 17 2013 : 11:35:08
|
Hi Diego,
Anthony did a custom programming and so far so good.It is working good. Vaheh |
|
|
|
Topic |
|