Virtual Product Download Email Has Incomplete List of Products

[swaggerbear]

Hi there (again hehe). My Prestashop store is all done and ready and groovy. I've tested the payments live and everything's great. Except...

 

When I initially tested payments, I only bought one of my own products. I received my invoice, confirmation and virtual product download e-mail. Those all worked fine.

 

Being thorough, I just bought FOUR of my own products. I received my invoice, confirmation and virtual product download e-mail. HOWEVER...my invoice showed all four products I purchased, and the confirmation e-mail from PayPal showed all four products I purchased.

 

My virtual product download e-mail only showed the first THREE products I purchased. I did not get a link to the fourth.

 

I'm not expecting customers to come flocking to my site buying everything I offer in one fell swoop, but surely it's reasonable to assume that some customers might buy more than one thing at a time.

 

I can't tell if this glitch is only allowing the first three products to appear in the e-mail, or if for some reason it's subtracting one item from the total for orders greater than one item (i.e., a buggy "foreach"). Regardless, the customer needs to get 100% of the products they paid for.

 

Has anybody else encountered this?

 

Cheers!

Geoff.

 

Store: http://cranetraxmusic.com

 

 

Edit: I notice if I go into the "Order History" page, that while the same song that was missing from my Virtual Products Download e-mail appears, it doesn't have a link to be able to access the file (the rest of them do).

Edited August 19, 2013 by swaggerbear (see edit history)

[swaggerbear]

OMG I'm an idiot. The product in question didn't have an actual file attached to it under "virtual product". /facepalm

I do notice sometimes the link to the files I upload don't always appear consistent. Like, I'm 99% positive I uploaded a file but then I notice later that there's no file attached. I'm not 100% sure though so for now I'm closing this with a big blush on my face.

[touchdez]

Just as a matter of interest, a good idea would be to check your downloadable files periodically. For some reason some do disappear...

[swaggerbear]

Yeah thanks for that @touchdez. I poked around a bit after I posted this and saw that I'm not alone. This is a serious Prestashop instability I would say. We have to be able to rely on the integrity of those file pointers. Having them vanish for no explainable reason is very, very bad.

 

I found this guy's fix which I installed. I don't really detect any interface changes but hopefully it works. The page is in French but Google Translate does a decent enough job of giving the gist.

http://blog.manit4c....prestashop-1-5/

 

I also took the advice of the commenters and wrote the following SQL query I can use to keep an eye on the files. It was good because as soon as I ran it, I found a couple other missing files as well that I never would have caught otherwise. I've got over 200 products and I'd never find the gaps without it.

 

SELECT p.id_product, p.reference, p.uploadable_files, pd.id_product, pd.id_product_download, pd.filename, pd.display_filename, pd.date_add, pd.nb_downloadable, pd.active, p.is_virtual, pl.name FROM wyo_product p LEFT JOIN wyo_product_lang pl ON ( p.id_product=pl.id_product) LEFT JOIN wyo_product_download pd ON ( p.id_product=pd.id_product) WHERE pl.id_lang = 1

 

(Replace "wyo" with whatever table prefix your host used when you installed Prestashop.)

Edited August 20, 2013 by swaggerbear (see edit history)

[touchdez]

I will give that a try, thank you. The one thing I have noticed when uploading the virtual download was not to leave the page until the upload had completed, however long it takes.

[tomerg3]

You may want to try http://www.prestashop.com/forums/index.php?/topic/53511-module-batch-downloadable-product-upload-files-to-your-server-using-ftp-and-assign-them-to-products-making-them-downloadable-or-attachments/

 

It lets you upload files via FTP and mass assign them to products.