Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by sgflowers

  1. sgflowers

    family 3.0 problems

    hi i didn't see a thread for this contribution yet when i click on assign families i do not have any families available in the dropdown i have created 2 families any ideas?? also there are a couple of errors in the install and sql this gives an error in php admin: CREATE TABLE `products_families` ( `family_id` SMALLINT( 3 ) NOT NULL , `products_id` SMALLINT( 3 ) NOT NULL , ); also CREATE TABLE `Families` ( `family_id` SMALLINT( 3 ) NOT NULL AUTO_INCREMENT, `family_name` VARCHAR( 20 ) NOT NULL , PRIMARY KEY ( `family_id` ) ); Families should be families otherwize you get errors in admin in the install: 12.) Add the following code to /catalog/admin/includes/database_tables.php file: define('TABLE_FAMILIES', 'families'); should also have: define('TABLE_PRODUCTS_FAMILIES', 'products_families'); i still can't get the admin to work though...
  2. Just wondering if there is a contribution that will do this: create a discount package for specials... here is what i mean... product A $10 product B $15 we have a product called special package 1 special package contains qty 1 of product A and qty 1 of product B cost is $20 (save $5) when someone purchases special package 1 it would: -give discounted price -take 1 product A and 1 Product B out of inventory -give a custom description / product package name
  3. sgflowers

    In the 'Search 404 Page' Contribution

    .htaccess files affect all subdirectorys so generally you would put it in the catalog root - kevin
  4. sgflowers

    Recover Cart Sales

    that fixed it! works great lightning fast
  5. sgflowers

    Recover Cart Sales

    What version of OSC are you using? Have you used version 1.0 before of RCS Tool? If 1.2 is your first try with this tool then try 1.0 and see if you have the same problems or if it is only with 1.2 and 1.3? Do you have the SHOW_ATTRIBUTES set to TRUE or FALSE? Also do you use Attributes with your products? osc ms2 lots of attributes attributes set to false
  6. sgflowers

    Recover Cart Sales

    Then that is most likely related to the performance issue for the Attributes, that has hopifully been fixed with the version 1.3 that will be out within the next 30 minutes, me and Met00 are finializing a few last minute issues as I type. You either have a slow server, or short timeouts on your SQL server, or both. The attribute code has been optimized, and the attributes can be disabled now as well. When 1.3 is released please try it and see if it fixes the problem. same thing with 1.3 any ideas? thank you, kevin
  7. sgflowers

    Recover Cart Sales

    that is what i am using it only displays on a setting of 0 days and anything large than that takes forever to run then displays blank page
  8. sgflowers

    Recover Cart Sales

    1. I will try the other contribution. 2. No, everything looks ok, except that it doesn't work. After "executing" search nothing is found. Thanks. Kind regards, Raul I have the same problem with recover sales 1.2 displays nothing after long search unsold carts worked fine for me... recover sales> no errors just nothing displayed on page after search ie blank page after it goes to recover_cart_sales.php
  9. sgflowers

    Abandoned Carts

    same issue here: Fatal error: Call to undefined function: money_format() in /httpdocs/admin_tep/stats_unsold_carts.php on line 124
  10. sgflowers

    Admin protection

    use htaccess or the adminitrators contribution they both work...
  11. sgflowers

    family 3.0 problems

    any word on a resolution of this error: CODE 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 ') and p.products_id = pf.products_id and p.products_id != '88' select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products_families pf, products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and () and p.products_id = pf.products_id and p.products_id != '88' limit 9
  12. Hello, just looking for some feedback on some who have tried the x-sell and the family products mods. I am running ms2 and want to install one of the two. not try to cause a debate here and i thank both authors for their contrib. I just want to know the differences If i don`t hear anything i will probably just end up installing both and go from there... Thanks, Kevin sgflowers
  13. sgflowers

    NewsBox Mod Update

    I had the same problem with the previous version i can't seem to get it to display the news file see on the mainpage www.secretgardenflowers.com any ideas??
  14. sgflowers

    family 3.0 problems

    My previosly mentioned fix worked, again, fine. Getting same error 3.3 install familty products any fix chris??
  15. sgflowers

    Family Product v3.0

    still can't get it to work after i assign a bunch of products to a family then what do i have to do thanks, kevin
  16. sgflowers

    family 3.0 problems

    ok also i am not clear on how to use this contrib i assigned a bunch of accessories to a family called "accessories" what is the next step...
  17. sgflowers

    family 3.0 problems

    chris, any other changes from 3.0 to 3.1?
  18. sgflowers

    family 3.0 problems

    also if you change the group id for families (16) i had to use 17 because another contrib was using 16 i has to edit admin/select_family_display.php for all occurance of 16 and change to 17
  19. sgflowers

    help with currencies in header

    i was trying to do a reply to sec thread sorry
  20. hello, i cannot get the currency to display properly in the header <?php // show languages in header if (SHOW_CURRENCIES_IN_HEADER=='1') { ?> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr class="header"> <td class="main" align="right" height="30" valign="middle"><?php require(DIR_WS_INCLUDES . 'currencies_in_header.php'); ?></td> </tr> </table> <?php } ?> here is the section from catalog/includes/header.php i can't figure out what to change so that it displays properly see:(at top right) www.secretgardenflowers.com
  21. sgflowers

    Canada Post Mod

    have you tried the latest cp mod (v3.5) it works great
  22. sgflowers

    [Contribution] Family Products-MS2

    have you figured out what happens when 2 families are assigned to a product? i would suggested either displaying both or random between is there any way options for this could be set by product sounds pretty complicated easy to write as a request for you i guess can't wait to try out v3 thanks 4 your work
  23. new version looks great can't wait to give it a spin...
  24. sgflowers

    [Contribution] Family Products-MS2

    I think a random selection from the family would be a great feature ie 15 products are listed as family products but you only want display say 6 it randomly picks 6 to display
  25. sgflowers

    [Contribution] Family Products-MS2

    I am a bit confused as well with xsell i can assign a specific product suggestion to a specific product is this possible with family products or does the whole family of products get shown