Jump to content

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

Import Newsletter subscribers Rate Topic   - - - - -

 

Posted 13 March 2007 - 11:25 PM #1

Is there a way to import email addresses into newsletter subscribers?

At the same time, is is possible to keep CS-Cart from sending out subscription confirmation when I manually (or import) add addresses? I have a new cart, and I want to import 1000 emails from previous shopping cart. I'd prefer that the cart did not send out a confirmation when I enter the addresses. All of them have already subscribed to my old list.

Thanks!
Aaron

 
  • recedo
  • Senior Member
  • Members
  • Join Date: 24-Apr 06
  • 498 posts

Posted 14 March 2007 - 12:47 PM #2

The best bet would be directly through the database I guess.
Simon

Heavily Modded CS for MP3 Downloads - www.notsounknown.co.uk

 

Posted 14 March 2007 - 03:48 PM #3

Where are the email addresses for Newsletter stored? Nothing jumped out at me when I looked at db structure...

Aaron

 
  • glyndon
  • Senior Member
  • Members
  • Join Date: 07-Dec 06
  • 187 posts

Posted 14 March 2007 - 04:42 PM #4

Try the 'cscart_site_subscribers' table

 

Posted 14 March 2007 - 05:35 PM #5

Found it right after I posted...

Sorry to be thick, but unsubscribe key is required. I am able to import into db via SQL statement, but I do not have the unsub key. Won't it be required for the unsubscribe link included in each email?

If it is, does anyone have insight on how it is generated so I can create my own keys?

Thanks!

 
  • rob200
  • Junior Member
  • Members
  • Join Date: 02-Feb 07
  • 26 posts

Posted 14 March 2007 - 06:45 PM #6

Looking in addons/news_and_emails/include/include/customer/news.php (line 81) its just an md5 hash of a unique ID, so something like this in SQL would do (assuming you're using MySQL)...

MD5(RAND())

 

Posted 15 March 2007 - 01:38 AM #7

Thanks to all that helped. I was able to create a SQL statement and imported my emails into the site_subscribers table.

Aaron

 
  • zanimo
  • Junior Member
  • Members
  • Join Date: 04-Feb 08
  • 6 posts

Posted 26 March 2008 - 09:17 PM #8

I have the same problem

I am not familiar with SQL commands, what do I do to get

 

Posted 15 May 2008 - 07:21 PM #9

Hi rob200 and salukicentral would you mind describing how you have imported your subscribers list, and generating the MD5 hash codes for the unsubscribe key?

As far as sql goes I know how to access the tables and browse the information from cpanel, but thats about as far as my knowledge extends :?

 
  • sraza
  • Senior Member
  • Members
  • Join Date: 19-Dec 07
  • 141 posts

Posted 10 July 2008 - 12:46 AM #10

Was this information ever provided? Can it please be posted here as I have same issue - I have about 800 email addresses i need to import, some detailed instructions please as I am new to both cs-cart and sql.

(I do however follow directions carefully - most of the time anyways :-) )

Thanks,
sraza

 
  • RSW
  • Senior Member
  • Members
  • Join Date: 11-Nov 09
  • 175 posts

Posted 28 July 2010 - 05:05 PM #11

I too think this information would be of great value to all cs-cart users.
=======================
running on Apache 2 - CentOS

 
  • stavroch
  • Member
  • Trial users
  • Join Date: 15-Feb 16
  • 20 posts

Posted 23 February 2016 - 10:28 PM #12

Any news?



 
  • ThomH
  • Senior Member
  • Members
  • Join Date: 20-Nov 07
  • 1647 posts

Posted 24 February 2016 - 10:10 AM #13

Take a look at this solution: link


WebGraphiq offers a wide range of professionally developed, ready to use CS-Cart add-ons to provide additional functionality and boost your sales. The oldest active CS-Cart add-on development team. -- Since 2006 --


CS-CART ADD-ONS | FREE QUOTE | CS-CART DEVELOPMENT | @webgraphiq