How to edit the text on the product_info.php page

You need to edit the file:- catalog/includes/languages/english/product_info.php.

Make general changes to the text sent to a customer on osCommerce Store registration.

When a customer registers at your store they receive an email giving them generic information about the function of the store they have just registered with.

This language can be altered by editing the catalog/includes/languages/english/create_account.php file.

Fix – How to have PayPal Order shown in Admin side.

When a costumer makes a PAYPAL payment there is no order logged in the admin area of oscommerce.

Step 1: open paypal.php in your /includes/modules/payment/
Step 2: Add

tep_draw_hidden_field(”rm”,2) .

Just before
tep_draw_hidden_field(’cancel_return’, tep_href_link(FILENAME_CHECKOUT_PAYMENT, ”, ‘SSL’));

around line 96

Order will now show in admin side.

How to recover missing order info from osCommerce DB.

You get an email from PayPal saying that you have received a payment, but you don’t get an email from osCommerce, and it doesn’t show up as an order in your osCommerce admin section.

When a customer selects to pay via PayPal, osCommerce sends the customer to PayPal’s site, and your own osCommerce site has no way of knowing the status of the transaction until the payment is completed and PayPal sends the customer back to your site. When PayPal redirects the customer back to your site, it passes a number of values back to your site so that osCommerce can tell that the payment has been completed.

This problem occurs when the customer completes the payment on PayPal, but doesn’t let PayPal forward them back to your site. This could occur for several reasons. Probably most often because the customer closes the window, or goes somewhere else before their browser is redirected back to your site. Whatever the case, if the browser doesn’t go back to your site, then osCommerce does not know that the transaction was completed and therefore doesn’t send you and email or mark it as complete.

Fortunately, osCommerce does keep track of what was in the customer’s cart. So it is usually possible to retrieve the contents of their cart directly from the database. Note that this may not always be possible as the customer may have gone back to your site and added something different to their cart.

Find the customer_id
The first thing you will need to know is the customer’s ID. You can find this by logging into your osCommerce admin section, then click the "customers" button on the left side and find the customer that made the purchase. When you find the customer, click on their name, then look at the URL that you are currently on. Find the cID= in the URL and the number after the equals sign is the customer ID.

Find the contents
Now that you have the customer ID, you can use it to run a database query and retrieve the content’s of that members cart you can log into phpMyAdmin using the instructions provided when your account set up. Please contact us if you need this information re-sent to you. Once inside of phpMyAdmin, click on your database name on the left pane, then click the "SQL" tab at the top. Run the following SQL and substitue the customer’s id for <PUT CUSTOMERS_ID HERE>

SELECT products_description.products_name,
customers_basket.customers_basket_quantity
FROM customers_basket, products_description
WHERE customers_basket.customers_id = ‘<PUT CUSTOMERS_ID HERE>’
AND customers_basket.products_id = products_description.products_id
AND products_description.language_id = ‘1′

Click Go and voila you have your order details.