Product Review Reminders on Apparel Stores |
Post Reply |
Author | |
Guests
Guest |
Post Options
Thanks(0)
Posted: 06-November-2013 at 9:57pm |
A client with an apparel store where almost all products are apparel products pointed out to me that he could not use the feature for review reminders because it always return the following message:
"Cannot send 'Write a Review' reminder because all products of this order cannot be reviewed." I discovered that this is because the query that checks for available products doesn't return any records if all items in the order are apparel items. I believe the following correction should be suitable:
The issue is with the different ways "active/inactive" are handled with apparel products.
|
|
whizzinpc
Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20 |
Post Options
Thanks(0)
|
What file does this apply to?
|
|
Guests
Guest |
Post Options
Thanks(0)
|
Sorry. That would have been helpful, eh? /productcart/pcadmin/prv_AutoSendEmails.asp
|
|
whizzinpc
Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20 |
Post Options
Thanks(0)
|
FYI.... I tried applything this to our store which has a mix of Apparel and non-Apparel products.... and the emails stopped sending on regular products.
|
|
Guests
Guest |
Post Options
Thanks(0)
|
My bad.
Not sure how I get this backwards in what I pasted earlier, but the check for standard products should be (products.active<>0 AND products.pcprod_Apparel=0) not (products.active<>0 AND products.pcprod_Apparel=1) ... which of course never be true. Here's the correction in full:
Either standard products, apparel products or a combination will be returned.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |