×

info

Dear guests,
You are currently on the old forum we kept as a knowledge base. You will find the new community forum here
Welcome, Guest
Username: Password: Remember me
Keyword

TOPIC: HikaShop filter - Reminder / abandoned cart - when does it happen?

HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 2 months ago #52312

  • Anonymous user
  • cpaschen's Avatar
  • Posts: 51
  • Karma: 0
[Not really sure if this is an AcyMailing question or a HikaShop question, but because this is coming up in the AcyMailing filter area I'l ask here]

I'm trying to set-up an 'abandoned cart' email for HikaShop orders that haven't been paid in X-hours (I've already modified the timing of the cron process based on another thread here).

My question is which type of filter should I use?

1. HikaShop Orders - and then set the 'state' in 'created' for a certain amount of {time}

2. HikaShop Reminder (created x hours ago and not paid yet).

I've tried both options and it almost appears that there is a problem with the way that Hikashop classifies orders.

I know what option 1 does above, and it appears it actually won't produce an abandoned cart notice because HS never 'creates' the order until you've actually started into the payment process. (unless you are paying offline)

My question is how does the 'Reminder' (#2) filter type work?
Does it actually check for abandoned carts? Or is it just the same as #1?

If there is documentation for this please direct me as I couldn't find anything related to this very common eCommerce communication need.

Thanks
Please log in to post a reply

Re: HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 2 months ago #52331

  • Anonymous user
  • Adrien's Avatar
  • Posts: 20233
  • Karma: 681
Hello,

The "hikashop reminder" filter does the same as the first filter but also checks that there is no other order created after this one... to avoid sending duplicate messages.

So none of the two filters will actually meet your needs...

You should directly write the necessary query in our universal filter plugin:
www.acyba.com/en/component/content/artic...salfilter.html#query
Please have a look at our official documentation before posting a new message!

Do you like AcyMailing? We love your reviews!
We would appreciate if you could take 5 minutes to post a review on the Joomla! Extensions Directory.
We answered one of your question? Well, it's the best way to thank us!
Please log in to post a reply

Re: HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 2 months ago #52360

  • Anonymous user
  • cpaschen's Avatar
  • Posts: 51
  • Karma: 0
Unfortunately, Hikashop doesn't store the emails of users in a db table directly until after the order is processed (which is the problem in the first place). However, the user's email IS stored in the _sessions table, but it's just a part of all the text in the 'data' field.

Here's a sample of just a small section of that one session entry:
s:37:"price_value_without_shipping_with_tax";d:5932.5199999999995270627550780773162841796875;s:28:"price_value_without_shipping";d:5932.5199999999995270627550780773162841796875;s:27:"price_value_without_payment";d:5937.469999999999345163814723491668701171875;s:36:"price_value_without_payment_with_tax";d:5937.469999999999345163814723491668701171875;}}}}s:7:"zone_id";s:4:"4309";s:18:"checkout_fields_ok";i:1;s:15:"checkout_fields";O:8:"stdClass":0:{}s:7:"user_id";s:4:"1698";s:16:"shipping_address";s:4:"2793";s:15:"billing_address";s:4:"2793";}}}s:4:"user";O:5:"JUser":27:{s:9:"?*?isRoot";b:0;s:2:"id";s:1:"0";s:4:"name";s:13:"CHRIS PASCHEN";s:8:"username";N;s:5:"email";s:23:"user@mydomain.net";s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:6:"groups";a:0:{}s:5:"guest";i:1;s:13:"lastResetTime";N;s:10:"resetCount";N;s:10:"?*?_params";O:9:"JRegistry":1:{s:7:"?*?data";O:8:"stdClass":0:{}}s:14:"?*?_authGroups";a:1:{i:0;i:1;}s:14:"?*?_authLevels";a:2:{i:0;i:1;i:1;i:1;}s:15:"?*?_authActions";N;s:12:"?*?_errorMsg";N;s:10:"?*?_errors";a:0:{}s:3:"aid";i:0;s:10:"superadmin";N;s:3:"gid";s:1:"0";}s:13:"session.token";s:32:"c52329e1bd5baade9919752b08a1c8a0";}ck_submital|a:2:

The only option for AcyMailing appears to be the 'ExactAddress' option; however, I need to have the data for that type of filter automatically pulled from the session table and parsed, first to check to make sure the session entry is actually a hikashop cart (which is possible based on other data in the session record) and then to locate and grab the email address (which there is only the user's email address if it is a HS cart entry - although it does appear more than once in the session record).

So is there any way to modify the AcyMailing Universal plugin to do this?
OR
Would it be easier to just write an 'abandoned cart' plugin that pulls data from the session table and creates a unique table that AcyMailing can then act upon using the Universal filter?
Please log in to post a reply

Re: HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 2 months ago #52369

  • Anonymous user
  • Adrien's Avatar
  • Posts: 20233
  • Karma: 681
Hello,

In that case I would encourage you (or the Hikashop team!) to develop a new filter for that action only... you would not have to do anything with the Universal filter, the plugin would take care of creating the subscriber in AcyMailing and selecting it so then we could execute the actions we want on them.
I think that's the easiest solution... I definitely don't see an advantage in re-using our universal filter plugin for that.
Please have a look at our official documentation before posting a new message!

Do you like AcyMailing? We love your reviews!
We would appreciate if you could take 5 minutes to post a review on the Joomla! Extensions Directory.
We answered one of your question? Well, it's the best way to thank us!
Please log in to post a reply

Re: HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 1 month ago #53089

  • Anonymous user
  • cpaschen's Avatar
  • Posts: 51
  • Karma: 0
Well, we finally got the Hikashop data into an ALMOST usable format.

But we have the Cart table having a User_ID field that needs to be JOINed on the _hikashop_user table to be able to access the email address.

I've done some searching and I'm wondering if the UniversalFilter / Query would allow us to get at the data with a JOIN.
I tried to check here:
www.acyba.com/en/support/documentation/3...universalfilter.html

But the Query example graphics are not displaying, so I can't see what's possible.

Can you tell me if a JOIN is possible (and if you can get your sample query graphic working)?

If JOIN is not possible, then could you suggest an existing plugin that would be similar to this that I could look at as something to base a custom plugin on?
Please log in to post a reply

Re: HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 1 month ago #53090

  • Anonymous user
  • cpaschen's Avatar
  • Posts: 51
  • Karma: 0
BTW ... I did try this as a query:
SELECT a.user_email FROM nkvlr_hikashop_user a, nkvlr_hikashop_cart b WHERE b.user_id = a.user_id

But doesn't seem to do anything.

I have the Filters options set to:

Query
Email
In
... query above ...

AcyMailing List
Subscribe users to
Abandoned Cart list + Campaign

Should this query/filter work? Or am I hitting up against limitations of this filter plugin?

FYI ... the query DOES return a valid email when run directly within MySQL.
Last Edit: 7 years 1 month ago by Anonymous user.
Please log in to post a reply

Re: HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 1 month ago #53091

  • Anonymous user
  • Adrien's Avatar
  • Posts: 20233
  • Karma: 681
Hello,

Thanks for the bug report, I just changed that picture on our documentation.

Your query should do the job (you can indeed add a JOIN)... but it's a filter which means the user should be already created in AcyMailing first.
You may want to use the import system first (that you can automate with this same filter plugin) to make sure all your users are in the AcyMailing database.
Please have a look at our official documentation before posting a new message!

Do you like AcyMailing? We love your reviews!
We would appreciate if you could take 5 minutes to post a review on the Joomla! Extensions Directory.
We answered one of your question? Well, it's the best way to thank us!
Please log in to post a reply

Re: HikaShop filter - Reminder / abandoned cart - when does it happen? 7 years 1 month ago #53110

  • Anonymous user
  • cpaschen's Avatar
  • Posts: 51
  • Karma: 0
THANKS!
It seems to have worked (at least when manually processing the filter rules and queue).

Now to wait and see if these all work with the cron!

(When I get this fully tested I WILL document this ... this is much needed functionality for HS and AcyMailing marketers)
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 6 years 1 month ago #69880

  • Anonymous user
  • conticreative's Avatar
  • Posts: 5
  • Karma: 0
I am sorry to revive such an old post, but I need exactly the same thing and the promise to document the process is tantalizing as it would save me a ton of time.

Also, it makes me wonder if somehow the OP was not successful and I was getting myself into a very long project destined to fail.

Is there a tutorial for building this filter in ACY mailing?

Thank you.
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 6 years 1 month ago #69881

  • Anonymous user
  • cpaschen's Avatar
  • Posts: 51
  • Karma: 0
Sorry for not following up on this.

My client pulled the project so we never actually got it fully working. But that was almost a year ago.
There are a LOT of new functions in AcyMailing (i.e. filters) as well as updates to HS, so this should be at least a little bit easier now.
Unfortunately, I don't have any reason to build and test at this point.
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 6 years 1 month ago #69882

  • Anonymous user
  • conticreative's Avatar
  • Posts: 5
  • Karma: 0
Thank you so much for replying. I wasn't expecting a reply so soon.

NBot to worry, I know how these things go. I am totally new to ACYmailing so I have to start learning from scratch. At the hikashop forums for the past couple of years they have answered questions like mine with a link to the filter tutorials. But even today I doubt that the built in filter in ACYmailing can handle abandoned cart emails out of the box like that.

Heck, I don't even see where I can setup a CRON yet.

In any event, if you remember anything useful or you have notes or know of a tutorial that may help, I'd be grateful. If not, don't worry, the fact alone that you replied was very welcome.

PS: if you are interested in a quick job helping me set this up, let me know. My partner has to leave town because his mother died so I a,m now alone trying to do the job of two people. My client would be happy to pay someone to help me with this.

Take care and thank you again.
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 6 years 1 month ago #69885

  • Anonymous user
  • cpaschen's Avatar
  • Posts: 51
  • Karma: 0
I've been working with AcyMailing for a few years now and Hikashop for about 2+.
GREAT combination of features.

If you need help on a project feel free to contact me off-list.
You can find my contact info at my web site (www.PaschenCommunications.com).
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 6 years 1 month ago #69934

  • Anonymous user
  • Adrien's Avatar
  • Posts: 20233
  • Karma: 681
Hi,

It's not about abandoned cart but orders which are not paid... (it's a bit different) but there is a step by step for that:
www.acyba.com/acymailing/388-automatic-r...s-with-hikashop.html
Please have a look at our official documentation before posting a new message!

Do you like AcyMailing? We love your reviews!
We would appreciate if you could take 5 minutes to post a review on the Joomla! Extensions Directory.
We answered one of your question? Well, it's the best way to thank us!
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 3 years 8 months ago #106008

  • Anonymous user
  • PolishedGeek's Avatar
  • Joomla eCommerce & Web Development Experts
  • Posts: 3
  • Karma: 0
Has anything ever been built to allow email followup for abandoned carts, when no order is created yet but the user has left the HikaShop site with orders in their cart?
~ Deb Cinkus, CEO
Polished Geek LLC

Joomla Web Development & eCommerce Experts
Certified eCommerce Marketing Specialist
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 3 years 8 months ago #106047

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
Hi !

Feel free to take a look at this documentation which give you all the information you need ;)
www.acyba.com/acymailing/388-automatic-r...s-with-hikashop.html
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 3 years 8 months ago #106076

  • Anonymous user
  • PolishedGeek's Avatar
  • Joomla eCommerce & Web Development Experts
  • Posts: 3
  • Karma: 0
Thanks, but this documentation only refers to sending reminders once an ORDER is created in HikaShop, but not paid yet. I was inquiring about whether anything has been built that pulls from the saved carts area of HikaShop, for people who have put items in their cart but left the site before the order was created.
~ Deb Cinkus, CEO
Polished Geek LLC

Joomla Web Development & eCommerce Experts
Certified eCommerce Marketing Specialist
Please log in to post a reply

HikaShop filter - Reminder / abandoned cart - when does it happen? 3 years 8 months ago #106120

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
Hi,

Thanks for your feedback and my apologies for misunderstanding your previous message :)

There is no way to do this by using our Hikashop plugin as this feature isn't included in it however you can use our universal filter to create your own query and execute actions based on this query.
www.acyba.com/acymailing/309-acymailing-...universalfilter.html
Please log in to post a reply
Time to create page: 0.084 seconds
Powered by Kunena Forum