ProductCart Shopping Cart Software Forums : Product Review Reminders on Apparel Stores https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 03:44:14 +0000 Fri, 31 Jan 2014 22:08:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5745 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Product Review Reminders on Apparel Stores : My bad.Not sure how I get this...]]> https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21795.html#21795 Author: Guests
Subject: 5745
Posted: 31-January-2014 at 10:08pm

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:
'Check availabe products
'<WMS: Fix for orders with all apparel products>
'queryQ="SELECT products.idProduct FROM Products INNER JOIN ProductsOrdered ON Products.idProduct=ProductsOrdered.idProduct WHERE ProductsOrdered.idOrder=" & aryRows(0, intX) & " AND Products.active<>0 AND Products.removed=0 AND (Products.idProduct NOT IN (SELECT pcRE_IDProduct FROM pcRevExc));"
queryQ="SELECT products.idProduct FROM Products INNER JOIN ProductsOrdered ON Products.idProduct=ProductsOrdered.idProduct WHERE ProductsOrdered.idOrder=" & aryRows(0, intX) & " AND ((products.active<>0 AND products.pcprod_Apparel=0) OR (products.pcProd_SPInActive=0 AND products.pcprod_ParentPrd>0)) AND Products.removed=0 AND (Products.idProduct NOT IN (SELECT pcRE_IDProduct FROM pcRevExc));"

Either standard products, apparel products or a combination will be returned.
]]> Fri, 31 Jan 2014 22:08:13 +0000 https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21795.html#21795 <![CDATA[Product Review Reminders on Apparel Stores : FYI.... I tried applything this...]]> https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21794.html#21794 Author: whizzinpc
Subject: 5745
Posted: 31-January-2014 at 3:12pm

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.]]> Fri, 31 Jan 2014 15:12:35 +0000 https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21794.html#21794 <![CDATA[Product Review Reminders on Apparel Stores : whizzinpc wrote:What file does...]]> https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21768.html#21768 Author: Guests
Subject: 5745
Posted: 04-January-2014 at 3:10pm

Originally posted by whizzinpc whizzinpc wrote:

What file does this apply to?

Sorry. That would have been helpful, eh?

/productcart/pcadmin/prv_AutoSendEmails.asp
]]> Sat, 04 Jan 2014 15:10:14 +0000 https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21768.html#21768 <![CDATA[Product Review Reminders on Apparel Stores : What file does this apply to? ]]> https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21767.html#21767 Author: whizzinpc
Subject: 5745
Posted: 04-January-2014 at 2:23pm

What file does this apply to?]]> Sat, 04 Jan 2014 14:23:12 +0000 https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21767.html#21767 <![CDATA[Product Review Reminders on Apparel Stores : A client with an apparel store...]]> https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21683.html#21683 Author: Guests
Subject: 5745
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:
'Check availabe products
'<WMS: Fix for orders with all apparel products>
'queryQ="SELECT products.idProduct FROM Products INNER JOIN ProductsOrdered ON Products.idProduct=ProductsOrdered.idProduct WHERE ProductsOrdered.idOrder=" & aryRows(0, intX) & " AND Products.active<>0 AND Products.removed=0 AND (Products.idProduct NOT IN (SELECT pcRE_IDProduct FROM pcRevExc));"
queryQ="SELECT products.idProduct FROM Products INNER JOIN ProductsOrdered ON Products.idProduct=ProductsOrdered.idProduct WHERE ProductsOrdered.idOrder=" & aryRows(0, intX) & " AND ((products.active<>0 AND products.pcprod_Apparel=1) OR (products.pcProd_SPInActive=0 AND products.pcprod_ParentPrd>0)) AND Products.removed=0 AND (Products.idProduct NOT IN (SELECT pcRE_IDProduct FROM pcRevExc));"
The issue is with the different ways "active/inactive" are handled with apparel products.
]]> Wed, 06 Nov 2013 21:57:30 +0000 https://forum.productcart.com/product-review-reminders-on-apparel-stores_topic5745_post21683.html#21683