AC7 Job Scheduler screenshot

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
User avatar
calvis
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 710
Joined: Tue Jan 27, 2004 3:57 pm
Location: Redmond, WA

Re: AC7 Job Scheduler screenshot

Post by calvis » Wed Jan 28, 2009 12:22 pm

Hi Joe,

This is looking very nice. However, I want to give you some more ideas for added functionality especially on the subscription reminders. It would greatly expand the appeal of the subscription reminders if it was applicable to replinishable and perishable products. Here are some examples: calendars that need to be replaced each year, supplements that only last for 30 days, fire extinguishers that need to be recharged every 2 years, tax forms every year and so on. You get the idea.

Maybe for marketing purposes you can just call it Product Reminders.

SolunarServices wrote: 2. New feature: Subscription reminders. Site admin can now specify up to 4 reminder email templates to be sent at designated intervals prior to subscription expiration. This'll need some more love I'm sure, but the base code seems solid. I'm not all the familiar with selling subscription-based products so some customer input will be necessary to make it better.
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Wed Jan 28, 2009 12:46 pm

Very very nice.

Looking forward to it as you already knew!
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Wed Jan 28, 2009 12:56 pm

calvis wrote:It would greatly expand the appeal of the subscription reminders if it was applicable to replinishable and perishable products.
Awesome idea Calvis, thanks!

My solunar fishing/hunting times would be a great example. I don't sell them via subscriptions, but they are only good for 12 months. A way to "schedule" reminders for a specific product sale would be very useful.

I'll give that some good thought.

You do realize if you keep giving me these great ideas that this project will never get finished right? Robbie's gonna pop a vein soon if I don't get this done :lol:
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Wed Jan 28, 2009 1:24 pm

Way to go Calvis!

*falls over*
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
calvis
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 710
Joined: Tue Jan 27, 2004 3:57 pm
Location: Redmond, WA

Re: AC7 Job Scheduler screenshot

Post by calvis » Wed Jan 28, 2009 2:12 pm

**Robbie, slips Calvis a $50.00 Firefold gift certificate to entice Calvis to shutup**

I am glad you like the idea Joe - especially when it applies to your own business. Maybe you can put in Product Reminders at a later time so Robbie can start using the scheduler ASAP.

:twisted:
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.

User avatar
DelectablyYoursDecor
Ensign (ENS)
Ensign (ENS)
Posts: 9
Joined: Fri Aug 08, 2008 8:39 am
Location: Harrisburg, PA
Contact:

Re: AC7 Job Scheduler screenshot

Post by DelectablyYoursDecor » Fri Jan 30, 2009 9:35 am

I was thrilled to read these posts and can't wait for the product release. I am very interested in it!

Thanks... Gail

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Fri Jan 30, 2009 10:51 pm

I'm done testing abandoned basket reminders in my development environment. I'll push everything to Solunar.com this weekend and see what smokes.

The usefulness of the feature seems a bit in-question, at least on my Solunar.com site. I was a little surprised to see there aren't all that many people who have both registered with the site AND have basket contents. I was expecting much more, but the overall percentage is less than 3% per day on average. Got plenty of unregistered ones, but they have no email address so nothing can be done with them.

Anything is better than nothing - I'm sure higher-volume sites would benefit greatly from it. In my case, I've only been live for a year so I haven't built up much of that coveted repeat-business customer base.

Requiring registration for shipping estimates wouldn't fly - people would bail right away. Maybe I can entice registration with a free month of Solunar Fishing/Hunting Times - easy marketing and economical for me.

I guess I'll just have to grow some more :wink:
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Wed Feb 04, 2009 2:38 pm

I am back in the country.

For the abandoned baskets FireFold gets 30-40 per day. With more traffic comes more baskets.

How we doing Joe?!
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Wed Feb 04, 2009 3:16 pm

While you were away basking in the sun, I've been doing live testing on the final version.

Job scanning just stopped for no reason on the first day but it seems ok since then. A full restart of IIS seemed to resolve it and it hasn't occcured since then. Probably should have bounced IIS when I loaded up the new DLLs :roll:

I can already see how troubleshooting live installs could be difficult, so I'm going back and adding more logging to the system.

Otherwise this build seems pretty stable. No job crashes. Feed construction and upload is working like clockwork. 7-day follow up emails continue to flow smoothly with about 1 of 5 getting a thank-you response from the customer.

Just wish I could test abandoned baskets better - not enough on my site to do a solid test. I'll have to just fudge some existing user baskets so the system will generate some triggers.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Wed Feb 04, 2009 5:10 pm

Good to hear. Keep us updated!
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Mon Feb 09, 2009 4:18 pm

My weekly checkin!

How we doing Joe?
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Mon Feb 09, 2009 8:49 pm

Taxes :evil:
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Sun Feb 15, 2009 10:26 am

ok, firing taxes off to the accountant today - finally got that monkey off my back.

There's an odd date-math isssue going on in the abandoned basket feature. Going to work that out this morning. I will activate the abandoned basket feature this afternoon.

If anyone wants to help me test, feel free to drop by Solunar.com. You'll need to register with your site so there's an email to send messages to. Once you're registered, add a few random items to your basket and then just leave.

In an effort to test this a tad quicker, I'm going to set the intervals to 1, 2 and 3 days. So you *should* receive an abandoned basket notification tomorrow, Tuesday and a final one on Wednesday. The coupon code and final-reminder logic is all set up, so the last message should add you to a new group on the backend.

If doesn't work, all sorts of weird stuff is going to happen so I'll apologize in advance if you get 7,000 emails reminding you of your basket :P

I've seen a few quirks with the new feed builder code. The job gets stuck in "active" mode every once in a while. The job queue design is great though - if one job blows up, it doesn't mess up any of the other jobs or interfere with their processing. The blown-up job just sits there as "active" and doesn't get processed again.

I'll probably need to add some sort of admin alert that checks for jobs that are still active after like 60 minutes - at that point the job can probably be considered "stuck" and the admin should be notified.

Every time it's happened so far, the feed builder file was created on the server drive. That means the issue is most likely an FTP issue and not a programming one. The difficulty is there isn't much I can do for logging to troubleshoot it. Either it uploads or it doesn't. I'd say the job has stopped twice in the last 10 days, so that's not all that bad but still not completely "hands off".

Otherwise, it's sure been nice to have my Google feeds completely automated.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Sun Feb 15, 2009 10:53 pm

Sounds like you are getting there!

I added a few things to my cart. Looking forward to seeing those emails.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Mon Feb 16, 2009 6:34 am

Yeah. I did notice a multi-shipment order caused the followup reminder routine to bomb yesterday morning. Going to troubleshoot that today, probably a minor thing. I think that's the first multi-shipment order I've had since the module was installed.

The date-math issue is resolved as well.

The perfectionist in me is saying the overall design could be better i.e. more flexible. However I'm already 45 days behind schedule on release.

The time I spend redesigning all the classes was well spent - breaking up the code into more manageable pieces has greatly improved debugging.

I've also managed to still keep installation super-simple. A few SQL scripts to install the necessary table triggers and a replacement global.asax file. Everything else is all new DLLs and pages, so it should be a quick installation process.

This project turned out to be SOOOO much more than what I was thinking when I first started it :P
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Thu Feb 19, 2009 5:09 pm

Abandoned basket testing is now turned off.

Anyone who helped test it, thank you for your assistance.

I think I've got enough features added - time to draw up documentation and beta-test on some unsuspecting customer site........ :P
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

gunter
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 22
Joined: Thu Oct 02, 2008 9:43 pm

Re: AC7 Job Scheduler screenshot

Post by gunter » Fri Feb 20, 2009 2:26 am

Looks like this could be very impressive - well done!

We have a specific requirement that this might suit nicely if extended a bit.
We want to send out digital products to subscribers on a regular weekly basis (in fact a collection of digital products). They would need to be sent on an individuals timeline so every members would be getting their products at different times based on when they signed up.
For example
Week 1 get Digital Products abc1, abc2, abc3
Week 2 get Digital Products def1, def2
Week 3 get Digital Products ghi1, ghi2,ghi3,ghi4
etc - until the subsciption period has ended

The system would need to check for the subscription status incase it had lapsed or been cancelled before each delivery.
It would also be a great bonus if it could send an alternate email in the case of an elapsed/cancelled subscription - ie to entice them to come back as members.

Does this sound feasible?
Would anyone else be interested in such an idea?

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Fri Feb 20, 2009 7:43 am

I got the test emails from Joe. They did great!

We need a release!! :D
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Fri Feb 20, 2009 8:38 am

gunter wrote:Looks like this could be very impressive - well done!
Thank you. This project has taken far longer than I anticipated but I think it's taking shape very well now.
We have a specific requirement that this might suit nicely if extended a bit.
We want to send out digital products to subscribers on a regular weekly basis (in fact a collection of digital products). They would need to be sent on an individuals timeline so every members would be getting their products at different times based on when they signed up.
That certainly would be possible. The complexity involved would depend on how static the weekly product list is within your business. Checking existing subscriptions prior to transmission would be simple.
It would also be a great bonus if it could send an alternate email in the case of an elapsed/cancelled subscription - ie to entice them to come back as members.
I've already added a subscription reminder feature to this module. The site admin can specify up to 4 reminder messages to be sent at designated intervals BEFORE a subscription expires. Look through the previous posts in this thread for the screenshots - I believe the 3rd screenshot shows the subscription reminder setup.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

sdlong02
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Mon Jan 19, 2009 2:33 pm

Re: AC7 Job Scheduler screenshot

Post by sdlong02 » Wed Mar 25, 2009 12:51 pm

Did this never go live? :cry:

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Wed Mar 25, 2009 1:49 pm

I've shelved the project for a little while. When it does work, it's great. However when it has any issue at all, it's incredibly difficult to troubleshoot or debug. The entire design is server-side code, so nailing down where the problem lies is tough.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Wed Mar 25, 2009 2:23 pm

I did some testing with Joe - and he was right. It's great when it works, but can be a dangerous bomb if it doesn't behave correctly.

Hopefully he finds the time to get all the kinks worked out. I'd love to see it in full action one day.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

sdlong02
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Mon Jan 19, 2009 2:33 pm

Re: AC7 Job Scheduler screenshot

Post by sdlong02 » Fri Mar 27, 2009 10:03 am

Sorry to hear - I read through the post as you were testing it and the project was doing alot of the things I was looking for. Hopefully we will see this one dusted off in the future.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: AC7 Job Scheduler screenshot

Post by AbleMods » Fri Mar 27, 2009 12:06 pm

sdlong02 wrote:Sorry to hear - I read through the post as you were testing it and the project was doing alot of the things I was looking for. Hopefully we will see this one dusted off in the future.
I appreciate that very much.

I'm going to keep thinking about it. I'm at a loss as to how to implement an effective method for troubleshooting. All I can think of at this point is using TRY-CATCH all over the place with dozens and dozens of Logging entries. Maybe that's the only way :roll:
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: AC7 Job Scheduler screenshot

Post by Robbie@FireFold » Fri Mar 27, 2009 2:43 pm

SolunarServices wrote:
sdlong02 wrote:Sorry to hear - I read through the post as you were testing it and the project was doing alot of the things I was looking for. Hopefully we will see this one dusted off in the future.
I appreciate that very much.

I'm going to keep thinking about it. I'm at a loss as to how to implement an effective method for troubleshooting. All I can think of at this point is using TRY-CATCH all over the place with dozens and dozens of Logging entries. Maybe that's the only way :roll:
FireFold is here to help if you need it! Wish we could help with coding, but sadly out strong point is breaking stuff!
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

Post Reply