MrBaseball34 Posted July 23, 2010 Share Posted July 23, 2010 We are planning a site that offers a downloadable report based on data consolidated from different public and private sites (with permission, of course).This seems to be the workflow but I have some questions, see them below marked enclosed in [].Scripts build_report and pr_report are done but will need some tweaking to work in this workflow.Can someone that has done digital downloads before help out here?[pre]1. User selects a item in store, if there is no item they enter an item number to build a report for. [No brainer - will build form for that and add to theme]2. User pays for item. [No brainer]3. Upon Paypal or Google Checkout confirmation... [How is confirmation for these handled in PS?]4. Add entry into database that report is ready to be generated/sent. This script also checks to see if a report has already been generated that is not > 14 days old. If a report is already made < 14 days, then flag as available, otherwise flag to generate. [When would this be done? Directly after confirmation but how to know?]5. Script check_report.php opens the database table with records showing all reports to be generated or sent. Loop through records and... Then script build_report.php is called to consolidate the data for the report into our database, and then hands off the item number to pr_report.php to build the actual report. [should I use exec() or call the other scripts using file_get_contents(), would need to know that the data is actually stored before trying to call pr_report script]6. Report is then moved to a special download folder and entry into database that file is ready for download. [No brainer, done at the end of pr_report script]7. Email is sent to user that file is avail for download with link to report in download folder. [No brainer, done at the end of pr_report script][/pre] Link to comment Share on other sites More sharing options...
MrBaseball34 Posted July 27, 2010 Author Share Posted July 27, 2010 WOW, 55 views and not one of you has done digital downloads? Link to comment Share on other sites More sharing options...
MrBaseball34 Posted July 28, 2010 Author Share Posted July 28, 2010 And another 30 views, I guess nobody does digital downloadable product, do they? Link to comment Share on other sites More sharing options...
MrBaseball34 Posted August 3, 2010 Author Share Posted August 3, 2010 OK, up to 159 views and still no one does digital downloads. What a joke. I've been busting my chops trying to help other people on this forum and this is the thanks I get? I help out as much as I can because this is supposedly a PEER support group. That is quite obvious to me because PrestaTeam is nowhere to be found. Maybe this was posted in the wrong forum?Can anyone throw me a bone, here, I'm hanging on a thread trying to get this thing working. I've spent the last week trying to get PP and GC working; PP, OK, GC, not yet.1. PS requires, in the BO, for you to enter a filename for downloadble products. If my product is dynamically generated, how am I supposed to do that? 2. If the do not see the product in the product list, they may search for it, I plan on modifying the search to show a form that they can enter a new part number for the report to be generated if it is not found. I need to add this report to the products list. I have code to add products to the products table but this report also needs to be added to the user's cart. If a product is not in the Smarty $products variable which is where the cart get's its info on the product, this means that it was added to ps_product "outside" the normal PS means, how can I do this?3. Should I intercept the completed transaction in the PaymentModule class’s validateOrder() function or in each payment method's validateOrder function?4. I don't yet have an SSL cert for my site. How can I test Google Checkout without https links?Got a few more but this is to start. I'd really appreciate it if ANYONE can help out here. Link to comment Share on other sites More sharing options...
Dusty Posted August 3, 2010 Share Posted August 3, 2010 Hi,Don't think I can help with digital products but I have run GC successfully on an OS Commerce site without an SSL cert for some years now. It just means that your back office is not notified by GC. You do however receive emails from GC with customer order details etc and the option to proceed with billing the card they used. Once you have set up a GC merchant account you can go ahead and play around in GC Sandbox. I'm having considerable trouble getting GC to work with Prestashop 1.3.1. as it will not post order details (size & Colour)with the order. Have posted to bugtracker but no one seems interested. I have also posted to find if anyone is using GC with 1.3.1 but not one taker. Forum is very disappointing. I would guess it is not a priority as it is only available to US & UK merchants. Hope this is of some help. Link to comment Share on other sites More sharing options...
MrBaseball34 Posted August 3, 2010 Author Share Posted August 3, 2010 Well, in my case, it is IMPERATIVE that I get a reply back from GC. Although I *could* write an IMAP handler to intercept the emails from GC, I'd rather do it in one place where it would handle both PP and GC transactions. Link to comment Share on other sites More sharing options...
MrBaseball34 Posted August 3, 2010 Author Share Posted August 3, 2010 Oh, BTW, I share your sentiments about the forum. It is a joke that so many questions go unanswered. If they wanted to set themselves apart from the pack, they should actually support the product. What I would do is make all the developers take a turn on the forums, kind of like being "on-call"That way, you keep a higher profile and your customers don't get frustrated. Link to comment Share on other sites More sharing options...
Azurafiles Posted January 9, 2011 Share Posted January 9, 2011 agree, in most cases the forum support is a joke here.Such a shame, because I had such high hopes for this os Link to comment Share on other sites More sharing options...
adamus007p Posted January 25, 2011 Share Posted January 25, 2011 4. I don’t yet have an SSL cert for my site. How can I test Google Checkout without https links?use openssl and create yourself for freei won't work without ssl, you can add exception in your browser, but better to add ssl certificate Link to comment Share on other sites More sharing options...
Robert G. Posted January 25, 2011 Share Posted January 25, 2011 3. Upon Paypal or Google Checkout confirmation... [How is confirmation for these handled in PS?][/pre] With regards to PayPal: This is done through an IPN (Instant Payment Notification) handler. Once a transaction goes through, PayPal sends a POST to the PayPal payment module's IPN handler, which in turn loops through the POST, sends it back to PayPal for validation. If PayPal replies "VERIFIED", the transaction is deemed genuine and not tampered with.More info on IPN: https://www.paypal.com/ipn/We are planning a site that offers a downloadable report based on data consolidated from different public and private sites (with permission, of course).This seems to be the workflow but I have some questions, see them below marked enclosed in [].Scripts build_report and pr_report are done but will need some tweaking to work in this workflow.Can someone that has done digital downloads before help out here?[pre]4. Add entry into database that report is ready to be generated/sent. This script also checks to see if a report has already been generated that is not > 14 days old. If a report is already made < 14 days, then flag as available, otherwise flag to generate. [When would this be done? Directly after confirmation but how to know?][/pre] Save a DATETIME along with the report and calculate current time vs datetime time would be the easiest to implement. Available can be a simple bool value. Either way, you'll be looking at extending your existing database scheme for this to work. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts