There wasn’t much sugar in the pot.
The English sentence could refer to a cooking pot (i.e. an olla), for example if one were to be adding sugar as a sweetener to cooked fruit such as cherries or apples.
However, the English sentence is probably more likely to refer to a sugar pot, otherwise called a sugar bowl or sugar basin.
In that case I believe the appropriate word would be azucarero.