We use AspDotNetStorefront Multistore 9.1.0.1/9.1.0.0.

I plan to run a daily-deal promotion in which each user will have a unique coupon code. So we will have a large number of coupon codes. I'd like to know the maximum number of coupon codes that the platform can accommodate.

A related question: Does the platform provide a way to upload mulitple coupon codes, with all of them having the same parameters (same dollar amount discount, free shipping not included, etc.)? Or would this require customization?

Thanks very much for any assistance on this.
in MultiStore by (110 points)

2 Answers

0 votes

I'm guessing that the promotions are stored in its own table, you would be able to create as many as you'd like.

the problem that I see is that when you go into the Promotion Editor in the portal, with the high number of records, it will take a bit longer.

We have 15,000 product, 187 categories, 1938 sections ("Departments"...we call them "Attributes"), so when we go in the portal, it is slow.

I ran this in my portal. [Configuration] - [Advanced] - [Run SQL] - DO NOT RUN THIS, unless you know SQL.

You would just create a stored procedure that increments the "Code".

insert into Promotions (name, Description, UsageText, Code, CallToAction, priority, active, autoassigned, PromotionRuleData, PromotionDiscountData)
values ('test1', 'test description',
    'Special promotion', '123', 'Special Offer!', 1, 1, 0,
    '<ArrayOfPromotionRuleBase xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" />',
    '<ArrayOfPromotionDiscountBase xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <PromotionDiscountBase xsi:type="OrderPromotionDiscount">
    <DiscountType>Percentage</DiscountType>
    <DiscountAmount>0.1</DiscountAmount>
  </PromotionDiscountBase>
</ArrayOfPromotionDiscountBase>')

 

by (1.5k points)
Thanks very much.  You comments are quite helpful.
0 votes

I just did the same.

Imported 300,000 unique per customer coupons into a test version (on 9.0.1.3 as promos operates differently from 9.3 onwards)

I took a copy of the current Coupons table, exported this to a csv. Added the values for the coupons and then imported into a temporary table then inserted this into the coupons table.

We had a litte trouble with 64 bit drivers on our server. But if you can get a csv or xls sheet working then something like this could import it straight into the Coupon table (without the need for a temp table)

 

select *
into Coupon FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\coupon.xls;HDR=YES',
'SELECT * FROM [coupon$]')

In the above statement

[coupon$] was our sheet name, this will be Sheet1 in Excel by default.

As always test on a develeopment copy of the database!

 

 

by (2.3k points)
...