Professional Excel Templates
With simple spreadsheet commands, you can customize the look of your report. For example, if the column for Buyer Country is unnecessary for your records (you ship only within the United States, so the information is not useful), you can delete the column. You can perform all spreadsheet tasks men-1101 ) tioned here in similar fashion in either Microsoft Works or Excel. To total a spreadsheet column The spreadsheet generated by Selling Manager is much more useful if you total up the columns. That way, you can see your total sales at a glance.
A spreadsheet such as Excel or Lotus 1-2-3 can help you account for your transactions. What you should know is that you often use the database capabilities of the spreadsheet program rather than the calculation capabilities. Why not use a database manager instead I don't recommend the use of a spreadsheet unless you are a spreadsheet expert and don't know or don't want to know how to use a database manager. eBay attempted to devise a spreadsheet solution to the bulk upload situation (Master Lister) and finally backed off Spreadsheets are great for calculations but not so adroit for accounting systems.
In the zeal to acquire and purchase merchandise, it's easy (and tempting) to throw all of the receipts and other documentation into a file folder or shoebox and deal with it when the need arises (usually April 14). Though this method might serve casual eBay sellers, as your eBay business volume increases, you will need a more systematic approach to documenting your purchases. The best time to do that is close to the time of purchase, when your memory is fresh and any paper trails are still close at hand. Whether your system is a notebook with lined columns, an Excel spreadsheet, or accounting or auction-management software, you have to dedicate the time to log the captured data.
Ensure you download data from online auction-management programs to your local system for archiving before the information is removed from the service and you can no longer access it. Most programs allow you to download the data in a format that can be read by spreadsheet programs, such as Microsoft Excel and Intuit QuickBooks accounting programs.
Item and inventory management If you want to keep your inventory online, you can create it on their system. If you want to input your inventory offline, you can import it from their Excel template. You can also import open auctions or store listings to your ChannelAdvisor account for relisting or servicing. Item and inventory management Includes calendar- and time-based (dates and times for launching) auction scheduling, automated auction launching and relisting, the ability to import past or current auctions, and the ability to import auction data from a spreadsheet or database.
If you're in business and need to keep records of your shipping (dates, weights, and confirmation numbers), this method may be the way to go. The Post Office site, although free, prints out a label only once. If you want keep records, you'll have to enter the information separately into a spreadsheet or a text file.
If you have a lot of products, you won't want to enter them all by hand. Rather, import them into the system en masse. It's much quicker to enter data into a spreadsheet or database program and import the information than it is to enter it into Catalog Manager one by one. (If you want to do this later, skip this section, continue building your store, and return here later.) Open the file in a spreadsheet program and you can see it a little more clearly. You can see that the first row contains headings and the second row contains product data.
How, then, do you create an import file Virtually all spreadsheet and database programs have a way to export to the .csv format. You could, in theory, create the file in a text editor, but you probably shouldn't it's easy to make mistakes. The easiest program to use is a spreadsheet program, such as Microsoft Excel, but merchants with large product catalogs may already have their products in a database. If you exported a .csv file from Catalog Manager and have Excel installed on your system, you'll probably find the file automatically opens in that program. note Understanding how to use a spreadsheet and a word processor's search-and-replace function can make your data manipulation easy. For instance, let's say you want to use the same information in the Name field and in the ID field so your .html pages have words from the product name in the filename Merchant Solutions uses the ID as the product page's filename. First, sort your data in the spreadsheet alphabetically by the Name...
Keeping track of your winners isn't rocket science. You can track buyer information in an Excel spreadsheet or a Word document, both of which are PayPal allows you to download your sales data into a format compatible with QuickBooks, a highly respected and popular bookkeeping program. You can also choose to download your data in Excel spreadsheet format (the downloads also work in Microsoft Works). PayPal reports are full of detailed information about your sales and deposits. Putting this information in a standard accounting software program on a regular basis makes your year-end calculations easier to bear. (In Chapter 16, we detail what else you may need for this task.)
PayPal allows you to download your sales data into a format compatible with QuickBooks, a highly respected and popular bookkeeping program. You can also choose to download your data to an Excel spreadsheet. PayPal reports are chock-full of intensely detailed information about your sales and deposits. Putting this information in a standard accounting software program on a regular basis makes your year-end calculations easier to bear. (In Chapter 16, I detail what else you might need for this task.)
At least twice a week, people e-mail me looking for a special item, and I try to help them find what they need. Start wanted lists. A wanted list is just the item the person is looking for (like Noritake Princess Gravy Boat) and the person's name and e-mail. Keep track on a computer spreadsheet or database. You just never know what you may come across, and customers appreciate that extra touch. You can also send out an e-mail every so often to these people saying, Just wanted to let you know that
Desktop applications form the basis of most of the work that people do with computers today. Yes, many people use browsers to search for data, make purchases, and perform other tasks, but many common tasks such as word processing and manipulating databases remain on the desktop. That's why having a special desktop application to work with eBay can be very appealing. The application reduces the user's learning curve by presenting a familiar interface. A company can customize the appearance of the eBay data to reflect its method of working with eBay. In many cases, it's also easier to integrate the data produced by a desktop application with other applications in use at a particular location. For example, you could send data directly from the custom application to a database or spreadsheet for further manipulation.
This chapter has demonstrated how you can use VBA to write programs that use eBay Web Services. It's essential to remember that the techniques in this chapter work with any application that supports VBA, not just Microsoft Office. The capabilities of the application also affect how you interact with eBay Web Services. Yes, you can force a spreadsheet to act as a
The remaining three items in this spreadsheet let you work with items on eBay without ever leaving the Excel environment. The pages are listed in the order that you'd normally use them, starting with the Inventory page show in Figure 7.4. As you can see, this page contains a list of items to sell on eBay. You can add, remove, or modify items as needed.
Your eBay sales reports include important information about your transactions and download in a spreadsheet format. Here is the information you can expect to find in the reports you download It's best to generate monthly or quarterly reports, so that your reports coincide with specific tax periods. You can always combine more than one report in your spreadsheet program to show different periods of time. Your file may take a minute or two to prepare and download. During this process, you'll be asked if you want to save, open, or cancel the download. Choose Save to save it to your hard drive. The file is downloaded in a format that can be opened in either Microsoft Excel or Microsoft Works spreadsheet programs. Now you can open the new file in your spreadsheet program, and it will look very similar to Figure 26-5.
Timing The best time to use this strategy is when you have a catalog to follow up with prospects or you have an
Capture the name, address telephone number and email address of every single winning bidder on your auctions. Put them in a database or set up an Excel spreadsheet to keep track of them. Once in a while send them a coupon for 5 off the next auction they win. It works for me. People would come back to my auctions and bid on other things I have listed rather than throw out 5 bucks. Or send them a flyer with your 'specials'- you get the idea. (Remember your goal is to build long-term relationships through COMMITMENT to your customers. If you have something you think they would really like, tell them about it The spreadsheet below shows you how many listings you have to put on eBay each month and each day in order to meet your goal of a six-figure income You can see from the spreadsheet that for me to make my six-figure income goal, with this as my only working eBay strategy, I would have to list 32 to 64 items per day at an average low-minimum bid of around 67. My assumptions for both...
Visual Studio Tools for Microsoft Office basically allows you to use the Visual Studio .NET interface to create code that gets called from Microsoft Office documents. You can use the same code and familiar interface as you do with Visual Studio .NET, and you can also run those procedures from a particular document or spreadsheet. This means that you can call a Web API using SOAP or HTTP with nearly the same code as described in the earlier chapters.
Ledger systems wouldn't work for a company with a warehouse full of stock, but will work nicely in a beginning eBay sales environment. Many sellers tape sheets of paper to their boxes to identify them by number, and use that as a reference to a simple Excel spreadsheet for selling purposes. Excel spreadsheets are perfect for keeping track of your sales as well, but if you're using a management service or software, you don't need both for physical inventory. After you're running a real business, however, you have to keep Uncle Sam happy with a dollars and cents accounting of your inventory, so keep your inventory records in a standardized program such as QuickBooks (discussed in Chapter 16). In Chapter 9, I detail a variety of auction management software and Web sites, many of which include physical inventory tracking features. You may also want to use Excel spreadsheets for your downloaded PayPal statements, to hold information waiting to transfer to your bookkeeping program, or...
Let's put aside for the moment the situation in which you provide codes for option combinations. In general, you simply enter the text that would normally be entered into the Options text box in Catalog Manager, into the options field in your spreadsheet or database. Place line breaks between them, just as you would when typing into Catalog Manager.
Most of these inventory systems wouldn't work for a company with a warehouse full of stock but will work nicely in an eBay sales environment. Many sellers tape sheets of paper to their boxes to identify them by number, and use that as a reference to a simple Excel spreadsheet for selling purposes. Excel spreadsheets are perfect for keeping track of your auctions as well, but if you're using a management service or software, you don't need both for physical inventory. After you're running a full-time business, however, you have to keep the tax inspectors happy with pounds and pence accounting of your inventory, so keep your inventory records in a standardised program such as QuickBooks (discussed in Chapter 16). In Chapter 8, we detail a variety of auction management software and Web sites, many of which include physical inventory tracking features. You may also want to use Excel spreadsheets for your downloaded PayPal statements, to hold information waiting to transfer to your...
Spreadsheets and bookkeeping Many sellers keep their information in a simple spreadsheet program such as Excel. The program has all the functionality you need to handle inventory management and sales info. For bookkeeping, I like QuickBooks, which is as complete as it gets. It's straightforward and professional, and it no longer requires that you have a basic knowledge of accounting. It also integrates with spreadsheets. In Chapter 16, I discuss QuickBooks in some detail.
I Item and inventory management If you want to keep your inventory online, you can create it on their system. If you want to input your inventory offline, you can import it from their Excel template. You can also import open auctions or store listings to your ChannelAdvisor account for relisting or servicing.
Doing this once or twice isn't going to tell you much. Doing it routinely will build a large database of useful data for marketing analysis. If your auction management service does this, great If not, you need to keep the results in a spreadsheet or database application. Remember, the prime message of this book is that databases are ever valuable to doing business. This is another instance where a database can help you make intelligent marketing decisions.
Most vendors design PDAs as electronic versions of the calendar, address book, and personal note taker. Early versions of these products didn't include the mini-word processors and spreadsheets you'll find in modern versions. In fact, you can extend many PDAs to double as cameras, scanners, and other devices now with special add-ons. Other mobile devices, such as cellular telephones, have followed suit, but to a lesser degree.
Official Download Page Vertex42 The Excel Nexus
Vertex42 The Excel Nexus will be instantly available for you to download right after your purchase. No shipping fees, no delays, no waiting to get started.