Import Mailing List

Store Builder Questions
1

Anybody know how specifically to import customer mailing lists into CS cart. I know how to import most things but don’t see that particular option.

2

I have contacted the support regarding import of subscribers:

here is answer:



In order to import the subscribers you should do the following:

  1. Delete all subscribers on the “Subscribers” page (the link to this page is under the “Content” tab) in your administration panel.
  2. Create the “restore.sql” file in the “var/database/backup” directory of your CS-Cart installation with the following content:

    INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘1’, ‘%SUBSCRIBER_1_EMAIL%’, ‘1265626941’);

    INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘2’, ‘%SUBSCRIBER_2_EMAIL%’, ‘1265626941’);

    INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘3’, ‘%SUBSCRIBER_3_EMAIL%’, ‘1265626941’);

    where %SUBSCRIBER_1_EMAIL% is the e-mail address of a subscriber, for example:

    INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘1’, ‘subscriber@mail.com’, ‘1265626941’);

    INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘2’, ‘subscriber2@mail.com’, ‘1265626941’);

    INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘3’, ‘subscriber3@mail.com’, ‘1265626941’);

    Log in to your administration panel, open the “Administration” tab and click on the “Database” link.
  3. Open the “Restore” tab, select the “restore.sql” file and click on the “Restore” button.

    Then I had also this question to support:

    Regarding subscribers import,

    how can I import subscribers if I have multipe mailing lists and the same subscriber can be subscribed to multiple mailing lists? Is it possible to atomate the process? thank you.

    The answer was:

    Unfortunately, there is no ability to automate it in standard CS-Cart. Some additional code modifications are required to realize such a feature. These modifications are not covered by our technical support service. We can offer you our custom development service. Our engineers can make this feature for you on a paid basis. Please let me know if you are interested in it and I will forward your request to our custom development specialist for an estimate.
3

Wow, this is a bit clunky. Anyone have a better way of getting lists imported?

4

WOW… I can’t believe that with the newsletter support the system has that you can’t easily import subscribers.

I mean MANY users here have a client base that existed before using CS-cart. You would think that it should be a priority to get those subscribers listed in the cs-cart system.

Currently I am using a 3rd party mail list provider, and although its features are great, I would be happier to move them into cs-cart… but it looks as if I might need to go the other way… that I will need to turn off the mail-list block on the site and migrate the users currently listed in it (a much smaller number that in the other system) to the 3rd party system and add a custom block for joining our mail-list.



what a pain!

5

Yes, there are much more robust newsletter managers, but I wanted the convenience of the built-in system for my clients. I spent the time formatting their user-base and importing into CS-Cart, and it has been working very well for us.

6

How did you do the import?

I have a few hundred in the cs-cart system, and few thousand to add to it.

I have a couple mail-lists setup. (retail, and wholesale)



any help would be much appreciated.

7

I exported the users from the original system and stripped them down to clean email addresses only. Then I set up a spreadsheet based on kocalka’s post below, with the same format:



INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘1’, ‘subscriber@mail.com’, ‘1265626941’);

INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘2’, ‘subscriber2@mail.com’, ‘1265626941’);

INSERT INTO cscart_subscribers (subscriber_id, email, timestamp) VALUES (‘3’, ‘subscriber3@mail.com’, ‘1265626941’);



If you’re crafty with find/replace and other spreadsheet tools, you can ease the pain a bit.



You can then import that into your database as noted, or directly with your mySQL tool of choice.

8

huh… I guess I will need to get things going on a test server for this… I won’t dare start messing around like this on my live site.

9

Most people are hesitant when starting out with db work. You’ll get less nervous after do a few imports and dumps.



Just always backup the db before making changes to it. Then you can quickly revert in the rare chance something breaks.

10

what I did in version pro 2.2.5 is: use the import for users feature and then add users to the subscribers list in the newsletter admin.



jorden