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?
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.
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,
Oh or the obvious one that I missed, used functions in excel to spit out the correct values and then import manually.
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
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