Tips and Tricks HQ Support Portal › Forums › WP Photo Seller › WP Photo Seller – Only Manual Payment Orders are Shown in order History
Tagged: Manual Checkout, paypal checkout, WP Photo Seller
- This topic has 12 replies, 3 voices, and was last updated 7 years, 6 months ago by Peter.
-
AuthorPosts
-
September 24, 2016 at 6:17 am #13729candislphotographyMember
Please help! I am receiving notifications from paypal that order payments have been made, but these orders are not shown in my order history in the plugin. However, any order that is done with manual checkout is shown in the list of orders in the plugin. For example, I have 7 orders – 2 are manual and 5 are paypal checkout. Only 2 orders total are listed in the orders tab in the plugin. However, the 5 paypal orders show up in my email as a payment notification from paypal. What could be wrong? Please help ASAP! Thank you!
September 24, 2016 at 6:59 am #74230PeterMemberPlease get the latest version of the plugin which solve should your issue.
https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins
September 24, 2016 at 6:28 pm #74231candislphotographyMemberI just installed the most recent version and it still does not appear to be working. Please let me know if there is anything else I can try. Thanks!
September 24, 2016 at 6:51 pm #74232candislphotographyMemberIf it helps, in the DB wp-orders only has the 2 manual order, but wp-order-items shows all items ordered.
September 24, 2016 at 7:13 pm #74233candislphotographyMemberI have it partially working now with these errors showing up on the order receipt:
Subtotal $
Warning: number_format() expects parameter 1 to be double, string given in /home3/calhans/public_html/candislphoto.com/wp-content/plugins/wp-photo-seller/admin/order-view.php on line 48
Tax $
Warning: number_format() expects parameter 1 to be double, string given in /home3/calhans/public_html/candislphoto.com/wp-content/plugins/wp-photo-seller/admin/order-view.php on line 70
Shipping $
Warning: number_format() expects parameter 1 to be double, string given in /home3/calhans/public_html/candislphoto.com/wp-content/plugins/wp-photo-seller/admin/order-view.php on line 78
Total $
Warning: number_format() expects parameter 1 to be double, string given in /home3/calhans/public_html/candislphoto.com/wp-content/plugins/wp-photo-seller/admin/order-view.php on line 87
It’s possible it’s because I was doing an order logged in as the seller, but I can’t find out if the errors will continue if done by another user.
September 25, 2016 at 4:43 am #74234PeterMemberjust installed the most recent version and it still does not appear to be working
Have you made a sale since after you installed the latest version?
DB wp-orders only has the 2 manual order, but wp-order-items shows all items ordered
Note that viewing the orders or receipts for those recent problematic payments will not be valid since those orders appear to not be completed successfully, therefore I recommend that you ignore those.
Let me know when you get a new order and if you see an issue for those.
If you’d like, you can set up a test gallery priced at $0.01 and post the link so I can make a test purchase.
June 3, 2017 at 5:27 pm #74235DesMasMemberHello
I can confirm, that orders with direct payment via paypal do not get listed in “list of orders”.
The items get stored in the wps_order_items table with order_id set to 0.
The table wps_orders shows no entry for this order.
Plugin-Version: 2.1.5
Wordpress Version: 4.7.5
WPMU: No
MySQL Version: 5.6.19
PHP Version: 5.6.21
Session-Speicherort: /tmp
CURL Bibliothek-Schenkung: Yes
Datei Schreibrechte debuggen: Writable
June 4, 2017 at 12:16 am #74236PeterMemberPlease do the following:
– enable photo seller logging
– create a test gallery with price $0.01 and provide the link so I can make a purchase.
June 4, 2017 at 8:07 am #74237DesMasMemberHi Peter,
logging is enabled by default.
Here a snipped of the log.txt, with some faked fields for security reasons (would send it by mail if you wish):
Code:[LOG DATE: 06/03/2017 6:31:23 pm – Server time zone UTC]
[WPSPayPalStandard.php – line 172] Failed to insert the following into the order table: Array
(
[bill_first_name] => Max Muster
[bill_address] => Am Musterberg 19
[bill_city] => Musterdorf
[bill_state] =>
[bill_zip] => 12345
[bill_country] => Germany
[ship_first_name] => Max Muster
[ship_address] => Am Musterberg 19
[ship_city] => Musterdorf
[ship_state] =>
[ship_zip] => 12345
[ship_country] => Germany
[shipping_method] => Herunterladen
[email] => m.muster@musterland.de
[phone] =>
[shipping] =>
[tax] =>
[subtotal] => 7.5
[total] => 7.50
[coupon] => none
[discount_amount] => 0
[trans_id] => xxxxxxxxxxxxxxxxxxxx
[ordered_on] => 2017-06-03 18:31:23
[status] => Pending
[ouid] => xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
[payment_method] => Paypal
[payment_status] => Complete
[share_cart_discount_amount] => 0
[delivery_status] => Complete
)[LOG DATE: 06/03/2017 6:31:23 pm – Server time zone UTC]
Product Name: 15vwBredeneek-5838 – Digital : [022-200210] – Social Media Bild mit Wasserzeichen – einmalig(1296×864)[LOG DATE: 06/03/2017 6:31:23 pm – Server time zone UTC]
[WPSPayPalStandard.php – line 255] Just about to insert the following ordered item into the order_items table: Array
(
[order_id] => 0
[product_id] => 236
[item_number] => 236
[product_name] => 15vwBredeneek-5838 – Digital : [022-200210] – Social Media Bild mit Wasserzeichen – einmalig(1296×864)
[product_price] => 7.5
[description] => 15vwBredeneek-5838 – Digital : [022-200210] – Social Media Bild mit Wasserzeichen – einmalig(1296×864)
[quantity] => 1
[gallery_id] => 1
[digital_ratio] => 1
[variation_description] => 15vwBredeneek-5838 – Digital : [022-200210] – Social Media Bild mit Wasserzeichen – einmalig(1296×864)
[duid] => 6c8d104ba8bd760bcc334b17da95f924
[form_entry_ids] => none
[date] => 2017-06-03 16:31:23
[full_gallery_purchase] => 0
[variation_id] => 76
)I’ll turn on the WordPress Debug mode and test it again to see what the insert() function has to claim about this
June 4, 2017 at 8:23 am #74238PeterMemberAs you have already observed for some reason your logs show an error as follows:
“Failed to insert the following into the order table”
In other words your server failed to do the DB operation which saves the order.
Can you double check that the following tables exist in your DB:
wps_orders
wps_order_items
Also can you check your general server error logs and let me know if you see anything related to the photo seller failures.
In addition, please check that you have the following setup correctly:
Log into your paypal account and check the following settings:
1) “Auto Return” (this should be enabled)
2) “Payment Data Transfer” (this should be enabled)
3) “Instant Payment Notification (IPN)” (this should be enabled).
4) UTF-8 formatting enabled as per https://support.tipsandtricks-hq.com/forums/topic/some-characters-and-text-not-recognizable-in-the-notification-email
Photo seller side:
1) In Payment Gateway Settings make sure you have entered your paypal email and also the correct PDT identity token.
June 4, 2017 at 8:26 am #74239DesMasMemberHi Peter,
as thought, its a constraint
Code:[04-Jun-2017 08:16:17 UTC] WordPress-Datenbank-Fehler Column ‘shipping’ cannot be null für Abfrage INSERT INTOwp_ssg_wps_orders
…As far as i can see, you are setting the shipping value in a fallback to the PayPal value “$pp” but it has not been secured that this is not NULL:
WPSPayPalStandard.php::95
Code://Check for type of delivery method
if ($deliveryMethod == ‘Pickup’) {
$shipping_cost = 0;
} else {
$shipping_cost = $pp[‘mc_handling’];
}A look into the WPS Debug statement for the “[WPSPayPalIpn.php – line 65] Starting WPSPayPalIpn::saveCartOrder: Array” also does not show this entry as part of the array.
I also see 2 other WPS relevant warnings i the log:
Code:[04-Jun-2017 08:16:17 UTC] PHP Notice: Undefined index: mc_handling in /kunden/124913_23714/SSG4/wp-content/plugins/wp-photo-seller/payment_gateways/WPSPayPalStandard.php on line 99
[04-Jun-2017 08:16:17 UTC] PHP Notice: Undefined index: tax in /kunden/124913_23714/SSG4/wp-content/plugins/wp-photo-seller/payment_gateways/WPSPayPalStandard.php on line 120June 4, 2017 at 8:42 am #74240DesMasMemberHi Peter,
There are also two other non satisfied constraints to fix:
1. $pp (check for empty does not work)
2. $pp
With these fixes, the order gets stored on the database.
WPSPayPalStandard.php::95
Code://Check for type of delivery method
if ($deliveryMethod == ‘Pickup’ || is_null($pp[‘mc_handling’]) ) { //FCA 20170604: added check for null
$shipping_cost = 0;
} else {
$shipping_cost = $pp[‘mc_handling’];
}//$contact_ph = empty($pp[‘contact_phone’])?”:$pp[‘contact_phone’];
$contact_ph = is_null($pp[‘contact_phone’])? ” : $pp[‘contact_phone’]; //FCA 20170604: changed to check for null
$pp_tax = is_null($pp[‘tax’])? ” : $pp[‘tax’]; //FCA 20170604: added check for null$data = array(
‘bill_first_name’ => $pp[‘address_name’],
‘bill_address’ => $pp[‘address_street’],
‘bill_city’ => $pp[‘address_city’],
‘bill_state’ => $pp[‘address_state’],
‘bill_zip’ => $pp[‘address_zip’],
‘bill_country’ => $pp[‘address_country’],
‘ship_first_name’ => $pp[‘address_name’],
‘ship_address’ => $pp[‘address_street’],
‘ship_city’ => $pp[‘address_city’],
‘ship_state’ => $pp[‘address_state’],
‘ship_zip’ => $pp[‘address_zip’],
‘ship_country’ => $pp[‘address_country’],
‘shipping_method’ => $deliveryMethod,
’email’ => $pp[‘payer_email’],
‘phone’ => $contact_ph,
‘shipping’ => $shipping_cost,
‘tax’ => $pp_tax, //$pp[‘tax’], //FCA 20170604: added check for null
‘subtotal’ => $subtotal,
‘total’ => $pp[‘mc_gross’],
‘coupon’ => $coupon_code,
‘discount_amount’ => $discount,
‘trans_id’ => $pp[‘txn_id’],
‘ordered_on’ => date(‘Y-m-d H:i:s’, WPSCommon::localTs()),
‘status’ => $status,
‘ouid’ => $ouid,
‘payment_method’ => ‘Paypal’,
‘payment_status’ => ‘Complete’,
‘share_cart_discount_amount’ => $share_cart_discount
);June 4, 2017 at 9:38 am #74241PeterMemberAh yes – I remember I fixed this a while back.
You must have a rather old version of the plugin.
I will email you to give you an updated zip file.
$pp (check for empty does not work)
Yes it does work. Using empty covers NULL and many other things:
-
AuthorPosts
- You must be logged in to reply to this topic.