Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Peter Rombouts 71 posts 265 karma points
    Jan 07, 2014 @ 09:43
    Peter Rombouts
    0

    TC.GetAllFinalizedOrdersForCustomer not returning orders

    Hi all,

    I'm trying to retrieve finalized orders per customer in Umbraco/TeaCommerce. When calling GetAllFinalizedOrdersForCustomer with the correct store, and customer id, I get 0 records.

    Examining the finalized cache, I can see the following order (excerp):

    customerId="3287" dateCreated="2014-01-04T14:57:40" dateModified="2014-01-07T09:38:26" dateFinalized="2014-01-04T15:03:13" isFinalized="true" 

    Can anybody tell me why my results keep 0, although the order seems to be ok?

    Kind regards,
    Peter Rombouts

  • Anders Burla 2560 posts 8256 karma points
    Jan 07, 2014 @ 09:45
    Anders Burla
    0

    Which TC version do you use? I know that in v 2.1.1 we fixed a bug where no orders would be selected.

    Kind regards
    Anders

  • Peter Rombouts 71 posts 265 karma points
    Jan 07, 2014 @ 10:08
    Peter Rombouts
    0

    Hi Anders,

    We are running version 2.2.2

    Kind regards,
    Peter Rombouts

  • Anders Burla 2560 posts 8256 karma points
    Jan 07, 2014 @ 10:19
    Anders Burla
    1

    Using the razor API or XSLT?

    Can you send us your xml cache file to info (at) teacommerce.net so we can test. Also which store id you use and also the customer id

    Kind regards
    Anders

  • Peter Rombouts 71 posts 265 karma points
    Jan 07, 2014 @ 10:21
    Peter Rombouts
    0

    Hi Anders,

    It is a custom code project, so we are running the query in a .cs file.
    I will send all info the mailaddress you provided.

    Kind regards,
    Peter Rombouts

  • Peter Rombouts 71 posts 265 karma points
    Jan 07, 2014 @ 11:38
    Peter Rombouts
    100

    Hi all,

    Thanks to the outstanding help of the TeaCommerce team the issue is resolved.
    The problem was that the 'StoreID' was not properly set in some usercontrol on our side, which resulted in the errors.

    Our better understanding of the xml cache will help us in the future debugging these issues.

    For future reference, the XML files suffix (like -0 of -1) is the StoreID.
    That will give you a clue that there is something wrong.

    In our case, the ID is 1 but the logs contained both 0 and 1 files, and thanks to those files Anders pointed us in the right direction.

    Thanks Anders!

    Kind regards,
    Peter Rombouts

Please Sign in or register to post replies

Write your reply to:

Draft