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
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?
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
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.
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
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?
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
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
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
Hehe. Was logged in with Anders' user apparently. Will just write this one as well to get notifications. ;)
/Rune
This site I am working on was built a while back......Does Tea Commerces store order info by default?
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
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
Oh. One question though. Tea Commerce v1 or v2?
The above is for Tea Commerce 1
/Rune
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
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
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
One more question, i notice that when TC storeds CC information its not encrypted is there any recommendations??
Best way would be to recover a backup. You cannot know what has changed or overwritten. The database might also have been changed.
/Rune
As for the CC information not being encrypted. In which scenario is that a problem?
/Rune
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?
it
There's no restore feature in Umbraco. You must contact your webhosting provider and ask them to restore the site.
/Rune
is working on a reply...