Viewing Products with Digital Download Attachments

[JulieandBlu]

I am not sure how to word this, but I would like to know if there is a way to see all your products at once - as in a list - as well as the attachments? (v 1.5.6.2 by choice)

 

I sell download products, and I would like to see a list of all the products, so I can check to see if the download file is attached rather than go through each product individually and look at the Virtual Product tab.

 

I found that sometimes the attachment doesn't get attached, and I want to ensure the integrity of my site. In other carts, I have the ability to check the files by getting a list of the products with their attachments, and I was hoping I could do this under the stats section, but the catalog evaluation does not show the attachments.

 

Is this even possible?

 

Thanks

[bellini13]

The way I go about this is to execute the following 2 queries.  In PS v1.5+, you can use the Advanced Parameters > SQL Manager to add these queries and then execute it any time you want.

 

 

This query says "Locate any active products that are not virtual.".  I only sell virtual products, so this should always be empty.  Sometimes I forget to attach the file, and when that happens, the product would appear when executing this

SELECT * FROM `ps_product` WHERE `active` =1 AND `is_virtual` =0

This second query says "Find any products where the file name is empty".  There is a weird bug where sometimes you edit a product, and the file name gets wiped out, even though the product "is virtual".  So this list should always be empty.

SELECT * FROM `ps_product_download` WHERE `display_filename` IS NULL or `display_filename` = ''

[JulieandBlu]

 

The way I go about this is to execute the following 2 queries.  In PS v1.5+, you can use the Advanced Parameters > SQL Manager to add these queries and then execute it any time you want.

 

 

This query says "Locate any active products that are not virtual.".  I only sell virtual products, so this should always be empty.  Sometimes I forget to attach the file, and when that happens, the product would appear when executing this

SELECT * FROM `ps_product` WHERE `active` =1 AND `is_virtual` =0

This second query says "Find any products where the file name is empty".  There is a weird bug where sometimes you edit a product, and the file name gets wiped out, even though the product "is virtual".  So this list should always be empty.

SELECT * FROM `ps_product_download` WHERE `display_filename` IS NULL or `display_filename` = ''

Awesome Bellini13 - This is exactly what I was looking for, and it promptly gave me two out of 400 that had dropped the product. I would have pulled my hair out trying to find them

Thank you SO much.