Start Searching...
 Introduction
 Installation
    Server Requirements
    Installation Steps
    Database Setup
    Software Activation
    Zip Code Search 
    Enable Translation
    Upgrade from v6.0
 Administration Guide
    Site Preferences
       Setup
       General
       Company Information
       Display
       Listing Options
       Shipping Options
       Stores
       Email Templates
       IP Blocking
       Bid Increments
    Billing and Fees
       General
       Credit Cards
       Payment Services
       Checks
       Fee Amounts (Sellers)
       Fee Amounts (Buyers)
       Classified Fees
       Membership Plans
       Discount Setings
    Maintenance
       Processing
       Send Invoices
    International
       General
       Supported Currencies
       Translation
    Users
       User List
          User Information
          Transactions
          Feedback
          View Items
          Bids
       New Account
       Email Users
       Custom User Fields
    Items
       Item List
       Item Approvals
       Custom Item Fields
       Import Items
    Categories
       Category List
       Custom Field Category Groups
    Regions
       Region List
    CMS
       Content
       Banners
    Reports
       Recent Activity
       Statistics
       Tops Sellers
       Account Fee Balances
       Listing Fees Revenue
       Sales Transactions
    Data Management
       Restore Defaults
       Clear Data
       Reset Database
 User Guide
    Introduction
    My Account
       Summary
       Bidding
       Listings
       Invoice Purchases
       Invoice Sales
       Trading
       Feedback
       Account
 Payment Processing
    Authorize.NET
    PayPal Standard Payments
    PayPal PayFlow Pro
    LinkPoint / YourPay
    CyberSource
    SECPay
 License Agreement



Go back to the previous page Move forward one page

Home > Administration Guide > Items > Import Items

Import Items


Administrative users can bulk import items in a CSV format.  A blank .csv template can be downloaded from the administration control panel. 

To upload listings:
  1. Download blank CSV file from the administration control panel if needed
  2. Insert values into CSV file
  3. Zip the CSV file and all images together
  4. From the admin control panel, select the "Browse" button to select the .zip file
  5. Click Upload to upload all new listings

To verify your information without creating listings, select the checkbox "Validate Data Only (no items will be posted)".  This will check all of the data contained in the .zip file for accuracy.

The CSV Template includes the following values:

1 Seller text value username of the seller, required
2 Category integer value category #, required
3 ListingFormat text value auction, revauc, dutch, revdutch, rfq, trade, fixedprice, or classified
4 Title text value max 60 characters, required
5 Description text value required
6 ItemLocation text value enter either the region names or the region #s, beginning with Tier 1, separated by horizontal bars (|) (e.g. "US|VT|Essex Junction" or "1|45|123")
7 Quantity integer value default value of 1 if omitted
8 PreferredCurrency 3-character text currency code "USD", "AUD", "GBP", etc; default "USD" if omitted
9 Price decimal value required for fixed price, optional for rfq and classified listing formats
10 StartBid decimal value required for auction listing formats
11 Reserve decimal value only applicable to auction listing formats
12 BuyItNowPrice decimal value only applicable to auction listing formats
13 PaymentProcess text value invoice, checkout or immediate payment
14 PaymentInstr text value
15 PayPalEmail text value
16 CCsAccepted 0 or 1 1 = Yes, 0 or blank = No; applies to auction, dutch or fixedprice listing formats where the seller is an admin user.
17 BuyersPremiumPct decimal value blank or 0.00 - 100.00; applies to auction, dutch or fixedprice listing formats
18 IsTaxable 0 or 1 1 = Yes, 0 or blank = No; applies to auction, dutch or fixedprice listing formats
19 TaxPercent decimal value blank or 0.00 - 100.00; applies to auction, dutch or fixedprice listing formats
20 ShippingOpts text value
Flat Rate Shipping option(s) format:

 <SERVICE CODE1>:<COST1>:<EXTRA COST1>[|<SERVICE CODE2>:<COST2>:<EXTRA COST2>[|<SERVICE CODEn>:<COSTn>:<EXTRA COSTn>]]

For example, if the available shipping options for this listing are:
  • UPS Ground ($5.00 + $2.50 per additional item)
  • FEDEX Priority Overnight ($15 per item)
Enter:

  UPSGND:5.00:2.50|FDXPO:15.00:15.00

Valid Flat Rate Shipping Codes:
  • CODE
    Service Name
     admin_defined1 Free Shipping
     admin_defined2 USPS First Class
     admin_defined3 Freight
     admin_defined4 Pick-Up
Valid Flat Rate -or- Calculated Shipping Codes:

 CODE  Service Name
UPSNDAUPS Next Day Air
UPSNDEUPS Next Day Early AM
UPSNDASUPS Next Day Saturday Delivery
UPSNDSUPS Next Day Saver
UPS2DEUPS 2 Day Air AM (comm. destinations only)
UPS2NDUPS 2nd Day Air
UPS3DSUPS 3 Day Select
UPSGNDUPS Ground
UPSCANUPS Canada Standard
UPSWEXUPS Worldwide Express
UPSWSVUPS Worldwide Saver
UPSWEPUPS Worldwide Expedited
FDX2DFEDEX 2 Day
FDXESFEDEX Express Saver
FDXFOFEDEX First Overnight
FDXPOFEDEX Priority Overnight
FDXPOSFEDEX Priority Overnight Saturday Delivery
FDXSOFEDEX Standard Overnight
FDXGNDFEDEX Ground
FDXHDFEDEX Home Delivery
FDXIGNDFEDEX International Ground
FDXIEFEDEX International Economy
FDXIFFEDEX International First
FDXIPFEDEX International Priority
USPFCUSPS First-Class Mail
USPEXPUSPS Express Mail
USPBPMUSPS Bound/Printed
USPLIBUSPS Library
USPMMUSPS Media Mail
USPPMUSPS Priority Mail
USPPPUSPS Parcel Post
USPFCIUSPS First Class International
USPPMIUSPS Priority Mail International
USPEMIUSPS Express Mail International
USPGXGUSPS Global Express Guaranteed



    
21 UseShippingCalculator 0 or 1 1 = Yes, 0 or blank = No
22 ShippingOriginCountryCode text value only applicable when UseShippingCalculator = 1; 2-character country code
(Note: AuctionInc currently only supports US)
23 ShippingOriginPostalCode text value only applicable when UseShippingCalculator = 1; zip code from where the shipment will be sent
24 ShippingOriginStateCode text value only applicable when UseShippingCalculator = 1; 2-character state code
25 ShippingWeight numeric value only applicable (and required) when UseShippingCalculator = 1
26 ShippingWeightUnit LBS, OZ or KG only applicable when UseShippingCalculator = 1; LBS = pounds; OZ = ounces; KG = kilograms
27 ShippingLength numeric value only applicable when UseShippingCalculator = 1
28 ShippingWidth numeric value only applicable when UseShippingCalculator = 1
29 ShippingHeight numeric value only applicable when UseShippingCalculator = 1
30 ShippingDimUnit IN or CM only applicable when UseShippingCalculator = 1
31 IsCombinable 0 or 1 only applicable when UseShippingCalculator = 1; 1 = Yes, 0 or blank = No
32 StartDate date value
33 EndDate date value required if duration is omitted
34 Duration integer value number of days ; required if end date is omitted
35 ReList integer value optional number of times to auto-relist an unsuccessful item
36 HomePageFeatured 1 or 0 1 = On, 0 = Off
37 CategoryFeatured 1 or 0 1 = On, 0 = Off
38 HighlightListing 1 or 0 1 = On, 0 = Off
39 BoldListing 1 or 0 1 = On, 0 = Off
40 GalleryListing 1 or 0 1 = On, 0 = Off
41 HitCounterStyle 0, 1 or 2
42 image_1 text value filename of an image included in the uploaded zip file
43 image_2 text value filename of an image included in the uploaded zip file
44 image_3 text value filename of an image included in the uploaded zip file
45 image_4 text value filename of an image included in the uploaded zip file
46 image_5 text value filename of an image included in the uploaded zip file
47 image_6 text value filename of an image included in the uploaded zip file
48 cf_Type text value Property Type
Valid values:
  • -
  • Commercial
  • Land
  • Manufactured Homes
  • Other
  • Residential
  • Timeshares

See also

    
Prints the content you see below