Tuesday 4 February 2014

Promotions in WCS. 

Promotions provide the ability to attract the customers to purchase the items from the site and make them visit once again once the promotions are available. WCS supports 3. types of promotions which play the vital role for any site which is developed in WCS, the following are the types of promotions that WCS supports
  1. Catalog-Entry level
  2. Order level
  3. Shipping level
Catalog-Entry Level Promotions: Under this type the WCS supports some kind of promotions that are related to the catalog,category.
For example : Buy Catalog entry A,Get Catalog Entry B free
                      Buy Catalog Entry A, Get some percentage off on the purchase of Catalog entry B.
                      Percentage off on the total amount on purchase of catalog entries fro a category.
                      Amount off on the subtotal of catalog entries of a category.
                      Buy X & Y , get a percentage off on both, etc.

Order level Promotions: Under this type of promotions we deal the promotions which are enabled during when the order is getting placed by a customer in the site.
For example : Percentage off on an order
                      Certain amount off on the order being placed
                      Free gift with an order.
Shipping level Promotions: This type of promotions deals with the shipping of the item that is being placed for order.
For Example : Free Shipping of the order
                      Discounted Shipping for an order using a selected shipping mode.
                      Discounted Shipping for an item using a selected shipping mode.

Data Model and the tables related to Promotions:

Promotion Data Model

The main tables in Promotion data model are :
  1. PX_PROMOTION: this table contains Promotions and its status (i.e. Active & Inactive),Starttime and Endtime ,Code-that is is related to that particular promotion.
  2. PX_POLICY: this table tells about the promotion policies.
  3. PX_USAGE: this table tells about statistics  the promotion usage. also contains the ORDERS_ID of the orders to which the promotion was applied.
  4. CLCD_PROMO: this table stores information about the relationship between the Calculation Framework and the promotion standalone infrastructure. Each calculation code matches one promotion in the PX_PROMOTION table.



No comments:

Post a Comment

Solr settings and full indexing (Attribute task update)

SOLR is mainly used for : Indexing Querying    SOLR is a product of apache and having the inbuilt server named jeety. Mainly the ...