There are 34 Sorceries in the game:
26 that can be bought from NPCs
4 that are found in static locations
3 that are made by transposing boss souls with
Ludleth of Courland in Firelink Shrine
1 that is a covenant reward (Great Deep Soul from Aldritch Faithful)
This achievement can be earned in your first playthrough or across multiple playthroughs. There are missable Sorceries tied to
Orbeck of Vinheim and
Anri of Astora, so be careful with their progression.
Relevant NPC and Scroll information can be found at the end of the solution.
This image shows every Sorcery in the order they are stored in inventory:
Soul ArrowSold by Orbeck of Vinheim.
Great Soul ArrowSold by Orbeck of Vinheim.
Heavy Soul ArrowSold by Orbeck of Vinheim.
Great Heavy Soul ArrowSold by Orbeck of Vinheim.
Farron DartSold by Orbeck of Vinheim.
Great Farron DartSold by Orbeck of Vinheim after returning the Sage's Scroll.
Farron HailSold by Orbeck of Vinheim after returning the Sage's Scroll.
Homing SoulmassSold by Orbeck of Vinheim after returning Logan's Scroll.
Homing Crystal SoulmassSold by Orbeck of Vinheim after returning the Crystal Scroll.
Crystal HailTrade with Ludleth of Courland for the Soul of Crystal Sage.
Soul SpearSold by Orbeck of Vinheim after returning Logan's Scroll.
Crystal Soul SpearSold by Orbeck of Vinheim after returning the Crystal Scroll.
White Dragon BreathTrade with Ludleth of Courland for the Soul of Consumed Oceiros.
Soul StreamBehind a fairly obvious illusory wall on the second or third level of the Grand Archives.
Soul GreatswordSold by Orbeck of Vinheim.
Farron FlashswordSold by Orbeck of Vinheim.
Magic WeaponSold by Orbeck of Vinheim.
Great Magic WeaponFound on a corpse just past a large crystal enemy near the Farron Keep Perimeter bonfire.
Crystal Magic WeaponSold by Orbeck of Vinheim after returning the Crystal Scroll.
Magic ShieldSold by Orbeck of Vinheim.
Great Magic ShieldObtained by killing a specific enemy in a cell in Ithiryll Dungeon. From the bonfire, head out to the large area, drop down to the lower level and open the door to the cell essentially below the bonfire hallway. The enemy is in this cell.
SpookSold by Orbeck of Vinheim.
Aural DecoySold by Orbeck of Vinheim.
Pestilent MercurySold by Orbeck of Vinheim after returning the Sage's Scroll.
Cast lightSold by Orbeck of Vinheim the Golden Scroll.
RepairSold by Orbeck of Vinheim after returning the Golden Scroll.
Hidden WeaponSold by Orbeck of Vinheim after returning the Golden Scroll.
Hidden BodySold by Orbeck of Vinheim after returning the Golden Scroll.
ChameleonThis spell is obtained from a pilgrim in one of two places, both of which require progressing Anri's questline:
1) When you meet Anri near the Church of Yorshka bonfire, this pilgrim is disguised (via Chameleon) as one of the human statues in the corner and
can be killed to obtain the spell. This ruins progress towards the Usurpation ending and achievement, though.
2) In the Darkmoon Temple behind an illusory wall right before Anor Londo. You must have progressed Anri's questline towards the Usurpation ending for the pilgrim to be there, and it will be dead with the spell available after interacting with Anri:
Twisted Wall of LightSold by Orbeck of Vinheim after returning the Golden Scroll.
Deep SoulTrade with Ludleth of Courland for the Soul of Deacons of the Deep.
Great Deep SoulRewarded for reaching rank 1 in the Aldritch Faithful covenant. This requires 10 Human Dregs, which are awarded for successful Aldritch Faithful covenant kills and are also rare drops from the mages located in the large area between the Pontiff Sulyvahn bonfire and Anor Londo.
AffinitySold by Karla.
Dark EdgeSold by Karla.
_______________________________________________________
Relevant NPCsSeveral NPCs sell Sorceries but only Orbeck and Karla are necessary as they sell all 26 that can be purchased.
Orbeck of VinheimLocated in Crucifixion Woods near the Crystal Sage bonfire on the second level of a building. Talk to him with 10 or more INT and he will relocate to Firelink Shrine.
Note that Orbeck will leave Firelink for good if you move past areas where scrolls can be found without immediately returning them to him. Be careful.
KarlaLocked in a cell on the lower level of the Irithyll Dungeon. The key is found in the Profaned Capital at the end of a hallway in a building beyond the toxic swamp. Exhaust her dialogue and she will relocate to Firelink Shrine.
_______________________________________________________
ScrollsScrolls must be returned to Orbeck in order to fully unlock his inventory.
Sage's ScrollFrom the Keep Ruins bonfire, proceed down the ramp, turn left, and follow the wall around to an area with dead mushroom enemies. The scroll is on a corpse nearby.
Golden ScrollFound in Farron Keep in a cave near the area with many cursed basilisk enemies. Proceed to the right from the Farron Keep bonfire and you'll find it.
Logan's ScrollDropped by a sorcerer enemy in the Profaned Capital on the roof of the building across the toxic swamp.
Crystal ScrollObtained upon killing the Crystal Sage in the Grand Archives.