Auction Product Type

it cant find that table, either there is no table or your table prefix is different?

agrace90:

make that http://gracefulhosting.com/samplecart/index.php?main_page=product_auction_info&cPath=1&products_id=3

ANDYII is correct. It appears that the SQL install was wither not done or not done properly. The easiest way to install the DB side of the mods is from the ZEN ADMIN screens (SQL PATCH).
Cut and Paste the SQL install into the box and hit RUN.

bramnick:

ANDYII is correct. It appears that the SQL install was wither not done or not done properly. The easiest way to install the DB side of the mods is from the ZEN ADMIN screens (SQL PATCH).
Cut and Paste the SQL install into the box and hit RUN.

That is exactly what I did. I even went in and checked to see if it created that table (it did not) and rewrote the php file so that it would. Help.............

Here is the text I get after doing an sql patch. Am I supposed to be seeing all of this???

1062 Duplicate entry 'SHOW_PRODUCT_AUCTION_INFO_MODEL' for key 2
in:
[INSERT INTO zen_product_type_layout VALUES ('','Show Model Number', 'SHOW_PRODUCT_AUCTION_INFO_MODEL', '1', 'Display Model Number on Product Info 0= off 1= on', last_insert_id(), '1', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Weight', 'SHOW_PRODUCT_AUCTION_INFO_WEIGHT', '1', 'Display Weight on Product Info 0= off 1= on', last_insert_id(), '2', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Attribute Weight', 'SHOW_PRODUCT_AUCTION_INFO_WEIGHT_ATTRIBUTES', '1', 'Display Attribute Weight on Product Info 0= off 1= on', last_insert_id(), '3', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Manufacturer', 'SHOW_PRODUCT_AUCTION_INFO_MANUFACTURER', '1', 'Display Manufacturer Name on Product Info 0= off 1= on', last_insert_id(), '4', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Quantity in Shopping Cart', 'SHOW_PRODUCT_AUCTION_INFO_IN_CART_QTY', '1', 'Display Quantity in Current Shopping Cart on Product Info 0= off 1= on', last_insert_id(), '5', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Quantity in Stock', 'SHOW_PRODUCT_AUCTION_INFO_QUANTITY', '1', 'Display Quantity in Stock on Product Info 0= off 1= on', last_insert_id(), '6', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Reviews Count', 'SHOW_PRODUCT_AUCTION_INFO_REVIEWS_COUNT', '1', 'Display Product Reviews Count on Product Info 0= off 1= on', last_insert_id(), '7', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Reviews Button', 'SHOW_PRODUCT_AUCTION_INFO_REVIEWS', '1', 'Display Product Reviews Button on Product Info 0= off 1= on', last_insert_id(), '8', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Date Available', 'SHOW_PRODUCT_AUCTION_INFO_DATE_AVAILABLE', '1', 'Display Date Available on Product Info 0= off 1= on', last_insert_id(), '9', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Date Added', 'SHOW_PRODUCT_AUCTION_INFO_DATE_ADDED', '1', 'Display Date Added on Product Info 0= off 1= on', last_insert_id(), '10', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product URL', 'SHOW_PRODUCT_AUCTION_INFO_URL', '1', 'Display URL on Product Info 0= off 1= on', last_insert_id(), '11', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Starting At text on Price', 'SHOW_PRODUCT_AUCTION_INFO_STARTING_AT', '1', 'Display Starting At text on products with attributes Product Info 0= off 1= on', last_insert_id(), '12', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Tell a Friend button', 'SHOW_PRODUCT_AUCTION_INFO_TELL_A_FRIEND', '1', 'Display the Tell a Friend button on Product Info

Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button
0= off 1= on', last_insert_id(), '15', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Product Free Shipping Image Status - Catalog', 'SHOW_PRODUCT_AUCTION_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH', '0', 'Show the Free Shipping image/text in the catalog?', last_insert_id(), '16', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')), '), ('','Product Price Tax Class Default - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_TAX_CLASS_ID', '0', 'What should the Product Price Tax Class Default ID be when adding new products?', last_insert_id(), '100', now(), now(), NULL, ''), ('','Product Virtual Default Status - Skip Shipping Address - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_PRODUCTS_VIRTUAL', '0', 'Default Virtual Product status to be ON when adding new products?', last_insert_id(), '101', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Product Free Shipping Default Status - Normal Shipping Rules - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_PRODUCTS_IS_ALWAYS_FREE_SHIPPING', '0', 'What should the Default Free Shipping status be when adding new products?', last_insert_id(), '102', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Yes!!! I got it to work. I just started the install over from the beginnning (for the fourth time!!)

How do I turn on the buy it now function??

agrace90:

How do I turn on the buy it now function??

When you build (or modify) an auction product, you need to specify a "Buy it now" price.

if it has a BIN price and the current bid does not already exceed it, a button should show up.

Arnold

I doesn't though..

bramnick,
can you recall what was changed to stop the bidders name from showing?
I was thinking about the possibility of using the forum nick, and if the data could be pulled from that table instead...

bramnick:

I just uploaded 0.97 It contains a published fix for mooncavecrystals request for 0.01 starting bid (down from 1.00)

Also prints previous bidder's ID instead of first and last names.

No other fixes or enhancements in here.

No DB changes required

ZC team is looking at the upload and once blessed they will place in download area.

I would have to diff the source code for those 2 versions and see where it is. The change was small, it uses a different DB field is all.

here is what I am up against,
if the bidder doesnt follow through with the auction and pay for it, I dont seem to have any records to point me to who it is, and I assumed that the bidder ID was the customer ID but it seems not so, I even bid on an item took the bidder ID (me) and compared it to customer ID's, and it wasn't me :huh:
I have been searching files and did find one I thought would do the trick, (tpl_product_auction_info_display.php)
it had been modified from the original, I replaced the absent code but still showing just the Bidder ID, maybe there is more than 1 file that would need to be changed, anyway we have a forum bridged with zen and was looking into using the forum nick as the identifier
either that or the owner should get an email with the winning bidders info, I hadn't received any.
I did get out bid notices from when I had bid...
original code

<td class="main"><?php echo AUCTION_WINNER . ' ' . $last_bid->fields['customers_firstname']; ?> <?php echo $last_bid->fields['customers_lastname']; ?></td> </tr>

changed code

<td class="main"><?php echo AUCTION_WINNER . '  ' . TEXT_AUCTION_BIDDER_ID . ': ' . $last_bid->fields['customers_id']; ?></td> </tr>

Hi all,

I have just downloaded this and installed it. Everything seems to be working great and will do exactly what im after except that ive come across 1 small problem.

I set a product up with a £50 reserve price, i went in and placed a bid as a customer would for £20, bid accepted. However it still says that the reserve has not been met, but i am not able to enter another bid? Why is this?

Any ideas?

Many thanks

Paul

Fixed!

I commented out this line from the tpl_product_auction_info_display.php (line 167)

This now means that the bid entry box will always be visible allowing current customer to raise their bids if necessary without having wait untl they are outbid.

Looks like a great mod! I think it needs some additional extras but nothing i cant handle.

Thanks for this mod! let the fun begin!!!

Paul

Welcome Paul to our little world of auction, this mod was all but dead until bramnick revived it and gave it new life.
Nice little hack will ad it to my inventory :smile:
Yes it still needs things but we wont know till we experience troubles or inconveniences , like admin need more control, but it will come the more we get involved...

Wilkesy:

Fixed!

I commented out this line from the tpl_product_auction_info_display.php (line 167)

<?php //if ($customer_high_bidder != $_SESSION['customer_id']) { ?>

This now means that the bid entry box will always be visible allowing current customer to raise their bids if necessary without having wait untl they are outbid.

Looks like a great mod! I think it needs some additional extras but nothing i cant handle.

Thanks for this mod! let the fun begin!!!

Paul

Thank you AndyII. I only came across this mod while i was having a look around the download area, but now ive tried t i must say that i am impressed. Thanks for everyone who has contributed to this!

This afternoon i have been working on a small modification to the 'My Account' area so that people can see the items they have bidded on, however i have now run into a small trouble during testing. I have setup a product and 2 accounts, bidded against each other and received the outbid emails. However the auction has just finished and although i wont the auction, both my accounts received the same email saying thati was not successful in the bidding. On the website it shows the 'Congratulations......' lins and 'Pay now' button.

Any idea why i would have received the wrong email to the winning account?

Many thanks

Paul

Hi guys,

Just thought id share my thoughts about this mod too. I think the basics are there however now that ive had a good play around ive come up with a list of a few things that would be great to have.

Setup changes:

In configuration > stock set 'Show Shopping Cart - Delete Checkboxes or Delete Button' = 2 This removes the 'delete buton so customers cant remove the item they have won from the car

Modifications:

Ability to stop customers from clicking the 'Pay now' button more than once. This should be pretty easy to do as there is a status that appear via zencart normally saying that the cart already contains the item.

Display in 'My Account' for winning items.

Notification emails when auction is gtting close to the end. Can this be part of the cron job?

I got adventurous and installed on a live site :blink:
this mod is very nice but how do we find and solve the troubles if it is not in use in real life?
that email problem may be a new bug
some of us rely on members like you and bramnick to solve these things, Like I said, if bramnick hadn't ventured in when he did, I am not sure where this mod would be now, my guess would be dead in the water :smile:

Hi AndyII

Ill do my best to get some of these changes done, but im still having trouble with the emails. Just had another auction end and no email at all?

Cheers

Paul

if anyone want to play on a live site, I can setup some real auctions, I WILL return any funds if you win the bid, these are small auctions and I use penny bids as our site doesn't have large value items anyway
I am running Zen 1.3.7

AndyII:

if anyone want to play on a live site, I can setup some real auctions, I WILL return any funds if you win the bid, these are small auctions and I use penny bids as our site doesn't have large value items anyway
I am running Zen 1.3.7

I'll test!!! I'm just about done with setting mine up and turning it on.

I've noticed that the customer ID is in the table alone with the bidder ID.

I need to check the email some more before I go live with it. The text email looks good, but the html one is missing the link back to the product. Also not getting the admin copy. I can track the email with the email archive manager, it be nice to have something in admin to track the auction better.

Running Zen 1.3.8a