I’m getting no help whatsoever from Ess/M2e because I’m on the ‘free’ plan at the moment. How Ess expect anyone to get to the next subscription level without support for the erratic M2e is beyond me! The phrases ‘sprat to catch a mackerel’ and ‘reap what you sow’ spring to mind. Annoyingly I expect we would be on the paid service within a couple of months if the extension worked as it should. Ess should really take a careful look at their business policy..The M2e community forum appears to be a barren wasteland and the knowledgebase does not seem to include anything technical or helpful, only config information.
Anyway, my immediate problem is that having uploaded a 2 column csv, sku and qty using Magmi, with the Ess changes inspector Magmi plugin installed and active, the automatic revise synchronisation immediately became stuck at 5% and will not move. Without this running our ebay inventory gradually depletes and listings are eventually hidden. I have approx 60 M2e listings with a total of around 14K ebay listings, mostly bundles listed as simple products through M2e, it is not practical to update these manually every time we receive new stock, it would tie up me and my PC for literally 2 days for each stock revision.
The manual revise option does work correctly, despite the automatic revise being ‘stuck’ in the background.
My first priority is to cancel the auto revise, which is obviously not working, it’s not clear how I can achieve this, any ideas?
Ultimate priority is, of course, to get the auto revise to work as it should.
Hope someone can throw me a line…
ok, don’t know if this will work for you but it’s something you can at least try if you want.
First, a warning. Backup everything first, it’s not my fault if you brake your site and if you don’t understand what I’m saying from a technical point of view get someone that does to do it. I’m not being funny but your not suppose to do direct database changes so it’s at your own risk.
Having said all that, I know what it’s like when somethings not working and you don’t know what to try.
If you going into your Magento database using phpmyadmin or something look for a table called “m2epro_locked_object” and a table called “m2epro_lock_item”
If you delete any rows of data in there but keep the empty tables then that might start it working again.
I’ve had it before where it stops downloading orders from Amazon before and this worked for me. It stops the same process running again if it’s already running but sometimes if it doesn’t finish correctly it can leave a lock behind.
Hope that helps and good luck :)
Hi Kevin. Thanks for your reply, at least I can take a look at that if it happens again. It suddenly kicked into life after 24 hours of inactivity, this was only after Ess, to their credit, had agreed to make an exception and take a look despite us not qualifying for ticket support. So I owe Ess an apology of sorts..
Although I’m only uploading 2 columns and around 2K skus, each sku has up to 7 bundles associated with it, making around 14,000 ebay listings, I suspect this may be the reason for the problem. I’ve tried uploading just a couple of products and it works just fine. I expect the problem will occur again when I try to update the full inventory.
Not sure what Jade Beli is answering above
Ok, it’s still not working properly. I think I’ve narrowed it down, by testing and checking the logs, to a problem with updating our bundle products, we have more bundles than simple, each simple product may have 7 bundles associated with it.
When using the Ess Magmi plugin, the simple products are updated in approx 30 mins if only a small csv of 150 SKUs is uploaded, if I upload 2000 simple products it gets stuck synchronising for around 24 hours due to performing what appears to be a full revise on each of the associated bundle listings, regardless of whether the item is in stock or affected by the upload. The simple products would be updated quickly and easily if it wasn’t for the bundles tying up the system.
M2e must be registering a major change to each bundle’s attributes which then warrants a full ebay revise when the bundle availability changes within Magento. As we all know, bundles do not maintain an independent inventory, for M2e and ebay the inventory of a bundle is the same as the total inventory of all the products making up that bundle (i.e. 2 x A and 2 x B in the bundle makes 4 bundles of AB available – not ideal but we can allow for this in other policies). What I need is an option to perform a partial revise when bundle availability changes, this should be default behaviour as far as I’m concerned. It’s something I haven’t a hope of fixing myself. Any thoughts?
Yes, thanks, It’s only recently become clear that M2e servers are actually a large link in the chain between Magento, the local M2e interface and ebay.
I’ve suggested to M2e support that the Magmi plugin would massively benefit from a configuration option to perform only a differential update to QTY, if the plugin was able to detect whether the Magmi uploaded quantity differed from that already existing in Magento and only apply changes where the QTY is different our updates would take minutes or seconds rather than a full day (!). As an example, our inventory upload may be 1000 simple SKUs, if there are 9 bundles associated with each SKU then 10,000 products are updated on ebay. If we only actually need to update 10 SKU inventories and the 9 bundles associated with each we’ve suddenly dropped from a 10,000 product revision to a 100 product revision – it’s a no brainer!!
The immediate benefits of this are obvious to the store owner, fast updates, revisions of products whose quantities have not changed are not made. The performance benefits to ESS and the entire M2e subscriber community are significant because M2e’s servers see an immediate and huge decrease in load.
I’m thinking I might add this to the M2e voting system but should such an obvious requirement really need voting??!
Dave, really appreciate that, I’m surprised there’s not been more votes – it’s a ‘no brainer’ that can only benefit all M2e users.
I’m not sure if M2e have actually done something about this or whether it’s coincidence, updated to the latest M2e today, uploaded my changed inventory and it’s whizzing through it relatively quickly, simple product quantities updated within a couple of minutes and the related bundles are updating at the rate of one every 4 seconds or so.
I’ve also found a way to only export products with changed inventory from our business system, this means updating hundreds rather than thousands of simple products, with obvious reductions in time taken.
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