<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>ProductCart Shopping Cart Software Forums : saved shopping carts message</title>
  <link>https://forum.productcart.com/</link>
  <description><![CDATA[This is an XML content feed of; ProductCart Shopping Cart Software Forums : Using ProductCart : saved shopping carts message]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Sat, 11 Apr 2026 22:40:02 +0000</pubDate>
  <lastBuildDate>Sat, 21 Apr 2012 20:52:23 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.04</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://forum.productcart.com/RSS_post_feed.asp?TID=5107</WebWizForums:feedURL>
  <image>
   <title><![CDATA[ProductCart Shopping Cart Software Forums]]></title>
   <url>https://forum.productcart.com/forum_images/pc_logo_50.png</url>
   <link>https://forum.productcart.com/</link>
  </image>
  <item>
   <title><![CDATA[saved shopping carts message : There actually is a pretty easy...]]></title>
   <link>https://forum.productcart.com/saved-shopping-carts-message_topic5107_post19530.html#19530</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forum.productcart.com/member_profile.asp?PF=2">Guests</a><br /><strong>Subject:</strong> 5107<br /><strong>Posted:</strong> 21-April-2012 at 8:52pm<br /><br />There actually is a pretty easy way to manage this automatically.<div><br></div><div>ProductCart has a routine it runs monthly to clean up some statistics data is stores on items added to cart. It checks for whether it's time to run the clean up again every time an item is added to cart.</div><div><br></div><div>In&nbsp;<em>pc/inc_SaveShoppingCart.asp</em>&nbsp;look for the following around line 170:</div><div><table width="99%"><tr><td><pre class="BBcode"></div><div><div><span ="Apple-tab-span" style="white-space:pre">			</span>query="DELETE FROM pcSavedPrdStats;"</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>set rsQ=connTemp.execute(query)</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>set rsQ=nothing</div><div><span ="Apple-tab-span" style="white-space:pre">		</span>end if</div></div><div></pre></td></tr></table></div><div>Right before the "end if", add the following:</div><div><table width="99%"><tr><td><pre class="BBcode"></div><div><div><span ="Apple-tab-span" style="white-space:pre">			</span>'&lt;Customization: Purge old saved carts&gt;</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>ndays=30</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>ndays=-1*Clng(ndays)</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>if scDB="SQL" then</div><div><span ="Apple-tab-span" style="white-space:pre">				</span>strDtDelim="'"</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>else</div><div><span ="Apple-tab-span" style="white-space:pre">				</span>strDtDelim="#"</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>end if</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>query="DELETE FROM pcSavedCartArray WHERE pcSavedCartArray.SavedCartID IN (SELECT SavedCartID FROM pcSavedCarts WHERE SavedCartDate&lt;" &amp;strDtDelim&amp;dateadd("d",ndays,Now())&amp;strDtDelim&amp; ");"</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>set rstemp=connTemp.execute(query)</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>set rstemp=nothing</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>query="DELETE FROM pcSavedCarts WHERE SavedCartDate&lt;" &amp;strDtDelim&amp;dateadd("d",ndays,Now())&amp;strDtDelim&amp; ";"<span ="Apple-tab-span" style="white-space:pre">	</span></div><div><span ="Apple-tab-span" style="white-space:pre">			</span>set rstemp=conntemp.execute(query)</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>set rstemp=nothing</div><div><span ="Apple-tab-span" style="white-space:pre">			</span>'&lt;/Customization&gt;</div></div><div></pre></td></tr></table></div><div>Change "ndays=30" to however many days back you want to retain saved carts.</div><div><br></div><div>You also might want to take advantage of this add-on to automatically follow up on all of these abandoned carts you've got:&nbsp;<a href="http://wiki.earlyimpact.com/widgets/thirdparty/aband&#111;ned_cart" target="_blank" rel="nofollow">http://wiki.earlyimpact.com/widgets/thirdparty/abandoned_cart</a></div>]]>
   </description>
   <pubDate>Sat, 21 Apr 2012 20:52:23 +0000</pubDate>
   <guid isPermaLink="true">https://forum.productcart.com/saved-shopping-carts-message_topic5107_post19530.html#19530</guid>
  </item> 
  <item>
   <title><![CDATA[saved shopping carts message : Hi,I get the message in my CP...]]></title>
   <link>https://forum.productcart.com/saved-shopping-carts-message_topic5107_post19529.html#19529</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forum.productcart.com/member_profile.asp?PF=2293">prillo</a><br /><strong>Subject:</strong> 5107<br /><strong>Posted:</strong> 20-April-2012 at 8:40pm<br /><br />Hi,<br><br>I get the message in my CP once every few days that the saved shopping carts exceeds 10,000, and I have the option of removing the oldest carts.<br><br>If I didn't do this bit of housekeeping, what would happen?&nbsp; Slower response time?&nbsp; Just curious as I have had to ignore it now and then when it pops up (busy with other things).<br><br>Also is there any way to preset this so that it automatically drops the 10,001th oldest cart and up?<br>]]>
   </description>
   <pubDate>Fri, 20 Apr 2012 20:40:15 +0000</pubDate>
   <guid isPermaLink="true">https://forum.productcart.com/saved-shopping-carts-message_topic5107_post19529.html#19529</guid>
  </item> 
 </channel>
</rss>