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
- Catalog-Entry level
- Order level
- Shipping level
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.
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 :
- 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.
- PX_POLICY: this table tells about the promotion policies.
- PX_USAGE: this table tells about statistics the promotion usage. also contains the ORDERS_ID of the orders to which the promotion was applied.
- 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.
Real concept...
ReplyDelete