Wonder Lister won’t connect to database after upgrading to Windows 10

Many users have reported that after they upgraded to Windows 10, Wonder Lister will get stuck at connecting to database step on startup.

The reason we have found is that Microsoft SQL Server service startup mode gets reset from Automatic to Manual and therefore it does not start automatically. So, we need to check and correct the startup mode back to Automatic. To do this:

Go to:

Control panel : Administrative tools : Services

Scroll down the list until you see: SQL server (wonderlister)

Double click it.

Change startup type to AUTOMATIC as well as start it.

Then run WL.

How to generate slightly different titles on Bulk Duplicate?

First, you need to enable this functionality by setting a preference. To do that, go to main menu option:

Tools -> Options -> Preferences

ManagePreferences_ListingPolicies

 

If not already checked, check the box corresponding to “Append a short random string to Title on Duplicate”, as shown in the screenshot above.

If you had to check the box, ensure you Save your changes.

Close the Manage Preferences window.

Now, that the feature has been enabled, when you duplicate any listing / listing template, (you can select multiple), the title of the original listing will be appended a short random string in the duplicated listings.

How does Wonder Lister help in preventing over selling?

Use case:

There are a lot of sellers who sell on multiple eBay sites and/or have multiple eBay User IDs. Now, imagine a case where you have say one quantity of an item, but you wish to list it on multiple eBay sites, say, US, UK as well as Australia. In addition, on each site, you actually want one fixed price listing and another as an auction. So, across all three sites in two different formats will result in a total of six listings. BUT you only have one quantity. So, when any listing is SOLD, you MUST ensure that you END all other five remaining listings IMMEDIATELY, otherwise, you stand the risk of over selling.

Wonder Lister Solution:

In Wonder Lister, you can set a preference (a simple checkbox!) that essentially says that when a listing with a given SKU ends, automatically END all other Active Listings with the same SKU. And that’s pretty much it.

Based on the above, as you can see, the ONLY requirement is that all listings share a common SKU which they should in the first place as they all represent the same physical item.

How does Auto List feature work in Wonder Lister?

Concept behind Auto List feature

Auto List allows you to setup a recurring schedule for automatically listing you item.

Any listing whose duration is NOT GTC, can be set to Auto List.

Auto List works based on the schedule time (or start time) of the listing it is set on and its duration in days.

Every listing created by the execution of Auto List has the EXACT Schedule time you start off with on the original listing.

Example

Listing L1 schedule time was 10:00 AM on 28th March, 2016 for a duration of 3 days

Current system time: 14:00 on 4th April, 2016 when Auto List was turned ON

As a result of Auto List being turned ON, a new Wonder Lister Scheduled Listing L2 is created whose scheduled time would be set to 10:00 AM on 6th April, 2016 (Minimum date/time which is more than the current system time of 14:00 on 4th April, 2016). The scheduled time of L2 is arrived by simply continuing to add 3 days to 10:00 AM 28th March until current system time is exceeded. L2 itself will have its Auto List turned ON to start with.

Now, when, the system time becomes, 10:00 AM on 6th of April, 2016, then, L2 is submitted to eBay. If successful, then, since L2 also has its own Auto List On, it results in creation of a new Wonder Lister scheduled listing L3 with scheduled time set to 10:00 AM 9th April, 2016. L3 also has its own Auto List turned ON by default.

The process continues ad infinitum until the Auto List is turned OFF on the absolute last scheduled listing.

How to turn ON Auto List for a single listing

In Manage Listings, in the Listings Grid, locate the listing you are interested in. You can also do a search by a host of fields to locate the right listing. Once the listing is displayed in the Grid, click it to select it. Click F2 to start editing the selected listing. Under the AutoList column, click the checkbox. If there are any additional changes you wish to make, do them as well. Finally, press the ENTER key. You will be prompted to Save or Discard your changes. Click on Save.

How to turn ON Auto List for Multiple Listings

In Manage Listings, in the Listings Grid, select all those listings you wish to set Auto List ON. Click on the button ‘Bulk Change‘. A new window titled Bulk Change would open up. Maximize it if needed. At the absolute last, you would see ‘Auto List?‘ field. Click on the first check box. This indicates you are interested in editing Auto List field. The second checkbox will then get enabled. Check/Uncheck the second checkbox to ON/OFF Auto List. Click on the button ‘Submit revisions‘ to apply the changes to your selected fields.

How to turn ON Auto List using CSV file

Name of the column in the CSV file is:

Auto List

The Value can be true/false or 1/0

The CSV file used to Create NEW listings as well as editing existing listings support this column

 

Bulk editing of UPC, EAN or other product identifiers to ‘Does Not Apply’

With the recent announcement from eBay, eBay now requires that each listing has product identifier. Those listings that genuinely do not have say a valid UPC, then, the UPC must be set to ‘Does Not Apply’.

So, essentially, there is a need to change almost every listing for UPC (or other product identifier). The procedure described here is the same for other product Identifiers.

To Bulk apply UPC equal to ‘Does Not Apply’ to a bunch of listings, follow these steps:

(1)  In the Manage Listings, select all the listings you wish to change

(2) Click on the button ‘Apply CIS’ just above the Listings Grid

(3) From the new window that opens up, enter the name and value for the item specific you wish to change. So, in this specific case, enter the name as UPC and the value as ‘Does Not Apply’. Click on Save button.

(4) You will see the item specific we just created in the Grid below.

(5) Select that UPC from the Grid and click on Apply button. This will apply the selected item specific (UPC) with the value you entered (Does Not Apply) to all the listings you selected.

 

 

How to retrieve year end reports from Wonder Lister for Income Tax Use

To produce sales reports for any period, use the main menu option:

Reports -> Sales Reports

On the screen that displays, enter the starting date and the ending date for the sales report and then click the button labelled ‘Show Report’

After some time, the sales report data will be displayed in a Grid format.

After the Sales Report has been displayed in the Grid (under the three different Tabs), Right-Click anywhere inside the Grid, you would see several options including the options to Export in various formats. For printing (or just to save raw data in electronic format like a CSV file), Export the data as CSV format. That CSV then can be opened, edited easily in EXCEL and can also be printed.

Please see screen shot attached.

ExportSalesReport

What is the meaning of different price columns in the Listing Grid within Wonder Lister?

On eBay, a listing is primarily, either an "Auction" or a "Fixed Price" listing. In Wonder Lister, since the Listing Grid can be displaying both "Auction" format and "Fixed Price" format listings, thus, there are different price columns.

The table below summarizes the meaning of each price column.

Price field Applies to Auction? Applies to Fixed Price?
Start Price Yes Yes and is same as Fixed Price
Current Price Yes No
BIN Price (also called Buy It Now price) Yes No
Reserve Price Yes No
Fixed Price No Yes and is same as Start Price

 

Processing of background tasks when Wonder Lister is running in a networked environment

Background tasks are important to keep the data within Wonder Lister database up to date. Besides fetching periodic updates from eBay, background tasks also submit listings scheduled within Wonder Lister.

Wonder Lister is designed such that no configuration is needed to be done by a user as to which workstation should process the background tasks. The first workstation that starts Wonder Lister automatically becomes the “master” computer as far as processing of background tasks is concerned. If for any reason, the “master” workstation goes down, then, one of the remaining workstations will assume the role of the “master”. No user intervention is needed for this to work.

However, there may be times when you need to “Pause” this background processing for a while. You can “Pause” (and “Continue”) using the main menu option:

Tools -> Options -> Manage status of background tasks

“Pausing” all the background tasks should be done only when absolutely needed because not just the synchronization of data with eBay is impacted but also any pending Wonder Lister scheduled listings won’t be processed.

 

How does eBay Duplicate Listing Policy impacts you

eBay’s Duplicate Listings Policy states

“The duplicate listings policy is designed to help you list in a way that makes it easy for buyers to find and compare items that interest them.

You can’t have more than one fixed price listing of an identical item at the same time. 

You can have more than one auction-style listing for identical items. However, only one duplicate auction-style listing without bids appears on eBay at a time. Separate listings may be created for the same item on different eBay sites, as long as the international shipping options don’t result in the listings cluttering the search results of any individual site.”

For full article, please see eBay’s Duplicate Listings Policy

At the same time, long time eBay sellers have reported duplicate listings getting created automatically due to eBay’s system glitches. Please see:

http://community.ebay.com/t5/Archive-Policies-User-Agreement/Duplicate-listings/td-p/2970018

http://www.ecommercebytes.com/C/letters/blog.pl?/pl/2011/7/1311259939.html

and there are many other such posts on eBay seller discussion forums.

So, how does Wonder Lister helps you?

In Wonder Lister, there is a system folder called “Potential Duplicates” which displays those active listings that APPEARS to be duplicate. You can look at each such listing to confirm if they really are duplicate and take appropriate action (may be End potentially duplicated listings). This would go a long way in ensuring that your account does not get suspended by eBay.