I wanted to take a minute to point out how good of a tool Microsoft Access can be for an amazon seller. I myself buy a lot of my inventory on eBay which means most of the record keeping doubles. This is how it works:

1. I bid on tons of auctions at prices that leave me a margin on the other side (selling on amazon)
2. I receive the items, test them, and place them for sale on amazon
3. I receive orders through amazon
4. I package the item with a copy of the packaging slip
5. I buy postage through amazon (which is handled through stamps.com)
6. I toss the packages in my mailbox or drive to the post office if my mailbox won’t suffice
7. I pray that the seller is happy and the sale is over

When it comes to record keeping though. As soon as I buy an item off eBay I go to my access database where I have a form for entry.  I feel out the first “column” under “purchase”.

entryform

After receiving the item, I go back to that entry and fill out the middle column. If the item checks out, I list the item on amazon.

When the item sells, I fill out the last column. You get the idea.

But Access is so much more powerful than just this set of functionality.

I have inventory floating around all of the item. Item’s inbound can be hard to keep track of, and when I receive one – how can I match it up with the inventory I have marked down as purchased? With Queries.

Filed under: Uncategorized

Like this post? Subscribe to my RSS feed and get loads more!