default table generated by wizard

The default tables generated by the checkout wizard do not create 2 sets of addresses. I do have the "ill offer shipping" box checked on the wizard, however im not setting up any connections to external shipping (shipping will jsut be based on total cost). When the pages are generated, the order confirmation page does have a billing section and shipping section. HOWEVER the database table generated by tthe process only has 1 set of address fields. and to be even more confusing, the NAME, ADDRESS, and ADDRESS2 fields all have SHIP in the name, but the city state zip does not. SO i end up with this:

OrderShipName
OrderShipAddress
OrderShipAddress2
OrderCity
ORderState
OrderZip
OrderCountry

i also only have 1 field for phon, fax, email.

so what am i doing wrong. this is really weird.

aslo i realized that its missing other fields.

it did create a field for the total, the shipping, the tax, but it didnt for any credit card fields (type, exp) nor did ir create any fields for CHARGES or at least a CHARGES field that is the sum total of all charges.

am i crazy? i thought this did this all before.

sam

the fields created by the wizard in the orders table are:

OrderID
OrderAmount
OrderShipName
OrderShipAddress
OrderShipAddress2
OrderCity
OrderState
OrderZip
OrderCountry
OrderPhone
OrderFax
OrderShipping
OrderTax
OrderEmail
OrderDate


if you require additional fields, you will need to edit the table after it is created to add them.


NOTE: you mention fields for storing credit card details, do not store the credit card information in your database.

This is a very bad practice and in almost all cases is illegal.

i do not normally store cc info in the database. but my client wants to run the transactions offline because she has a swiper terminal. i really hate doing this and have told her she has to clear out the cc info asap. But i dont know what else to do if she si going to run them offline.

Do you have alternative options? i would love another solution other than emailing her the cc info.

_Never_ Email Credit card numbers. that's worse than storing them in the database.

if the client wants to run the credit card of line, the only viable _legal_ option is to call the customer and process the order with them on the phone.

no i would never email credit card numbers (unless i wanted it to be stolen).

however - im not understanding how you are referring to this as illegal.
i have inherited a few sites that use cart32 for thier cart/checkout.
and it has the option to store orders and credit card info (no payment gateway).
these 2 clients use it this way.
so that cart system was built with the option in it to just store the info.

believe me i dont like this setup, but i dont see how its illegal. especially if she is clearing the credit card info within a few days of the order being placed.

i realize this isnt your job to discuss this, its very off topic.
i need to meet the clients needs but at the same time i dont want to do anything that is illegal.

Look up PCI (Payment Card Industry) compliance.


If you are thinking of storing credit card information to your database, regardless of how long it will be saved to the database, the database server and site will need to comply to PCI standards of security.