Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Addon code to sync Cs-cart users to mailchimp list Rate Topic   - - - - -

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 27 June 2013 - 11:33 PM #1

Hi Cs-carters,

Check out this addon code for syncing cs-cart users to a mailchimp list.
Was sick of uploading csv user files to my mailchimp account, so wrote this addon code.
This runs daily as a cron job and creates subscribers in mailchimp who joined in the last 24 hrs.

Addon code to sync Cs-cart users to Mailchimp

regds,
Shikhar
Cs-cart tips at shikhar.me

 
  • globalburo
  • Junior Member
  • Members
  • Join Date: 16-Mar 11
  • 138 posts

Posted 28 June 2013 - 08:03 AM #2

hello
Tanks This addon nice for me
but I have litte problem
Batch Subscribe failed!
code:200
msg :Invalid MailChimp List ID: Deneme

complete
pls help me what is wrong ?
I write api key and list name(Deneme)
am I another write anything ?

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 28 June 2013 - 08:28 AM #3

Hi Global,

Thanks for checking out the addon.
The one you are using is not the ListID, check the screenshot attached, I have highlighted the ListID.

regds,
Shikhar

Attached Files


Cs-cart tips at shikhar.me

 
  • globalburo
  • Junior Member
  • Members
  • Join Date: 16-Mar 11
  • 138 posts

Posted 28 June 2013 - 08:54 AM #4

I dont fint this image on my mailchimp acound
I have 1 acound and 5 List ID (Deneme= my test id )
And another problem my order status chance dont send mail my cutomer email
tank you ..

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 28 June 2013 - 09:10 AM #5

See the screenshot attached.

For order status change to send emails, configure it from orders -> order statuses -> edit order status-name -> check notify customer

Attached Files


Cs-cart tips at shikhar.me

 
  • globalburo
  • Junior Member
  • Members
  • Join Date: 16-Mar 11
  • 138 posts

Posted 28 June 2013 - 09:51 AM #6

I think I make add true
My chimp Acound an display different
I dont know how add images this mesaj box
my email order statuses before is good run now is problem
Posted Image

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 28 June 2013 - 10:01 AM #7

Yes global your mailchimp shows differently, no idea on this.
Do some research or contact mailchimp support on how to get ListID.
Cs-cart tips at shikhar.me

 
  • globalburo
  • Junior Member
  • Members
  • Join Date: 16-Mar 11
  • 138 posts

Posted 28 June 2013 - 10:18 AM #8

Thank you for your interest

 
  • Roto
  • Advanced Member
  • Banned
  • Join Date: 23-May 12
  • 127 posts

Posted 28 June 2013 - 10:31 AM #9

thanks for share. 8)
...

 
  • Webrunner
  • Member
  • Members
  • Join Date: 06-Dec 06
  • 68 posts

Posted 22 August 2013 - 09:50 AM #10

Thanks for sharing! I used your code to get all subscribers into mailchimp, not all clients.

Therefor I've changed the database query. People wanting to do the same:
Change
$user_array = db_get_array('SELECT user_id,title,firstname,lastname,email FROM ?:users WHERE user_type = "C" AND timestamp > ?i', $since_timestamp) ;

Into

$user_array = db_get_array('SELECT cscart_subscribers.email, cscart_users.firstname, cscart_users.lastname FROM cscart_users RIGHT JOIN cscart_subscribers ON cscart_users.email = cscart_subscribers.email WHERE cscart_subscribers.timestamp > ?i', $since_timestamp) ;
in the mailchimp.php file

Authorized Reseller Bitcoin accepted!
CS-Cart $345 - Ultimate $775 - Multi-Vendor $1250 https://sprintweb.nl
 


 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 22 August 2013 - 10:11 AM #11

@webrunner

Nice to know it worked well for you, I was under the impression that no one used it :P
Cs-cart tips at shikhar.me

 
  • Onkel_Sid
  • Junior Member
  • Members
  • Join Date: 04-Sep 10
  • 301 posts

Posted 27 October 2013 - 12:45 AM #12

Will this also work in version 4 of CS-Cart?

Stop smoking start vaping: Dampskyen.no


 
  • Onkel_Sid
  • Junior Member
  • Members
  • Join Date: 04-Sep 10
  • 301 posts

Posted 28 October 2013 - 05:07 PM #13

To answer my own question. Yes, it does !

Stop smoking start vaping: Dampskyen.no


 
  • gasngrills
  • Senior Member
  • Members
  • Join Date: 23-Feb 08
  • 247 posts

Posted 30 October 2013 - 01:41 PM #14

To answer my own question. Yes, it does !


Did you have to do anything different to make it work with 4.0.2? I can't get to work.

Thank you
Joe

CS-Cart 4.9.1


 
  • Onkel_Sid
  • Junior Member
  • Members
  • Join Date: 04-Sep 10
  • 301 posts

Posted 01 November 2013 - 08:28 AM #15

Sorry. I thought i had it working, but it turns out i was wrong.

If anyone with some coding skills could take a look at this and figure out what needs to be changed, it would be great. This is a very useful addon, and it works great on 3.0.6, but obviously needs some tweaking to work in 4.0.2.

Stop smoking start vaping: Dampskyen.no


 
  • akistdm
  • Senior Member
  • Trial users
  • Join Date: 09-Oct 11
  • 235 posts

Posted 25 March 2014 - 09:19 PM #16

have we got any news for the ver 4?

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 25 March 2014 - 09:25 PM #17

I have released it as a commercial addon Cs-cart Bells and Whistles Addon

Apart from Mailchimp this addon contains other features like :

Email Log
Order Listing - Backend
Display Customer nth order number on Order detail page - Backend
Search customers by phone number - Backend
Search orders by product name - Backend

So, should be a good bargain.
Cs-cart tips at shikhar.me

 

Posted 25 March 2014 - 11:32 PM #18

Deleted

Jeremy
Requin Creative Group
CS-Cart License | CS-Cart Addons


 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 26 March 2014 - 07:36 AM #19

Deleted


What do you mean ?
Cs-cart tips at shikhar.me

 

Posted 26 March 2014 - 01:21 PM #20

Deleted my response to the post as you have already addressed the update for CS-Cart 4.

Jeremy
Requin Creative Group
CS-Cart License | CS-Cart Addons