Does anyone else have continual inventory discrepancies?
I have products that one day are at zero count ( correct ) and a day or two later there will an order for one ( should be hid ) and when we check inventory, there are now, say.... 10 in inventory. Which is a huge problem since I don't care to sell products that we do not have in stock!
Old merchant, New to forum
Karl
Full Version: Inventory
yep, we've noticed this and its very annoying!
Does the MC Cart deduct inventory even if an order goes into non finalized?
Does the MC Cart deduct inventory even if an order goes into non finalized?
Hi All,
The MonsterCommerce shopping cart will only take a product out of inventory once an order is placed and it is not in an order status of Cancelled, Not Finalized or a custom order status that was created on the Order Status Editor.
If your order is in any other status, then this will be subtracted from inventory. Also if you delete an order this will replace the inventory as well.
Joe
The MonsterCommerce shopping cart will only take a product out of inventory once an order is placed and it is not in an order status of Cancelled, Not Finalized or a custom order status that was created on the Order Status Editor.
If your order is in any other status, then this will be subtracted from inventory. Also if you delete an order this will replace the inventory as well.
Joe
QUOTE(
Tech Lead @ Jul 21 2006, 09:06 AM) [snapback]112232[/snapback]
Tech Lead @ Jul 21 2006, 09:06 AM) [snapback]112232[/snapback]Hi All,
The MonsterCommerce shopping cart will only take a product out of inventory once an order is placed and it is not in an order status of Cancelled, Not Finalized or a custom order status that was created on the Order Status Editor.
If your order is in any other status, then this will be subtracted from inventory. Also if you delete an order this will replace the inventory as well.
Joe
Then what is causing the discrepancies? I've seen many complaints about this in the forums. I personally don't want to have to deal with an irate customer when I have to say "The item you tried to purchase is not in stock".
Jazz
I have to agree, it still doesn't explain why this happens, we've even seen inventory go into a - (minus) amount.
QUOTE( Tech Lead @ Jul 21 2006, 08:06 AM) [snapback]112232[/snapback]
Tech Lead @ Jul 21 2006, 08:06 AM) [snapback]112232[/snapback]Hi All,
The MonsterCommerce shopping cart will only take a product out of inventory once an order is placed and it is not in an order status of Cancelled, Not Finalized or a custom order status that was created on the Order Status Editor.
If your order is in any other status, then this will be subtracted from inventory. Also if you delete an order this will replace the inventory as well.
Joe
So if I understand you right, this may be what is happening to us.
We have an item, that we have incorrectly marked available with quanity of 2. Someone orders this item, we send them an email and or call them on the phone and tell them that it is backordered, change the status of their order to BackOrdered (which we created), then one hour later someone else orders the same item, all though we were under the impression that the qty was 0 since the original order had ordered these items, but since we put it in back-order status, this item now has Qty of 2 available.
Is this what you mean? That inventory for these orders will only be subtracted when we move it out of Back order status?
The discrepancies are not due to orders being cancelled or moved into a pending status.
I was contemplating running a lateral program that would also track inventory, but that would only resolve half the problem. Even if I know the actual counts, if inventory in MC doesn't, I am still making unhappy customers.
Karl
I was contemplating running a lateral program that would also track inventory, but that would only resolve half the problem. Even if I know the actual counts, if inventory in MC doesn't, I am still making unhappy customers.
Karl
[quote name='Manager@TFS' date='Jul 21 2006, 06:13 AM' post='112233']
Tech Lead)--><div class='quotetop'>QUOTE( Tech Lead @ Jul 21 2006, 09:06 AM) [snapback]112232[/snapback]</div><div class='quotemain'><!--quotec-->
Hi All,
The MonsterCommerce shopping cart will only take a product out of inventory once an order is placed and it is not in an order status of Cancelled, Not Finalized or a custom order status that was created on the Order Status Editor.
If your order is in any other status, then this will be subtracted from inventory. Also if you delete an order this will replace the inventory as well.
Joe
[/quote]
Then what is causing the discrepancies? I've seen many complaints about this in the forums. I personally don't want to have to deal with an irate customer when I have to say "The item you tried to purchase is not in stock".
Jazz
[/quote]
Has anyone figured this out?? Within the last few days we have had orders go through for items that are out of stock. When we checked inventory the numbers are way off. No rhyme or reason. Some items have almost doubled in quantity, others up by 10 or 12, and then some are at plus 2 or 3.
The discrepancies are all in one category...the first category listed in our left column navigation....the last one listed in the back office category manager.
Monday night we checked the inventory on 7 different items, fixed them all to the correct quantity and tonight all were way off again... on the high side. Decided to look further and almost all the items are way off. This is driving us crazy. Ideas????????
Any ideas?
Tech Lead)--><div class='quotetop'>QUOTE( Tech Lead @ Jul 21 2006, 09:06 AM) [snapback]112232[/snapback]</div><div class='quotemain'><!--quotec-->Hi All,
The MonsterCommerce shopping cart will only take a product out of inventory once an order is placed and it is not in an order status of Cancelled, Not Finalized or a custom order status that was created on the Order Status Editor.
If your order is in any other status, then this will be subtracted from inventory. Also if you delete an order this will replace the inventory as well.
Joe
[/quote]
Then what is causing the discrepancies? I've seen many complaints about this in the forums. I personally don't want to have to deal with an irate customer when I have to say "The item you tried to purchase is not in stock".
Jazz
[/quote]
Has anyone figured this out?? Within the last few days we have had orders go through for items that are out of stock. When we checked inventory the numbers are way off. No rhyme or reason. Some items have almost doubled in quantity, others up by 10 or 12, and then some are at plus 2 or 3.
The discrepancies are all in one category...the first category listed in our left column navigation....the last one listed in the back office category manager.
Monday night we checked the inventory on 7 different items, fixed them all to the correct quantity and tonight all were way off again... on the high side. Decided to look further and almost all the items are way off. This is driving us crazy. Ideas????????
Any ideas?
We have also had issues with the inventory. It seems to only be affecting our products that use advanced variants. We recently re-counted all of our physical inventory and updated it in the Commerce admin for each of our products. Within a week, we had orders for items that we didn't physically have in stock.
We have submitted a ticket about this. They say that they think it's the way we are handling our orders using the status. But this is not the case since we have just recently noticed one of the products had an inventory level of zero was showing a quantity of one now. This product wasn't in an order, we just did a routine check of inventory and noticed this. This is also a product we have had issues with on past orders showing up as available.
Not sure what is going on but it is frustrating. We have moved from two other cart solutions before coming to Commerce because of inventory issues and the systems not being able to track them.
Ryan
Commerce admin for each of our products. Within a week, we had orders for items that we didn't physically have in stock.We have submitted a ticket about this. They say that they think it's the way we are handling our orders using the status. But this is not the case since we have just recently noticed one of the products had an inventory level of zero was showing a quantity of one now. This product wasn't in an order, we just did a routine check of inventory and noticed this. This is also a product we have had issues with on past orders showing up as available.
Not sure what is going on but it is frustrating. We have moved from two other cart solutions before coming to
Commerce because of inventory issues and the systems not being able to track them. Ryan
QUOTE(DerbyGarage @ Nov 10 2006, 08:44 AM) [snapback]118112[/snapback]
We have also had issues with the inventory. It seems to only be affecting our products that use advanced variants. We recently re-counted all of our physical inventory and updated it in the
Commerce admin for each of our products. Within a week, we had orders for items that we didn't physically have in stock.We have submitted a ticket about this. They say that they think it's the way we are handling our orders using the status. But this is not the case since we have just recently noticed one of the products had an inventory level of zero was showing a quantity of one now. This product wasn't in an order, we just did a routine check of inventory and noticed this. This is also a product we have had issues with on past orders showing up as available.
Not sure what is going on but it is frustrating. We have moved from two other cart solutions before coming to
Commerce because of inventory issues and the systems not being able to track them. Ryan
mamamia or derby do you guys use dataport?
Never had an issue with inventory quantity here. We normally go straight through:
new-->processing-->ready to ship-->complete
We do a manual inventory about every 60 days with no issues (yet).
PS We dont allow orders on out of stock items which might be helping.
new-->processing-->ready to ship-->complete
We do a manual inventory about every 60 days with no issues (yet).
PS We dont allow orders on out of stock items which might be helping.
QUOTE(MartiniGuy @ Nov 10 2006, 08:15 PM) [snapback]118131[/snapback]
Never had an issue with inventory quantity here. We normally go straight through:
new-->processing-->ready to ship-->complete
We do a manual inventory about every 60 days with no issues (yet).
PS We dont allow orders on out of stock items which might be helping.
Come on Martini Guy. This has been an ongoing issue for years.
inventory creeps and everyone that has been on this system for long knows it. Every day we get orders for items that we know were at zero. I can't wait for Ryan or Steph to step up to the plate here and explain how this happens. Oh never mind I know this won't happen. Perhaps someone at the NEW that actually knows how the system works will respond here but I doubt it. I wish someone from would have to take the ass chewings that we take because of the flaws in their system. Martini Guy, if you need to take a manual inventory every 60 days then you better find a new system.Tired of the irrate and rude customers.
Steve
I thought I should note that we have not seen any problems with inventory. We have our system set to hide items that are 0 and not alow them to be ordered. We use New Order > In Progress > Complete and occasional Cancel status states.
The few times I have seen discrepancies have been explained by something we did. One of the most common mistakes is cancelling an order when we do not have the item (this is usually because our physical inventory count is off due to breakage or short shipping) and forgetting to go back in and 0 that product out....as it would have put that item back in stock when we cancelled the order.
The few times I have seen discrepancies have been explained by something we did. One of the most common mistakes is cancelling an order when we do not have the item (this is usually because our physical inventory count is off due to breakage or short shipping) and forgetting to go back in and 0 that product out....as it would have put that item back in stock when we cancelled the order.
QUOTE(cjs @ Nov 10 2006, 11:06 PM) [snapback]118136[/snapback]
The few times I have seen discrepancies have been explained by something we did. One of the most common mistakes is cancelling an order when we do not have the item (this is usually because our physical inventory count is off due to breakage or short shipping) and forgetting to go back in and 0 that product out....as it would have put that item back in stock when we cancelled the order.
This happens to us as well, as you can see in the earlier post in this thread. But I believe you can mess up your inventory with Dataport 5.x if you aren't careful as well.
QUOTE(deerefun @ Nov 10 2006, 10:29 PM) [snapback]118133[/snapback]
QUOTE(MartiniGuy @ Nov 10 2006, 08:15 PM) [snapback]118131[/snapback]
Never had an issue with inventory quantity here. We normally go straight through:
new-->processing-->ready to ship-->complete
We do a manual inventory about every 60 days with no issues (yet).
PS We dont allow orders on out of stock items which might be helping.
Come on Martini Guy. This has been an ongoing issue for years.
inventory creeps and everyone that has been on this system for long knows it. Every day we get orders for items that we know were at zero. I can't wait for Ryan or Steph to step up to the plate here and explain how this happens. Oh never mind I know this won't happen. Perhaps someone at the NEW that actually knows how the system works will respond here but I doubt it. I wish someone from would have to take the ass chewings that we take because of the flaws in their system. Martini Guy, if you need to take a manual inventory every 60 days then you better find a new system.Tired of the irrate and rude customers.
Steve
Hey Steve.
Not disputing that there are folks who've had problems, I just havent had any tied to the system. My manual inventory is more of a control over manual mistakes than anything else.
I do hope that the issue gets resolved for you--I can imagine the frustration.
MartiniGuy--
We do not use dataport.
I will say we have created some of our inventory problems ourselves by not understanding that you cannot delete old orders without messing up inventory.
But there have been long periods were we have done nothing that would affect the inventory and it has been way way off. We can not come up with any reason, or see any pattern, that would give us a clue.
We do not use dataport.
I will say we have created some of our inventory problems ourselves by not understanding that you cannot delete old orders without messing up inventory.
But there have been long periods were we have done nothing that would affect the inventory and it has been way way off. We can not come up with any reason, or see any pattern, that would give us a clue.
QUOTE(mamamia @ Nov 11 2006, 02:02 PM) [snapback]118144[/snapback]
MartiniGuy--
We do not use dataport.
I will say we have created some of our inventory problems ourselves by not understanding that you cannot delete old orders without messing up inventory.
But there have been long periods were we have done nothing that would affect the inventory and it has been way way off. We can not come up with any reason, or see any pattern, that would give us a clue.
Hey mamamia.
Sorry to hear that! There obviously is a problem in the system...if it's intermittent and only related to some sites, it's probably going to be a pickle to fix. For the sake of those with the issues, I certainly hope it's attended to by monkster.
I do use dataport, but very, very judiciously. Just downloaded 5.0 today to grab my email list, but using it for bulk inventory processing scares me a bit (I've read the horror stories).
QUOTE(macrick @ Nov 10 2006, 06:13 PM) [snapback]118128[/snapback]
mamamia or derby do you guys use dataport?
We have Dataport activated but do not use it currently. We only used it when we were exporting orders to a fulfillment center that we were using. We have never used it for inventory management.
Ryan
QUOTE(DerbyGarage @ Nov 13 2006, 08:44 AM) [snapback]118167[/snapback]
QUOTE(macrick @ Nov 10 2006, 06:13 PM) [snapback]118128[/snapback]
mamamia or derby do you guys use dataport?
We have Dataport activated but do not use it currently. We only used it when we were exporting orders to a fulfillment center that we were using. We have never used it for inventory management.
Ryan
Oh I thought maybe the inventory discrepancies might have occured via the dataport. If you aren't careful, you can screw things up with dataport. Other wise, sometimes, when you move orders out of any status to cancelled it will put the inventory back in on the product(s). Or if you delete an order.
QUOTE(macrick @ Nov 13 2006, 11:14 AM) [snapback]118175[/snapback]
Oh I thought maybe the inventory discrepancies might have occured via the dataport. If you aren't careful, you can screw things up with dataport. Other wise, sometimes, when you move orders out of any status to cancelled it will put the inventory back in on the product(s). Or if you delete an order.
We have talked with support about the order status sections and it seems like we are doing everything correctly. Even if I moved and order to cancelled it should still be able to keep track of the inventory. The inventory on the cancelled order used to be live in t he system and is should just add it back in without adding extra. We also shouldn't be seeing out of stock items show up all of a sudden.
Ryan
Oh and BOY did we have issues today, on what has proven to be our busiest day of the year!
Ok, so, we have been trying to use Dataport 5 to change order status. Every time we try to download the orders, it dosen't work, possibly because there are too many. This is ruled out.
So then we went to DP 4, and tried to change the status on the .csv sheet, and upload it as tracking. BIG mistake- it takes all of these orders and makes them "not finalized". What does that do? OHHHHH...it puts all these already-sold items back into inventory. So then we sell a bunch of stuff we don't have.
To fix? Change the status of each item in DP 4 individually. 3000 times. Sorry sir, it's a "known issue". Or, do it the old fashioned way, 25 at a time.
This is just silly. How long are some of these known issues sitting out there? I KNOW some have been for years. If it's an issue, it's basically a problem. If my car had a known slow leak in the tire, i'd probably fix it since I knew about it for 2 years.
What good is Dataport 5 if we can't even download our orders, or use at all sometimes because it hogs our system?
Ok, so, we have been trying to use Dataport 5 to change order status. Every time we try to download the orders, it dosen't work, possibly because there are too many. This is ruled out.
So then we went to DP 4, and tried to change the status on the .csv sheet, and upload it as tracking. BIG mistake- it takes all of these orders and makes them "not finalized". What does that do? OHHHHH...it puts all these already-sold items back into inventory. So then we sell a bunch of stuff we don't have.
To fix? Change the status of each item in DP 4 individually. 3000 times. Sorry sir, it's a "known issue". Or, do it the old fashioned way, 25 at a time.
This is just silly. How long are some of these known issues sitting out there? I KNOW some have been for years. If it's an issue, it's basically a problem. If my car had a known slow leak in the tire, i'd probably fix it since I knew about it for 2 years.
What good is Dataport 5 if we can't even download our orders, or use at all sometimes because it hogs our system?
We had another inventory issue yesterday. Somehow a product ended up with a quantity level of -1 and it had been sold!
Not the first time this has happened.
Not the first time this has happened.
Hello All,
The only thing that I can recommend is if you believe you are having inventory issues or other bug issues, please contact us at support so that we can gather all details of the issue.
Currently the only inventory bug that has been found is with advanced variant products, and having the following settings set -
"Hide Products If Not In Stock" = YES
"Allow Purchase when Quantity in Stock is Less Than Zero" = YES
This will display the advanced variant option and allow you to purchase it.
More information can be found at -
http://kb.monstercommerce.com/development/...s.asp?BugID=626
Joe
The only thing that I can recommend is if you believe you are having inventory issues or other bug issues, please contact us at support so that we can gather all details of the issue.
Currently the only inventory bug that has been found is with advanced variant products, and having the following settings set -
"Hide Products If Not In Stock" = YES
"Allow Purchase when Quantity in Stock is Less Than Zero" = YES
This will display the advanced variant option and allow you to purchase it.
More information can be found at -
http://kb.monstercommerce.com/development/...s.asp?BugID=626
Joe
QUOTE( Tech Lead @ Nov 14 2006, 07:03 AM) [snapback]118198[/snapback]
Tech Lead @ Nov 14 2006, 07:03 AM) [snapback]118198[/snapback]Hello All,
The only thing that I can recommend is if you believe you are having inventory issues or other bug issues, please contact us at support so that we can gather all details of the issue.
Currently the only inventory bug that has been found is with advanced variant products, and having the following settings set -
"Hide Products If Not In Stock" = YES
"Allow Purchase when Quantity in Stock is Less Than Zero" = YES
This will display the advanced variant option and allow you to purchase it.
More information can be found at -
http://kb.monstercommerce.com/development/...s.asp?BugID=626
Joe
Thanks for the response.
Both of the options you mentioned above in our storefront are set to "NO". We still have issues.
It is definately an issue with advanced variants. I don't think we have a had an issue with a product that doesn't use advanced variants. We have to use both formats for our products since some require other ordering options.
We have had a trouble ticket in for a while and have given specific product and order issues.
Thanks for the help,
Ryan
QUOTE
So then we went to DP 4, and tried to change the status on the .csv sheet, and upload it as tracking. BIG mistake- it takes all of these orders and makes them "not finalized". What does that do? OHHHHH...it puts all these already-sold items back into inventory. So then we sell a bunch of stuff we don't have.
I use DP4 all the time to download new orders and upload tracking and change order status to complete and have not had any issues. The times I have seen our orders get transferred to Non Finalyze with DP4 is when we had the status as "completed" instead of "complete". It did not recognize the status and put them all in non finalyze.
I stay way far away from DP5 as I think it is dangerous and is way to easy to totally mess up your store....just my opinion. I hope DP4 never goes away. I understand spreadsheets and it is very easy to work with them in DP4.
Are the merchants that use Advanced variants the ones that have the most inventory issues? It seems that way. I'm hoping that is not the case. Are there other merchants that are not using advanced variants having these issues?
Thanks,
Jazz
Thanks,
Jazz
DP5 is a typical product. Could be very, very good, but isn't quite there, and once it's out, no more work is done on it. I simply can't download all my orders, it won't let me.
I have absolutely no quick way to go in and change multiple statuses. If it weren't for Stoneedge, I'd have to hire another full time person just to fix MC's backend.
product. Could be very, very good, but isn't quite there, and once it's out, no more work is done on it. I simply can't download all my orders, it won't let me. I have absolutely no quick way to go in and change multiple statuses. If it weren't for Stoneedge, I'd have to hire another full time person just to fix MC's backend.
We were told by support that our problem cannot be duplicated or re-created on their end. They asked for specific products, order numbers etc. if we run into the problem again. We have already provided the product ID, order number info etc. that they requested on this trouble ticket.
Not sure what to provide next time.
We moved to Commerce was because we were sick of dealing with the inventory issues we had seen in other carts.
UPDATE:
We given support all of the information we have on an inventory item issue. We even tracked back the last two orders for that product and included orders numbers. Hopefully they can figure something out. They have had everything from us for over a week now.
Ryan
Not sure what to provide next time.
We moved to
Commerce was because we were sick of dealing with the inventory issues we had seen in other carts.UPDATE:
We given support all of the information we have on an inventory item issue. We even tracked back the last two orders for that product and included orders numbers. Hopefully they can figure something out. They have had everything from us for over a week now.
Ryan
I recently posted the temporary fix we received from support with our ongoing inventory issues that seem to be our problem. I guess that wasn't allowed because it was so ridiculous that they didn't want the rest of you reading it. So they deleted it plus a response to it re-assuring me that the idea was ridiculous.
So, instead of posting that again I will ask this question:
Have any of you found any work arounds using the existing inventory system that is provided to us? I know there are 3rd party software solutions. I am interested to see if there is anything that can be done currently without having to re-count our inventory every night and matching it to what is in the Commerce admin.
Thanks,
Ryan
So, instead of posting that again I will ask this question:
Have any of you found any work arounds using the existing inventory system that is provided to us? I know there are 3rd party software solutions. I am interested to see if there is anything that can be done currently without having to re-count our inventory every night and matching it to what is in the
Commerce admin.Thanks,
Ryan
We started our trouble ticket on 10/31/2006 for inventory issues. After going back and forth with support and providing detailed information about the issue we have found that there isn't an advanced variant inventory issue.
We could have saved quite a bit of time researching this since Oct. 31st, 2006 if the first reply would have said there isn't an issue. Seems like there are quite a few poeple in this thread that don't have the issue.
Well....it's back to manually counting inventory on our shelves and comparing it to the MC inventory.
Ryan
We could have saved quite a bit of time researching this since Oct. 31st, 2006 if the first reply would have said there isn't an issue. Seems like there are quite a few poeple in this thread that don't have the issue.
Well....it's back to manually counting inventory on our shelves and comparing it to the MC inventory.
Ryan
We have no issues reported with incorrect inventory. With this being said, I wanted to explain a few things regarding the order status within our cart.
When moving to/from a custom order status, inventory is not affected in any way. Not Finalized and Cancelled statuses add the inventory back to your products, but only if they are moved from another default status. All other statuses take inventory out, but only if moved from Not Finalized or Cancelled.
It's probably better explained with a few examples. 1) I have a New Order that I move to Cancelled. The product's inventory gets put back in stock. 2) I have a New Order that I move to my custom status. Inventory stays the same (removed from inventory), since it was removed in the New Order status. I then move it from the custom status to Cancelled. Inventory stays the same (removed from inventory).
The above example demonstrates a way to not put inventory back in stock when cancelling an order. This is the opposite of what is being discussed in this forum, but demonstrates a way for the opposite to happen as well.
Also, when an order is deleted, inventory is put back in stock. So if you delete an order in New Order, it will put the inventory back in stock.
Put this with what I said above, and you get a possible issue. You move an order from New Order to Cancelled, then delete it. In that situation, the inventory actually gets put back into stock TWICE. This could be what the problem is in this thread.
When moving to/from a custom order status, inventory is not affected in any way. Not Finalized and Cancelled statuses add the inventory back to your products, but only if they are moved from another default status. All other statuses take inventory out, but only if moved from Not Finalized or Cancelled.
It's probably better explained with a few examples. 1) I have a New Order that I move to Cancelled. The product's inventory gets put back in stock. 2) I have a New Order that I move to my custom status. Inventory stays the same (removed from inventory), since it was removed in the New Order status. I then move it from the custom status to Cancelled. Inventory stays the same (removed from inventory).
The above example demonstrates a way to not put inventory back in stock when cancelling an order. This is the opposite of what is being discussed in this forum, but demonstrates a way for the opposite to happen as well.
Also, when an order is deleted, inventory is put back in stock. So if you delete an order in New Order, it will put the inventory back in stock.
Put this with what I said above, and you get a possible issue. You move an order from New Order to Cancelled, then delete it. In that situation, the inventory actually gets put back into stock TWICE. This could be what the problem is in this thread.
WOW,
I really started something!
We use Dataport but only for our UPS intergration.
We have experienced these issues even before utilizing dataport, and also happens with products with no variants.
Heck, even since moving to a "new" server last year, we still have ongoing inventory issues.
Hopefully, some day it will be adressed
Until then keep smiling!
Karl
I really started something!
We use Dataport but only for our UPS intergration.
We have experienced these issues even before utilizing dataport, and also happens with products with no variants.
Heck, even since moving to a "new" server last year, we still have ongoing inventory issues.
Hopefully, some day it will be adressed
Until then keep smiling!
Karl
QUOTE(scaldiran-MC Team @ Jan 4 2007, 12:40 PM) [snapback]119676[/snapback]
It's probably better explained with a few examples. 1) I have a New Order that I move to Cancelled. The product's inventory gets put back in stock. 2) I have a New Order that I move to my custom status. Inventory stays the same (removed from inventory), since it was removed in the New Order status. I then move it from the custom status to Cancelled. Inventory stays the same (removed from inventory).
The above example demonstrates a way to not put inventory back in stock when cancelling an order. This is the opposite of what is being discussed in this forum, but demonstrates a way for the opposite to happen as well.
Also, when an order is deleted, inventory is put back in stock. So if you delete an order in New Order, it will put the inventory back in stock.
Let me see if I am understanding you correctly because we have heard different things about the status options from a few of the support staff.
If we have a "New Order" then move it to "Pending" status then eventually moving it to "cancelled" status could still keep the inventory out?
We have gone through the process of the different status options numerous times with support and by what we were told and what we have tried it seemed to work to add the inventory back in. Yet, we still had random issues after that.
Ryan
Hi Ryan,
Any time an order is moved to cancelled status, no matter what status it was in before the qty of the products purchased will be added back to the qty in stock. Note if you move the order from cancelled to say Pending, this will then take the stock back out of inventory and decrease that value. Secondly, any time an order is deleted the qty in stock will be added back to the product. So if you move an order to cancelled and then delete it, the qty in stock will be added back twice.
One final note though if the order is in a custom order status that you created - if you move that to canceled it will not add the inventory back then.
Joe
Any time an order is moved to cancelled status, no matter what status it was in before the qty of the products purchased will be added back to the qty in stock. Note if you move the order from cancelled to say Pending, this will then take the stock back out of inventory and decrease that value. Secondly, any time an order is deleted the qty in stock will be added back to the product. So if you move an order to cancelled and then delete it, the qty in stock will be added back twice.
One final note though if the order is in a custom order status that you created - if you move that to canceled it will not add the inventory back then.
Joe
QUOTE( Tech Lead @ Jan 5 2007, 07:08 AM) [snapback]119711[/snapback]
Tech Lead @ Jan 5 2007, 07:08 AM) [snapback]119711[/snapback]Hi Ryan,
Any time an order is moved to cancelled status, no matter what status it was in before the qty of the products purchased will be added back to the qty in stock. Note if you move the order from cancelled to say Pending, this will then take the stock back out of inventory and decrease that value. Secondly, any time an order is deleted the qty in stock will be added back to the product. So if you move an order to cancelled and then delete it, the qty in stock will be added back twice.
Joe
Looks like we have been doing it corretly then.
Thanks,
Ryan
Hows that explain inventory that has ended up with a minus number? We frequently have issues with inventory, so much so, its over to Stonedge we go.
QUOTE(smckenzie @ Jan 5 2007, 08:57 AM) [snapback]119723[/snapback]
Hows that explain inventory that has ended up with a minus number? We frequently have issues with inventory, so much so, its over to Stonedge we go.
We have had the exact same issue. That is why we started our trouble ticket to begin with, to see if we could get this figured out. Now, we do a random manual count of a few products on our shelf each day. The past three days we have had two that were off, one by -4 and the other by +2. That is just the last three days.
Ryan
QUOTE( Tech Lead @ Jan 5 2007, 08:08 AM) [snapback]119711[/snapback]
Tech Lead @ Jan 5 2007, 08:08 AM) [snapback]119711[/snapback]Hi Ryan,
Any time an order is moved to cancelled status, no matter what status it was in before the qty of the products purchased will be added back to the qty in stock. Note if you move the order from cancelled to say Pending, this will then take the stock back out of inventory and decrease that value. Secondly, any time an order is deleted the qty in stock will be added back to the product. So if you move an order to cancelled and then delete it, the qty in stock will be added back twice.
One final note though if the order is in a custom order status that you created - if you move that to canceled it will not add the inventory back then.
Joe
Somebody remind me how an order gets in Pending. What is the difference between Not-Finalized and Pending? If inventory is taken away when an order is in Pending, is inventory taken away when an order is in Not-Finalized?
QUOTE(macrick @ Jan 5 2007, 10:41 AM) [snapback]119726[/snapback]
Somebody remind me how an order gets in Pending. What is the difference between Not-Finalized and Pending? If inventory is taken away when an order is in Pending, is inventory taken away when an order is in Not-Finalized?
All of the orders that didn't process (credit card wise) go into the "not finalized" status automatically.
This is what support said about the "Not Finalized" status and inventory:
Not Finalized and Cancelled statuses add the inventory back to your products, but only if they are moved from another default status.
This brings up another question. When an order does not finalized because a credit card transaction was declined or failed for some reason, does it add the inventory back? Or since it wasn't moved from a default status such as "New order" it leaves the inventory as taken out and we have to manually move the "not finalized" order into "Cancelled" status to put this inventory back into the system?
To have an order in "Pending" status you would have to move it manually to that status. We used to accept check and moneyorder orders. The order would process then once we saw the payment type was a check or money order we would move it into "Pending" until we received payment. Once we received payment we would move the order to "Ready To Ship" then to "completed" onced shipped. If a payment didn't arrive for an order in a reasonable amount of time we would move the order to "Cancelled" status.
Ryan
Hi Macrick, DerbyGarage,
If an order comes in as not finalized - inventory is not adjusted in any way. Note if you move that order out of not finalized to cancelled, the inventory will not put itself back it will just stay the same. If you move an order from not finalized to pending or some other status though as long as the status is not a custom status you have created, it will take the inventory off of the product. So to note, if you have an order that comes in as not finalized, then an order is placed that sets your products inventory to 0. If you then move that not finalized order to say Completed - this would then set your inventory to -1 as we do not do an inventory check once in the admin panel.
Joe
If an order comes in as not finalized - inventory is not adjusted in any way. Note if you move that order out of not finalized to cancelled, the inventory will not put itself back it will just stay the same. If you move an order from not finalized to pending or some other status though as long as the status is not a custom status you have created, it will take the inventory off of the product. So to note, if you have an order that comes in as not finalized, then an order is placed that sets your products inventory to 0. If you then move that not finalized order to say Completed - this would then set your inventory to -1 as we do not do an inventory check once in the admin panel.
Joe
QUOTE( Tech Lead @ Jan 5 2007, 09:08 AM) [snapback]119711[/snapback]
Tech Lead @ Jan 5 2007, 09:08 AM) [snapback]119711[/snapback]<snip> Secondly, any time an order is deleted the qty in stock will be added back to the product. So if you move an order to cancelled and then delete it, the qty in stock will be added back twice.
One final note though if the order is in a custom order status that you created - if you move that to canceled it will not add the inventory back then.
Holy Crap!!! This should be called out in Big Bold Print on the Order Status Editor Page!!!!
Why on earth would you design folders like this???
We set up a bunch of custom folders assuming they worked just as any other normal status folder. No wonder we were constantly coming up one or two short when we ran out of inventory at Christmas!!!
I love these hidden "features" that the MC tech staff talks about like, "oh yeah.... Didn't you know that?"
Also, I would like to add that it is not just bug 626 that are contributing to inventory issues, these are also pertinent:
ID: 357
Description:
Admin
Site Settings Summary:
* Inventory >> Product Editor
1) Quantity in Stock defined on General Tab = 0
2) Product has Advanced Variants defined with inventory counts specified
* Site Information >> Site Wide Settings >> Site Rules
3) “Allow Negative Product Quantities” = YES
** Then the product is hidden within the product list within the storefront.
If a product uses Advanced Variants and specifies inventory counts within this section, the Quantity in Stock defined on the General tab of the product should not affect the show or hide of this product.
For example:
Product has Advanced Variants that all have quantity in stock defined
On the General tab of the Product Editor the Quantity in Stock is set to 1
Within Site Wide Settings "Hide Products If Not In Stock" is set to YES.
Now, go to the Category of this product
*** The product is in the list.
Now, open the Product Editor for this product and change the Quantity in Stock on the General tab to 0.
Return to the Category of the product
*** The product is no longer listed in the product list
Suggested Workaround:
Within Inventory >> Product Editor > General tab, under Qty In Stock enter at least 1.
Last Updated: 7/15/2004 11:23:01 PM
ID: 309
Description:
If Site Information > Site Wide Settings > Site Rules Tab >
Allow Negative Product Quantities option is set to NO:
And the following criteria exist within the Product Editor:
1. Quantity in stock on general tab can be 0 or a negative or positive number.
2. Advanced Variants enabled
3. Inventory count for active advanced variant is 0 (zero)
4. Inventory count for inactive (unchecked) advanced variant is 9
Results:
Quantity in stock within the Product Detail page shows as 9.
No variant dropdown is displayed because none of the active variant is in stock.
The In stock value within the Product Detail page is displaying the inventory quantity from the hidden advanced variant.
Buy Button does display, but not able to purchase product.
Alert that inventory is not available appears.
Suggested Workaround:
Last Updated: 6/24/2004 6:54:59 PM
Along with issue 626 these have been issues for over two years. If you let the MC cart handle itself "the way it's supposed to" and you are using Advanced Variants to track a significant inventory, things will no doubt get screwy and unorganized.
Best,
Garland
ID: 357
Description:
Admin
Site Settings Summary:
* Inventory >> Product Editor
1) Quantity in Stock defined on General Tab = 0
2) Product has Advanced Variants defined with inventory counts specified
* Site Information >> Site Wide Settings >> Site Rules
3) “Allow Negative Product Quantities” = YES
** Then the product is hidden within the product list within the storefront.
If a product uses Advanced Variants and specifies inventory counts within this section, the Quantity in Stock defined on the General tab of the product should not affect the show or hide of this product.
For example:
Product has Advanced Variants that all have quantity in stock defined
On the General tab of the Product Editor the Quantity in Stock is set to 1
Within Site Wide Settings "Hide Products If Not In Stock" is set to YES.
Now, go to the Category of this product
*** The product is in the list.
Now, open the Product Editor for this product and change the Quantity in Stock on the General tab to 0.
Return to the Category of the product
*** The product is no longer listed in the product list
Suggested Workaround:
Within Inventory >> Product Editor > General tab, under Qty In Stock enter at least 1.
Last Updated: 7/15/2004 11:23:01 PM
ID: 309
Description:
If Site Information > Site Wide Settings > Site Rules Tab >
Allow Negative Product Quantities option is set to NO:
And the following criteria exist within the Product Editor:
1. Quantity in stock on general tab can be 0 or a negative or positive number.
2. Advanced Variants enabled
3. Inventory count for active advanced variant is 0 (zero)
4. Inventory count for inactive (unchecked) advanced variant is 9
Results:
Quantity in stock within the Product Detail page shows as 9.
No variant dropdown is displayed because none of the active variant is in stock.
The In stock value within the Product Detail page is displaying the inventory quantity from the hidden advanced variant.
Buy Button does display, but not able to purchase product.
Alert that inventory is not available appears.
Suggested Workaround:
Last Updated: 6/24/2004 6:54:59 PM
Along with issue 626 these have been issues for over two years. If you let the MC cart handle itself "the way it's supposed to" and you are using Advanced Variants to track a significant inventory, things will no doubt get screwy and unorganized.
Best,
Garland
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.