Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Tracking Messages
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pdieppa
VP-CART New User

USA
86 Posts

Posted - April 24 2013 :  17:03:14  Show Profile  Reply with Quote
What is the best way to find orders that have tracking messages?

Thanks

PD

diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - April 25 2013 :  00:53:42  Show Profile  Reply with Quote
hey PD, from my thinking, you can use my method here
- going to your administration of VPASP
- there is a Misc > Edit Tables menu
- OrderTracking table there
- click on the Switch to Advanced
- in there a "Display" list, you can pick the wanted fields to show maybe you select orderid, and trackcomment.
- click display
- and see you get what you want !
tell me that my idea is good
Diego..
Go to Top of Page

manilow
VP-CART New User

France
134 Posts

Posted - April 25 2013 :  03:58:11  Show Profile  Visit manilow's Homepage  Reply with Quote
Hi,

I changed the link "Tracking Messages" in the admin section (tmp_adminheader.htm and tmp_adminheader_full.htm) to :

shopa_editdisplay.asp?table=ordertracking&SortUpdown=Desc

In this way you''ll see the last tracking messages.

Regards,

Erik
www.AquaThermia.com
Go to Top of Page

support
Administrator

4679 Posts

Posted - April 25 2013 :  04:17:43  Show Profile  Visit support's Homepage  Reply with Quote
Hi Erik and Diego,

Nice tweak!

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

************************************
Did you know VPASP now offers premium Cloud based e-commerce web hosting?

Ask me for more details on how we can help you with a complete solution to your
online needs.
************************************
Go to Top of Page

pdieppa
VP-CART New User

USA
86 Posts

Posted - April 25 2013 :  12:15:53  Show Profile  Reply with Quote
I like both options. Diego''s is the quick and dirty way, Erik is the elegant for my customer service people.

Do you think I could edit the shopa_editdisplay.asp and add a url link to the orderid field which will open the order? We want to start responding to those messages within VPASP.

shopa_trackingorder.asp?oid=XXXXX (replace with oid)

Thanks

PD
Go to Top of Page

pdieppa
VP-CART New User

USA
86 Posts

Posted - April 26 2013 :  11:07:41  Show Profile  Reply with Quote
After looking at the code for shopa_editdisplay.asp, I realized I can''t make any of those fields URLS linking to shopa_trackingorder.asp because that script is also used for other views other than tracking messages. I guess I will have to create my own script.

Does anyone know at what point the field "Viewed" is set to "YES"? Right now, I don'' see a way to find messages that have not been viewed or responded to. All of mine entries on the tracking table are set to YES.
Go to Top of Page

manilow
VP-CART New User

France
134 Posts

Posted - April 26 2013 :  12:14:17  Show Profile  Visit manilow's Homepage  Reply with Quote
Hi PD,

Maybe this approach is what you would like to obtain. I created another "Tracking Messages" link in the admin section (tmp_adminheader.htm and tmp_adminheader_full.htm) :

shopa_displayorders.asp?SortA=Yes&Selectioncritereontext=SELECT+orders%2E%2A+FROM+orders+LEFT+JOIN+ordertracking+ON+orders%2Eorderid%3Dordertracking%2Eorderid+ORDER+BY+ordertracking%2Etrackdate+DESC

Paste the link exactly in this format in the admin templates or, to try first, in the address bar. In this way you''ll see all orders having a tracking message (including your own), ordered by the tracking message date.

Another way is to save the SQL query in the shopa_query.asp page. Then paste the following SQL query:

S ELECT orders.* FROM orders LEFT JOIN ordertracking ON orders.orderid=ordertracking.orderid ORDER BY ordertracking.trackdate DESC

(Delete the space in the word S ELECT; the forum doesn''t allow the sql query string)

I hope this will solve your request.

Kind regards,

Erik
www.AquaThermia.com
Go to Top of Page

Mark Priest
VP-CART Expert

United Kingdom
580 Posts

Posted - October 21 2014 :  20:19:47  Show Profile  Reply with Quote
This is great.

With this tweak shopa_editdisplay.asp?table=ordertracking&SortUpdown=Desc

is there a way to add it so it doesn''t display all my own tracking messages? for example anything with the trackname admin

Regards,

Mark
[URL="http://www.fireworkscrazy.co.uk" rel="nofollow"]Fireworks For Sale[/URL]
Go to Top of Page

manilow
VP-CART New User

France
134 Posts

Posted - October 22 2014 :  16:30:01  Show Profile  Visit manilow's Homepage  Reply with Quote
Hi Mark,

The link below displays all orders with a tracking message, ordered by date in reverse order :

<a href="shopa_displayorders.asp?SortA=Yes&Selectioncritereontext=SELECT+orders.*+FROM+orders+LEFT+JOIN+ordertracking+ON+orders.orderid%3Dordertracking.orderid+where+trackname+not+like+''%25admin%25''+ORDER+BY+ordertracking.trackdate+DESC"><%=GetLang("langadmintrackmessage")%></a>


Replace ''admin'' by the tracking name from which you don''t want orders to appear.
Kind regards,

Erik
www.aquathermia.com
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