Title: [Plugin: Subscribe2] subscriber category Last modified: August 20, 2016 --- # [Plugin: Subscribe2] subscriber category * [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/) * When I add new subscribers in WordPress, they are assigned to subscribe to all categories through subscribe2. * How can I change the code so that each subscriber added set to subscribe to the category with the same name as their User ID?? * Could you please tell me where in the code I make change so that each new subscriber added subscribe to the category with the same name as their User ID?? * Please help me.. deeply appreciate your help. * [http://wordpress.org/extend/plugins/subscribe2/](http://wordpress.org/extend/plugins/subscribe2/) Viewing 14 replies - 16 through 29 (of 29 total) [←](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/?output_format=md) [1](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/?output_format=md) 2 * [Matt Robinson](https://wordpress.org/support/users/mattyrob/) * (@mattyrob) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281041) * [@jbyungrokim](https://wordpress.org/support/users/jbyungrokim/), * Subscribe2 does not use category name, but ids. The name and slug can be changed whereas the id cannot (unless it is deleted). * For each user there is a usermeta field called s2_subscribed that contains a csv string of the subscribe user ids. There is also another field for each category that is s2_cat = id. So for category id 1 there is a field called s2_cat1 and the value is 1. * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281042) * okay.. then let’s say I have a category called “trial”. * what field values do I need to assign “trial” category to a user “John Doe”?? * Also, could you tell me the field name for Role?? I need to put “Administrator” under one field.. but import-users-from-csv plugin doesn’t quite say the field name for “Role.” * Thanks. * [Matt Robinson](https://wordpress.org/support/users/mattyrob/) * (@mattyrob) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281047) * [@jbyungrokim](https://wordpress.org/support/users/jbyungrokim/), * I can’t tell you what the ids of your own categories are – they are in your database. * I have no idea about this other plugin or how it works so I can’t tell you what you need to put for each heading. I guess that Role would be Administrator but I really don’t know as it’s not my plugin you are talking about now. Perhaps you should open another thread about the import plugin to get help on it. * [Ulrich Sossou](https://wordpress.org/support/users/sorich87/) * (@sorich87) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281048) * > Also, could you tell me the field name for Role?? I need to put “Administrator” > under one field.. but import-users-from-csv plugin doesn’t quite say the field > name for “Role.” * The field name is ‘role’, and you should put ‘administrator’ in lowercase. * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281060) * so do I need to specify s2_subscribed when importing new administrator users?? * but I have problem. I wouldn’t know user ID until I import them all. so what do I specify for s2_subscribed column?? * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281061) * I had below values: * user_login;user_email;user_pass;first_name;last_name;role;s2_cat1 zombiela;zombiela@gmail. com;111111;John;Kim;administrator;4 * s2_cat1 value of 4 belong to the category, “test_category”. * import was successfuly, but test_category option box was not checked. * what should I do in order to assign the category each of these users will subscribe to through this import process?? * I have assigned s2_cat1 to the value of the category ID, but it still doesn’t check it. * [Matt Robinson](https://wordpress.org/support/users/mattyrob/) * (@mattyrob) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281062) * [@jbyungrokim](https://wordpress.org/support/users/jbyungrokim/), * If you want these new administrator users to be subscribed to any categories in Subscribe2 then yes, you need to specify a s2_subscribed value when importing. * I would have thought the import plugin takes care of adding the meta values under a newly created user ID. * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281063) * how would i know s2_subscribed value when the users are just being added?? * any idea? * [Matt Robinson](https://wordpress.org/support/users/mattyrob/) * (@mattyrob) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281064) * [@jbyungrokim](https://wordpress.org/support/users/jbyungrokim/), * s2_subscribed is a comma separated list of the subscribed category IDs that you want the user subscribed to. * The s2_cat values should have the same number in the key and value, so: s2_cat1 = 1 s2_cat2 = 2 * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281067) * s2_subscribed s2_cat4 —————————— 4 4 * I had above values, and imported a user. But when I check back, not only category ID 4, but all categories were checked in option box. * So I deleted the user manually, but after this manually delete, import plugin is not working anymore. * I guess, I have to delete s2_subscribed and s2_cat4 also, but i don’t know where to go to delete these two manually. * Can you tell me where in MySQL table should I go to delete above two manually. * Also, why all categories are checked in option box when I did as you told me to do?? * [Matt Robinson](https://wordpress.org/support/users/mattyrob/) * (@mattyrob) * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281068) * [@jbyungrokim](https://wordpress.org/support/users/jbyungrokim/), * Those values are stored in the usermeta table. * I have no idea why all categories are checked, you are playing around directly with the WordPress tables and their values. This can be pretty risky and lead to duplicated keys and values, orphan values and corrupt databases. * Make sure you are backing up and being very careful * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 7 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281070) * i think my process will get done a lot easier if I import data manually to usermeta table directly.. * do you think I can add s2_subscribed and s2_cat(id) values directly to usermeta table alone.. and get the job done?? * csv based column by column mass import does not work out.. first of all, s2_cat( id) set up require many .. many columns for every single category i have.. * so it will be a lot easier if i import manually and directly to wordpress usermeta table.. * but my only concern is.. is there any other table involved beside usermeta table in assigning categories each user subscribe to?? * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 7 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281077) * I just added a post with an image. * eMail got delivered, but the email didn’t show the image on the original post. * How can I make the image show up in the email got delivered??? * Thread Starter [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * (@jbyungrokim) * [14 years, 7 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281085) * how do i update the code so that new subscribers added subscribe to all categories?? Viewing 14 replies - 16 through 29 (of 29 total) [←](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/?output_format=md) [1](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/?output_format=md) 2 The topic ‘[Plugin: Subscribe2] subscriber category’ is closed to new replies. * ![](https://ps.w.org/subscribe2/assets/icon-256x256.png?rev=2318630) * [Subscribe2 - Form, Email Subscribers & Newsletters](https://wordpress.org/plugins/subscribe2/) * [Frequently Asked Questions](https://wordpress.org/plugins/subscribe2/#faq) * [Support Threads](https://wordpress.org/support/plugin/subscribe2/) * [Active Topics](https://wordpress.org/support/plugin/subscribe2/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/subscribe2/unresolved/) * [Reviews](https://wordpress.org/support/plugin/subscribe2/reviews/) * 29 replies * 4 participants * Last reply from: [jbyungrokim](https://wordpress.org/support/users/jbyungrokim/) * Last activity: [14 years, 7 months ago](https://wordpress.org/support/topic/plugin-subscribe2-subscriber-category/page/2/#post-2281085) * Status: not resolved