Add option to subscribe to AcyMailing at guest buy

Is there an easy way to have a tickbox in the address form which allows an opt-in on a certain AcyMailing?

I only sell without registration, so guest only.

utillis,
did you figure this out? might you be able to share the steps you took if you did?

Nope, so far I have added a custom check field at the end of the checkout procedure. So now my database has the information. However I would have to create a script which runs after a successful buy which verifies this field in the database and if true adds the emailadress and customer name to the AcyMailing table with the wanted list IDs.

Until now my focus has been on other stuff.

Although I would be willing to pay a small fee if someone can make that script, even if the configuration of tables and list IDs are not in a Joomla plugin or something.

I want to re-ignite this discussion. Does anyone have a solution for this yet?

I don't have one yet. Would be a nice one for freelance.com or something like that.

Hi,

This will require a custom plugin for such action.
So a PHP developer is required, you can post a request on our Commercial jobs section, there is potentially developers which can develop that for you.

Ok so I have done it (in a way). I am not at all a php developer so basically I went in search for a different solution, there are flaws in this solution (it takes the Subscribers Name from the first address created and it's a First Name only) but it will work in my situation and hopefully some others. Also worth noting that this solution copies the new user every 30 minutes... you can change this if you like by editing the query when creating the scheduled event.

The way to do it is via MySQL Event Scheduler Queries (5.1+). So here's how.
1. Login to your MySQL database and ensure that Event Scheduler is running by running the query:

SET GLOBAL event_scheduler =  "ON"

CREATE EVENT hikasub1
    ON SCHEDULE
      EVERY 30 MINUTE
    COMMENT 'Copies name from address to sub_user_name'
    DO
UPDATE 
    XXX_hikashop_user a, XXX_hikashop_address b
SET
    a.sub_user_name = b.address_firstname
WHERE
    a.user_id = b.address_user_id

CREATE EVENT hikasub2
    ON SCHEDULE
      EVERY 30 MINUTE
    COMMENT 'Copies from Hikashop to AcyMailing'
    DO
    INSERT INTO 
	XXX_acymailing_subscriber (name, email)
SELECT 
	sub_user_name, user_email FROM XXX_hikashop_user
WHERE 
	subscribe = 'Yes'
ON DUPLICATE KEY UPDATE
	subid=subid

CREATE EVENT hikasub3
    ON SCHEDULE
      EVERY 30 MINUTE
    COMMENT 'Sets timestamp on new subscriber row'
    DO
 UPDATE
	XXX_acymailing_subscriber
SET 
	created = UNIX_TIMESTAMP()
WHERE 
	created IS NULL

CREATE EVENT hikasub4
    ON SCHEDULE
      EVERY 30 MINUTE
    COMMENT 'Adds the new user to subscription list'
    DO
INSERT INTO 
	 XXX_acymailing_listsub (listid, subid, subdate, status)
SELECT 
	1, XXX_acymailing_subscriber.subid, XXX_acymailing_subscriber.created, 1
FROM
	XXX_acymailing_subscriber
ON DUPLICATE KEY UPDATE
	listid=listid

Yeah no worries. My solution is a little more user friendly because it only adds people if the say "yes" to subscribing, the AcyMailing auto plugin just registers everyone.