Using ProductCart - Product Review Reminders on Apparel Stores

Product Review Reminders on Apparel Stores

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=5745
Printed Date: 05-October-2024 at 12:01am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Product Review Reminders on Apparel Stores

Posted By: Guests
Subject: Product Review Reminders on Apparel Stores
Date 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.

Replies:

Posted By: whizzinpc
Date Posted: 04-January-2014 at 2:23pm

What file does this apply to?

Posted By: Guests
Date Posted: 04-January-2014 at 3:10pm

whizzinpc wrote:

What file does this apply to?

Sorry. That would have been helpful, eh?

/productcart/pcadmin/prv_AutoSendEmails.asp

Posted By: whizzinpc
Date 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.

Posted By: Guests
Date 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.