Your original statement is better as “ Let us know the date when the goods will be ready for shipment.” or “... ready to be shipped.”
But it’s important to note that “ready for shipment” doesn’t mean they will be shipped then, only that they are ready. The “shipping date” is the date the goods are shipped.