Daily Sales
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3503
Printed Date: 22-February-2025 at 3:42pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Daily Sales
Posted By: amgqmp1
Subject: Daily Sales
Date Posted: 11-March-2010 at 4:10pm
|
I have been running a PC 2.76 shop for many years, and recently upgraded all the way to 4. One feature that I'm missing is the ability to quickly see our current daily sales. Just viewing the sales reports section in 2.76 would provide that data. Has it been relocated? If yes, where? If no, any easy hack to bring it back?  |
Replies:
Posted By: whizzinpc
Date Posted: 12-March-2010 at 11:37am
|
I don't think it can be found anywhere unless you run a report. We added it manually. I just modified the code. invoicing.asp look for the following section.
<% While Not rs.eof pTotal=rs("total") pIdOrder=rs("idOrder") pIdOrder=scpre + int(pIdOrder) %> <li><%response.write "Order #: "&pIdOrder&" - Total: "&scCurSign & money(pTotal)%> - <a class="resultslink" href="Orddetails.asp?id=<%=rs("idorder")%>" onFocus="if(this.blur)this.blur()">View details >></a></li> <%rs.MoveNext%> <%Wend%> </ul> <% end if Set rs=Nothing %> and change it to: <% While Not rs.eof pTotal=rs("total") pIdOrder=rs("idOrder") pIdOrder=scpre + int(pIdOrder) pTotalDay = pTotalDay + pTotal %> <li><%response.write "Order #: "&pIdOrder&" - Total: "&scCurSign & money(pTotal)%> - <a class="resultslink" href="Orddetails.asp?id=<%=rs("idorder")%>" onFocus="if(this.blur)this.blur()">View details >></a></li> <%rs.MoveNext%> <%Wend%> </ul> <p>Today's total: <% Response.write scCurSign & money(pTotalDay)%><br> </p> <% end if Set rs=Nothing %> It basically adds the daily total to this page just below the list of all orders for the day. You get to the page from Orders>Locate an Order. |
Posted By: amgqmp1
Date Posted: 12-March-2010 at 12:41pm
|
You are my hero for the day! That worked out beautifully, and I'll learn from that code to add it to the home page too. Thank you!  |