|
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
|
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
|
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
|
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
|
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.
|
|
Debbie B
|
July 24, 2018 at 2:39 am
I would be happy to test drive the ee3 import functionality, understanding thaat it may not work 100%.
Thank you,
Debbie
|
|
Tony
|
July 24, 2018 at 3:23 am
You can download it from here:
https://github.com/Pebblo/eea-voucher-import
Click the ‘Clone or download’ button and download as zip, then upload as a plugin – Dashboard -> Plugins -> Add New -> Upload Plugin.
Then go to Settings -> EE4 Voucher Import
Set the settings up as is you were creating a normal promotion but there is also a field for the Event ID you want the promotions to apply to.
The CSV is formatted with 2 columns – http://take.ms/CFw8e
The first column should usually just be 1 for evry field (1 means the promotion is active and should be imported, 0 means it is not active and should not be imported).
The second column is the Promo code to use.
|
