I haven't tested the integration since we last wrote. It's possible that something has changed on the virtuemart front.

Will need to setup a test environment and test.

Regards,
Daniel

I believe the latest version of VM (3.6) is the issue. Are you been able to test CMC successfully with 3.6?

Thanks for your help!
-Matt

Just checked and it is crashing for me as well. Something has changed. Will need to debug.

Things have changed... I'll need some time to figure out where stuff was moved and how we are supposed to read the products out.

Ok, thanks to Max from VM I think that we can have a quick fix.
Go in administrator/components/com_cmc/libraries/shopsync/shops/virtuemart.php

on line 5 and 6 you have:

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/vmmodel.php';

change it to

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';

VmConfig::loadConfig();

now rerun the sync and it should work. (or at least it did for me with test data)

Regards,
Daniel

Hi Daniel,

Thanks for looking into this. Max is a good guy!

I made the changes to the virtuemart.php file as you instructed and I see a little progress now. However, I am still getting an error while trying to sync (see attached image). We have ~275 products, but it came up as 0 then you can see the error behind the popup that says "Error Syncing Customers."

Let me know if I can provide any additional information.

Thanks,
-Matt

Hi Dan,

I just wanted to follow up here as I am still having sync issues.

Thanks for all of your help,
-Matt

Hi Matt,

Sorry, I guess I forgot to post my comment last time. Can I get access to your site to debug the issue live in there? I cannot reproduce the problem with the demo data form VM.

Regards,
Daniel

Of course, I have setup access for you as an admin, how can I send this to you privately?
Thanks Dan,
-Matt

Just use the forum.. At the bottom of the post input box is a "site details" tab. Enter the access credentials there and they are only visible to site moderators. After I'm ready with debugging you can remove them and change the credentials on your site.

Please give me ftp + it would be very good if I also have phpmyadmin access to the database to eventually inspect the raw data if necessary.

Hello Dan,
I have added the site url, user/pass. Ftp access is really difficult to set up, I can try to see if our WebOps team will do it. I have added mysql access to ftp for now. Can we work around ftp, happy to send any files you need.
Thanks,
-Matt

Ok, at first glance I seem to be able to reproduce the issue on my machine. Will try to debug it tomorrow.

That is great news, thanks again for all of your help!
-Matt

Hi Daniel,

I wanted to reach out to see if you were able to debug this issue. Let me know how I can help!
-Matt

I was traveling last week. Not sure if I'll find time for CMC this week, but I'll try to squeeze it somewhere when I get some free time.

Thanks Daniel, I appreciate the update.
-Matt

Now in the corona times I should have some more time to look into this this week as I don't need to commute

Will let you know, once I've fixed it.

Thanks Daniel, be safe and be well!
-Matt

So, okay! I had another look at this and I'm starting to doubt that we really have a problem.

Can you go in mailchimp click on your name -> connected sites -> do you see your site there?

click on it and remove it.

Then go in the joomla backend to CMC and re-sync.

In my case the error that I was seeing was -> something with store already synced. It seems that once a store is synced - you cannot resync it.

We have a plugin for virtuemart ecom360virtuemart that syncs products, users etc when you make modifications in virtuemart. So after initial sync there is no need to try to resync the store.

I tested this and it seems to work fine. I was able to create a newsletter and to pull a product from my VM store.

Before you turn on the ecom360 plugin you would have to make a 2 line change there as well. (things have changed in the latest vm version)

go to:
plugins/system/ecom360virtuemart/ecom360virtuemart.php

and change:

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/vmmodel.php';

to

require_once JPATH_ADMINISTRATOR . '/components/com_virtuemart/helpers/config.php';

VmConfig::loadConfig();

After that you can enable the plugin and the site should work. (if you don't do this change you'll see a white screen and your site won't work)

Regards,
Daniel

Hi Daniel,
Thanks for working on this, I have followed the steps you outlined above and I have made some progress. The site does now sync, however, it shows 0 products. Meanwhile we have over 300 active products.

Your help is greatly appreciated, I hope you are doing well.
-Matt