Product update notification issue

[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.

[lat9]

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.

[CaroleAs]

Thanks!

[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?

[lat9]

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.

[CaroleAs]

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?

[swguy]

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