Customer Purchase Order

[torweb]

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!!

[michael_s]

See this:
http://www.oscommerce.com/community/...purchase+order

[torweb]

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!!!

[torweb]

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

http://www.oscommerce.com/community/...purchase+order

[torweb]

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.

[tdiaz]

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.

</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>