eBay’s SellerSphere Featured Seller BamfordTrading Out-takes Video

John & Gill from BamfordTrading passed on solid advice in their recent article that was featured by eBay SellerSphere in January, you can see the article and the three videos they included in the full article here.

However… Those polished videos were not without a few slips and with John & Gills permission here are the out-takes.

Your Feedback

I’m also working on persuading John add more video content, you can do me a huge favour by subscribing to BamFordTrading’s YouTube channel.

Let us know what you think of the video in the comments box below :)

A Question For You!

Well it’s about time really! It’s why I have been quite quiet here for past week or so. I’m about 9,000 words in and half way through the table of contents I first wrote a few weeks back. Yep that’s right I’m writing a book, well two actually.

No one section of the first book is complete enough to share properly and I’ve not hammered down what I am going to call the book, but to give you a synopsis of what the is intended to be:

Help optimise multi channel businesses by sharing advice and guidance, that takes no more than 10 minutes per day.

It’s why I added an out of place article earlier last week around Google Calendar and major part to this book is going to be your ability to set up reminds to just spend 10 minutes working on your business and for me to show you exactly where you should be spending those 10 minutes each day to really maximise what you’re up to.

A Question For You

I’ve got a lot of unanswered questions currently, most are to do with how deep do I push certain subjects, which I’m sure I’ll find an answer to as I work on them more over the next few weeks.

However…. As helpful as I feel such a book would be to you, what I am considering is moulding the written book to a video diary that you can follow.

For example on day three I may take you through registering social accounts to protect your business trading names, having this in a written format might be suitable for some, but a video sessions of a few minutes with me explain why and then taking you off to go and register the top 5 or so accounts.

So that question…

Would you find the combination of a well written book that guides you through tasks that are designed to take no more than 10 minutes each day with a video series that also literally talks you through each stage, help you to commit to making the actions needed? Or would the book alone be enough?

I’m trying to gauge what would be most effective for you, to take the critical step into taking action for a couple of mornings a week over a cuppa?

Let me know in the comments box below.

LastDropofInk Mobile Site Launched

LastDropofInk Mobile Site

Well, it’s about time I re-launched the mobile version, after all 10-20% of the traffic here during the weekdays can come from mobile devices.

Yesterday I altered one of the standard themes, wrote a customised mobile site and after testing on numerous devices, it’s been launched.

It’s been set up so that if you’re on a mobile decide (other than an iPad) that you’ll be redirected to the heavily cut down version which includes the basic functionality.

  • Home link
  • Search
  • Finger-friendly links
  • Image optimisation
  • A method to get back to the main site if desired

Being a speed freak, I’ve also ripped out (blocked) the really large overhead files as well, so that instead of the total page weight being around 183Kb, that it comes in at a tenth of this at 18Kb. You can test mobile sites here http://ready.mobi/results.jsp?uri=http%3A%2F%2Flastdropofink.co.uk&locale=en_EN

I’d like to also pass on an excellent tip I found to block the extra styles and JavaScript files in WordPress from here. My example is below and blocks the tubepress extension from loading css and js files in the header on the mobile site, by blocking them in the functions.php file.

add_action( ‘wp_print_styles’, ‘my_deregister_styles’, 100 );
function my_deregister_styles()
{
wp_deregister_style( ‘tubepress’ );
wp_deregister_script( ‘tubepress’ );
}

Using the Mobile Site?

Use the comments box below and let me how it feels!

An Introduction to Google Calendar & How To Guide

Since its launch in April 2006, Google Calendar has become a very simple, yet effective tool and also sports some exceptionally powerful features included.

If you’re reading this article in February 2011, this articles inclusion may not make any sense (yet), however if you’re reading this in March or later then I’ve put this video guide together for you so that you’re able to schedule those 10 minute windows in Google Calendar which will drive results for your business.

Google Calendar Introduction & How To Guide

In this video I discuss and show you:

  • Why use Google Calendar in the first place
  • How to create an event
  • How to move an event
  • How to create a recurring event
  • And how to share calendars between staff members (this is pretty cool!)

This video is almost exactly 10 minutes long, grab a cuppa &amp sit back knowing that you’ve taken action today!

Why Use Google Calendar?

  • It’s Free
  • As you’ve seen its ‘Matt Proof’ (really easy to use)
  • You can share calendars with staff by just adding an email address
  • You can set up email and pop-up reminders in seconds
  • Tasks can be colour-coded and repeated if necessary
  • It works on mobile devices, like the iPad, iPhone or Android
  • It just works!!!

Are there Alternatives?

Yes, in Microsoft Outlook you can schedule recurring events, however for most of you, you’ll be using the standalone version without MS Exchange and the scheduling features don’t run without the actual application being open. The same goes (I believe) for the iMac equivalent, iCal. The application needs to be running (and the device needs to be on in the first place) for notifications to be sent.

If you’re anything like me, then I don’t have the desktop or laptop on all the time, instead I have a combination of devices and that’s why a service like Google Calendar a simple, versatile choice because you can be notified of the events via email, its integrated on the Android devices, can be sync’d on the iPhone/iPad and also to remember the ease of use for calendar sharing between members of your team.

Quickly Dealing with Website Spam Bots

website-spammers-1If you look in the image to the right, one of the community based sites I’m involved with was seeing a higher than normal user count for this time of the morning, which probably meant that it was being attacked by users or most likely spam bots.

Looking through the IP addresses, there was a common theme the IP ranges 180.76.6.* and 180.76.5.* which are located in China (we have no users in China see here for a lookup tool)

Now that’s pretty easy to crudely solve using a .htaccess file, regex and apache rerewrite rules.

Because I want to cover two subnets, I’ve written two rules, they are simply:

#180.76.6.* and .5
RewriteCond %{REMOTE_ADDR} ^180\.76\.5\.
RewriteRule .* http://www.google.com [R,L]

RewriteCond %{REMOTE_ADDR} ^180\.76\.6\.
RewriteRule .* http://www.google.com [R,L]

If you desired to just block a single address then you would need a slightly different rule, which would be:

RewriteCond %{REMOTE_ADDR} ^180\.76\.6\.183$
RewriteRule .* http://www.google.com [R,L]

This won’t stop their current connection, but as soon as the user agent goes to reload or navigate to another page, then in this example they’ll be sent to google.com instead (although I can assure you they are not being redirected to google in the live example of this).

Coping with a siege such as this example speed is of the essence and this is a quick and dirty way of dealing with them and also highly amusing as you chose where they are redirected to (but for goodness sake, make sure you check this works with your IP or IP range first!)

Ideally configuring a firewall wall before they even hit the site would be more suitable along with a few other methods of identifying them without being altered to the attack in the first place.

Use Dropbox? 5Gb Free Storage for BETA Testers

I was passed this from one of the chaps I play games with. If you watch the video and also check the link here, its an official thread as part of their beta program and while I’ve not personally verified this (which I am doing right now I hasten to add), 2 colleagues have.

If you’ve not heard of DropBox before, see an earlier article where I covered this tool here “DropBox, File Backup & Transfer Matt Proof

Update: See the image to the top right, current gained an extra 3.5Gb & there is just under 4Gb of photos and video on my camera currently

Do I Need an eBay Shop Design to Sell on eBay?

The short answer to this question is no, you do not need an eBay shop design to sell on eBay.

While having you eBay shop custom designed by a third party design company may look fantastic and most are able to offer features and functions that are not found in the basic eBay shop structure, it is not a requirement that you have your eBay shop themed or custom designed.

This article is quite brief, I’m just making the point that you can easily use one of the standard templates that eBay provides for your eBay shop and I will be covering the entire eBay shop in great detail in the forthcoming weeks.

 

You can theme the eBay shop yourself

While I’m not going to cover the fine detail of the eBay shop here, you are able to change many aspects of your eBay shop very easily using the tools that eBay provide to you.

For example, you can pick from approximately 30 pre-built themes and advanced, more customisable themes are available.

Example Standard Themes

A couple of examples are shown below:

Selecting a Standard Theme

Selecting the one of choose is really easy and you can pick your standard eBay shop design in eBay here:

http://cgi6.ebay.co.uk/ws/eBayISAPI.dll?StoreMgmtChangeTheme

While these are not specifically tailored to your business and branding, these themes are perfectly acceptable, can be enabled in seconds and included free on your subscription level.

Advanced Themes

There are five advanced themes provided by eBay that allow you to have more control over the elements of the eBay shop without needing to know any CSS or HTML, or if you are comfortable in making design changes, these themes, especially the ‘Custom header Only’ theme easily allow the insertion of HTML & CSS to extend the eBay shop design further.

Paid-for Themes

There are many design companies out there offering eBay shop designs for various prices and at various standards. I recently covered the eBay listing templates in a two part series here and here and also an interview with DZine-Hub whose business is focused towards eBay Shop and eBay listing template creation.

Summary

As I mentioned in the beginning, this article is quite brief, just to answer this question specifically as its been asked too many times now. So… No, you don’t need an eBay shop design to sell on eBay.

One of the basic designs will be fine for the interim and while the designs offered are not all equal in what you can do with them, you can easily save yourself several hundred pounds of outlay and focus on shifting product first.

I will be covering the entire eBay shop in minute detail in the forthcoming weeks. If you’d like to be notified when its released, use the subscribe box below to be notified.

What if the prices for everything were the same?

 

This whole price parity issue with Amazon over the past few days as got me thinking. What if the prices for everything were the same?

Let’s imagine for a few minutes what would happen if we say, all governed by a communist government worldwide and one of the parts of the establishment was that for all products, the prices had to be the same.If Prices Were the Same?

I mean everything, from a can of coke to a Plasma TV. If it’s exactly the same product it has to be exactly the same price set by a third party, no if’s, no but’s and you go to jail if you break the rules. (The jail part is harsh, but I’m just making the point).

Now before you start picking holes, unbranded goods would fall into categories, for example, a printed T-Shirt, regardless of design or material would be a fixed price. All broken or refurbished goods have to be scrapped. Every single product is categorised and has its own fixed price, regardless of country of origin or point of sale and cross-border trade was not allowed.

How Would You Differentiate Your Business?

Humouring me for a few moments, that everything businesses product has to be sold at the same price as their competitors.

What would you do to to compete in a marketplace where everything was equal as far as pricing is concerned?

Let me know your thoughts in the comments box below.

How eSellerPro’s Channel Profile Can Help Your Business

One of eSellerPro’s core features is a function called a ‘Channel Profile’, in this article I’ll be covering the basics to what a ‘Channel Profile’ does and how it can help your business.

Multi-Channel selling is now an assumed practice for eCommerce businesses, unlocking the power to reach a much wider audience than you could ever have imagined, but sensibly. The Channel Profile feature in eSellerPro can enable you to achieve this.

I’ve put together a short video, where I describe the key benefits of using a channel profile and how it could help your business when dealing with multiple sales channels.

What is a Channel Profile?

The purpose of the channel profiler is to maximise the exposure of your inventory exposure across more than one channel, then once an update has happened to let the other channels know of that update to the stock level.

In eSellerPro you can create more than one channel profile (hence ‘profile’ in its name), which you can apply to more than one inventory record and each profile can have different attributes. I’ll cover these later on in this article, but for now the easiest way of explaining what a Channel Profile does is by using  an example.

Let’s say we have 10 of the same mugs in stock and we wish to sell them on:

  • One eBay account
  • Amazon
  • Our website.

For maximum market exposure, we’re going to use the channel profile to list ALL 10 of these mugs onto eBay, Amazon and also show them on our website too. A couple of hours later, a customer called Jane buys one from eBay.

We now only have 9 in stock and the channel profile will now update Amazon to 9 and the website also to 9. Then another customer, Jim buys from the website. Again the channel profile will update the other marketplaces, eBay & Amazon with the new stock level of 8.

The next morning a new delivery of these mugs arrive and we have 10 more, so we now have a stock level of 18 mugs. The Channel profile will now update each of the selling channels where the products are listed with the updated stock level.

In this basic example, we gain maximum market exposure for our products and keep each of the selling channels in-line with the latest stock levels. Neat eh?

The Negatives of Using A Channel Profile

I’m going to note here the negatives you might have already realised are minor in comparison to the positives of exposing your inventory across as many channels as possible. However you need to be aware of them.

In theory if you only have 10 in stock, then you only have 10 to sell. By exposing your inventory across just 3 platforms in the example above, you are actually exposing 30 items and again in theory if they all sold at the same time, you could go to a negative inventory count of 20 (that’s the 30 sold, minus the 10 you had in stock).

The Channel Profiler is a process that runs on eSellerPro’s servers and it does not update the marketplaces instantaneously, there is a time lag on eSellerPro’s side and with the marketplaces themselves. While I now don’t know the exact figures, a period of about 30 minutes would be about right for each passing of an eSellerPro account to make updates to the 3rd party platforms.

We also need to understand that eSellerPro is a 3rd party to the marketplaces and as such there are time delays in the communication to them. Again referencing the earlier example, the orders from eBay & Amazon are not picked up instantaneously, they’re scheduled. Plus we also need to account for time delays in the marketplaces themselves, Amazon orders are not immediate, they tend to sit for 15-30 minutes before being released and also you can only ask for order reports every 30 minutes or so.

So it’s perfectly possible for Jane and Jim to buy on two different marketplaces within a time window of say 10 minutes and eSellerPro is not capable of updating the other channel to let it know there is a deduction of the inventory level, if there was only one left, this could have caused an oversell or back order. Hardly ideal.

It should also be noted that in relation to eBay, eBay auctions and BIN listings of 10 days or less, are regarded as being committed to the eBay marketplaces, thus if you have 10 in stock and 2 of those are in two auctions, then eSellerPro sees an available stock count of 8 and will use this value to keep the platforms updated.

Note: You can use the true stock level of 10 called “Percentage of On-Hand”, however this is where you’re most likely to be caught out, as using this option I strongly advise you never to use this option (although there are situations where it does not matter, such as virtual or limitless stock).

Channel Profile Tolerances

The channel profile process also has “tolerances”, for items over a stock count of 20, there is no compelling reason to keep the selling platforms updated with the latest stock count for each change.

If we had 10,000 of those mugs in stock, then updating them every time we sold one would be silly and slow down the really important updates for other stock items which have much left. As such eSellerPro has different tolerances for different stock levels and they can be found in their Wiki.

A Simple Example of a Channel Profile

A really simple example of a channel profile is the first example, where we were listing all 10 of the mugs on the 3 platforms. In this example we are committing 100% of  the “Available stock” (10) to each of the channels.

An Advanced Example of a Channel Profile

There is likely to be situations where you don’t want to commit all your stock to all of the channels all of the time and this is where the ability to create multiple profiles comes in really handy.

For the first example, we would have named the channel profile something like “List 100% to eBay, Amazon and Our Website” (naming the profiles to what they do is again strongly suggested, it makes them “Matt proof”).

For this second example, we’re going to want to keep two of mugs in stock at all times, this is because they’re end of line and we want to keep safe just in case we get a return of breakage.

Similar to the previous example, we’re going to commit 100% of the “Available Stock” to platforms, but we’re going to add a number 2 to the column called “Min. Qty Avail”. By setting a value of 2 in this column, we’re saying list 100% of our stock, but when we get to our last 2, take them off all the platforms.

We could of course just set this value of 2, to just one platform, so that when we get to our last 2 items, we take it off Amazon, but leave the 2 on eBay and the website. I did say that this was ‘neat’ :)

Further Examples

The abilities of the channel profile doesn’t stop at just listing 100% of items onto marketplaces and keeping their stock levels in-tow and basic stock control. You can also configure a channel profile to use these cool features:

  • Percentage based listing, not just 100%, maybe only 50% to eBay and 100% to Amazon & the website.
  • Force set inventory levels onto one or more marketplaces, that never go out of stock
  • Force set inventory levels onto one or more marketplaces that are removed when the available quantity drops below a specific level
  • Using a “Cost Formula”, dynamically calculable your selling prices for each channel and also the minimum and maximum prices for Amazon & Play.com accounts.
  • Cap the number of listed items on a platform to a maximum number
  • And there are some funky things you can do with sequences and stocked sub skus of products that 99.9% of the people reading this wouldn’t ever use.

It should also be noted that if you have the WebXML interface enabled for up to 10 external channels, the channel profile can also apply inventory update rules to these too and via the new eSellerPro API, the status of the SKU can be checked to see if its been set to list on several of the ‘channels’ in the channel profile.

My eSellerPro Channel Profile Tips

Here are a collection of tips that you may find useful:

  1. Never edit the default profile
    Think of this profile as a off switch, keep it set to manual and use this profile to take items off all the platforms and for new records that are not ready to be listed yet.
  2. Keep calculations to a minimum
    The more you ask for a channel profile to do, the long it will take and the slower it will run. Where ever possible, keep calculations for prices to external tools lke excel or PHP before entering into eSellerPro.
  3. Never use product specific channel profiles
    If you create product specific channel profiles, you’re missing one of the huge benefits of eSellerPro ‘profiles’. If you do have an exception product that needs its own rules, just create another profile and name it accordingly. Then ALL your profiles are in one place and easy to administer.
  4. Name the channel profiles sensibly
    If the profile is listing 100% to eBay, Amazon and the Website, name it that. In the bulk update tool, in the inventory record and in the import/export system you only see the names of the profile, thus name them clearly in relation to what they actually do.
  5. Think through each channel profile thoroughly before creating it
    Take a few moments to write down what you want the profile to do, then once written, use this to guide you to the configuration of the profile.
  6. Use ‘Bulk Update’
    You can use the bulk update tool to update as many records as you would like, remember that naming them clearly will make this task a cinch.
  7. Import/Export with care
    Don’t forget you can import a channel profile name as part of the custom import/export sheets. But use this with care, as you can enable products to be listed from an import sheet, this may not be desired straight away and may cause other issues, especially if you are loading new products and images need to be collected from a 3rd party before listing, the listing may go live and be incomplete!

The Channel Profile Summary

Using a channel profile is not without its risks, as you can in theory oversell heavily if the products which have been assigned a channel profile are in ultra high demand, accounting for the lags of the platforms themselves and giving eSellerPro enough time to react (although in reality this is quite rare, I can only remember of two instances in 3 years of this happening).

Sensible configuration of your channel profiles for different velocity products is key and also keeping them as straight forward and aptly named is strongly advised.

The examples in this article are quite basic, however if you consider you may have thousands of inventory records, numerous eBay accounts more than one Amazon Seller Central account (yes this is possible), multiple websites and maybe 3rd part integrations to other selling platforms, being able to expose your entire inventory across ALL possible channels and keep them updated when items sell and stock deliveries are made, makes the “Channel Profiles” in eSellerPro one of the core parts of the entire system.

Try doing all that manually. You’ll have no hair left like me!

Your Feedback

Do you use the Channel Profile in your eSellerPro account, is this something you could or couldn’t live without? Let me know in the comments box below.

Reverse Engineering The Data From an eBay Listing Part 2

Welcome to the second part of a 2 part series in this final part I’ll be looking at the data that is posted into the template to show you how easy it is to create a fantastic eBay listing, but with minimal data.

In the first part here, I worked out what the probable layout of the eBay listing template that was used, introduced you to keywords and pointed out that eBay templates don’t have to be a single template, they can be made up of lots of smaller templates, that once combined form the the final finished eBay listing.

So let’s have a look at the ‘data’ used behind an eBay listing.

Reverse Engineering the Data From an eBay Listing Video

To make this as easy as possible for you, I’ve put together a video to explain how this works and where I have pulled the data from and I have attached the excel spreadsheet that I created from this video later on in this article.

While you’re watching this video, keep in mind how ‘light’ or ‘easy’ the listing data is when you look at it in its purest of forms.

Data File

The Excel file that was created during the video is here and includes the formulas that were explained to create the price saving value & percentage.

What Have We Covered?

While it may appear that large eBay sellers spend a lot of time ‘listing’ items to eBay, they’re actually not. They’re in fact spending time on quality data to create eBay listings through listing tools that allow the use of one or more templates to create the finished listings that we see everywhere on eBay.

When you break down the actual data requirements for a product (a fashion item in this example) then the amount of data is actually very, very low. What makes it look great is the way the data is formatted through the listing template and most larger sellers are clever to recycle data that is needed for item specifics, into the eBay listing too. What looks complex, is actually very easy to do.

In this two part series, I have shown you how an eBay template could work, what the elements are and in this final part what the data behind the actual listing could look like before its been sent to eBay. My question is, did you expect for it to be this straight forwards? Let me know in the comments box below:

What is eSellerPro & How it Can Help Your Business?

So what is eSellerPro and how can it help your business? To answer these questions effectively, I’ve put together a 3 minute video overview where I discuss the following:

  • The 3 core parts of eSellerPro, these being:
    • Inventory data & stock management
    • Order aggregation
    • The “Channel Profile” to keep the sales channels up to date
  • Suitable business types

Answered in a 3 Minute Video

Before you watch this video it’s important to note that I am a former employee of eSellerPro, clients that I work with use eSellerPro for all or parts of their businesses.

I’m not a sales rep nor do I receive any incentive from eSellerPro to publish this content. I certainly do not believe that eSellerPro is perfect, no solution provider is. What I am motivated to do, is to ensure that you choose the right back-end tool for your business and eSellerPro “could” be one that is most suitable to you.

Your Feedback

I haven’t covered the 3 core elements to eSellerPro in any great detail, the video was only designed to give you a brief overview of what these are and how they could help your business. However, these will follow in the next few days.

However did you find this video useful? Have you or are you using eSellerPro to run part or all of your business? Let me know in the comments box below.

That’s Curious BrightPearl is Releasing a Magento & eBay Integration?

Brightpearl LogoBrightpearl, now that’s a curious one.

It appears they’re adding a Magento & eBay link to their arsenal (see their shhhh page here) and I’m super curious!

If we look at the different SaaS (Software as a Service) providers out there, they’ve all originated from different angles:

  • ChannelAdvisor came from the perspective of eBay
  • And so did MarketWorks too
  • eSellerPro came from an order processing perspective, for which the marketplaces & listing were added later.
  • 247 TopSeller has hefty Amazon slant to it
  • StoreFeeder came from a Fulfilment perspective
  • Linnworks came from an ERP and MRP satellite systems
  • ChannelGrabber from a need to combine eBay & Amazon together

Brightpearl, Where Did They Come From?

As we’ve seen above each of these providers have come unique points of view and Brightpearl isn’t exception. Brightpearl came from two entrepreneurs and co-founders Chris Tanner and Andrew Mulvenna, whom was frustrated with the likes of NetSuite & Sage and how everything from a website (osCommerce) & accounting perspective was not linked and hindrance to his business at the time called “Lush Longboards”.

A years coding bender in 2006/2007 led to the development of Brightpearl, two investments later from Eden Ventures & Notion Capital, Brightpearl have over 6000 customers, a solid product that combines the features of a inventory management system, full-blown accounting (including purchase orders, quotes & invoices), contacts & a CRM tool (which is excellent I hasten to add! They’ve extended the Rapportive extension that links with Gmail), a web-based EPOS system (this is very cool) and an eCommerce offering for integrated websites.

Recently Kate Gover from Lahloo Tea discussed how Brightpearl helps her business. The video is below:

When I met the team at Brightpearl last year (hola!), the irony was that the businesses using Brightpearl felt it so valuable to use Brightpearl for their online channels that they were manually importing sales orders from other sales channels like Magento, eBay & Amazon, so that they can leverage the functionality of Brightpearl to its full potential.

eBay can get deep very quickly and Magento API is pretty poor currently, especially if you want to do complex tasks. I don’t know how far they’ve gone with the integrations yet, but even if they’ve done the basics such as stock control and order aggregation, it could be pretty slick.

Now it’s looking like they are adding a Magento integration and an eBay integration…. From a different perspective, that of website & accounting, that’s why I’m curious.

You can find out more about Brightpearl on their website and Shhhhh page where I found this information is here http://www.Brightpearl.com/shhh.