Auction Product Type

Rexxo1:

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?
Rexxo1:

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.

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

Rexxo1:

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
Attachment #8630

as from Auction Manager
Attachment #8631

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,

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!

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!
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; } } ?>

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!

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!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... Attachment #8740

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

davewest:

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) {

> 
> The edited page if you wish to just replace it... Attachment #8740
> 
> 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.

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!

:oops: Along with my previous post regarding installing "auction_product_type_1-2a with zen-cart 1.3.9h", I am planning on also including add-on "simple_in_stock_display_0-5", so that my fixed priced items only show "In Stock", and not the quantity amount of what's in stock.

The "simple_in_stock_display_0-5" file "includes/modules/Your_Template/product_listing.php":

    $zc_col_count_description++;
    break;// Begin Edit(simple_in_stock_display_0-5)
    case 'PRODUCT_LIST_QUANTITY':
        $lc_align = 'right';
        if (zen_get_products_stock($listing->fields['products_id'])>0) {
		$lc_text = 'In Stock';  //  any at all (part of simple_in_stock_add_on)
	}
        else {
		$lc_text = 'Out of Stock';  // none at all (part of simple_in_stock_add_on)
	}
	break;// End Edit
    case 'PRODUCT_LIST_WEIGHT':
    $lc_text = TABLE_HEADING_WEIGHT;

And in the same location "auction_product_type_1-2a" file "includes/modules/Your_Template/product_listing.php":
:

    $zc_col_count_description++;
    break;
    case 'PRODUCT_LIST_QUANTITY':
    $lc_text = TABLE_HEADING_QUANTITY;
    $lc_align = 'right';
    $zc_col_count_description++;
    break;
    case 'PRODUCT_LIST_WEIGHT':

I'm still learning how to write code, so any help, if what I am about to ask is possible, would be greatly appreciated.

If it's possible to just show "In Stock" for the fixed price items I will be selling, and show the actual quantity of the items I will be auctioning, with an "if" statement, would someone be able to help me? How would I write it, and where exactly would I put it?

Thanks in advance! I hope it's possible with an "if" or some other coding. :smile:

Joseph_Greely:

1. Missing in the download file: "includes/modules/pages/product_auction_info/main_template_varsattributes.php".
   That file was removed some time back to clean it up for php5.3... I did a quick update prier to 1.2a when it was removed, wasn't part of this update is why it was left off.

2. File named "includes/templates/YOUR_TEMPLATE/images/hdg.gif" in the "File Structure Information", is named "hbg.gif" in the download.yap... a type-o hbg.gif is the file or anything you like it to be... was a fix to prevent double hitting the bid button.

"simple_in_stock_display_0-5", so that my fixed priced items only show "In Stock", and not the quantity amount of what's in stock.Not sure on that one... Zen does a nice job with stock. Zero quantity 'shows out of stock', one or more shows the add button or more info depending on how you have your settings.

If it's possible to just show "In Stock" for the fixed price items I will be selling, and show the actual quantity of the items I will be auctioning, with an "if" statement, would someone be able to help me? How would I write it, and where exactly would I put it?anything possible... you would do a quick test of the database to get the product type_id for auctions, then you could do a if statement to check for the auction type_id. The code is some posts back... just use the $typeID in a if statement...

Thanks for the quick reply dave, I do appreciate it. I thought it would be something simple like that, or there would have been a sooner post after the release. I just wanted to make sure.

Thanks much!:clap:

I just had a major problem. My auction ends in 7AM but an email was sent to all of my bidders telling them the auction was over. A winning email was also sent to a bidder telling them they won!

What would cause this mod to email everybody 5 hours early?

swamyg1:

I just had a major problem. My auction ends in 7AM but an email was sent to all of my bidders telling them the auction was over. A winning email was also sent to a bidder telling them they won!

What would cause this mod to email everybody 5 hours early?
still some things to work on.... time is one.... the auction is based on the server time. Like me I'm -8 hours behind UTM, my server is -6 hours behind UTM which will close my auctions a day early compared to where I'm at.... does the same for my shop order records. Something I'm still working on is a date and time class to base the auctions on.... oust side of server time, haven't had any other problems.

I have one cart using this mod, running 1.3.8A, with all the manual updates.

I had version 99A installed, and it worked fine for over a year, with a few minor bugs such as when using browser fwd and back buttons, bids would sometimes increase if a bid had been placed.

But it worked.

Now, I checked out a long-expired auction page, and the page kept reloading, without actually showing the product info or images, it would just reload over and over again. That auction was ended.

I noticed the new version, and so I chose the highest one for 1.3.8A, Version 1-0a of the Auctions Module.

I removed the old tables from the DB and executed the SQL statements in ZC. I set up an auction...

But even with this new version, the same thing is happening.
The page keeps reloading incessantly. When it (rarely) stops,
it shows the bottom buttons, as well as the footer, but the product image and description are completely missing.

BUT usually what happens is the left column loads, the header images store logo loads, but starting with the breadcrumbs, and ending
with the login to place bid buttons, that whole section keeps refreshing, without ONCE displaying the product description or image. (The product title does display) as does this :

Auction ends on 12-12-2011 00:00:00
314 days, 13 hours, 49 minutes, 51 seconds

• 0 Bids
  Starting Bid! $5.00

I HAD the cron function on, with the older install. I disabled it with this one, and the same thing is still happening.

As it HAD been working, I'm guessing some other module may be responsible. I did add the SEO URLS in the time between last checking an auction page, and this new issue.

I tried setting 'Enable SEO URLs' to false, to see if that would
help but the auction page still keeps refreshing....

Any help would be greatly appreciated!

Hello everyone (my first post :smile:),

I've done a couple of searches, but can't seem to find the answer to my problem. I'm probably missing something obvious, so I'll appreciate a nudge in the right direction.

I am running ZC v1.39h (with Comstock template), and have just installed Product Type Auction v1.2a. The whole process went surprisingly painlessly (well, I wasn't quite sure what to expect!).

Anyway, my problem now is that my log files have this single entry:

[01-Feb-2011 03:23:39] PHP Fatal error: Cannot redeclare class productAuction in /includes/classes/class.productauction.php on line 17

New files clogging up my cache directory, as the error occurs every time the cron job runs, which is every 5 minutes.

Everything seems to work as expected, and I have a test auction going on, no obvious problems. But the error condition persists.

I have used the Developer Tools utility in admin to search all the files, and the only occurrence of "productAuction" outside of the templates is the two files attached. There are no duplicates that I can find.

Any help sincerely appreciated!

infosolprovider:

[01-Feb-2011 03:23:39] PHP Fatal error: Cannot redeclare class productAuction in /includes/classes/class.productauction.php on line 17

New files clogging up my cache directory, as the error occurs every time the cron job runs, which is every 5 minutes.
The auction is checked for time by default with each page load or by setting a cron job... I just turned it on and didn't get the error... if you had an older version installed it used a edit to application_top.php, if that's still there then you would get a redeclare error.

In trying to stay up on the changing Zen Cart, I've been getting rid of the core edits such as application_top. The config.auction.php file takes the place of editing application_top. Try turning off the cron job or checking application_top..

davewest:

The auction is checked for time by default with each page load or by setting a cron job... I just turned it on and didn't get the error... if you had an older version installed it used a edit to application_top.php, if that's still there then you would get a redeclare error.

In trying to stay up on the changing Zen Cart, I've been getting rid of the core edits such as application_top. The config.auction.php file takes the place of editing application_top. Try turning off the cron job or checking application_top..
Hi @davewest,

Thanks very much for looking into this. It's definitely a strange one, as my install of APT is a clean, brand new one of v1.2a. I checked application_top.php just to be sure, and it's fine, nothing in there as far as I can see.

Turning off the cron job solves the problem, but I'm worried that there may be a performance hit on the shop overall, as a result? (That's what I understand from the cron setting in Auction Manager).

I suspect there's something obvious that I'm missing....

HI
Dear
i use 1.39h zencart
I meet a problem
i can only recieve the outbid email

clients can't recieve the winner or other emails

But when some person register my site
they can receive the welcome email

if it is my server email's problem
Why can i still receive the outbid and welcome email??

can anyone help?

i really need some help,please!