Jump to content
Sign in to follow this  
penfold_99

[Contribution] Purchase Order V2.3

Recommended Posts

I was wondering if someone can help me with my problem with Purchase Order v.2.3.3 running under

OSC 2.2 ms 2.

 

I've installed this contrib three times. It installs perfect with nothing wrong. But my problem is that the total of the orders are not being charged to the credit account.

 

for example. when i process an order for $40 by loggin into the client's account with a $500 credit limit, the $40 is not changing the balance.

 

is there something I'm doing wrong. Well evidently, since it's not working.

 

i've already installed it, and enabled it through the customer's account.

 

If someone could please help me out.

 

thank you.

 

Wish I could help on this one Tom, but mine seems to do the math correctly and I can't find a reason it wouldn't. I am, however, a novice. Good find helping out Irin earlier BTW!

 

Mike

Share this post


Link to post
Share on other sites
Wish I could help on this one Tom, but mine seems to do the math correctly and I can't find a reason it wouldn't. I am, however, a novice. Good find helping out Irin earlier BTW!

 

Mike

 

hey mike,

thanks for the response. but when you say, yours seem to do the math correctly, does this mean that you enter in the sales total to the purchase order section manually? or is the balance adjusted automatically when a granted customer orders through their account?

 

to my understanding, the correct way is the mod adjusts the balance itself instead of the store owner adjusting the balance him/herself. now if yours is working properly, then its gotta be something with the po.php file in the modules directory.

 

what do you think?

 

i too am a novice at this. but it seems that you've helped quite a bit of people in the past. in my book, that's a SUPER NOVICE.

 

thanks for the compliment, but i'm starting to think that majority of osc developers, or semi developers problems in this forum is that we mainly overlook or mis-read something in the directions during the installation.

 

or....we all smoke too much. lol j/k

 

tom

Share this post


Link to post
Share on other sites

Try Purchase Orders 1.4.1 by Houston Dill

 

I installed it over a year ago and it works great. Since then I have heavily modified the contrib and even used it to create other mods requiring the same logic.

 

Unfortunately I have too many things on my plate to sort it all out and repackage it right now ... but the original mod works fine.

Share this post


Link to post
Share on other sites

Actually I did repackage my own modded version Purchase Orders v1.5 .. i just found it buried in my files.

 

I will try an get some time to go over it and repackage it again with more changes I have added.

 

That is ... if anyone is interested.

Share this post


Link to post
Share on other sites

Hello!

 

I installed Purchase Order V2.3.3 and Purchase Order Account Application, and it works very well!! Thanks!

 

I would like to know your advice : would it be hard to have many slave-accounts "linked" to one master-credit-account? As long as new users know the master's account number and ZIP code, their new accounts would be created and they wouldn't be able to purchase passed the master's credit limit and delivery would be made to master-account.

 

Would it be possible...?

 

Thanks in advance!

Share this post


Link to post
Share on other sites

Hi. I think I have this contribution working. I had one strange side effect that is puzzling me. All of my quantity discount pricing was deleted from my products and I am baffled as to why

 

I have SPPC and Quantity Price Breaks installed that may be giving me a conflict. There were two points in the PO instructions where I could not cutNpaste, but had to merge...

 

Can someone tell me if I did it correctly or did this merge cause my loss of my discount data? or could it of been the inertion of the sql into the db? im a lil confused.

 

in admin/customers.php, my existing code did not match the instructions beacuse of a previous edit for SPPC, it says to do this:

 

line 239 replace the following code

$customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");

with this code:

// Company PO Account start
// Added c.customers_allow_purchase_order_entry to query.
	$customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_credit_account_status, c.customers_credit_amount, c.customers_credit_status, c.customers_credit_left,  c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");
// Company PO Account end

 

I ended up with this:

 

	  // BOF Separate Pricing Per Customer and company PO added 4 entries Credit
	$customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_credit_account_status, c.customers_credit_amount, c.customers_credit_status, c.customers_credit_left, c.customers_email_address, a.entry_company, a.entry_company_tax_id, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_group_id,  c.customers_group_ra, c.customers_payment_allowed, c.customers_shipment_allowed, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");

 

and then in catalog/admin/includes/classes/orders.php, my existing code did not match the instructions beacuse of a previous edit for SPPC, it says to do this:

 

find

  $order = tep_db_fetch_array($order_query);

  $totals_query = tep_db_query("select title, text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . tep_db_input($order_id) . "' order by sort_order");

ABOVE it add

// Company PO Account start
 		// Added purchase_order_number to query.
  $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, purchase_order_number, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($order_id) . "'");
// Company PO Account end

 

I ended up with this:

 

	function query($order_id) {
  $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, purchase_order_number, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");
  $order = tep_db_fetch_array($order_query);

 

Did I do this correctly? could the edits cause the loss of pricing data in the catalog?

 

 

and lastly, Does "Mikey's fix" test out as functioning? this was the only other edit I thought of that may have some effect...

 

 

Thanks for the help. The site

Dave


-Dave

Share this post


Link to post
Share on other sites
...when you say, yours seem to do the math correctly, does this mean that you enter in the sales total to the purchase order section manually? or is the balance adjusted automatically when a granted customer orders through their account?

 

Hey Tom, mine seems to deduct the order total from the customers credit limit automatically when they place the order. Using the "Increase Credit" and "Payment Credit" fields in the customer edit window are kind of funky, but they seem to work ok too. If you want a copy of my po.php (or other file) to compare with, just say the word.

 

And, I think that your assessments of "most problems" hits both of my nails on the head! lol

Share this post


Link to post
Share on other sites
Hey Tom, mine seems to deduct the order total from the customers credit limit automatically when they place the order. Using the "Increase Credit" and "Payment Credit" fields in the customer edit window are kind of funky, but they seem to work ok too. If you want a copy of my po.php (or other file) to compare with, just say the word.

 

And, I think that your assessments of "most problems" hits both of my nails on the head! lol

 

 

Hey Hawg-

I think I'm gonna need a copy of your po.php file. For some reason, it's not hitting the balance when I order through whether my admin or through the customer's account.

 

I really do appreciate your help. HELP!!!

tom

Share this post


Link to post
Share on other sites
Hey Hawg-

I think I'm gonna need a copy of your po.php file. For some reason, it's not hitting the balance when I order through whether my admin or through the customer's account.

 

I really do appreciate your help. HELP!!!

tom

 

Here's my po.php (I hack tables/cells alot to match my store, so it might look more different than it really is from the MOD orignal)

 

<?php

/*

$Id: cc.php,v 1.1.1.1 2004/03/04 23:41:17 ccwjr Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

class po {

var $code, $title, $description, $enabled;

 

// class constructor

function po() {

global $order;

global $customer_id;

 

$this->code = 'po';

$this->title = MODULE_PAYMENT_PO_TEXT_TITLE;

$this->description = MODULE_PAYMENT_PO_TEXT_DESCRIPTION;

$this->email_footer = MODULE_PAYMENT_PO_TEXT_EMAIL_FOOTER;

$this->sort_order = MODULE_PAYMENT_PO_SORT_ORDER;

$this->enabled = ((MODULE_PAYMENT_PO_STATUS == 'True') ? true : false);

 

// mikey's fix for showing/hiding PO payment option :P

$check_accstat = tep_db_query("SELECT customers_credit_account_status, customers_credit_status from " . TABLE_CUSTOMERS . " where customers_id ='" . $customer_id . "'");

$accstat = tep_db_fetch_array($check_accstat);

If ($accstat['customers_credit_account_status'] =='0' ){

$this->enabled = false;

}

 

}

 

// class methods

 

function selection() {

global $order;

 

$selection = array('id' => $this->code,

'module' =>'<img src="images/icons/PO.gif">?????' . $this->title,

'fields' => array(array('title' => MODULE_PAYMENT_PO_TEXT_NUMBER,

'field' => tep_draw_input_field('po_number', ''))));

 

return $selection;

}

 

 

function javascript_validation() {

/* $js = ' if (payment_value == "' . $this->code . '") {' . "\n" .

' var cc_owner = document.checkout_payment.cc_owner.value;' . "\n" .

' var cc_number = document.checkout_payment.cc_number.value;' . "\n" .

' if (cc_owner == "" || cc_owner.length < ' . CC_OWNER_MIN_LENGTH . ') {' . "\n" .

' error_message = error_message + "' . MODULE_PAYMENT_CC_TEXT_JS_CC_OWNER . '";' . "\n" .

' error = 1;' . "\n" .

' }' . "\n" .

' if (cc_number == "" || cc_number.length < ' . CC_NUMBER_MIN_LENGTH . ') {' . "\n" .

' error_message = error_message + "' . MODULE_PAYMENT_CC_TEXT_JS_CC_NUMBER . '";' . "\n" .

' error = 1;' . "\n" .

' }' . "\n" .

' }' . "\n";

*/

return $js;

}

 

function pre_confirmation_check()

{

global $HTTP_POST_VARS;

global $order;

global $customer_id;

 

 

$error = '';

 

$check_credit = tep_db_query("SELECT customers_credit_account_status, customers_credit_status, customers_credit_left from " . TABLE_CUSTOMERS . " where customers_id ='" . $customer_id . "'");

 

$credit = tep_db_fetch_array($check_credit);

 

If ($credit['customers_credit_account_status'] =='1' )

{

If ($HTTP_POST_VARS['po_number'] == '')

{

$error = sprintf(MODULE_PAYMENT_PO_TEXT_ERROR_NO_NUMBER);

}

else

{

if ($credit['customers_credit_status'] == "1")

{

if ($order->info['total'] > $credit['customers_credit_left'])

{

$error = sprintf(MODULE_PAYMENT_PO_TEXT_ERROR_NOT_ENOUGH_CREDIT. $credit['customers_credit_left']);

}

}

else

{

$error = MODULE_PAYMENT_PO_TEXT_ERROR_CREDIT_DISABLED;

}

}

}

else

{

 

$error = sprintf(MODULE_PAYMENT_PO_TEXT_ERROR_NO_CREDIT_ACCOUNT);

}

If ($error)

{

$payment_error_return = 'payment_error=' . $this->code . '&error=' . urlencode($error) ;

tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, $payment_error_return, 'SSL', true, false));

}

}

 

function confirmation() {

global $HTTP_POST_VARS;

 

$confirmation = array('title' => $this->title,

'fields' => array(array('title' => MODULE_PAYMENT_PO_TEXT_NUMBER,

'field' => $HTTP_POST_VARS['po_number'])));

return $confirmation;

}

 

function process_button() {

global $HTTP_POST_VARS;

 

$process_button_string = tep_draw_hidden_field('po_number', $HTTP_POST_VARS['po_number']);

return $process_button_string;

}

 

function before_process() {

global $HTTP_POST_VARS, $order;

 

$order ->info['po_number'] = $HTTP_POST_VARS['po_number'];

}

 

function after_process()

{

return false;

}

 

function get_error() {

global $HTTP_GET_VARS;

 

$error = array('title' => MODULE_PAYMENT_PO_TEXT_ERROR,

'error' => stripslashes(urldecode($HTTP_GET_VARS['error'])));

 

return $error;

}

 

function check() {

if (!isset($this->check)) {

$check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_PO_STATUS'");

$this->check = tep_db_num_rows($check_query);

}

return $this->check;

}

 

function install() {

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable credit account Module', 'MODULE_PAYMENT_PO_STATUS', 'True', 'Do you want to accept payments by credit account?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort order of display.', 'MODULE_PAYMENT_PO_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0' , now())");

}

 

function remove() {

tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");

}

 

function keys() {

return array('MODULE_PAYMENT_PO_STATUS', 'MODULE_PAYMENT_PO_SORT_ORDER');

}

}

?>

 

If this doesn't help, I'd look closely at "catalog/checkout_process.php" and "catalog/includes/classes/order.php" too. I think that's where the automated math happens. Then again, the proverbial blind leading the blind might be applicable here as well...

 

Mike

Share this post


Link to post
Share on other sites

Quick question: Is this contribution based off the osCommerce 2.2 Milestone 2 Update 051113 snapshot? Or a prior snapshot? Thanks in advance.


Most likely your question has been answered, please do a search first.

Share this post


Link to post
Share on other sites

I am using it on 2.2 Milestone 2 Update 051113

 

site

 

no one answered my question above, but I think its working ok. A few merge issues with SPPC...

 

Dave


-Dave

Share this post


Link to post
Share on other sites
Quick question: Is this contribution based off the osCommerce 2.2 Milestone 2 Update 051113 snapshot? Or a prior snapshot? Thanks in advance.

 

hey flying monkey,

yeah this is good for osc 2.2 ms 2.

Share this post


Link to post
Share on other sites

hey roaddoctor...

is that what it is? is it an issue merging with sppc? cause i have sppc installed, and i'm having a problem with the customers processing the order through their account. it's not hittiing the balance. it's not subtracting or adding to the balance.

 

is this the same problem you're having.

 

hawgwired -

thanks for that po.php file you sent me. we almost have the same files. i didn't see anything different on mine than yours in regards to the purchase order coding.

 

if anyone has any other suggestions, that'd be cool.

 

please? thanks again.

Share this post


Link to post
Share on other sites

Hi

 

Purchase Order Module works great. However, I also have the Purchase Without Account (PWA) module installed too. What is happening is that customers who do not have an account and who have not logged in, also see the PURCHASE ORDER option when they go through the payment procedure, by going directly to payment without logging in using PWA.

 

I need to HIDE the Purchase Order Account and number box on the checkout_payment.php page, so that ONLY logged in users can see this payment option.

 

Many thanks.

Share this post


Link to post
Share on other sites
Hi

 

Purchase Order Module works great. However, I also have the Purchase Without Account (PWA) module installed too. What is happening is that customers who do not have an account and who have not logged in, also see the PURCHASE ORDER option when they go through the payment procedure, by going directly to payment without logging in using PWA.

 

I need to HIDE the Purchase Order Account and number box on the checkout_payment.php page, so that ONLY logged in users can see this payment option.

 

Many thanks.

 

hey maze

you should check out a few posts back by hawg-wired. he put in a fix for this here. in this same thread a few post back...i think at around post #34. He included in there with //Mikey's fix

Share this post


Link to post
Share on other sites

Thanks for you response.

 

I tried it but it won't work. Actually I didnt expect it to work.

 

Mikeys fix wont work because the fix checks on the customer status in the database.

 

Customers using the PWA go diretc to checkout without logging in. So the system cannot check against the customer database.

 

I need a simple IF statement which checks if the user is logged in, then if he is, the Purchase Order box shows. This IF statement can be in ADDITION to the other checks made against the database too.

I just dont know where to add this &&.

 

 

Need to sort this urgently.

Share this post


Link to post
Share on other sites

Here's a patch to let customers view their own credit limit and available credit.

--- old-store/account_edit.php 2006-03-22 15:26:36.000000000 -0500

+++ new-store/account_edit.php 2006-03-22 15:26:36.000000000 -0500

@@ -113,7 +113,7 @@

}

}

 

- $account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");

+ $account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax, customers_credit_account_status, customers_credit_status, customers_credit_amount, customers_credit_left from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");

$account = tep_db_fetch_array($account_query);

 

$breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));

@@ -226,11 +226,19 @@

<td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td>

<td class="main"><?php echo tep_draw_input_field('fax', $account['customers_fax']) . ' ' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td>

</tr>

- </table></td>

+

+ <?php if (($account['customers_credit_account_status'] == 1) && ($account['customers_credit_status'] ==1)) { ?>

+ <tr><td class="main">Credit Limit: </td> <td class="main"> $<?php echo $account['customers_credit_amount'] ?> </td></tr>

+ <tr><td class="main">Available Credit: </td><td class="main"> $<?php echo $account['customers_credit_left'] ?> </td></tr>

+<?php } ?>

+ </table>

+ </td>

</tr>

- </table></td>

+ </table>

+ </td>

</tr>

- </table></td>

+ </table>

+ </td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

Share this post


Link to post
Share on other sites

As anyone further modified this to allow someone to use an additional payment method if the line of credit runs out? For example, maybe you want to place an order for $250, with $200 on the Purchase Order, and $50 on a credit card.

 

I'm tried to assess how hard this customization would be.

 

Mark

Share this post


Link to post
Share on other sites

I have an idea, but I'd like to know everybodies opinions. I am going to design an addon. With the Purchase Order number on the checkout payment in the form it is (the person enters any number they want and it'll process it.)

 

I am thinking of coding an addon so that the admin can set a Purchase Order number (which will basically be like an ID) that if the customer is enabled, then they can view the Purchase Order on the checkout page, if their not setup for a Credit Account, they will not see it. It'll also use the Purchase Order Application in conjunction. Customer submits the application, admin reviews it, if Accepted, and an automatic (or manually set) Purchase Order number is assigned.

 

I think this'll be much easier on people and since it will basically be automated, this'll save a little more time for big business sales and such. First off, I'd like the authors of both contributions permission first. Second off, this contribution that I am thinking of developing will most likely be labeled "Purchase Order 3.0" since it'll enhance new features. I'm even debating to add some AJAX to it (quicker changing and such.)

 

It'll be open-source, just to clear it up as some issues have arisen about me asking for opinions on developing a contribution and then it being COMMERCIAL (WHICH IT WILL NOT!) So let me know everybody.


Installed Contributions: AJAX Menu, AJAX Attributed Manager, AP URL ReWriting, Credit Class and Gift Vouchers, CCGV Report, Date of Birth PullDown, FCKEditor for Product Desc., Monthly Installment Payments, More Pictures 6, MSRP Savings, Must Agree to Terms on Checkout, Order Editor, Payment Method Fee, PopUp Promo, Private Messages, Purchase Order, Purchase Order Application, Secure Admin Login-Logout, STS Plus, SugarCRM Integration, Supertracker, Tax Exempt and Organization Discounts, Your Recent History.

 

23 Total Contributions Installed :)

Share this post


Link to post
Share on other sites
I have an idea, but I'd like to know everybodies opinions. I am going to design an addon. With the Purchase Order number on the checkout payment in the form it is (the person enters any number they want and it'll process it.)

 

I am thinking of coding an addon so that the admin can set a Purchase Order number (which will basically be like an ID) that if the customer is enabled, then they can view the Purchase Order on the checkout page, if their not setup for a Credit Account, they will not see it. It'll also use the Purchase Order Application in conjunction. Customer submits the application, admin reviews it, if Accepted, and an automatic (or manually set) Purchase Order number is assigned.

 

I think this'll be much easier on people and since it will basically be automated, this'll save a little more time for big business sales and such. First off, I'd like the authors of both contributions permission first. Second off, this contribution that I am thinking of developing will most likely be labeled "Purchase Order 3.0" since it'll enhance new features. I'm even debating to add some AJAX to it (quicker changing and such.)

 

It'll be open-source, just to clear it up as some issues have arisen about me asking for opinions on developing a contribution and then it being COMMERCIAL (WHICH IT WILL NOT!) So let me know everybody.

I would like such add-on, I would like to help. PM me!

Share this post


Link to post
Share on other sites

Alright then Plascual, thanks for the help. I shot you a PM... I am going to try and code it all on my own though so if you want to help, I'll need a BETA tester group. So let me know.


Installed Contributions: AJAX Menu, AJAX Attributed Manager, AP URL ReWriting, Credit Class and Gift Vouchers, CCGV Report, Date of Birth PullDown, FCKEditor for Product Desc., Monthly Installment Payments, More Pictures 6, MSRP Savings, Must Agree to Terms on Checkout, Order Editor, Payment Method Fee, PopUp Promo, Private Messages, Purchase Order, Purchase Order Application, Secure Admin Login-Logout, STS Plus, SugarCRM Integration, Supertracker, Tax Exempt and Organization Discounts, Your Recent History.

 

23 Total Contributions Installed :)

Share this post


Link to post
Share on other sites

Great contribution!

 

I installed the contribution, but it appears that the purchase order number is not saved into the database for each order. Consequently, the customer cannot view the purchase order number. It temporary saves the purchase order number during checkout; but it's just not written into the db.

 

Does anyone's work properly? Please check your account_history_info.php to verify that it does. Thanks in advance!

Edited by FlyingMonkey

Most likely your question has been answered, please do a search first.

Share this post


Link to post
Share on other sites
Quick question: Is this contribution based off the osCommerce 2.2 Milestone 2 Update 051113 snapshot? Or a prior snapshot? Thanks in advance.

 

Hi flying money,

 

the contrib is based on milestone 2 but should also work on creloaded 6.15+

 

Penfold

Share this post


Link to post
Share on other sites
I have an idea, but I'd like to know everybodies opinions. I am going to design an addon. With the Purchase Order number on the checkout payment in the form it is (the person enters any number they want and it'll process it.)

 

I am thinking of coding an addon so that the admin can set a Purchase Order number (which will basically be like an ID) that if the customer is enabled, then they can view the Purchase Order on the checkout page, if their not setup for a Credit Account, they will not see it. It'll also use the Purchase Order Application in conjunction. Customer submits the application, admin reviews it, if Accepted, and an automatic (or manually set) Purchase Order number is assigned.

 

I think this'll be much easier on people and since it will basically be automated, this'll save a little more time for big business sales and such. First off, I'd like the authors of both contributions permission first. Second off, this contribution that I am thinking of developing will most likely be labeled "Purchase Order 3.0" since it'll enhance new features. I'm even debating to add some AJAX to it (quicker changing and such.)

 

It'll be open-source, just to clear it up as some issues have arisen about me asking for opinions on developing a contribution and then it being COMMERCIAL (WHICH IT WILL NOT!) So let me know everybody.

 

Baby Boy,

 

i have a problem with the admin setting the th PO number as this is for the customer to use to link an order to an invoice with there busines, why generate a po number when the invoice number does the same thing for our use?

 

couple of other things.

 

what is ajax? i'm all for simple things but it it really needed?

 

if you are thinking of doing a major upgrade, can you add these things as i have not had time to devote to this.

 

If a order is cancelled, increase the credit limit by the amount of the order.

 

generate a pdf document the customer has to sign, this is a leaglly binding contract and if the customer doesn't pay then you can produce this document.

 

allow bulk entry of invoice numbers and mark them as paid this will inturn adjust the credit level.

 

i have a few other things that could be included so if your willing to do it then pm me.

 

penfold

Share this post


Link to post
Share on other sites
Baby Boy,

 

i have a problem with the admin setting the th PO number as this is for the customer to use to link an order to an invoice with there busines, why generate a po number when the invoice number does the same thing for our use?

 

couple of other things.

 

what is ajax? i'm all for simple things but it it really needed?

 

if you are thinking of doing a major upgrade, can you add these things as i have not had time to devote to this.

 

If a order is cancelled, increase the credit limit by the amount of the order.

 

generate a pdf document the customer has to sign, this is a leaglly binding contract and if the customer doesn't pay then you can produce this document.

 

allow bulk entry of invoice numbers and mark them as paid this will inturn adjust the credit level.

 

i have a few other things that could be included so if your willing to do it then pm me.

 

penfold

 

Hi Guys,

 

I've installed this contribution and when i go into the admin section for customers, i can edit the customers account, but i get this appearing at the top of the screen:

 

Warning: reset() [function.reset]: Passed variable is not an array or object in C:\wamp\www\oscommerce-2.2ms2-051113\catalog\admin\includes\classes\object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in C:\wamp\www\oscommerce-2.2ms2-051113\catalog\admin\includes\classes\object_info.php on line 18

 

Any ideas as to what is causing this problem?

 

I've had a nose through this contribution forum, but not come across anything.

 

Help please!!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×