If you're experiencing problems trying out PlayerAuctions' Bulk Offer Upload, here's all the information you need to help you out and get you posting offers in no time at all.
Bulk Offer Upload for account
Data Field Requirements
The requirements for the Bulk Offer Upload file must be followed precisely, or it won’t be accepted by the system. This means that you’re unable to change the format, sheet name, column titles, or any other properties of the Bulk Offer Upload template.
Fields | Description |
Game/Server/Faction |
1. Refer to the Server List file for a list of all valid Game/Server/Faction values. All of these values must be written exactly as they are in the Server List file to count as valid. 2. If a game has no factions, then the Faction field must be NULL or remain blank. Otherwise, the Faction field must be filled in. |
Listing Price |
Required. |
Price Currency |
Required. The value must be USD. |
After-sale protection | Required. The value must be 0/7/14/30 Days. |
Offer Duration | Required. The value must be 3/7/14/30 Days. |
Cover image (PA hosted) |
Optional. Only internal URLs are supported. Here's how you can find the image URL: 1) If you have existing offers, go to the offer listing page, right click the cover image, and choose "Copy Image Address" in the browser menu. The URL should be in the following format: "https://image-cdn-p.azureedge.net/title-image/*****/202108050831503150.jpg" 2) If you want to use a new cover image go to the offer creation page and choose account. Click "Cover Image" and pick an image from your file explorer. Once the image is uploaded right click the cover image and choose "Copy Image Address" in the browser menu.
|
Title | Required. |
Description |
Required. HTML code If you're unfamiliar with coding but need to generate code from your text description for an offer, please follow these simple steps:
--> |
Delivery Method | Required. The value must be "Automatic" or "Manual". |
Login name (Auto) Password Character name Parental password Security question Security question answer First name Last name Phone with area code City Country Extra information |
The columns in green must be filled in if your delivery method is 'Automatic'. 'Parental password', 'Security question' and 'Security question answer' are sometimes required depending on the game. If this information is available, please include it. Extra information is optional. Other columns are required.
|
Login name Delivery Guarantee Delivery info |
The columns in yellow must be filled in if your delivery method is 'Manual'. 'Delivery Guarantee' is required and can be "20/2/24/48/an amount more than 48 hours". 'Delivery info' is optional. |
Maximum File Size
Any bulk offer upload file must meet the following file size requirements:
- Cannot contain more than 5,000 rows.
- Cannot be over 2MB in size.
If you need to bulk upload more offers, then please split them into separate files.
What type of files are accepted?
Only(xlsx, xlt) file types are supported.