Profile: joster
User posts
Hello-
After using the customer reminders plugin successfully for a few weeks, we are now getting errors in log:
Error while running the 'Customer Reminders Task' schedule task. An error occurred while executing the command definition. See the inner exception for details.
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- End of inner exception stack trace --- at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClassb.<GetResults>b__9() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() at System.Lazy`1.CreateValue() at System.Lazy`1.LazyInitValue() at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source) at Nop.Services.Customers.CustomerService.GetCustomerBySystemName(String systemName) at Nop.Web.Framework.WebWorkContext.get_CurrentCus
Hi-
We've configured a reminder that asks the customer to return to our site and review the products they purchased. Within the message body we include a link to the www.mydomain.com/orderdetails/ view using the %Order.OrderNumber% token so they can see a link to each item and review it.
When the customer clicks the link in their email, they are prompted to login..I suppose already logged in customers wouldn't be prompted, but the issue is that my customers who used Guest Checkout (80% of them or more) do not have login information, and therefore cannot access the orderdetails.
Can you suggest a way for me to be able to display links to each of the products a customer has ordered that won't force them to login first?
Thanks!
Hello-
I think there is a bug with version 3.20 that causes the customer reminder to not be sent to the store admin or the BCC......but only when the domain of the email address is the same as the domain of the nop site. (www.mydomain.com and @mydomain.com)
When we would try a test order with our email address (same domain as the nop domain), we would not receive the reminder, so we thought no customers were receiving them either...this is not the case.
If I change the BCC on the reminder to an address with @gmail.com or other domain, it sends the email successfully.
And if I check out as a customer with an email address other than the same as the nop domain, it sends successfully.
Also, I should add that all other messages configured in our message templates use the same send from email address, and we do receive those without a problem.
Thanks-
I am still having trouble getting our customer reminders to work on our website (version 3.20)
On our development site I set up a customer reminder to send to completed orders to ask them to write a product review. It is absolutely enabled, and it seems to execute at the right interval, and appears in the message queue as having been sent...but neither the customer nor the BCC ever receives it??
Hi joster,
Probably there is some problem with the email accounts setup in your store. All the emails from the Customer Reminders are added to the Message Queue and there is a separate scheduled task in nopCommerce that sends the emails. So you can check the System -> Message Queue for any emails that are not sent.
Also, our AbandonedCart reminder doesn't send messages at all. All I did was enable it...I changed none of the configuration values. I don't even see these in the message queue...
My product review reminder does show in the message queue as having been sent successfully...but neither the customer or us (BCC) receives it. We do receive all other emails generated by the website, so do not understand what the problem could be.
No, for testing purposes, we logged in with various customer test accounts and created orders in which we closed the browser while checking out...but no AbandonedCart reminders ever appear in message queue ...sent or unsent....
Frustrated...
OK...here is an update on my issue with this plugin.
It turns out that our customers are receiving them, but the store admin and configured BCC do not.
When we would try a test order with our email address (same as nop domain), we would not receive the reminder, so we thought no customers were receiving them either...this is not the case.
I think there is a bug that causes the customer reminder to not be sent to the store admin or the BCC......but only when the domain of the email address is the same as the domain of the nop site.
If I change the BCC on the reminder to an address with @gmail.com or other domain, it sends the email successfully.
And if I check out as a customer with an email address other than the same as the nop domain, it sends successfully.
Also, I should add that all other messages configured in our message templates use the same send from email address, and we do receive those without a problem.
Please respond so that I don't feel compelled to re-post this in the bugs category...
Thanks-
(Too late...I posted it in bugs)
I am still having trouble getting our customer reminders to work on our website (version 3.20)
On our development site I set up a customer reminder to send to completed orders to ask them to write a product review. It is absolutely enabled, and it seems to execute at the right interval, and appears in the message queue as having been sent...but neither the customer nor the BCC ever receives it??
Hi joster,
Probably there is some problem with the email accounts setup in your store. All the emails from the Customer Reminders are added to the Message Queue and there is a separate scheduled task in nopCommerce that sends the emails. So you can check the System -> Message Queue for any emails that are not sent.
Also, our AbandonedCart reminder doesn't send messages at all. All I did was enable it...I changed none of the configuration values. I don't even see these in the message queue...
Is it possible that there are no abandoned shopping carts?
Thanks
My product review reminder does show in the message queue as having been sent successfully...but neither the customer or us (BCC) receives it. We do receive all other emails generated by the website, so do not understand what the problem could be.
No, for testing purposes, we logged in with various customer test accounts and created orders in which we closed the browser while checking out...but no AbandonedCart reminders ever appear in message queue ...sent or unsent....
Frustrated...
Hello again-
I am still having trouble getting our customer reminders to work on our website (version 3.20)
On our development site I set up a customer reminder to send to completed orders to ask them to write a product review. It is absolutely enabled, and it seems to execute at the right interval, and appears in the message queue as having been sent...but neither the customer nor the BCC ever receives it??
Also, our AbandonedCart reminder doesn't send messages at all. All I did was enable it...I changed none of the configuration values. I don't even see these in the message queue...
Suggestions?
Yes, that is very helpful. However...
Today, while checking things in the admin area of our development site, where I am configuring this reminder, I found something that makes me sick to my stomach!
I clicked on the Customer Reminders Messeges Report to see what it looks like, and see hundreds of SENT reminder messages...to all of my customers this month...this makes me sick because the message template was not even complete.
There have been ZERO orders on this dev site, so even though the customer reminder was enabled, it should not have sent anything to anyone!!!!
Our production site has been live for 3 weeks. The database on my dev site is a backup from my production site from about 2 weeks ago.
It seems to have sent a message to every customer who ever placed an order, though there have been no orders on this development site at all, so it seems like it was just "catching up" by sending to anyone who hadn't yet been sent to.
How can this happen?????
On my customer reminder, I will ask for customers to return to my website to post a review for the products they ordered. I want it to be very easy for them.
I see that %Order.Product(s)% token is available in the message template.
I suppose this will make a list of each product in that order?
Will the list be the product names only, or will they be links to the product pages? (this is what I need)
Also, I want to configure it to only send to customers who have received their shipment and had time to use the product..21 days from date of the order...
I am not clear about how I should configure the time intervals.
It's like this...
The task needs to run every day and just send reminders to those customers who ordered exactly 21 days earlier.
How would I set that up?
Thanks,
Steve
posted in wrong forum...sorry
OK...well...I spoke too soon.
Error
The log entry message.Short message: The parameters dictionary contains a null entry for parameter 'productPageId' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult RetrieveProductRibbons(Int32, Int32[])' in 'SevenSpikes.Nop.Plugins.ProductRibbons.Controllers.ProductRibbonsController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter.
157.55.32.89
Name of the customer who caused the exception.Customer: builtin@search_engine_record.com
Originating page of exception.Page URL: http://www.myfootshop.com/productribbons/retrieveproductribbons
The referrer URL.Referrer URL:
Date/Time the log entry was created.Created on: 1/14/2014 3:35:25 AM
