Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Synchronisation 'revise' task permanently stuck at 5% after Magmi stock qty upload, M2e support sadly lacking!
Rob Hemsley

Excellent
April 6, 2016 - 12:59 pm
Member Since: October 7, 2014
Forum Posts: 44
sp_UserOfflineSmall Offline

Hi guys.

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…
Cheers
H

kevinthomas197

Excellent
April 7, 2016 - 11:38 am
Member Since: September 21, 2014
Forum Posts: 37
sp_UserOfflineSmall Offline

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 :)

Jade Beli

New
April 7, 2016 - 11:52 am
Member Since: April 6, 2016
Forum Posts: 2
sp_UserOfflineSmall Offline

It’s working now,it was an issue with the configuration. But still can’t upload as I get warning and fatal error.

Failed to open stream,no such file error
engines.php

Rob Hemsley

Excellent
April 7, 2016 - 1:52 pm
Member Since: October 7, 2014
Forum Posts: 44
sp_UserOfflineSmall Offline

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..

If anyone is interested, and like me was unaware, the log for the latest Magmi upload is called progress.txt and is within the Magmi ‘step’ directory.

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

Cheers
H

Avatar
Dave Furness

Founder
April 9, 2016 - 2:45 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Glad it’s working for now Rob, keep us updated if anything goes untoward again, also thanks for the help Kevin, really appreciate your guidance there.

Dave

Every expert was once a beginner

Rob Hemsley

Excellent
April 15, 2016 - 5:15 pm
Member Since: October 7, 2014
Forum Posts: 44
sp_UserOfflineSmall Offline

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?
Cheers
H

Avatar
Dave Furness

Founder
April 21, 2016 - 9:52 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey Rob,

I haven’t come across this before unfortunately, from what I can gather the option to partial revise would rely solely with M2E and isn’t something you could dev yourself and it is M2E that handles all aspects of the communication with eBay.

Dave

Every expert was once a beginner

Rob Hemsley

Excellent
April 21, 2016 - 10:53 am
Member Since: October 7, 2014
Forum Posts: 44
sp_UserOfflineSmall Offline

Hi Dave.
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??!
Cheers
H

Rob Hemsley

Excellent
April 21, 2016 - 12:22 pm
Member Since: October 7, 2014
Forum Posts: 44
sp_UserOfflineSmall Offline

Ok, I’ve added this to the ‘ideas’ list at M2e, I’d really appreciate it if anyone reading this could drop by and add a vote – it can only improve performance for us all, whether using Magmi or not…

http://support.m2epro.com/foru…..y-update-c

Avatar
Dave Furness

Founder
April 23, 2016 - 10:38 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Ive been and added a few more votes for you Rob

Dave

Every expert was once a beginner

Rob Hemsley

Excellent
April 28, 2016 - 5:03 pm
Member Since: October 7, 2014
Forum Posts: 44
sp_UserOfflineSmall Offline

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.

Cheers
RobH

Avatar
Dave Furness

Founder
May 8, 2016 - 9:15 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Well that’s good news Rob! Happy Days

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:
17 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: 27486

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606