[Contribution]Purchase Orders for new checkout procedure.

[♥olby]

Just added a rewritten version of purchase orders, that works with the new checkout procedure.

 

Enjoy.

[cdii]

I have installed the purchase contribution, but when I try to use it I get the following error on the new (1129) checkout;

 

Warning: Failed opening 'includes/languages/english/modules/payment/po.php' for inclusion (include_path='') in c:phpdevwwwestore1129catalogincludesclassespayment.php on line 39

 

and this error on the admin side;

 

Payment Method: MODULE_PAYMENT_PO_TEXT_TITLE

 

Cheers

 

John

[♥olby]

Then I suggest that you just do what its asking for :wink:

 

Install the po.php language file into languages/english/module/payment/

[cdii]

Then I suggest that you just do what its asking for :wink:

 

Install the po.php language file into languages/english/module/payment/

 

Thanks for the tip, the file po.php was under directory payments instead payment, I guess typo error.

 

The module works perfectly, though I have one question;

Is it possible to have the purchase detail info under order in admin sections as per your po_order screen image i.e

 

Payment method: Purchase Order

Account Name: BGnet

Account Number: 123456

Purchase Order Number: 0012

 

Cheers

 

John

[♥olby]

Hi John.

 

If youv'e made the requested changes to the admin files and table orders, these informations is allready on your ordersheet. (select edit in admin).

 

If you would like to have it on invoice or packingslip you just copy the code from orders.php to one or both of the other files.

 

HTH

[cdii]

Thanks for your time and patience, I have tried almost everything, but I cannot get the order/ select /edit in admin to show the detail purchase order under payment. I have followed all the steps included in the readme. when I select credit card payment options, the details show on the admin under payment.

 

Thank You in Advance

 

John

[♥olby]

Hi John.

 

Are you running on a snapshot later than 1.th november? You should be.

 

Send me a copy of your:

/admin/orders.php

/admin/includes/catalog/order.php

/catalog/checkout_process.php

/catalog/includes/classes/order.php

 

or

 

give me the address to your /admin-section and /catalog, so I could take a look.

[ozstar]

Hello,

 

Before this vers came out I tried the other PO version by the Snowman and I learned later it didn't work for my Nov 22nd snapshot.

 

I now have the later vers that olby has kindly done but am now a lttle confused.

 

Do I keep the changes I made to the files for vers 1, or do I put them back as they originally were?

 

If that's the case what changes do I make to them now for this vers as there doesn't seems to be any instuctions there to change files.

 

I have placed the new files in the appropriate dirs and added the new fields to the db.

 

Bear with me...

 

Thank you

[♥olby]

Hi David.

 

This new version of PO is not a remix of Snowman's PO.

It's possible that some of the changes made are OK, but I really don't know.

I suggest that you undo Snowman's version by undoing his install.txt.

 

The table fields are, as far as I remember, the same.

HTH

[ozstar]

Thank you olby. I will deconstruct !

 

Are there any changes I have to make to any files or all I need to do is add the files in your zip?

 

Can't wait to get it happening!!

 

Thanks

 

David

[♥olby]

Hi David.

 

As stated in the install.doc, this is what you should do:

The following files have to be altered:

 

/admin/orders.php

/admin/includes/classes/order.php

/admin/includes/languages/english/orders.php

 

/catalog/checkout_process.php

/catalog/includes/classes/order.php

 

Search for "// purchaseorder" in the files included in this contribution.

 

I dont know, wheater theres has been made changes to these files since 9. th november.

You could rename the originals to .org.php and then try it out - see what happens :)

 

HTH

Good luck and enjoy.

[cdii]

Hi Olby,

 

Once again I thank you for helping me, I am using 1201 cvs and

link to my URL;

 

http://www.akilinet.com/default.php or http://66.12.80.2/default.php

http://www.akilinet.com/admin or http://66.12.80.2/admin

 

I do appreciate your effort.

 

Cheers

 

John

[♥olby]

Hi John.

 

Following your URL's gives the admin index.php but all the rest is Page not found.

Could you mail the files in question to:

[email protected]

[♥olby]

Theres an error in this first version, so please get this one in stead:

http://www.oscommerce.com/downloads.php/co...ions,757/type,1

[ozstar]

Hello,

 

I have installed v1.1 as per the install file but when I go to the checkout I get this on a white page..

 

Fatal error: Failed opening required 'includes/classes/order.php' (include_path='./:/usr/local/lib/php') in /home/starlite/starlite-www/catalog/checkout_shipping.php on line 42

 

I have checked I have the new order file there and I do, but can't find any reference where I have to insert any URL etc.

 

I also think it is easier for english folk to understand 'replace file' rather than 'altered' as I first thought I had to actually go in and make alerations to the files.

 

Thanks a lot..

[CC]

I just wondered a few things about this mod:

 

Why does this hack use Account numbers?

 

OSC doesnt provide account numbers for users as standard.

So how are you guys making this work?

If a customer doesnt have an account number, how will they know what to put in as they are purchasing??

 

How are you guys using this with Acc numbers??

 

Thanks

 

CC.

[♥olby]

David wrote:

I have checked I have the new order file there and I do, but can't find any reference where I have to insert any URL etc.

Sorry David, but this is not an error from this mod (as far as I can see).

Does everything else work?

Check again, that it's not orders.php.

Did you upload in ASCII-format?

Is classes/order.php corrupted in any way?

.... understand 'replace file' rather than 'altered' ....

The safest thing is allways to alter your excisting files. This mod is made on the snapshot from 9.th. of november, and there have been changes since then.

The class file order.php has to be changed in 3 places, clearly marked in the contributed version with // purchaseorder.

 

CC wrote:

Why does this hack use Account numbers?

Thats mostly a B2B thing. Every company has its customers registred by an account-number (phonenumber or otherwise generated).

It's not that common in B2C.

 

HTH

[ozstar]

Hello and thank you again. You were right ! On checking everything yet again I noticed I had forgotten to upload an order.php fille. Once I did that, It went fine.

 

There are a couple of q's though.

 

When I get the order email it does not give the Account name,A/c# and PO #. Should it?

 

Also When I click on the live link in that same email to see the invoice. I now get this.

 

I am not sure it is related to your great contrib, but I thought I'd mention it just in case. I will be looking elsewhere too altho' my speed is pretty slow on php at the moment.

 

This is what I get..

 

http://www.starlite.com.au/catalog/account...php?order_id=14

 

I get this..

 

1054 - Unknown column 'customers_status' in 'field list'

 

select customers_name, customers_company, customers_status, customers_status_name, customers_status_image, 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, comments, currency, currency_value, account_name, account_number, po_number, date_purchased, orders_status, last_modified from orders where orders_id = '14'

 

[TEP STOP]

 

Any ideas?

 

Thank Olby

[ozstar]

I'm not sure what is happening but the link above now works yet the new orders with numbers above 15 show that error message. This whether I have the PO on in Admin or not.

 

The last couple of tests brought down two duplicate emails for the 1 order.

 

I will keep checking.

 

Thanks

[♥olby]

Hi David.

 

I haven't put the fields into the email. I try to leave as little information in that as possible. Let people use the link instead.

 

As for the error:

 

/catalog/includes/classes/order.php find:

      $order_query = tep_db_query("select customers_name, customers_company, customers_status, customers_status_name, customers_status_image, 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, comments, currency, currency_value, account_name, account_number, po_number, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($order_id) . "'");

 

and replace it with:

      $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, comments, currency, currency_value, account_name, account_number, po_number, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($order_id) . "'");

 

somehow I've managed to get the Customer Status from elari mixed up into this contribution - sorry :?

[CC]

Olby wrote

CC wrote:  

Quote:  

Why does this hack use Account numbers?

 

Thats mostly a B2B thing. Every company has its customers registred by an account-number (phonenumber or otherwise generated).

It's not that common in B2C.

 

I understand this much as I would never offer a consumer the ability to purchase by purchase order number.

But how have you gone about generating an Account Number??

 

Have you got this automated or are you just alocating an account number to a business client manually.

I would like to do this for everyone, as I think everyone should have an account number for enquiries etc.

But then I would like to it be at the top of their account page. sort of the same as their name at the top.

 

Have you done something like this, or is there a call for something like this that I could create that more people would benefit from??

 

Cheers.

 

CC.

[♥olby]

Hi CC

 

I think theres a need for an account number - yes.

This number should be generated offline by the shop-owner, and put into table customers by the shop-owner.

Theres a lot of different Company policies concerning this accountnumber, so it can't / shouldn't be made automatically.

I haven't made anything in that aspect.

The accountnumber in this mod is just a textfield.

 

Normal procedure would be:

1. New Customer applies for becoming a customer at Company X

2. Company X checks the customer offline

3. Creates an account with all information in osc, with a temporary password

4. Company X sends the customer-account information to the customer.

 

3 and 4 can/should be used for existing customers, who wants to shop online.

 

I would like to help you out on this one, if needed.

[CC]

Thanks for the feedback Olby.

 

I like the ideas you have for this, and think it will indeed be useful to do it this way.

I foresee one problem.

If we were to do it this way we would need to be able to disable Purchase Order payment for all customer's without an official company credit acount.

This way consumer buys do not have the option to use this, and only the credit companies do have the option.

 

I will look more deeply into this and see how we could tie them together.

 

That said I would still like to put in place Account numbers for all clients so I can track them this way.

I want a client to call up with an enquiry and the first question they are asked is "Can I take your Account Number?"

 

Then this brings up the relevant client in the customers section.

 

Dont think this will be a small task, but surely one that is worth undertaking.

 

Any help from any OSC users will ba appreciated.

Any one who has already implemented this please shout up and offer us your assistance.

 

CC.

[elari]

maybe should be made with customers status ?

 

olby did you succeed to install cs ?

 

maybe can set in cs the allowed payment for each status and then payment module can be auto disabled (something like the cod) if not allowed

[♥olby]

Hi elari.

 

I was thinking the same, and yes I did succed to install cs, into Ians newest loaded version.

Haven't gone live yet, due to db-changes from my very old (4 month :) ) version, to the new one.

 

To all - mostly a forum administrator -

Could this and the last 4 postings be tranferred into a new topic called

 

Customer Account Number (still in contributions)

 

Please