Bulk upload or create coupons?

[silken]

I would like to give an individual, one-time use coupon to each person registered to my site and cannot figure out the easiest way to do this. I certainly don't want to have to generate 2000 separate coupons. Is there a way I can upload an excel, csv or other formatted file containing coupon numbers (I can easily generate those in excel) to the coupon datatabase? Or is there something more obvious I am missing?

Thanks in advance,
Debbie

[Jim]

There is currently no built in way to create multiple individual coupons or to upload coupons created outside of ShopSite.

One of our hosting partners, Lexiconn, has a module that can do something like this but it is available only to stores hosted by them. See http://www.lexiconn.com/ecommerce/shopsite/coupon-creation-module.html

[silken]

That's sad! Is there a way to add a column to the customer registration that would allow this?

[Jim]

"That's sad! Is there a way to add a column to the customer registration that would allow this?" No.

[Jim]

I found a way that it can be done using a free scripting application, iMacros for Firefox. iMacros is also available free for Chrome and I believe IE. Do a google search for "imacros free download" to get links to the various free browser addons. You can install it in FireFox using the Addon's functionality.

I recorded a script that will create a single coupon and then modified it to add a number to both the coupon name and the coupon code (so each coupon is unique). I then ran the macro using the Loop option and created as many coupons as the value I set for the loop.

Code: Select all

VERSION BUILD=8601111 RECORDER=FX
TAB T=1
URL GOTO=https://my.domain.com/cgi-bin/ss/start.cgi
TAG POS=1 TYPE=IMG ATTR=ID:nav_img_m4
TAG POS=1 TYPE=IMG ATTR=ID:button_coupons
TAG POS=1 TYPE=INPUT:IMAGE FORM=ACTION:coupon.cgi ATTR=ID:button_add_a_coupon
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:FormName ATTR=NAME:CouponName CONTENT=test<SP>{{!LOOP}}
TAG POS=1 TYPE=TD ATTR=TXT:Specific<SP>products:
TAG POS=1 TYPE=SELECT FORM=NAME:FormName ATTR=NAME:Year CONTENT=%2014
TAG POS=2 TYPE=INPUT:RADIO FORM=NAME:FormName ATTR=NAME:coupon_onetime
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:FormName ATTR=NAME:Percent CONTENT=10
TAG POS=1 TYPE=TD ATTR=TXT:Entire<SP>orderSpecific<SP>products:<SP>Allow<SP>only<SP>1*
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:FormName ATTR=NAME:MinimumCurrency CONTENT=25.00
TAG POS=1 TYPE=TD ATTR=TXT:Currency:<SP>$<SP>Units:
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:FormName ATTR=NAME:AlternateCode CONTENT=testcode{{!LOOP}}
TAG POS=1 TYPE=INPUT:IMAGE FORM=NAME:FormName ATTR=ID:button_create_coupon_link
TAG POS=1 TYPE=INPUT:IMAGE FORM=NAME:FormName ATTR=ID:button_save_changes

It takes about 2-3 seconds to create each coupon this way, I created 100 in about 3 minutes. One thing that you need to watch for is that coupons cannot have the same name or coupon code. Running the script as is would attempt to create duplicate coupons each time since the LOOP value would start at 1 each time you run the script. This could be overcome by using some other value for the coupon code and name such as the date and time. You could also change the coupon name and coupon code text each time you want to create a bunch of coupons.

I use imacros for many things that I have to do on a frequent basis such as updating my test stores, logging in to various sites etc. It is a remarkable tool for the fact that it is free to use. They have a commercial version of the product too but for what I do the free version is sufficient.

[silken]

Wow, Jim, I don't know what to say. Thank you so much for taking the extra time to do this. I am one happy uuser!

I've never done this before but will see if I can figure it out. Nonetheless, your effort is astonishing.
Debbie