Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by coolfly

  1. coolfly

    [Contrib] Make An Offer

    Hi Jozinecko, Again, sorry I have been on holiday. I got your IM. If you are still having this problem, let me know and I will look at the code to remove the tax and get back to you. As for the incorrect price, see the code change I put in the message above for Nichole, this may help you too.
  2. coolfly

    [Contrib] Make An Offer

    Hi Nicole, Sorry I've been away for a while. On your first question about the red and green lights, I will look at the code for what controls that and get back to you shortly. On your second question about the incorrect price try this (only if you are using the v2.2 rc2 store) in catalog/make_an_offer.php, look for the code: // $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; $products_price = $currencies->display_price($productid,$new_price, tep_get_tax_rate($product_info['products_tax_class_id'])); // Price without currency symbols $products_price_clean = tep_round(tep_add_tax($new_price * $rate,tep_get_tax_rate($product_info['products_tax_class_id'])),$currencies->currencies[$currency]['decimal_places']); } else { $products_price = $currencies->display_price($productid,$product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); and change to: // $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); // Price without currency symbols $products_price_clean = tep_round(tep_add_tax($new_price * $rate,tep_get_tax_rate($product_info['products_tax_class_id'])),$currencies->currencies[$currency]['decimal_places']); } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); On question 3, I'm not sure I understand..the customer is going to decide what they want to offer you. If you would like, there are ways we can put a note to 'alert' the customer that 'tax will be added' (and they can think of this while they decide what to offer you) On question 4, No it's not possible. It would be nice to be able to accept offers directly from the email, but I think that would cause a security issue. One thing I am (slowly) working on in my free time, is the ability to accept offers from your admin panel (which you would have to securely sign into)..where it would put the offer in their shopping cart for when they return. The email can have an option to both 1) reply to the sender telling them you accept/reject their offer, and 2) provide you a link to your admin where you will then sign in first and then apply the new accept options(if you're going to accept). Again, something for the future, when I have a weekend to look at it. Again, sorry for late reply, if you are still having these issues, let me know and I'll do my best to help you.
  3. coolfly

    [Contribution] - USPS Methods

    Just wanted to add that if you are getting the following error or similar: check to make sure your admin/includes/modules.php and admin/includes/functions/general.php have all the updated code mentioned in the directions for previous versions...if you've installed other contributions, you may have replaced those pages with earlier versions that need updating....even if you haven't used other contributions, check anyway. don't ask me how I know :rolleyes:
  4. you the man...sure enough I put the new code 'under' instead of 'replacing' :-" ..Thanks!
  5. Hey Sam, first time using this....SUPER! quick question, everything seems to work fine, but I think I also have an extra 'browse for image' field aside from the four that I (believe I) should have...based on these pics, did I do something wrong? ...I'm talking about the one where the browse field is off to the left... Thanks,Chris when entering new product: existing product:
  6. coolfly

    [Contribution] Linked Products

    Zappo could answer those questions best, but after just spending a day and half trying to get past the errors I mentioned above, I would strongly consider waiting for him to revisit this thread before installing this. I can tell you two things, -I'm pretty sure the errors I had were all related to one problem with the product_types table in the db (fields: type_id, type_color, and type_name)..I tried circumventing them by manually adding the values with phpmyadmin, but the error remained, so I think something's not connecting the dots there. Was getting another undefined column (line 484) error in the 'linked types' part of the store admin, again with those 3 fields...the other options all had drop downs that seemed to work fine. Wish I had the experience to fix them, but not yet. -His new product attributes page looks awesome..very nicely laid out with the different 'option types' available..hope he comes back soon and finishes it. I found something called 'related products' that I'm trying to install now..seems to be similar to this and master products, recently updated and actually has an involved support thread. It would be great to see this one get off the ground though, as it has all the contributions you need, already built in.
  7. coolfly

    [Contrib] Make An Offer

    Well I finally got to contribute something :) I uploaded a full package (v3.1) with the all the modified files for a 2.2RC2a Vanilla Store. Here are the updates I included: -Added all the Modified Files for a clean Install -Added Beginning/End Comments where needed for those files -Fixed Error in 'make_an_offer.php' that caused item and original price not to appear in email offers sent to shop owner. Credit to Shawnm Posted 17 June 2007 - 12:43 PM -Added 'mouseover' note informing customer how to use the direct offer box. Credit to angelstudio54 Posted 18 April 2009 - 05:04 PM -Changed grammatical error in English>make_an_offer.php "Your order has been successfully send.." to "Your offer has been successfully sent.." Again, Thanks to Wheel of Time for this great contribution! Sorry for English only, but I didn't want to insult the Dutch people by trying to edit a php file in their language and make a mess of it. edit: oh yea, you can find it here: http://addons.oscommerce.com/info/3034
  8. coolfly

    [Contribution] Linked Products

    sorry to double post, but I fixed the problem in the admin side, and (of course) it was of my own doing...knocked out a (.) for a comma when pasting the offer variable... however I do have another 1054 when I go to edit/create a product... 1054 - Unknown column 'type_linked' in 'field list' select type_linked from product_types where type_id = '0'
  9. coolfly

    [Contribution] Linked Products

    yea, I'm getting this too, I think type_show_product_as needs to be defined, but I don't know exactly what it's purpose is...something to do with invisible products. This contribution looks really cool, would like to get it working. Also I'm getting a syntax error in the admin side... Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/mysite/public_html/admin/categories.php on line 331 line 331 tep_db_query("insert into " . TABLE_PRODUCTS . " (" . $AddSelectSql . ", products_quantity, products_model, products_image, products_price, products_make_an_offer, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id) values (" . $AddInsertSql . ", '" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "' ,tep_db_input($product['products_make_an_offer']) . "', '" . '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "')"; it's a long one..notice I have the 'make an offer' attribute in there, but don't believe that's causing the error. Hope King Zappo returns soon...
  10. coolfly

    [Contribution] Option Types v2

    hi dan...thanks for reply..i had sent you a pm about it, but disregard it. hmm, you using a clean osc store or a template? If you can, hold off on removing for a while...I'll try to figure it out or maybe someone familiar with it will post now that there's more than one of us with problem...seems like a cool mod if working right... Thanks, Chris
  11. coolfly

    [Contribution] Option Types v2

    Dan I get the same errors with either the text field or text area. I'm trying to add the text field in the old 'products_attributes' section as I don't have the text option with the ajax manager. Have you figured out the mistake yet, as I probably have duplicated what you did? edit: just a follow up...i still get the errror (which i have to browse back to get out of) but the text field does appear correctly on the product page. I still would like to get rid of the error though...thanks
  12. coolfly

    Master Products - MS2

    Hi George, I had talked to you earlier in the year about the possibility of slave pop-ups. I see you eventually added it on..AWESOME! I wound up creating a site that was customer friendly but an extreme pain for the admin in the sense that they (make that 'I') have to first make the secondary products as options and then create a separate html page for each of the product descriptions...50 products. Needless to say, weekly price changes take the better part of a day. After doing this for a good part of a year, I'm redoing the site to be easier to maintain...so your contribution is really going to help in this area. One general question...can slave products be set up so that they only add if the master is chosen? Thanks for putting it out, Chris
  13. coolfly

    Linkpoint API Problems

    Hi, I'm using godaddy (haha) and I'm having the (well documented) problem of a blank page a few minutes after hitting the confirm button. I turned on debug and here is the result: at curl_process, incoming data: host = secure.linkpt.net port = 1129 keyfile = /home/content/k/i/n/###/html/catalog/includes/modules/payment/linkpoint_api/****.pem configfile = 10 digit store number ordertype = PREAUTH result = LIVE transactionorigin = ECI ponumber = 1002 taxexempt = Y terminaltype = UNSPECIFIED ip = ip number chargetotal = 1.06 cardnumber = my card number cardexpmonth = 12 cardexpyear = 11 cvmindicator = provided cvmvalue = cvm # userid = 10 name = my name company = address1 = my adress line 1 address2 = city = state = Florida (Broward County) country = US phone = my phone addrnum = my adress line 1 zip = zip code sname = my name again saddress1 = my adress line 1 again saddress2 = scity = my city sstate = Florida (Broward County) szip = my zip scountry = US Warning: htmlspecialchars() expects parameter 1 to be string, array given in /home/content/k/i/n/####/html/catalog/includes/modules/payment/linkpoint_api/lphp.php on line 172 items = debugging = true sending xml string: <order><orderoptions><ordertype>PREAUTH</ordertype><result>LIVE</result></orderoptions><creditcard><cardnumber>*mycardnumber*</cardnumber><cardexpmonth>12</cardexpmonth><cardexpyear>11</cardexpyear><cvmvalue>***</cvmvalue><cvmindicator>provided</cvmindicator></creditcard><billing><name>MyName</name><company>*company name*</company><address1>*myadress line 1*</address1><address2></address2><city>*mycity*</city><state>Florida (Broward County)</state><zip>*my zip</zip><country>US</country><userid>10</userid><phone>*my phone*</phone><addrnum>*adress line1 again* terrace</addrnum></billing><shipping><name>****</name><address1>**** terrace</address1><address2></address2><city>*****</city><state>Florida (Broward County)</state><zip>***</zip><country>US</country></shipping><transactiondetails><ponumber>1002</ponumber><taxexempt>Y</taxexempt><terminaltype>UNSPECIFIED</terminaltype><ip>******</ip><transactionorigin>ECI</transactionorigin></transactiondetails><merchantinfo><configfile>*store10digits*</configfile><keyfile>/home/content/k/i/n/****/html/catalog/includes/modules/payment/linkpoint_api/****.pem</keyfile><host>secure.linkpt.net</host><port>1129</port></merchantinfo><payment><chargetotal>1.06</chargetotal></payment> <items> <item> <id>bunch of numbers{don't know their relevance, so won't post them, lol}</id> <description>product name</description> <quantity>1</quantity> <price>295.00</price> </item> </items> </order>
  14. coolfly

    Linkpoint / YourPay module not wokring

    has there been a resolve to the problem mentioned by the OP?
  15. Well, now you can say you don't know of anyone that's tried it successfully :D . I do believe it can be done easily though...just not by me. I was trying to replicate the options_values_price into weight, which I do believe is the key, but there were too many other variables that I don't understand enough, messing me up. I found someone from 2005 that says it would be easy to do, so I sent her a line, no response. probably moved on in life. Too bad, it's really a valuable contribution that would be awesome to have work with this. Oh well, Thanks.
  16. just an update on my previous post should some1 run into the same sql problem (1064) that I was having. The answer, as I thought, was to go into phpmyadmin, under the table "discount_coupons", and manually "insert" a coupon by filling in the fields under that tab. This took away the sql error and allowed me to finish the installation of the program. Again this might just be an oddity in my whole custom template, but worth a try if you're getting the same thing. My next question: Is there a way for the coupon to be featured in the cost breakdown on the "order confirmation" page. Mine only shows the total products in one box at full price, and then the discounted price is reflected in the subtotal, which is fine, but some customers that are mathematically challenged may not believe they're getting the discount if they don't see a line that says "coupon -$XXX" ...you follow me? http://addons.oscommerce.com/info/4269 I believe your looking for discount coupon codes 3.31 (about 8 down). Install the fixes after if you should run into any of those issues..I haven't, although the fix that keeps the shipping in the event of a negative total price, seems worthy. I don't mean to ask you an obvious question, but did you actually finish the install under admin>modules>order totals>discount coupons..."install"? I ask because I forgot that step too, and was looking around for a while, lol :blush: . They do mention it in the readme, so I assume some others missed it too. EDIT...I already had a coupon installed as a fix to the sql problem I mentioned above which is why i thought i was done, re-reading your post you probably did this already...sorry.
  17. Hi, I installed and double checked everything, but still get this error when I go into admin>Discount Coupons: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-6, 6' at line 1 select * from discount_coupons cd order by cd.coupons_date_end, coupons_date_start limit -6, 6 I also get this 1064 error in things like Reviews, Products Expected...The interesting thing with those is that I can easily get rid of the error by simply creating a review or by adding an item for a later date in the case of products expected. The problem with this is that the only way to create a coupon is with the module working, or can I create a coupon manually through the db??? Or is there a way to just get rid of this error?? I've tried the different sql requests mentioned in various posts and in the readme but am getting nowhere... Thanks
  18. coolfly

    QBI Quickbooks Import

    ooops....sorry to double post, but i forgot to upload the functions and classes files....sorry! :blush:
  19. coolfly

    QBI Quickbooks Import

    Hi. I installed the QBI 2.10c on my test shop...it's my first install of this contribution. When I get to the part of the install where you go into admin and choose "import quickbooks qbi", I get: Warning: require_once(includes/functions/qbi_functions.php) [function.require-once]: failed to open stream: No such file or directory in /home/mysite/public_html/ktest/admin/includes/qbi_page_top.php on line 31 Fatal error: require_once() [function.require]: Failed opening required 'includes/functions/qbi_functions.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mysite/public_html/ktest/admin/includes/qbi_page_top.php on line 31 any ideas? (i'm 0-3 on different contributions today :angry: , one of those days )
  20. coolfly

    AJAX Attribute Manager support

    Hi, I've also installed the 2.8.2 version and can't find it under add/edit product. I've read all posts since it was added and have tried the following: cleared firefox console of errors cleared all data in firefox/also updated to newest version/made sure java enabled removed htaccess (i put it back after determining not the cause) don't have sort order re-checked the categories.php file new install of this, wasn't an update from a previous version...any ideas?
  21. coolfly

    FedEx Direct 2.06 Support thread

    Ok, leaving as meter NONE. I double checked all configurations to be correct. Tried debug mode and get this (i edited my personal info out obviously for this post): Data sent to Fedex for Meter: 0,"211"10,"428176340"4003,"correct store owner"4007,"correct store name(company listed with fedex account)"4008,"exact address listed with fedex and on line 1 in module"4011,"correct city"4012,"correct state"4013,"correct zip"4014,"US"4015,"correct phone with dashes"99,"" Data returned from Fedex for Meter: all info is entered exactly (and case wise) as fedex has it on myfedex contact info page. "data returned from fedex for meter"...does this mean communication is made? i tried calling previous to doing the debug and the fedex tech confirmed my account but said i don't have a meter number (obviously) and to call my webhost and make sure i have port 443 attps enabled....any merit to this?
  22. thanks surfalot...i missed that part :blush: why, is this something that's been tried already, from that contribution? it already has an entry in the db in the products_attributes category, "options_values_weight" ..same place you get options_value_price and options_value_id. I'll mess around with it over the weekend...
  23. coolfly

    FedEx Direct 2.06 Support thread

    update: i now have curl....cURL support...enabled...cURL Information...libcurl/7.18.1 zlib/1.2.3 libidn/0.6.5 <<7.18.1! it's that good stuff :wacko: However, I'm having the same problem as the first writer below ("No response to CURL from Fedex server, check CURL availability, or maybe timeout was set too low, or maybe the Fedex site is down") The resolve was never mentioned. So where do I find this meter number that he seeks? also extra credit: i have "add weight to attribute" contribution...it works fine with all the other shipping mods...not this one though...any1 say otherwise?
  24. (configuration in pic) Hi. I set this up on my test store to see what it can do. Seems awesome, but I'm running into a slight problem. When you select "complete," shouldn't it check mark everything? As you can see in the attached pic, it only seems to highlight the area, but not check anything. When I download, I only get the headings in the top row, but no products. When I do a custom file and check certain fields, I get the same result with no products. Some of the "quicklink" downloads work fine, but not "complete." There were also some occurrences where all headings were in cell 1a, as mentioned in a previous post, but that seems to have stopped. -I've only got two products in the test store. -I'm running a non-vanilla template -haven't tried importing back in yet (babysteps, lol) Thanks
  25. Wow, judging by the reviews, this is something to have. I basically have a store with minimal products, but each product has many attributes. Some of the attributes require weight for shipping of which I'm using "Add weight to attribute." Is this also doable through this contribution? And to make sure I'm understanding properly, everything pertaining to editing items/attributes can be imported/exported using excel?? Please say yes!!!