New Arrivals Order?
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=1716
Printed Date: 07-October-2024 at 11:20am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: New Arrivals Order?
Posted By: rotokirby
Subject: New Arrivals Order?
Date Posted: 14-June-2008 at 6:51pm
|
Does anyone know how to change to order that products are shown on the New Arrivals page (shownewarrivals.asp)?
I can't even figure out how the order is determined. It's not sorting by name or price or SKU as far as I can tell. It isn't even sorted by the ProdID. Right now I've got a bunch of items that are just sticking at the top of the page no matter how many new items I add to the store. New items are showing up in the middle of the New Arrivals page. I would like it to default sort by SKU (descending)....that would put our newest products at the top of the new arrivals page. Even better would be if the user Sort be allowed on that page.... Thanks in advance. ------------- Rotofugi Designer Toy Store & Gallery Chicago > IL > US http://rotofugi.com - http://rotofugi.com |
Replies:
Posted By: Hamish
Date Posted: 14-June-2008 at 9:10pm
|
Hi, From the WIKI :- "All the features available on the page are the same as the ones described for Manage Best Sellers, with exception to the following difference: New arrivals only include products that have been added in the last N days (as determined by each user).
For example, if you added 14, only products that have been added to the database in the last 14 days would be displayed on the New Arrivals page." and for that (Best Sellers) see : http://wiki.earlyimpact.com/productcart/marketing-best_sellers To change the order you need to tweak the SQL statement, lines 113 & 115 in my copy. Change the end of the SQL statements from :- ORDER BY products.pcprod_EnteredOn DESC;" to: ORDER BY products.sku DESC;" (Not tested - but give it a try  ) - Don't forget the guidelines as per my Sig I've not looked into pcprod_EnteredOn , but I'd say that its the date that items were added to the stores db, so I'm surprised it's not doing what you need anyway. Perhaps those "stuck" items have a duff or future "entered on" date? ------------- Editing ProductCart Code? See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code |
Posted By: rotokirby
Date Posted: 14-June-2008 at 9:30pm
|
I'll give that a shot and report back....as always, thanks for the helpful advice! ------------- Rotofugi Designer Toy Store & Gallery Chicago > IL > US http://rotofugi.com - http://rotofugi.com |
Posted By: rotokirby
Date Posted: 15-June-2008 at 1:33am
|
I didn't try your solution yet Hamish, but I did a little digging around in the database and it seems that the pcProd_EnteredOn variable only stores the date and not the time an item is added to the database, thus the behavior I was seeing. All of the items added on a given day are stamped with the date but they all say they were added at 12:00:00 AM. It's like having a VCR without the clock set. LOL.
As items are added they were going onto the end for that day's new arrivals, thus the reason they were showing up in the middle of the New Arrivals page since I've been adding a lot of stuff in preparation for our launch this coming Wednesday. I think I'll just bear with it for now given the number of other things I need to finish before then, but it would certainly be helpful if, in the future, PC could record both the date and time items are added to the database so that the New Arrivals would sort more accurately. ------------- Rotofugi Designer Toy Store & Gallery Chicago > IL > US http://rotofugi.com - http://rotofugi.com |
Posted By: Hamish
Date Posted: 15-June-2008 at 3:30am
|
Hi, I guess it's because it's designed around normal use, where a store is less volatile. Most of the time stores are a lot less volatile than they are pre-launch, with only a few items changing each time. I guess for stores with a very hgh volume of new items each day it may matter, but even then I suspect the new arrivals on any one day would just all be added in one go, so would not necessarily be added in any particular order. ------------- Editing ProductCart Code? See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code |
Posted By: ProductCart
Date Posted: 15-June-2008 at 4:02am
|
Nice avatars you two! This is an area of the application where we agree that the store manager should have more control. Some products might not need to be listed among the new arrivals, some might need to be listed even if they are not strictly the newest. I don't know whether we will have time to enhance this area of the application for the upcoming v3.5 release (July release). We'll keep you posted. Massimo ------------- The ProductCart Team Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software |
Posted By: rotokirby
Date Posted: 15-June-2008 at 4:09am
|
Edited because I posted before seeing Massimo's reply. :)
Massimo, thank you again for being so active here on the forums and listening to user input. If there is a way to just get the time entered involved in the equation we'd be set. ------------- Rotofugi Designer Toy Store & Gallery Chicago > IL > US http://rotofugi.com - http://rotofugi.com |
Posted By: Hamish
Date Posted: 15-June-2008 at 4:23am
|
Hi Massimo, My Avatar is one of Rotokirby's products, when I looked at his store I thought many of them would make great Avatar's - so I asked if I could borrow one ------------- Editing ProductCart Code? See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code |
Posted By: rotokirby
Date Posted: 15-June-2008 at 4:40am
|
And we definitely appreciate the extra promotion! :)
If anyone is interested, Hamish's avatar is "Bossy Bear" by artist David Horvath, manufactured by Hong Kong toy makers Toy2R. ------------- Rotofugi Designer Toy Store & Gallery Chicago > IL > US http://rotofugi.com - http://rotofugi.com |
Posted By: rotokirby
Date Posted: 19-June-2008 at 12:34pm
|
BTW Hamish, your suggestion above worked perfectly for us. ------------- Rotofugi Designer Toy Store & Gallery Chicago > IL > US http://rotofugi.com - http://rotofugi.com |
Posted By: mrindian
Date Posted: 31-October-2008 at 4:47pm
|
Question: Is their anyway of taking an existing item and making it a new item? My problem: I've had products for years, but I have fully updated the product - so it's a basically a new product - but it still has the same part number since it's updated. Therefore - any way of making it a new product without deleting it from the product cart database and re-entering it as a new product? Or do I have to goto the actual sql database and update the field? Thanks, Gary Stark _popupControl(); |
Posted By: Hamish
Date Posted: 31-October-2008 at 5:04pm
|
Hi Gary, Set them as "Featured Products" instead of "New Arrivals".
------------- Editing ProductCart Code? See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code |
Posted By: rotokirby
Date Posted: 31-October-2008 at 5:06pm
|
How about cloning it, then de-activating the original product. In my experience the only thing that isn't cloned are "additional" photos. ------------- Rotofugi Designer Toy Store & Gallery Chicago > IL > US http://rotofugi.com - http://rotofugi.com |
Posted By: mrindian
Date Posted: 31-October-2008 at 10:15pm
|
Thanks for the suggestions - I've listed them as featured products also (sometimes) but I like the automatic feature of "New Arrivals". In my business - making parts for Antique Indian Motorcycles, People don't come to the online store until they need a part, so I like to show all new arrivals for the past 365 days. This lets customers now we are making new stuff for their bikes, and not just keeping existing items in stock... I can try the cloning feature, just looking for an easy way to modify the entry date. If it could be added in a future release... < > Just a check mark - reset product arrival date(or whatever ei would call it.Gary |
Posted By: ProductCart
Date Posted: 03-November-2008 at 7:00am
|
Certainly a good suggestion for the future. Right now ProductCart only saves the date a product was added on ("pcprod_EnteredOn" in the "products" table). There could be another field that would store the date that the product has been modified on (which at the beginning would have the same date as "pcprod_EnteredOn"), and a way to tell the "Show New Arrivals" feature to use that date instead of the "pcprod_EnteredOn" date. This is also something that an ASP developer could do quite easily (more involved for us as we need to update all of the add-on's that use the same files). ------------- The ProductCart Team Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software |