Exporting subsets of promotion codes
About this task
By default, when you use the Management Center Promotions tool to export promotion codes, all of the promotion codes for a promotion are exported. You can configure a store to limit the maximum number of unused promotion codes to export. To configure this limit, you must insert a record in the STORECONF table for your store. This record sets the maximum number of codes to include in a promotion code export for your store. This subset size is associated with a single store and only exports promotion codes that are not already used for the promotion.
When you specify a subset for a store, all subsequent promotion code exports use that subset to determine the number of unused codes to export. To export all promotion codes after you configure a subset, you must delete the subset configuration from your database, or change the subset value to -1. To change the number of promotion codes included in your subset, you must run a SQL update statement that changes the value field of your subset.
Procedure
- Open a connection to your database to run SQL statements into the database.
-
Run the following SQL query:
Where NumberOfCodes is the number of promotion codes to include in the subset of promotion codes.INSERT INTO STORECONF (STOREENT_ID, NAME, VALUE) values (StoreId, 'wc.promotion.NumberOfUnusedPromotionCodesToExport', 'NumberOfCodes');