<pre>200809
    Notes
        products.products_price = Suggested Selling Price (For Member) or Price (Normal For Customer)
        products.products_cost =  Member Purchase Price
        products.products_shipping (This field is not used)
        customers.customers_is_member = (New Field) Customer Type (Member = 1, Customer = 0, Default = NULL) Use function in general.php to check type.

    Data Restructure

        1. Add Display Member Price in Administrator > Configuration > Product Listing

            INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Member Price', 'PRODUCT_LIST_COST', '3', 'Do you want to display the Product Member Price', '8', '5', now());

        2. Add Customer Type column
            
            ALTER TABLE `customers` ADD COLUMN `customers_is_member` CHAR(1) DEFAULT NULL;

    Modified Sources

    /admin/includes/languages/english/categories.php    // modby: Terry, 200809, Drop Shipping, add field products_cost (if action=update_products)
    /admin/includes/languages/english/specials.php      // modby: Terry, 200809, Drop Shipping, show member price in browse, insert and edit mode
    /admin/includes/languages/english/customers.php.php // modby: Terry, 200809, Drop Shipping, add field is_member
    /admin/includes/languages/english.php               // modby: Terry, 200809, Drop Shipping, add field is_member
    /admin/categories.php                               // modby: Terry, 200809, Drop Shipping, add field products_cost (if action=update_products)
    /admin/customers.php                                // modby: Terry, 200809, Drop Shipping, add field customers_is_member
    /admin/specials.php                                 // modby: Terry, 200809, Drop Shipping, show member price in browse, insert and edit mode
    /includes/boxes/specials.php                        // modby: Terry, 200809, Fix Side Box Image Width
    /includes/boxes/whats_new.php                       // modby: Terry, 200809, Fix Side Box Image Width
    /includes/boxes/best_sellers.php                    // modby: Terry, 200809, Fix Side Box Image Width
    /includes/classes/currencies.php                    // modby: Terry, 200809, Drop Shipping, add display_profit()
    /includes/classes/shopping_cart.php                 // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
    /includes/modules/default_specials.php              // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
                                                        // modby: Terry, 200809, Fix: strip_tags() and increase substr length
                                                        // modby: Terry, 200809, Drop Shipping, add field products_costs
    /includes/modules/new_products.php                  // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
                                                        // modby: Terry, 200809, Fix: strip_tags() and increase substr length
                                                        // modby: Terry, 200809, Drop Shipping, add field products_costs
    /includes/modules/best_sellers_mod.php              // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
                                                        // modby: Terry, 200809, Fix: strip_tags() and increase substr length
                                                        // modby: Terry, 200809, Drop Shipping, add field products_costs
    /includes/modules/product_listing.php               // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
    /includes/functions/html_output.php                 // modby: Terry, 200809, Drop Shipping, add field is_member
    /includes/functions/general.php                     // modby: Terry, 200809, Drop Shipping, add tep_get_customer_account_type()
                                                        // modby: Terry, 200809, Drop Shipping, add tep_get_customers_is_enabled()
    /includes/languages/english.php                     // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
    /includes/languages/english/index.php               // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
    /includes/form_check.js.php                         // modby: Terry, 200809, Drop Shipping, add field is_member
    products_new.php                                    // modby: Terry, 200809, Drop Shipping, add field products_costs
                                                        // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
    specials.php                                        // modby: Terry, 200809, Drop Shipping, add field products_costs
                                                        // modby: Terry, 200809, Fix: strip_tags() and increase substr length
                                                        // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices
    stylesheet.css                                      /* modby: Terry, 200809, Fix: font sizes affects the layout */
    style.css                                           /* modby: Terry, 200809, Fix: font sizes affects the layout */
    index.php                                           // modby: Terry, 200809, Drop Shipping, add condition to show customer/member prices

</pre>