PLEASE NOTE: DO NOT USE THE DLLs FOR LINKPOINT ON A SYSTEM RUNNING WINDOWS XP PROFESSIONAL PLEASE ALSO NOTE: DELETE_ORDER.CFM NOW DELETES THE ORDER FROM THE DATABASE. IT USED TO JUST DELETE THE HTML ORDER, BUT LEFT THE DATA IN THE DATABASE. TO DELETE AN ORDER PERMANENTLY, YOU HAD TO GO INTO ADVANCED ORDER PROCESSING. THIS IS NO LONGER THE CASE! Fixed a bug; form failed to pass the taxable flag when using attributes. Also modified sql script to allow nulls in table ProdPics. Files changed: admin/save_prods.cfm qes_tables.sql Fixed a bug; checkout_cart failed to properly add shipping under a specific scenario. Files changed: checkout_cart.cfm Fixed a bug; cc_expyear not passed correctly, "Yesterday" orders not querying properly. Files changed: checkout_cart.cfm Files changed: view_orders.cfm Fixed a bug; cc_expyear not passed correctly to TheLinkApi.cfm (CSI custom tag). Added support for the SkipJack payment system. Files changed: checkout_cart.cfm Added Ship To information to Ord_Detail for permanent retention of this info. Info now displays in "Advanced Order Processing". Added NumberFormat mask to salestax vaue in checkout_cart. Added rename category function. Files changed: checkout.cfm checkout_cart.cfm edit_cats.cfm save_cats.cfm finish_order.cfm finish_order_payflow.cfm qes_tables.sql Added fields to Params to store fax number and address for store (for offline ordering). Files changed: setup.cfm checkout.cfm qes_tables.sql Added "New" field to table Products. Checking the "New" checkbox in add or edit product causes QuicKEStore to display a "New" graphic next to your thumbnails. Added support for PayPal single item purchase. Read the readme.doc for instructions on integrating PayPal. Altered all store templates. They are all frameless. This enables the SSL icon in MS and Netscape browsers to properly display. Added a graphic for "no image available". This is the thumbnail that displays when there is no image. This helps keep a consistent look on the product preview pages. Files added: checkout_pp.cfm (used for PayPal only) ipn.cfm (used for PayPal only) menu.cfm proddetail_pp.cfm (used for PayPal only) thanks_pp.cfm (used for PayPal only) store1.cfm store2.cfm store3.cfm store5.cfm thanks_pp.cfm Files changed: ch_params.cfm index.cfm qes_tables.sql th_noprod.gif Removed: directory "Store1" and all files it contained directory "Store2" and all files it contained directory "Store3" and all files it contained Fixed a bug in copy product. Fixed a bug (404) in "Back" link after clearing cart. Fixed product detail so that it shows "Reg." and "Sale" prices when appropriate. Made minor improvements to product display for templates 3 and 5. Files altered: checkout.cfm edit_prods.cfm menu.cfm proddetail.cfm store3.cfm store5.cfm Fixed a bug in payflowpro.cfm. This only affected users of PayFlowPro. Fixed Setup.cfm to remember store address and fax number info. Added links to QuickEStore recommended affiliate sites, AuthorizeNet and Bank of America. Files altered: payflowpro.cfm setup.cfm Fixed another bug in payflowpro.cfm! This only affected users of PayFlowPro. Added support for Bank of America's e-Branded payment gateway solution. Files Added: checkout_cart_bofa.cfm finish_order_bofa.cfm Files altered: checkout.cfm setup.cfm setup_processor.cfm view_orders.cfm Fixed a bug in finish_order_payflow.cfm! Sales tax value needed masking to two decimal places. Altered edit_prods.cfm to display product category next to product name. Files altered: edit_prods.cfm finish_order_payflow.cfm Added a template that displays PayPal Single Item Purchase as an option alongside of the normal "Add to Cart" button (store template 6). Added a template for PayPal's Shoping Cart (store template 7) Added the capability to rename sub-categories. Added the option to upload images for association with categories and sub-categories. When present, the images are displayed using store template 8. Changed the "Next" button on the final checkout page (checkout_cart.cfm) to a "Submit Order" button. Fixed inventory management function such that any order that would put onhand inventory into the negative for a product flagged "do not allow orders when qty is zero" is forbidden. Files Added: proddetail_ppcart.cfm store6.cfm store7.cfm store8.cfm Files altered: ch_params.cfm checkout.cfm checkout_cart.cfm edit_cats.cfm edit_prods.cfm finish_order_payflow.cfm index.cfm insertorder.cfm prodpage.cfm proddetail_pp.cfm save_cats.cfm save_prods.cfm updatecart.cfm Edited TheLinkAPI.cfm - expyear reformatted Edited customerservice.cfm to properly display store image file Edited store7.cfm (PayPal cart) so that it will pass product attributes to PayPal Edited store8.cfm and store6.cfm to fix attribute bug (both attribute one and attribute two fields were named "Att1". Edited proddetail_pp.cfm so that it works properly with PayPal cart. Completely revised ipn.cfm to integrate seamlessly with PayPal. File now writes entire order, including product attributes, sales tax, and shipping, to your QuickEStore database. Edited finish_order_payflow.cfm - again. Shipto information now properly returned, and file now parses first name and last name from Payflow's single "Name" form field. Edited ord_detail.cfm to properly display this shipping information. Edited qes_tables.sql to make CustomerID field in Customers table an "Identity" type with NULL disallowed. Files altered: finish_order_payflow.cfm ord_detail.cfm qes_tables.sql Added template popstate.cfm to populate the table "States" when using SQL server. Edited "view_orders.cfm". This template now only displays the last four digits of the customer's credit card number. This allows the merchant to use this page as a receipt or shipping manifest. The whole credit card number is visible when selected from the drop down menu on this page. Added Inventory Report. Altered finish_order_payflow.cfm Altered ipn.cfm to accommodate instances where the purchaser selects "no shipping address necessary" in PayPal. In this case, no address, city, state, zip or country is returned to QuickEStore and nulls are inserted instead. Added three fields to table "Products": DiscAmt (Number) DiscIsPct (Y/N) DiscTrigger (Number) QuickEStore now supports discounts. In the "Add Product" and "Edit Product" admin pages, the merchant can enter a discount amount, declare it a dollar amount or percent off, and set a "trigger" - the number of this item the customer has to place in the cart before the discount is triggered. Does not work with PayPal. See readme.doc for details. Files altered: edit_prods.cfm insertorder.cfm updatecart.cfm Proddetail.cfm save_prods.cfm store1.cfm store3.cfm store8.cfm Also added page_footer.cfm and cfincluded it into all store pages. Ensures closing HTML and BODY tags are present for better performance in Netscape and other sensitive browsers. Fixed bug in edit_prods.cfm (SQL installs) that crashed when adding or copying products. Added default value of zero for product level discount, and added form variable "Show_Inventory" on the copy product form. Updated qes_tables.sql to reflect new database tables. Added QuickEStore_Data.Mdf and QuickEStore_Log.Ldf (SQL Database Files) to the zip archive. Setup script no longer defaults to ACC after setup has been run for SQL installs. Files altered: edit_prods.cfm setup.cfm Enhanced customer search in QuickEStore admin to allow searching by customer first or last name. Enhanced view orders page in admin to allow searching by user-defined date range. Fixed bug in authnet.cfm that set all transactions to AUTH_ONLY. Added CyberCash back to setup_processor.cfm. Files altered: authnet.cfm custlist.cfm custdetail.cfm email.cfm openauthnet.cfm quickecrm.cfm setup.cfm setp_processor.cfm view_orders.cfm PayPal cart is no longer used. In this version, choosing the "PayPal Optional" template (store 6) results in a "Pay With PayPal" option at the end of the checkout process. That is to say we no longer use the PayPal shopping cart. We use the QuickEStore cart and at the end (checkout_cart.cfm), we can either enter a credit card, etc., or click on "Pay With PayPal" and QuickEStore will post the entire cart contents to PayPal. This effectively means that you can even use price-based attributes with PayPal now, as long as you aren't using PayPal's limited "Single Item Purchase". Files altered: checkout_cart.cfm store6.cfm QuickEStore is AuthorizeNet Certified, and now supports the "e-check" payment method available through AuthorizeNet. Also, a bug that caused an error when using the new PayPal optional template is fixed. The error occurred when the customer clicked on the product to view product detail. This only happened with template 6 (store6.cfm). Files altered: authnet.cfm checkout.cfm checkout_cart.cfm openauthnet.cfm writeorder.cfm store6.cfm Files added: various graphics to support the e-check checkout method. Placed screenshots of the eight store templates in the setup file for reference during store setup. Also added a 9th store template that is basically the same as Template 6 (PayPal Single Item Purchase) but with a standard "Add to Cart" button for credit card purchasing, instead of PayPal payment. Modified the "Edit Shipping" link in the Admin Screens. Now you can edit the Price or Weight threshhold and the associated shipping fee at the same time. (Functional enhancement). Files altered: setup.cfm editshipping.cfm Files added: Store1.jpg Store1_sm.jpg Store2.jpg Store2_sm.jpg Store3.jpg Store3_sm.jpg Store4.jpg Store4_sm.jpg Store5.jpg Store5_sm.jpg Store6.jpg Store6_sm.jpg Store7.jpg Store7_sm.jpg Store8.jpg Store8_sm.jpg Store9.cfm Added to setup script. Value is written to the cfapplication file upon successful setup. This prevents a parameter not found error in certain situations. Added Integrated UPS Shipping rates using CF_UPSRateMonger. See readme.doc, page 10, for usage instructions. Improved PayPal integration. Cart now sends tax and shipping values to PayPal. Improved PayPal documentation and illustrations. Fixed bug in application.cfm file for UPS shipping rates (bad file path). LinkPoint API updated files to conform to LinkPoint changes. LinkPoint account holders were notified of changes to the API/gateway. Remediated files were provided on request on or after 10/03/2005. These files are now included in the production release. Changed "allow orders when inventory equals zero" functionality on all store templates. Instead of removing the product from the store, QuickEStore now removes only the "Add to Cart" (or "Buy Now with PayPal") button. Files added: pay_proc\config.inc pay_proc\LINKtest.cfm pay_proc\lpcfm.cfm pay_proc\status.cfm dll\LpiCom_6_0.dll Files changed: pay_proc\TheLinkApi.cfm store2.cfm store3.cfm store4.cfm store5.cfm store6.cfm store7.cfm store8.cfm Modified the VeriSign PayflowPro gateway interface to conform to new Java-based CF custom tag. Modified the AuthorizeNet gateway interface - added the field x_tran_key, which passes the account password, which is now required. Included a pdf file called AuthNetGatewaySetupForm.pdf for applying for the AuthorizeNet merchant account and/or gateway, for which I am a reseller. Modified the setup script. You can now select a checkbox during setup indicating that you want to "offer PayPal as an option upon checkout". This means that with ANY of QuickEStore's storefront templates, you can offer the customer the option of paying with a credit card or their PayPal account at the checkout screen. You can also check "PayPal only" during setup to offer PayPal exclusively upon checkout. Added the BluePay payment gateway as an option in "Setup CC Processor" in the Admin screen. Added two new fields, "Vendor" and "Certificate Path" in the "Setup CC Processor" screen for PayflowPro customers. In the Add/Edit product screen in Admin, the drop-down for "Attributes" only displays when one or more attributes has been defined. Also, "Quantity in Stock" defaults to 1000 when entering a new product, while "Safety Stock" defaults to 1. Four new fields have been added to the table "Params": vendor, certpath, paypalonly and offerpaypal. Phone number is a required field in checkout.cfm Files changed: admin\edit_prods.cfm admin\save_prods.cfm admin\setup.cfm admin\view_orders.cfm pay_proc\openauthnet.cfm pay_proc\payflowpro.cfm application.cfm checkout.cfm checkout_cart.cfm Files added: includes\cc_only.cfm includes\pp_only.cfm includes\pp_option.cfm