Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

marcel emmen

Archived
  • Posts

    62
  • Joined

  • Last visited

Posts posted by marcel emmen

  1. Hi there,

     

    I still have problems with credit class Gift voucher in Load 4 I thing is version 4.1 which is in this load. I will tell you want go's wrong.

     

    In admin i zend a giftvoucher to a test customer. The test customer receives a e-mail and redeem his giftvoucher lets say 25,- he then go's shopping and orders a article of 200,- checkout and select the gift voucher account box to redeem his amounth of 25,- the rest has been pay by a other payment. When the test customer comes on the checkout success page he is reading the following message:

    You have funds in your Gift Voucher Account. If you want

    you can send those funds by email to someone

     

    He can then send the amount he just use of 25,- to somebody else?

     

    Also after the order has been complete the gift voucher box still shows:

    You still have

    ? 25.00

    left to spend in your Gift Voucher Account

    Send to a Friend

     

    Who know's what's wrong and can help me to solve this?

    Thanks Marcel

  2. Hi there,

     

    I just download Easy Populate and have test it! Great contribution. However still have some questions,

     

    Will there be a update in the near future so that Easy Populate can work with product and product options with price update?

     

    I can now import all my records easy in the database but then i still have to manual edit every product to added the option value. As i'm in fashion and shoes this is need for every article so you can immagine that a import possiblilty for the options in easy populate will be great?

     

    Marcel

  3. Ok, i have change the zone shipping so that iso calculating the weight it uses the order total.

    It seems to be working fine. In the checkout the shippingcost is calculate correctly. However when I choose this shipping and click proceed the checkout isn't going further... it stays at shipping.

     

    anyone a idea what can be wrong?

    Marcel

  4. Dear Linda,

     

    I already have a full sollusion.

    What I basicly do is that I first check if product-atribute is numeric or alfa.

    If the attribute is numeric then the field is been convert to a numeric type

    this is done with the 0+ (its a zero) and if the attribute is alfa then the field type stays original.

     

    if you sort a attribute with numeric value and you do not convert the field type to numeric the sort is going wrong. 1,2,3,4, is going ok but if your attribute contains 1,2,3,4,5,10,11 then the 10,11 are show first in the field.

     

    Ok below is the correct working change you have to made to the product_info.php field

     

    in the product_info.php file change the line:

    $products_options = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by pov.products_options_values_name" );

     

    with:

    // changes made by Marcel Emmen 12-2002 to sort options in the catalog

    //

    if (is_numeric(products_options_values_name))

    {

    $products_options = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by 0+pov.products_options_values_name" );

    }

    else {

    $products_options = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by pov.products_options_values_name" );

    }

    // end of changes

    //----------------------------------------------

  5. Hi there,

     

    I have found a easy solution to sort product options. However this only works with numbers or text not both at the same time. I know also how this can be solved but don't know how to put this in the code; Maybe there are others who now how to solve this; Let me explain more

     

    Ok first solution to sort options with numbers you only have to added:

    . " order by 0+pov.products_options_values_name" );

    at the end of the line which starts with $products_options = tep_db_query("select pov.products_options_values_id, in the product_info.php file

     

    if you which to sort the options for text options then you need to added;

    . " order by pov.products_options_values_name" ); without the 0+ (that's a zero)

     

    most of the time options will be text or numbers so there must be a way to check if the first option value of a option is text or numeric and then depending on the result do a; . " order by 0+pov.products_options_values_name" ); for numeric or a . " order by pov.products_options_values_name" ); for text.

     

    I already have a part of the solution but maybe somebody else can complete it.

     

    It has to be something like this:

    if is_numeric(pov.products_options_values_name) {

    0+pov.products_options_values_name

    } else {

    pov.products_options_values_name

    }

     

    the function is_numeric returns TRUE if the value is numeric and FALSE if the value is text. The only thing i don't know is how to get the first option value of the actual record. Are there others who can help to make this option complete? I think many people like this and are waiting for this solution.

     

    Thanks Marcel

  6. You right it's not difficult to install a contribution. But what if you want to install 4,5 or 6 contributions? if you don't look out, one contribution over rules the other because they use the same files. With a small file it's easy to find the differents but with large files it's getting more complicated.

     

    I use also DBman a perl/cgi database script. This database has lots of contributions cq addon's. All addon's have a detail discription what has to be change in the files. It's more work to make the change but less complicated if you have more addon's because you know where to look.

     

    It was just a idea not a must.

    Marcel

  7. I was wondering why every contributions isn't setup as a install/change document, i.s.o php files. All these contributions are very nice but difficult to install if you want more then one. If change are made to two of the same files you a problem and have check every line of the code so that you know what to change without destroying the other contributions.

     

    Maybe a idea for al of us. This make live less complicated

     

    Marcel

    Albundy

×
×
  • Create New...