OSCommerce MS2.2 Paypal Issue Resolution Sought
$30-100 USD
Paid on delivery
Current Situation:
I am dealing with a problem with OSC MS2.2 and Paypal. I installed the following contribs to address a well documented issue
with Paypal:
- osCommerce-PayPal_IPN-v1.1
- Held_Orders_v2.0_2
- Held Orders Fix
- Held Orders UserAbandons Order
Source: [url removed, login to view],3819
Afer installing the above contribs, I placed Paypal in "Test" mode and installed the COD payment module to perform testing.
Results:
- All product and product attribute data successfully posted to
datatables
- Generated an email to the customer (me)
- Generated an email to the store owner (me)
- I thought life was good....but
- When changed from "Test" to "Live" with Paypal, everything went
perfect except the following:
1. None of the product details/attribute values were listed on the
order receipt
2. It looks like all product attributes from the drop-down boxes
are present in the DB, but none of the data input into
the "text field" or "textarea" fields are recording to the DB.
NOTE: Attached you will find the following two text files:
1. COD Order Notification - [url removed, login to view]
2. Paypal Order Notification - [url removed, login to view]
Please take note of the differences in data below the word
"Products". I list the data elements missing on the second
document titled "Paypal Order Notification - Example".
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Operating Environment:
- osCommerce 2.2-MS2
- Linux 2.6.16-CentOS-4.3 (Hosted)
- MySQL 4.1.19-standard (Hosted)
- Apache/[url removed, login to view] (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2
mod_bwlimited/1.4 PHP/4.4.2 FrontPage/[url removed, login to view]
mod_ssl/[url removed, login to view] OpenSSL/[url removed, login to view]
- PHP Version: 4.4.2 (Zend: 1.3.0)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Other Contributions Currently Installed:
- WYSIWYG Editor [url removed, login to view]
- Option Type Feature [url removed, login to view] within OSC MS2.2
- SEO Assistant V 1.3.3_full package
- [url removed, login to view]
- Ask a Product Question 2.3
- Banner-ad-in-a-box V1.1 by Aubrey Kilian (currently disabled)
- Banner Ads in Header (currently disabled)
- FroogleDataFeeder_v162d
- Google position 1.3 (04-29-2006)
- How Did You Hear About Us 1.4
- Links_Manager_for_OSC_v2.0
- newsdesk_v_1.48.3-updated
- osCommerce Account Agreement Checkbox
- pickup_1.05_1_2
- RSS Feed 0.1
- Skype Contact v1.0
- Spider Session Remover_v1.0
- Automatic Notify Admin Via E-mail Of New Account v1.0.5
- Making PayPal Return Order Data
- Store Offline
- Add Subject Line to Contact Us Page
- Automatic Notify Admin Via E-mail Of New Account v1.0.5
- close popup window_v1.1
- catalog products with images 1.6.1.2
- I also have many hand-coded customizations for links to customer
support contact methods.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Additional Project Tasks:
1. Modify the invoice, packing slip, and "thank you" email sent after
an order is received to contain:
Customer Information:
- Order Date
- Invoice Number
- Customer Number
- First & Last Name
- Street Address
- City, State & Zip Code
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The scope of this project has changed a little:
I discovered the attributes do make their way onto the customer invoice, but NOT UNTIL I go into the "Orders Held" area within the Admin console, click "Edit" then change the "Status" from "Processing" to "Pending, Delivered, or Preparing [Paypal IPN]".
Another issue I discovered was that customers MUST click on "Return to Merchant" after submitting payment through Paypal in order for all the details of the order to be recorded to my store DB. I NEED TO KNOW, EXPLICITLY, IF THERE IS A SOLUTION TO ELIMINATE THIS STEP?
I also discovered our store sends an abbreviated invoice witout attributes/details, but not a detailed invoice containing attributes/details until after a customer presses the "RETURN TO MERCHANT" button. I would like to have our store provide a detailed invoice containing each and every detail of an order (including all attributes) the moment they click on "Send Payment" from within Paypal. I ALSO NEED TO KNOW IF THERE IS A SOLUTION TO SATISFY THIS NEED?
Lastly, the "Products" section of our detailed invoice should look like this:
1 x Candi () = $0.05
Bead Selection: Pearls
Bracelet Size: 7.00 (adult small)
Charm Selection 1: None
Charm Selection 2: None
Gift Options: None
Personalized Name: Mary
Students Birth Months: January, May, August
Teacher Birth Month: January
Toggle Clasp: None
vs.
1 x Candi () = $0.05
Bead Selection Pearls
Bracelet Size 7.00 (adult small)
Charm Selection 1 None
Charm Selection 2 None
Gift Options
Test 5a
Test 5b
Teacher Birth Month January
Toggle Clasp None
Please let me know if you can accomodate these requirements.
Thank you
Project ID: #59931
About the project
5 freelancers are bidding on average $84 for this job
Please view PMB for detail. Thanks. EncodedArt Inc - A solution Canadian provider company.