OSCommerce MS2.2 Paypal Issue Resolution Sought

Cancelled Posted May 8, 2006 Paid on delivery
Cancelled 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

PHP

Project ID: #59931

About the project

5 proposals Remote project Active May 9, 2006

5 freelancers are bidding on average $84 for this job

encodedart

Please view PMB for detail. Thanks. EncodedArt Inc - A solution Canadian provider company.

$100 USD in 2 days
(49 Reviews)
7.2
webdoers

We're the team of enthusiastic and technically conscious highly qualified engineers, with core software industry experience. Our team have 25 man-years experience. They are serving the key position in their respective More

$100 USD in 7 days
(9 Reviews)
4.5
infosys

Please check PMB

$30 USD in 2 days
(0 Reviews)
0.0