If an auction has more than 1000 items it is recommended that you split the file into two auctions for performance reasons
- Install the following tool from http://www.scaled-solutions.com/blog/open-source-csv-file-splitter
- Within this Page click Grab your copy of my CSV Chunker file splitter now. and run the executable from the zip file.
The split files will move to your download folder into a folder called Split.
Note: You need to ensure that you have these two lines at the top of each excel file you split
Item Type | Lot Number | Title | Summary | Description | Category | Vendor | End Date | End Time | Buyers Premium | Sales Tax | Currency | Display Price | Buy Now | Make Offer | Purchase Price | Opening Bid | Bid Increment | Reserve Price | Contact Seller | Address Line 1 | Address Line 2 | City | County | Postcode | Country | Latitude | Longitude |
Leave empty for Lots or else specify: Listing (or Lot if you do want to specify it) | Leave empty for automatic numbering | The Category ID | The Vendor ID | Start with a single quote and use YYYY-MM-DD format. For example '2012-12-31 (Leave blank to use the Auction close date) | Start with a single quote and use HH:MM format. For example '15:30 (Leave blank to use the Auction close time) | (Leave blank to use the Auction value) | (Leave blank to use the Auction value) | The Currency ID (Leave blank to use the Auction value) | (Lots only) | Either Y or N | Either Y or N | Either the Buy Now price or for Make Offer; optionally, the Minimum Acceptable Offer | (Lots only) | (Lots only) | (Lots only) | Either Y or N | (Leave all Location fields blank to use the Auction Location) | (City and Country are required if not using the Auction Location) | (City and Country are required if not using the Auction Location) |