Jump to content

MediaHound

Members
  • Content count

    58
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    MediaHound
  1. Hi, This is a great contribution. I have just installed it and it works great. My shop uses MVS - Multi Vendor Shipping, so I had to merge the two modifications in the places where they overlapped in /admin/categories.php There were two queries that needed to be merged, these are the two, in order as they appear in the instructions. $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, pd.products_keywords, pd.products_metadescription, pd.products_pagetitle, p.products_id, p.products_quantity, p.products_model, p.vendors_prod_id, p.products_image, p.products_price, p.vendors_product_price, p.products_weight, p.vendors_prod_comments, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.vendors_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); Above is the first one you will encounter, this code is the merged query, use this instead. Below is the second one you will encounter. This code is the merged query, use this instead. $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, pd.products_keywords, pd.products_metadescription, pd.products_pagetitle, p.products_quantity, p.products_model, p.vendors_prod_id, p.products_image, p.products_price, p.vendors_product_price, p.products_weight, p.vendors_prod_comments, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, p.vendors_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); I have updated the contribution with the modified /admin/categories.php to merge it with the MVS hack. I think these two queries were all that was needed (along with some common sense as far as arranging things goes) but I have included the complete merged file as it works on my site in the contrib. I hope it helps someone and I'm not liable if it breaks your site! You may not need to, but it may be advisable to test on a non-production site first! If anything, maybe just use it as a guide as you merge your files as you have them on your particular shop.
  2. MediaHound

    Quickbooks Merchant Service v1.0

    I can tell you that I never filled this page out: http://developer.intuit.com/membership/MPC...Application.asp This is where you should add your app info: http://appreg.intuit.com/AppReg.aspx (click add) Once you do, you should see it listed here, and it will show you your appid: http://appreg.intuit.com/
  3. MediaHound

    Multi_Vendor_Shipping new thread

    Yes, Nigel, you have to setup a totally different shipping module for each vendor. Some can have a table rate by number of items, some can have a table rate by weight, some can have a per item charge, etc. MVS allows you to assign many types of shipping charges, then everything gets added up together at the checkout for the customer to make one payment.
  4. MediaHound

    Quickbooks Merchant Service v1.0

    See post #7 for the code inside intuit.php Cheers
  5. MediaHound

    Quickbooks Merchant Service v1.0

    Your URLS will probably look something like this: Subscribe URL: https://www.putyourdomainnamehere.com/intuit.php Change URL: https://www.putyourdomainnamehere.com/intuit.php Cancel URL: https://www.putyourdomainnamehere.com/intuit.php Login URL: Marketing URL: (The last two are blank)
  6. Brilliant! It's in popup_image.php in my installation. It's a brilliant solution, but it distorts many of the pictures as the scale is thrown off. My site(s) use various sizes of images for the products, its too varied to be able to say that 450 will work for all of them. Especially since the height and width are not kept with constrained proportions by doing this.
  7. MediaHound

    Using OSC for eBay Checkout

    Hi Kenja, Did you figure this out? Were you able to set it up, and if so, could you share it with me? Thanks
  8. MediaHound

    Ebay checkout

    Hi Oskar, Did you set this up, and if so, how did you do it? Thanks!
  9. Thank you for pointing this out.
  10. Excellent mod, thank you very much! /clicks install and subscribe to thread :thumbsup:
  11. MediaHound

    Quickbooks Merchant Service v1.0

    If you get this error in your /tmp/curlerrors.txt * About to connect() to webmerchantaccount.quickbooks.com:443 * Connected to webmerchantaccount.ctcfe.quickbooks.com (12.149.175.48) port 443 * error setting certificate verify locations * Closing connection #0 make sure to give the webserver permissions to read from /your/path/to/usr/share/ssl/certs/ and permission to read /your/path/to/usr/share/ssl/certs/intuit.cer
  12. MediaHound

    Quickbooks Merchant Service v1.0

    intuit.pem should look something like this: -----BEGIN RSA PRIVATE KEY----- keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo keyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfokeyinfo -----END RSA PRIVATE KEY----- -----BEGIN CERTIFICATE----- certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo certinfocertinfocertinfocertinfocertinfocertinfocertinfocertinfo -----END CERTIFICATE-----
  13. MediaHound

    Quickbooks Merchant Service v1.0

    One thing I will suggest is to use a path for the ticket to be created in a place most people will have access to. I wrote it to /tmp and luckily I can access /tmp but I can see this being a problem for most users. intuit.php <?php //This script is accessed by Intuit's QBMS to return data from a request. $PHP_ConnectionTicket = $_POST['conntkt']; $PHP_AppData = $_POST['appdata']; $PHP_AppID = $_POST['appid']; $handle = fopen("/tmp/ticket.txt", "w"); fwrite($handle, $PHP_ConnectionTicket."\n"); fwrite($handle, $PHP_AppData."\n"); fwrite($handle, $PHP_AppID."\n"); ?> I presume that some people might need to change line 8 to a location thats not prevented access with a jail or cage...
  14. MediaHound

    Quickbooks Merchant Service v1.0

    ok I got further This is the URL I used for the confirm app http://merchantaccount.quickbooks.com/j/sd...p;appdata=10001 I was using the https://login.ptc.quickbooks.com/j/qbn/sdka...p;appdata=10001 URL but that did not work. The one at the top of this post is the one to use apparently.
  15. MediaHound

    Quickbooks Merchant Service v1.0

    That sounds great Parmenio, thanks. I created my CSR, submitted it, and got it signed. I was fed back my two certificates. I put them together into one file named intuit.pem and put it in a secure, non- web accessible URL. I then visited my confirm appid url and got this error There is a problem with sharing your financial data between applications. Error Message: Auth ID does not exist Exception from other package: AuthException: (-90) Auth ID does not exist Maybe these obstacles will help to prepare some step-by-step guide or be useful for others as we figure it all out.
×