Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ChilliNr1

Pioneers
  • Posts

    59
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by ChilliNr1

  1. Just realised, the characters at the start of the link, which cause it to fail, are whatever I have in the catalogue path in the config file. What have I done wrong?

    Hi there,

    same problem for me!

    If I try to klick any Link inside Cooliris, the following error shows up:

    The requested URL /catalog/http://www.folienqueen.de/catalog/product_info.php?products_id=51 was not found on this server.

    Where can I change it? This is what`s in the adress line:

    http://www.folienqueen.de/catalog/http%3A%2F%2Fwww.folienqueen.de%2Fcatalog%2Fproduct_info.php%3Fproducts_id%3D51

    Thanks in advance!

  2. Hi,

    the Coupon is working fine for me, except one little thing:

    I set the min. order amount at 20Euro and give a discount over 10Euro.

    If your cart has an amount from 1-9Euro, you`ll get an error message!

    From 10-xxxEuro, you`ll get the discount. But you shouldn`t!

    Only for 20Euro and up... Why is there a 10Euro "discount hole"?

    If I set the amount to 30Euro, it works fine!!!

    The only thing is, under 20Euro cart worth, the error message says:

    "Min. amount is 30Euro!" Not right but working this way.

    Where`s the hook?

     

    Is it in includes/classes/discount_coupon.php?

    Maybe here somewhere:

     function check_coupons_min_order() {
      switch( $this->coupon['coupons_min_order_type'] ) {
    	//minimum number of products:
    	case 'quantity':
    	  global $cart;
    	  $total = $this->cart_info['valid_products']['count'];
    	  if( $this->coupon['coupons_min_order'] > $total ) { //make sure there are enough products in the cart
    		$this->message( sprintf( ENTRY_DISCOUNT_COUPON_MIN_QUANTITY_ERROR, $this->coupon['coupons_min_order'] ) );
    		if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DEBUG == 'true' ) $this->message( 'INFO: Failed to pass check_coupons_min_order(): $total='.$total, 'debug' );
    		return false;
    	  }
    	  break;
    	//minimum price:
    	case 'price':
    	default:
    	  global $order, $currencies;
    	  $total = $this->cart_info['valid_products']['total'];
    	  //if we display the subtotal without the discount applied, then just compare the subtotal to the minimum order
    	  if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_SUBTOTAL == 'false' && $this->coupon['coupons_min_order'] > $total ) {
    		$this->message( sprintf( ENTRY_DISCOUNT_COUPON_MIN_PRICE_ERROR, $currencies->format( $this->coupon['coupons_min_order'], true, $order->info['currency'], $order->info['currency_value'] ) ).'.' );
    		if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DEBUG == 'true' ) $this->message( 'INFO: Failed to pass check_coupons_min_order(): $total='.$total, 'debug' );
    		return false;
    	  //if we display the subtotal with the discount applied, then we need to compare the subtotal with the discount added back in to the minimum order
    	  } else if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_SUBTOTAL == 'true' ) {
    		$subtotal = $total;
    		foreach( $this->applied_discount as $discount ) {
    		  $subtotal += $discount;
    		}
    		if( $this->coupon['coupons_min_order'] > $subtotal ) {
    		  $this->message( sprintf( ENTRY_DISCOUNT_COUPON_MIN_PRICE_ERROR, $currencies->format( $this->coupon['coupons_min_order'], true, $order->info['currency'], $order->info['currency_value'] ) ).'.' );
    		  if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DEBUG == 'true' ) $this->message( 'INFO: Failed to pass check_coupons_min_order(): $subtotal='.$subtotal, 'debug' );
    		  return false;
    		}
    	  }
    	  break;
      }
      return true;
    }

    I`m not sure...

     

    Thank you for your time!

    ChilliNr1

  3. Has anyone come up with a true "fix" for the recalculate shipping function? I looked at the new "Bug Fix" download from February 09 by ChilliNr1 and as far as I can tell it isn't really a fix, it simply doesn't call the recalculate shipping function.

     

    This means the site still won't recalculate shipping if the discount amount changes the order total enough to affect shipping rates. This may not matter if you do everything by weight - but if you are using a table method and/or free shipping contribution, then it does matter.

     

    Anybody have any idea how to get the function is_recalc_shipping working properly with table rates and or free shipping contributions?

    Hi,

    I`m using the free shipping module when purchase is over 50Euro.

    That`s why I fixed (deleted the call for recalculating) it!

    Before that, you have an amount over 50Euro for example in your cart and free shipping.

    When you`ve entered a coupon code and the amount is recalculated below 50Euro,

    you`ve to pay shipping again...

    I don`t use shipping per weight or anything like that!

    It`ll work with the free shipping module!!!

    I can`t say how it affects the table method?!

     

    Can anyone help me?

     

    I'd like to include shipping cost when using percentage discount. Let's say I have a 10% percentage discount. I hope, the discount = 10% * ( price total + shipping cost).

     

    I found from the discout_coupon.php that there are two functions may be important. But I failed many times after I tried to modifiy them. Can you give me some advice?

     

    Thank you in advance.

    Hi,

    with this option in admin, it`s not possible at all.

    It`s not only change some rows in discout_coupon.php...

    It`s a little bit more complicated than that!

    But what is it good for?

    It`s not more attractiv to customers, than give discount by shopping cart worth...

    For example: Give 10% for 10Euro, 20% for 25Euro, 30% for 40Euro and so on, but stop before giving 100% ;)

    Or you can give procebtual discount an shipping up to free shipping.

    But both isn`t more attractiv in my eyes!

    Greetings!

  4. Hi,

    I still got the following error and I don`t know why?!

    It does not appear after checkout,

    only when I`m looking at my history and then trying to print invoice.

    The error comes at the Order History Line before the footer...

    Any idea?

    1054 - Unknown column 'os.public_flag' in 'where clause'
    
    select os.orders_status_name, osh.date_added, osh.comments from orders_status os, orders_status_history osh where osh.orders_id = '1' and osh.orders_status_id = os.orders_status_id and os.language_id = '2' and os.public_flag = '1' order by osh.date_added
    
    [TEP STOP]

    Thank you!

  5. This is not a bad idea, thanks for the suggestions!

    Hi,

    have you seen this? LINK

    There you get a discount when you buy 3 items for the cheapest one...

    Maybe this is interessting for you!

    @DboG: *uff* I don`t know what else could be wrong...

    Download the latest packages and updates and take a look at the files in the admin folder!

    Maybe you can backup your files and overwrite them for testing.

    If they`ll work, you`ll have an error in your files...

    Sorry that`s the only thing I would try :blink:

  6. Thanks. Do you mean the sql_script.sql that's packaged with the 3.32 version, uploaded 1/30/09? When i try to run that SQL query, I get an error "1065 - Query was empty." Am I missing something?

    Hi,

    sorry, my fault. The SQL File isn`t included there.

    Take the next one called: "installer_database"

    This is the sql script only!

    I deleted my tables I`ve created before and reinstalled the database.

    Now it work fine!

    Have a nice day!

  7. @miamizx: Well my dilema is that I have many many products on the site, its impossible to filter by product or manufacturer since I don't know what the user is going to buy. What I wanted to do is give a user a 50% discount off one item(doesn't have to be the first, just any ONE item) instead of the entire order. I guess I would have to just give out $ coupons instead of %

    Hi,

    I think the only way is, to make a couple of coupons...

    First gives you 5$/€ at 20$/€, 10$/€ at 30$/€ and 15$/€ at 45$/€ shopping cart worth for example!

    So you post all coupon codes to your customers, and they choose the discount dependent on the worth of their shopping cart!

    That`s an option!

  8. Hi there! I've scoured this thread for a solution to my issue without success, so hopefully someone could help.

     

    After some fumbling with the apparently broken (though better-documented) dynamoeffects version of the contribution, I cleaned it out and installed the wontonesaju version from 1/28/09 with apparent success. I can create discount coupons and, upon test checkout, they seem to calculate fine.

     

    My issue is that in the coupon administration, whenever I click any of the exclusion buttons for a coupon (e.g. Product Exclusions), I get a blank page. This happens for any of the exclusions. I saw some folks posted a couple months ago with the same problem, but have not seen any fixes. Does anyone have any ideas? I've checked my files and everything seems in order -- is there something I'm overlooking?

     

    Any suggestions are appreciated!

    Hi,

    download the latest version 3.32 and install the sql file!

    Your problem should be solved!

    Greetings!

     

    @miamizx: How should this works? Who knows which one IS the first item in your cart?

    It`s not possible so far. Maybe you can filter some products out by manufactor or something...

  9. Hi, I can't just replace the checkout_confirmation.php file because i have other contribs installed that changed that file.

     

    ¿Could you, please, mark the changes in the file with notes?

     

    I just see one change

     

    // ChilliNr1`s Coupon AND Free Shipping Fix START
    /**************if( $order->coupon->is_recalc_shipping() ) tep_redirect( tep_href_link( FILENAME_CHECKOUT_SHIPPING, 'error_message=' . urlencode( ENTRY_DISCOUNT_COUPON_SHIPPING_CALC_ERROR ), 'SSL' ) ); //redirect to the shipping page to reselect the shipping method**************/
    // ChilliNr1`s Coupon AND Free Shipping Fix END

     

    Is this the only one?

     

    Thank you.

    Hi,

    yep that`s all! ;) I changed the request for the shipping costs.

    You`ve only have to delete if( $order->coupon->is_recalc_shipping() ) tep_redirect( tep_href_link( FILENAME_CHECKOUT_SHIPPING, 'error_message=' . urlencode( ENTRY_DISCOUNT_COUPON_SHIPPING_CALC_ERROR ), 'SSL' ) ); //redirect to the shipping page to reselect the shipping method

    That`s it!

    Greetings!

    @nipunjoshi Sounds complicated. Did you`ve reinstalled the database? Sorry, but that's too deep for me. :blush:

  10. Hi,

    your code solve the problem with the pics in the main "images" folder,

    but it doesn`t help me out with the subfolders?!

    ALL pics are now displayed with images/xxx.jpg

    The others like images/large/xxx.jpg are displayed like images/xxx.jpg and marker as unused...

    Any idea else?

    Thank you so far!

  11. Hi,

    does anyone have an idea how to change the code to display the subtotal WITHOUT the discount?!

    Because my free shipping modul won`t work with that...

    Here`s the code:

    //kgt - discount coupons
    	if( is_object( $this->coupon ) ) {
    	  $applied_discount = 0;
    	  $discount = $this->coupon->calculate_discount( $this->products[$index], $valid_products_count );
    	  if( $discount['applied_discount'] > 0 ) $valid_products_count++;
    	  $shown_price = $this->coupon->calculate_shown_price( $discount, $this->products[$index] );
    	  $this->info['subtotal'] += $shown_price['shown_price'];
    	  $shown_price = $shown_price['actual_shown_price'];
    	} else {
    	  $shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'];
    	  $this->info['subtotal'] += $shown_price;
    	}
    	//end kgt - discount coupons

    Thank you!

  12. Hi,

    I get the following error on the confirmation page if I try to enter the correct code:

    1054 - Unknown column 'geo_zone_id' in 'from clause'
    
    SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id=88 or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id=81 or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="XXX"
    
    [TEP STOP]

    What does it mean?

    Thank you!

    Hi together,

    saju from wontonetech solved my problems very fast and good!

    Download the latest version, all problems should be solved.

     

    Greetings!

  13. Hi again,

    the problem is NOT the server, it IS the DATABASE!

    The server lists the files correct with subfolder.

    The database doesn`t show the included subfolders!

    Your fix shows the folder for the server and in the unused list...

    But the database shows them all as being in the main image folder!

    Here`s the code the error could be in:

    // put the images in an array
    while ($image_info = mysql_fetch_array($image_info_query))
    {
     if ($numb_tables)
     {
    for ($i = 0; $i < $numb_tables; ++$i)
    {
      if( strpos($image_info[$table_array[$i]], 'jpg') || strpos($image_info[$table_array[$i]], 'gif') || strpos($image_info[$table_array[$i]], 'png') )
      {
      if($image_info[$table_array[$i]]){$full_image_list[] = strip_tags($image_info[$table_array[$i]]);}//put all db images into 1 array
      }
    }
     }
    }
    
     $full_image_list = array_unique($full_image_list);
     sort($full_image_list);// list from db
    
     $count_db_list = count($full_image_list);//number of images installed in the database
    
    // end reading the database for installed images

    Greetings!

  14. Hi,

    I get the following error on the confirmation page if I try to enter the correct code:

    1054 - Unknown column 'geo_zone_id' in 'from clause'
    
    SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id=88 or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id=81 or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="XXX"
    
    [TEP STOP]

    What does it mean?

    Thank you!

    Hi,

    fixed in the latest update!

    Greets!

  15. However you named the upload images in the database that will need to be put into the $table_array

     

    Might look like:

    $table_array = array("products_image_upload","products_image","products_image_medium","products_image_large");

     

    You need to do this part, I can only guess what you named the upload images.

     

    Note: If you don't have the "upload" images listed in the database then you can't have them listed to be removed.

     

    On the errors, I can't help you there.

    Hi,

    any idea where I can find tha correct name for the upload folder in the database?

    Thanks for your support!

  16. Post ALL paths to all image folders that exist on the server:

     

    It might look like: shop/images/medium; shop/images/large; etc...

     

    Then post the variables:

    $images_dir =

    $more_folders =

     

    We'll see if we can help.

     

    Regards,

    Jeff

    Hi Jeff,

     

    thanks for helping me out!

    Here are my folders IN the images folder:

    banners, default, dvd, icons, infobox, large, mail, medium, upload.

    Now I`d like to compare the 4 main folders (images, images/medium, images/large, images/upload).

    That would be enough for me! So I choose the main dir as images!

    And the subfolder at $more_folders = array!

    Here`s my code:

    // look in this images folder - do not add more folders here - just the main one
    $images_dir = 'images';
    
    // if you add more sub folders of $images_dir then edit as EX: $more_folders = array("thumb","full");
    // you must make sure the corresponding tables are in $table_array
    $more_folders = array("medium","large","upload");
    
    // to add more tables use ex: $table_array = array("products_image","products_image_med");
    // see below for possible image names
    $table_array = array("products_image","products_image_medium","products_image_large");

    No problem so far!

    But how is the array for the upload folder called???

    What do I write in $table_array = array for it?

    I can`t find the upload folder in mysql...

    I think that`s the problem!?!

    I`ve tried products_image_upload, but it will cause an error:

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at D:\vhosts\Mysite.COM\httpdocs\catalog\admin\remove_unused_images.php:2) in D:\vhosts\Mysite.COM\httpdocs\catalog\admin\includes\functions\sessions.php on line 102

    Here's line 102 of my sessions.php

    return session_start();

    Thank you for your time and support!

    I`m waiting for your solution!

×
×
  • Create New...