[contribution] Super Download Store

[AlexStudio]

Is it possible to add files to the directory and have them update on the order page for previously ordered bundles?

This can be done by adding custom code to update previous orders tables, currently SDS doesn't have this feature.

 

My next question is based on reading some other posts here... Is it possible to have *.exe's for the files available in the download directory with SDS?

Packing those .exe files into .zip or .rar is highly recommended. However, it is possible to have .exe files for download.

 

My final question is file size limitations... My files are typically 300mb - 1.5GB... Would SDS work with these files and if so what configuration would you recommend? I often use freedownloadmanager available at cnets download site...

That depends on the server capacity you have. Splitting large files (over 100mb) into smaller pieces is highly recommended. After all, SDS is designed to handle large download files in this way. You need to test downloading from your store and find out the largest single download your server can handle without problem. There are always users still using dial-up connections, and you have to think about how long it could take to download 1.5G files.

 

Oh one final question... I've seen two stores that have 'download' in their options with a file size listed next to the delivery options box... Does SDS add file size data to that box?

Yes, there is file size displayed next to the download button when SDS properly installed.

[fsdreamscapes]

This can be done by adding custom code to update previous orders tables, currently SDS doesn't have this feature.

 

Packing those .exe files into .zip or .rar is highly recommended. However, it is possible to have .exe files for download.

 

That depends on the server capacity you have. Splitting large files (over 100mb) into smaller pieces is highly recommended. After all, SDS is designed to handle large download files in this way. You need to test downloading from your store and find out the largest single download your server can handle without problem. There are always users still using dial-up connections, and you have to think about how long it could take to download 1.5G files.

 

Yes, there is file size displayed next to the download button when SDS properly installed.

 

Alex thank you... I'm in the Philippines right now and passed through Taipei on my way here a few months ago. Most of my users are Microsoft Flight Simulator users either in the USA or Europe I have a CD delivery option for everyone else... My internet here is bad, just got wireless internet installed at my place and my upload speed is a horrible 11kbps, unfortunately I nuked a 590mb file in all my messing around getting ready to install mods into osCommerce so back with another 24 hour upload session... Hopefully the ISP will come and fix my upload bandwidth tomorrow... Ok back on topic now...

 

Thanks for all the info, sounds good. Zipping my exe's actually will make the installer larger but that's not too much of an issue, I can also split the files into smaller chunks for other users. Download by redirect needs to be on though for me to use my downloader but it has downloaded fine, just gotta do an MD5 checksum once it's downloaded...

 

I'll have to figure out the whole PayPal IPN system as well... PayPals site was very cryptic in trying to find out how to set it up properly... Your mod looks like what I really need. I have to try and figure out a way to give my beta test team access to the files through a coupon or something...

 

Will give a shot at installing her now.... Looking forward to testing the whole thing out...

 

Also can I request permission to PM?

 

Sincerely

Dean Mountford

FS Dreamscapes

[AlexStudio]

I'll have to figure out the whole PayPal IPN system as well... PayPals site was very cryptic in trying to find out how to set it up properly... Your mod looks like what I really need. I have to try and figure out a way to give my beta test team access to the files through a coupon or something...

Please search in this thread for 'PayPal IPN' and you will find what needs to be done for SDS to work with it. However, I don't recommend using PayPal IPN with any coupon mod currently available because it can lead to unsolvable security issues.

 

Also can I request permission to PM?

Well, if you need to ask something in private, go ahead PM me. I'll see what I can do.

[fsdreamscapes]

Please search in this thread for 'PayPal IPN' and you will find what needs to be done for SDS to work with it. However, I don't recommend using PayPal IPN with any coupon mod currently available because it can lead to unsolvable security issues.

 

Well, if you need to ask something in private, go ahead PM me. I'll see what I can do.

 

Thanks Alex. Yeah I'll have to learn how to set up PayPal IPN from scratch then learn how to add it in to the loop. Good thing is I'm just starting out with my store so it's not live yet... I can probably just use FTP for my beta testers anyway...

 

I did want to report back that the install went flawlessly on RC1, I dropped the modded files straight in (my osc install was clean) and everything worked as it should. I was holding my breath for a bit waiting for an sql error but none came up :)

 

I've been at this for 4 days now preparing an online store. I learned one thing, lol backup your store on your server rather than downloading it all, works a heck of a lot faster :P

 

Ok I'll send you a PM, I'll probably do it tomorrow when I have a fresh mind... I think it's something that may interest you...

[fsdreamscapes]

Ok I've run into a problem. I just ran a test via manual credit card processing and manually updated the status to download now available...

 

Went into the test customer account and says the download is available, but there is no hyperlink to be able to download, it only shows the details...

 

Download links

 

FS Dreamscapes - 10m Mesh+ Arizona Link expires: Wednesday 19 December, 2007 5 downloads remaining

 

Did I miss something along the way?

[fsdreamscapes]

nevermind, user error... :P i'd created two instances of a download link within my file... All fixed now... :-)

 

now if only i can track down the bug in my download routine for a 300mb file that has caused it to come through corrupted... but thats off topic and not really anything to do with SDS...

Edited December 12, 2007 by fsdreamscapes

[fsdreamscapes]

Ok, Alex you are a genius... I figured out a way to get the SDS to do what I wanted it to do... I've got a whole series of files I want to include in packages but bring them online as they are developed and have the customer just log in to their account and view orders and grab the new files when they come in...

 

What I can do is set up dummy files in my download folder and then once the group is made I can delete the files for the products still in development. This way they show up on the users order sheet and once I upload the files to the server they will be able to download the files... I know it's a hokey way of doing it but it saves me a lot of work in the long run... What my test showed was that if I swap out the smaller dummy file for the larger master file when the file comes back online the file size is correctly updated in the users order download links :)

 

Alex thanks for this mod, I think it's really perfect for what I need... I'll pm you tomorrow on the other stuff...

 

Dean

[Merlisk]

If you want to offer 'free' downloads, why bother handle it through payment and checkout? Why not just put a link to the free downlad file in the product description?

 

I've not finished reading the thread, so I apologize if you've already addressed this, but I would also like to be able to allow free downloads after purchasing something else. The nice thing about your contribution is that I can allow for multiple files, but since it's set-up to only allow access to those files after manual intervention (updating the status), it's not quite what I need.

 

What would I have to alter to allow for immediate downloads after a purchase?

 

And, thanks again for your hard work.

[AlexStudio]

For SDS to work automatically, you need payment modules capable of updating orders status on payment complete. If you want to offer free downloads for physical item orders, you have to insert the downloads manually as an additional order without charge, or insert the downloads into the physical order directly from phpMyAdmin. Currently this part is not implemented in SDS, I'll work on it when I have time.

[Merlisk]

For SDS to work automatically, you need payment modules capable of updating orders status on payment complete. If you want to offer free downloads for physical item orders, you have to insert the downloads manually as an additional order without charge, or insert the downloads into the physical order directly from phpMyAdmin. Currently this part is not implemented in SDS, I'll work on it when I have time.

 

Thanks for the response.

 

I guess what I really need to do is to go to the final checkout screen and automatically override something to allow downloads when it sees a certain item, regardless of payment status.

 

Long story: the download is just convenience after ordering an account (disguised as an item in OSC.) My OSC mod goes behind the scenes and creates the account on another server. I just want the download right there after the order is complete instead of forcing the customer to go to another page for the download. Since this convenience download has multiple files, I was hoping to 'trick' your mod into doing what I need easily.

[fsdreamscapes]

Hi Alex...

 

I just wanted to say thank you for your excellent mod... Everything is up and working great...

 

I have a couple of noobish type questions...

 

1) would it be possible for me to get a programmer who could write a coupon code that would affect the price before SDS sees it? The reason is I have software I want to offer at an upgrade price for users who have previously bought my software.

 

2) in theory is it possible to run a cron job to update the tables for previous purchases to update the download links on my customers orders?

 

I'm still working on getting you that PM...

 

Dean.

Edited December 15, 2007 by fsdreamscapes

[AlexStudio]

Yes SDS works with discount/coupon contribs, so you can get a coder to make one for you, or try out some from the contributions.

 

Yes it is a good idea to run a cron job to update orders status once per day. Even more, if you're using 'download by redirect', you can also have a cron job to clean up symbolic links say every 2 hours.

[fsdreamscapes]

Yes SDS works with discount/coupon contribs, so you can get a coder to make one for you, or try out some from the contributions.

 

Ok so is it just the paypal ipn then that causes issues with coupons, as mentioned in an earlier post? I'm confused now

[AlexStudio]

Yup, it's PayPal IPN not to be used with discount/coupon contribs.

[deansp2001]

Im trying to install this add on but dont understand these part of the instructions:

 

STEP 3.2 - And then add new definitions to files list below: (Do NOT overwrite your existing files with the ones came with this package!!)

 

 

catalog/includes/database_tables.php

catalog/admin/includes/configure.php

catalog/admin/includes/database_tables.php

catalog/admin/includes/languages/english/products_attributes.php

 

 

What do I need to do?

 

Thank you

[AlexStudio]

There are new lines (definitions) need to be added into the files listed. You can find the new definitions in the SDS package stored in the corresponding directories.

[deansp2001]

Hi, I couldnt see the new definitions in the download....only new & modified files and the 2 sql files. am i missing something??

[sunshynevideo]

Im trying to install this add on but dont understand these part of the instructions:

 

STEP 3.2 - And then add new definitions to files list below: (Do NOT overwrite your existing files with the ones came with this package!!)

catalog/includes/database_tables.php

catalog/admin/includes/configure.php

catalog/admin/includes/database_tables.php

catalog/admin/includes/languages/english/products_attributes.php

What do I need to do?

 

Thank you

 

Open the files above that are included with the downloaded packaged and use a program such as winmerge to compare the difference between those and ones that you have.

[harikatt]

for downloading the link is not clickable.. and its showing default time stamp like this..

 

 

Link expires:

Wednesday 29 November, 2000

 

 

can u please help me.. as per my knowledge something to do with this line 49 at this code

 

 

 

// MySQL 3.22 does not have INTERVAL
  list($dt_year, $dt_month, $dt_day) = explode('-', $downloads['date_purchased_day']);
  $dty = intval($dt_year);
  $download_timestamp = mktime(23, 59, 59, $dt_month, $dt_day + $downloads['download_maxdays'], (int)$dty);
  $download_expiry = date('Y-m-d H:i:s', $download_timestamp);

[ayeronnie]

I must be an idiot.

 

I am trying to get a store going with only downloads, but I am not even how to add the downloads. I've created other stores and I know how to add products, but not downloadable ones. I've been messing with it, but it sure doesn't make sense. Seems some one one would have come up with a different solution by now. One where you could add the product, file name and mark it as download all on the add product page. Or is it just me?

 

I love the store software and sure appreciate the add-ons greatly! Just very surprised so one smarter than me hasn't made it a little easier.

 

Does any one know of a step by step how to add download products? I really am lost. Seems most people in this thread have more experience with download stores than me. :)

 

On the add product page, there is no place to put in the file name? Do I add the product then go to the product attributes page and mark every thing I add? Seems like an odd way to do it. I have added the header tags and extra image contributions and those are added to the add products page. Why not downloads? Just curious.

 

Thank you in advance.

[bkellum]

I must be an idiot.

 

I am trying to get a store going with only downloads, but I am not even how to add the downloads. I've created other stores and I know how to add products, but not downloadable ones. I've been messing with it, but it sure doesn't make sense. Seems some one one would have come up with a different solution by now. One where you could add the product, file name and mark it as download all on the add product page. Or is it just me?

 

I love the store software and sure appreciate the add-ons greatly! Just very surprised so one smarter than me hasn't made it a little easier.

 

Does any one know of a step by step how to add download products? I really am lost. Seems most people in this thread have more experience with download stores than me. :)

 

On the add product page, there is no place to put in the file name? Do I add the product then go to the product attributes page and mark every thing I add? Seems like an odd way to do it. I have added the header tags and extra image contributions and those are added to the add products page. Why not downloads? Just curious.

 

Thank you in advance.

ron,

Here is your step by step...

 

http://www.oscommerce.com/forums/index.php?showtopic=236224

[ayeronnie]

ron,

Here is your step by step...

 

http://www.oscommerce.com/forums/index.php?showtopic=236224

 

Thank you Bill!

 

Thats exactly what I was looking for. I tried searching at length, but some how never found your thread. I'm sure I am not the only one that really appreciates it!

 

I am still surprised that some one hasn't made it a part of the add product page. Seems it would make it so much easier to add downloads. Then again, I am no osc or php guru..:)

 

Thanks once again.

Edited December 29, 2007 by ayeronnie

[grpetz]

Hi Alex! Your super download store is great. I've been using it at our website now for about 3 months and have no complaints. I wonder if you or someone here might be able to pinpoint a problem that did develop. Whether or not it's related to your contribution I don't know. I have installed other contributions, so I don't know if something I did caused this or not... but here is the problem......

 

When I am on the products listing page that list all the downloadable products found in that category and I click on the 'buy now' button (though I changed my button to say 'add to cart')... after clicking the button instead of taking me to show that it has added it to the shopping cart , it instead takes me to the product info page... where I can then click 'add to cart' and it successfully adds it to the cart from that point. I don't experience this except with downloadable products, all other products are working corectly when you click on the 'buy now' from the table products listing.

 

Any suggestions of where to look and what to change would greatly help me a bunch. I hope this can be solved so there is no double clicking needed to add the downloadable products to the shopping cart. One of the add ons I've recently put on the site was 'purchase without account' contribution.

 

I hope you have a blessed new year in 2008 and thank you very much for your hard work.

 

Gary

www.lilybandmusic.com

[grpetz]

Hi Alex! Your super download store is great. I've been using it at our website now for about 3 months and have no complaints. I wonder if you or someone here might be able to pinpoint a problem that did develop. Whether or not it's related to your contribution I don't know. I have installed other contributions, so I don't know if something I did caused this or not... but here is the problem......

 

When I am on the products listing page that list all the downloadable products found in that category and I click on the 'buy now' button (though I changed my button to say 'add to cart')... after clicking the button instead of taking me to show that it has added it to the shopping cart , it instead takes me to the product info page... where I can then click 'add to cart' and it successfully adds it to the cart from that point. I don't experience this except with downloadable products, all other products are working corectly when you click on the 'buy now' from the table products listing.

 

Any suggestions of where to look and what to change would greatly help me a bunch. I hope this can be solved so there is no double clicking needed to add the downloadable products to the shopping cart. One of the add ons I've recently put on the site was 'purchase without account' contribution.

 

I hope you have a blessed new year in 2008 and thank you very much for your hard work.

 

Gary

www.lilybandmusic.com

 

I think I figured it out.... when I click on the 'buy now' in the products listing on my downloadable products it goes to the product info because I have product attributes set up on it... so naturally it goes there first to get the attributes set right before adding it to the cart... AHHHHHHH....

 

Have a happy new year everyone!!

 

Gary

www.lilybandmusic.com

[Guest]

I have just installed the store but cannot now access the admin section of the program. I get the following message:

 

<quote>

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '***'@'localhost' (using password: YES) in ****/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

<quote>

 

Can anyone help please? I have been so careful in installing the Store that I am puzzled at what has happened.

 

There has been no change to this particular file since original installation.

 

Thanks

 

Martin