E-Commerce User Guide : Appendix A: Detailed description of Sales Host operation : Sales Host processing : ww_email processing
 
ww_email processing
 
The ww_email table is used to generate any e-mail that needs to get sent. If the sales string processed contains an <email> tag, that information is transferred to the ww_email table when the sale is processed, assuming no errors are encountered. If an error is encountered, ww_email is populated if an <email_ex> tag is found (exception e-mail). The table is populated as follows at this point:
 
wwsale_id
Sale id of the ww_sales record
sale_no
Sale number of the sale that has been completed
email
XML information on the e-mail(s) to be sent
result
Empty (is filled in after the record is forwarded)
date_time
Date/time that the record is added
fwd_status
0
fwd_time
Empty
 
ww_email records are “forwarded” after the sale is completed. This consists of any records in the ww_email table with a fwd_status less than 2 being made into e-mail. A check is performed on the ww_tix table to ensure that any records associated with the sale have been forwarded. If they have not, an error is generated, “WW_TIX records did not exist on server so email could not be sent.” E-mail can be configured to attach the PDFs to the e-mail itself (using the <pt_em> and/or <pf_em> tags in the e-mail). If they can’t be attached, an error is generated, “Unable to attach proper number of pdf(s).” If they are sent successfully, the record is marked with a fwd_status of 2; otherwise 5, and the Result field is populated with the problem.