I've been trying to add a couple of farmable items that in my opinion should be farmable in the pots but for some reason, i can't get the soil to work.
MissingBotanyCrops.zip

It looks like you're using an outdated reference for the soil. The soil should look like this.

Always check the game log for issues related to your datapack files first.