I just think people write out of obligation too often.

"How do I motivate myself to write through the boring part of my story?"

"How do I make this boring scene not boring?"

Don't write it.

Don't write boring things just because you think the structure of the story demands it. I promise it doesn't need to be there.

If your characters need to have gone shopping for a later part of the story to make sense you can just have a sentence about how they went shopping and move on.

You are not obligated to write the boring parts. No matter what those parts are.

You are not obligated to make the parts of your story that you're not excited to write interesting somehow.

You can just write the fun and interesting parts and gloss over and summarize boring things.

Your audience will thank you and you will thank yourself.

my writing life got so much better once I realized that if Tolkien himself was allowed to have his viewpoint character knocked unconscious so he could skip writing a battle scene, I could, too.