|
guiapenin
|
January 24, 2018 at 3:38 am
Good Morning,
I would like to know if there is a list of equivalences between the tables of the EE3 and EE4 databases?
In EE3 we implemented a plugin that allowed us to generate thousands of codes and insert them in EVENTS_DISCOUNT_CODES_TABLE and EVENTS_DISCOUNT_REL_TABLE automatically using the fields coupon_code,coupon_code_price, use_percentage,coupon_code_description, wp_user,code_limit.
we would like to know what fields are equivalent in EE4
Thank you
Event Espresso – 4.9.55.WordPress 4.9.2
|
|
Josh
|
January 24, 2018 at 12:32 pm
Hi guiapenin,
EE3 → EE4
coupon_code → _esp_promotion.PRO_code,
coupon_code_price → _esp_price.PRC_amount and _esp_promotion.PRC_ID,
use_percentage → no exact equivalent; use _esp_price_type,
coupon_code_description → _esp_price.PRC_description and _esp_promotion.PRC_ID,
wp_user → _esp_price.PRC_wp_user and _esp_promotion.PRC_ID,
code_limit wasn’t a field in EE3, but you could check out _esp_promotions.PRO_uses
|
|
guiapenin
|
January 25, 2018 at 12:38 am
Thank you very much for the reply. Let’s try and comment if it works.
Another doubt, to what would be the discount_id
Regards
|
|
Josh
|
January 25, 2018 at 6:18 am
esp_promotion.PRO_ID, and you’ll also give each promotion its own esp_price.PRC_ID
|
