DataConnector
SalesRule
ColumnName DataType Description
Rule_id Int Rule Id
Name String Name
Store_labels String Store Labels
Description String Description
Website_ids String A List Of Websites The Rule Applies To
Customer_group_ids String Ids Of Customer Groups That The Rule Applies To
From_date String The Start Date When The Coupon Is Active
To_date String The End Date When The Coupon Is Active
Uses_per_customer Int Number Of Uses Per Customer
Is_active Boolean The Coupon Is Active
Condition String Condition
Action_condition String Action Condition
Stop_rules_processing Boolean To Stop Rule Processing
Is_advanced Boolean Is This Field Needed
Product_ids String Product Ids
Sort_order String Sort Order
Simple_action String Simple Action Of The Rule
Discount_amount String Discount Amount
Discount_qty String Maximum Qty Discount Is Applied
Discount_step Int Discount Step
Apply_to_shipping Boolean The Rule Applies To Shipping
Times_used Int How Many Times The Rule Has Been Used
Is_rss Int Whether The Rule Is In RSS
Coupon_type String Coupon Type
Use_auto_generation Boolean To Auto Generate Coupon
Uses_per_coupon Boolean To Auto Generate Coupon
Extension_attributes String Extension Attributes