Products on order

[zohia]

Hi!

I'm trying to install products on order but can't undersand what to do in step 2.... it might be fairly easy but I just don't know what to do.

Any ideas?

 

It says:

 

### STEP 2.0 #####################################################

##################################################################

### DATABASE update SQL TO DO to add the delay order for product

### REQUETE SQL pour ajouter dans la base de donnŽe le dŽlai sur commande

##################################################################

 

###################################

### ALTER TABLE with the query

### OR LOAD the products_on_order.sql file

 

ALTER TABLE `products` ADD `products_on_order` INT(2) DEFAULT '0' NOT NULL AFTER `products_quantity`;

[Velveeta]

Hi!

I'm trying to install products on order but can't undersand what to do in step 2.... it might be fairly easy but I just don't know what to do.

Any ideas?

 

It says:

 

### STEP 2.0 #####################################################

##################################################################

### DATABASE update SQL TO DO to add the delay order for product

### REQUETE SQL pour ajouter dans la base de donnŽe le dŽlai sur commande

##################################################################

 

###################################

### ALTER TABLE with the query

### OR LOAD the products_on_order.sql file

 

ALTER TABLE `products` ADD `products_on_order` INT(2) DEFAULT '0' NOT NULL AFTER `products_quantity`;

Yes, you need to run that alter table query at the bottom of that section you posted, to add the new products_on_order field to your products table... You can either copy and paste it into phpmyadmin to run it that way, run it from the command-line mysql client if you have ssh access, or wrap that statement in a tep_db_query function call and execute it in a php script...

 

Richard.