Jump to content

MediaHound

Members
  • Content count

    58
  • Joined

  • Last visited

Posts posted by 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. 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.


  3. I just echo'd this line in my enlarged_view.php file:

    tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], 450)

     

    The "450" is the image width. Let me know if you need more instruction.

     

    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.


  4. I didn't study your question in enough detail to know if this is the problem, but I just installed the module and discovered the "New Install" instructions are missing a line for catalog/includes/classes/order.php. They need to say to add the following after line 15:

    //kgt - discount coupon

    var $coupon;

    //end kgt - discount coupon

     

    The above code is in the sample order.php file provided, it's just not mentioned in the instructions.

     

    Thank you for pointing this out.


  5. 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


  6. 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-----


  7. 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...


  8. 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.


  9. parmenio, could you post some code examples of what your using behind each of these, and if your not using any and left them blank, could you let us know?

     

    Subscribe URL: * * Need https URL

    Change URL: * * Need https URL

    Cancel URL: * * Need https URL

    Login URL:

    Marketing URL:


  10. The issue I'm having is the certificate signing request GUI provided in cPanel does not allow you to fill out the Common Name (and "pass phrase" is not mapped to it!)

    IMPORTANT: When creating this certificate the Common Name (Your Name) needs to be EXACTLY your.url:your.application.name.

     

    Now to figure how to do the CSR the old fashioned way...


  11. What you describe is not possible with the contrib in it's current state. You would need to add the functionality yourself or bribe/convince someone else to do it for you.

     

    You could use a batch image tool to resize the images to your intermediate size and then provide a link to the full sized image in the description.

     

    Thanks for that psynaptic.

    Yes, I realize that it's not a current functionality.

    I remember seeing something about multipliers as one of the bonus features in the readme, but that has nothing to to with what I need from what I remember.

    Maybe someone will take my idea or if they have the same problem they will code it in for a future release.

    I think I'll just batch resize the images and overwrite my existing huge ones with them. Either that or rename the scaled down ones, update my db with the new locations, then link to the old huge ones from the description like you suggest.


  12. nagging issue on the admin side of this contrib:

     

    frontend is working great, but only the thumbs are working in the backend? i broke all my other image links (oscommerce logo, top nav images, etc).

     

    here's the 404s i'm getting:

     

    http://www.daplummah.com/catalog/admin/DIR...Soscommerce.gif

    http://daplummah.com/catalog/admin/DIR_WS_...nfiguration.gif

    http://www.daplummah.com/catalog/admin/DIR...der_support.gif

     

    etc.

     

    catalog/admin/includes/configure.php (23-25):

      define('DIR_WS_CATALOG_IMAGES', '../images/');
     define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
     define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

     

    thanks for looking.

     

    Are you defining:

      
     define('DIR_WS_IMAGES', 'images/'); 
    

    ?

×