Jump to content

Java Roasters

♥Ambassador
  • Content count

    2,058
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by Java Roasters

  1. Happy Birthday Harald    :)

  2. Package Tracking for Canada Post Based on Package Tracking UPS, USPS, & Fedex Version 1.3 by Wayne Wetterhahn (Hard Media) and with special thanks to yesUdo for his amazing help in putting this together. Description: This contribution allows osCommerce store owners to provide real-time Canada Post package tracking to their customers. Store owners just enter the tracking number into a text box on the orders page inside the admin. This should be done when updating the order status to ?Shipped?. The customer will receive an email as usual telling them the order has been updated. Included in the email is a link which takes them to their account page on your website. On the order details page, the customer will find a box with their tracking number and a clickable box to track their package. This will open a new window, so the customer never leaves your website. If you do not want a customer to receive a tracking number or if you did not ship with a method that provides a tracking number, don't include one when updating the order. I will do my best to answer questions regarding this package but it is just a hack and I am not the best at PHP.
  3. @ satish: If you put the first letter at the end of the word, it spells the same word backwards.

  4. In the Configuration Table, Configuration ID 76 MODULE_PAYMENT_CC_STATUS is not needed anymore and can be removed. It is not referenced in osC code base anymore.
  5. Java Roasters

    Seperate Pricing Per Customer v3.5

    Hi Jan, After looking at several solutions I really just needed to display the attribute prices differently. I installed a contribution that shows the actual product price in the attribute price dropdown which solved half the problem. I then created a new way to list items instead of the traditional dropdown, checkbox, etc. I just made one that used the input type "hidden" to show just a list of the attributes. Added to functions/html_output.php // Output a form list menu for product info page function tep_draw_list_menu($name, $values, $default = '', $parameters = '', $required = false) { $field =''; if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]); for ($i=0, $n=sizeof($values); $i<$n; $i++) { $value = tep_output_string($values[$i]['id']); $field .= '<input type="hidden" name="' . $name . '" value="' . $value . '"'; $field .= ' '; $field .= '>' . tep_output_string($values[$i]['text'], array('"' => ' '')) . '<br>'; } $field .= ''; return $field; } Then changed the lines in product_info.php to <td class="main" valign="top" style="padding-right:10px; font-weight:bold"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_list_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td> That displayed the actual product prices for each attribute in a list form and takes away the option of selecting an option which I did not need for just a catalog (no shopping).
  6. Java Roasters

    Seperate Pricing Per Customer v3.5

    I am trying to figure out how to display some prices but have run into a snag. I am building a site that is to be used as a catalog only, no checkout. The store has lots of products that have several sizes such as Small, Medium, Large, etc. and all the different sizes have different prices for Retail and Wholesale groups. I am looking for ideas on how to display the different prices on the product pages so the correct prices show up for each of the groups. Thanks,
  7. Java Roasters

    Accessibility issues

    Burt (community member) has an ebook on making osC 2.2 accessible.
  8. Java Roasters

    Canada Post

    Sorry I didn't realize you were looking for a V3 module. The contributions are all for V2.
  9. Java Roasters

    Canada Post

    What is wrong with one of the modules here? http://addons.oscommerce.com/category?search=canadapost PS links to your site are not allowed in signatures here.
  10. This is a simple hack of the files in catalog/includes/boxes/** so they do not use the box class anymore. I feel this makes them easier to make them unique and different than other osC stores. I also included the file for catalog/includes/modules/new_products.php but there are still a lot of files to do if you don't want the box class anywhere in your site. I hope it helps someone and if people like it then we can finish all the files needed.
  11. Java Roasters

    Boxes without the boxes class

    No, but it is a 2 minute install if you wanted to see how it works.
  12. Java Roasters

    Boxes without the boxes class

    Here is the contribution http://addons.oscommerce.com/info/6719
  13. Thanks for all your work keeping the forum running so all of us can enjoy it and learn from each other.

  14. You can set up a product for it and then have the customer billed once every month or whenever. Do not store CC details in your DB, let your payment provider do that. http://addons.oscommerce.com/category?search=recurring
  15. Java Roasters

    Admin control panel & 500 error on it ?

    Remove the .htaccess file and add it back in one bit at a time till you find the part that is causing the problem.
  16. Java Roasters

    [Contribution] CSS Buttons Everywhere

    I added an update to the package that should fix the difference between the regular buttons and the submit buttons. They all look the same now. It is not my code, it is from Basic Design Contribution, I just googled it and found the missing bit of code there.
  17. I am not only proud to say he was our main coder but even more proud to call him a friend. Thanks for ALL your amazing help and your coding skills.

  18. When I first started with osC I knew nothing about PHP or HTML. Emmett helped me not only install the contributions but also helped me understand PHP. I would not have lasted here without his endless support and energy. If you need PHP code custom written or a store designed I highly recommend his services.

    I am not only proud to say he was our main coder but even more proud to call

  19. What version of osC is your template for? You might now have a catalog part from one version and the admin from another, not good. If needed check the contributions section for a register globals patch or you can create your own php.ini file if your host allows that (google will tell you how to do that). But first try to match your catalog and admin folders to the same version.
  20. Java Roasters

    Which version to install for Chemo's SEO Urls

    osCommerce and CRE may have started off similar but are now very different. I am not sure anyone here will be able to help. If it is not showing the admin I do know all the DB entries are done on the first page call from your site. Go to www.yourdomain.com and then it will show up in the admin. At least that is how it is done on an osC site. I would go back to the last version written by Chemo and start there but it won't work for PHP5 / MySQL5.
  21. Java Roasters

    [Contribution] U HTML Emails

    I just installed it with NO problems on 2.2ms2-060817. It is a VERY easy install and works great. The only thing I have seen is that on the create account email the subject was "EMAIL_SUBJECT" instead of "Welcome to STORE NAME". I am sure that is a 2 minute fix. The emails look great out of the box but I only tested in Thunderbird. This is an excellent piece of work. :thumbsup:
  22. Java Roasters

    Error when trying an advanced search

    I fixed it by changing (around line 260) if ($status_tmp_product_prices_table == true) { $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; } elseif ($status_tmp_special_prices_table == true) { $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; } else { $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; } To if ($status_tmp_product_prices_table == true) { $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . $product_prices_table . " as tmp_pp using(products_id)"; } elseif ($status_tmp_special_prices_table == true) { $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id "; } else { $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; }
  23. Java Roasters

    Customer Account logic

    With SPPC4.1 and Address Enhancer installed we accomplished what we wanted by making the Company Name permanent similar to the Tax ID Number. Then in address_book.php we just edited a couple of parts; <tr> <td class="main" align="right" valign="top"><b><?php // echo PRIMARY_ADDRESS_TITLE; ?></b></td> <td><?php // echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" valign="top"><?php // echo tep_get_address_book_list('primary', $customer_default_address_id, $customer_id); ?></td> <td><?php // echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> To take out the choice customers had to change their primary address book entry. Then a bit further down the page we changed to; <?php if ($addresses['address_book_id'] == $customer_default_address_id) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo tep_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'edit=' . $addresses['address_book_id'], 'SSL'); ?>'"> <td class="main"><b><?php echo tep_output_string_protected($addresses['id_name']); //rmh addr-enhancer ?></b><?php echo ' <small><i>' . $address_text . '</i></small>'; //rmh addr-enhancer?></td> <td class="main" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'edit=' . $addresses['address_book_id'], 'SSL') . '">' . tep_image_button('small_edit.gif', SMALL_IMAGE_BUTTON_EDIT) . '</a>'; ?><?php echo tep_draw_separator('pixel_trans.gif', '50', '1'); ?></td> </tr> <?php } else { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="moduleRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo tep_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'edit=' . $addresses['address_book_id'], 'SSL'); ?>'"> <td class="main"><b><?php echo tep_output_string_protected($addresses['id_name']); //rmh addr-enhancer ?></b><?php echo ' <small><i>' . $address_text . '</i></small>'; //rmh addr-enhancer?></td> <td class="main" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'edit=' . $addresses['address_book_id'], 'SSL') . '">' . tep_image_button('small_edit.gif', SMALL_IMAGE_BUTTON_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'delete=' . $addresses['address_book_id'], 'SSL') . '">' . tep_image_button('small_delete.gif', SMALL_IMAGE_BUTTON_DELETE) . '</a>'; ?></td> </tr> <?php } ?> This just checks for the primary address and then only displays the "edit" button for that entry but still allows the "edit" and "delete" button for the other entries in the address book. When a customer signs up for an account and has filled in the Company and Tax fields they can be approved for the "wholesale" customer pricing and taxes. But now the info they entered can not be changed or deleted by them making it always available for tax records.
  24. Java Roasters

    Customer Account logic

    We have been working on a "new" version of our site (3rd) and have been looking at the customer account logic especially when it comes to customers that are offices (ones that have entered a company name). With standard osC a company can enter their name and purchase products from your store. If they get it tax exempt then you would have to get their tax number also. Now, a customer can enter a different address without the company name and then delete the one with the company but continue to purchase from the store but with no record of the company they are associated with. Now if you have SPPC installed which does store the tax number but makes it uneditable you can offer a company tax exempt status and then they can remove the company name and also their tax number by adding another address and then delete the original address with that information. If you get audited by the gov't years later then you can get hit for all the taxes owing that should have been paid for that customer. Has anyone got a work around for this or advice on how to keep the info permanently and not have the customer be able to delete it. I know the easy solution is to only have one address book entry per customer but that seldom works with small companies that put purchases on their personal credit card. Thanks, Peter
  25. Java Roasters

    Customer Account logic

    Attaching the tax id to the table_customer makes much more sense and does then allow the customer to change their address book but not allow them to remove/change the tax id number. Good work.
×