Author |
Topic |
|
pdieppa
VP-CART New User
USA
86 Posts |
Posted - April 24 2013 : 17:03:14
|
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
|
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.. |
|
|
manilow
VP-CART New User
France
134 Posts |
Posted - April 25 2013 : 03:58:11
|
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 |
|
|
support
Administrator
4679 Posts |
Posted - April 25 2013 : 04:17:43
|
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. ************************************ |
|
|
pdieppa
VP-CART New User
USA
86 Posts |
Posted - April 25 2013 : 12:15:53
|
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 |
|
|
pdieppa
VP-CART New User
USA
86 Posts |
Posted - April 26 2013 : 11:07:41
|
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. |
|
|
manilow
VP-CART New User
France
134 Posts |
Posted - April 26 2013 : 12:14:17
|
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 |
|
|
Mark Priest
VP-CART Expert
United Kingdom
580 Posts |
Posted - October 21 2014 : 20:19:47
|
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] |
|
|
manilow
VP-CART New User
France
134 Posts |
Posted - October 22 2014 : 16:30:01
|
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 |
|
|
|
Topic |
|