Hi Matt,
Can you get me access to the site for debugging? I would need backend + ftp access to understand what's going on. I can't reproduce this on my test site.

Regards,
Daniel

Hi Dan,

I see it on both sides. In Joomla, when I did the sync, 0 products showed, but all contacts did, categories and I forget the other parameter. On the mailchimp side, it shows as a connected site, but if I try to add a product to a newsletter, I cannot see any products.

Thanks for your continued support,
-Matt

Where does it show 0 products? When you hit sync or what? That's strange because in my case it showed 11 products from a dummy vm installation.

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

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

Thanks Daniel, be safe and be well!
-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, I appreciate the update.
-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.

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

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

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

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

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.

Of course, I have setup access for you as an admin, how can I send this to you privately?
Thanks Dan,
-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

Hi Dan,

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

Thanks for all of your help,
-Matt

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

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

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.