Jump to content

The Lego Man

Members
  • Content count

    43
  • Joined

  • Last visited

Everything posted by The Lego Man

  1. I downloaded and installed the following Producs / Sort add-on from @geoffrywalton http://addons.oscommerce.com/info/8311 It appears to be working fine on the Admin side (ie in Admin I can sort products upon allocating them a numerical value). However from the customer side (store category) the products remain listed in alphabetical order. Did I misunderstand the add-on does anyone know or is there some trick I am missing? My OSC version is v2.3.3. The add-on is stated as for 2.3
  2. Hi, I am currently using osCommerce Online Merchant v2.3.3 I want to install a Guest Checkout module so that buyers do not need to sign-up but can still make purchases. I have searched http://addons.oscommerce.com/category?search=GUEST+CHECKOUT and some results do appear but I am unsure as to which one will work with my version. Has anyone tried to install one for v2.3.3 without issues? Thanks, David
  3. The Lego Man

    Product / Sort add-on not working as expected

    Can anyone help? :(
  4. The Lego Man

    Product / Sort add-on not working as expected

    Any ideas anybody for this problem? @@geoffreywalton
  5. The Lego Man

    Product / Sort add-on not working as expected

    The install instructions state : catalog/admin/categories.php Line 20 After if (tep_not_null($action)) { switch ($action) { add //sort order case 'beginsort': $sorting = true; break; tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_POST_VARS['cPath'])); case 'setsortorder': for ($i=0, $n=sizeof($HTTP_POST_VARS['products_id']); $i<$n; $i++) { tep_set_product_sort_order($HTTP_POST_VARS['products_id'][$i], $HTTP_POST_VARS['sortorder'][$i]); } $sorting = false; tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_POST_VARS['cPath'])); break; //end sort order However my code already has the following modification in this area: if (tep_not_null($action)) { // ULTIMATE Seo Urls 5 PRO by FWR Media // If the action will affect the cache entries if ( $action == 'insert' || $action == 'update' || $action == 'setflag' ) { tep_reset_cache_data_usu5( 'reset' ); } switch ($action) { I therefore am trying the following: if (tep_not_null($action)) { // ULTIMATE Seo Urls 5 PRO by FWR Media // If the action will affect the cache entries if ( $action == 'insert' || $action == 'update' || $action == 'setflag' ) { tep_reset_cache_data_usu5( 'reset' ); } switch ($action) { //sort order case 'beginsort': $sorting = true; break; tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_POST_VARS['cPath'])); case 'setsortorder': for ($i=0, $n=sizeof($HTTP_POST_VARS['products_id']); $i<$n; $i++) { tep_set_product_sort_order($HTTP_POST_VARS['products_id'][$i], $HTTP_POST_VARS['sortorder'][$i]); } $sorting = false; tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_POST_VARS['cPath'])); break; //end sort order Could this be the problem?
  6. The Lego Man

    Product / Sort add-on not working as expected

    Was worth a try but ... no luck.
  7. The Lego Man

    Product / Sort add-on not working as expected

    Yes, on the Admin side, the products display correctly as expected i.e. in the sorted order. Customer side however is in standard alphabetical order.
  8. The Lego Man

    Product / Sort add-on not working as expected

    Can I ask, are you running 2.3.3 and does the visitor to your store see the products in the order you have sorted them? Appreciate your help!
  9. The Lego Man

    Product / Sort add-on not working as expected

    Martin Thanks for the reply. I have no + sign nor do I remember having one beforehand. I have doubled checked the SQL queries. Second one is still in the configuration table.
  10. The Lego Man

    Adding Category Descriptions to osC v.2.3.1

    Steve, Thanks. I will take a look there so!
  11. The Lego Man

    Adding Category Descriptions to osC v.2.3.1

    Hi I have installed this and it is working correctly however I do not wish to display the category image on top of each category (I only wish for the text to show). Any ideas on whether I can do this? Thank you.
  12. The Lego Man

    Guest Checkout options for v2.3.3 ?

    Thanks all for the feedback and options. I will investigate.
  13. The Lego Man

    Quantity box in product listing 1.2 for 2.3

    Thanks @@greasemonkey I had installed some other add-on. All removed now. Thank you!
  14. The Lego Man

    Quantity box in product listing 1.2 for 2.3

    @@greasemonkey I downloaded qbox and uploaded the files from the aas_v0.2_bugfixes folder. No files were overwritten so I'm taking it that all files were new. I don't see any difference to the product page. No qty box visible. Did I only upload files to fix a bug ? Any ideas?
  15. The Lego Man

    Quantity box in product listing 1.2 for 2.3

    @@greasemonkey Hi again, Just curious as to whether it is possible to have the quantity box display on the product's individual page as well as the on the category page. Currently I have it working on the category page but if you click on a product it doesn't show.
  16. The Lego Man

    Quantity box in product listing 1.2 for 2.3

    @@greasemonkey Really appreciate your help with this, it is working as hoped now. Made my day. Thank you!
  17. The Lego Man

    Quantity box in product listing 1.2 for 2.3

    @@greasemonkey Thank you for the reply! Yes, I have made the changes to application_top To get the box to appear where I want it, I simply placed your suggested code in the the prod_list_grid line (please see below) Note - changing the $prod_list_contents had no effect, probably as I am using a grid layout for my products - so this line (second line) is unchanged in both code snippets below. My previous code was as follows: case 'PRODUCT_LIST_BUY_NOW': $prod_list_contents .= ' <td align="center">' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'products_id')) . 'action=buy_now&products_id=' . $listing['products_id'])) . '</td>'; $prod_list_grid .= '<br>' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id'])); break; Replaced with: case 'PRODUCT_LIST_BUY_NOW': $prod_list_contents .= ' <td align="center">' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'products_id')) . 'action=buy_now&products_id=' . $listing['products_id'])) . '</td>'; $prod_list_grid .= '<br>' . tep_draw_form('buy_now', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id='. $listing[$x]['products_id']), 'POST') . '<table cellSpacing="0" cellPadding="0" width="100%"><tr><td align="right" width="25%">' . tep_draw_input_field('buyqty', '1', 'size=3 maxlength=3') . '</td><td align="center" width="75%" valign="absmiddle">' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart') . '<td align="absmiddle">' . '</td></tr></table></form>'; break; See screenshot of before (L) and after (R ) below is shown here http://minifigbay.com/after.png
  18. Hi, As part of the installation of a contribution I have to run the following SQL database query: DROP TABLE IF EXISTS `products_cross_sell`; CREATE TABLE IF NOT EXISTS `products_cross_sell` ( `products_cross_sell_id` int(10) NOT NULL auto_increment, `products_id` int(10) unsigned NOT NULL default '1', `cross_sell_id` int(10) unsigned NOT NULL default '1', `cross_sell_sort_order` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`products_cross_sell_id`) ) TYPE=MyISAM; When I do this I get the following error message: #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 'TYPE=MyISAM' at line 7 Is there an obvious error does anyone know? Thanks David
  19. The Lego Man

    Quantity box in product listing 1.2 for 2.3

    Hi Scott, I am currently trying to get this set up for my site however as my product_info file has already been modified I am unsure how to do step 2: change from; $prod_list_contents .= ' <td align="center">' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing[$x]['products_id'])) . '</td>'; to -----> $prod_list_contents .= ' <td align="center">' . tep_draw_form('buy_now', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id='. $listing[$x]['products_id']), 'POST') . '<table cellSpacing="0" cellPadding="0" width="100%"><tr><td align="right" width="25%">' . tep_draw_input_field('buyqty', '1', 'size=3 maxlength=3') . '</td><td align="center" width="75%" valign="absmiddle">' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart') . '<td align="absmiddle">' . '</td></tr></table></form>'; The code I have is as follows: case 'PRODUCT_LIST_BUY_NOW': $prod_list_contents .= ' <td align="center">' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'products_id')) . 'action=buy_now&products_id=' . $listing['products_id'])) . '</td>'; $prod_list_grid .= '<br>' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id'])); break; } I am using a Grid product layout for some pages. Any help with figuring out what I need to do to correctly add in the quantity boxes would be great. I am able to get the quantity box to appear alongside the buy now button however the functionality of the produced actually being added to the shopping cart is not working. Thanks, David
  20. Hi all, For the last 12 months or so I have been regularly keeping an eye out for a Points and Rewards / Loyalty points module that works with my OSC installation (currently its v2.3.3). Does anyone know if one exists or if one is in the pipeline? When I have searched Add-Ons the most appropriate one appears to be POINTS AND REWARDS MODULE V1.00 http://addons.oscommerce.com/info/3220 however this Add-On appears to only work with v2.2. I have not been keep on trying this out on my v2.3.3. in case it corrupts my database. Any ideas or suggestions greatly appreciated. Thanks, David
  21. The Lego Man

    ### POINTS AND REWARDS MODULE V1.00 ###

    Hi all, Does this module work for v2.3.1 ? When I browse to http://www.YOUR DOMAIN NAME / YOUR CATALOG DIR / admin/installer.php I get to the Points/RewardsV2.1beta - DataBase Setup interface. When I click Install This Module an error message is displayed stating: Warning: Cannot modify header information - headers already sent by (output started at /home/.../public_html/....com/admin/installer.php:31) in /home/.../public_html/......com/admin/installer.php on line 242 Any ideas?
  22. The Lego Man

    ### POINTS AND REWARDS MODULE V1.00 ###

    Hello, Has anyone implemented this contribution successfully for v2.3.1 following the guide? The documentation on http://addons.oscommerce.com/info/3220 states it was tested on Version 2.2MS2 yet on the history page the most recent entry states "Complete Package for 2.3x".
×