Jump to content

Certek

Members
  • Content count

    16
  • Joined

  • Last visited

Posts posted by Certek


  1. Thanks for producing this module. I had been using the viaKlix module and I recently received a letter from Elavon indicating that they will will be discontinuing viaKlix in June. After calling Elavon to activate a VirtualMerchant account for me, I installed this VirtualMerchant module on a test site to confirm that it works as advertised. After a couple of minor details were adjusted, it seems to be working properly.

     

    Since this is fresh in my mind, I thought I'd point out a couple of issues and/or suggestions for improvement.

     

    - After you get the files in place and go to the admin control panel to activate the Virtual Merchant module, the title for the module is shown as "Credit Card: (MODULE_PAYMENT_CHARGEIT_CC_ACCEPTED)". I recognized the all-caps identifier as one that should have been defined so I thought that I had made an error when putting the files in place. After some searching about, I realized that the reason that MODULE_PAYMENT_CHARGEIT_CC_ACCEPTED was undefined was because the module hadn't yet been installed. It may be useful to modify the code slightly so that the entry in the module list does not include the undefined identifier prior to the module being installed.

     

    - I saw the list of fields on the first page of this support thread so I went to my VirtualMerchant login and verified that all of the entries were present. On my first test charge (using the production server) I got an error code back. Since I had set up the email for transaction errors, I shortly received an email indicating that ssl_salestax was required but not present in the post. I had overlooked the fact that status for ssl_salestax is 'required' by default but is listed as not required in the field list. It might be a good idea to include the field list in the installation instructions and to point out that one should confirm that the required/not required status is set as indicated.

     

    - I did not enable DCC so I didn't bother to try to add the fields ssl_cardholder_amount, ssl_cardholder_currency and ssl_conversion_rate. Consequently, I didn't have the problem that others have had as noted in other posts in this thread. It is probably worthwhile to add a note to the installation instructions to the effect that those fields aren't needed if DCC isn't enabled.

     

    - I would also be worthwhile noting in the installation instructions that the "Order ID" field must be manually added. Unless Elavon changes the defaults and the standard fields, the only changes that need to be made are to add the "Order ID" field and to change the status of the "Sales Tax" field from required to not required.

    DK,

    I want to thank you for your posts regarding installing the Virtual Merchant contribution. I also am currently running with ViaKlix and got the same change notice. I have a question regarding your install. Did you uninstall the ViaKlix contribution prior to installing the VM? You also mention adding the "Order ID" field when making this install. I know enough to be dangerous and it would go a long way if you could show me the code that did this. Thanks in advance for your reply.


  2. My previous information was in error. The set_function field is used by the configuration editor to present the selection options. If you are using a mySQL version below 5.0.3, you can change the data type to TEXT instead of VARCHAR(555).

     

    These are two separate commands. You need to alter the table before you can update the configuration. Paste each one into an SQL query window in phpMyAdmin.

     

    --Glen

     

    Thanks Glen and I was able to figure that out the hard way. Nonetheless, I learned more about SQL in my efforts so not all is lost. The module is up and running fine on my sight. Thanks again.

     

    Steve


  3. Steve,

    Effective May 14, packages over one cubic foot in volume will be charged either the actual weight or the dimensional weight, whichever is greater. This is designed to discourage shipping "balloon" packages. It won't affect many shippers. As a rule of thumb, if your rectangular packages weigh less than 9 lb/cubic foot, and you ship to zones 5-8, you will be subject to the surcharge. Depending on the density, you might incur a surcharge of a few dollars. Shippers of odd-shaped packages have a different calculation (DMM 123.1.4.2)

     

    I don't foresee a problem in my shop, as the largest package I ship is a 12x12x12" box, and my packages of this size are typically about 15 pounds. If I wind up with a package subject to dimensional weight, I'll just eat the extra postage.

     

    People shipping low value, low density (pillows, bubble wrap, packing peanuts, etc) packages will have problems, but most will be fine.

     

    --Glen

     

    Glen,

    Thanks for the reply. I have a lot of packages that will be affected by this change so I am scrambling to make the correct changes. I have my files updated but have yet to run the SQL updates. I am a little confused on the SQL. I know I run them in myPHP but have a question. The instruction state the following...

     

    Execute this SQL update:

     

    ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

     

    Execute this SQL update if you already have the module installed and are updating:

     

    UPDATE `configuration` SET `set_function` = 'tep_cfg_select_multioption(array(''Global Express'', ''Global Express Non-Doc Rect'', ''Global Express Non-Doc Non-Rect'', ''Express Mail Int'', ''Express Mail Int Flat Rate Env'', ''Priority Mail Int'', ''Priority Mail Int Flat Rate Env'', ''Priority Mail Int Flat Rate Box'', ''First-Class Mail Int''),' WHERE `configuration_key` ='MODULE_SHIPPING_USPS_TYPES_INTL' LIMIT 1 ;

     

    ====================

     

    My question is what exactly do I input for this change? Is this two separate commands? I already have this module installed so do I just run the second one listed? Sorry if this is a stupid question. Just not too up on this stuff.

     

    Steve


  4. Yes, it will. I am not certain of the exact effect, but I use this contribution in my store and will look into fixing it, as soon as USPS posts the revisions to the Rate V2 and International rate calculators. I'll also contact the USPS ICCC to determine if the documentation is already available somewhere. It hasn't made it to the webtools page yet.

     

    --Glen

     

    Glen,

    This will not be an easy task as the new rates are not only weight based but vary based on the size of the package. Any priority package over 1 foot cube is going to have a size surcharge. There will have to be an oversize entry for this contribution that takes package size into account. I really think it will be a disaster to deal with and I am thinking of just not using USPS.

     

    Steve


  5. I just installed the 1.7a version. I have been looking for this type of contribution for some time. While the UPS and USPS shipping estimates seem to be working fine, I can't get the table rates to work. I did a quick search and I think this may be a problem that has yet to be resolved. Has anybody been able to use this contribution with table rates? I have a table rate for U.S. customers. If their order is below $199 then shipping is $7.97. Over $199 and it is free.

     

    Thanks in advance for your insight on this.

     

    Steve


  6. Simone,

    Try this as it worked for me - http://forums.oscommerce.com/index.php?s=&...st&p=856268

     

    Hope it works for you.

    Steve

     

    I think the link is not working - here is what I changed.

     

    MySQL 5 Fix

     

    The current version of the Froogle Feeder errors when using MySQL 5. This can be resolved by making the following change: (Just add the parenthesis and see what happens)

     

    Around line 89:

     

    FROM categories,

    categories_description,

    products,

    products_description,

    products_to_categories

     

    Change to:

     

    FROM (categories,

    categories_description,

    products,

    products_description,

    products_to_categories)


  7. Steve,

     

    Sorry I was unable to help out on this. I am as stumped as you right now, since this error line:

     

    SQL error Unknown column 'products.manufacturers_id' in 'on clause'

     

    Indicates the manufacturers_id is missing from the products table.

     

    Anyone else have any ideas?

     

    Bruce,

    In my search of this problem, I have found others with the same problem.

     

    http://forums.oscommerce.com/index.php?s=&...st&p=820485

    http://forums.oscommerce.com/index.php?s=&...st&p=829888

     

    Then I found this...

     

    http://forums.oscommerce.com/index.php?s=&...st&p=856268

     

    I tried it an no more error after I ran it. I got the following...

     

    File completed: frooglefile.txt

    Connected to uploads.google.com, for user realdealtools

    Uploaded D:/Home/...I removed the tree data on purpose... /feeds/frooglefile.txt to uploads.google.com as frooglefile.txt

     

    Script timer: 26.373841 seconds.

     

    I think this worked but don't know for a fact. Will have to check out the details on Google Base. I don't know if I have to first define the file name to Google before they receive it.

     

    Hope this helps you out on your next build. I will let you know if I run into any additional problems.

     

    Steve


  8. Hello Steve,

     

    I am 99% sure that you have a field missing in your PRODUCTS table, which appears to be the manufacturers_id field. Ran into a similar issue with another client, unrelated to this contribution, and that was the end result.

     

    Go into your phpMyAdmin tool or other MySQL tool, VIEW the PRODUCTS table. Typically this field is between the products_tax_class_id and the products_ordered fields. If you do not see it there, then for whatever reason it was deleted from your database.

     

    Setup the field again as follows into the PRODUCTS table:

     

    `manufacturers_id` int(11) default NULL

     

    Be sure to let me know if this resolved your issue.

     

    Bruce,

    Thanks for getting back to me so quickly. I checked on the product table and I do in fact have the manufactures_id in place. Here are the total headings for the products table.

     

    products_id

    products_quantity

    products_model

    products_image

    products_price

    products_date_added

    products_last_modified

    products_date_available

    products_weight

    products_status

    products_tax_class_id

    manufacturers_id

    products_ordered

     

    As you may know I am a newbie with all of this stuff. At the same time I have learned a ton these past few months as I got my store up and running. I have checked around the help section and just can't get my hands on a solution for this problem. Thanks again for your time and effort.

     

    Steve


  9. In response to the numerous reported issues and suggestions I have received so far for this contribution, I am starting a new thread to discuss:

     

    - reported bugs

    - fixes made

    - suggested improvements

     

    Over the coming few weeks I will be making some improvements to the coding to combat against incompatibility errors many people have found with the automatic uploads, plus adding some new features in based upon your feedback.

     

    So anyone having issues or suggestions for improvements I ask that you post them here, and I will post either fixes, or notifications once new versions have been released.

     

    Thanks.

     

    Bruce,

    Thanks for the opportunity to report errors and your hard work with this contribution. I have tried to no avail to install it. And I really can find any information in the forums to resolve it. If you can shed some light on the problem I would be extremely grateful.

     

    After I run the Froogle Feed (actually any feed yahoo, froogle, or bizrate results in the same error) I get the below listed error. I have yet to try it with bidhopper. If it helps my provider is running PHP Version 4.4.3-dev. Also, I am running on a Windows Server.

     

    Start Error

     

    SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.realdealtools.com/oscommerce/catalog//product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.realdealtools.com/oscommerce/catalog/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' ORDER BY products.products_id ASC

     

    End Error

     

    Thanks for you time and effort.

    Steve


  10. Just installed the latest version of Froogle/Google Base, Yahoo, and Bizrate Feeds contribution and get the following error. I have checked the support threads and can't find reference to it. Anybody know what it means? Your time and effort is appreciated.

     

    Error...

    : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.realdealtools.com/product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.realdealtools.com/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id ORDER BY products.products_id ASC

×