| |
| 1. | Best Seller Count by item, not order
Posted by lvmultimedia on 8/21/2004 7:48:13 AM
Hi Jules,
The TopSellers query counts the number of orders an item is on so, if someone buys 7 of an item on one order, top sellers counts it as 1, as it is only on one order.
Is there an easy fix to make TopSellers count the quantity of an item sold, instead of the count of how many orders it was placed on?
The current SQL:
SELECT TOP 5 [OrderDetails].[ProductID], [Products].[Product], [Products].[CategoryID], ... |
| 2. | Re: Best Seller Count by item, not order
Posted by lvmultimedia on 8/23/2004 8:19:50 AM
Thanks Jules,
I just had to add to the SQL a bit about the CategoryID and it works like a charm |
| 3. | Re: Best Seller Count by item, not order
Posted by lvmultimedia on 8/26/2004 7:39:08 AM
Hi Jules,
This does put the products in the right order that I need... by quantity of items sold instead of quantity of orders an item is on, but it lists all the products sold...not just the top 5.
Any ideas of what to try?
SELECT TOP 5 OrderDetails.ProductID, Products.Product, Sum(OrderDetails.Quantity) AS SumOfQuantity
FROM OrderDetails INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID
GROUP BY OrderDetails.ProductID, ... |
| 4. | Re: Best Seller Count by item, not order
Posted by lvmultimedia on 8/26/2004 6:40:14 PM
this one is really confusing.... still listing all products sold, instead of the top 5....
I'll be testing, trying to figure it out too,.... but if something hits you, please pass it on! |
| 5. | Re: Best Seller Count by item, not order
Posted by lvmultimedia on 9/5/2004 12:50:21 PM
Hi Jules,
After thinking on this, I may have a theory as to why this is showing more than the Top 5...
Please let me know if I a correct in this theory.
The sql is pulling the top 5 by quantity of items, but because the quantities are currently like those below, we are getting more than 5 items in the "Top 5".
item A1 sold 7 items and shows up 1st
item B2 sold 2 items and shows up 2nd
item C3 sold 1 item and shows up ... |
| 6. | Re: Best Seller Count by item, not order
Posted by lvmultimedia on 9/8/2004 7:00:19 AM
right,
Sorry about that, I sent you my local version of the database, which only had 5 items sold.
I just downloaded the site database, took a look, and the topSellers query has pulled all 6 of the titles that have sold. ... and if you look at www.savpress.com you will see that Best Sellers in the left column lists 6 titles (one looks like it is doubled, but it is actually 2 different items, one hardcover, one paperback)
When I had originally found this problem, ... |
| 7. | Microsoft VBScript runtime error '800a005e'
Posted by lvmultimedia on 12/14/2004 1:44:09 PM
Hi Jules!
when trying to send to the mailing list, I received this error... (however I do know that the mail was sent, as I received it) I should have been directed back to the admin home page but the error I get is:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Replace'
/adminsection/mailing_list.asp, line 41
line 41 is:
tmpStr=Replace(tmpStr,"#" & fld.Name & ... |
| 8. | Re: Microsoft VBScript runtime error '800a005e'
Posted by lvmultimedia on 12/31/2004 12:16:59 PM
ooops... forgot to reply that your answer worked fine!
I also wanted to thank you again......and again... for a fantastic extention!
Happy new year! |
| 9. | Cdosys email throwing an Internal Server Error
Posted by lvmultimedia on 8/26/2007 5:14:16 PM
Hi Julian!
I thought I'd go to the guy who got me started....
I am trying to set up a simple form on many of my sites, that would call on the cdosys.asp page below to send the form contents in an email.. using the smtp server for that domain. I have taken out only the REAL authentication information for the smtp server in the code below. When I try and run this, I get a very generic 500 Internal Server Error.... (you know, ask your system administrator)
|
| 10. | Re: Shipping for some items and no shipping for others
Posted by lvmultimedia on 11/11/2006 4:18:10 PM
Yes, 3.5 is added no matter what. Taking 3.5 out will not work, as that is the shipping charge for the first hardcover book, if there is one purchased.
I'm sure it is a logical issue.... obviously I'm not very logical, which is why I asked for your help :)
this is where I am now, I'll explain it again, in case I wasn't clear before:
this charges 3.50 for the first item, and .50 for every item after the first item. I need the script to realize what ... |
| 11. | Shipping for some items and no shipping for others
Posted by lvmultimedia on 10/26/2006 11:54:02 AM
Hi Jules:
I use this to have shipping of 3.50 for the first item, then .50 for each additional item...
<%
'
'Add shiping costs to cart
'
TotNumItems=objCart.TotalNumberItems
%>
<%
objCart.Shipping=("3.50" + ((TotNumItems-1)*"0.5"))
%>
That works fine... But now I need to be able to apply an IF THEN statement to allow a product to not be charged a shipping ... |
| 12. | Re: Shipping for some items and no shipping for others
Posted by lvmultimedia on 10/28/2006 4:22:35 PM
ok, I'm an idiot.
I've never added a cart column (not that I remember anyway). I just added a new column "Download"
I would like the cart to NOT charge shipping for any line item where the "download" column in my product table is marked "True" and add 3.50 shipping for the FIRST item that the download column is "FALSE" and then for every additional LINE item that is not a download another .50 should be added.
|
| 13. | Re: Shipping for some items and no shipping for others
Posted by lvmultimedia on 11/2/2006 1:31:49 PM
Hi Jules, thanks again... this is still not working (it is charging shipping for all line items, even if they are downloads) can you see anything wrong?
<%
'
'Add shiping costs to cart
'
TotNumItems=objCart.TotalNumberItems
for i=0 to ubound(objCart.CCcart,2)
if objCart.GetCartValue("Download",i)="True" then
'It's a download
TotNumItems=TotNumItems-1
end if
next
|
| 14. | Re: Shipping for some items and no shipping for others
Posted by lvmultimedia on 11/9/2006 8:12:39 AM
When someone purchases a download, it should not charge any shipping, but it is charging for shipping.... the new procedure isn't doing anything different than what I had originally. |
| 15. | Re: mailing list
Posted by lvmultimedia on 11/9/2006 8:30:54 AM
I have a few customers who have similar situations.
What I have done is duplicated the mailinglist.asp page as many times as needed to split up the database. I call them mailinglist1.asp mailinglist2.asp etc... and each page has its own recordset pulling email addresses by recordID number to limit it to a certain number. The last page I made started with the least amount, as any new emails added will be added to this partial list. Every month or so, I check on that last recordset to see ... |
| 16. | Review.asp and CAPTCHA
Posted by lvmultimedia on 6/22/2006 4:04:06 PM
Has anyone implemented a CAPTCHA on thier reviews.asp page? (similar to yahoo logins, where the person posting a review would enter the wavy or mangled text shown in an image to prove they were a person, not a spam bot).
I have tried, but the free scripts I have found so far must be sent from the review.asp page to another page altogether. I either need help altering this free script to allow it to post back to the review.asp page, or I need help splitting the review.asp page to work by ... |
| 17. | adding a 2nd Transferorderpaypal.asp page
Posted by Lvmultimedia on 4/29/2006 1:30:40 PM
Hi jules,
on one of my sites, www.savpress.com, we are selling books and a couple cd's... that is and has been working fine. Now the web site owner wants to add the capability of downloading mp3 files of his books for a fee.
should I make a 2nd transferorderpaypal.asp page so that anyone who purchases a download will/can be redirected from paypal to the download page.....or is there a way ...possibly using if/then/else/end if statements to alter this part of the current transfer ... |
| 18. | Cart stopped working I haven't a clue why.
Posted by Lvmultimedia on 4/6/2006 12:55:19 PM
I'm not sure what is happening to one of my sites... so far, these strange things are happening, all of a sudden, with no new uploads or changes to the site (the site has worked for over a year) here is what I have found (so far)
..oh, I can view products, and detail pages, but cannot do these other things, so it cant be a connection problem or I wouldn't be able to view the products...
the site is www.whimsikidz.com if you want a go at it
When trying to add a ... |
| 19. | Re: Cart stopped working (now have a clue)
Posted by Lvmultimedia on 4/6/2006 1:04:47 PM
OK, the cart works fine... turns out that none of my sites work on this computer, but work fine on another one I have.... probably because of a new software suite I installed for spam, antivirus, and firewall.
sorry for the false alarm post! |
| 20. | Shipping recordset
Posted by lvmultimedia on 8/18/2005 8:01:45 AM
Hi Jules, this shipping rs doesn't work...can't seem to find out why. When I input a default value, and test in DMX2004 it pulls correctly from the database. When tested live, shipping is always $0.00 unless I change the default value to a number above $0 ...then pulls the shipping for that number, but not what the actual cart subtotal is. .. Can you see what is wrong here?
<%
Dim ShippingRS__value
ShippingRS__value = "0"
If ... |
| 21. | Re: Shipping recordset
Posted by lvmultimedia on 8/19/2005 4:38:27 AM
there goes Jules...brilliant as usual
I appeciate it!
Larry |
| 22. | Sales tax, based on ShipRegion
Posted by lvmultimedia on 7/25/2005 5:49:11 PM
Hi Jules, I'm trying to add the tax value from a recordset, based on the ShipRegion (State).
I have a table called "States" with the two letter state abbreviation (State) and the corresponding Sales Tax Rate (SalesTax)
The code below will add the custom shipping charge I made, but no tax is ever added, no matter what ShipRegion is in the Customers table.
can you take a look and see if you can see why?
thanks!
<%
set ... |
| 23. | Re: Sales tax, based on ShipRegion
Posted by lvmultimedia on 7/27/2005 6:28:57 AM
SELECT * FROM States WHERE State = 'AK'
AK is the default value of the Recordset.
so, the TaxRS is empty but I haven't a clue why...
When I enter an order with my own login, I know the ShipRegion of "WI", is in the database, so I'm not sure why or what I should be coding to pull the information correctly.
|
| 24. | Re: Sales tax, based on ShipRegion
Posted by lvmultimedia on 8/18/2005 7:48:00 AM
Thanks Jules! |
| 25. | Dreaded Categories
Posted by lvmultimedia on 7/20/2005 7:08:13 AM
Hi Julian!... its been a while...
I apologize in advance, I have read, re-read, and re-re-read all the posts I could find on categories and subcategories, but I just can't figure out how to do this. It seems so simple!
If I have these categories/subcategories:
Toys
-Games
-Plush
-Puzzles
Books
-Baby
-Toddler
-Child
-Young Adult
-Parent
-Grandparent
|
|
|
|
|