Jump to content

jgeoff

Members
  • Content count

    55
  • Joined

  • Last visited

About jgeoff

  • Birthday 01/06/1966

Profile Information

  1. jgeoff

    Header Tags for novices

    This might be conflicting a little with Chemo's Ultimate SEO URLs contrib... I'm no longer getting any META descriptions and keywords for categories and even the home page -- but I am with product info pages. Or maybe that's designed, I forget now -- but do you think some logic could be added so that IF the description and keywords fields are blank THEN use some default description and keywords? Thanks for any ideas! JG
  2. jgeoff

    New York Sales Tax

    I don't think it really matters how it's done. I updated it as combined as that's how it's been since the contribution was first posted until you decided to change it. ;) You don't NEED TO assign a New York State tax rate of 4% then add the city taxes -- you can just use the combined state/city taxes as obviously all the cities are in New York State. My client operates out of Long Island, NY, so they only need to charge NY sales tax and no other states. I have NO "Tax Zones" or "Tax Rates" set up, and just the one "Taxable Goods" Tax Class. It works for what my client needs. The tax chart I posted is the most accurate, currently, if your are going to do it this way, but if you want to do it the other way, then subtract the 4% for each line in the SQL. Then follow the rest of mickeymouse's instructions...
  3. This contrib seems to be working great in RC2a -- Thanks!
  4. jgeoff

    New York Sales Tax

    In your Admin > Modules > Shipping... edit the shipping methods you use as: Tax Class (Taxable Goods) That makes shipping taxable
  5. jgeoff

    Get 1 Free

    I GOT IT!!! :) B) I'm not a programmer so maybe this isn't the best or most efficient way to do this, but it's working! Wayne, if you have any suggestions to tidy this up, please let me know. ADDING "BUY X GET Y" TO THE PRODUCT LISTINGS: In /catalog/includes/modules/product_listing.php replace the case 'PRODUCT_LIST_NAME': section with case 'PRODUCT_LIST_NAME': $lc_align = ''; $get_1_free_query = tep_db_query("select pd.products_name, pd.products_id, g1f.products_free_quantity, g1f.products_qualify_quantity from " . TABLE_GET_1_FREE . " g1f, " . TABLE_PRODUCTS_DESCRIPTION . " pd where g1f.products_id = '" . (int)$listing['products_id'] . "' and pd.products_id = g1f. products_free_id and pd.language_id = '" . (int)$languages_id . "' and status = '1'" ); if ((isset($HTTP_GET_VARS['manufacturers_id'])) && (tep_db_num_rows($get_1_free_query) > 0)) { $free_product = tep_db_fetch_array($get_1_free_query); $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>' . '<p class=get1free2>' . sprintf (TEXT_GET_1_FREE_PROMOTION, $free_product['products_qualify_quantity'], $product_info['products_name'], $free_product['products_free_quantity'], $free_product['products_id'], $free_product['products_name']); } elseif (tep_db_num_rows($get_1_free_query) > 0) { $free_product = tep_db_fetch_array($get_1_free_query); $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> ' . '<p class=get1free2>' . sprintf (TEXT_GET_1_FREE_PROMOTION, $free_product['products_qualify_quantity'], $product_info['products_name'], $free_product['products_free_quantity'], $free_product['products_id'], $free_product['products_name']); } elseif (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a><br>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> <br>'; } break; /* ORIGINAL case 'PRODUCT_LIST_NAME': $lc_align = ''; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a><br>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> <br>'; } break; */ Add to /catalog/includes/languages/english/index.php (This can be different than the wording in product_listing) // Get 1 Free define('TEXT_GET_1_FREE_PROMOTION', 'Buy %u %s & Get %u <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=%s') . '">%s</a> free!'); (The only problem I notice is that for some reason the first %s isn't displaying. It's coming out as "Buy 1 & Get 1 Y free!" for some reason -- any ideas?) I also changed the stylesheet to include a separate class to display for index than the product_info page. These are currently my personal settings: .get1free { font-family: Verdana, Arial, sans-serif; font-size: 12px; background: #ffb3b5; border: 1px; border-color: #000000; } .get1free2 { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #ff2222; } Again, if it can be cleaned up (do we need the last two else's in there?) let me know. JG
  6. jgeoff

    Get 1 Free

    Yet another feature request, in addition to the above (and the "Get This Item Free With Purchase of X" request)... I'd like to be able to add 2 or more free (distinct) items with the purchase of another item ("Buy X and get Y and Z Free!") Wishful thinking? ;) Thanks, JG
  7. jgeoff

    Catalog as homepage

    In your web hosting cPanel (or whatever you use) you can set up a redirect so anyone going to http://www.yoursite.com/ will automatically be redirected to http://www.yoursite.com/catalog/
  8. jgeoff

    UPS Module

    UPSChoice 1.8.3 works for me
  9. jgeoff

    Free shipping per product 1.1

    Okay, I pretty much got it to work -- BUT -- all this does is subtract the # of items before calculating per-item shipping. What I need is for it to subtract the free shipping product weights before I pass it along to the UPS module... :/
  10. jgeoff

    Free shipping per product 1.1

    Has anyone gotten this add-on working on the latest version of osC? :huh:
  11. jgeoff

    New York Sales Tax

    My bad, I didn't assign the tax rate to the shipping module :blush: ( Edit time is too short on these forums :-" )
  12. jgeoff

    Country-State Selector

    My bad: I thought that was a double-quotation mark (") :blush:
  13. jgeoff

    New York Sales Tax

    I just discovered a major problem w/ the add-on: New York State requires tax to be charged on intrastate shipping as well. Is there a work-around? Thanks, JG
  14. jgeoff

    Country-State Selector

    That makes most of the code (until the HTML) turn grey if I do that, in Notepad++, so that doesn't seem exactly right, syntax wise...?
  15. jgeoff

    New York Sales Tax

    The New York State Tax By Zip Code add-on does work well, and FWIW, I just updated the SQL file to reflect the tax rates that went into effect Dec 2007
×