Copied to clipboard

Flag this post as spam?

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


  • lanhhuyet 14 posts 22 karma points
    Jul 09, 2013 @ 21:07
    lanhhuyet
    0

    Configure Tea Commerce DB

    Hi, I am super noob when it comes to Tea Commerce, how do the adjust Tea Commerces to store order info?

    This is currently how it store when i use the UpdateOrderProperties() in .Net

    I would like to split the alia into columns like First, Last, Middle, Address

    Thanks

  • lanhhuyet 14 posts 22 karma points
    Jul 09, 2013 @ 21:12
    lanhhuyet
    0

    I can change the names of the Alias, but cant seem to split them into different columns, not sure if its a tea Commerce thing or sql issue

  • Anders Burla Johansen 2560 posts 8256 karma points
    Jul 09, 2013 @ 21:45
    Anders Burla Johansen
    0

    Hi Ian,

    Your problem is that you are having a ASP.NET runat=server form around your content. Kill that, fast :)

    All you need is regular html forms. Try taking a look at our starter kit for advise on how to set up a solution.

    And try to not use User Controls in Umbraco. They are difficult to maintain and not the way of the future. Have a look at Umbraco Web API instead.

    /Rune

  • Rune Grønkjær 1310 posts 2904 karma points
    Jul 09, 2013 @ 21:46
    Rune Grønkjær
    0

    Hehe. Was logged in with Anders' user apparently. Will just write this one as well to get notifications. ;)

    /Rune

  • lanhhuyet 14 posts 22 karma points
    Jul 09, 2013 @ 22:06
    lanhhuyet
    0

    This site I am working on was built a while back......Does Tea Commerces store order info by default?

  • lanhhuyet 14 posts 22 karma points
    Jul 09, 2013 @ 22:15
    lanhhuyet
    0

    Everything is working fine even though the site is built poorly, I just want to know if its possible to split Alias into different columns. can that be handled thru TC?  I do not remeber how TC is storing information, I search thru my solution and can not find where a connection is made to sql

  • Rune Grønkjær 1310 posts 2904 karma points
    Jul 10, 2013 @ 12:08
    Rune Grønkjær
    0

    The custom order and order line properties are are saved in the TeaCommerce_CustomOrderProperty and TeaCommerce_CustomOrderLineProperty tables in the database. The db layer of Tea Commerce is in it's own assembly seperated from the other API's.

    I'm not sure what you mean with splitting up the Alias?

    /Rune

  • Rune Grønkjær 1310 posts 2904 karma points
    Jul 10, 2013 @ 12:09
    Rune Grønkjær
    0

    Oh. One question though. Tea Commerce v1 or v2?

    The above is for Tea Commerce 1

    /Rune

  • lanhhuyet 14 posts 22 karma points
    Jul 10, 2013 @ 14:55
    lanhhuyet
    0

    Tea Commerce v1, Currently the way that it is saving into the database, when i use tc.updateorderproperties, its saving order information such as firstName, lastName, phone....etc all in one column as Alias, I would like to alter this process to save each property/field as its own column, I do not see where tea commerce is accessing db to save these fields

     

     

  • Rune Grønkjær 1310 posts 2904 karma points
    Jul 10, 2013 @ 15:18
    Rune Grønkjær
    0

    Well. You cannot alter the way the information is saved in Tea Commerce, BUT, you could hook into one of the .NET events and resave the property information. You could do that on AfterOrderFinalized when the order has been bought and paid for. At that point you could save the data in your own table, or whatever you want.

    /Rune

  • lanhhuyet 14 posts 22 karma points
    Jul 10, 2013 @ 15:25
    lanhhuyet
    0

    I have a tea commerce packaged 1.4.5 and upgrade to 2.1 without realizing they are not compatiable, is there anyway to fix this change set? its breaking tea commerce on site

     

    Thanks

  • lanhhuyet 14 posts 22 karma points
    Jul 10, 2013 @ 15:36
    lanhhuyet
    0

    One more question, i notice that when TC storeds CC information its not encrypted is there any recommendations??

     

  • Rune Grønkjær 1310 posts 2904 karma points
    Jul 10, 2013 @ 16:27
    Rune Grønkjær
    0

    Best way would be to recover a backup. You cannot know what has changed or overwritten. The database might also have been changed.

    /Rune

  • Rune Grønkjær 1310 posts 2904 karma points
    Jul 10, 2013 @ 16:28
    Rune Grønkjær
    0

    As for the CC information not being encrypted. In which scenario is that a problem?

    /Rune

  • lanhhuyet 14 posts 22 karma points
    Jul 10, 2013 @ 16:58
    lanhhuyet
    0

    I upgraded Tea Commerces thru Umbraco, im not sure if umbraco has a restore feature, as I have no backups for version of tea commerce, except to download 1.4.5 version and reinstalling that package is there a better way?

  • lanhhuyet 14 posts 22 karma points
    Jul 10, 2013 @ 16:59
    lanhhuyet
    0

    it

  • Rune Grønkjær 1310 posts 2904 karma points
    Jul 11, 2013 @ 08:45
    Rune Grønkjær
    0

    There's no restore feature in Umbraco. You must contact your webhosting provider and ask them to restore the site.

    /Rune

Please Sign in or register to post replies

Write your reply to:

Draft