[stitch1z]

[01/17/2012 10:38 PM] – Status : Unresolved DL file path = (correct file path URL)

[01/17/2012 10:38 PM] – Status : Resolved DL file path = (correct file path URL)

[01/17/2012 10:38 PM] – Advisory : No DL file path conversion performed on URL.

[01/17/2012 10:38 PM] – Status : Dispatching DL method = 1

I replaced my actual file path with “(correct file path URL)”. I tested both that go directly to the file and they work.

Yes, the downloadable files are hosted at Amazon AWS.

I am using E-store v 5.7.8 with wordpress 3.2.1

[stitch1z]

I should specify that it is checked to “on”.

[stitch1z]

By the way, this only happens on downloads, not PPV content links.

And yes, I have Downloadable checked off…

[stitch1z]

I got it figured out. Thank you for all of your help. Again. lol

[stitch1z]

Strange. Still not sending the description to the sales table.

To be clear I am altering paypal.php and eStore_post_payment_processing_helper.php so it will send the information to the sales table so the description and name will show up in the sales table when someone makes a purchase, initiating an update.

The name is sending, I’ve gotten it that far.

The code you just gave me didn’t pull the description either. I don’t know why, though…

Any other ideas?

Thank you again! You are very helpful!

[stitch1z]

Nope that’s not doing it. Any suggestions?

[stitch1z]

Would this work?

$product_description = $wpdb->get_row(“SELECT description FROM $products_table_name WHERE id = ‘$cart_item_number'”, OBJECT);

[stitch1z]

Long story short, I am getting an error when I try to query both tables. I’m doing it right, but I think there is a bug in some of the script I am using to display everything. This is why I had to go this route in the first place.

If you could possibly tell me how to tell estore to put the product description in the sales table upon each sale, I would be very grateful.

Thank you again!

[stitch1z]

Okay, I am almost there…

$product_name = $wpdb->escape(stripslashes($cart_item_data_name));

$sale_price = $current_cart_item;

$updatedb = "INSERT INTO $customer_table_name (first_name, last_name, email_address, purchased_product_id,txn_id,date,sale_amount,coupon_code_used,member_username,product_name,address,phone,subscr_id,purchase_qty,ipaddress,status) VALUES ('$firstname', '$lastname','$emailaddress','$current_product_id','$transaction_id','$clientdate','$sale_price','$coupon_code_used','$eMember_username','$product_name','$address','$phone','$subscr_id','$cart_item_qty','$customer_ip','$status')";

$results = $wpdb->query($updatedb);

$updatedb2 = "INSERT INTO $sales_table_name (cust_email, date, time, item_id, sale_price, name, description) VALUES ('$emailaddress','$clientdate','$clienttime','$current_product_id','$sale_price','$product_name','$product_description')";

$results = $wpdb->query($updatedb2);

Okay, I have the product name updating in my sales table now. ALL I need from you now is to tell me how to set “$product_description” to deliver the description of a product.

Like:

$product_name = $wpdb->escape(stripslashes($cart_item_data_name));

Thank you again!

[stitch1z]

My logic was all wrong….

Better yet (and probably much simpler), how do I tell WP-Estore to update the wp_eStore_sales_tbl with the same “name” and “description” fields that are used in wp_eStore_tbl. That would have me set for my sales reports.

Thank you again for being so helpful.

[stitch1z]

Disappointing, but okay… Any examples / suggestions of what I should look into instead?

[stitch1z]

Awesome. Thank you!

[stitch1z]

Okay, my Paypal is verified and sending me the link when I test it out. The shortcode on my thank you page is still not doing anything when after payment.

I have an updated version (I downloaded just days ago) of the plugin and all of my other shortcodes work fine.

Any idea what might be going on here?

Again, the link is here:

http://scenedealer.com/thank-you-for-your-patronage/

[stitch1z]

[08/06/2011 4:39 AM] – Advisory : Log file reset.

---

[08/06/2011 4:40 AM] – SUCCESS :Paypal Class Initiated by 66.211.170.66

[08/06/2011 4:40 AM] – SUCCESS :Post string : mc_gross=2.99&protection_eligibility=Ineligible&address_status=confirmed&payer_id=TDVPFLGV29E72&tax=0.00&address_street=4722+emerald+glen+dr&payment_date=21%3A40%3A29+Aug+05%2C+2011+PDT&payment_status=Pending&charset=windows-1252&address_zip=30135&first_name=david&address_country_code=US&address_name=david+anthony&notify_version=3.2&custom=ip%3D71.56.9.111&payer_status=verified&business=scenedealer%40gmail.com&address_country=United+States&address_city=douglasville&quantity=1&verify_sign=A9VjM7A51LNUlHbHF6CkrnXTh7niADV4xEUYzgn8BWTzsTLOcKMxph1C&payer_email=davidstitchez%40yahoo.com&txn_id=7F2869263H393823S&payment_type=instant&last_name=anthony&address_state=GA&receiver_email=scenedealer%40gmail.com&pending_reason=unilateral&txn_type=web_accept&item_name=durpin&mc_currency=USD&item_number=1&residence_country=US&handling_amount=0.00&transaction_subject=ip%3D71.56.9.111&payment_gross=2.99&shipping=0.00&ipn_track_id=dbTr576uD.uOTkrfENZsfw&

[08/06/2011 4:40 AM] – SUCCESS :Connection to http://www.paypal.com successfuly completed.

[08/06/2011 4:40 AM] – SUCCESS :IPN successfully verified.

[08/06/2011 4:40 AM] – SUCCESS :Creating product Information to send.

[08/06/2011 4:40 AM] – FAILURE :Funds have not been cleared yet. Product(s) will be delivered when the funds clear!

[08/06/2011 4:40 AM] – FAILURE :IPN product validation failed.

[08/06/2011 4:40 AM] – SUCCESS :Paypal class finished.

None of the other log files had anything in them other than the reset notice.

So the funds didn’t clear right away, most likely because I still need to verify my account with Paypal, BUT:

After I received a notification that the funds had cleared, I still never got a message with the link…

ALSO, even though there hasn’t been a cleared purchase yet, should the shortcode be showing up in my post if it is working properly?

http://scenedealer.com/thank-you-for-your-patronage/

Thank you so much.

-David

[stitch1z]

Anybody?

[Author]

Posts