I am working on an assignment to add some extra columns to Order entity when order save into database. But it's using database table name _SitecoreCommerce.SharedEnviornment table and data store in db like given below:

enter image description here

Where to add a new column in this scenario? Can we solve this by creating a new plugin for order customization? If yes then how to define columns and assign the values while order capturing?

1 Answer 1


Sitecore Commerce 8.2.1 uses a sort-of NOSQL approach to data, so what you see in SQL Server is a JSON-serialized representation of your order.

You can add extra information to an order by adding a new Component to an order.

Kelly Heard from Sitecore has a blogpost (https://community.sitecore.net/technical_blogs/b/the_commerce_experience/posts/simple-commerce-plugin) on how to extend a line item which you can easily extend to extending an order.

If you need help, let me know.

  • Do we have any way for extending commerce reports?
    – Aman
    Commented Jul 8, 2017 at 13:44
  • Which reports do you mean?
    – Erwin
    Commented Aug 2, 2017 at 12:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.