Product update notification issue

Just to be sure, because I have been tripped up in this very area:

The first command (Download Expiration = 0) changes *future purchases* to have unlimited downloads.

The second command (UPDATE orders_products_download...) changes *past purchases* of downloadable products to have unlimited downloads.

Quote:

---

Originally Posted by swguy

Just to be sure, because I have been tripped up in this very area:

The first command (Download Expiration = 0) changes *future purchases* to have unlimited downloads.

The second command (UPDATE orders_products_download...) changes *past purchases* of downloadable products to have unlimited downloads.

---

Yep and yep.

Thanks!

I have sent an update notification. One customer asked me to remove her from the emails since she no longer uses those products I sell. I know I can UNSUBSCRIBE her from the newsletter in her profile, but where can I remove her from product update notifications?

Quote:

---

Originally Posted by CaroleAs

I have sent an update notification. One customer asked me to remove her from the emails since she no longer uses those products I sell. I know I can UNSUBSCRIBE her from the newsletter in her profile, but where can I remove her from product update notifications?

---

What's the customer's "customers_id"? You can find that by navigating to the admin's Customers :: Customers tool and then searching by email address. The "customers_id" displays in the ID field in the table of results returned.

Quote:

---

Originally Posted by lat9

What's the customer's "customers_id"? You can find that by navigating to the admin's Customers :: Customers tool and then searching by email address. The "customers_id" displays in the ID field in the table of results returned.

---

I don't understand how it removes the contact from the product update notification list. Why do I need the customer_id?

@lat9 is going to give you a SQL command that requires on you knowing this piece of information.

First, I never received anything from lat9, but not biggies.

Now, I have other product updates. May I ask why one has to select the updated product if the notification is not sent specifically to the customers who purchased those products?

I think it makes sense to send it to everyone who opted to get the notification, but is that really what happens? I am surprised that from the thousands of customers in my store, only 37 would have opted for that (based on my last send).

Then, is it something that someone can opt-in without making a purchase? Can I send a note in my newsletter to encourage customers to go back to their account and opt in if they have not already?

Quote:

---

Originally Posted by lat9

What's the customer's "customers_id"? You can find that by navigating to the admin's Customers :: Customers tool and then searching by email address. The "customers_id" displays in the ID field in the table of results returned.

---

Quote:

---

Originally Posted by CaroleAs

I don't understand how it removes the contact from the product update notification list. Why do I need the customer_id?

---

Quote:

---

Originally Posted by swguy

@lat9 is going to give you a SQL command that requires on you knowing this piece of information.

---

Quote:

---

Originally Posted by CaroleAs

First, I never received anything from lat9, but not biggies.

Now, I have other product updates. May I ask why one has to select the updated product if the notification is not sent specifically to the customers who purchased those products?

I think it makes sense to send it to everyone who opted to get the notification, but is that really what happens? I am surprised that from the thousands of customers in my store, only 37 would have opted for that (based on my last send).

Then, is it something that someone can opt-in without making a purchase? Can I send a note in my newsletter to encourage customers to go back to their account and opt in if they have not already?

---

You never received anything from me because you never provided the customers_id that I'd requested in that first post.

A logged-in customer can opt-in without making a purchase from the product-notification block/sidebox when viewing a specific product ... depending on your template.

Quote:

---

Originally Posted by lat9

You never received anything from me because you never provided the customers_id that I'd requested in that first post.

---

Oh... I see. I was expecting a code that I would then, have to edit with the customer_id (so i can reuse it for other instances). Right now, I don't have that ID as I don't remember who it was (can't seem to find that email anymore).

Quote:

---

Originally Posted by lat9

You never received anything from me because you never provided the customers_id that I'd requested in that first post.

A logged-in customer can opt-in without making a purchase from the product-notification block/sidebox when viewing a specific product ... depending on your template.

---

I realized that I didn't even have that box. I added it and now that is clarified.

However, can you explain what is the point of using that box if the ones being notified might not even be customers who purchased that product?