Need advice on staying consistent with discipline

I'm terrible at follow through. I'll set a consequence and then not actually enforce it because I feel bad or I'm tired. My 9yo has figured this out and now does whatever because he knows I'll cave. My wife is actually the consistent one which makes me look bad. How do you guys stay firm when your kid is upset with you or crying? I know it matters but it's hard.