Problem
I am trying to add a coupon code, but an error displays similar to the following:
Code name has already been used. Parameter name: Code
However, there isn’t another coupon with the same code.
Solution
Ensure that there isn’t a duplicate active coupon code on the page. If this is the case, this may be a rare issue related to a coupon code existing in the Database but not in the UI. If you are an Administrator, a possible solution is to delete the coupon entry from the Database.
Important: Updating Database records directly bypasses the DirectScale software business logic, which has the potential to cause serious problems. Only corporate Administrators with the proper permissions should attempt.
Admin: Corporate Admin
Page: Tools > Developer Tools > Data Editor
URL: [CLIENTID].corpadmin.directscale.com/Corporate/Admin/SQLEditor
Permission: EditSqlEditorAdvanced()
-
Select the ORD_Promotions table, and filter by the coupon code.
SELECT * FROM ORD_Promotions WHERE Code = '<Your_Code_Here>'
-
Select the checkbox next to the row you want to delete.
-
Click the Delete {#} Row(s) button.
Now, you can create your coupon.
Comments
Please sign in to leave a comment.