Version: Description: 2.00.00.05: Commerce 2003 release candidate. 2.00.00.06: Minor non-technical modifications. 2.00.00.07: Resolved bare line feeds being inserted in email text when using USA e-Pay as a payment provider. This affected some Qmail servers. 2.00.00.08: Resolves the display issue when using UPS OnLineŽ Tools and a rate compare of available shipping methods was selected. Resolved the inventory reset of basket items when one or more items are out of stock and not allowed to be backordered. Enhanced the rounding mechanism that is used (some instances were rounded down when the result ended in an exact half cent value). Added a link for minimum quantity, weight error and basket empty page. 2.00.00.09: Changed UPS Details by Adding a 'Register' button. This requires a new AdminTemplate (upsdetailsform.htm) Modified DataBase configuration screen for commerce to display whether it can connect to the DataBase or not. The connection status message has become real time where in previous versions it did not connect to the DataBase and showed a not connected message. 2.00.00.10: Resolvced Fixed buffer overflow issue with #CGI tag. 2.00.00.11: Added minimum and maximum quantity tags. Added header, footer, and site name tags to the Templates Updated license error messages. also gives a notice to check permission when we cannot open the license file. 2.00.00.12: Added tag for checkout page, it will be populated with a registered user's company. 2.00.00.13: Resolved issue with editing county list in administrator when web site does not contain www. in host name. 2.00.00.14: Increased amount of data that can be passed in a #CGI tag (total amount of data is now 4096 characters. 2.00.00.15: Internal modifications for processing template tags. 2.00.00.16: Integrated the country codes Authorize.Net provided into the AIM protocol. 2.00.00.17: Resolved issue when shopper parsed repeat row tags, occasionally first tag was not processed. Resolve issue with forcedcookie and passthrough data not being passed on to the Verify Template. 2.00.00.18: Resolved ITEMOPT tag display issues. Resolved issue with CONTINUE_BUTTON tag on the ShipCompare template. Resolved issue with USPS number per box when ordering less than the max per box. 2.00.00.19: Improved UPS registration process when user fields contain the ampersand character. Force package shipping weight to at least the minimum allowed for any real-time (UPS or USPS) method. Improved creation routine for temporary file for shopping cart use. Enhanced making modification with the administrator, if unable to save changes an error page will be displayed. 2.00.00.20: Verisign Payflow Pro item reporting added to products authorization requests. 2.00.00.21: Enhansed interanal handling of the basket cookie to minimize errors when cookie become mangled. Resolved issues with the defaction elements for the Verify and Buyit actions. Removed the error page when making changes live could not locate a stage file to delete. 2.00.00.22: Minor non-technical modifications. 2.00.00.23: Added tag for emails to print softgood exec data. 2.00.00.24: Resolved empty search results being returned if the search query contained no 'OR' tokens. 2.00.00.25: Added Configuration variable (mysql_socket) to facilitate MySQL installations to other than the default directory structure. Resolve issue with not all option combinations being displayed when tracking by all options and some combinations were out of stock. PayPal integrated with PDG Commerce (need new AdminTemplates). 2.00.00.26: Integrated VeriSign's PayFlow Link payment method. Enhanced the handling of inventory when using a 'linked' payment method (WorldPay, PayFlow Link and PayPal). Item will not be removed from inventory until the callback is received. Updated the MySQL AdminTemplates to handle configuration variable for MySQL socket. 2.00.00.27: Enhanced Worldpay's integration to use local order details storage similar to VeriSign's PayFlow Link integration. Uses a temp xml file to hold custom text, passthrough data, affiliate information, shipping cost and the basket data string. Resolve issue with customers having to log in after registering as a new user. 2.00.00.28: Resolve issue with Previous Search Link not appearing on thumbnail search output pages. 2.00.00.29: Checking out now allows for a 'Checkout Select Template' that will not display the basket selection option after registering or login but will utilize the existing anonymous basket. This also affects the regular registration process; the customer's basket will contain the data from any existing anonymous session on the client machine. Resolved the registration error page issue that was displaying the Company information in the email field. 2.00.00.30: Added functionality to allow customer's to retrieve their login password if forgotten. It will be emailed to the email address on file. Resolved issue with determining the total number of items for a given search query, some instances were returning zero and the check for maximum number was not performed. Added internal check to ensure a template name is provided, if not an Error page is displayed. Modified the Administrator's template output to include the full version information vice just the patch level and database table version number. 2.00.00.31: Minor non-technical modifications. 2.00.00.32: Made some PayPal enhancement changes based on feedback from Papal. Stripped non-numbers from the phone number field for PayFlow Link. 2.00.00.33: Resolved HOSTNAME_LENGTH define conflict between mailmod module and MySQL files. Ensured shopper attempts to open the specific product text file even if it is no specified in the product database definition. 2.00.00.34: Added a comment1 field to the PayFlow Link method to agree with the implementation of PayFlow Pro, removed the AVS information from the customer email. Enhanced the search mechanism when determining is the search string will result in exceeding the maximum search results. Enhanced displaying the specific product text if the database contains empty strings vice NULLs for file location. Commenced building Linux RedHat and FreeBSD versions as staticly linked (larger file size) due to some library issues on customers servers. 2.00.00.35: Added anonymous checkout templates (both secure and non-secure). If the anonymous checkout template does not exist commerce will display the standard one. Resolved improper SQL statement when updating User Defined data (affected MySQL databases only). 2.00.00.36: Resolved issue of not having the proper template file specified for the Item Template. 2.00.00.37: Resolved issue of passing an inappropriate country code to WorldPay. 2.00.00.38: Resolved issue of not removing all of the UPS XML temporary files that were generated to obtain a rate quote. 2.00.00.39: Fixed improper SQL statement for creating new User Defined data row in database. Another work around is to set the USERDEF column UD_Searchable to allow NULLs. 2.00.00.40: Resolved issue with Country display when editing/viewing the last section. 2.00.00.41: Bypassed sending real-time shipping request if basket weight is zero. Modified US postal code to 5 digits before sending to USPS for a rate quote. Fixed issue where product descriptions were always being searched even when the Administrator checkbox was selected. Enhanced the mechanism for specific product price overriding the customer category discount. If input box is empty any override will be removed, if input box is set to 0 (zero) no discount will be applied. Resolved the issue with splitting contact shipping and billing information where one of them was no longer displayed. Resolved infrequent 'corrupt license' error when updating to a new license. 2.00.00.42: Resolved issue with CyberCash builds not properly communicating with the CyberCash server. Built new sslconx.exe (version 1.4) to properly handle files > 64 kBytes (required for CyberCash build on Window's platform only). 2.00.00.43: Resolved issue with not being able to remove specific product discounts for a given customer category. Resolved issue with not maintaining the product category for the 'Return to Product Listing' link on the product detail page after leaving a discount page. 2.00.01.00: Enhanced method for initializing internal structures at program start. Search queries can not include a form element to have the search result displayed in reverse order. Include to form or add &sortorder=descending the href= string. Added functionality to have external StateList file (StateList.txt) to load state/province codes and full names. The file needs to be located in the PDG_Commerce directory. This will allow merchants to add APO's and FPO's to State DropDown boxes (It will only apply to US and Canadian country selections). 2.00.01.01: Enhanced Passthrough recording by not allowing a field name of password to be outputted. 2.00.01.02: Added the middle initial to the bill first name cell of the order csv file. 2.00.01.03: Resolved issue with 'Shop Some More' not directing customers to the expected page when the resulting page is a search output with a quoted phrase in the keywords field. 2.00.01.04: Added tag (!---ORD_INDEX---) to print the OrderID number in emails. 2.00.01.05: Resolved the issue with updating the primary contact date on a customer update query. 2.00.01.06: Resolve error when generating UPS rate query and multiple packages are involved. 2.10.00.00: Enhanced product licensing for Hosting Providers. 2.10.00.01: Removed the functionality of defaulting to an off line payment method when unable to determine the payment value submitted. 2.10.00.02: Resolved the issue of not completing a link payment method (PayPal and Payflow link) when pass through data is not entered on form. Optimized the search routine in the Shopping Cart. 2.10.00.03: Resolved issue with not always being able to modify the AVS setting for the USA ePay payment processor. Added variables requested by PayPal to submission data on redirect. Modified the database order logging to use server local time vice GMT. Changed the ORDER_INFO table TimeValue field to use 01 as January vice 00. Field is read as CCYYMMDD (i.e. 20030819 for Aug 19, 2003) 2.10.00.04: Resolved issue with preparing SQL statements when text fields required modification prior to being entered. 2.10.00.05: Resolve issue with setting the customers cookie as a per-session vice permenant cookie. 2.10.00.06: Resolved issue with country determination for UPS details display. 2.10.00.07: Added the authorization code return value from CyberCash to the vendor email billing section. CCV2 is now passed to the CyberCash gateway server for validation. Modified how package weights are determined to be below the minimum level when using a realtime shipping method (i.e. UPS or USPS). The package does not require dimensions to have the weight set to the minimum in the rate quote trnasaction. Enhanced displaying the realtime shipping error messages. Up to 1024 characters will now be displayed in the error table. 2.10.00.08: Resolved issue with vendor emails being sent more than once if multiple vendors are listed. 2.10.00.09: Resolved issue with not setting the From address for vendor emails when sending the failed order emails on UNIX platforms if sendmail was used. 2.10.00.10: Fixed issue with credit card when it does not pass luhn10 check and using VeriSign payment method. 2.10.01.00: OpenSSL upgrade. 2.10.01.01: Modified SSL communications for AuthirizeNet 2.10.01.02: adjusted Customer Verification to not require a zip code for international address. Fixed Order Reporting issues. 2.10.01.03: Modified PayPal to set the return method to link, this allows returning to a static page with IPN enabled Modified PayPal to submit the default currency code to PayPal vice relying on the merchant's settings. 2.10.01.04: Modified !---INV--- and !---INVOPT--- item repeat output tags (used in seraches and multiadds) so that they do not force a linefeed after the data is printed. 2.10.01.05: Modified Administrator templates modify check. 2.10.01.06: Special Build 2.10.01.07: Added new tags to thankyou, verify and verify inv error templates ( !---BILLPROV--- and !---SHIPPROV--- ) 2.10.01.08: Fixed issue with duplicate orders on reports for UNIX Based systems (Does not affect Windows Servers) Fixed navbar sku search inventory issue. The display function was not printing first item in list and only displaying a max of 5 skus. Fixed Price display for Customer Category setting (Display Pricing) If unchecked does not show prices. 2.10.01.09: Fixed Move product to another category was not working because of default option and option lock settings. 2.10.01.10: Fixed usps rate quote to truncate the zip at 5 chars for usps domestic quotes. Added pass through tags for thankyou/verify templates (includes credit accept). The new tag will be . It will return the value portion of the pass through field. Added tag to display customer category name for all templates. The new tag is 2.10.01.12: Inv issue - Some product's inv nodes have 0 set for flags. This cuases the inv node not to be located. The shopper now accepts a 0 flag for an inventory node. Adjusted babble validation. An encrypted signature string will override the current IP check fo babble validation. 2.10.01.13: Remove/Recalc bug - introduced in patch 12 has been fixed. Multiadd single add (madd) action not using the appropriate template when template is passed to the program as an html element. Issue fixed with link payment methods (paypal,payflow link and worldpay) due to encryption signature (introduced with patch 12). The order item (product) details were not displayed or logged properly. 2.10.01.14: Commerce admin now has the ability to delete all products through the maintenance page (new form) 2.10.01.15: PayPal payments now allow the merchant to log pending orders (new paypal form). A checkbox has been added to the PayPal admin page to log pending transactions. If it is checked the cart will log and send the order information twice (once for the pending notice and once for completed notice. Fixed customer verification issue. The verify action was allowing a customer to continue without providing the billing state. 2.30.01.17: Multiple ship destination commerce released 2.30.01.18: Commerce can now install the db through the admin under database configuration 2.30.01.19: PayPal fix for pending order logging when completed. The string "Compare Rates" in emails, OrderLog and Default thankyou display has been has been removed for UPS. Only the selected UPS method will display. Fix for shipping error introduced in patch 01.14 where the 1st [0 index] ship method does not display the Rate Compare page if it is a "RateCompare" method. 2.30.01.20: Multiple ship destination fix -there was a problem with number per box items and ups warning display. USA Epay issue where the customer's first and last name did not have a space seperating them. Fixed display for listcategories action. 2.30.01.21: Fixed multipreadd issue with cart2004. displays template error. 2.30.01.22: Commerce Order reporting issue for admin where main order page does not fully display, has been fixed. 2.30.01.30: Release of Gift Certificates in commerce. Payment csv update - non-credit and non-check payment methods will display the payment description in the csv paymentline. Order reporting bug has been fixed - error when displaying orders admin page - (has to do with december). Standard Basket output tag when displaying ups disclaimer was "squishing" some of the other basket columns.(has been fixed) Admin DB Install was not installing the babble table correctly - this issue has been fixed. Subtotal Discounts were not allowing the discounts to change (commerce only) has been fixed. Added !---BILLMETHOD--- tag to thankyou pages to display the payment method description. 2.30.01.31: Billtext was not getting set to ship address when shiptobill was checked. Fixed it so that the shiptext is being set to the billtext.. 2.30.01.32: Deleteing a customer cat gave an incorrect error to check if the customer cat has users when it should have deleted the category (MySQL-UNIX). Fixed thankyou ups warining for shipping when items have zero weight. Added basket tag "!---PRICE_WITH_ITEM_DISC","!---QTYPRICE_WITH_ITEM_DISC" . Added item repeat (alreay available for single item display) tags "!---ORIGINAL_PRICE","!---DISCOUNT_AMOUNT","!---TEXT_ORIGINAL_PRICE---","!---TEXT_DISCOUNT_AMOUNT---" 2.30.01.33: Custom development if "Deny_Duplicate_CSV_Orders" is in the conf file then the cart will check to see if the order being placed is a duplicate. This is done by checking last name, zip, email and items ordered the CSV file. 2.30.01.34: Custom development if "Use_Subtotal_For_Ship_Percent" is in the conf file then the cart will use the subtotal for the base amount if a percentage is in the additional cost for a shipping method. Fixed basket tag "!---PRICE_WITH_ITEM_DISC","!---QTYPRICE_WITH_ITEM_DISC" the discount was eing added now it is being subtracted. 2.30.01.35: Gift Certficate reporting for the administrator (windows only). 2.30.01.36: Fixed problem where the administrator Logout action was not performing an SSL check for the logout page. Deny duplicate order will now determine the csv type based on the switches in the admin. adding text file for deny message. 2.30.01.37: Fixed problem where 'I' was missing from 'I' record of non releational csv - only affected cart2004. Final modification for deny duplicate is complete. 2.30.01.38: Fixed problem with search page and current num items and current subtotal tags. 2.30.01.39: Fixed default surepay gateway (was 'www.surepay.com' now it is 'xml.surepay.com') Gift certificate administrator reporting available for unix versions. If rate compare fails the shopping cart will use the back up ship method. Fixed previous/next search issue when some items are beign tracked by inventory but are not available. 2.30.01.40: !---COMPANY--- tag added to verify and thank you pages. Only displayed if 'company' is collected on checkout (or verify - then only displays on thank you) AIM protocol will use 'nameoncheck' if it is collected on verify page. Otherwise 'first last' name is used. Bill Information for a Customer will now include 'company' if it is collected on the checkout page. 2.30.01.41: Fix for error that was introduced in patch 40. If company is being collected on checkout the final "thank you page" can display a Internal Server Error instead of the correct thankyou output. 2.30.01.42: The month drop down on the order page was not listing December. This has been fixed. 2.30.01.43: Outstanding gift cert display has errors on windows release. The issue has been fixed for this patch. If template=[file name] is passed in on a removeall action then the [file name] template will override the empty basket and/or basket template. 2.30.01.44: Fixed Softgoods issue where no exec data was being displayed 2.30.01.45: Fixed windows (admin) order display some items were appearing with 0 qty and price. (even thought the totals were correct). Changed Commerce registration to only require state/province and zip code for US. 2.30.01.46: Beta USA E-Pay check payment functionality has been added. Copyright year has been set to 2004. Fixed Softgoods download (items were not appearing in realtime.csv) issue that was introduced with patch 44. 2.30.01.47: No change for commerce. 2.30.01.48: Error in getting link id for item discounts (UNIX Commerce only). 2.30.01.49: Fixed display error in !---QTYAMOUNT--- tag where the onetime option flag was being ignored. Fixed thumbnail search output error, which was due to out of stock for inventory when displaying search results. 2.30.01.50: Moneris - install build for testing. If no problems will be release build. Remove shipping charge in admin displayed shipping page in error - now the action displayes shipping table page. 2.30.01.51: UPS_SERVER_ADDR Switch added for hosts that are having trouble resolving www.ups.com Check_Binary_Stamp Switch added for hosts that are opening admin templates in binary. 2.30.01.52: WorldPay basket issue on receipt page (commerce only). The basket display was for an empty order -- this issue has been fixed in this build. Moneris Release Build Commerce only. 2.30.01.53: XML order logging had some errors with regards to shippingmethod and phone pdgorder nodes. The doc type has also been removed from the xml file 2.30.01.54: Search output error when tracking inventory and not displaying items if not in stock (under special circumstances).. 2.30.01.55: USPS_SERVER_ADDR Switch added for hosts that are having trouble resolving usps web site. 2.30.01.56: Softgood modifications for Commerce Service Release - this WILL affect Cart versions. The same functionality is being added to both product lines. 2.30.01.57: UPS XML tracking fix. The date was displayed as d. Now it displays the date correctly. Cross/Up sales built into Commerce for service release. , were added to add item template tags. added to repeat item output and sample-item output , added to basket repeat tags. ConfigRoot transparent gif will be used for image tags with no image defined. in standard email will generate download links. 2.30.01.58: Added UPS OS3 designation to UPS XML tools USPS Was not displaying the selected method name for International or Rate Compare. 2.30.01.59: Updated "View All Customers" admin action for Commerce. Large customer database was taking a long time to load. FIXED csv file error introduced with last patch. (due to USPS method name fix). 2.30.01.60: Fixed customer search/display issues in Commerce admin (affected UNIX platforms). Fixed remove of shared options (affected UNIX platforms). 2.30.01.61: Default Sample-Item (non template display) will now show product Up Sales. Added tag this will display the product category quantity discounts. Added "AIM_USE_FULL_INVOICE_NUM=Yes" config setting to send the full invoice number (including prefix) to the AIM payment processor 2.30.01.62: Transaprent.gif for product images fixes. Keyword thumbnail output display error with first item (only occurs if not Indexing). 2.30.01.63: Adjusted country display list to handle commerce (ver 1) contact record's country settings. 2.30.01.64: Adjusted admin order display to add a '
' for page breaks while printing orders. 2.30.01.65: Major search engine overhaul. Fixes issue with inventory and search previous and next buttons. New config variable "Check_INV_When_Building_Search_List" This will toggle between checking inventory only for display items (default for optomized search speed) OR check inventory before an item is put in the search list (this will check inv for items that will not be displayed - much slower that default). New search page tags for sort ordering on the fly. "!---SORT_BY_DESC_PRICE_URL---", "!---SORT_BY_ASC_PRICE_URL---", "!---SORT_BY_DESC_SKU_URL---", "!---SORT_BY_ASC_SKU_URL---", "!---SORT_BY_DESC_DESC_URL---", "!---SORT_BY_ASC_DESC_URL---", "!---SORT_BY_DESC_ORDER_URL---", "!---SORT_BY_ASC_ORDER_URL---", "!---SORT_BY_PRICE_HEADER_URL---", "!---SORT_BY_SKU_HEADER_URL---", "!---SORT_BY_DESC_HEADER_URL---", New parameters accepted for search action sortkey=[price|description|sku|order],sortorder=descending(ascending is the default),perrow=[#],perpage=[#] 2.30.01.67: Admin Replicate/Restore fix for UNIX versions. 2.30.01.68: Updates to Paylow Link integration. billtext and shiptext was not being stored by the shopping cart. This has been fixed. Updates to Paylow Link integration. Some shipping charges were not being recorded by the shopping cart. This has been fixed. 2.30.01.69: Adjusted !---VALUEOPT --- tag on the sample item page because the tag was displaying a
after the select box. In the case of a custom text option the tag will still provide a custom text textarea with a
between the select and the textarea and a
after the textarea. 2.30.01.70: UPS has changed the Pickup Type Rate Chart. This update has been implemented in compatible PDG Products. This PDG Product has been modified to update current shipping methods and display the new pickup rate chart types. Update to order report page so that the current year is preselected in the select box. Update User will not allow adding of duplicate friendly names. 2.30.05.70: Commerce 2003 SR1 release. 2.30.05.71: Ship API update which creates new csv file to store order data (seperate from order csv file). Ship API update the new ship csv file will be created when changes are made live in the administrator. Check_HTML_Email_File_for_CRLF=yes added to config vars. This forces the CRLF check for the html email template. 2.30.05.72: Ship API has a new schedule shipments page with the ability to delete a single order (from the shipment scheduler). Ship API has a new schedule all shipments page with the ability to deselect specific invoices for shipall. Ship API has a purge shipping history function, which will purge all shipped invoices/1Z number before a specific date (entered by merchant). 2.30.05.73: Update/Remove corresponding ProdText file when product removed / sku changed. Commerce only. Added following tags for use on CreditAccept/ThankYou.html page: "!---CARD_TYPE---", "!---CARD_NUMBER---", "!---CARD_EXP_DATE---", "!---BANK_NAME---", "!---ROUTING_NUMBER---", "!---CHECK_NUMBER---", "!---ACCOUNT_NUMBER---", 2.30.05.74: Upgrade DB for Commerce SQL error corrected. 2.30.05.75: UPS XML requires InvoiceLineTotal for orders originating in the US and going to Puerto Rico or Canada. was not displaying information on custom email. This issue has been fixed. 2.30.05.76: Added some more payment information to Pfpro request (SHIPTOSTREET,CITY,SHIPTOCITY,SHIPTOSTATE). Some adjustments to STREET,STATE were also made. 2.30.05.77: Modified PDG Mailer to use the email vendor name for who the email is from. UPS XML ship all function needed modification from patch 75. 2.30.05.78: Custom Basket Option tags were not displaying based on Product Option settings. This patch fixes that issue. Added DOCUMENT_ROOT to Windows root directory search. 2.30.05.79: Added tag that displays authorization status returned from payment service. This tag can be used on ThankYou, CreditAccept, and HTML emails 2.30.05.80: Added , repeat tags that display on the item template. These tags would surround a section of the page that will be repeated for each item discount line. Additional tags to be used inside of the above mentioned section. "!---MIN---", "!---MAX---", "!---DISC_AMT---", "!---ITEM_PRICE---", 2.30.05.81: Added product category check for searches. If the product category does not exist an error will be displayed. 2.30.05.82: Fixed problem that occurs with products without options. The add action would not add the product in question. This issue has been fixed - the option without selections will be ignored. 2.30.05.83: Functionality for including one-line description in the csv is now available. 2.30.05.84: The UPS and/or Shipping information was not getting writen to custom HTML emails. 2.30.05.85: Fix for PDG_[prod] dir search affected unix only. The cgi-bin location was not located due to DOCUMENT_ROOT and SCRIPT_FILENAME env settings. 2.30.05.88: Fixed issue where some "special notification" emails were double spaced on UNIX based servers when using sendmail.