For the early-to-mid-game however, its not so simple. If you have the master key you can get there by going down to new londo ruins and taking a right up through a gate and across the bridge in valley of the drakes.

My advice is to stick it out through blighttown or go through the back door. It is advised to max out item discovery not only for the higher chance to get a drop but also since it's possible to get multiple items from the same corpse, being this one of the best ways to farm for hard souls that the player can turn in whenever they want. All soul farming methods can be improved by equipping the Covetous Silver Serpent Ring (10 at+1 to 35 at +3 - found before starting NG+ if you have The Ringed City DLC), the Shield of Want (20), the Mendicant's Staff (20), and the Symbol of Avarice (50), which - when all pieces are equipped - will increase the total number of souls gained. To this end, soul farming is recommended late-game, allowing you to simply purchase the items you need. The Crystal Sages Rapier is a unique weapon transposed from the Soul of the Crystal Sage, which can be gained early in the game. Actually the best place to farm souls is behind the door the crest of artorias opens. Most souls(consumable item) can be farmed by killing Locusts in the swamp by The Ringed City, the amount and quality of the souls obtained will vary depending on which game cycle the player is at.(I.E: they'll start dropping Soul of a Champion in NG+ and beyond as a drop from their corpses).

Dark souls 3 soul farming early game