[ic] Is an order E-Mail Receipt available as a CSV file?

Dorothy Puma dorothy at digilink.net
Thu Oct 9 00:24:23 EDT 2003

Hostmaster wrote:
>>>Hello List Members,
>>>Someone places an order on our Interchange Shopping Cart.  The order
> goes
>>>through, and the customer is E-mailed an acknowledgement of the
>>>Is there a file on the server where the information contained in the
>>>transaction acknowledgement E-mail is stored?  I looked at
>>>but that wasn't the one I am looking for.
>>>Michael G.
>>If you go in the User Interface and click the table tab which list all the
>>tables in IC.
>>The customer order information is in the orderline table you can download
> it
>>from there.
> Thank you for the reply.  The orderline table text file is not the one I am
> looking for.  It does not contain the information received by the customer
> in an email receipt.  I have included the information from the Email receipt
> (names and addresses changed) to illustrate what I am looking for.  This
> information is also available if I go into the Admin Interface, and click on
> "Orders", then the Order Number.  I would like to be able to find the
> database where this specific information is stored before it is processed
> for Email or for the Browser.  Please see below for the information I am
> looking for in a CSV or text file, and thanks again:
> ------------------------------------ 
> Dear Hardware, Inc. customer,
> Thank you for your order #0117. It is being electronically processed.
> Name: Walter Peterson
> Company: CS Productions
> Email address: walt at empire.com
> Address: One North Main
> City, State, Zip: Los Angeles, Utah  90038
> Country: US
> Payment Method: Credit Card (visa)
> Shipping Method: UPS Ground Commercial
> Daytime Phone: 323-555-1212
> Evening Phone:
> Quan  Item No.    Description                            Price
> Extension
> ---- ----------- ------------------------------- ---------- ----------------
> ----
>   1  3249-0400-1  "LEFT HANDED PLIARS"         $12.50
> $12.50
>      00000
>   1  3202-0300-1 "JIG SAW BLADE"              $8.90
> $8.90
>      00000       GALV"
>                                                  SUBTOTAL
> $21.40
>                                                  SALES TAX
> $1.41
>                                                  SHIPPING
> $0.00
>                                                  ORDER TOTAL
> $22.81
> Should you have a question about your order, or about other Hardware, Inc.
> products, please reply to this message and let us help.
> Always reference your order number when calling for a status.
> You can visit your account maintenance page to check order status.
> Remember, you can always visit our site at:
>     http://hardwarinc.com/cart
> Regards and thanks for your business!
> Hardware, Inc.
> 12 South Main
> Los Angeles, CA
> 800-555-1212
> -------------------------------------------
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

The order information is contained in both the transactions and the 
orderline tables, with information also being in the userdb.  The 
information that you see in the admin section gets pulled from all three 
of these tables.  Have you looked in your orders directory? There is a 
copy of the email that is sent to the admin of the site. If you need 
specific reports, you can use the templates in the etc directory to 
create your own.  There is also a Quickbooks module that you can use to 
create itf files.  Here is a link to the latest version from CVS. 

If itf format is not what you are looking for, you can use the module as 
your basis to customize to fit your needs.


More information about the interchange-users mailing list