First of all, a Canon Powershot A620 camera. I recommend this for several reasons.
You can set it to "auto" and it will handle most situations with out a lot of thought or effort on your part. It still has settings for close-ups of small objects. Point-and-shoot, but with the ability to do more complicated things without a lot of work on your part.
This has the vari-angle LCD viewfinder so that you can take a photo of yourself wearing a hat/poncho/sweater you want to sell and see if you're really in the frame. If you want to do this, you'll need a tripod, or other means of holding the camera in place. Actually, a small tripod would be a help for close-up photography of small objects, too.
You may also want a slave flash for more complicate lighting set-ups. Don't worry about a lot of technical stuff. You can add a slave almost anywhere if you have it pointed at your subject and improve the lighting of your photo. You may have to set the camera to underexpose slightly to get a good exposure. Experimentation with your particular camera will work best.
And, if you want to take your camera with you to just take photos for you, you'll need a bag to carry it in. I found a nice, small, light one in tan, and also in navy. I was also lucky enough to find the ultimate bag for the knitter. It's a backpack with easily accessible space in the bottom for your camera gear, and a large open space for your current knitting project, a book to read, etc. And, as if that weren't enough, it has a special compartment for a laptop computer. Check my store for more bags.
If you plan to take photos of very small things at home, you could use two small, gooseneck lamps for lighting, positioned on either side of the object. A nice, unobtrusive background would be good, too. Check out your local thrift store or Chez Tarjay for a plain dish towel or other small piece of fabric in some nice colors for backgrounds.
And don't forget, you can leave a comment with a question on all this, and I'll do what I can to help. But you may not have any problems. This equipment will make your photographing life SOOOO much easier.