Author Topic: Stock inventory not changing affter purchase  (Read 1629 times)

coolmango

  • Beginner
  • *
  • Posts: 15
  • A beginner
  • VirtueMart Version: 3
Stock inventory not changing affter purchase
« on: April 01, 2020, 06:51:03 am »
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

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3165
  • VirtueMart Version: 3.6.11
Re: Stock inventory not changing affter purchase
« Reply #1 on: April 01, 2020, 10:08:48 am »
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.9.18
php 7.3

coolmango

  • Beginner
  • *
  • Posts: 15
  • A beginner
  • VirtueMart Version: 3
Re: Stock inventory not changing affter purchase
« Reply #2 on: April 02, 2020, 02:14:01 am »
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

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3165
  • VirtueMart Version: 3.6.11
Re: Stock inventory not changing affter purchase
« Reply #3 on: April 02, 2020, 09:53:50 am »
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.9.18
php 7.3

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9648
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Stock inventory not changing affter purchase
« Reply #4 on: April 02, 2020, 10:55:31 am »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3165
  • VirtueMart Version: 3.6.11
Re: Stock inventory not changing affter purchase
« Reply #5 on: April 02, 2020, 12:49:13 pm »
Quote
and 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 :-)

Quote
any status that moves stock out of your business to "is removed"
regards
A

Joomla 3.9.18
php 7.3

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9648
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Stock inventory not changing affter purchase
« Reply #6 on: April 02, 2020, 14:25:16 pm »
AH - Glad you "manned up" and admitted the errors of your ways...
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3165
  • VirtueMart Version: 3.6.11
Re: Stock inventory not changing affter purchase
« Reply #7 on: April 02, 2020, 18:38:36 pm »
Its nice to see you noticed :-)
regards
A

Joomla 3.9.18
php 7.3

coolmango

  • Beginner
  • *
  • Posts: 15
  • A beginner
  • VirtueMart Version: 3
Re: Stock inventory not changing affter purchase
« Reply #8 on: April 03, 2020, 00:08:07 am »
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

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 377
    • MiniJoomla
  • VirtueMart Version: 3
Re: Stock inventory not changing affter purchase
« Reply #9 on: April 03, 2020, 01:18:56 am »
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 from products, orders and database table
Virtuemart Email Manager - customs email templates

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2747
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Stock inventory not changing affter purchase
« Reply #10 on: April 03, 2020, 07:06:24 am »
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)

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3165
  • VirtueMart Version: 3.6.11
Re: Stock inventory not changing affter purchase
« Reply #11 on: April 03, 2020, 10:05:29 am »
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.9.18
php 7.3

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2747
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Stock inventory not changing affter purchase
« Reply #12 on: April 03, 2020, 10:14:29 am »
Thanks AH for clarifying what I wrote.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3165
  • VirtueMart Version: 3.6.11
Re: Stock inventory not changing affter purchase
« Reply #13 on: April 03, 2020, 10:56:57 am »
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.9.18
php 7.3

coolmango

  • Beginner
  • *
  • Posts: 15
  • A beginner
  • VirtueMart Version: 3
Re: Stock inventory not changing affter purchase
« Reply #14 on: April 08, 2020, 03:21:07 am »
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 <---