Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Stock Check with another Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vaheh
VP-CART New User

USA
115 Posts

Posted - May 06 2013 :  13:07:42  Show Profile  Visit vaheh's Homepage  Reply with Quote
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  Show Profile  Reply with Quote
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
Go to Top of Page

vaheh
VP-CART New User

USA
115 Posts

Posted - May 07 2013 :  11:22:55  Show Profile  Visit vaheh's Homepage  Reply with Quote
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




Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - May 11 2013 :  03:17:20  Show Profile  Reply with Quote
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.
Go to Top of Page

vaheh
VP-CART New User

USA
115 Posts

Posted - May 13 2013 :  14:08:11  Show Profile  Visit vaheh's Homepage  Reply with Quote
Hi Diego,

Thank you so much for your reply.
I will check and keep you posted about the result.

Thanks,
Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - June 15 2013 :  03:43:10  Show Profile  Reply with Quote
vaheh, hey , how s with ur result ? im just have time to browse the forum.
Diego.
Go to Top of Page

vaheh
VP-CART New User

USA
115 Posts

Posted - June 17 2013 :  11:35:08  Show Profile  Visit vaheh's Homepage  Reply with Quote
Hi Diego,

Anthony did a custom programming and so far so good.It is working good.
Vaheh
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00