Site maintenance: Sun 15 Nov, from 20:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Setting Up Categories, Products, Attributes / Item being sold does not come out of inventory

Item being sold does not come out of inventory

Locked

Started by iface on 16 Feb 2009, 10:09 PM · Views: 3,386

Results 1 to 17 of 17
This thread is locked. New replies are disabled.
16 Feb 2009, 10:09 PM
#1
iface avatar

iface

New Zenner

Join Date:
Dec 2005
Posts:
21
Plugin Contributions:
0

Item being sold does not come out of inventory

Zen Cart 1.3.7
Database Patch Level: 1.3.7

Customers are able to purchase orders. The products are physical products that get shipped not downloaded. Right now we need to manually go in and change the inventory count with each sale. We'd like the inventory to automatically be updated when a product is purchased?

Is there another setting that needs to be configured? This what we have.

The stock configuration settings:
Check stock level = true
Subtract stock = true
Allow Checkout = false

The product unit is set to 1.

16 Feb 2009, 11:42 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Item being sold does not come out of inventory

Subtract stock = true should be doing this

Zen-Venom Get Bitten

17 Feb 2009, 1:25 AM
#3
iface avatar

iface

New Zenner

Join Date:
Dec 2005
Posts:
21
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

Hello

I double checked and subtract stock is set to true.

Subtract stock = true

Could there be something else?

17 Feb 2009, 6:15 AM
#4
meltdown avatar

meltdown

Totally Zenned

Join Date:
Jun 2006
Location:
My family and I live in Brighton, England
Posts:
947
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

After seeing this thread, I double-checked my store status in this area and found that customers are also able to purchase 2 or more of a one-of-a-kind item. My stock configurtion settings are also:
Check stock level = true
Subtract stock = true
Allow Checkout = false

The quantity of the item is set to 1 within the admin

The "Show Sold Out Image in place of Add to Cart" is set to 1

The customer does receive the warning:

Products marked with *** are out of stock or there are not enough in stock to fill your order.
Please change the quantity of products marked with (***). Thank you

but is still allowed to add the item to the shopping cart.

This came up for me after a customer purchased two of the same one-of-a-kind necklaces. I thought that I had re-adjusted the settings so as to block this possibility but obviously not.

Can the Sold image be forced to appear in place of the add-to-cart when a one-of-a-kind or over-stock item is placed in the shopping cart?

17 Feb 2009, 6:33 AM
#5
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Item being sold does not come out of inventory

Can the Sold image be forced to appear in place of the add-to-cart when a one-of-a-kind or over-stock item is placed in the shopping cart?
What happens then if I register and place it in my cart BUT do not complete the transaction???

Zen-Venom Get Bitten

17 Feb 2009, 1:38 PM
#6
meltdown avatar

meltdown

Totally Zenned

Join Date:
Jun 2006
Location:
My family and I live in Brighton, England
Posts:
947
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

By clicking the checkout button on the shopping cart page and traveling to the login page, I registered a test account to find out what would happen. After creating the account I was returned to the shopping cart page and greeted by the same message:

Products marked with *** are out of stock or there are not enough in stock to fill your order.
Please change the quantity of products marked with (***). Thank you

and not allowed to proceed until I rectified the situation. :smile: Once again Zen had it all worked out!

17 Feb 2009, 4:05 PM
#7
iface avatar

iface

New Zenner

Join Date:
Dec 2005
Posts:
21
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

Hello I think I have my configuration correct. (below) But if something is successfully purchased, say a book. The inventory count for that book does not get lowered by one. Instead I have to go into the store admin and edit the product inventory myself. What other settings effect this functionality? The store transactions go through successfully. The products are physical books that get mailed out via UPS.

Check stock level = true
Subtract stock = true
Allow Checkout = false

The product unit quantity is set to 1.

3 Apr 2009, 10:20 AM
#8
skybluepunk avatar

skybluepunk

New Zenner

Join Date:
Oct 2008
Posts:
28
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

I'm having the same problem.

I have the following settings:
Check stock level = true
Subtract stock = true
Allow Checkout = false

Yet, when a customer makes a purchase, the stock level remains unchanged.

I thought the stock level change might be triggered by changing the status of the order, but this doesn't seem to affect it.

I also have the Stock by Attribute add-on - could this be causing the problem?

3 Apr 2009, 10:30 AM
#9
skybluepunk avatar

skybluepunk

New Zenner

Join Date:
Oct 2008
Posts:
28
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

Just to clarify my previous post, my store sells both physical products and downloads.

I'm only concerned about the stock level adjustment for the physical products.

27 May 2009, 6:52 PM
#10
jake555 avatar

jake555

New Zenner

Join Date:
May 2009
Posts:
3
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

It appears this issue STILL hasn't been resolved? I'm having the same problem and its a big showstopper for this store since, as with other posters, all of the items are one-of-a-kind.

Subtracting ordered amounts from stock inventory is a really basic feature of any cart, either something else needs to be configured somewhere, or there is some critical unresolved bug in zen cart. Do any developers/maintainers feel like answering this?

27 May 2009, 7:05 PM
#11
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,739
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

What addons do you have installed, what payment module(s) are you using and are you expecting the stock to subtract when the item is added to the cart or or after chewckout?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

27 May 2009, 7:13 PM
#12
jake555 avatar

jake555

New Zenner

Join Date:
May 2009
Posts:
3
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

No add-ons installed, just 'the basic' Zen Cart v1.3.8a/v1.3.8.

Only payment modules allowed are Paypal Express Checkout and Paypal Website Payments Pro.

I don't expect stock to subtract until after checkout. Right now the item in question has Qty min, max and units = 1, and product quantity = 1

Stock settings are:
Check stock level true
Subtract stock true
Allow Checkout false
Mark product out of stock ***
Stock Re-order level 5
Products status in Catalog when out of stock should be set to 0
Show Sold Out Image in place of Add to Cart 1

Thank you for your rapid response, btw

27 May 2009, 7:28 PM
#13
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,739
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

Are your orders showing up in the Admin properly?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

28 May 2009, 12:15 PM
#14
jake555 avatar

jake555

New Zenner

Join Date:
May 2009
Posts:
3
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

Aha, no, it doesn't appear to be. I jumped the gun and assumed the email log of the paypal transaction implied that it had gone through. So I must have something else mis-configured further upstream. Should I start a new thread to figure out my paypal problem or continue here?

just in case, here was the last message I got from zencart;

2009-05-27 12:42:21
-------------------
(live transaction) --> <https://api-3t.paypal.com/nvp>
Request Headers:
Array
(
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 45
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - WPP-NVP
    [4] => X-VPS-VIT-Integration-Version: 1.3.8a
)


Request Parameters: {SetExpressCheckout}
Array
(
    [LOCALECODE] => US
    [PAYMENTACTION] => Sale
    [AMT] => 38.00
    [RETURNURL] => <http://www.mysite.com/ipn_main_handler.php?type=ec>
    [CANCELURL] => <http://www.mysite.com/index.php?main_page=login&ec_cancel=1>
    [PAGESTYLE] => Primary
    [METHOD] => SetExpressCheckout
    [CURRENCYCODE] => USD
    [USER] => myapiuser
    [PWD] => ****************
    [VERSION] => 3.2
    [SIGNATURE] => ****************************************************
)


Response:
Array
(
    [TOKEN] => (token; EC-(17 characters))
    [TIMESTAMP] => (timestamp, date+time)
    [CORRELATIONID] => (12 character id)
    [ACK] => Success
    [VERSION] => 3.2
    [BUILD] => 904483
    [CURL_ERRORS] =>
    )
28 Aug 2009, 8:28 PM
#15
citd avatar

citd

New Zenner

Join Date:
Apr 2009
Posts:
1
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

I'm using 1.3.8a and having a very similar problem.

Website Payments Pro is the PayPal option I'm using.

In my case the PayPal orders are completing perfectly, they show in admin, generate all the correct emails etc. The only thing that is not happening is that the items purchased are not being deducted from the inventory.

Subtract Stock is set to 'true'.
The auto-return path is set to checkout_process

For some reason when I place a test order using the credit card field 'my' orders do reduce quantities correctly.

I'm at a dead end on this, and would appreciate any suggestions or advice.

17 Oct 2009, 3:20 AM
#16
ouxly40 avatar

ouxly40

New Zenner

Join Date:
Aug 2007
Posts:
31
Plugin Contributions:
0

Re: Item being sold does not come out of inventory

I sell only downloads. I have been having the same problem since day 1. Has anyone figured out what is causing this?

17 Oct 2009, 3:53 AM
#17
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Item being sold does not come out of inventory

Inventory or Stock is not tracked on Downloads ... :blink:

However ...

If your entire site is ONLY Downloads ... and you will NEVER use anything except Downloads on your site ... you can cheat ...

The way you cheat is you do something that is NEVER done with Downloads and you mark the Product as Virtual ...

Normally, you would NEVER mark a Download as Virtual as it would mess up your Shipping ... but ... if you NEVER will have anything but Downloads on your site ... you can mark the Product as Virtual and it will track the stock/sale of the Product ...

Keep in mind that you are tracking this by reducing the stock so you will need to set some kind of stock setting in the Product to have this work and configure the Configuration ... Stock settings correctly for tracking stock ...

NOTE: This is NOT how Downloads should be setup ... but it can work on a site that is ONLY Downloads and will NEVER have Physical Products and with NEVER have shipping ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!