Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

auctionTastic


FWR Media

Recommended Posts

Local code?

 

Other contributions were added where the auction is also. Is that what you mean?

 

What I mean is that it views properly on a fresh install so the problem must be with the code on your site.

Link to comment
Share on other sites

Hi Robert,

 

The RC1 release works really well. I have a couple things I noticed though.

 

1) Even though I put an increment amount of 1.00 in the auction listing setup, the increment amount seems to default to .54 cents. ???

 

2) The auction date and time do not correspond to my site date and time. ( Auctions are ending 6 hrs before the scheduled time ) ??

 

 

Any ideas about why these to things might happen ?

 

Thanks

 

Chris

Link to comment
Share on other sites

Hi Robert,

 

The RC1 release works really well. I have a couple things I noticed though.

 

1) Even though I put an increment amount of 1.00 in the auction listing setup, the increment amount seems to default to .54 cents. ???

 

2) The auction date and time do not correspond to my site date and time. ( Auctions are ending 6 hrs before the scheduled time ) ??

 

 

Any ideas about why these to things might happen ?

 

Thanks

 

Chris

 

The time thing.

 

Look in two files ..

 

1) catalog/includes/modules/auctions/classes/oscAuctions.php

 

and change var $timeZone = 'Europe/London';

 

2) admin/auctions.php change ..

$timeZone = 'Europe/London';

 

Never heard of the increment thing, I'll have a think on it.

Link to comment
Share on other sites

Thanks Robert, I will look at the time zone location. Is there a currency code hard coded in the contribution or does it call on the default currency set in the admin ?

 

I was just thinking perhaps it is doing a currency exchange.

 

 

Chris

Link to comment
Share on other sites

Thanks Robert, I will look at the time zone location. Is there a currency code hard coded in the contribution or does it call on the default currency set in the admin ?

 

I was just thinking perhaps it is doing a currency exchange.

 

 

Chris

 

Currency is as set in admin, certainly not hardcoded.

Link to comment
Share on other sites

Hi Robert,

 

I originally thought the bid increment was set at .54 cents. However, I have been testing the contribution and found that the increment rate is not set at all. It varies depending on item. For example I have set it to 1.00 increment, and a .99 cent starting price. It tells me the minimum bid amount is 1.99 but when I accept the terms and conditions and click "Place Bid" it shows the current price as 1.76. Very confusing.

 

This is on a live site, if you wish to look at it you can log into www<dot>thehotfish<dot>com and create an account to see what I am talking about. Any suggestions would be greatly appreciated.

 

 

Chris

Link to comment
Share on other sites

Hi Robert,

This is on a live site, if you wish to look at it you can log into www<dot>thehotfish<dot>com and create an account to see what I am talking about. Any suggestions would be greatly appreciated.

Chris

I'm curious, I just went to your website. I installed this contribution as well but a person does not have to login to see the prices or the bidders. Is this an added contribution ?

Link to comment
Share on other sites

Hi Robert,

 

Another question. Has Auctiontastic ever been tested with any of the discount coupon code contributions. ??? The site I mentioned above has a DCC contribution installed and it disables the codes. Which is a good thing for auction items, but not for the rest of the store. It may also have something to do with the increment amount maybe. I am still testing.

 

 

 

Chris

Link to comment
Share on other sites

  • 4 weeks later...
auctionTastic

 

Create multiple product auctions in osCommerce

 

Originally based on another auction contribution (credits.txt included) this is a total rewrite due to the original having unworkable code. At 27 odd files this is quite a large contribution although changes to core files has been kept to very very little.

 

Full instructions are included:

 

Package includes: -

  • Auto Installer
  • Upload folder (contains all files new to oscommerce)
  • Modified files folder (files where we are modifying oscommerce code)
  • Documentation folder (install instructions including manual file changes - new code syntax highlighted)

 

Features:-

 

  • Multiple auction products
  • Products with attributes can be auctioned
  • Products can be bought as normal even if auctioned
  • Standard product price shown above auction price (including addition of attributes value)
  • product info page refresh options in admin
  • My Auction view in My Account
  • Inform current highest bidders of new bids
  • Inform winning bidders at end of auction
  • Product added to cart of winning bidder at end of auction (Can't be removed by them)
  • Valid HTML (I hope)
  • Compatible with PHP4/5 MySQL4/5
  • Error free (error_reporting(E_ALL))
  • Compatible with .. RC2a (lower probably will work but untested)

 

Feedback and bug reports appreciated as always.

 

The files are http://addons.oscommerce.com/info/6431

 

The contribution is set so that no others can add packages this is to maintain some quality. This does not stop users from making suggestions here that could be integrated into a later release.

 

Finally I wanted to mention that this was not built by design it started off as a customer asking me to install another auctions contrib, the further I went into it the clearer it became that the previous contribution just couldn't work with the code in place, before I knew it I wasn't just changing code I was rewriting it . . the code would have been a lot better if planned from the start but it seems relatively solid.

 

 

Hi,

I would like to have a special kind of auction in which each one can make a bid the nearest possible to a maximum price (defined for each prduct) but which can cancel the bid of someone else or be canceled if someone make the same bid. At the end of the auction (a time should be defined for the auction), if the minimum quantity of bids was reach, the nearest bid which was not canceled takes the product. Making a bid has a cost even if it was canceled.

Is it possible to add this mode in auctiontastic ?

Thanks a lot.

Link to comment
Share on other sites

Hi!

Thank you for this great contribution!

I just want to know if it's possible to have all the auctions on the front/main page. So the website opens with the Auctions category?

 

Thanks in advance!

ps: I have translated auctions_general.php into Dutch if you're interested. I'm still working on auction_terms.php

Link to comment
Share on other sites

  • 2 weeks later...
Is it any chance you will rewrite this auction scripts for osCommerce Online Merchant v3.0 Alpha 5?

 

None whatsoever .. v3.0 is years from being ready to use as a live cart.

Link to comment
Share on other sites

Hi FWR,

 

Its been long time to discuss on this.

 

Today i notice a strange thing i thought to consult with you.

 

While auction we have validation function validate(form)

 

I am worried because on some particular situation my condition code not worked / or disabled or something.....

 

do you have any visibility of such situations.......

Link to comment
Share on other sites

Hi FWR,

 

Its been long time to discuss on this.

 

Today i notice a strange thing i thought to consult with you.

 

While auction we have validation function validate(form)

 

I am worried because on some particular situation my condition code not worked / or disabled or something.....

 

do you have any visibility of such situations.......

 

 

// Check to see if bid_price has any data

if(document.auction_bid.bid_price.value==''){

alert('<?php echo AUCTIONS_JS_BIDS_EMPTY_INPUT; ?>');

return false;

}

 

It seems 'document.auction_bid.bid_price.value' not been checked...........is this due to some browser issue.......plz suggest.....

Link to comment
Share on other sites

Hello Guys!

 

I managed to install this contribution in a 2002 osc! GREAT WORK!

 

I think that I have found a Possible bug, I had no time to go through this entire topic in this forum.

If this is a known issue, please ignore.

 

in file

/includes/classes/shopping_cart.php

 

code:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

 

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

should be:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

else

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

 

Thanks

D

Link to comment
Share on other sites

Hello Guys!

 

I managed to install this contribution in a 2002 osc! GREAT WORK!

 

I think that I have found a Possible bug, I had no time to go through this entire topic in this forum.

If this is a known issue, please ignore.

 

in file

/includes/classes/shopping_cart.php

 

code:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

 

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

should be:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

else

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

 

Thanks

D

 

Don't know which version you are looking at but in mine ..

 

Replace with ...

		  $products_weight = $product['products_weight'];
	  // BOF AUCTIONS
	  if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
		$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');
	  }
	  // EOF AUCTIONS

 

The second $this->total += doesn't exist.

Link to comment
Share on other sites

Don't know which version you are looking at but in mine ..

 

Replace with ...

		  $products_weight = $product['products_weight'];
	  // BOF AUCTIONS
	  if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
		$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');
	  }
	  // EOF AUCTIONS

 

The second $this->total += doesn't exist.

 

 

I am looking at the latest version.

several lines bellow your new code

 

I marked the line in underline bold italic red :-)

 

 

function calculate() {

global $currencies;

 

$this->total = 0;

$this->weight = 0;

if (!is_array($this->contents)) return 0;

 

reset($this->contents);

while (list($products_id, ) = each($this->contents)) {

$qty = $this->contents[$products_id]['qty'];

 

// products price

$product_query = tep_db_query("select products_id, products_price, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");

if ($product = tep_db_fetch_array($product_query)) {

$prid = $product['products_id'];

$products_tax = tep_get_tax_rate($product['products_tax_class_id']);

$products_price = $product['products_price'];

$products_weight = $product['products_weight'];

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

// EOF AUCTIONS

 

$specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'");

if (tep_db_num_rows ($specials_query)) {

$specials = tep_db_fetch_array($specials_query);

$products_price = $specials['specials_new_products_price'];

}

 

$this->total += $currencies->calculate_price($products_price, $products_tax, $qty);

$this->weight += ($qty * $products_weight);

}

 

// attributes price

if (isset($this->contents[$products_id]['attributes'])) {

reset($this->contents[$products_id]['attributes']);

while (list($option, $value) = each($this->contents[$products_id]['attributes'])) {

$attribute_price_query = tep_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$prid . "' and options_id = '" . (int)$option . "' and options_values_id = '" . (int)$value . "'");

$attribute_price = tep_db_fetch_array($attribute_price_query);

if ($attribute_price['price_prefix'] == '+') {

$this->total += $currencies->calculate_price($attribute_price['options_values_price'], $products_tax, $qty);

} else {

$this->total -= $currencies->calculate_price($attribute_price['options_values_price'], $products_tax, $qty);

}

}

}

}

}

Link to comment
Share on other sites

Another approach to order completion

this way almost no files are changed on the core OSC code

this is just a sample not a complete code

 

 

1. force all bidding users to enter credit card info before bidding.

2. When the auction is closed create an order

3. delete all non winning customers credit card details

 

 

 

function tep_create_auction_order($auction_id)

{

 

global $currencies, $languages_id;

 

 

// ================================================================================

=

$auction_data_query = tep_db_query("select * from auctions where auctions_id='".(int)$auction_id . "'");

$auction_data_row = tep_db_fetch_array($auction_data_query);

$customer_id = $auction_data_row['auctions_high_cust'];

$auction_closed_time = $auction_data_row['expires_date'];

$auction_produtcs_id = $auction_data_row['products_id'];

$auction_produtcs_price = $auction_data_row['auctions_max'];

$auction_shipp_handle_price = $auction_data_row['auctions_shipp_handle_price'];

 

$customer_data_query = tep_db_query("select * from customers where customers_id='".(int)$customer_id . "'");

$customer_data_row = tep_db_fetch_array($customer_data_query);

$customers_default_address_id = $customer_data_row['customers_default_address_id'];

 

$customer_address_query = tep_db_query("select * from address_book where address_book_id='".$customers_default_address_id."' and customers_id='".(int)$customer_id . "'");

$customer_address_row = tep_db_fetch_array($customer_address_query);

 

$product_data_query = tep_db_query("select products_name from products_description where language_id='".$languages_id."' and products_id='".(int)$auction_produtcs_id . "'");

$product_data_row = tep_db_fetch_array($product_data_query);

$auction_product_name = $product_data_row['products_name'];

 

// ================================================================================

=

$sql_data_array = array('customers_id' => $customer_id,

'customers_name' => $customer_data_row['customers_firstname'] . ' ' . $customer_data_row['customers_lastname'],

'customers_street_address' => $customer_address_row['entry_street_address'],

'customers_city' => $customer_address_row['entry_city'],

'customers_postcode' => $customer_address_row['entry_postcode'],

'customers_state' => $customer_address_row['entry_state'],

'customers_country' => $customer_address_row['entry_country_id'],

'customers_telephone' => $customer_data_row['customers_telephone'],

'customers_email_address' => $customer_data_row['customers_email_address'],

'customers_address_format_id' => 1,

'delivery_name' => $customer_data_row['customers_firstname'] . ' ' . $customer_data_row['customers_lastname'],

'delivery_street_address' => $customer_address_row['entry_street_address'],

'delivery_city' => $customer_address_row['entry_city'],

'delivery_postcode' => $customer_address_row['entry_postcode'],

'delivery_state' => $customer_address_row['entry_state'],

'delivery_country' => $customer_address_row['entry_country_id'],

'ip_address' => "TBD",

'delivery_address_format_id' => 1,

'date_purchased' => $auction_closed_time,

'orders_status' => 2,

'currency' => "ILS",

'currency_value' => '1');

 

tep_db_perform(TABLE_ORDERS, $sql_data_array);

$insert_id = tep_db_insert_id();

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'new_value' => $new_value,

'date_added' => 'now()');

tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'products_id' => $auction_produtcs_id,

'products_tax' => '0',

'products_quantity' => '1',

'products_name' => 'æëéä áîëøæ (î÷"è '.$auction_produtcs_id .") " . $auction_product_name,

'products_price' => $auction_produtcs_price,

'final_price' => $auction_produtcs_price,

'products_stock_attributes' => '');

tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'title' => "Sub total:",

'text' => $currencies->display_price($auction_produtcs_price, 0),

'value' => $auction_produtcs_price,

'class' => "ot_subtotal",

'sort_order' => "1");

tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'title' => "Shipping & Handling:",

'text' => $currencies->display_price($auction_shipp_handle_price, 0),

'value' => $auction_shipp_handle_price,

'class' => "ot_custom",

'sort_order' => "2");

tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

 

// ================================================================================

=

 

$total_amount = $auction_produtcs_price + $auction_shipp_handle_price;

 

$sql_data_array = array('orders_id' => $insert_id,

'title' => "Total:",

'text' => $currencies->display_price($total_amount, 0),

'value' => $total_amount,

'class' => "ot_total",

'sort_order' => "4");

tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

 

// ================================================================================

=

 

// update order attributes

// update auction - order created successfully

 

}

Link to comment
Share on other sites

  • 2 weeks later...
I am looking at the latest version.

several lines bellow your new code

 

I marked the line in underline bold italic red :-)

Hi,

you are right.

 

Find ...

// BOF AUCTIONS
         if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
           $this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');
         }
// EOF AUCTIONS

and replace with

// BOF AUCTIONS
         if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
           $products_price = $this->contents[$products_id]['auction_price'];
           $qty = '1';
         }
// EOF AUCTIONS

It will works ...

Link to comment
Share on other sites

  • 2 weeks later...
auctionTastic

 

Create multiple product auctions in osCommerce

 

Originally based on another auction contribution (credits.txt included) this is a total rewrite due to the original having unworkable code. At 27 odd files this is quite a large contribution although changes to core files has been kept to very very little.

 

Full instructions are included:

 

Package includes: -

  • Auto Installer
  • Upload folder (contains all files new to oscommerce)
  • Modified files folder (files where we are modifying oscommerce code)
  • Documentation folder (install instructions including manual file changes - new code syntax highlighted)

 

Features:-

 

  • Multiple auction products
  • Products with attributes can be auctioned
  • Products can be bought as normal even if auctioned
  • Standard product price shown above auction price (including addition of attributes value)
  • product info page refresh options in admin
  • My Auction view in My Account
  • Inform current highest bidders of new bids
  • Inform winning bidders at end of auction
  • Product added to cart of winning bidder at end of auction (Can't be removed by them)
  • Valid HTML (I hope)
  • Compatible with PHP4/5 MySQL4/5
  • Error free (error_reporting(E_ALL))
  • Compatible with .. RC2a (lower probably will work but untested)

 

Feedback and bug reports appreciated as always.

 

The files are http://addons.oscommerce.com/info/6431

 

The contribution is set so that no others can add packages this is to maintain some quality. This does not stop users from making suggestions here that could be integrated into a later release.

 

Finally I wanted to mention that this was not built by design it started off as a customer asking me to install another auctions contrib, the further I went into it the clearer it became that the previous contribution just couldn't work with the code in place, before I knew it I wasn't just changing code I was rewriting it . . the code would have been a lot better if planned from the start but it seems relatively solid.

 

how do I run the installer using EasyPHP?

Link to comment
Share on other sites

  • 2 weeks later...

I have quite a few auctions on our website. Is there a way to set a "flag" for the administrator NOT to add another auction for the same product ? This contribution does not support multiple auctions for the same product but it appears I can add multiple auctions for the same product.

ANy assistance as always is greatly appreciated.

Link to comment
Share on other sites

In admin/configuration/Auction Listing I have set the end of auction listing to 0 - meaning auction goes inactive - disappearing totally. This indeed happens when there is a bid - the information stays listed in admin and in the highest bidder account.

 

HOWEVER - when there are no bids on the auction, it does not disappear ???

 

Can someone verify for me please. Thank you for your time in advance.

Link to comment
Share on other sites

Is anyone still monitoring this contribution that can help me out with above two questions ?

 

Yes I am monitoring this.

 

I am a bit slower these days as Hotmail in their infinate wisdom have stopped outlook express downloading emails when I press Send/Recv this means that to see if I have received posts to any support threads I am monitoring I have to physically go to hotmail.com.

 

Re: Point one, there is no functionality at this stage to suppress such auctions.

 

Re: point 2 .. no I did not realise this I will try to replicate it and come back.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...