Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sfergus

Archived
  • Posts

    13
  • Joined

  • Last visited

Profile Information

  • Real Name
    S Fergus

sfergus's Achievements

  1. Hello again, I hope you can help me with this. I've installed a lot of contributions and done a lot of line editing of the code based on instructions, but I'm no programmer. So this contribution is probably beyond me unless I get a little help, and I really need it done. I just need to know what code to use in order to have the discount trigger when a specific item is in the cart. Also, I need to figure out what code to use when a combination of specific items are in the cart. I'm pretty sure I can do the easy charge instead of the easy discount (I did read the earlier posts about that). Thanks again for any help.
  2. Hi Amanda, This looks like an excellent contribution. I have a couple questions before I install it. Can I use this to trigger when specific items are in the cart? Can I use this to apply an extra charge to an item, rather than a discount? I'd like to sell products from a certain category that will have a higher individual cost if they are the ONLY products from that category in the shopping cart. Hence the reason I want an extra charge for an item. Then I'd like to have another extra charge, but not as high, if multiple items from the same category are present in the cart. But it would only apply the extra charge for a certain amount of items (probably 4 items from the category). Each additional group of 4 would incur the extra charge again. I'm selling some products that must be refrigerated, and I have special packaging to use. Each package can hold a certain amount of items. A single refrigerated item will cost more by itself to ship than a group of them. Thanks for any help.
  3. Hi, I have a shipping problem I can't figure out. I ship some things that require refrigeration. If a customer only orders one bottle, that's fine because I think I can use the Individual Product Shipping Prices. But I want to offer the customer the ability to buy more than one refrigerated product, but use the same package to ship all of their products. So I don't want the extra charge for the individual product applied if there are multiple products with the extra charge in the order. Any thoughts as to how I would accomplish this?
  4. Nevermind! I just found the site with the software for sale. I didn't see it in the 50 pages of this forum thread. We'll probably just buy 3.0.
  5. Hi, I need a Quickbooks contrib like this one. The work done to date looks awesome, and should fit my needs. Adam, do you mean you won't ever be posting v.3.0? A new version would be great, but should I just get 2.1 and install it now if 3.0 won't be coming? I'd love to have use the new version, but my clients want their Quickbooks going as soon as possible.
  6. Oscommerce supports downloads by default, but the method is not very practical. You'll probably need to install a downloads controller such as this: http://www.oscommerce.com/community/contri...oads+controller and if you're using a payment gateway to process credit cards, you'll need a contribution for your gateway. Be sure that when you install contribs like this that you back up, and use a file comparison program such as Beyond Compare, because gateway contribs will probably modify some of the same files as the download controller.
  7. :D Nevermind! I fixed it. Turns out it was the Add Weight to Product Attributes v0.2 contribution. I uninstalled that and removed the field from the database, and the download works fine now. That contribution seemed buggy anyway; it never really calculated the weight correctly for multiple orders of the same product. Now I just need to find another way to make the same product have different weight options. But I'm happy. The downloads are a much bigger part of my sales. :thumbsup:
  8. I've done some more looking, and I wonder if the download.php file is also being used, in addition to the downloads.php file. Perhaps this is where the extra links are coming from. Or maybe the Downloads Controller is somehow adding the download product attribute to the physical items in the cart. Does anyone have any ideas for what I can do?
  9. Go to your Admin tool, select Catalog > Products Attribute. Set up an option for Standard and for Rush. You can add to the total price of an item if they select Rush. You should have the Standard so that it is the first option on a product by default. Also, are you using Fedex contributions at all? They have overnight shipping options. Wouldn't this work as well?
  10. I've done extensive searching of the forums and I can't find the solution to this. My store sells both virutal and physical goods. If both types are in the cart, after checkout the customer will see download links for physical goods. This is clearly not supposed to happen. Here's a screenshot of what is occuring: The only thing that should have a link is CAM Skin Intensive Matters. Another odd problem is that an extra link is being generated for the virtual goods. I'm using Downloads Controller v5.3 and Paypal Website Payments Pro v7.3. My store is www.gloriagillbere.com/OsCommerce. If you go there, please be gentle and ignore the image quality (I'm getting better ones soon). I suspect the solution to this problem lies in the downloads.php file, but I lack the php knowledge to figure it out. The contents of my downloads.php file: <?php /* $Id: downloads.php,v 1.3 2003/06/09 22:49:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- downloads //--> <?php if (!strstr($PHP_SELF, FILENAME_ACCOUNT_HISTORY_INFO)) { // Get last order id for checkout_success $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by orders_id desc limit 1"); $orders = tep_db_fetch_array($orders_query); $last_order = $orders['orders_id']; } else { $last_order = $HTTP_GET_VARS['order_id']; } // Now get all downloadable products in that order // BOF: WebMakers.com Added: Downloads Controller // DEFINE WHICH ORDERS_STATUS TO USE IN downloads_controller.php // USE last_modified instead of date_purchased // original $downloads_query = tep_db_query("select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ''"); $downloads_query = tep_db_query("select o.orders_status, date_format(o.last_modified, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . (int)$customer_id . "' and o.orders_status >= '" . DOWNLOADS_CONTROLLER_ORDERS_STATUS . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ''"); if (tep_db_num_rows($downloads_query) > 0) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo HEADING_DOWNLOAD; ?></b></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <!-- list of products --> <?php while ($downloads = tep_db_fetch_array($downloads_query)) { // MySQL 3.22 does not have INTERVAL list($dt_year, $dt_month, $dt_day) = explode('-', $downloads['date_purchased_day']); $download_timestamp = mktime(23, 59, 59, $dt_month, $dt_day + $downloads['download_maxdays'], $dt_year); $download_expiry = date('Y-m-d H:i:s', $download_timestamp); ?> <tr class="infoBoxContents"> <!-- left box --> <?php // The link will appear only if: // - Download remaining count is > 0, AND // - The file is present in the DOWNLOAD directory, AND EITHER // - No expiry date is enforced (maxdays == 0), OR // - The expiry date is not reached if ( ($downloads['download_count'] > 0) && (file_exists(DIR_FS_DOWNLOAD . $downloads['orders_products_filename'])) && ( ($downloads['download_maxdays'] == 0) || ($download_timestamp > time())) ) { // WebMakers.com Added: Downloads Controller Show Button // original MS1 echo ' <td class="main"><a href="' . tep_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads['orders_products_download_id']) . '">' . $downloads['products_name'] . '</a></td>' . "\n"; echo ' <td class="main" align="center"><a href="' . tep_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads['orders_products_download_id']) . '">' . $downloads['products_name'] . '<br>' . tep_image_button('button_download.gif', '') . '</a></td>' . "\n"; } else { echo ' <td class="main">' . $downloads['products_name'] . '</td>' . "\n"; } ?> <!-- right box --> <?php // BOF: WebMakers.com Added: Downloads Controller echo ' <td class="main">' . TABLE_HEADING_DOWNLOAD_DATE . '<br>' . tep_date_long($download_expiry) . '</td>' . "\n" . ' <td class="main" align="right">' . $downloads['download_count'] . TABLE_HEADING_DOWNLOAD_COUNT . '</td>' . "\n" . ' </tr>' . "\n"; // EOF: WebMakers.com Added: Downloads Controller } ?> </tr> </table></td> </tr> <?php if (!strstr($PHP_SELF, FILENAME_ACCOUNT_HISTORY_INFO)) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="smalltext" colspan="4"><p><?php printf(FOOTER_DOWNLOAD, '<a href="' . tep_href_link(FILENAME_ACCOUNT, '', 'SSL') . '">' . HEADER_TITLE_MY_ACCOUNT . '</a>'); ?></p></td> </tr> <?php } } ?> <?php // BOF: WebMakers.com Added: Downloads Controller // If there is a download in the order and they cannot get it, tell customer about download rules $downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''"); if (tep_db_num_rows($downloads_check_query) > 0 and tep_db_num_rows($downloads_query) < 1) { // if (tep_db_num_rows($downloads_query) < 1) { ?> <tr> <td colspan="3" align="center" valign="top" class="main" height="30"><FONT FACE="Arial" SIZE=1 COLOR="FF000"><?php echo DOWNLOADS_CONTROLLER_ON_HOLD_MSG ?></FONT></td> </tr> <?php } // EOF: WebMakers.com Added: Downloads Controller ?> <!-- downloads_eof //-->
×
×
  • Create New...