Support

Home Forums Event Espresso Premium EE4 Promotions bulk upload

EE4 Promotions bulk upload

Posted: July 11, 2018 at 3:21 pm


Debbie B

July 11, 2018 at 3:21 pm

I have to import 1000 discount codes for an event.

Previously in EE3 there was the ability to do a bulk upload using a csv file. Is there an equivalent for EE4?

If not is there a way that I can upload 1000 codes quickly?


Tony

  • Support Staff

July 12, 2018 at 3:42 am

Hi there,

Not currently no, may I ask what type of promotion codes these are?

The reason I ask is is they are Social coupon codes a bulk option wouldn’t help as their use case will likely not be supported. For example if they are coupon codes, which should be available for only single use but can be used on any event, the promotion system does not have an option to do that.


Debbie B

July 12, 2018 at 2:34 pm

They are Groupon codes so for one event only and for one use only.


Josh

  • Support Staff

July 12, 2018 at 7:03 pm

Hi,

May I ask is there only one event open for registration at this time, like there’s no other events that can be registered for?


Debbie B

July 12, 2018 at 8:35 pm

My website has multiple events up at any one time but this particular groupon promotion is for a specific event on a specific day.

The idea is to sell 1000 tickets through groupon where the buyer receives a specific code that when they register for the event reduces the price to $0.

I could do this easily with ee3 but with ee4 it seems to be impossible which seem like a step backwards to me.


Debbie B

July 14, 2018 at 4:43 am

Is there a workaround? Can I do something through the SQL database?

I really do not want to create 1000 individual codes in the next week.


Josh

  • Support Staff

July 14, 2018 at 12:40 pm

You might be able to do this through the SQL database via a CSV import. Sequel Pro is a recommended app for this.

In this case each promo code would add one row to each of these 3 tables:
_esp_price
_esp_promotion
_esp_promotion_object

and you’ll need to be sure to increment the IDs.

Here are some example CSV files for each of the above that can be edited to add more codes using a spreadsheet app:

_esp_price
https://slack-files.com/T02SY781D-FBQDZQKC4-45a2bdf891

_esp_promotion
https://slack-files.com/T02SY781D-FBQ4SKHFB-a598b29dfd

_esp_promotion_object
https://slack-files.com/T02SY781D-FBRV6QE06-09ceae1a12

Note for example if your last price recorded in _esp_price has ID 799, the first promotion-related price ID can be 800, then increment by 1.

Hope that helps, please let us know if you have any questions.


Tony

  • Support Staff

July 16, 2018 at 4:59 am

Hi Debbie,

Do you have a test/developer site you can run some tests on?

A little while ago I modified the EE3 voucher import tool to work with EE4 which would allow you to set up a setting page similar to the current promotion code page and select a CSV with the promotion codes within, it will then loop over all of the codes and create a promotion using those settings.

In short, it loops over X amount of rows in the CSV and creates a promotion in EE using that code and the settings you set when selecting the CSV.

It’s not official and should be considered unsupported/experimental but you are more than welcome to try it if you would like? The reason I asked if you have a test site is I would recommend testing out that it works for you first before using it on the live site as you’ll be adding at least 1000 rows to multiple tables for the promotions to work based on the above, you’ll want to be sure it’s going to work for you before doing so.

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: publish

Updated by  Tony 1 week ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!