Stock listing details
Each stock listing page can show a table with up to 8 columns and 400 rows. Here's how to do it:
- Create an Excel format spreadsheet using Microsoft Office, or any other spreadsheet which can save files in the Excel XLS format.
- In the top row put the titles for your columns. For example, you might want to include the Description, Condition and Price for your items.
- Enter the details for your items, and save the spreadsheet. Then, choose the Stock List page layout, and upload the spreadsheet to CollectFair in just the same way as putting a picture on your page.
- To update your stock, edit the Excel file on your computer, and upload the revised version.
PayPal Buy Now buttons
- Each line of your stock list can have a Buy Now button. For these to work you must have stored your PayPal email address with CollectFair - more information.
- To create the buttons you need to add columns with special top line entries to your Stock List spreadsheet. The headings are:
- The column headed 'PayPal Price' will be where the Buy Now buttons appear in the stock list on your stall. The other special columns will not appear in the publicly visible stock list.
- The 'PayPal Description' column is optional. It can be used for a stock number or unique name (up to 60 characters) so that you can tell which item has sold when you get an email from PayPal. If you do not use this column, the first column of the stock list will be used automatically as the item's description.
Example of a spreadsheet which will generate Buy Now buttons.
Stock listing - extra hints & tips
- Keep descriptions brief to ensure the stock list is easy to read.
- You can include written descriptions of each item, but not a picture. Border and font choices in the spreadsheet have no effect on the appearance of the stock list.
- Organising your stock list
Leave a blank row to separate different sections in your stock.
The formatted stock list will appear on the web as shown above
Excel version information
Stock lists have been tested using Microsoft Office 97, 2000, XP and 2003 on Windows, and Office X on Mac.
If you are having trouble getting the system to recognise your Excel file, please contact us.