Auction Product Type

[davewest]

I am running Zen Cart 1.3.8a with the latest version of Product Type Auction. Auction manager shows my auctions as closed even though the auction close date is still a week away. How do I resolve this issue?

I haven't gone back and tested it fully on 1.3.8a, but it should work. Most of the updates was for php may not work on older versions below 5.... Did you activate the auctions?

Also, when accessing the auction products through auction manager I get the "Category Disabled" message at the top yet this message does not show up when accessing the auction products through admin->catalog->categories/products. How do I fix auction manager to display correctly?

The auction manager only displays info about the product and auction, not the categories...

Recheck that all the files was installed fully.... with out more info... something to look at... not much to go on... I haven't had anything like your describing occur on my installs.

[Rexxo1]

Thanks for the quick response! Yes, I have activated the auctions and they seem to be working (accepting bids...).

When in the Auction Manager you can edit a product. When you click the edit on the product it displays the product in Category "Top" and the "Category is Disabled" message is there. But in reality I created a category called "auctions" where the products reside. I will re-install as you suggested and see it that works.

Steven

[davewest]

When in the Auction Manager you can edit a product. When you click the edit on the product it displays the product in Category "Top" and the "Category is Disabled" message is there. But in reality I created a category called "auctions" where the products reside.

That help... I've spent so much time looking at the other fields that I missed that one... As long as it says 'Product Master Category ID# 336 Auctions', of course the ID number and name should be different, your editing in the right place. The page title where it says TOP and the disable cat are for display only but are wrong due to stepping into the edit form from outside the normal path way Zen was expecting.
as from category pathway


as from Auction Manager


I'll have to see where its getting the title and pathway from and chase it down, but it shouldn't keep you from editing from the manager I do all the time. The top category should be disable for entering products due to subcats, thus the disable warning.

[davewest]

I'll have to see where its getting the title and pathway from and chase it down, but it shouldn't keep you from editing from the manager I do all the time. The top category should be disable for entering products due to subcats, thus the disable warning.

Didn't take long to find it... it was missing the cpath master category ID in the link.. Found I missed adding p.master_categories_id to the sql query at line 174 of admin\auctions_manager.php

$auctions_query_raw = "select p.products_id, p.products_status, p.master_categories_id,

[doggero]

I installed the auction mod a few months ago and had only a few problems. I am very happy with this mod.

My question now though is I sell products at a fixed price but then also auction them, Is there a way to keep the Auction products from showing up in the "New Items" Page?

I have had a few customers get confused by the duplicate listing. I have annotated on the title of the items *AUCTION* which has seemed to help, but I would prefer to just block the auction items from showing in New items.

If this can be done I would be greatful, if someone could tell me how.

Thanks in advance!

[davewest]

I installed the auction mod a few months ago and had only a few problems. I am very happy with this mod.

My question now though is I sell products at a fixed price but then also auction them, Is there a way to keep the Auction products from showing up in the "New Items" Page?

I have had a few customers get confused by the duplicate listing. I have annotated on the title of the items *AUCTION* which has seemed to help, but I would prefer to just block the auction items from showing in New items.

If this can be done I would be greatful, if someone could tell me how.

Thanks in advance!

The default way Zen handles showing new products is by the date they was placed on your site. The only way I know of to deal with it is to remove auction products from the query. Just did it and it works by editing includes\modules\pages\products_new\header_php.php
We need to know the type_id from the product type table for product_auction which is the type_handler name. Then we need to add a line to the query to not include any auction products. The code below is from 1.8.9h with the lines in red I added...

<?php
/**
 * products_new header_php.php
 *
 * @package page
 * @copyright Copyright 2003-2007 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: header_php.php 6912 2007-09-02 02:23:45Z drbyte $
 */

  require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
  $breadcrumb->add(NAVBAR_TITLE);
// display order dropdown
  $disp_order_default = PRODUCT_NEW_LIST_SORT_DEFAULT;
  require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
  $products_new_array = array();
// display limits
//  $display_limit = zen_get_products_new_timelimit();
  $display_limit = zen_get_new_date_range();

 // get auction type ID
$sql = "SELECT * FROM " . TABLE_PRODUCT_TYPES . " WHERE type_handler = 'product_auction'";
  $result = $db->execute($sql);
  $typeID = $result->fields['type_id'];
// end auction type ID

  $products_new_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price,
                                    p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model,
                                    p.products_quantity, p.products_weight, p.product_is_call,
                                    p.product_is_always_free_shipping, p.products_qty_box_status,
                                    p.master_categories_id
                             FROM " . TABLE_PRODUCTS . " p
                             LEFT JOIN " . TABLE_MANUFACTURERS . " m
                             ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             WHERE p.products_status = 1
                             AND p.products_id = pd.products_id
                             AND p.products_type <> ' $typeID '
                             AND pd.language_id = :languageID " . $display_limit . $order_by;

  $products_new_query_raw = $db->bindVars($products_new_query_raw, ':languageID', $_SESSION['languages_id'], 'integer');
  $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW);

//check to see if we are in normal mode ... not showcase, not maintenance, etc
  $show_submit = zen_run_normal();

// check whether to use multiple-add-to-cart, and whether top or bottom buttons are displayed
  if (PRODUCT_NEW_LISTING_MULTIPLE_ADD_TO_CART > 0 and $show_submit == true and $products_new_split->number_of_rows > 0) {

    // check how many rows
    $check_products_all = $db->Execute($products_new_split->sql_query);
    $how_many = 0;
    while (!$check_products_all->EOF) {
      if (zen_has_product_attributes($check_products_all->fields['products_id'])) {
      } else {
// needs a better check v1.3.1
        if ($check_products_all->fields['products_qty_box_status'] != 0) {
          if (zen_get_products_allow_add_to_cart($check_products_all->fields['products_id']) !='N') {
            if ($check_products_all->fields['product_is_call'] == 0) {
              if ((SHOW_PRODUCTS_SOLD_OUT_IMAGE == 1 and $check_products_all->fields['products_quantity'] > 0) or SHOW_PRODUCTS_SOLD_OUT_IMAGE == 0) {
                if ($check_products_all->fields['products_type'] != 3) {
                  if (zen_has_product_attributes($check_products_all->fields['products_id']) < 1) {
                    $how_many++;
                  }
                }
              }
            }
          }
        }
      }
      
      $check_products_all->MoveNext();
    }

    if ( (($how_many > 0 and $show_submit == true and $products_new_split->number_of_rows > 0) and (PRODUCT_NEW_LISTING_MULTIPLE_ADD_TO_CART == 1 or  PRODUCT_NEW_LISTING_MULTIPLE_ADD_TO_CART == 3)) ) {
      $show_top_submit_button = true;
    } else {
      $show_top_submit_button = false;
    }
    if ( (($how_many > 0 and $show_submit == true and $products_new_split->number_of_rows > 0) and (PRODUCT_NEW_LISTING_MULTIPLE_ADD_TO_CART >= 2)) ) {
      $show_bottom_submit_button = true;
    } else {
      $show_bottom_submit_button = false;
    }
  }
?>

Kind of a quick way of doing it. This only affects the 'New Product' page. Hopefully that helps with your question.

[swamyg1]

Is there a way to set a maximum bid amount? I thought I would have a "Free Auction" for fun but it's getting ridiculous... I have people bidding $100 billion and stuff, worst idea ever! Can you think of any way to help me? My auction is still going on!

[davewest]

Is there a way to set a maximum bid amount? I thought I would have a "Free Auction" for fun but it's getting ridiculous... I have people bidding $100 billion and stuff, worst idea ever! Can you think of any way to help me? My auction is still going on!

That's a new one... never thought about a max amount, but with the two key words free-fun would get it going.... this is basically the opposite of the to low bid, but without an easy admin setting.

in includes\modules\pages\product_auction_info\header_php.php add the lines in red in between the black code sections about line 125.

if ($auction_bid > 0 ) {
  if ($auction_bid < ($auction_bid_minimum_increase + $auction_current_bid)) {
    $error = true;
    $messageStack->add('place_bid', ENTRY_BID_TOO_LOW, 'error');
  }
 
if ($auction_bid >= ($auction_bid_minimum_increase + $auction_current_bid) + 200) {
    $error = true;
    $messageStack->add('place_bid', 'To High - Try Again!', 'error');
  }
  
  if ($error == false) {

This works by checking if the bid is 200 over the current bid plus the minimum increase.. change the 200 to something higher or lower for what you want....

The edited page if you wish to just replace it... header_php.zip

I'll have to add this to the next update...

[swamyg1]

That's a new one... never thought about a max amount, but with the two key words free-fun would get it going.... this is basically the opposite of the to low bid, but without an easy admin setting.

in includes\modules\pages\product_auction_info\header_php.php add the lines in red in between the black code sections about line 125.

if ($auction_bid > 0 ) {
  if ($auction_bid < ($auction_bid_minimum_increase + $auction_current_bid)) {
    $error = true;
    $messageStack->add('place_bid', ENTRY_BID_TOO_LOW, 'error');
  }
 
if ($auction_bid >= ($auction_bid_minimum_increase + $auction_current_bid) + 200) {
    $error = true;
    $messageStack->add('place_bid', 'To High - Try Again!', 'error');
  }
  
  if ($error == false) {

This works by checking if the bid is 200 over the current bid plus the minimum increase.. change the 200 to something higher or lower for what you want....

The edited page if you wish to just replace it... header_php.zip

I'll have to add this to the next update...

You are the man, you totally saved my fun marketing event from being a total flop. Thanks so much. Love this mod BTW.

Thanks again.

[Joseph_Greely]

I am preparing to do a fresh install of "auction_product_type_1-2a" using Zen-Cart 1.3.9h.

In reviewing the "File Structure Information" and matching it with the files in the download, I noticed two items that I was unable to find any reference to, since the release date of 12/20/2010:
1. Missing in the download file: "includes/modules/pages/product_auction_info/main_template_varsattributes.php".
2. File named "includes/templates/YOUR_TEMPLATE/images/hdg.gif" in the "File Structure Information", is named "hbg.gif" in the download.

Not being critical, I just need to know, before moving forward, if either of these two issues, will create a problem with the downloaded file, or if it was just accidentally missed in being updated in the "File Structure Information" area of the installation instructions prior to release?

Thanks in advance!