New user's questions

[sheldonlg]

I have OSCommerce 2.2 installed with payment through PlugnPay. I have been able to add an object to the cart. When a user selects that and adds it to the cart, it goes to PlugnPay and the user gets a confrimation. (This is not live as yet, only in testing mode). I have not yet returned from PlugnPay, because I have to unprotect the site first.

 

Here are the questions:

1 - A purchase does not seem to show up in the orders table. Perhaps this is because it has not yet returned successfully from PlugnPay. I will find this out tonight when I unprotect the directory. It does, however, show up in the orders_total table. Furthermore, the orders_id fields in the two tables don't seem to match. Also, the customers_id for the last user does not show up in the orders table, even though it is in the custormers table. Is this installation all messed up?

 

2 - I want to integrate the addition of items to the database using my own web interface. To do this (There is a valid reason for this). To do this, I plan look at the tables as they are now set, and then check the changes that occur with the addition of a new product. I will then call the appropriate routines behind the scenes. I want to bypass the manual addition through the OSCommece interface.

[sheldonlg]

I removed the password protection on the directory. A test purchase went all the way through. However, nothing appeared in the orders table. Can someone please help me out here? :'(

 

Shelly