Importing Listings
In order to allow merchants to upload and manage a large number of listings, Adult
DVD Marketplace supports the importing of a tab-delimited text file that can be
created in any spreadsheet application, such as Excel.
Creating the spreadsheet
To create this file, a spreadsheet must be created with the following columns:
Column 1: This column must contain the Adult DVD Marketplace ID for the DVD
being loaded. This ID can be found manually by visiting the info page for that
DVD (where it is labeled as the SKU), or through an automated process described
below.
Column 2: This column must contain the condition of the DVD. This can be either:
New, Like New, Very Good, Good, or Acceptable. For more info on these conditions, please review our
condition guidelines.
Column 3: This column contains any comments that you want to be displayed beside
your listing describing either the DVD itself, or giving information about yourself.
Column 4: This column contains the price of the DVD (without a dollar sign).
Column 5: This column contains a count of how many copies of the DVD you have
available. For used items this will normally be set to 1. If you don’t
want us to track inventory for you, but instead want the listing to always be
displayed, you can set the count to a value of -1. In this case you will be
responsible for manually canceling the listing if you run out of inventory.
Column 6 (Optional): This column can contain an internal ID that will be stored with the listing
and will be printed on the notification e-mail that is sent to you following a sale. This is for your
own internal use only, and is optional.
Columns 7+ (Optional): If you want to store additional info related to this DVD in the spreadsheet
for your own personal use you can use columns 6 and higher. This info will be
ignored when the file is imported.
Sample Excel Spreadsheet:
Creating the import file
In order to create an import file from this spreadsheet, you must save or export
the spreadsheet to a tab-delimited text file. In Excel, select "Text (tab-delimited)"
from the "Save As Type" selector on the dialog for saving the file.
Loading the import file
Once you have saved the spreadsheet as a tab-delimited text file, you are ready
to import the file into Adult DVD Marketplace. The process is:
- Select "Import/Export Listings" from the "User Account"
menu
- Select "Browse" to choose the file to be uploaded, or type the
filename directly into the text field.
- If you are uploading a file that contains all your listings, select the
"Drop all listings before import" option. This will delete all
your existing listings and replace them with those in your new file. If the
option is not selected then the listings in your file will be added to those
that have already been listed.
- Finally, click the "Import listings" button to load the listings
from your file.
Exporting your listings
If you want to create an import file from a set of listings that you have loaded
manually, or if you want to create a new import file based on your current listings,
you can do so by selecting the "Export your listings" option from
the import page.
You can edit this file in Excel by importing the tab-delimited text file. This
is done by selecting "Import External Data" from the "Data"
menu.
Looking up DVD IDs
If you want to find the IDs for a large number of titles, rather than looking
them up by viewing each DVD’s info page, you can use our automated matching
tool. To use this feature you should create a text file containing the titles
of the DVDs you wish to import, with one title per line.
Once you’ve created your file, select the file in the "Get DVD IDs"
section of the import page and click the "Get IDs" button.
Our search will find the ID for any DVD with exactly one title matching the
exact spelling of the title you provided. Results will vary depending on the
complexity and uniqueness of the title. If an ID is not located, then that title
is most likely stored under a slightly different spelling. In this case, you
should use the title search tool to locate that title.
Exporting Your Sales
If you wish to export your sales in a tab-delimited format, you can access the following export URL,
passing in your username and password in the appropriate fields:
http://www.adultdvdmarketplace.com/xcart/adult_dvd/export_sales.php?login=XXX&password=XXX
With no additional parameters, your sales for the current day will be returned. However, you may use
the following optional parameters for more control over the output:
| startorderid | Returns all your sales with an order ID GREATER than the ID passed in. |
| or | |
| startdate | Returns all your sales on the dates GREATER THAN OR EQUAL to the date passed in (format: yyyy-mm-dd). |
| |
| header | Pass in a value of "yes" to include a header row with the output describing
the contents of each column. |
| format | Pass in a value of "xml" to output your sales as in XML format rather than as a CSV file. |
Exporting listings via RSS
Your listings on Adult DVD Marketplace can easily be integrated into a third party site by exporting
your listings in an RSS format.
To export your listings as an RSS feed, use the following URL:
http://www.adultdvdmarketplace.com/xcart/adult_dvd/export_listings_xml.php?seller_login=XXX
By default all your active listings will be returned (up to a limit of 500 listings), sorted in the order
in which the listings were added to the site. Use the following optional parameters to customize the data in the feed:
| limit=straight | Returns only your listings for straight titles |
| limit=gay | Returns only your listings for gay titles |
| limit=featured | Returns only your listings for your own featured titles |
| limit=featured_straight | Returns only your listings for your own featured straight titles |
| limit=featured_gay | Returns only your listings for your own featured gay titles |
| |
| sort=time | Sorts in order of time the listing was entered (Default) |
| sort=title | Sorts alphabetically by title |
| sort=studio | Sorts alphabetically by studio then by title |
| 
