Tom Muck's blog at A blog for web developers about all things ecommerce. http://blog.cartweaver.com/?blogger=1 A blog for web developers about all things ecommerce.: Tom Muck's blog lawrence@cartweaver.com en-us Removing items from cart that are sold (ColdFusion) One of the frequent questions I get doing support for Cartweaver is "How do I make sure that all the items in a customer's cart are still available?" What happens is that a customer will place an item in the cart, and then leave the site. Another customer comes along and buys the product. The first customer comes back and tries to purchase the item, but cannot. Unfortunately, the customer doesn't find out until the order information is entered.

The following modification for the ColdFusion version will remove items from the cart that are no longer available, and show the customer a message that an item has been removed from the cart because it is no longer available.

Now, in CWIncFunctions.cfm, add the following section of code at line 399, right after this line:


Add the following code:


  
  SELECT c.cart_sku_ID, c.cart_sku_qty, s.SKU_Stock, c.cart_Line_ID
  FROM tbl_cart c
  INNER JOIN tbl_skus s
  ON c.cart_sku_ID = s.SKU_ID
  WHERE c.cart_custcart_ID =
  AND s.SKU_Stock < c.cart_sku_qty
  
  
  
  
    
      
      DELETE FROM tbl_cart
      WHERE cart_Line_ID =
      
    
      
      UPDATE tbl_cart SET cart_sku_qty =
      WHERE cart_Line_ID =
      
    
  
  

Now, when a user comes back to view his cart, any items that are no longer available are removed from the cart and a message is displayed to the customer, and items that have smaller quantities available than were available at the time of the cart creation have their values adjusted. This only affects carts where Allow Backorders is unchecked in the Cartweaver admin.

Update: 10/4/2009 Thanks to Alex in the CW support newsgroup for pointing out that the method does not consider quantities in the cart greater than available quantities. It was written for one situation, but I have now adjusted the code to work with all situations where a quantity is no longer available for a given item

]]> http://blog.cartweaver.com/index.cfm?newsid=78 http://blog.cartweaver.com/index.cfm?newsid=78 Sat, 03 Oct 2009 15:22:04 GMT Removing items from cart that are sold (PHP) One of the frequent questions I get doing support for Cartweaver is "How do I make sure that all the items in a customer's cart are still available?" What happens is that a customer will place an item in the cart, and then leave the site. Another customer comes along and buys the product. The first customer comes back and tries to purchase the item, but cannot. Unfortunately, the customer doesn't find out until the order information is entered.

The following modification for the PHP version will remove items from the cart that are no longer available, and show the customer a message that an item has been removed from the cart because it is no longer available.

In CWIncFunctions.php, add the following section of code at line 470, right after this line:

$Cart["Products"] = array();

Add the following code:

if(!$cartweaver->settings->allowBackOrders) {
  $query_rsCWCheckStock = sprintf("SELECT
  s.SKU_Stock,
  c.cart_Line_ID
  FROM tbl_cart c
  INNER JOIN tbl_skus s
  ON c.cart_sku_ID = s.SKU_ID
  WHERE c.cart_custcart_ID = '%s'
  AND s.SKU_Stock < c.cart_sku_qty",$cartID);
  $rsCWCheckStock = $cartweaver->db->executeQuery($query_rsCWCheckStock, "rsCWCheckStock");
  $rsCWCheckStock_recordCount = $cartweaver->db->recordCount;
  $row_rsCWCheckStock = $cartweaver->db->db_fetch_assoc($rsCWCheckStock);
  if($rsCWCheckStock_recordCount > 0) {
    $cartweaver->setCWError("Item Sold", "An item or items in your cart are no longer available or had quantities adjusted");
    do {
      if($row_rsCWCheckStock["SKU_Stock"] <= "0") {
        $query_rsCW = sprintf("DELETE FROM tbl_cart
        WHERE cart_Line_ID = %d",$row_rsCWCheckStock["cart_Line_ID"]);
        $rsCW = $cartweaver->db->executeQuery($query_rsCW, "rsCW");
      } else {
        $query_rsCW = sprintf("UPDATE tbl_cart SET cart_sku_qty = %d
        WHERE cart_Line_ID = %d",$row_rsCWCheckStock["SKU_Stock"], $row_rsCWCheckStock["cart_Line_ID"]);
        $rsCW = $cartweaver->db->executeQuery($query_rsCW, "rsCW");
      }
    } while ($row_rsCWCheckStock = $cartweaver->db->db_fetch_assoc($rsCWCheckStock));
  }
}

Now, when a user comes back to view his cart, any items that are no longer available are removed from the cart and a message is displayed to the customer. This only affects carts where Allow Backorders is unchecked in the Cartweaver admin.

Update: 10/4/2009 Thanks to Alex in the CW support newsgroup for pointing out that the method does not consider quantities in the cart greater than available quantities. It was written for one situation for a customer, but I have now adjusted the code to work with all situations where a quantity is no longer available for a given item.]]> http://blog.cartweaver.com/index.cfm?newsid=77 http://blog.cartweaver.com/index.cfm?newsid=77 Sat, 03 Oct 2009 14:13:18 GMT PHP 5.3 deprecated functions -- Cartweaver PHP 3.1.16 released PHP 5.3.0 has been released, and contains many changes from previous PHP releases. Because of this, we have updated the Cartweaver code to work with this release, and will also allow the code to work on PHP 6.0 as well.

The full list of release notes can be found at http://us2.php.net/migration53.

The main reason for the updated code is the fact that the following functions are now all deprecated in PHP and will throw E_DEPRECATED error messages when used (E_DEPRECATED is a new error message level). The functions are removed in PHP 6:

Deprecated functions:

call_user_method() (use call_user_func() instead)
call_user_method_array() (use call_user_func_array() instead)
define_syslog_variables()
dl()
ereg() (use preg_match() instead)
ereg_replace() (use preg_replace() instead)
eregi() (use preg_match() with the 'i' modifier instead)
eregi_replace() (use preg_replace() with the 'i' modifier instead)
set_magic_quotes_runtime() and its alias, magic_quotes_runtime()
session_register() (use the $_SESSION superglobal instead)
session_unregister() (use the $_SESSION superglobal instead)
session_is_registered() (use the $_SESSION superglobal instead)
set_socket_blocking() (use stream_set_blocking() instead)
split() (use preg_split() instead)
spliti() (use preg_split() with the 'i' modifier instead)
sql_regcase()
mysql_db_query() (use mysql_select_db() and mysql_query() instead)
mysql_escape_string() (use mysql_real_escape_string() instead)
Passing locale category names as strings is now deprecated. Use the LC_* family of constants instead.
The is_dst parameter to mktime(). Use the new timezone handling functions instead.

The functions previously used by Cartweaver are ereg(), ereg_replace(), session_unregister(), and split().

There is also a new PHP site devoted to Windows installations at http://windows.php.net/

If anyone has a Cartweaver version pre-3.1.16, you will want to download the latest version and apply the fixes/changes. To download Cartweaver, go to http://www.cartweaver.com/customers and login as a customer. You should see your downloads. If you have not updated a Cartweaver installation, the easiest way is to simply replace the files in the /cw3 folder. If you have made changes to any of the files in your site, the UpdateNotesCW3PHP.htm file details each change to each file showing line numbers and code before/after. I've found Beyond Compare (http://www.scootersoftware.com/) to be a valuable tool for making line-by-line file changes, or comparing directories.

Update: 2009-09-08 6:47pm One thing I noticed on the PHP site is that the Windows ISAPI version of PHP is not supported any more. Hopefully the bugs have been addressed in the CGI versions, as previous versions of PHP were crash-prone when using the old CGI version. Supposedly the new FastCGI version is better.

]]> http://blog.cartweaver.com/index.cfm?newsid=75 http://blog.cartweaver.com/index.cfm?newsid=75 Wed, 09 Sep 2009 03:47:28 GMT Customer Contact plugin hints Customer Contact eNewsletter plugin allows you to send emails to customers and other contacts in your Cartweaver database. Sending email through a browser is a little different than using a service, if you have not done it before -- the execution time will vary depending on the speed of your server and number of emails you are creating. A list of 1000 emails might take 1-3 minutes to complete, and bigger lists can take proportionally longer. I used to send to lists of 50,000-100,000 for a large company, and the browser would be open for up to an hour. Sending personalized email can be a slow process.

As with anything, it's probably a good idea to test with smaller lists first, or lists consisting of your own email address, however there are a few things you can do if you are timing out or having other difficulties with larger lists:

For PHP:

1. make sure you have a valid file and/or email address in the CWError.php file. This can help track down problems
 
2. make sure that your php.ini setting for max_execution_time is set high enough for the large list. By default the maximum is 30 seconds, which can get you through a small list, but to send 1000 messages your maximum might need to be 100-200 seconds or more. Your page will take the full time to complete.
 
3. Make sure web server timeouts are large enough. Consult your web server documentation about page request timeouts.
 
For ColdFusion:

1. Make sure the ColdFusion setting for page execution is large enough, if it is enabled, or put a <cfsetting> tag in your cwcc_SendEmails.cfm file. This article talks about ColdFusion timeouts:
http://kb2.adobe.com/cps/194/tn_19438.html

2. Make sure web server timeouts are large enough. Consult your web server documentation about page request timeouts.

]]> http://blog.cartweaver.com/index.cfm?newsid=70 http://blog.cartweaver.com/index.cfm?newsid=70 Fri, 26 Jun 2009 00:10:46 GMT New CW article at Community MX I started a series at Community MX about modifying and enhancing the Cartweaver admin using the configuration options and custom coding. The first article is about adding a low-stock warning to your admin home page.

Some other past Community MX articles about Cartweaver are:

Integrating Cartweaver with a Page Design

Showing Results and Details on One Page Using AJAX

Using JumpStarts with Cartweaver, Featuring Minneapolis

]]> http://blog.cartweaver.com/index.cfm?newsid=65 http://blog.cartweaver.com/index.cfm?newsid=65 Fri, 05 Jun 2009 01:21:33 GMT Make Add to Cart buttons (php) I get a lot of questions about making an Add to Cart button for Cartweaver. This is not something that is available out of the box, but easily implemented. Cartweaver doesn't work like Paypal, where you need static add to cart buttons to make the cart work. CW is self-contained and database driven, where all products are stored in the database. However, an add to cart button is easily added. I have been using them for years on my own site www.tom-muck.com/extensions. The following can be added to the ProductForm.php file in the Cartweaver admin, right before the closing </div> tag on the Page 1 div. Find this code:

 </div>
 <div id="page2">

add this:

<p><a href="AddToCartButtons.php?prodId=<?php echo($row_rsCWGetProduct["product_ID"]);?>" target="_blank">Make Add To Cart Buttons</a></p>
 </div>
 <div id="page2">

Now, create a new page in the /cw3/admin folder called AddToCartButtons.php and put this code on it:

<?php
include("application.php");
$productId = isset($_GET["prodId"]) ? intval($_GET["prodId"]): 0;

/* Get Product Data */
$query_rsCWGetProduct = sprintf("SELECT DISTINCT product_ID,
product_Name,
product_Description,
s.SKU_ID,
s.SKU_MerchSKUID
FROM tbl_products p
INNER JOIN tbl_skus s
ON p.product_ID = s.SKU_ProductID
WHERE product_ID = %d
AND product_Archive = 0
AND product_OnWeb = 1
", $productId);
$rsCWGetProduct = $cartweaver->db->executeQuery($query_rsCWGetProduct, "rsCWGetProduct");
$rsCWGetProduct_recordCount = $cartweaver->db->recordCount;
$row_rsCWGetProduct = $cartweaver->db->db_fetch_assoc($rsCWGetProduct);

do {
?>
<h2><?php echo($row_rsCWGetProduct["product_Name"] .": skuid " . $row_rsCWGetProduct["SKU_MerchSKUID"]);?></h2>
<textarea cols="80" rows="10">

<form action="details.php?prodId=<?php echo($row_rsCWGetProduct["product_ID"]);?>" method="post" name="AddToCart">
 <input name="qty" type="hidden" value="1">
  <input name="skuid" type="hidden" value="<?php echo($row_rsCWGetProduct["SKU_ID"]);?>">
  <input name="prodId" type="hidden" value="<?php echo($row_rsCWGetProduct["product_ID"]);?>">
  <input name="submit" type="submit" class="formButton" value="Add to Cart">
</form></textarea>
<br/><br/><hr/>
<?php
} while ($row_rsCWGetProduct = $cartweaver->db->db_fetch_assoc($rsCWGetProduct));

That should do it. Now, when you click the link, the page populates with add to cart button code for each sku for that product.

The add to cart button code looks like this:

<form action="details.php?prodId=31" method="post" name="AddToCart">
 <input name="qty" type="hidden" value="1">
  <input name="skuid" type="hidden" value="59">
  <input name="prodId" type="hidden" value="31">
  <input name="submit" type="submit" class="formButton" value="Add to Cart">
</form>

]]> http://blog.cartweaver.com/index.cfm?newsid=64 http://blog.cartweaver.com/index.cfm?newsid=64 Sat, 30 May 2009 01:49:09 GMT Integrating a page design I posted a new free article at Community MX, intended mostly for beginners with Cartweaver on integrating a page design with Cartweaver: http://www.communitymx.com/content/article.cfm?cid=52740.

The article shows how to use the standard Dreamweaver page layouts with Cartweaver, but is intended to show how any page design can be made to work with Cartweaver, and explains the include file concept that we use.

]]> http://blog.cartweaver.com/index.cfm?newsid=54 http://blog.cartweaver.com/index.cfm?newsid=54 Sat, 13 Sep 2008 13:51:16 GMT New round of SQL injection attempts Be on the watch for new SQL injection attempts, coming from China, using an ascii-encoded binary string. Essentially, what it does is find a vulnerable database and append a string to the fields in every table. The string is a closing </title> tag with a script, followed by a comment to hide the rest of the page:

http://www.bloombit.com/Articles/2008/05/ASCII-Encoded-Binary-String-Automated-SQL-Injection.aspx

I put something like this in my application.cfm file to re-rout the attackers temporarily:

<cfif FindNoCase('user>0',cgi.query_string) OR findNoCase('declare',cgi.query_string)
OR findNoCase('EXEC(@',cgi.query_string)>
    <cflocation url="http://www.ftc.gov">
</cfif>

]]> http://blog.cartweaver.com/index.cfm?newsid=52 http://blog.cartweaver.com/index.cfm?newsid=52 Fri, 08 Aug 2008 17:08:42 GMT Using GoDaddy with Cartweaver -- Transactions GoDaddy provides an excellent service for domain registration and domain management, but when it comes to web hosting, there are a few gotchas to be aware of. One of them is the proxy server that is used for SSL. When you are setting up your e-store and using a payment gateway like Authorize.Net, you have to communicate via SSL behind the scenes. In ColdFusion, this is done with the <cfhttp> tag. In PHP, it is done with cURL or OpenSSL.

To convert the payment gateway file in Cartweaver to use the proxy server, you have to edit the file located in /cw3/CWLibrary/ProcessPayment/ for PHP or /cw3/CWTags/ProcessPayment/ for ColdFusion. A typical file would be CWIncAuthorizeNet.cfm or CWIncAuthorizeNet.php. For ColdFusion, the code looks like this:

<cfhttp url="https://secure.authorize.net/gateway/transact.dll"
method="post" >

You would change it to this to use the proxy server:

<cfhttp url="https://secure.authorize.net/gateway/transact.dll"
method="post"
proxyserver="proxy.shr.secureserver.net"
proxyport="3128" >

For PHP, the cURL code looks like this:

$url = "https://secure.authorize.net";
$path = "/gateway/transact.dll";

// post back to Authorize.net system
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$url . $path);
curl_setopt($ch, CURLOPT_VERBOSE, 1);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_POSTFIELDS, $str);
$authNetResult = curl_exec($ch);
curl_close ($ch);

You have to add a few lines for the proxy:

$url = "https://secure.authorize.net";
$path = "/gateway/transact.dll";

// post back to Authorize.net system
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$url . $path);
curl_setopt ($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE);
curl_setopt ($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);
curl_setopt ($ch, CURLOPT_PROXY,"http://proxy.shr.secureserver.net:3128");
curl_setopt($ch, CURLOPT_VERBOSE, 1);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_POSTFIELDS, $str);
$authNetResult = curl_exec($ch);
curl_close ($ch);

If you still can't get it to work, call GoDaddy support. They can usually help. GoDaddy does not outsource their support overseas, unlike other companies, and is usually pretty good and easy to get on the phone.

]]> http://blog.cartweaver.com/index.cfm?newsid=50 http://blog.cartweaver.com/index.cfm?newsid=50 Sat, 19 Jul 2008 14:30:38 GMT Adding a second payment type in ColdFusion This modification can be used for "Pay by Credit Card or Check" or for "Pay now or request a Quote". This is simply a matter of changing the credit card processor from your payment processor that is set up in the Application.cfm file to "none" on the fly, based on user input. The code for this modification in PHP is shown at http://www.tom-muck.com/cw/

You should be able to set up a form field on the order form to allow for checks to be sent on CWIncOrderForm.cfm:

<p>Pay by:<br />
Send check:
<input type="radio" name="paymenttype" value="0" checked="checked" />
Credit Card:
<input type="radio" name="paymenttype" value="1" />
</p>

then add a bit of code to the CWIncOrderForm.cfm file around line 43, right after <cfif IsDefined ('FORM.OrderFormNext')> :

<cfif isDefined("Form.paymenttype")>
<cfset session.paymenttype = form.paymenttype />
</cfif>

then a bit of code to the CWIncShowCart.cfm file:

<cfif IsDefined("Session.paymenttype")>
 <cfswitch expression="#Session.paymenttype#">
   <cfcase value="0">
    <cfset request.paymentAuthType = "none">
    <cfset request.paymentAuthName = "none">
   </cfcase>
   <cfcase value="1">
    <cfset request.paymentAuthType = "gateway">
    <cfset request.paymentAuthName = "CWIncAuthorizeNet.cfm">
   </cfcase>
 </cfswitch>
</cfif>

Also, if you want to change the confirmation emails based on the payment type, add this code to the top of CWIncConfirmation.cfm as well:

<cfif IsDefined("Session.paymenttype")>
 <cfswitch expression="#Session.paymenttype#">
   <cfcase value="0">
    <cfset request.paymentAuthType = "none">
    <cfset request.paymentAuthName = "none">
   </cfcase>
   <cfcase value="1">
    <cfset request.paymentAuthType = "gateway">
    <cfset request.paymentAuthName = "CWIncAuthorizeNet.cfm">
   </cfcase>
 </cfswitch>
</cfif>

Then you can make your changes in the email within the CFMAIL tag however you like, such as:

Your order has been received.
As soon as your payment is received you will receive a confirmation notice and your order will be shipped! Your order details are as follows.

#EmailContents#

You might also add a bit of code after the <h2>Order Details</h2> line:

<h2>Order Details</h2>
<cfif request.paymentAuthType EQ "none">
<p>Your order has been recieved. The order will be shipped when your check or money order is received.</p>
</cfif>

This could also be used to switch between a gateway and Paypal, or even 3 options -- credit card, check, or Paypal.

Update: If the customer is logged in already, the default payment option only is shown, but you can set up a link to change the payment type like this:

<a href="<cfoutput>#request.targetCheckOut#</cfoutput>"><strong>Change your payment type</strong></a>

]]> http://blog.cartweaver.com/index.cfm?newsid=46 http://blog.cartweaver.com/index.cfm?newsid=46 Sun, 11 May 2008 15:37:41 GMT Protect that download directory When running a digital downloads store, you want to make sure your web visitors do not have access to the folder where your downloads are contained. This also applies to anyone using the Cartweaver Downloadable Products plug-in. Depending on your server, you have different options. If the web server is IIS, you can go into the admin and turn off anonymous access. If it is an Apache server, add an .htaccess file to the downloads folder like this:

Deny from all

or

Redirect /yourstorefolder/ http://yourdomain.com/yourstorefolder/error.php?error=No%20access%20allowed%20

That should take care of any attempts to download from the folder.

Note that not all web hosts allow the use of .htaccess. If not, you may have to contact the web host to ask them to turn off web access to this folder. You may also have access to an administrative panel for your web hosting account that has this functionality available.

]]> http://blog.cartweaver.com/index.cfm?newsid=42 http://blog.cartweaver.com/index.cfm?newsid=42 Sun, 30 Mar 2008 05:00:00 GMT New price format string functionality in Cartweaver The lastest versions of Cartweaver PHP and ColdFusion contain a new price format string. This was a much requested feature, as many CW users wanted to format prices in a different way than it was set up by default. Some users might need to display prices with tax, prices without tax, both prices, tax amounts, etc. VAT formatting in particular needed a different format. We came up with a price format string in the getPriceList() function:

The function takes these arguments.
productID: The product ID to display.
allowBackOrders: Do we allow back orders?
taxRate: Rate of tax for the item
currentRecord: row number for CSS ids
showMax: flag to show max price along with min price
priceFormat: string with replaceable masks for price parts

Price format string new in 3.0.7 (PHP) and 3.0.9 (ColdFusion) to format price on results and details page for taxable items $priceFormat in this format:
@@beforeDiscountPrice@@
@@currentPrice@@
@@tax@@
@@priceWithTax@@
@@taxAmount@@

Use in combination with showMax. By default, minimum and maximum price of product are shown ($1.00 - $5.00). Set to false to show only the minimum price. Then, priceFormat can be used to format the price like this:

for example, assuming a 50% discount, 5% tax rate, showing prices before tax and after tax:
@@beforeDiscountPrice@@ @@currentPrice@@ (@@priceWithTax@@ including @@tax@@% tax)
shows 2.00 - 10.00 (2.10 - 10.50 including 5% tax) 1.00 - 5.00 (1.05 - 5.25 including 5% tax)

Another example shows displaying minimum price only with 50% discount, 25% VAT, and showing price with VAT included and excluded:
@@beforeDiscountPrice@@ @@priceWithTax@@ (@@currentPrice@@ + @@taxAmount@@ VAT)
shows 2.50 (2.00 excluding.50 VAT) 1.25 (1.00 excluding .25 VAT)

A simple example with no discount and no tax, showing only minimum price:
Prices starting at @@currentPrice@@
shows: Prices starting at $1.00

The format string is called from the CWIncDetails and CWIncResults pages, but you can also set up a simple session variable or configuration item to handle this:

$_SESSION["PriceFormatString"] = "@@beforeDiscountPrice@@ @@priceWithTax@@ (@@currentPrice@@ + @@taxAmount@@ VAT)";

Or for CF:

<cfset Session.PriceFormatString = "@@beforeDiscountPrice@@ @@priceWithTax@@ (@@currentPrice@@ + @@taxAmount@@ VAT)">

UPDATE:

The getPriceList() function is called like this:

echo(getPriceList($productID,
$allowBackOrders,
$taxRate,
$currentRecord,
$showMax,
$priceFormat));

Essentially, you find the place on CWIncResults or CWIncDetails where the function is being called from, and adjust it to your liking:

echo(getPriceList($row_rsCWGetProduct["product_ID"],
$cartweaver->settings->allowBackOrders,
$taxRate,
',
true,
$priceFormatString));

]]> http://blog.cartweaver.com/index.cfm?newsid=41 http://blog.cartweaver.com/index.cfm?newsid=41 Mon, 03 Mar 2008 23:19:11 GMT Open House at Community MX Community MX is having an open house where visitors are able to view over 2400 articles and tutorials. Community MX is a subscription service, so this is a good opportunity to see what is available. The open house is from 12/24/2007 through 1/1/2008.

Some articles relevant to Cartweaver users are Using JumpStarts with Cartweaver, Featuring Minneapolis, Using a ColdFusion Custom Tag as a Site Template, Resending Undeliverable Mail in ColdFusion, Writing Readable SQL, PHP Site Simplification with Application.php. For a full list of what I've written for Community MX, see this page: http://www.communitymx.com/author.cfm?cid=1003

]]> http://blog.cartweaver.com/index.cfm?newsid=37 http://blog.cartweaver.com/index.cfm?newsid=37 Mon, 24 Dec 2007 14:19:49 GMT Adding Payment Gateways and Processors There are literally hundreds of payment processors out there. We support a few out of the box, and have several others available as free downloads to customers, but it is not too difficult to add a new payment processor using an existing gateway/processor as a guide.

Basically there are two types of payment processors: gateway or processor. A gateway communicates behind the scenes (like Authorize.net) and processes the transaction in realtime, and a processor shows a form on a third-party web site, and credit card data is collected there (like Paypal.)

The basic procedure to create a new payment processor file in Cartweaver is to get the API from your payment processor, and use one of our payment processor files as a guide. Modify the form values in the file to use the names specified by your processor (for example, it might use "x-lastname" or "UserLastName" or "LastName"). Once you do this, you should be able to turn on the debugging email functionality, post test transactions to your payment processor, and proceed from there.

The next step is to parse the result, and all payment processors handle this differently. For example, Authorize.Net passes results in comma-delimited form, so this sample line would parse the result, for PHP:

$authNetCodes = explode(",",$authNetResult);

For ColdFusion, use the simple list functions:

<cfset request.TransactionResult = Val(ListFirst(cfhttp.fileContent))>

Some processors use name/value pairs in a querystring. The following will parse those types of results in PHP:

$resultArray = explode('&', $result);
foreach($resultArray as $val) {
  $temp = explode('=', $val);
  $response[$temp[0]] = $temp[1];
}

or for ColdFusion:

<cfset resultArray = ListToArray(result, "&")>
<cfset response = StructNew()>
<cfloop from="1" to="#ArrayLen(resultArray)#" index="i">
  <cfset response[ListFirst(resultArray[i], "=")] = ListLast(resultArray[i], "=")>
</cfloop>

After this parsing, you can read the response array/struct values using the variable names described in the gateway API document, such as $response["success"]. The main point is that we have quite a few payment processors available, and although each one is different, you can probably locate code in these files that will assist you in creating a new payment processor file. For a list of which processors we support, check http://www.cartweaver.com/features/payments/

If you find out about the API and want me to take a look at it, let me know through my contact form. In the past I have converted payment processor files for customers for a fee, but it does not usually fit into my schedule.

]]> http://blog.cartweaver.com/index.cfm?newsid=34 http://blog.cartweaver.com/index.cfm?newsid=34 Fri, 09 Nov 2007 14:15:37 GMT Locale settings in Cartweaver PHP One of the frequent questions we get is about locales in Cartweaver PHP. Because of the varying nature of locale settings in Windows, Linux, Mac, and other systems running PHP, it is hard to come up with a reliable way to get the locale setting of the server. The locale setting is in application.php, and is how we determine how to format money and date/time displays. For Windows systems, the Dreamweaver setup server behavior takes care of this. A full list of Windows locales is at http://tom-muck.com/cw/windowslocales.cfm. Linux locales are not quite as easy. For that reason, we include a file at http://[yourserver]/cw3/setup/locales/CWGetLocales.php that lists your locales on your server. This is a Linux-only function, and does not work on all Linux server due to security restrictions. I have posted a list of locales on my Linux server at http://www.tom-muck.com/cw/linuxlocales.cfm.

If you are unable to obtain the locale setting on your server, and the listed locales do not work, you can modify the function in CWIncFunctions.php to hard-code the currency symbol like this:

// for CW3
function cartweaverMoney($theNum, $showCurrencySymbol = true, $stripComma = false) {
  $currencySymbol = '$';
  $theNum = number_format($theNum, 2, ".",",");
  if($showCurrencySymbol) $theNum = $currencySymbol . $theNum;
  if($stripComma) $theNum = str_replace(",","",$theNum);
return $theNum;
}

Some typical locales for US format are:

  • en_US
  • en_US.iso88591
  • en_US.iso885915
  • english-us
  • eng
]]> http://blog.cartweaver.com/index.cfm?newsid=32 http://blog.cartweaver.com/index.cfm?newsid=32 Mon, 05 Nov 2007 02:54:34 GMT Using Application.cfc with Cartweaver ColdFusion Cartweaver was designed for use with the Application.cfm file, but versions 7 and 8 of ColdFusion allow the use of an Application.cfc file, giving greater control over application events. Cartweaver can be used with Application.cfc with a few tweaks.

1. First, set up your Application.cfc with some settings (these would be from your cfapplication tag):

<cfcomponent>
<!--- Initialize the application --->
<cfscript>
this.name = "testCW"; // make sure every application has a unique name
this.applicationTimeout = createTimeSpan(7,0,0,0);
this.clientmanagement= "yes";
this.sessionmanagement = "yes";
this.sessiontimeout = createTimeSpan(0,0,30,0);
this.setClientCookies = "yes";
this.clientstorage="clientvariables"; // datasource for client variables
</cfscript>

2. Then, copy the <cfmodule> tag from your existing Application.cfm to your onRequestStart method.

<!--- On request start --->
<cffunction name="onRequestStart">
  <cfargument name="requestname" required=true/>
  <cfmodule
    id = "CW3GlobalSettings"
    template = "cw3/CWTags/CWTagGlobalSettings.cfm"
    datasource = "yourdatasource"
    etc..... >
</cffunction>

3. In the onError method, you'll have to create your own error handling to take the place of the error pages.

4. Rename OnRequestEnd.cfm at the store root to debugger.cfm and include this method in Application.cfc (if you want the debugging functionality of CW):

<cffunction name="onRequestEnd" output="true">
  <cfargument type="String" name="targetPage" required=true/>
  <cfinclude template="debugger.cfm">
</cffunction>

5. Include other methods, if needed (onSessionStart, onSessionEnd, etc).

6. Close the component tag:

</cfcomponent>

7. We include two files of frequently used functions in application.cfm because they are used thoughout the application, but that won't work in Application.cfc. Add these two include files to the rest of your presentation pages (results, details, confirmation, orderform, and showcart):

<cfinclude template="cw3/CWTags/CWIncFunctions.cfm">
<cfinclude template="cw3/CWTags/CWIncDiscountFunctions.cfm">

8. Then create an ApplicationProxy.cfc file at the store root with this in it:

<cfcomponent name="ApplicationProxy" extends="Application"></cfcomponent>

9. That is for the admin functionality, which will have it's own Application.cfc extending the site root Application.cfc. Put a new Application.cfc file at the root of /cw3/admin, including only the onRequestStart function:

<cfcomponent name="Application" extends="ApplicationProxy">
  <cffunction name="onRequestStart">
    <cfargument name="requestname" required=true/>
    <cfset super.onRequestStart(requestname)>
    <!--- Here, insert everything from the Application.cfm from the admin folder
         EXCEPT for the application.cfm include and the error handling ---->
  </cffunction>
</cfcomponent>

That should be all that is required. There can be further optimizations, however this should give you a working site.

]]> http://blog.cartweaver.com/index.cfm?newsid=26 http://blog.cartweaver.com/index.cfm?newsid=26 Wed, 17 Oct 2007 00:22:18 GMT Adding CSV File Downloads to the Cartweaver Admin (PHP) I dug up an old PHP class that I wrote a few years back and thought I would post it for anyone who needs CSV functionality on their site. It will work with any PHP recordset, including Cartweaver recordsets, which use my custom DB abstraction class (only for MySQL, though). The class is simple, and can be downloaded here.

The class is typically used on a page by itself, or on any page within conditional statements. You link to the page and the file download begins. The class constructor has 3 arguments:

$csvfile = new CSVFile(recordsetName, [quotes true or false], [filename]);

The first is the MySQL recordset. The second optional argument is true or false to put quotes around the fields. The third optional argument is the filename, which defaults to Download.csv by default.

To use it, follow these instructions:

1. If this is a Cartweaver recordset, make sure you include the application.php file at the top of the page:

require_once("application.php");

2. Include the class file:

require_once("yourclassdirectory/CSVFile.php");

3. Create your recordset. Below is a typical Dreamweaver recordset, using the Northwind database that you can download here for MySQL if you don't have it:

mysql_select_db($database_connNorthwind, $connNorthwind);
$query_rs = "SELECT p.ProductID, p.ProductName, p.UnitPrice FROM products p ORDER BY p.ProductID";
$rs = mysql_query($query_limit_rs, $connNorthwind) or die(mysql_error());

For Cartweaver, a typical recordset might look like this:

$query_rs = "SELECT * FROM tbl_orders ORDER BY order_Date";
$rs = $cartweaver->db->executeQuery($query_rs, "rs");

4. Add a line to invoke the CSVFile class:

$csvfile = new CSVFile($rs, true);

5. Link to the file.

Now, when the page is browsed, the file download will begin immediately.

Cross-posted from tom-muck.com. See this blog post for info on creating a button in the CW admin for order downloads.

]]> http://blog.cartweaver.com/index.cfm?newsid=24 http://blog.cartweaver.com/index.cfm?newsid=24 Sat, 13 Oct 2007 15:14:18 GMT Adding CSV File Downloads to the Cartweaver Admin (ColdFusion) One of the frequent requests in the forums is to provide a downloadable list of orders, customers, products, or other items from the Cartweaver admin. The following applies to ColdFusion, but is an easy way to create downloadable files for Quickbooks, Excel, or other applications where you might need a CSV file.

The functionality revolves around a custom tag I wrote a while back called CF_CSVFILE. You can find it available free on my blog:

http://www.tom-muck.com/blog/index.cfm?newsid=46

I'll go through a simple example using the Cartweaver orders page. The basic technique to using this tag within CW (or any other application) is to create a <cfquery> tag using the data you want to download, put the csvfile tag on the page, and then simply link to the page. We can do this with dynamic queries as well -- the orders page uses form fields to create the display list. We can simply divert this form to a new OrdersDownload.cfm page by following these steps:

1. Create a file called OrdersDownload.cfm. It should be totally blank -- no tags or any other characters in the file.

2. Save the csvfile.cfm tag from my blog to a directory within /cw3/admin called "tags".

3. Add this code to the top of the OrdersDownload.cfm file:

<cfimport prefix="mytag" taglib="tags">

4. Copy the rsByDate query from the Orders.cfm page to the OrdersDownload.cfm page.

5. Add the reference to the csvfile custom tag to the OrdersDownload page beneath the query:

<mytag:csvfile rs=#rsByDate#>

6. Add a new button to the Orders.cfm page next to the submit button that is already there to create a link to the new form post:

<input name="Submit2" type="submit" class="formButton" value="Download Orders"   onclick="document.DateForm.action='OrdersDownload.cfm'">

That's all there is to it. It looks more complicated than it is, and can be used with any query. For example, to create a downloadable list of all customers, create the CustomersDownload page with this code:

<cfimport prefix="mytag" taglib="tags">
<!--- retrieve all customers --->
<cfquery name="rsCustomers" datasource="#request.dsn#">
SELECT * FROM tbl_customers
</cfquery>
<mytag:csvfile rs=#rsCustomers#>

Then simply link to it. Since you are getting all customers, you don't need the submit button or extra javascript -- a simple link will do.

]]> http://blog.cartweaver.com/index.cfm?newsid=23 http://blog.cartweaver.com/index.cfm?newsid=23 Sat, 13 Oct 2007 02:15:59 GMT Changing Cartweaver Shipping Options One of the frequent questions we see in the forums is "How do I implement XXXX shipping?" Cartweaver has flexible shipping, but we also left it open for others to implement their own shipping. The key to CW shipping is in the file CWFunShipping (or CWTagShipping in ColdFusion). The getShippingRates() function (cwShipping() in the ASP version) returns the shipping cost, given weight or cart cost. There are several things that can be done in this function if you need more complex shipping than CW offers (such as real-time UPS or FedEx shipping), or simpler shipping (such as "$4 shipping for all orders"), or conditional shipping (such as "free shipping over $100").

If you keep in mind that the shipping function returns the shipping cost, you can use logic to determine the cost. The function is dual purpose, however. If the mode "ShipList" is passed to the function, it returns a list of shipping functions. If the mode "Calculate" is passed, the return value will be the shipping cost. So you must check first for the mode and then return the shipping cost if the mode is "Calculate".

For UPS/FedEx, you would need a script to contact UPS/FedEx, and an account with them. Modify the getShippingRates() function to use the script:

// If not listing ship methods, call your UPS function
if($mode == "Calculate") return getMyUPSFunction();

For simpler shipping, first make sure you have set up a shipping method in the CW admin, then simply re-write the function to use your simpler shipping, such as:

// If not listing ship methods, return $4 for shipping cost
if($mode == "Calculate") return 4;

For conditional shipping, simply add a line in the function before any other calculations are made:

// If over $100, return 0 for shipping
if($mode == "Calculate" && $cartTotal > 100) return 0;

You could also create your own custom function here to use your own criteria for shipping.

The bottom line is that CW shipping is flexible, but it is also easily changed if you need something different.

Update (11/12/2007): Another simple modification is to charge X$ for each item in the cart, like $3 shipping for 4 items would be $12. Basically you need to pass a quantity to the function and rewrite the function so that it multiplies $3 x number of items. Add a quantity field at the end of the method:

function getShippingRates($mode="ShipList", $shipType=null, $shipToCountryID=0, $cartWeight=0, $cartTotal=0, $qty=0)

Then add a line as first line of the function:

if($mode == "Calculate") return $qty * 3;

Then change the calls to getShippingRates() to pass the cart quantity to the function on CWIncShowCartSetup.php.

$_SESSION["shipTotal"] = getShippingRates("Calculate", null, 0, 0, 0, $cartweaver->getCartQty());

]]> http://blog.cartweaver.com/index.cfm?newsid=20 http://blog.cartweaver.com/index.cfm?newsid=20 Wed, 19 Sep 2007 12:22:46 GMT Adding New Image Types to Cartweaver 3 One of the limitations of Cartweaver 2 was that only 2 images were allowed per product, and the system was not set up to allow for more image types. Cartweaver 3 comes with 4 image types out of the box and allows the programmer to add as many more images as he needs. All that is required is add the image type to the database, create the folder, and then manually code the image somewhere in the details page.

For example, to add an image type of "Secondary", follow these steps:

1. Add "Secondary" to the tbl_listimgtypes table and then note it's ID. It is probably 5. You can do this in any database admin, or run an insert statement like this:

INSERT INTO tbl_list_imagetypes (imgType_Name, imgType_SortOrder, imgType_Folder) VALUES
('Secondary', 1, 'cw3/assets/product_secondary/')

2. Create the product_secondary folder in the /cw3/assets/ directory (or whereever you are storing images).

3. Display it on the details page with:

<?php echo(cwDisplayImage($productId, 5, $row_rsCWGetProduct["product_Name"], "No image available"));?>

...for php, or:

<cfoutput>#cwDisplayImage(request.Product_ID, 5, rsGetProduct.product_Name, "No image available")#</cfoutput>

...for ColdFusion, or:

<%= cwDisplayImage(rsCWGetProduct("product_ID"), 5, rsCWGetProduct("product_Name"), "No image available") %>

...for ASP.

The function cwDisplayImage takes the following arguments:

cwDisplayImage([product id], [image type], [product name, or alt text], [to display if no image available])

After adding the new image type to the database, it will show up among the images to be uploaded in the Cartweaver admin. You can have an unlimited number of images per product.

]]> http://blog.cartweaver.com/index.cfm?newsid=18 http://blog.cartweaver.com/index.cfm?newsid=18 Wed, 12 Sep 2007 13:50:53 GMT Welcome Hello! Welcome to the new Cartweaver blog. We will be posting things here pertaining to e-commerce in general and Cartweaver in particular, with some other technology or non-technology related items as well. In case you don't know me, my name is Tom Muck, and I am the lead programmer of the PHP version of the Cartweaver shopping cart. I have also taken over the duties for the ColdFusion version as well. My posts will be primarily about different coding aspects, FAQ items, or other technical concerns with Cartweaver, ColdFusion, PHP, SQL, or other topics. I have been doing this many years, and have my own site www.tom-muck.com where I have been selling Dreamweaver extensions for years. I also write for Community MX, and have over 100 articles available there and other places, dealing mostly with ColdFusion, PHP, SQL, and e-commerce.

One of my goals here will be to document many of the little code enhancements or modifications that I have been posting on my own site.

Thanks for listening!

]]> http://blog.cartweaver.com/index.cfm?newsid=8 http://blog.cartweaver.com/index.cfm?newsid=8 Tue, 14 Aug 2007 17:04:58 GMT