Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Michael Milauskas
  1. milauskas

    Virtual Merchant orders not going through to VM

    ANother follow up. In the includes/modules/payments/chargeit.php page there is this line: $this->virtual_merchant_url = 'https://www.myvirtualmerchant.com/VirtualMerchant/process.do'; I talked with Virtual Merchant and this is correct. This is the correct url for these transactions. THe next line is: $this->curl_referer = MODULE_PAYMENT_CHARGEIT_REFERER_URL; I checked php.ini jsut to be sure cURL is active. It is. Also in chargeit.php there is this: ('Set Referer URL', 'MODULE_PAYMENT_CHARGEIT_REFERER_URL', 'https://secure.yoursite.com/checkout_confirmation.php', 'Set the authorized referer url you set in your Virtual Terminal Merchant Account.', '6', '5', now())"); Should this url be changed to, for example, https://myrealdomain.com/catalog/checkout_confirmation.php ? (Note: This is what I see in the actual module in the admin area. I'm wondering if I need to alter the "https://secure.yoursite.com/checkout_confirmation.php" so it matches. I did this and did a few transactions, but nothing shows up when I log into my virtual merchant account. Am I misunderstanding "Virtual Terminal Merchant Account?" Is that referring to the Virtual Merchant site I log into or is it the add on in osC? Is there anywhere else I might look as to what gets sent and where?
  2. milauskas

    Virtual Merchant orders not going through to VM

    Just a follow up. The transactions seem to go through, at least on the osC end. The money is deposited to the bank account so that's working. Is there some setting I've done wrong that's preventing the orders from showing up on the Virtual Merchant site?
  3. Hi, I installed the Charge-it add on for Virtual Merchant (Elavon). I've input all the info (acccount id, user id, pin) and tested things out first in test mode. Everything looked like the transaction was successful. I even get the confirmation email of my purchase. It's now in production mode. However while the orders show up in the osC admin, when we go to our virtual merchant account online, there are no orders showing up? Am I missing something? I called Virtual Merchant today. There wasn't much they could tell me except that maybe the add on was in test mode. It's not. I set it to production mode.' This is the only payment module that's active. I just went through all the others listed in the payment modules page and nothing else but charge-it is installed. Is there something that may prevent these orders from being processed/showing up in Virtual Merchant? Thanks!
  4. milauskas

    Error with virtual merchant transaction

    Thanks guys. Actually I downloaded the (new?) virtual merchant payment module add on. Looks like it was different from the one that was being used before. I talked with Virtual Merchant directly and although my merchant ID, etc were all correct something wasn't working. When I installed the new VM add on I was able to complete a transaction.
  5. milauskas

    Error with virtual merchant transaction

    Thanks, Chris. I'll probably have to get someone to clean things up (did this a couple years ago for another problem). Is there anywhere in particular that I could look in the meantime to see if there's any more anomalous code? Any common areas where these things occur?
  6. milauskas

    Error with virtual merchant transaction

    Hi, I have an osc site built for a client and now customers can't complete any orders. It's been up and running for 6+ years (it's version 2.2). There was some hacking (a bunch of spam emails were being sent from the site) so I don't know if that's related to this, but when I try to go through checkout I enter my credit card (real or fake) and I get this error from virtual merchant. An Error Occurred While Processing Your Request Error Code : 4000 Error Name : VID Not Supplied Error Message : The VirtualMerchant ID was not supplied in the authorization request. This is on a virtual merchant page, not on any page from the client's site/domain. I didn't install the module to be able to use elevon as a payment gateway. That was done by a third party. However, it's worked for years and now I'm getting this error. Any solutions? Does anyone know what this error refers to? Thanks!
  7. milauskas

    YahooDataFeeder error

    Hi All, I've never used a data feed until recently. I did use the Feedmachine Solution successfully but I am now trying to use YahooDataFeeder to create feeds for other shopping sites. I've followed the instructions as best I can, however, after uploading all the relevant files (including yahoo.php, which I've altered to include my domain and database) I go to view yahoo.php in my browser and get the following error: : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://mydomain.com/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://mydomain.com/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 ORDER BY products.products_id ASC I read another similar post with a similar error and my problem is the same. It seems to be saying there is no manufacturers_id column in the database, but there is. I double checked in phpMyAdmin. Did I do something wrong when altering yahoo.php or is it something else?
  8. milauskas

    Discount Coupon Code errors

    It's above the continue button. Does that mean something? Should it be somewhere else? I removed all the modified files, restored the database and tried again. I'm not getting those errors anymore, but now I'm not getting the discount applied. Thanks for your help!
  9. milauskas

    Discount Coupon Code errors

    In addition, I'm seeing this is the shipping module in the admin section:
  10. HI, I just installed the discount coupon code contrib, but Im experiencing problems. I'm able to create a coupon in the admin section, and everything seems fine, but when I go to make a purchase on the site problems arise. 1) On checkout_payment.php the text for the coupon entry box reads: ENTRY_DISCOUNT_COUPON It should read "Coupon Code" (and I've got this in english.php: define('ENTRY_DISCOUNT_COUPON', 'Coupon Code:');) 2) On trying to put the code into the box and continue with payment, nothing happens. There's no error or anything. It just stays on checkout_payment.php and I can't go any further. 3) If I DON'T try to use the coupon code, I am taken to checkout_confirmation.php where I see the following error: Can anyone tell me what I've done wrong?
  11. I thought I'd add a follow up to this since I was pulling my hair out till I found this solution at the end of this post. I had installed the Attribute Sort w/ Attribute Clone contrib and was getting that same column count error. I took the code that Ben Walsh provided and placed it in admin/products_attributes.php. I had to replace some of the code that I added as part of the Attibute Sort contrib, specifically: // BOE: Attribute Sort with Clone Tool tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (null, '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . //(float)tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "', '" . (int)$attributes_sort . "','')"); // EOE: Attribute Sort with Clone Tool Find this in your code and replace it with the code Ben Walsh provided (above). Now I can add attributes without that error.
  12. Hi, I am trying to get the Attribute Sets Plus contrib to work on my site. I went through the install instructions step by step and I *think* I've modified all the files necessary. I've run the sql script to alter the database and uploaded the modified/new files. The problem occurs in the Admin area when I click the Attribute Sets link. I get this error: 1146 - Table 'skort.TABLE_PRODUCTS_ATTRIBUTES_SETS' doesn't exist select products_attributes_sets_id, products_attributes_sets_name from TABLE_PRODUCTS_ATTRIBUTES_SETS where 1 order by products_attributes_sets_name [TEP STOP] I'm not sure what this is telling me. I went into phpMyAdmin to look at the database and the table product_attribute_sets does INDEED exist. What mistake have I made? Please enlighten me! Thanks!
  13. This is what I had in the table rate module: 20:15.95,30:17.95,50:20.95,99.99:22.95,100:34.95 I changed it to this and things are working okay: 20:15.95,30:17.95,50:20.95,99.99:22.95,10000:34.95 I don't know why the problem in the first place, but I'm not knocking my apparent success. Just letting everyone know about my solution.
  14. Okay, I seem to have solved it. I altered the table so that it now reads: 20:15.95,30:17.95,50:20.95,99.99:22.95,10000:34.95 So, any orders up to $10,000 will have $34.95 shipping. I still don't know why anything over $100 was giving me zero shipping. I assumed that 100 and up would be $34.95, but I may be wrong. In any case, I am posting my solution in case anyone else runs across this in the future.
  15. No, I checked. That's not it. I installed an additional table rate module to see if that had any affect. It didn't. Orders over $100 still get free shipping. I'm pulling my hair out on this. It would be easy to set free shipping in the order total module, but that's not where I altered the code. Guess I'll keep looking.