eBay Good Till Cancelled (GTC) listings have a new feature called OutOfStockControl. If you have a GTC listing and you are all sold out eBay ends and removes your items and you lose the sales records for that item. The only option you have is to re-list the item and lose it’s sales history. The sales history is often helpful in obtaining more sales (as buyers see that others are buying that item so they feel more safe doing so).
Sales history also helps in your search results ranking.
It took me alot of time to research on how to add this to the listing so I thought about writing instructions so others can get help from it.

  • Open My eBay by going to http://www.eBay.com, logging in, and clicking the “My eBay” link at the top right corner.
  • You need to add eBay File Exchange to your eBay system. If you already have File Exchange you can skip these sub-steps.
  • Go to http://pages.ebay.com/sellerinformation/sellingresources/fileexchange.html
  • Click the link that says “Sign Up Now”
  • Go back to My eBay
  • Go to File Exchange Tool
  • Click “Create Download Request”
  • Under Listings and records choose “Active”
  • Set the Download Format to “Standard”
  • Set “Date Range” to “All active listings”
  • Enter your email address
  • Click save
  • Wait for an email from ebay. When you get the email continue to the next step. Depending on how many listings you have this could take some time to complete.
  • When you receive the email, click the link which will download the .csv file.
  • Open the .csv file in Microsoft Excel.
  •  First, you need to rename the column “Item ID” to “ItemID” (no space)
  • Select the entire column by clicking the “A”, and change the column format to “Number”.
  • Move the decimal place over two spaces so the ItemIDs are whole without a decimal.
  • Create a new column before ItemID and name it “Action”
  • Under the Action Column, set all the cells to “Revise”
  • Now delete all columns other than “ItemID”, “Action”
  • Now create a column and name it “OutOfStockControl” No Spaces!!
  • Set the value to “TRUE” for any listing you want to have this feature
  • Now save the file.
  • Go back to eBay File Exchange, click “Upload Files”. Enter your email and select the file you just saved.

If you are running Hyper-V Failover Cluster and managing it using SCVMM you would have noticed that when you create a new VM in SCVMM, the VM name in the Failover Cluster Manager shows as “SCVMM VMNAME Resources”.

Also, if you rename a VM in SCVMM or Hyper-V Manager it does not get updated in Failover Cluster Manager and vice versa.  This creates issues if you have alot of VMs to manage and then if you need to rename a VM.

To resolve this issue, I wrote a small script using Powershell. This script can be run in two modes:

  1. Compare the VM names in Failover Cluster and SCVMM and list the VMs with mismatching names.
  2. Rename the VMs in Failover Cluster to match the SCVMM names.

There are three variables that you need to check/change before running the script:

  1. $VMMServer: This is your VMM Server FQDN
  2. $Cluster: This is your Failover Cluster FQDN
  3. $Mode: If you set it to “1” it will list the VMs with mismatch names, if you set it to “2” it will rename the VMs

If this script works for you and solves your issue, please leave a comment.

Download the script below

When I upgraded my Macbook to Mavericks, I started having problems with my VPN. Network Connect client started failing to launch or install. I went online and started searching for a solution. I found the solution to allow Network Connect to launch or install. I was able to connect to my VPN but then I faced another issue. After a few minutes Network Connect seemed to stop routing traffic on VPN tunnel. I search online and found out there are people having this issue but found no solution to it. I started researching the cause and finally was able to create a solution myself that I would like to share with you all.

So, actually there are two issues with Network Connect and Mavericks.

Issue No. 1:

Network Connect fails to launch or install.


This solution available on forums etc.  What you need to do is go to Safari menu, then Security / Manage Website settings then go down to Java plugin. Select the URL of your VPN and set it to run in Unsafe mode / Always allow.

Issue No. 2:

Network Connect stops forwarding traffic to the VPN Tunnel after a few minutes.


What I found out was that the OSX was losing ARP entry for the gateway after a few minutes and therefore stopped forwarding any traffic. I went ahead and wrote a small script myself. What this script does is that it saves the current ARP entry for the gateway in a variable and then refreshes the ARP tables with this entry every second. So even if OSX loses the ARP entry for the gateway, this scripts puts it back and the traffic keeps on flowing. I have tested this script on a few Macbooks and it works fine. Juniper says they will be releasing a new version of Network Connect that will fix this issue, until then this script is a good workaround.

What you need to do is that before starting up your VPN connection do the following:

  • Open Terminal Window
  • Type “sudo su -“, then enter your user password when you see the password prompt
  • run “./arprefresh.sh”
  • Leave the Terminal Window open and start your VPN
  • DO NOT CLOSE TERMINAL WINDOW, leave it running while you work on the VPN

If this script works for you and solves your issue, please leave a comment.

Download the script below