This has been resolved. Thank you all!
@t-p Yes, I followed the instructions on hostgator’s website. Thanks!
@contentiskey Thank you for the advice. I have reached out to hostgator’s support, hopefully they’ll be able to find out what is going on. Thanks!
I was able to find out what I was doing wrong. I was not entering the data in the “adjustments” section and thus making the table “manual” entry only.