Inventory & Variation issues

[kez]

We have a product (an event) with 1 variation (lunch). The options are No Lunch, Regular Lunch, Vegetarian Lunch the last 2 options have prices attached. Inventory is turned on, spots are limited.

The issue is that inventory is decreased for every sale (that’s expected) AND for every lunch (should not be happening). So I have 7 sales of the product, 6 of them added the lunch option and total sales is showing as 13, and the inventory is reduced by 13 instead of 7. Only the product sale should be deducted from inventory.

How to I fix this issue?

We have the eStore Variations UI Addon plugin installed and activated.

[wzp]

Did you set this up as a PHYSICAL or DIGITAL product?

There is ONE variation, with 3 choices?

The variation setup is in accordance with the addon documentation?
https://www.tipsandtricks-hq.com/ecommerce/wp-content/uploads/docs/doc_eStore_advanced_variations_ui_addon.pdf

[kez]

It is a physical product (as all our others, which show up in Order Management have been)

Yes, ONE variation with 3 choices

I have set it up as the documentation describes. I could take a screenshot, but you offer no way here for me to attach a file.

[wzp]

Use a pastebin service or Google Drive and post a link.

[kez]

Screenshot of variation setup
https://drive.proton.me/urls/X5XJG350Y8#UShbidtLYu4g

[kez]

Any idea why the number of sales attributed to the product are more than the number of orders I can see in the Customer Management area?

[wzp]

…the number of sales attributed to the product are more than the number of orders I can see in the Customer Management area…

I’m going to take a “shot in the dark,” on this. I see you have another support issue ongoing with @admin, in which the issue of PHP 8 compatibility is raised.

In your screenshot, for the “No Lunch” option; the “Assign a Price” box is unchecked. What happens if you assign a price of “0” to it?

• This reply was modified 2 years, 1 month ago by wzp.

[kez]

@wzp I’ll try assigning 0 to No Lunch and see what happens. I’ll have to wait for orders to come in but we are getting orders every day, so hopefully by tomorrow I’ll have information.

I want to clarify, I was not the one who raised the issue of PHP 8 compatibility. That was someone else, not related to my website which is running PHP version 7.4.30.

[kez]

It looks like we have had 2 sales today since I updated the eStore plugin and Order Management add-on as per @Admin’s advice. The Product sales count only incremented by 2 – which is correct. So possibly the plugin updates fixed the issue. It’s hard to be sure with only 2 orders.

[kez]

Update: it now seems that what might be happening is that the sales count is accurate, but the Customer Management system is not recording all of the orders. This is a really big problem for us!

I have evidence of one sale where this is definitely the case. I’m waiting to hear back from the person managing the Paypal account to find out if the same thing explains the discrepancy between the 2 numbers. if that’s the case then 1/3 of our orders are not showing up in the Customer Management system.

[kez]

I have gotten the number of sales from Paypal now and the Sales count on the product itself (in the Product Management area) is correct. The eStore plugin is not recording some of the sales. Obviously this is a huge problem for an event where we need to have all orders in a list for the day of the event as people arrive.

I am fairly sure that is what is happening is that the eStore is not recording the orders where the purchaser chose a quantity greater than 1. For example if they bought two tickets. I have 1 confirmed case of exactly this, and I suspect this will be true for all cases where the eStore did not record the order. I am waiting for confirmation from the person who manages the Paypal account.

I have changed the product setting to not show the quantity field for in the product listing. But they can still update the quantity on the sales page, and if they add the product to their cart more than once the quantity field in the cart will increase anyway, so I don’t think this is necessarily a solution. I will have to wait for more sales to come through.

I would really like some support on this issue. So far I have not received solutions to either of the 2 issues I have posted.

[kez]

@Admin – I have confirmed now, that every order which did not get recorded in the Customer Management area is for quantity 2.

[kez]

I have now created a staging site so I can change make changes without affecting the live site. As per Luke’s suggestion I deactivated all the add-ons and tested by purchasing 2 of the product. Same issues exist. I then deactivated ALL plugins except the eStore plugin and purchased 2 of the product. Same issues exist.

So it doesn’t seem to be a plugin conflict.

[admin]

We replied to your email but I will post it here also just to make sure you get this info:

It Looks to be a UTF-8 character encoding issue. The character set is not set to UTF-8. Check the following settings of the PayPal account:

Some Characters and Text Not Recognizable in the Notification Email

[kez]

Thanks @admin I will ask the person managing the Paypal account to make this change.

Regarding the inventory issue, I replicated the product and made that the live product after all my testing and finding that it worked on our staging site. Today we just got our first order for quantity 2 for the new product and it came into the Customer Management area. Which is great, at least that issue has been fixed. That was the most improtant issue.

Still none of the sales of this product are showing up in the Order Management area, even though on our staging site that issue was fixed by the new replicated product.

[Author]

Posts