Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by milauskas

  1. 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!
  2. 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?
  3. 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?
  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

    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!
  6. 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?
  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. 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?
  9. 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!
  10. milauskas

    Discount Coupon Code errors

    In addition, I'm seeing this is the shipping module in the admin section:
  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. Hi All, Silly question (but important--and I'm not afraid to say this makes me look stupid): I enabled free shipping for orders over $100, however, my client now changed her mind and we're NOT going to have free shipping. Problem is I can't remember what I did to enable free shipping over $100. I've got a table rate shipping module and it's set to charge by price, like so: 20:15.95,30:17.95,50:20.95,99.99:22.95,100:34.95 However, any order I place over $100 show a shipping charge of $0. Where can I look to try to change the code? I didn't set this in the Order Total module so it's got to be somewhere else. What pages should I look at? I've looked over checkout_shipping.php, but I don't think it's there. Thanks!
  14. 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.
  15. 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.
  16. 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.
  17. milauskas

    Need paypal IPN help

    HI all, I'm at a loss right now. This is not my first osC store, but I'm stuck. My client uses Paypal, but when her father tried to make a purchase, Paypal did not return him to the osC store. Therefore I installed Paypal IPN. So far so good, except I've got it set up to test (in Paypal Sandbox) and I don't think it's working. The orders seem to go through okay in osC but I get an email from the store owner entitled "Paypal IPN Invalid Process." Here's the email I get Can somebody tell me if I am doing something wrong--or at the very least what I *should* be trying to do with the Sandbox? I don't know if I'm experiencing problems just because I've got the IPN module set to test, but I want to make sure it's working before going live. I'm at a complete loss as to what to do. Thanks for any help.
  18. milauskas

    Paypal returns customer to payment page

    Hi All, I've installed Paypal IPN v.2.3.3 and am testing things out in the PayPal sandbox. THis is my first time doing so, so I'd appreciate any help at all. What's happening is this: PayPal DOES appear as a choice on the Payments page. I select it and go to the Order Confirmation page. Fine. I hit the Confirm button which takes me to PayPal. I log in and make my payment. Again, fine. The FIRST problem is that I get a message in PayPal that "This invoice has already been paid. For more information, please contact the merchant." There is a Return to Merchant button on this page and clicking it takes me back to the Payments page in osC (as if I never chose a payment type). As a buyer it appears that (according to PayPal) I've already paid the invoice, but in osC it looks like I haven't. If I hit the continue button, it just starts the process over and takes me back to PayPal. In addition: I recieve the customer's order in the admin section of osC so that's working, but the customer's shopping cart is not emptied. What can I do? Thanks!
  19. Hi all, I'm building a site for a client and she's got some unique shipping needs. I've scoured the forums but can't find what I'm looking for. Is this possible: It's a store for baked goods. Most products can be shipped with no problem. A few (cakes and cupcakes) will only be available for local Los Angeles area delivery. Ideally it should work like this. 1) Cakes/cupcakes should have their own shipping option 2) Local delivery is available BUT only if the order is over $50 3) Free shipping should be available for orders over $100 I've tried several configurations but none work. Local delivery/shipping appears for ALL products (not just cakes/cupcakes) and if I set these products' shipping to a table rate and enable free shipping for order over $100, then ALL products have this free shipping applied. Is there a solution to this? Alternatively, is there a way to PREVENT any shipping for the cakes/cupcakes and just have them show up in the catalog, but a buyer would need to call to order? In this scenario I'd want to keep anyone from ordering through osC but still have the items show up in the catalog. Any help is GREATLY appreciated.
  20. Hi all, I know there's got to be a solution to this: I've got three table rate modules set up. One for Ground, one for 2nd day and one for local delivery. Ground and 2nd day are set by the total order price. So is local, but there are only two options for local. Orders over $50 only qualify for this and local orders over $100 have free shipping. So... Here's how I have each module set: Ground: 20:7.95,30:9.95,50:10.95,100:13.95 2nd Day: 20:15.95,30:17.95,50:20.95,100:22.95 Local: 50:34.95,100:0.00 The problem is that when I have ANY order over $100 ALL shipping options show $0.00. I only want the local delivery option to be zero when over $100. If the order is less than $100, then all the shipping options are correct (i.e., they show the correct amounts). Anyone know why this is occurring and what I can do?
  21. milauskas

    I Can't Sort By Price

    Hi, I just tried that myself with no change. Products still aren't sorting by price. Did you have success with this? Mike
  22. milauskas

    images and header

    HI, I don't know what kind of template you're using, but I am working with a template right now that already had a default (i.e., fake) logo in the header. I merely modified that logo in photoshop to fit my needs. If you're talking about the top header itself, take a look in includes/header.php. You should be able to modify it there.
  23. Just wanted to let people know that I had this same problem (June, 2008) and this was the solution. I installed an osC template which I got from templateworld.com. I ran the above queries in phpMyAdmin and it solved the problem. Thanks for this solution!
  24. milauskas

    No paypal IPN in admin>modules>payment

    Hi, I'm trying to help a friend who has an osC store but orders aren't always coming through. I suspect it's a "not returning from Paypal" thing. I downloaded the Paypal IPN contrib and went through the install (placing the folders/files) in the correct places, but when I go into the admin section I don't see the Paypal IPN module, so I can't activate it. I've gone over the install instructions a number of times, but I can't figure out if I've missed something. I simply added the files that come with the contrib to the appropriate folders in the catalog. SInce Paypal IPN was not already there, I merely added the new files (didn't overwrite anything). Can someone give me some help or guidance? Thanks!
  25. milauskas

    ione small question about "CCGV" conribution

    If you go into the admin section and find Gift Voucher Queue you can release the vouchers there. (At least this is what happens in CCGV (trad) which I'm using. By releasing the voucher an email will get sent to the purchaser (you). YOu can then log in and send the voucher to whoever you wish.