e-Commerce Package

The ACS 3.x based e-commerce solution ported to OpenACS. This module implements a standard business-to-consumer Web store service. A feature summary is included with the documentaion.

Warning: This package is outdated and not maintained anymore.

 

Package Documentation 

Procedure Files

tcl/ec-audit-trail-procs.tcl       Procedures uses to view the audit trails documented in /www/doc/audit two procs helpful for building pages that show audit history for a set of id's in a table between specific dates 
tcl/ec-product-sc-procs.tcl       Procedures uses to view the audit trails documented in /www/doc/audit two procs helpful for building pages that show audit history for a set of id's in a table between specific dates 
tcl/ecommerce-credit-procs.tcl       Procedures related to credit card transactions for the ecommerce module 
tcl/ecommerce-customer-service-procs.tcl       Customer service procedures for the ecommerce module 
tcl/ecommerce-email-procs.tcl       Email procedures for the ecommerce module Started April, 1999 by Eve Andersson (eveander@arsdigita.com) Other ecommerce procedures can be found in ecommerce-*.tcl 
tcl/ecommerce-money-computations-procs.tcl       Computes the total price of an order. 
tcl/ecommerce-procs.tcl       Definitions for the ecommerce module Note: Other ecommerce procedures can be found in ecommerce-*.tcl 
tcl/ecommerce-scheduled-procs.tcl       Scheduled procedures for the ecommerce module. 
tcl/ecommerce-ssl-procs.tcl       Definitions for the ecommerce module Note: Other ecommerce procedures can be found in ecommerce-*.tcl 
tcl/ecommerce-state-changes-procs.tcl        
tcl/ecommerce-user-contributions-summary-procs.tcl       Exists only to show the site owner a user's activities on the site in the ecommerce system. 
tcl/ecommerce-utilities-procs.tcl       Utilities for the ecommerce module. 
tcl/ecommerce-widgets-procs.tcl       Definitions for the ecommerce module 
tcl/ecommerce-zip-codes-procs.tcl       Definitions for the ecommerce module 
tcl/froogle-procs.tcl       Froogle (http://www.google.com/froogle) data feed procedures. 
tcl/qmail-procs.tcl       qmail support procs. 

Procedures

ecGetUserAgentHeader       Gets user agent header 
ec_IllustraDatetoPrettyDate       date to pretty date 
ec_PrettyBoolean       Returns Yes or No instead of t/f 
ec_acs_admin_url        
ec_add_to_cart_link       Returns cart link 
ec_admin_present_user       link for admin to view user information 
ec_adp_function_p       Checks for any function execution in an adp page 
ec_all_cs_issues_by_one_user       creates html list of all issues by user_id or user_identification 
ec_all_orders_by_one_user       returns all order for this user 
ec_apply_gift_certificate_balance       This proc takes the place of the pl/sql procedure ec_apply_gift_cert_balance 
ec_assert_directory       Checks that directory exists, if not creates it 
ec_audit_delete_row       Inserts an entry to the audit table to log a delete. 
ec_audit_generate_column_name       Returns a max-length character (max) length identifier for the table and column name, joined at the hip by an underscore. 
ec_audit_process_row       internal proc for ec_audit_trail Sets audit_entry to the HTML fragement representing one line from the audit table or main table. 
ec_audit_trail       Returns an HTML fragment showing changes to one row in the OLTP system between the times start_date and end_date (YYYY-MM-DD HH24:MI:SS). 
ec_audit_trail_for_table       Returns the audit trail for each id from the id_column for updates and deletes from main_table_name and audit_table_name that occured between start_date and end_date. 
ec_best_price       Returns the minimum price offered 
ec_calculate_product_purchase_combinations       Find product purchase combinations and store those in ec_product_purchase_comb. 
ec_canned_response_selector       returns a canned response selector 
ec_capitalize_words       Capitalizes first letter of each word, makes rest lowercase 
ec_category_subcategory_and_subsubcategory_display       Returns an HTML table of category, subcategory, and subsubcategory information 
ec_category_widget       displays all categories, subcategories, and subsubcategories, default is a list of all the items you want selected 
ec_choose_n_random       Get Random Choices. 
ec_column_type_widget       Column type widget 
ec_combocategory_widget       Category widget combining categories and subcategories 
ec_continue_shopping_options       returns continue shopping options 
ec_convert_path       @ return The pathname in the local filesystem of ImageMagick 
ec_country_name_from_country_code       Gets country name from country code. 
ec_country_widget       Just like country_widget, except it's not United States centric. 
ec_creditcard_authorization       Authorizes the credit card for use with an order. 
ec_creditcard_expire_1_widget       Gives the HTML for the Expiration Date Month select list. 
ec_creditcard_expire_2_widget       Gives the HTML for the Expiration Date Year select list. 
ec_creditcard_marking       Connect to the payment gateway to charge a previously authorized credit card for a transaction. 
ec_creditcard_precheck       Prechecks credit card numbers. 
ec_creditcard_return       Refunds a transaction back to the credit card used for that transaction. 
ec_creditcard_summary       Returns Credit Card info 
ec_creditcard_widget       Credit card selector 
ec_custom_product_field_form_element       Get Custom Form Element. 
ec_customer_comments       returns customer comments 
ec_customer_service_email_address       returns the customer server email address 
ec_customer_service_signature        
ec_customer_service_simple_issue       Creates an issue, interaction, and action and closes the issue. 
ec_data_directory        
ec_date_text       Returns a textual representation of the date. 
ec_date_widget       Generates a date widget. 
ec_date_widget_validate       Validates a date widget. 
ec_date_with_time_stripped       Removes the time part of the date stamp (useful when using util_AnsiDatetoPrettyDate) 
ec_datetime_sql       Generates a sql datetime expression from a date widget or a date widget and a time widget. 
ec_datetime_text       Generates a textual representation of the date and time. 
ec_decimal_to_percent       Converts decimal to percentage. 
ec_decode       This proc is modelled after the decode in sql. 
ec_delayed_credit_denied       Sends "Credit Denied" email to consumers whose authorization was initially inconclusive and then failed, and then saves the order for them (so that consumer can go back to site and retry the authorization). 
ec_determine_categorization_widget_defaults       given category_list, subcategory_list, and subsubcategory_list, this determines which options of the categorization widget should be selected by default (when editing a product) 
ec_display_as_html       Formats text as HTML 
ec_display_product_purchase_combinations       display product purchase combinations 
ec_display_rating       Given a product's rating, if the star gifs exist, it will print out the appropriate # (to the nearest half); otherwise it will just say what the rating is (to the nearest half). 
ec_elements_of_list_a_that_arent_in_list_b       Do a check and return list of a that are not in b 
ec_email_delayed_credit_denied       Use this to send out the \"Delayed Credit Denied\" email. 
ec_email_gift_certificate_order_failure       Use this to send out the \"Gift Certificate Order Failure\" email after it is determined that a previously inconclusive auth failed. 
ec_email_gift_certificate_recipient       Use this to send out the \"Gift Certificate Recipient\" email after it a purchased certificate is authorized. 
ec_email_new_gift_certificate_order       Use this to send out the \"New Gift Certificate Order\" email after a gift certificate order is authorized. 
ec_email_new_order       Use this to send out the \"New Order\" email. 
ec_email_order_shipped       Use this to send out the \"Order Shipped\" email after a shipment is made (full or partial order). 
ec_email_product_notification       This proc sends notifications for any products in the order that require it. 
ec_expire_old_carts       Expires old carts. 
ec_export_entire_form_as_url_vars_maybe       exports form as url variables 
ec_export_entire_form_except       Exports all but part of a form 
ec_first_element_of_list_a_that_isnt_in_list_b       Get First Element of A not in B 
ec_formatted_date       Format Ugly Date. 
ec_formatted_full_date       Format Ugly Date to Pretty Date. 
ec_formatted_price_shipping_gift_certificate_and_tax_in_an_order       returns formatted price 
ec_full_categorization_display       given a category_id, subcategory_id, and subsubcategory_id (can be null), displays the full categorization, e.g. 
ec_generate_random_string       Returns a random string 
ec_generic_html_form_select_widget       This is a generalization of all the other widgets we have that create HTML select lists. 
ec_get_user_session_id       Gets the user session from cookies 
ec_gets_char_delimited_line       Reads and parses a line of data from a character delimited file similar to ns_getscsv. 
ec_gift_certificate_expires_widget       Gives the HTML code for the select list from which customer service can change when a consumer's gift_certificate expires. 
ec_gift_certificate_status       Returns the status of the gift certificate for the customer 
ec_hidden_input       Returns a safe-for-browsers hidden variable, i.e. 
ec_id        
ec_info_used_widget       info used widget 
ec_insecure_context_bar_ws_and_index       Returns a Yahoo-style hierarchical navbar, starting with a link to / and possibly the workspace or /, depending on whether or not the user is logged in. 
ec_insecure_location        
ec_insecurelink       Allows you to create a relative link from a secure page to an insecure page 
ec_interaction_type_widget       interaction type widget 
ec_issue_type_widget       issue type widget 
ec_item_summary_for_admins       item summary for admins 
ec_item_summary_in_confirmed_order       item summary in confirmed order 
ec_items_for_fulfillment_or_return       produces an HTML form fragment for administrators to select from items that are fulfilled or received back 
ec_last_second_in_the_day       Returns the last second of the given day's date. 
ec_leading_nbsp       Adds leading nbsps to an integer to give it the desired number of digits 
ec_leading_zeros       Adds leading zeros to an integer to give it the desired number of digits. 
ec_linked_thumbnail_if_it_exists       This looks at dirname to see if the thumbnail is there and if so returns an html fragment that links to the bigger version of the picture (or to product.tcl if link_to_product_p is "t"). 
ec_location_based_on_zip_code       Get location 
ec_log_user_as_user_id_for_this_session       logs user as user id for this session 
ec_lowest_price_and_price_name_for_an_item       Returns the lowest price and price name for an item 
ec_mailing_list_link_for_a_product       Returns a link for the user to add him/herself to the mailing list for whatever category/subcategory/subsubcategory a product is in. 
ec_mailing_list_widget       shows mailing lists for categories, subcategories, subsub 
ec_makeinsecure       If the current url is secure, will redirect the user to the insecure version of this page. 
ec_makesecure       If the current page isn't secure, will ad_returnredirect the user to the https version of the page. 
ec_max       Returns a if a>=b or b if b>a 
ec_max_of_list       finds max value from a list of values 
ec_message_if_null       Give Null Message. 
ec_min       Returns b if a>=b or b if b>a 
ec_multiple_state_widget       Returns a state multiple selection box 
ec_na_if_null       Returns N/A if Null. 
ec_navbar       Returns ec nav bar. 
ec_nbsp_if_null       Return nonbreaking space. 
ec_only_category_widget       category widget 
ec_order_status       Returns the status of the order for the customer 
ec_order_summary_for_admin       returns order summary for admins 
ec_order_summary_for_customer       Shows item details to customers, as opposed to one for the admins. 
ec_package_maintainer       @ return email of ecommerce package maintainer 
ec_package_url_lookup        
ec_pageroot        
ec_percent_to_decimal       Converts percentage to decimal equiv. 
ec_preferred_drivers       Determine if we implement nssock or nsunix. 
ec_pretty_column_type       Get Pretty Column Type. 
ec_pretty_creditcard_type       Returns the credit card type based on the one-or-two-letter code for that type. 
ec_pretty_mailing_address_from_args       Get Pretty Mailing Address. 
ec_pretty_mailing_address_from_ec_addresses       Gets Pretty Mailing Address. 
ec_pretty_price       Returns a nicely formatted price. 
ec_price_line       Returns the price line 
ec_price_price_name_shipping_price_tax_shipping_tax_for_one_item       Returns price, price_name, shipping, price_tax, and shipping_tax (all in a list) for one item. 
ec_price_shipping_gift_certificate_and_tax_in_an_order       Returns a list containing the total price, total shipping, gift_certificate amount and total tax for an order. 
ec_product_directory        
ec_product_file_directory       Returns the directory that that the product files are located under the ecommerce product data directory. 
ec_product_link_if_exists       Returns product link (to ec_products url with link_label wrapped by anchor tag) of product id, or null if no url exists. 
ec_product_links_if_they_exist       return product links 
ec_product_name       Returns product name from product_id, memoized for efficiency 
ec_product_name_internal       returns product name 
ec_product_review_summary       Returns a one-line user-readable summary of a product review 
ec_product_url_if_exists       Returns product url of product id, or null if none exists 
ec_products__datasource        
ec_products__url        
ec_professional_reviews_if_they_exist       returns professional reviews 
ec_prune_product_purchase_combinations       Prune expired product purchase combinations. 
ec_rating_widget       ratings widget 
ec_reach_widget       reach widget 
ec_redirect_to_https_if_possible_and_necessary       redirects the current url to the appropriate https address 
ec_remove_creditcard_data       Remove credit card number from ec_creditcards if package parameter SaveCreditCardDataP = 0. 
ec_report_date_range_widget       report date range widget 
ec_report_get_start_date_and_end_date       Gets the start and end date when the dates are supplied by ec_report_date_range_widget; if they're not supplied, it makes the first of this month be the start date and today be the end date. 
ec_same_value       Returns true if values are essentially the same for monetary purposes, otherwise returns false. 
ec_savings       Returns savings over Retail price 
ec_search_widget       Creates an ecommerce search widget, using the specified category id and search text if necessary 
ec_secure_location        
ec_securelink       Allows you to create a relative link to a secure page 
ec_send_unsent_gift_certificate_recipient_email       Finds authorized gift certificates for which email has not been sent to the recipient, sends the email, and records that it has been sent. 
ec_send_unsent_new_gift_certificate_order_email       Finds authorized gift certificates for which confirmation email has not been sent, sends the email, and records that it has been sent. 
ec_send_unsent_new_order_email       Finds authorized orders for which confirmation email has not been sent, sends the email, and records that it has been sent. 
ec_sendmail_from_service       Use this when you're sending out customer service emails. 
ec_shipment_summary_sub       Says how the items with a given product_id, color, size, style, price_charged, and price_name in a given order shipped; the reason we put in all these parameters is that item summaries group items in this manner 
ec_shipping_cost_summary       returns cost summary 
ec_shipping_price_for_one_item       returns the shipping price for one item 
ec_shipping_prices_for_one_item_by_rate       returns the shipping prices for one item based on rate parameters, no db queries 
ec_space_to_nbsp       converts space to html nbsp 
ec_ssl_available_p       Returns 1 if this AOLserver has either the nsssl module or nsopenssl module installed. 
ec_state_name_from_usps_abbrev       Takes a USPS abbrevation and returns the full state name, e.g., MA in yields Massachusetts out 
ec_state_widget       Returns a state selection bar, based on state_widget 
ec_stock_status_widget       returns stock status 
ec_subcategory_widget       subcategory widget 
ec_subcategory_with_subsubcategories_widget       returns subcategories with subcategories 
ec_sweep_for_payment_zombie_gift_certificates       Looks for confirmed gift certificates that aren't either failed or authorized, i.e., where we didn't hear back from the payment cron job to dig up confirmed but not failed or authorized gift certificates over 15 minutes old ("zombies"). 
ec_sweep_for_payment_zombies       Cron job to dig up confirmed orders over 15 minutes old ("zombies") that did not fail and haven't been authorized . 
ec_system_name        
ec_system_owner        
ec_template_widget       gives a drop-down list and, if category_id_list is specified, it will display the templates associated with those categories (if any) first 
ec_thumbnail_if_it_exists       This looks at dirname to see if the thumbnail is there and if so returns an html fragment to show thumbnail Otherwise it returns the empty string. 
ec_time_text       Returns a textual representation of the time. 
ec_time_widget       Generates a time widget. 
ec_time_widget_validate       Validates time widget input. 
ec_timeentrywidget       Gives a HTML form input for a time. 
ec_timeentrywidget_time_check       Checks to make sure that the time part of the timestamp is in the correct format: HH12:MI:SS. 
ec_unauthorized_transactions       Ec_unauthorized_transactions searches for unauthorized transactions whose to_be_captured_date is over 1/2 hr old and authorized_date is null this is similar to ec_sweep_for_payment_zombies except that in this case these are shipments that are unauthorized. 
ec_unmarked_transactions       unmarked transactions to_be_captured_p is 't' and authorized_date is not null and marked_date is null 
ec_unrefunded_transactions       Unrefunded transactions. 
ec_update_state_to_authorized       If a credit card authorization occurs, the following actions need to be taken: 1. 
ec_update_state_to_confirmed       If an order is confirmed, the following actions need to be taken: 1. 
ec_update_state_to_in_basket       If a credit card failure occurs, the following actions need to be taken: 1. 
ec_url        
ec_user_audit_info       Returns User ID, IP Address, and date for audit trails 
ec_user_class_display       Displays a comma seperated list of the users user classes with a comment on its approval status if approval is required. 
ec_user_class_select_widget       Returns a HTML multiple select list for user_class_id with an option for each user class. 
ec_user_class_widget       user class select 
ec_user_identification_summary       Get user Info 
ec_user_session_logout        
ec_zero_if_null       Returns Zero if Null. 
ecommerce_user_contributions       Returns list items, one for each classified posting 
froogle::upload       Upload active products to a Froogle Ftp server. 
qmail       procedure for sending mail by directly injecting it into the qmail system. 

SQL Files

sql/postgresql/ec-product-package-create.sql        
sql/postgresql/ec-product-package-drop.sql        
sql/postgresql/ec-product-sc-create.sql        
sql/postgresql/ec-product-sc-drop.sql        
sql/postgresql/ec-product-sws-drop.sql        
sql/postgresql/ec-product-sws-setup.sql        
sql/postgresql/ecommerce-create.sql        
sql/postgresql/ecommerce-defaults.sql        
sql/postgresql/ecommerce-drop.sql        
sql/postgresql/pl-sql-utilities-drop.sql        
sql/postgresql/pl-sql-utilities.sql        

Content Pages

www/
      account.adp
      account.tcl
      address-2.tcl
      address-international-2.tcl
      address-international.adp
      address-international.tcl
      address.adp
      address.tcl
     admin/
           audit-one-id.tcl Displays the audit info for one id in the id_column of a table and its audit history.
           audit-table.tcl Returns the audit trails of a table and its audit table for entry that exists between the start date and end date.
           audit-tables.tcl Gives the user a list of tables to audit.
           audit.tcl Displays the audit info for one id in the id_column of a table and its audit history.
          cat/
                category-add-0.tcl
                category-add-2.tcl
                category-add.tcl
                category-delete-2.tcl Deletes ecommerce product category.
                category-delete.tcl
                category-edit.tcl
                category-swap.tcl Switches the ordering of a category with that of the next category.
                category.tcl Displays properties of one ec category.
                index.tcl
                subcategory-add-0.tcl
                subcategory-add-2.tcl Inserts the subcategory.
                subcategory-add.tcl Confirmation page for adding a new subcategory.
                subcategory-delete-2.tcl Deletes an ecommerce product subcategory.
                subcategory-delete.tcl Confirmation page for deleting an ecommerce product subcategory.
                subcategory-edit.tcl Updates name od ecommerce product subcategory.
                subcategory-swap.tcl Swaps two adjacent subcategories of common category.
                subcategory.tcl
                subsubcategory-add-0.tcl
                subsubcategory-add-2.tcl Actually created subsubcategory of given subcategory.
                subsubcategory-add.tcl Confirmation page for creatin new ecommerce product subsubcategory.
                subsubcategory-delete-2.tcl Deletes ecommerce product subsubcategory.
                subsubcategory-delete.tcl Confirmation page for deleting an ecommerce product subsubcategory.
                subsubcategory-edit.tcl Modifies name of ecommerce product subsubcategory.
                subsubcategory-swap.tcl Swaps ordering of two adjacent subsubcategories of the same subcategory.
                subsubcategory.tcl Displays properties of given ecommerce product subsubcategory.
          customer-reviews/
                approval-change.tcl
                index-2.tcl
                index.tcl
                one.tcl
          customer-service/
                actions.tcl
                active-toggle.tcl
                canned-response-add-2.tcl
                canned-response-add.tcl
                canned-response-delete-2.tcl
                canned-response-delete.tcl
                canned-response-edit-2.tcl
                canned-response-edit.tcl
                canned-responses.tcl
                customer-history.tcl
                customer-search.tcl
                email-send-2.tcl
                email-send.tcl
                gift-certificate-add-2.tcl
                gift-certificate-add.tcl
                gift-certificate-edit.tcl
                gift-certificate-void-2.tcl
                gift-certificate-void.tcl
                gift-certificates.tcl
                index.tcl
                interaction-add-2.tcl
                interaction-add-3.tcl
                interaction-add.tcl
                interaction-summary.tcl
                interaction.tcl
                interactions.tcl
                issue-edit-2.tcl
                issue-edit.tcl
                issue-open-or-close-2.tcl
                issue-open-or-close.tcl
                issue.tcl
                issues.tcl
                picklist-item-add-2.tcl
                picklist-item-add.tcl
                picklist-item-delete-2.tcl
                picklist-item-delete.tcl
                picklist-item-swap.tcl
                picklist-row-delete.tcl
                picklist-value-add.tcl
                picklists.tcl To add a new picklist, just add an element to picklist_list; all UI changes on this page will be taken care of automatically
                spam-2.tcl
                spam-3.tcl
                spam-log.tcl
                spam.tcl
                statistics.tcl
                user-identification-edit.tcl
                user-identification-match-2.tcl
                user-identification-match.tcl
                user-identification-search.tcl
                user-identification.tcl
          email-templates/
                add-2.tcl
                add.tcl
                edit-2.tcl
                edit.tcl
                index.tcl
                variables.tcl
           index.tcl Ecommerce administration index page.
          mailing-lists/
                index.tcl
                member-add-2.tcl
                member-add.tcl
                member-remove-2.tcl
                member-remove.tcl
                one.tcl
          orders/
                address-add-2.tcl Confirm shipping address.
                address-add-3.tcl Insert the address.
                address-add.tcl New shipping address.
                by-order-state-and-time.tcl View orders by order state and order time.
                by-state-and-time.tcl View basket activity by order state and in-basket time.
                comments-edit.tcl Update the comments field of ec_orders.
                comments.tcl Add and edit comments for an order.
                creditcard-add-2.tcl Credit card confirm.
                creditcard-add-3.tcl
                creditcard-add.tcl Add a creditcard.
                fulfill-2.tcl This script shows confirmation page & shipping address.
                fulfill-3.tcl
                fulfill.tcl Fulfill an order.
                fulfillment-items-needed.tcl Items needed for fulfillment.
                fulfillment.tcl Order fulfillment page.
                gift-certificate-void-2.tcl Do the work for voiding a gift certificate.
                gift-certificate-void.tcl Void a gift certificate.
                gift-certificate.tcl Gift certificate page.
                gift-certificates-issued.tcl View gift certificates issued.
                gift-certificates.tcl View gift certificates.
                index.tcl The main page for the orders section of the ecommerce admin pages.
                items-add-2.tcl
                items-add-3.tcl Add items, Cont.
                items-add-4.tcl Actually add the items.
                items-add.tcl Add an item to an order.
                items-return-2.tcl
                items-return-3.tcl
                items-return-4.tcl This script does the following: 1.
                items-return.tcl Return items.
                items-void-2.tcl Void items.
                items-void.tcl
                one.tcl Display one order.
                refunds.tcl View refunds.
                revenue.tcl Financial reports.
                search.tcl Order search page.
                shipments.tcl
                track.tcl Track a shipment.
                void-2.tcl
                void.tcl
          problems/
                index.tcl This page dislpays the problems in the problem log, if display_all is not set then only unresolved problems are displayed.
                resolve-2.tcl This page confirms that a problems in the problem log is resolved.
                resolve.tcl This page confirms that a problems in the problem log is resolved
          products/
                add-2.tcl Add a product.
                add-3.tcl Add a product.
                add-4.tcl
                add.tcl Add a product.
                by-category.tcl List the product categories and summary data for each (how many products, how many sales).
                categories-upload-2.tcl Upload product category mappings.
                categories-upload-by-id-2.tcl Upload product category mappings.
                categories-upload-by-id.tcl This page uploads a data file containing product categories mapped to products.
                categories-upload.tcl This page uploads a CSV file containing product category "hints" and creates product category mappings.
                custom-field-add-2.tcl Add a custom product field.
                custom-field-add-3.tcl Add a custom product field.
                custom-field-add.tcl Add a custom product field.
                custom-field-edit-2.tcl
                custom-field-edit.tcl Edit a custom product field.
                custom-field-status-change.tcl
                custom-field.tcl
                custom-fields.tcl Admin page for custom product fields.
                delete-2.tcl Delete a product.
                delete.tcl Product delete confirm.
                edit-2.tcl Edit a product.
                edit-3.tcl Edit a product.
                edit.tcl Form for the user to edit the main fields in the ec_product table plus custom fields.
                extras-upload-2.tcl This file updates ec_custom_product_field_values (as opposed to inserting new rows) because custom-field-add*.tcl (which are to be run before extras-upload*.tcl) insert rows into ec_custom_product_field_values (with everything empty except product_id and the audit columns) when they insert the rows into ec_products (for consistency with add*.tcl).
                extras-upload.tcl This page uploads a CSV file containing client-specific product information into the catalog.
                import-images-2.tcl
                import-images.tcl This page uploads a data file containing store-specific product references and new product images pathnames for bulk importing images and thumbnails into ecommerce.
                index.tcl The main admin page for products.
                link-add-2.tcl Link a product.
                link-add-3.tcl
                link-add.tcl
                link-delete-2.tcl Delete a product link.
                link-delete.tcl
                link.tcl Lets admin maintain links among products (e.g., "you should also think about buying X if you're buying Y")
                list.tcl Lists a class of products, ordered to the user's taste.
                offer-add-2.tcl Add an offer.
                offer-add.tcl Add an offer.
                offer-delete-2.tcl Delete an offer.
                offer-delete.tcl Delete or undelete an offer.
                offer-edit-2.tcl Edit an offer.
                offer-edit-3.tcl Edit an offer.
                offer-edit.tcl Edit an offer.
                offers.tcl
                one-subcategory.tcl
                one-subsubcategory.tcl
                one.tcl Main admin page for a single product.
                recommendation-add-2.tcl Recommend a product.
                recommendation-add-3.tcl Recommend a product.
                recommendation-add-4.tcl Recommend a product.
                recommendation-add.tcl Search for a product to recommend.
                recommendation-delete-2.tcl Actually deletes the row.
                recommendation-delete.tcl Confirmation page, takes no action.
                recommendation-text-edit-2.tcl Actually updates the row.
                recommendation-text-edit.tcl Entry form to let user edit the HTML text of a recommendation.
                recommendation.tcl Display one recommendation.
                recommendations.tcl Product recomendations.
                review-add-2.tcl Submit a review.
                review-add.tcl Review confirmation page.
                review-edit.tcl Edit a review.
                review.tcl
                reviews.tcl Summarize professional reviews of one product and let site owner add a new review.
                sale-price-add-2.tcl
                sale-price-add.tcl Add a sale price.
                sale-price-edit-2.tcl Update a sale price.
                sale-price-edit-3.tcl Update a sale price.
                sale-price-edit.tcl Edit a sale price.
                sale-price-expire-2.tcl Expire a sale.
                sale-price-expire.tcl Confirm sale expire.
                sale-prices.tcl Let's site admin define a special time-limited price for an item.
                search.tcl Search for a product based on name or sku.
                subsubcategory-property-toggle.tcl
                supporting-file-delete-2.tcl Delete a file.
                supporting-file-delete.tcl Confirm delete of a file.
                supporting-files-upload-2.tcl Upload a file.
                supporting-files-upload.tcl Supporting files upload.
                toggle-active-p.tcl
                toggle-no-shipping-avail-p.tcl
                upload-2.tcl
                upload-utilities.tcl Upload utilites admin page.
                upload.tcl This page uploads a data file containing store-specific products into the catalog.
           restore-one-id.tcl Tries to restore from the audit table to the main table for one id in the id_column.
          retailers/
                add-2.tcl This page confirms that the information of new retailer.
                add-3.tcl This page inserts the new retailer's info into database.
                add.tcl
                edit-2.tcl
                edit.tcl
                index.tcl This page displays current retailers
                one.tcl
          sales-tax/
                clear-2.tcl
                clear.tcl
                edit-2.tcl
                edit.tcl
                index.tcl
          shipping-costs/
                edit-2.tcl
                edit.tcl
                examples.tcl
                index.tcl
          tools/
                form-custom.tcl
                sort-custom.tcl
                spell.tcl
                spelling-dictionary-add-to.tcl
                table-custom.tcl
                webspell
          user-classes/
                add-2.tcl
                add.tcl
                approve-toggle.tcl
                delete-2.tcl
                delete.tcl
                edit.tcl
                index.tcl
                member-add-2.tcl
                member-add.tcl
                member-delete-2.tcl
                member-delete.tcl
                members.tcl
                one.tcl
      billing.adp
      billing.tcl Present the available billing addresses of the visitor.
      browse-categories.adp
      browse-categories.tcl Present a list of top level product categories to browse.
      category-browse-subcategory.adp
      category-browse-subcategory.tcl This one file is used to browse not only categories, but also subcategories and subsubcategories.
      category-browse-subsubcategory.adp
      category-browse-subsubcategory.tcl This one file is used to browse not only categories, but also subcategories and subsubcategories.
      category-browse.adp
      category-browse.tcl This one file is used to browse not only categories, but also subcategories and subsubcategories.
      checkout-2.adp
      checkout-2.tcl
      checkout-3.adp
      checkout-3.tcl Users should get here from process-order-quantity-payment-shipping.tcl; this page just summarizes their order before they submit it.
      checkout-one-form-2.tcl
      checkout-one-form.adp
      checkout-one-form.tcl This generates a custom single order fulfillment page with options to interface with the sophisticated multi address fulfillment processing, when enough address history exists to make it worthwhile Essentially combines /ecommerce/www/checkout* address* select-shipping* billing* payment*
      checkout-progress.adp
      checkout-progress.tcl
      checkout.adp
      checkout.tcl
      contextbar.adp
      contextbar.tcl
      credit-card-correction-2.tcl 1.
      credit-card-correction.adp
      credit-card-correction.tcl Gives them a chance to correct the information for a credit card that the payment gateway rejected.
      default-master.adp
      default-master.tcl
      delete-address.tcl Set the ecommerce address with ID address_id to deleted so that it will no longer be available.
      finalize-order.tcl This script will: (1) put this order into the 'confirmed' state (2) try to authorize the user's credit card info and either (a) redirect them to a thank you page, or (b) redirect them to a "please fix your credit card info" page
      gift-certificate-billing.adp
      gift-certificate-billing.tcl Present the available billing addresses of the visitor.
      gift-certificate-claim-2.adp
      gift-certificate-claim-2.tcl
      gift-certificate-claim.adp
      gift-certificate-claim.tcl
      gift-certificate-finalize-order.adp
      gift-certificate-finalize-order.tcl this script will: (1) put this order into the 'confirmed' state (2) try to authorize the user's credit card info and either (a) redirect them to a thank you page, or (b) redirect them to a "please fix your credit card info" page If they reload, we don't have to worry about the credit card authorization code being executed twice because the order has already been moved to the 'confirmed' state, which means that they will be redirected out of this page.
      gift-certificate-order-2.adp
      gift-certificate-order-2.tcl Asks for gift certificate info like message, amount, recipient_email
      gift-certificate-order-3.adp
      gift-certificate-order-3.tcl Asks for payment info.
      gift-certificate-order-4.adp
      gift-certificate-order-4.tcl Dispays order summary
      gift-certificate-order.adp
      gift-certificate-order.tcl describes gift certificates and presents a link to order a gift certificate
      gift-certificate-thank-you.adp
      gift-certificate-thank-you.tcl The user is redirected to this page from gift-certificate-finalize-order.tcl if their gift certificate order has succeeded.
      gift-certificate.adp
      gift-certificate.tcl
      index.adp
      index.tcl Entry page to the ecommerce store.
      mailing-list-add-2.adp
      mailing-list-add-2.tcl Add the visitor to the selected mailing list.
      mailing-list-add.adp
      mailing-list-add.tcl This page either redirects them to log on or asks them to confirm that they are who we think they are.
      mailing-list-remove.adp
      mailing-list-remove.tcl
      order.adp
      order.tcl Displays an order for the user
      payment.adp
      payment.tcl This script has to check whether the user has a gift_certificate that can cover the cost of the order and, if not, present credit card form
      process-order-quantity-shipping.tcl Updates quantities, sets the shipping method, and finalizes the prices (inserts them into ec_items)
      process-payment.tcl Begins processing a payment from a customer, using either a credit card on file or a card they entered in payment.tcl (which is the only way to get to this script).
     product-file/
           index.vuh Return a product image
      product-search.adp
      product-search.tcl
      product.adp
      product.tcl Display a single product and possibly comments on that product or professional reviews
      review-submit-2.adp
      review-submit-2.tcl
      review-submit-3.adp
      review-submit-3.tcl
      review-submit.adp
      review-submit.tcl
      select-shipping.adp
      select-shipping.tcl
      shopping-cart-add.tcl This adds an item to an 'in_basket' order, although if there exists a 'confirmed' order for this user_session_id, the user is told they have to wait because 'confirmed' orders can potentially become 'in_basket' orders (if authorization fails), and we can only have one 'in_basket' order for this user_session_id at a time.
      shopping-cart-delete-from.tcl
      shopping-cart-quantities-change.tcl Changes the quantity of an item in an order.
      shopping-cart-retrieve-2.adp
      shopping-cart-retrieve-2.tcl
      shopping-cart-retrieve-3.adp
      shopping-cart-retrieve-3.tcl
      shopping-cart-retrieve.adp
      shopping-cart-retrieve.tcl This page either redirects them to log on or asks them to confirm that they are who we think they are.
      shopping-cart-save-2.adp
      shopping-cart-save-2.tcl
      shopping-cart-save.adp
      shopping-cart-save.tcl This page either redirects them to log on or asks them to confirm that they are who we think they are.
      shopping-cart.adp
      shopping-cart.tcl
      thank-you.adp
      thank-you.tcl
      toolbar.adp
      toolbar.tcl
      track.adp
      track.tcl
      update-user-classes-2.tcl
      update-user-classes.adp
      update-user-classes.tcl
  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

E-08907 Hospitalet de Llobregat (Barcelona)

 Tel Europe: +34 932 202 088
 Tel US: +1 415 429 5995
 Mail: info@project-open.com