Erroneous Inventory changes result of human or glitch?

[Druwallpat]

On two different occasions, I have noticed inventory changes for several items in our website’s wp-eStore.

These changes occurred for items that do not have limits so the inventory availability fields which were originally blank, somehow became populated with numbers.

Is there any other way that this could happen besides by someone physically editing the item details to make that change? Looking for verification that there’s no glitch here that I’m observing in action. Can this only be the result of human error?

[admin]

Hi, The value you see in the “available copies” field of a product is only changed by the plugin if there is a number there to start with. The initial quantity value can only be entered by a user.

We also have ways to find out if there is an issue. Simply enable debug from the settings menu of the plugin. Then do a test transaction of a product that does not have any value in the “available copies” field. Now after the transaction we can analyze the debug and make sure that it didn’t make any changes there.

[Druwallpat]

Thanks for your help… I’ve re-enabled the debug log and will check to see if something odd happens after the next transaction. I assume I am watching the iph-handling log…?

[admin]

Yes the ipn handling log will have the info.

[Druwallpat]

Okay… something weird is going on. Would you please look at the debug log?

[Druwallpat]

Here is the relevant details for an item that has infinite supply:

Registration – (Adult) #4402.5 (1) – This product does not have any downloadable content

[07/10/2013 4:40 PM] – SUCCESS :Incremental counter value for PayPal checkout: 560

[07/10/2013 4:40 PM] – SUCCESS :Applying filter – eStore_notification_email_body_filter

[07/10/2013 4:40 PM] – SUCCESS :Product Email successfully sent to **@telus.net.

[07/10/2013 4:40 PM] – SUCCESS :Notify Email successfully sent to **@mysite.org.

[07/10/2013 4:40 PM] – SUCCESS :Updating Products, Customers, Coupons, Sales Database Tables with Sales Data.

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 2

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 3

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 7

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 8

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 4

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 5

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 5

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 6

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: 19 Sales count value: 1

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: 18 New sales count value: 2

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 11

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: 18 New sales count value: 12

[07/10/2013 4:40 PM] – SUCCESS :Products, Customers, Coupons, Sales Database Tables Updated.

[07/10/2013 4:40 PM] – SUCCESS :Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.

[07/10/2013 4:40 PM] – SUCCESS :Not Using the WP Affiliate Platform Plugin.

[07/10/2013 4:40 PM] – SUCCESS :Paypal class finished.

[Druwallpat]

So after this transaction, the “available qty” was set to 18, when prior to the transaction the field was blank.

[admin]

That is a little weird. I will have to take a look inside your site. I sent you an email for it.

[admin]

I have finished my investigation and it is actually working as it should. When you see the following in the debug log file, it doesn’t mean that they are all for the SAME product. There were 6 products that was in that transaction so those are the sales count values of 6 different products. It also takes into account how many quantities of each of those items were purchased. So if 2 quantities of a product was purchased, then it will increment the sales count value by 2.

---

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 2

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 3

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 7

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 8

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 4

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 5

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 5

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: New sales count value: 6

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: 19 Sales count value: 1

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: 18 New sales count value: 2

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 11

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: 18 New sales count value: 12

---

I think this data in the debug log can be reported better by including the product ID in there so you can see exactly which product it relates to. I have just done that in the eStore plugin. It will now show the product ID value next to the sales count and available copies value in the log file.

[Druwallpat]

Yes, thank you I knew that this was updating all items purchased first to last, but disturbing here is that blank after the last entry (and repeated several times in the one I posted yesterday):

[07/10/2013 4:40 PM] – SUCCESS :Current available copies value: Sales count value: 11

[07/10/2013 4:40 PM] – SUCCESS :New available copies value: 18 New sales count value: 12

How can there be no value after this particular item’s “current available copies” that is subsequently changed to 18? So this item went from “blank” to 18. (BTW this particular item is registration for an event… it should always have unlimited supply.)

In the log tidbit I posted yesterday (but can’t repeat because the logs have been reset) the Current available copies value for one item of “8” was used numerous times as a replacement for blanks which were present in subsequent items.

It will help to have the product ID listed. If this problem reoccurs then when items like donations & registrations develop limits to the supply after sales, then I hope you can take look at this again.

[admin]

I have sent you another update which should address this issue. Let me know if you see this issue anymore after the update.

[Author]

Posts