News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Stock inventory not changing affter purchase

Started by coolmango, April 01, 2020, 06:51:03 AM

Previous topic - Next topic

coolmango

Hi Guys

Joomla 3 VM 3

When a shopper has bought a product the stock amount has not changed.
Eg: A shopper bought 1 product, the only 1 in stock, after the transaction was completed the inventory still listed 1 product left instead of 0. Checked again next day and it still hadn't changed.
My client says this has happened a few times though I'm not sure if it is constanly happening.

Any clues why this would be?

cheers
kim
---> using Joomla! v3.8.12 & Virtuemart v3 <---

AH

#1
Check what the order status does to stock

It should be configured to remove on the paid order status

http://docs.virtuemart.net/manual/configuration-menu/order-statuses.html

and

http://docs.virtuemart.net/manual/configuration-menu/order-status-edit.html
Regards
A

Joomla 3.10.11
php 8.0

coolmango

Hi A

Thanks for that.

I discovered that COM_VIRTUEMART_ORDER_STATUS_COMPLETED was set to 'is reserved' and changed to 'is completed'.
I'm assuming that should do the trick.

cheers
kim
---> using Joomla! v3.8.12 & Virtuemart v3 <---

AH

As long as you have the the other order statuses set correctly based on your work flow

i do not understand "is completed"

I only know of three stock handling options as shown in the documentation I posted urls for

This may be a bit of guidance:

any status that could move stock out of your business i.e. prior to being shipped "is reserved"
any status that moves stock out of your business to "is removed"
any status that returns stock into your business to "is available"

Based on the above if this is a payment option i would set "is reserved"
Regards
A

Joomla 3.10.11
php 8.0

GJC Web Design

and to add to the above once the order is shipped you would choose a status that gave  "is removed"
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AH

Quoteand to add to the above once the order is shipped you would choose a status that gave  "is removed"

I guess I was not specific enough :-)

Quoteany status that moves stock out of your business to "is removed"
Regards
A

Joomla 3.10.11
php 8.0

GJC Web Design

AH - Glad you "manned up" and admitted the errors of your ways...
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AH

Regards
A

Joomla 3.10.11
php 8.0

coolmango

Hi Guys

The change I made didn't work. I've attached the screen grab to show my settings.
Are they correct?

Any product being purchased is not being removed from the inventory automatically at any stage of the process. So my client's shoppers are buying stock that isn't there. It's a problem...

any help would be great, thanks.

cheers
kim
---> using Joomla! v3.8.12 & Virtuemart v3 <---

pinochico

What do you think you miss in your question?

Do you know what status you are using for product being purchased?

It would be great if you wrote this information straight into the question.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

Jörgen

#10
What pinochico means is this:

What is the status of the order when payment is done ?
What is the status when the order is shipped ?
What is the status of the order when it is fully processed ?
Please show the status for an order that does not work.

Do You have the correct settingfs for stock handling ?
Do You allow customers to buy out of stock products ?
There are settings for this under VM configuration/configuration/shopfront.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

AH

Your settings look fine

Run an end to end test on a local test site with the settings you have.  This change will not work retrospectively.

You also need VM to handle products differently based on stock at hand

I think that you have not configured VM to do something differently when there is no available stock

Check the "Stock Handling" option in Configuration -> Shopfront tab

1. Products Out of Stock are orderable, no special action
2. Do not Display Product
3. Do not Display Product, if child products also out of stock
4. Displays 'Notify Me' instead of 'Add To Cart' button
5. Products Out of Stock are orderable, and the field 'Availability' below is displayed

I suggest option 4 if the product will be sold again when stock is in




Regards
A

Joomla 3.10.11
php 8.0

Jörgen

Thanks AH for clarifying what I wrote.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

AH

I thought I would - as he had already posted the settings and they looked good

A diagram helps with Shopfront / config settings :-)
Regards
A

Joomla 3.10.11
php 8.0

coolmango

Hi AH

I've attached a screen shot of the config which was already set as you suggested. It didn't need changing.

I ran a test product ($1) through the shopping cart with settings as they are. The test product was set at In Stock: 10 - Booked,Ordered: 0
It currenlty uses Paypal.
Once Paypal had finished the sale the product status changed from Booked,Ordered: 0 to Booked,Ordered: 1
In Stock remains at: 10
Obviuosly this should be 9.

What do you suggest apart from changing the stock manually.

Thanks for your help

cheers
kim
---> using Joomla! v3.8.12 & Virtuemart v3 <---