I’m sure this shouldn’t be so difficult, but I’m stumped.
It seems that when an item reaches 0 stock, it automatically updates the Stock Availability attribute to “Out of Stock” – That’s great, makes sense
Trouble is, when you add more stock so that it’s no longer 0, the Stock Availability stays “Out of Stock”. Surely it should automatically go back “In Stock”.
My staff and I will never remember to update it to In Stock every time something goes back in stock.
Is there a setting for this? Am I missing something stupid?
You’re definitely not stupid, this is how Magento works, you can have a product with stock on it and the status of out of stock.
So when a member of staff does change this, they’ll also need to change the stock status too.
If you use magmi to update stock levels does this change the item from out of stock to in stock ?
Hi Calum, Dave,
As far as I’m aware, is that the stock status isn’t touched by the re-indexing (which would be the likely process to swap it in/out of stock).
Thinking aloud, if you;re updating your stock levels via Magmi, would the “is_in_stock” stock column be handy?
So for example in excel if you had sku, qty, is_in_stock as heads on row 1
In C2 you would have
And let that switch between 1 for instock and 0 for out of stock?
Cheers Matt, I think just having a magmi sheet ready with the is_in_stock column in there will probably make it easier for us. Plus I can make it a weekly task for an employee to do some kind of export and make sure that all >0 qtys are in stock.
Also, I think you can get M2E Pro to ignore the is_in_stock flag, if if it is out of stock but >0 qty then it should still list. So at least this will only effect the websites if we miss the odd one
Ace, that would work.
By the way, you would probably want a custom Dataflow export profile, that only exports sku, type, qty and the in_stock columns to trim the amount of data that is being exported out (and ultimately runs much faster and the chances of it actually completing will be higher).
If you get stuck, shout.
Cheers Matt, I currently tend to create custom export/imports in ESP using only the fields I need anyway – save accidentally messing up loads of other data if you accidentally insert a column or something.
I’ve also found this, but not tried it yet – http://www.crearecommerce.co.u…..bove-0.php
Ultimately it’s quite low priority compared to other tasks to get us up and running
Oh nice find.
The line that may cause you problems is line 11:
This would trigger a stock status update to apply the changes that have been made. This would be A OK on a smaller site, but on a laregr one with 10,000 products could take quite a long time to complete.
Besides that, ace!
We only have a couple of 1000 products, but how long would you class as a long time for a store with a few thousand? Was thinking of making it a daily cron job at midnight
I’d just run it say at or around midnight without the reindex process line, then schedule in reindexing processes to run overnight and let them pick them up.
The stock status index doesn’t take very long at all, it’s the product catalog is the beast.
Why Should You Join UnderstandingE?
- Access to over 500 step-by-step video tutorials
- +20 video courses available
- Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
- Everything is in 100% Plain English
- Learn how to build your own multi-channel software for eBay & Amazon
- Access to the community forums, meet fellow business owners like yourself
Join Now with 2 Clicks
Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606