Bulk Lister

Bulk Lister

Video Overview

Click Here for a Video Tutorial Overview of the Bulk Lister.


Getting Started

The Bulk Lister allows you to list and manage your items in bulk, using a CSV file. In general, you can list multiple items much quicker using the Bulk Lister compared to using the standard Sell Your Item process. The Bulk Lister is also a great option if you would like to import, manage, or even keep your inventory in sync with an external database, spreadsheet or website. For more details on these advanced options, see the Bulk Lister - Advanced Usage page.



  1. Select a template from the Bulk Lister page.
    From the Bulk Lister page, select a template to download based upon your needs. In general, we recommend that you start with the Auctions (Basic) template for auctions, and Store Items (Basic) template for store items. If you need to add additional fields which are not included in the (Basic) templates, you can easily do so as explained below.

  2. Open the template on your computer.
    To open the template which you download (which is a CSV file), you'll need a spreadsheet program such as Microsoft Excel. If you do not have Microsoft Excel, we recommend the free WPS Office .

  3. Fill in the template.
    For each listing you want to create, fill in one row within the spreadsheet, where the values you enter correspond to appropriate values for each header (see Fields below).

  4. Save the template.
    Save the template within your spreadsheet program, ensuring that it is saved as a CSV file (and not a Microsoft Excel .xlsx, etc. file)

  5. Upload any applicable images to the Bulk Lister > Image Manager.
    If your images are hosted on your own computer, upload them to the Bulk Lister > Image Manager (see Images below).

  6. Upload the template.
    Upload the template to the Bulk Lister, by clicking on the green "Select File" button, leaving the "Field Mapping Template" set to "Default", waiting for your file to finish uploading, and then clicking on the blue "Submit" button.

  7. Confirm and Submit.
    Once you upload your file, you will be presented with the option to map different fields to our own, and set advanced options. If you're using a Basic template, simply proceed to the bottom of this page and click on the blue "Submit" button.

  8. Review your newly created listings.
    Once you submit your file, we'll process it within the next few minutes. Once it's processed we'll send you an email, along with a report to review - which can also be access from the Members Area > Selling > Seller Tools > Reports page. The Bulk Lister Report will show you, line by line, if we successfully created a new listing, and if not, you'll see an error message as to why a new listing could not be created.

Fields

Each field you enter within your spreadsheet will correspond to a specific header. It's important to note that not all fields are "free text", in that certain fields only accept specific values. For example, the "category_id" field can only accept numeric ids as specified within the Bulk Lister > Categories page. Before filling out any information within your spreadsheet, please review the Bulk Lister > Fields page in more detail, to become familiar with each field, and what values are accepted therein:


Basic Fields

The Basic Fields which are included in the Basic templates are as follows:

Field
 Description
name
 This is the title of your listing.
category_id
 This is the numeric category id which corresponds to your listing. Only valid numeric category ids as specified on the Bulk Lister > Categories page can be entered.
description
 This is the description of your listing.
image
 This is either a URL to your image (if hosted online) or the file name of your image (if hosted on your own computer - see Images below).
start_price or buyout_price
 The Starting Price (auctions) or Buy It Now Price (store items) of your listing.
private_id (optional)
 The Private ID of your listing. While optional, we recommend that all listings include a Private ID (or SKU). Note that when using a Private ID, it must be unique across all of your open listings. Including a Private ID will help you to manage your inventory, and allow you to easily Bulk Update your listings in the future.

Images

If your images are hosted on your own computer, you can easily include them within your Bulk Lister CSV file, by following these steps:

  1. Include the File Name in each row of your Bulk Lister CSV file.
    Within the "image" column, simply enter the name of each of your images (file extension is optional, but recommended). For example, if your image is named item100.jpg include "item100.jpg" within the appropriate row in your Bulk Lister CSV file. Note that the full file path of your image should not be included (ie: do not enter C:\Users\Test\item100.jpg)
  2. Upload your images to the image manager.
    Before     uploading your Bulk Lister CSV file into the Bulk Lister, proceed to the Bulk Lister > Image Manager page, and upload all of your images. Follow the on-screen instructions on the Bulk Lister > Image Manager page to upload your image.

Note: To include multiple images, place two pipe characters directly between the name of each within your field value, ie: image1.jpg || image2.jpg

Note: If you are using an external Image URL, the same external Image URL can not be reused for different images. If you need to provide a new image, you will need to provide a new Image URL. This is because once we download a copy of an image from an external Image URL, we can not re-download a new image.

Categories

As noted within the Fields section, certain fields only accept specific values, including the category_id field. You can review the list of acceptable numeric category id numbers from the Bulk Lister > Category page:


HipComic: https://www.hipcomic.com/members/tools/bulk-lister/?filter=categories

HipStamp: https://www.hipstamp.com/members/tools/bulk-lister/?filter=categories

HipPostcard: https://www.hippostcard.com/members/tools/bulk-lister/?filter=categories


Magic Categories

One of the best ways to speed up the bulk listing process is by using Magic Categories, which allow you to enter a single specific numeric category id number for all of your listings, which is then replaced by the correct category for you magically! The following Magic Categories are currently available:

Site
 Magic Name
 Category ID
 Notes
HipStamp
 Stamps
 0
 The Magic Category: Stamps will place each of your listings in the appropriate stamp category on HipStamp, based upon the Country included within your listing's title. If your listing does not include a Country do not use this magic category.
HipPostcard
 Postcards
 0
 The Magic Category: Postcards will place each of your listings in the appropriate location based postcard category on HipPostcard, based upon the Country, State and/or City information included within your listing's title. If your listing does not include a Country, State and/or City do not use this magic category.
HipPostcard
 Postcards by Topic
 2056
 The Magic Category: Postcards by Topic will place each of your listings in the appropriate postcard category under the Topics (Themes) main category on HipPostcard, based upon the information included within your listing's title.


Default Listing Settings

For any fields which are not included within your (Basic) Bulk Lister CSV file, such as shipping costs, your Default Listing Settings will be used. As such, please review the settings you currently have set within the Members Area > Selling > Seller Tools > Default Listing Settings page.


Shipping Costs

If you need to set different shipping costs for one or more of the items within your Bulk Lister CSV file (different than your Default Listing Settings), please see the Bulk Lister - Shipping Costs page for additional instructions.


Item Specifics

If you would like to provide value for Item Specifics, such as "Main Character", "Stamp Condition", etc., or to review which Item Specifics will be automatically filled in when omitted through the power of Magic Item Specifics, please see the Bulk Lister - Item Specifics page for additional instructions.


    • Related Articles

    • Bulk Lister - Advanced Usage

      All Fields (Expert) Bulk Lister Template All fields in which you can set while creating an item individually through the Sell Your Item process can also be set through the Bulk Lister. In general, we recommend that you start with one of the (Basic) ...

    • Bulk Lister - Shipping Costs

      Shipping Costs Overview From the Members Area > Selling > Seller Tools > Postage Setup page, you define what your Locations/Regions are. For example, the default Locations/Regions will be "Domestic", which will be set to your own country, and ...

    • Bulk Lister - Item Specifics

      Item Specifics If you would like to provide value for Item Specifics, such as "Main Character", "Stamp Condition", etc., you can do so by adding the appropriate Item Specifics fields to your Bulk Lister CSV file. Review the Bulk Lister > Fields page: ...

    • How to Bulk Edit (Update) Existing Listings

      From the Members Area > Selling > Seller Tools > Default Listing Settings page, you can set up the default settings to use when you create new listings. However, these settings will only affect new listings you create, and will not affect your ...