sitecore commerce - basic queries

I have just started my XC learning. I have a few queries and require your help on this.

  1. In which DB does Sitecore store the items(sellable items, pricing cards) created in Sitecore XC ?
  2. Can we integrate product items created in Sitecore content tree with Sitecore XC ?
  3. Sitecore already enables future publishing configurable based on date. This enables flexible pricing based on dates. What's the advantage of using pricing cards?
  • Hi,

    1. Sitecore XC uses new Databases Global and SharedEnvironments. Within these Databases there are a few tables named XXXLists and XXXEntites. Within these Entities Tables Sitecore XC stores all the entities like sellable items, price cards, promotions, orders etc.

     

    2. That's already done OOTB via CommerceConnect. Commerce Connect is a full integration between Sitecore XP and Sitecore XC. This contains some API functionality, Analytics, but also Product handling in Sitecore XP. As you can see in the Screenshot, Catalogs, Categories, Products and Variants are shown as so called virtual Items. In the end these items are items and every interaction at this place triggers a corresponding functionality in Sitecore XC to update the changes there.


    Note: From Sitecore XC (9.0) on the stong recommendation is to not use Content Editor for Commerce item / information handling. This can also be seen in the fact, that the commerce items are OOTB protected. At least content editors should only use Business Tools for Sitecore XC related content handling


    3. Publishing of Sitecore product "items" or better entites is not done in Sitecore XP and not done via standard publishing mechanism of Sitecore XP. Sitecore XC has its own publishing mechanism to publish sellable items. Such publich mechanism as it is implemented now has OOTB no future publishing possibility.

    So in the to use price cards for furture pricing in general makes sense for commerce sellable items. In addition to that setting, price cards enables you to set currency based pricing, tag based pricing and tiered based pricing for now and the future with setting snapshots, which is for pricing far more powerful than, the item publishing mechanism

  • Hi,

    1. Sitecore XC uses new Databases Global and SharedEnvironments. Within these Databases there are a few tables named XXXLists and XXXEntites. Within these Entities Tables Sitecore XC stores all the entities like sellable items, price cards, promotions, orders etc.

     

    2. That's already done OOTB via CommerceConnect. Commerce Connect is a full integration between Sitecore XP and Sitecore XC. This contains some API functionality, Analytics, but also Product handling in Sitecore XP. As you can see in the Screenshot, Catalogs, Categories, Products and Variants are shown as so called virtual Items. In the end these items are items and every interaction at this place triggers a corresponding functionality in Sitecore XC to update the changes there.


    Note: From Sitecore XC (9.0) on the stong recommendation is to not use Content Editor for Commerce item / information handling. This can also be seen in the fact, that the commerce items are OOTB protected. At least content editors should only use Business Tools for Sitecore XC related content handling


    3. Publishing of Sitecore product "items" or better entites is not done in Sitecore XP and not done via standard publishing mechanism of Sitecore XP. Sitecore XC has its own publishing mechanism to publish sellable items. Such publich mechanism as it is implemented now has OOTB no future publishing possibility.

    So in the to use price cards for furture pricing in general makes sense for commerce sellable items. In addition to that setting, price cards enables you to set currency based pricing, tag based pricing and tiered based pricing for now and the future with setting snapshots, which is for pricing far more powerful than, the item publishing mechanism

  • Hello Venkatesh,

    here are answers to your questions:

    1. Sitecore XC has two separate databases, a) SitecoreCommerce9_Global and b)SitecoreCommerce9_SharedEnvironments. you can see sellable items and pricing cards in SitecoreCommerce9_SharedEnvironments database, see CatalogEntities table for sellable item and see PricingEntities table for pricing cards.

    2. OOTB No.

    3. I am not clear with your requirement but pricing cards allows you to setup quantity based pricing as well.