Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Updating SQL for PO number


Recommended Posts

I installed the Puchase Order Number contribution and it said to use a SQL editor to add to the table..


Add these 3 fields to table orders by running these lines in phpmyadmin or what ever you prefer.

# Add customers purchase orders values to each order

ALTER TABLE `orders` ADD `account_name` VARCHAR( 32 ) NOT NULL AFTER `currency_value` ;

ALTER TABLE `orders` ADD `account_number` VARCHAR ( 20 ) AFTER `account_name` ;

ALTER TABLE `orders` ADD `po_number` VARCHAR ( 12 ) AFTER `account_number` ;


. I couldnt get a editor to work so I opened the SQL file in HTML kit and added the lines...


account_name varchar(32) ,

account_number varchar(20) ,

po_number varchar(12) ,


in the table. Then I loaded it onto the server. In the admin area, looking at the orders, it says Purchase order, but it does not say the customer number or name. Is there something I did wrong?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...