November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Marketing, campaigns and discounts in database?

Tommy Albinsson
Tommy Albinsson
Vote:
 

Hi,

I have had some issues regarding the gui not beeing updated after I create a campaign or discount via code. Where can I find the campaign and discounts in the databse? The promotions/campaign tables seems empty to me so where does epi save them?

#181901
Edited, Sep 04, 2017 11:22
Joel Yourstone
Joel Yourstone
Vote:
 

Promotions are stored in the cms database together with other content, in tblContentType. :) And the values are stored just as cms values in the tblContentProperty. 

Edit: This is the "new" promotion system introduced in Commerce 9.24.

#181905
Edited, Sep 04, 2017 14:19
Quan Mai
Quan Mai
Vote:
 

We don't disclose on how data is saved in database. If you have problem with data is not being shown in UI, then you can post your code here and we might spot the problem. Also, it would help if you state your versions, and which promotion system you are using (the new or the legacy one, as Joel commented) 

#181908
Sep 04, 2017 16:48
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.