Peter H Posted August 1, 2017 Share Posted August 1, 2017 Hi I have transfered my store to a new domain and all went well but now all my Promotional Codes have turned into gift cards and I cant edit them any Idea of whats happened ? Quote Link to comment Share on other sites More sharing options...
moodybear Posted August 1, 2017 Share Posted August 1, 2017 Having similar issues where some promotional codes aren't visible but are still working (some people have taken advantage and I'm trying to stop it) The ones that I created before CC6 seem to have vanished.. Is there somewhere they are stored in a css? Quote Link to comment Share on other sites More sharing options...
ayz1 Posted August 1, 2017 Share Posted August 1, 2017 The coupon info is stored in the CubeCart_coupons table in your store database. Don't know why they aren't visible but I would guess if you want to stop a code being used you could delete the relevant code record from the coupons table. Always back up your database before editing it. Quote Link to comment Share on other sites More sharing options...
Peter H Posted August 3, 2017 Author Share Posted August 3, 2017 Hi I found the info in CubeCart_coupons but I want them back in the coupon list so I can edit them as and when I want. I don't even know if Technical support can help with this. Quote Link to comment Share on other sites More sharing options...
ayz1 Posted August 3, 2017 Share Posted August 3, 2017 Try adding a new coupon and test it to see if it works. If it does then the easiest way might be to delete all the old coupons in the database and set them up again. Quote Link to comment Share on other sites More sharing options...
bsmither Posted August 3, 2017 Share Posted August 3, 2017 Looking at the CubeCart_coupons database table, examine these columns: 'cart_order_id', 'code'. If the 'cart_order_id' is anything other than null, as if having nothing at all, a zero, or an actual cart order number, then CubeCart may consider this coupon as a Gift Certificate. The database table viewer should show null as either an italicized null, or highlighted in some way. If the cell is empty, then there is something other than null, such as a zero-length string. It could be the case that CubeCart must see something other than null to consider this coupon as a gift cert, and if an actual null, then it is a coupon. But I will have to double-check the code. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.