What is the best way to store order/item in umbraco?
Hi, I work on a very small shop website.
I use simplecart.js to manage online basket. But at the end of the checkout, i need to store the small order. I got it in XML format:
---order ------item ------item
I am using umbraco v6 and i think i can use custom datatype to save my XML in a parseable way (http://www.nibble.be/?p=51). But it is efficient for the purpose of keeping record or purchace? That information will be on the cache avalaible to all?meaby saving directly in a private table inside umbraco DB is a best way to do this?
Either way of storing the orders will work. However, I think it's more convenient to store them in custom tables in the database and then create a new custom section in Umbraco for handling all store/order related transactions. By storing the orders in custom tables you limit the number of things that can possibly go wrong. Storing them as nodes in Umbraco means they're stored in the database and in the XML cache. If something goes wrong somewhere along the way in syncing the database and XML cache, chances are that data about orders will get lost (not saying this is likely to happen, though)
Generally speaking, I think it's a good practice to consider what is actual content that should be handled in the Content section and what is user generated data. I tend to create custom tables for user generated data to keep the content section as clean as possible :-)
What is the best way to store order/item in umbraco?
Hi, I work on a very small shop website.
I use simplecart.js to manage online basket. But at the end of the checkout, i need to store the small order. I got it in XML format:
---order
------item
------item
I am using umbraco v6 and i think i can use custom datatype to save my XML in a parseable way (http://www.nibble.be/?p=51). But it is efficient for the purpose of keeping record or purchace? That information will be on the cache avalaible to all?meaby saving directly in a private table inside umbraco DB is a best way to do this?
thanks in advance.
Hi Pierre,
Either way of storing the orders will work. However, I think it's more convenient to store them in custom tables in the database and then create a new custom section in Umbraco for handling all store/order related transactions. By storing the orders in custom tables you limit the number of things that can possibly go wrong. Storing them as nodes in Umbraco means they're stored in the database and in the XML cache. If something goes wrong somewhere along the way in syncing the database and XML cache, chances are that data about orders will get lost (not saying this is likely to happen, though)
Generally speaking, I think it's a good practice to consider what is actual content that should be handled in the Content section and what is user generated data. I tend to create custom tables for user generated data to keep the content section as clean as possible :-)
All the best,
Bo
Thanks for reply! I will use custom table and edmx file.
is working on a reply...