Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2010
    Posts
    20
    Plugin Contributions
    0

    Default Order info in the db

    I have a problem with the information which is being saved in the database.

    I am unable to find any solution and what I would appreciate is some information, if someone can provide it (it will be very difficult to provide a solution, because I do not even know what is going on).

    When a customer places an order, Zencart triggers the email with the order and saves the data in the db.

    The email sent to the client is always correct; we have not detected any mistake and the amounts are correctly calculated. The information to process payment (Paypal / Credit card), is also correct (I am referring to the order total).

    However the information stored in the db with respect to the order is not always correct and sometimes it is stored without VAT.

    It is not happening in any specific combination of shipping and payment method; it happens sometimes in cod, sometimes in Paypal and also sometimes in storepickup, in flat shipping... so it is not that. (Only affecting the info included in the db).

    My question is:

    Can someone tell me the files that deal with the email which is sent to the clients and the file storing the order info in the db, so I can check them?

    Thanks in advance for your help
    (and sorry if it is a very easy question, I am not an expert and have been unable to find such files).

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Order info in the db

    Moving this out of the Bug Reports section, because it's not a bug in Zen Cart core code.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Order info in the db

    1. MOST IMPORTANT ISSUE: You're using an obsolete version of Zen Cart with known security holes. You need to upgrade ASAP.

    2. The emails are sent AFTER the order details are stored in the database, and are built using the same variables/data. The only reason they'd be different is if your code has been altered from its original design. It's largely all handled in /includes/classes/order.php. But since you allege it's not working correctly for you, it's possible that you've got various other pieces that have been altered incorrectly as well.

    I recommend following these steps: http://www.zen-cart.com/wiki/index.p...ing_From_Hacks ... until you've completely proven that nothing is compromised and that nothing extra has been added that doesn't belong and that all your database data is perfectly intact.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #4
    Join Date
    Oct 2010
    Posts
    20
    Plugin Contributions
    0

    Default Re: Order info in the db

    I wrote too fast...
    Last edited by vimad; 3 Feb 2012 at 05:54 PM. Reason: Already answered by Dr. Byte.

  5. #5
    Join Date
    Oct 2010
    Posts
    20
    Plugin Contributions
    0

    Default Re: Order info in the db

    Great!! that is somewhere to start!!!
    Thanks a lot!

 

 

Similar Threads

  1. Replies: 2
    Last Post: 24 Dec 2013, 08:05 PM
  2. v150 Writing extra order info to the db
    By jeffiec in forum General Questions
    Replies: 25
    Last Post: 14 Sep 2012, 08:56 PM
  3. Change the order of info in Product Listing
    By moxy in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 28 Dec 2006, 10:23 PM
  4. What file holds all the order and customer info ?
    By snarkys in forum Managing Customers and Orders
    Replies: 3
    Last Post: 19 Nov 2006, 12:26 PM
  5. Lining up info correctly on the My Account / Order Info Page
    By eist1 in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 8 Sep 2006, 09:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg