osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Customer Purchase Order

This is a discussion on Customer Purchase Order within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; Is there any way of including a field for customer's Purchase Orders. It would be nice to have this ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 06-14-2006, 01:36 PM
Member
 
Join Date: Feb 2006
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
torweb
Default Customer Purchase Order

Is there any way of including a field for customer's Purchase Orders. It would be nice to have this as a field on the Invoice and Packing List. My client was used to this while using XCart. It could be placed in the Orders.php

It's nothing that I could do from scratch. Just wondering if someone has already worked on this.

Thanks for any feedback!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 06-14-2006, 02:28 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,247
Thanks: 66
Thanked 294 Times in 280 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default RE: Customer Purchase Order

See this:
http://www.oscommerce.com/community/...purchase+order
__________________
Michael Sasek
osCMax Developer


osCMax Templates - Hundreds of premium quality templates. New designs every month!

xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience


osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 06-19-2006, 01:23 PM
Member
 
Join Date: Feb 2006
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
torweb
Default Purchase Order Option

First off, thanks Michael for the link to the Purchase Order mod...

Does anyone have any additional info on this. I keep running into a problem tring to add the additional fields to the Orders tabel in the SQL Database. I get a syntax error with the "NOT NULL AFTER" command. Here is what the SQL fields are supposed to look like according to the documentation:

`ip_order_no` VARCHAR( 30 ) NOT NULL AFTER `cc_expires` ,
`ip_requested_by` VARCHAR( 30 ) NOT NULL AFTER `ip_order_no` ,
`ip_contact_person` VARCHAR( 30 ) NOT NULL AFTER `ip_requested_by` ,

I can get it to work if I update the table with the following but don't know if this will work as it leaves out the designation after the command:

`ip_order_no` VARCHAR( 30 ) NOT NULL default '' ,
`ip_requested_by` VARCHAR( 30 ) NOT NULL default '',
`ip_contact_person` VARCHAR( 30 ) NOT NULL default '' ,

The link to the mod and documentation is:

http://www.oscommerce.com/community/con ... hase+order

My customer really needs this or some type of Purchase Order feature..

Thanks as always for any help!!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 06-20-2006, 08:39 AM
Member
 
Join Date: Feb 2006
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
torweb
Default Purchase Order

Sorry...I've posted the wrong link for this modification

http://www.oscommerce.com/community/...purchase+order
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #5  
Old 06-20-2006, 05:08 PM
Member
 
Join Date: Feb 2006
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
torweb
Default Purchase Order

Well, whoever reads this (if anyone), I've figured it out. It was mostly a problem with instructions...a couple of confusing gramar issues. It took me 7 hours to make operational but I did it!!!!!

Next I'll customize the look a bit to make it fit better with the invoice layout.

I'd post the issues here with regards to instructions, but there were so many I'd need to write a install manual..maybe I will.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #6  
Old 09-28-2006, 09:15 AM
New Member
 
Join Date: Feb 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
tdiaz
Default RE: Purchase Order

I'm looking for a way to allow the customer to specify a PO# as optional. Like a comment, not a payment option. Some customers want a PO# referenced on their invoice regardless of payment method. I've installed Institutional Purchase Order, but since it's a payment option it can't be used simultaniously with say, Credit Card. If I can figure out what is needed to make this work: (get the data passed to the fields, i'd be set)

I've added this in checkout_payment.tpl.php and there's no problem with the display or processing, I'm missing something to get the data into the fields. I've got the same fields as Instututional Purchase Order.


Code:
</tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
          <tr>
            <td class="main"><b><?php echo 'Purchase Order Information' ?></b></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
          <tr class="infoBoxContents">
            <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
                <tr> 
                  <td class="main"><?php echo 'Purchase Order #:'; ?><br>
                    <?php echo tep_draw_input_field('ip_order_no', $HTTP_POST_VARS['ip_order_no']);?></td>
                </tr>
                <tr> 
                  <td class="main"><?php echo 'Purchase Order Contact:'; ?><br>
                    <?php echo tep_draw_input_field('ip_requested_by', $HTTP_POST_VARS['ip_requested_by']);?></td>
                </tr>
                <tr> 
                  <td class="main"><?php echo 'Purchase Order Comment:'; ?><br>
                    <?php echo tep_draw_input_field('ip_contact_person', $HTTP_POST_VARS['ip_contact_person'], '', '', false);?></td>
                </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>

      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10');  ?></td>
      </tr>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
how to place an order for a customer? pal osCMax v1.7 Discussion 2 05-10-2005 06:29 AM
customer order pickup lil-raskals osCommerce 2.2 Modification Help 4 11-22-2004 05:23 PM
Add order to customer details Musicman osCommerce 2.2 Modification Help 0 01-06-2004 02:36 PM
customer comments in order and extra order email karen_l osCommerce 2.2 Modification Help 0 01-03-2003 11:51 AM
Help with Purchase Order add Anonymous osCommerce 2.2 Modification Help 1 12-01-2002 10:15 AM


All times are GMT -8. The time now is 09:44 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2008 osCMax