Community Add-Ons

All credit to Howard van der Burgt for making this GREAT contribution! This is a FULL PACKAGE for an OSC 2.2RC2a Vanilla Store (English) and includes the following updates:
-Added the Modified Files for Clean Install
-Added Beginning/End Comments where needed for those files
-Fixed Error in 'make_an_offer.php' that caused item and original price not to appear in email offers sent to shop owner. Credit to Shawnm Posted 17 June 2007 - 12:43 PM
-Added 'mouseover' note informing customer how to use the direct offer box. Credit to angelstudio54 Posted 18 April 2009 - 05:04 PM
-Changed grammatical error in english>make_an_offer.php "Your order has been successfully send.." to "Your offer has been successfully sent.."

Same file as before. I forgot to rename the update instruction files after I decided at the last moment to raise the version number to prevent confusion with infoBrokers addon.

This is the full package again.

v3.0 Make An Offer
- Depending upon a new admin setting the offer will be handled by email as before or an acceptable offer will be added directly to the shopping cart

Bugfix:
- Fixed wrong calculation when only one decimal was entered (ie. 3.5 instead of 3.50)

NOTE:-
- if you are upgrading from a previous version the maximum allowed offer percentage setting will be reset to the default
- I have added the German language file (thanks to Infobroker for providing this) but not the SQL statements from this addon provided by Infobroker.
- read the installation instructions carefully, especially if you have contributions like TotalB2B, CCGV and thelike running in your shop !
- a Dutch and English screenshot are inside the file for the new functionality

Have fun and I hope you like the new functionality !

Update offer and status with flags in admin/product_updates.php

Aktivierungs- und Deaktivierungsmöglichkeit von Angeboten und Status in der admin/product_updates.php

Build the Admin interface where you can see and handle
the products with offers in priceupdate (Basic:http://www.oscommerce.com/community/contributions,2415).

"Machen Sie ein Angebot" jetzt mit Updatemöglichkeiten im Admin auf der Seite: Produkt Preis, Lager, Gewicht und Angebot Update auf Basis: http://www.oscommerce.com/community/contributions,2415

With german languages directory

Mit deutscher Sprachdatei und SQL-Dump sowie deutscher Anleitung.

I made a typo error within the install instructions and put an underscore where it should have been a dot :-(
This is the full package with the type error corrected. Sorry for the inconvenience !

Urgent update to Make An Offer v2.0 and v2.1 !!
Thanks to PopTheTop for pointing this out.
Bugfix:
- Fixed a serious error which occured when a currency symbol was displayed before the price (it wouldn't calculate correctly against the maximum percentage allowed as set in the Admin)

Full package with update instructions.

v2.1 Make An Offer
- The customer has the option to send a confirmation to his own email address yes or no
- Through the Admin configuration you can set a maximum discount percentage related to the original price for which you will accept an offer (to prevent ridiculous offers)
- The status to show or not show the 'Make An Offer' button can now also be set without the need to edit a product (through the same method as you can enable/disable a product)
- In the Admin it is visible for each product if it is on Special or not. This to prevent possible mistakes when activating
the 'Make An Offer' button while the product is also on Special (except of course if you really want this).

- Bugfix:
After an error on the email address all product information was lost which lead to an empty email regarding the product information

All neccessary files provided for Dutch and English language. It's build for multilangual use so it should be easy to adapt to other languages.

Next step:
Admin interface to handle the received offers

Just replace the image file and both PHP files for this update.

Changes:

1) Designed a better looking image that matches the default stock osC images.

2) Re-wrote some of the code for better results. The original code only pulled the customer's first name. This is now fixed.

3) Submission is now being sent to the customer who send the offer.

4) Added more language defines, including one for a small "thank you" note to the customer.

5) Gave the e-mails a cleaner look.

6) The default setting of "0" in Admin / Product Editor now works correctly. It was defaulting to YES when you added a new product. Plus, the code was calling "false" instead of "0".

The contrib is now on a per product basis so it's more flexible for myself and hopefully others.
This update involves one database addition and places an extra field inside your product definition page. The option defaults to not show the 'Make An Offer' button so you don't have to worry about everything being negotiable all of a sudden :-)

This is a complete package with install instructions in English and Dutch (for which all the files are also provided).

I hope this contribution will be useful for others too so have fun with it !

No file uploades, just i could not get the origional script to add the customers email address, so in make_an_offer.php in the root dir, easy

replace:
------------
// add customer details (1/1) paulm 2004/04/02
if (tep_session_is_registered('customer_id'))
{
$name = $customer_first_name . ' ' . $customer_last_name;
$email = $customer_email_address;
}
// end add customer details

--------------

With
--------------
if (tep_session_is_registered('customer_id')) {
$customer_info_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");
$customer_info = tep_db_fetch_array($customer_info_query);
$name = $customer_info['customers_firstname'] . " " . $customer_info['customers_lastname'];
$email = $customer_info['customers_email_address'];
}

-----------


Thats all.

This contribution will add an extra button to the product information page through which a visitor can
send the shop owner an offer for that specific product.
The shop owner will receive an email for the offer and
after that can negiotate a little more with the potential
customer if needed. This contribution is of course only useful for shops which do not neccessarily have a fixed price set on the product.
Instructions and language files for Dutch and English provided.