Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Automatic stock availability
Dave1
Member
January 16, 2014 - 5:11 pm
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

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?

Avatar
Matthew Ogborne

Founder
January 17, 2014 - 4:21 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Dave,

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.

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Dave1
Member
January 17, 2014 - 2:15 pm
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

Cheers Matt, any idea if it’s possible to set the behaviour so that it goes back in stock when qty > 1?

Seems odd that it only automatically changes in one direction, to out of stock, but not back in stock again

Calum Roberts
Member
January 17, 2014 - 2:41 pm
Member Since: January 4, 2014
Forum Posts: 275
sp_UserOfflineSmall Offline

If you use magmi to update stock levels does this change the item from out of stock to in stock ?

Avatar
Matthew Ogborne

Founder
January 17, 2014 - 7:03 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

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

=IF(B2>0,1,0)

And let that switch between 1 for instock and 0 for out of stock?

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Dave1
Member
January 17, 2014 - 9:39 pm
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

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

Avatar
Matthew Ogborne

Founder
January 19, 2014 - 9:00 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Howdy Dave,

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.

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Dave1
Member
January 19, 2014 - 10:02 am
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

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

Avatar
Matthew Ogborne

Founder
January 20, 2014 - 1:45 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Howdy Dave,

Oh nice find.

The line that may cause you problems is line 11:

$process = Mage::getModel(‘index/process’)->load(8);

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!

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Dave1
Member
January 21, 2014 - 10:55 am
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

Cheers Matt!

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

Avatar
Dave Furness

Founder
January 21, 2014 - 12:53 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Oooo nice idea for the code find. I would have thought by running it at midnight you would avoid any problems with the time it would take to update.

Dave

Every expert was once a beginner

Avatar
Matthew Ogborne

Founder
January 21, 2014 - 1:20 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Dave1 said

Cheers Matt!

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

Howdy Dave,

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.

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Dave1
Member
January 22, 2014 - 11:30 am
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

Nice one cheers Matt. Not hight priority but I’ll let you know how it works if and when I set it up

 

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.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
38 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5221

Posts: 27485

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606