Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Stop ebay listings with a custom quantity
Ben Turner

New
June 25, 2014 - 10:05 am
Member Since: March 13, 2014
Forum Posts: 3
sp_UserOfflineSmall Offline

Hi

I’m hoping someone has a solution to a problem we have, as we have recently started using m2e / magento and are having some serious issues. We sell on a couple of ebay accounts and keep stock in various different warehouses, as well as supplier warehouses. The stock quantity in magento is populated from the stock control system in Warehouse 1 and all fulfillment takes place from here. Listing groups for items stocked in warehouse 1 all use ‘product qty’ in the selling template and all work well. We update magento from our stock control software via Magmi and have enabled direct database changes in m2e.

The problem comes with items stocked in the other warehouses, of which we have daily transfers to warehouse 1 to fulfill any orders. We cannot use ‘product qty’ in the listing template for these as magento has a quantity of 0 as there are none in warehouse 1, so we need to use a custom qty or custom attribute for the quantity. What we do for our own website is make the child item ‘disabled’ and ‘out of stock’ if there is no stock of that sku in warehouse 1 or any other warehouse, and the item cannot be ordered. If it is out of stock in warehouse 1 but in stock elsewhere we leave it as ‘enabled’ and ‘in stock’ with a quantity of 0 and the website will still offer it for sale with a leadtime shown to the customer, to allow time to transfer to the fulfillment warehouse or dropship it.

It would appear that m2e does not revise or end a child product unless ‘product qty’ changes. If you make a child product ‘disabled’ or ‘out of stock’ m2e ignores this unless ‘product qty’ changes to 0. This means that if you use a custom quantity or an attribute for quantity then it will NEVER stop a variation from being sold on ebay, regardless of the stock status or product status. This seems bizarre but m2e tell me it is the case.

Does any one have a similar situation and how have you got around it? What is the point of using a custom quantity or an attribute for quantity if it is not possible to automate management of the product? Does anyone use custom quantities and know a way to still end obsolete / discontinued products automatically?

Thanks

Ben

Avatar
Matthew Ogborne

Founder
June 26, 2014 - 8:23 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Ben,

Apologies for the delay in replying, we had our heads down recording tutorials.

From what you’ve described there are two options, an expensive method and a method that would need some coding, but may be more suitable.

There are a couple of warehouse extensions for Magento (just google for them, there are 3 main ones) and also a Magento ERP has similar functionality. None of these are cheap, but will get you close.

The other option is to do as you’re hinting at, use a pseudo quantity in Magento for eBay or manage the status of the configurable products via the imports.

You don’t mention what tool you’re using for the warehouses, if you have any form of programical interface for this, then a relatively simple PHP script to switch the quantities and status around would work using the Magmi Datapump API. See here for more info http://wiki.magmi.org/index.ph…..tapump_API

I’ve always intended to get to this level with the advanced tutorials, however we’re working on 3 things already and we’ll get mullered if I deviate from them to cover this, so what I would suggest is either grabbing an ad-hoc developer to do this for you or a better suggestion would be to contact Sebastien who created Magmi and see if he’s available to do this for you.

Hope that helps Ben,

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

Avatar
Matthew Ogborne

Founder
June 26, 2014 - 8:24 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Oh or the obvious one that I missed, used functions in excel to spit out the correct values and then import manually.

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

Ben Turner

New
June 26, 2014 - 4:06 pm
Member Since: March 13, 2014
Forum Posts: 3
sp_UserOfflineSmall Offline

Thanks Matt

The multi-warehouse options look interesting, i will definitely consider that for future as it appears it has scope to be used to manage stock from suppliers stock feeds, dropship etc. Install looks a bit daunting though as they have a big potential to interact with other extensions…

As it happens, m2e support have just told me they will customise their extension so that it pays attention to whether the status of the child sku changes, even if it has a custom quantity. This seemingly will do exactly what we want without having to change any of our existing processes. The fee is not unreasonable either so it seems it is good news all round! :-D

Thanks

Ben

Avatar
Dave Furness

Founder
June 26, 2014 - 10:45 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey Ben,

This is great news! Happy Days, stories like this make me realise how cool open source software is, especially when it comes to multi-channel software :)

Dave

Every expert was once a beginner

 

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:
12 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: 5223

Posts: 27502

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606