WP Photo Seller – Only Manual Payment Orders are Shown in order History

[candislphotography]

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!

[Peter]

Please 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

[candislphotography]

I 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!

[candislphotography]

If it helps, in the DB wp-orders only has the 2 manual order, but wp-order-items shows all items ordered.

[candislphotography]

I 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.

[Peter]

just 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.

[DesMas]

Hello

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

[Peter]

Please 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.

[DesMas]

Hi 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

[Peter]

As 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.

[DesMas]

Hi 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 INTO wp_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 120

[DesMas]

Hi 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
);

[Peter]

Ah 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:

http://php.net/manual/en/function.empty.php

[Author]

Posts