COMC Bulk Price Editor Tutorial

Last month, we released an updated version of the much requested COMC Bulk Price Editor for our sellers to utilize. Please refer to our original blog post for download link and instructions. Please note that the Bulk Price Editor will only work on Windows Operating Systems.

This tutorial is intended to walk you through the experience of using the Editor for the first time. In this tutorial, we will show you a basic overview of how you can reprice a large segment of your items using this tool.

When you run the Bulk Price Editor, you will be prompted with the following Microsoft Access Security Notice:

Do not worry, this is to be expected! Simply press the Open button to launch the Bulk Price Editor. Once you do so, you will reach the Introduction page of the program. This page outlines all of the steps necessary to utilize the Bulk Price Editor. The <back> and <next> buttons found in the lower right portion of the red menu will be used to guide you through the six steps found on the left.

Click <Next> to continue to the Sign in page from the introductory screen. This will take you to the Sign in page:

Enter your COMC Username and Password on this page, and click the Sign In button to get started. Once you have done so, you will be prompted to download all of your account’s inventory into the Bulk Price Editor as seen below:

On average, this process takes about 10 seconds per 10,000 items in your account, but could take longer depending upon your internet connection speed among other factors. Once your inventory has been downloaded into the Bulk Price Editor, the spreadsheet below the menu will be populated with items from your account.

( Please note that although it is recommended that you download an updated version of your inventory every time that you launch the Bulk Price Editor, if you have not made any changes to your inventory since the last time you used the tool, you can use the data previously downloaded in an earlier session.)

Once you have downloaded your inventory into the Bulk Price Editor, you are now able to search your inventory in order to filter which items you would like to edit in bulk. The options for searching are as follows:

Storage Fee Status: Subject to Fee or Exempt from Fee
Currently For Sale: For Sale or Not For Sale
From Batch: Choose items a specific consignment batch number
Acquired less than ____ months ago
Acquired more than ___ months ago
Acquired Between Date Range
Suggested Retail Price Range
Asking Price Range

Additionally, on the right of these options is the ‘Modified Recently’ box with three radio button options. Items that have not been modified over the last 90 days are free to update using the Bulk Price Editor. Items that have been modified in the past 90 Days can also be modified, and those modifications are currently free as of this tutorial being posted. Please note that there may be a charge to edit items that have been recently modified in the future. 

Using these filters, you should be able to carve down your inventory to the exact parameters, of the items that you want to reprice. For this walk through, we’ve chosen all of the items within our account with an asking price of $0.01 to $1.00. This has reduced our matching items from the 9,414 total items in our account down to 3,193 items.

Clicking the <next> button on the right side of this screen will then take you to the Apply Price Changes page seen below. This page will give you several options to choose how you would like to reprice your items in bulk.

There are four bulk operations that you are able to customize to your liking. You can choose from the following options:

Percent Off Current Asking Price – This will reduce all specified items by a percentage that you determine. If you have an item with a current asking price of $10, and use this option to lower your prices by 20%, your new asking price will be $8.

Percent Off Suggested Retail Price – This will reduce all specified items by a percentage off SRP that you determine. If you have an item with an SRP of $25.00, and use this option to lower your prices by 50% off SRP, your new asking price on that item will be $12.50.

New Fixed Price: This will set a fixed price for all specified items. If you’ve filtered your inventory to 250 items, all items will receive the same fixed price using this option.

Clear New Price: This option will clear all of the asking prices for the specified items found on this page and reset your changes. Use this option if you are unsatisfied with the prices in the spreadsheet below once you have already used one of the other three update new prices buttons.

In the box to the right of these options, you will find price rounding options to make your listings more visually appealing to buyers. Additionally, you will find options to drop full dollar prices by $0.05, set a minimum item price, and a maximum percentage off as well. Choose your price rounding options, determine which of four bulk pricing operations you want to use, entered your percentage off or fixed price, and press the update new prices button that is next to the bulk operation that you’ve chosen.

For our walk through, we’ve chosen to to reprice all of our items to 20% off of our current asking price, with prices rounded to the nearest $0.05 , and a minimum asking price of $0.05 as well. Depending on the quantity of items that you are editing, the Bulk Price Editor will need a little time to prepare these price changes. Once this operation is complete, press the <next> button to preview your changes, as your specified changes have not yet been populated to COMC.

Hit ‘OK’ on the prompt letting you know that changes have been made in the spreadsheet below. The spreadsheet will now contain a preview of all of the pending changes that you have specified on the previous apply price changes page.

IMPORTANT: Please review these prices to make sure that the perimeters that you’ve specified are your desired changes, as COMC is not responsible for erroneous changes to your asking prices made by the Bulk Price Editor.

Once you’ve reviewed your pending changes, hit the <next> button to move forward to the submit price changes screen.

If you are satisfied with your changes, hit the ‘Submit Pending Price Changes’ button the began updating your specified prices in bulk. Please wait for this operation to finish before exiting the tool. Hitting cancel before the operation is finished will result in some of your items prices being changed, but not all of them.

Once all of your changes have been implemented, you will see this prompt. At this point, you can return to the download inventory step if you wish to continue making more pricing changes to your inventory.

We hope that this walk through helps you with a better understanding of what is possible using the Bulk Price Editor. This is a very powerful tool, and not all of the advanced options, such as setting multiple search perimeters for defining your inventory, have been covered in this walk through. We recommend that you spend some time experimenting with the tool to get accustom to all that is possible. If you have any questions, feel free to ask us in the comment section belong and we’ll be happy to answer them!

Commission Structure Changes – Cashing Out, Blowout Gift Card Rates, & Legacy Store Credit Update

Hello COMC Nation!

We hope that you had a fantastic Holiday Bonus Sale! Now that 2019 is here we want to tell you about some changes that have gone into effect today on COMC. Some of these changes were already covered in our previous announcement regarding changes coming in 2019.

Cashing Out COMC Credit for Paypal/Check:

Our 20% Cash-Out Fee has been replaced with a 10% Cash-Out Fee and a 5% Transaction Fee. The specific details of this change can be found in-depth in our earlier blog post.

Cashing Out COMC Credit for Blowout Cards Gift Cards:

Our rates for redeeming COMC Store Credit for a Blowout Cards Gift Cards have changed as well. Out with the old, and in with the new:

Legacy COMC Credit Explained

To qualify for cash outs under our new commission structure, COMC credit must either be earned after January 1st, 2019. Store credit earned prior to this date is considered Legacy COMC Credit. While this credit will spend the exact same as new COMC credit earned in 2019 and beyond, the key difference between Legacy COMC Credit and new COMC Credit earned after January 1st is that it Legacy COMC Credit cannot be cashed out until it has been converted to new COMC Credit via the Request Refund page.

When Legacy COMC Credit is converted to New COMC Credit, a 5% conversion fee is assessed, and the credit is now eligible to be cashed out under the new commission structure. Alternatively, if you have Legacy COMC Credit in your account, you can simply choose to wait until January 1st, 2020 when the concept of Legacy COMC Credit is retired, and any existing Legacy COMC Credit still in your account will be automatically converted to new credit without the 5% conversion fee.

Legacy COMC Credit only needs to be converted to New COMC Credit if you wish to cash out. Otherwise, it spends exactly the same as credit earned after January 1st on COMC. When you use COMC Credit to consign items, make offers, buy items, request a shipment, or pay for any other COMC services, we will use up your Legacy COMC Credit first. When you Cash-Out COMC Credit, we will use the new COMC Credit first.  We will always use the credit that is most advantageous for you.

Regardless of how you use your Legacy Store Credit, you will ultimately be better off than before with our previous 20% cash-out fee. If you wish to maximize your cash out earnings, the best option would be to wait until January 1st, 2020, when all COMC credit, regardless of when it was earned, is eligible for the new commission structure. Waiting until this date to cash out Legacy COMC Credit will allow you to circumvent the 5% conversion fee, putting that savings directly into your pocket.

If you still have questions, our Customer Service Team is here to help! Simply send an email to staff@comc.com and our team will get back with you shortly. Happy New Year and here’s looking forward to a great year of collecting!

Sale Promotions and Port Sale Update

We hope that your Holiday Bonus Sale is off to a good start! As we talked about last month in our major announcement, we wanted to take this opportunity to tell you more in detail about the changes coming to Sale Promotions and Port Sales starting on January 1st, 2019.

Sale Promotions

On December 31st, we’ll be retiring the current Sale Promotions structure of $3 per day with a 3% transaction fee based on the sale price of an item at the time of sale.

On January 1st, COMC Sellers will be able to set up their sales under our new Sale Promotions structure, which has a $1 per 10,000 items insertion fee and a Promotional Transaction Fee of 1% of your original Asking Price, assessed at the time of sale. You can run a Sale Promotion for 1-11 days and pay only one insertion fee.

When you set up your sale, you can choose not only your Base Sale Discount (not editable once the sale is live), but also set custom percentage off rules for individual items in your inventory as well.

Sale Promotions are a great way to have your item stand out from others on the COMC Marketplace. Items on sale are seen by prospective buyers in green text with a sales tag icon. In addition, your sale is featured on the On Sale page and on the main COMC homepage.

Port Sales

Starting on January 1st, we’ll be reducing the cost of Port Sales from $10 to $5 per week, or until the port is sold. Port sales are a great way to sell a lot of inventory at once to one potential buyer.

Thank you for your consideration, and as always, if you have any questions, our Customer Service Team is here to help! Simply send an email to staff@comc.com and our team will get back with you shortly! Happy New Year!

COMC Bulk Price Editor Available for Download

The much requested COMC Bulk Price Editor is now available for our sellers to utilize! You can download it from here:

https://www.comc.com/BulkPriceEditor/BulkPriceEditor.accde

You will need Microsoft Access 2010 or later to run it. If you don’t have Microsoft Access, you can get the free Microsoft Office 365 Access Runtime. You must use the 32-bit version.

You will see a message like this the first time you open the Bulk Price Editor.

Click open on this prompt.

After opening it, there will be a new shortcut on your desktop.

For a full walk through tutorial on how to use the COMC Bulk Price Editor, please click here. 

COMC Sellers! Huge Announcement!

Thank you for helping COMC grow from being a garage startup to making a tangible impact on the trading card industry.  COMC currently ships more single trading cards than any other company on the planet, and we could not have done this without such amazing support from all our sellers, buyers, employees, vendors, and partners.  I am incredibly proud of what we have built together and feel very fortunate to be on this journey with you.

Today we are making one of our biggest announcements ever, and we don’t take this lightly.  In fact, we have been pondering and refining these changes for nearly 5 years.

If you haven’t already watched the video above, I recommend doing so before reading the rest of this post.

What enabled COMC’s success? 

Several factors have made COMC’s service so popular, but one of the most significant factors is our Buy Now – Ship Later model. This is a key reason why we are considered the best website for set builders and player collectors.

While most sites have tried offering faster and faster shipping to attract more business, this strategy has resulted in average order sizes of less than 2 cards per package.

At COMC, we have invested in a model where you can sell cards to earn COMC Credit, or you can buy more credit, and then you use that credit to make offers, instantly purchase items, and eventually request a shipment. This Buy Now – Ship Later model has resulted in an average of 40 cards per package, saving COMC members millions of dollars on shipping, and allowing COMC to dominate the low-end portion of the trading card market.

Why change? 

Many sellers have expressed they would like to use our service for more of their mid-range and high-end items in addition to all their low-end ones.  The greatest cost when selling low-end items is shipping, but as you progress to more mid-range and high-end items, commission fees gradually surpass shipping costs, and eventually commission fees become the most significant costs.

A fee structure that can support both low-end and high-end items will be a huge win for our sellers and our buyers.

What is the goal? 

We want to welcome more mid-range and high-end items onto the COMC platform while also preserving our superiority with low-end items.

What is changing? 

We are reducing the overall commissions we collect by making the following changes.

  1. Our 20% Cash-Out Fee is being replaced with a 10% Cash-Out Fee and 5% Transaction Fee.
  2. Our 20% eBay/Amazon seller’s commission is being replaced with a much smaller buyer’s premium.
  3. A small Enhanced Security Fee will be assessed to items listed for $50 or more.

Cash-Out Fee Details

On January 1st, 2019 we will reduce our Cash-Out Fee to only 10%.  This will be available for all COMC Credit that was charged the 5% Transaction Fee.  With any Legacy COMC Credit you earned before the 5% Transaction Fee, you will have these choices.

  1. Spend it on cards and services
  2. Convert some or all Legacy COMC Credit to new COMC Credit by paying a 5% Conversion Fee
  3. Wait until January 1st, 2020 when we retire the concept of Legacy COMC Credit and give 10% cash-outs to any COMC Credit

No matter which option you choose, you will be better off than you are with today’s 20% cash-out.  That said, the best option is still to simply use the Legacy COMC Credit on COMC and avoid the cash-out and conversion fees all together.  When you use COMC Credit to consign items, make offers, buy items, request a shipment, or pay for any other COMC services, we will use up your Legacy COMC Credit first.  When you Cash-Out COMC Credit, we will use the new COMC Credit first.  We will always use the credit that is most advantageous for you.

Here are some example Cash-Out scenarios.

December 31st, 2018  January 1st, 2020 
$1,000 COMC Credit $1,000 COMC Credit
– $200 20% Cash-Out Fee – $100 10% Cash-Out Fee
$800 PayPal Deposit $900 PayPal Deposit
January 1st, 2019  July 1st, 2019 
$0 New COMC Credit $600 New COMC Credit
+ $1,000 Legacy COMC Credit + $400 Legacy COMC Credit
– $50 5% Conversion Fee – $20 5% Conversion Fee
$950 New COMC Credit $980 New COMC Credit
– $95 10% Cash-Out Fee – $98 10% Cash-Out Fee
$855 PayPal Deposit $882 PayPal Deposit

We will also reduce the cost of Blowout Cards gift certificates.  These details will be provided in a follow up blog post.

Transaction Fee Details 

Starting January 1st, 2019, we will charge a 5% transaction fee on all transactions that transfer store credit in exchange for items. This fee will be collected at the time of sale and is very similar to the 3% promotion fee charged when you run a standard sale promotion today.   Consequently, we will also reduce promotion fees so it is easier for you to run promotions and drive sales.  More details on the new promotion fees will be provided in a blog post coming soon.

Traditional Order vs Buy Now – Ship Later 

We classify all eBay, Amazon, and COMC Shopping Cart purchases as Traditional Orders.  These orders require immediate shipment as part of the payment contract.  We will make several changes to streamline these Traditional Order scenarios, which are really intended for the causal buyer that just wants to quickly add a few items to their cart and check out.  For example, we have offered “free shipping” on more expensive eBay listings by embedding the cost of shipping in the eBay price.  Also, eBay and Amazon require all orders to be mailed out within 1 business day.  So, we will simplify our shipping options and standardize across eBay, Amazon, and the COMC Shopping Cart, making it seamless for casual customers to very quickly purchase a few items.

In contrast, our COMC Credit scenario enables the Buy Now – Ship Later functionality.  This is designed for more serious collectors who frequently do both buying and selling.  With COMC Credit, the buying process is clearly differentiated from the shipping process, and shipping is optional.  It is very common for people to buy items and then resell them without ever taking physical possession of the items.  It is also common for people to buy items one day and not request a shipment for weeks, months, or even years, so we will continue to offer our low-cost, slower shipping options when placing shipment requests with COMC Credit.

Improved eBay & Amazon Selling Experience (Traditional Order Premium) 

Over the past several years, we have required sellers to factor the 20% eBay/Amazon commission into their asking prices, making it more difficult for sellers to set competitive asking prices for mid-range and high-end items when opted in to sell on eBay and Amazon.  We will replace this seller’s commission with a much smaller buyer’s premium that we refer to as the Traditional Order Premium.

The Traditional Order Premium will be 10% + $5 for items with an asking price of $100+ COMC Credit and 15% for items with an asking price of less than $100 COMC Credit.  As a seller, you will no longer need to inflate your prices to cover the old 20% eBay/Amazon commission.  Instead, you will only need to factor in the 5% Transaction Fee and optional 10% Cash-Out Fee.  If you plan to buy other items with the COMC Credit you earn from selling, you can ignore the 10% Cash-Out Fee altogether.

Starting immediately after Cyber Monday, prices on COMC will reflect the Traditional Order Premium when you are not signed in.  Guest visitors to COMC can only use the COMC Shopping Cart to make purchases, and they will always be subject to the Traditional Order Premium.  As a COMC member, you will see the COMC Credit prices after signing in, and you will not be subject to the Traditional Order Premium when you use COMC Credit to make your purchases.

During December we will begin transitioning eBay and Amazon listings to reflect the Traditional Order Premium.  In the meantime, items will be listed on eBay and Amazon either because the seller opted in to covering the 20% commission or because we reflected the Traditional Order Premium in the listing’s price.  Until we update a listing, any sales form that listing will still be subject to the 20% eBay/Amazon commission.  Once a listing reflects the Traditional Order Premium, you will receive your full asking price when it sells.  After January 1st, 2019, your sales will also be subject to the 5% transaction fee.

Once all the eBay and Amazon listings have been updated, you will no longer need to opt in to selling on eBay and Amazon, and all items for sale on COMC will automatically be eligible for sale on eBay and Amazon.

Revenue from the Traditional Order Premium

The majority of the revenue we receive from the Traditional Order Premium will go towards covering eBay & Amazon fees, extra support costs and increased return rates from these platforms, PayPal and credit card fees, advertising to drive more traffic to COMC, and eventually, affiliate and referral programs (hint-hint), as well as the software development costs to build and maintain these systems. It is not easy being one of the largest sellers on both eBay and Amazon. We frequently push them to their limits.

Enhanced Security Fee Details 

We anticipate receiving a lot more high-end items as the result of these changes, and our $0.01/month Storage Fee does not sufficiently cover the expenses we incur when properly securing your $1,000 items.

On January 1st, 2019, we will introduce an Enhanced Security Fee for items with an asking price of $50 or more.  Low-end items will not be affected by this new fee.  The fee will be $0.01 per $1,000 of total asking price per day. This amounts to about $0.03 per month for a $100 item or $0.30 per month for a $1,000 item.

The fee will accrue daily but will only be charged monthly.  The first Enhanced Security Fee will be assessed on February 1st, 2019 and will be based on asking prices throughout the month of January.

This fee encourages more competitive asking prices for high-end items and should help clear out some of the inflated prices on COMC today.

We will add a filter to the Inventory Manager that makes it easy for you to find items that are subject to the Enhanced Security Fee so you can easily make price changes to minimize this fee.

Net Effect of Commission Changes 

When an eBay buyer spends $1,000 on one of your items, you will net 20% more cash.

COMC on eBay Today  COMC on eBay After Changes 
  • $1,000.00 List Price
  • $800.00 after 20% eBay Commission
  • $640.00 after 20% Cash-Out Fee
  • $1,000.00 Traditional Order Price
  • $904.54 COMC Credit Price
  • $859.31 After 5% Transaction Fee
  • $773.37 After 10% Cash-Out Fee

$773.37 is 20.8% more than $640.00.

If you want $1,000 cash in your pocket for an item that sells on eBay, you will be able to do that with 17% lower prices on eBay.

COMC on eBay Today  COMC on eBay After Changes
  • $1,562.50 List Price
  • $1,250.00 after 20% eBay Commission
  • $1,000.00 after 20% Cash-Out Fee
  • $1,291.56 Traditional Order Price
  • $1,169.60 COMC Credit Price
  • $1,111.12 After 5% Transaction Fee
  • $1,000.00 After 10% Cash-Out Fee

$1,291.56 is 17.3% less than $1,562.50.

Bulk Price Editor 

As a seller, you may want to make widespread changes to your asking prices to reflect the new fee structure.  We will release an updated version of the Bulk Price Editor to make that process easier for you.  Keep an eye out for a future blog post with more details.

Frequently Asked Questions 

If you have a question about these fee changes, please leave a comment, and we will update this post to answer as many questions as we can.

 

Thank you for joining us on this journey.  We strive to continually improve your collecting experience, and this is just one step of many to come.  Stay tuned for many feature announcements over the next few months and throughout 2019.

Tim Getsch
COMC Founder & CEO