Global Changes to Download Days and Counts?

If I have all of my download files set up for 10 Days and 5 Downloads and want to change all of my downloads to 7 Days and 7 Downloads, how do I do that?

I would really like to change them all at once. I'm hoping that I don't have to change each one individually because I have hundreds. LOL!

Thanks in advance! :smile:

Anyone? I'm really hoping that I don't have to change 800+ items one at a time. LOL! :)

Try
admin/configuration/attribute settings ?

misty:

Try
admin/configuration/attribute settings ?

I tried that and it changes it for new products but not all of the old products. So when I add a new product, it's right, but all of the previous products stay the same.

Thanks Misty :)

Then it's probably doable directly into/via database...you need zencart
dev i.e. ajeh, to explain how.
She wrote downloads for zencart.

misty:

Then it's probably doable directly into/via database...you need zencart
dev i.e. ajeh, to explain how.
She wrote downloads for zencart.
Thanks again, Misty! :)

The information on the number of days and download attempts is stored in the:
products_attributes_download

table and in the fields:
products_attributes_maxdays
products_attributes_maxcount

To change ALL existing Products with ANY download attributes to use the new values of 7 Days and 7 Download attempts you can run, from the Tools ... Install SQL Patches ... the following:

UPDATE products_attributes_maxdays SET products_attributes_maxdays= 7, products_attributes_maxcount = 7;

NOTE: Backing up your database is a good idea before doing this ...

Then, set your defaults to 7 Days and 7 Download Count for future referrence ...

Thank you, Linda!! :)

Linda, I just tried it and here are the errors I got:

Error Failed: 1

Error ERROR: Cannot execute because table products_attributes_maxdays does not exist. CHECK PREFIXES!

Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I was testing you ... yeah ... that's it ... testing you ... :cool:

See if this works better ...

To set Maximum Days to Download to 7 and Maximum Download Attempts Count to 10 ...

UPDATE products_attributes_download SET products_attributes_maxdays= 7, products_attributes_maxcount = 10;  

It worked like a charm! I hope I passed the test! :D LOL! Thank you so much!

Thanks for the update that this worked for you ... I got a little wild on the cut and past of the wrong code ... :blink:

Good luck with your cart and have a good holiday!