That’s How You Solve Scroll bars in eBay Listings! – Fix eBay’s Duff Code

I covered this previously in an article called “Do you keep seeing scroll bars on your eBay listings?” and as I started to explore this again for someone it became apparent that eBay’s JavaScript code is actually broken.

But before we go any further, I am fully aware that this could be classed as “site interference” by eBay (again this a debatable subject, as I’d class it as fixing a known problem, hence the following notice), so this comes with an explicit warning not to use this code, but for eBay to pick up this article and relay it to the right department (as I know you read this site *coff*).

Unpicking the Code

In the comments of the earlier article “Do you keep seeing scrollbars on your eBay listings?” I soon worked out why the scrollbars were appearing, the height attribute was not being assigned back to the page correctly.

eBay pass a variable in the URL of the item being viewed, I’m sure you have seen it before it looks like “#ht_1480wt_1396″at the end. What this is, is the height at 1480 and the width at 1396.

Now eBay have got the code in a subfunction called “ifr.getSize = function (some code here) “. This function gets the width really well and I have never seen an issue with the width on an eBay listing that has not been the code the seller made.

The code looks like this:

if (document.all) {
h = document.body.scrollHeight;
w = document.body.scrollWidth;
if (oCl.bIE && oCl.iVer >= 9 && document.getElementById('EBdescription')) {
h = document.getElementById('EBdescription').scrollHeight;
var u = document.location.href;
if (u && u.indexOf('&tid=') != -1 && document.getElementById('ngvi_store_id')) {
h = document.getElementById('ngvi_store_id').scrollHeight;
}
h = h + 40;
}
} else {
h = document.body.offsetHeight;
if (oCl.bSafari && oCl.iVer >= 523) {
w = document.body.scrollWidth;
} else {
w = document.body.offsetWidth;
if (window.scrollMaxX !== 0) {
w += window.scrollMaxX;
}
}
}

The line in bold works really well as most listings have a normal width “w = document.body.scrollWidth;“. But the function to get the height, well that’s forked, AKA broken.

And the problem is really obvious now, the code to set the height is trying to get the height straight away and in that attempt lies the problem, you can’t get the accurate height of a page if it’s not loaded yet!

I’d also like to point out at in the code that is in the iframe, eBay has gone for the right DIV tag, but forgotten to add an ELSE statement after it with some extra code to grab the other event, ie what happens if ngvi_store_id is not found?

So to the function that gets the page sizes (“ifr.getSize”) needs to be slowed down by a few seconds to let the iframe contents (that’s your descriptions) actually load.

Using something like this would work well:

setTimeout("ifr.getSize()", 5000);
rest of the code

But we don’t have control over that code, so the way to get around this is to add a delay and then force the parent URL of the listing to have new values for “#ht_” and “wt”.

About 5 seconds to be precise, plenty enough time for the entire description to have loaded and then send back the correct height to the eBay handler so that the scroll bars go away, because we now what the correct height actually is and have not been so eager to fix the page height.

<script type="text/javascript">
setTimeout("FixMyListingHeight()", 5000);
function FixMyListingHeight(){
var rf = window.document.referrer;
if (oCl.bSafari && oCl.iVer >= 523) {
w = document.body.scrollWidth;
} else {
w = document.body.offsetWidth;
if (window.scrollMaxX !== 0) {
w += window.scrollMaxX;
}
}
h = document.body.scrollHeight;
parent.location.replace(rf + '#ht_' + h + 'wt_' + w);
parent.frames[0].location.replace(sUrl + '&c=' + callerId + '#ht_' + h + 'wt_' + w);
}
</script>

This code is not perfect, but it works on IE, FF and Chrome. In FF the height get’s over-amplified, in this case, it’s a good problem, it just means it’s a long page to scroll through to ask a question :)

What it is missing is some specific code to catch the different browser versions as they appear to report back the height incorrectly across the browsers. That’s beyond my coding skills, I’m just pointing out what the issue is [it needs to be slowed down] and now how to solve it :)

Thought I’d share that with you, as the silly scroll bars have been driving me nuts for months.

How to: Remove Provider Credit Images From eBay Listings

I was asked on Thursday if I knew of a way to remove the “Powered By” logo’s from the bottom of eBay listings. You know the ones, the little 88×33 graphics that you see added to the bottom of your listings, that were not on your template, a few examples are to the right.

So instead I whipped up a little snippet of JavaScript that hunts for the last center tag there is on the page and then just in case it was something really important (like part of the description), it then has added an extra check to make sure it was only hiding the provider links if they match.You could crudely use CSS and set the CENTER tags to “display:none” eg center {display:none;}. The problem with that approach is that you may have text in your templates and descriptions that use the HTML <center> tag and that would hide those too, that’s not ideal…

 

The Code:

Drop this anywhere in your listing template, whether this be for eSellerPro, ChannelAdvisor, TurboLister, GarageSale, manually in the eBay Sell Your Item Form, Selling Manager or Selling Manager Pro, BlackThorne, it’ll remove the logo for them all, at the bottom of your eBay listings.

<script type="text/javascript">
window.onload=function(){
 findcenter();
}
function findcenter()
{
 nodes = document.getElementsByTagName("center");
 subnode = nodes[nodes.length-1];
 var link = subnode.getElementsByTagName("a")[0].href;
if(link.indexOf("eseller") != -1 || link.indexOf("channel") != -1
|| link.indexOf("iwascoding") != -1 || link.indexOf("pages.ebay") != -1  
|| link.indexOf("auctiva") != -1)
 {
 subnode.style.display="none";
 }
}
</script>

You can download this as a text file from here as the formatting isn’t great in the text above.

Summary

It’s been commonplace for providers to include logo’s on the bottom of your eBay listings for a long time now. From a personal perspective, I can understand both sides of the table.

On one side the providers would like to show that your business is using their eBay tool by including a logo at the bottom of a listing, thus promoting their services or offering and on the other side some businesses would rather not show to their competitors which back office tools they are using.

Your Feedback!

But… What do you make of this, should they stay or should they go? Let me know in the comments box below.

Birdtables & Competition, What on earth could they have in Common?

Birdtables & competition, what on earth could they have in common? Quite a lot actually.

It’s a story I have enjoyed sharing with a couple of people and each time I share it, it gets added to and I’m hoping you’ll get the idea too and add to it as well by leaving a comment at the bottom.

The Almighty Bird Table

bird tables and competitionSat on the doorstep one morning, sipping the first coffee of the day with the sun just coming up. I can see numerous little birds darting around the next door neighbours bird table.

This isn’t just any bird table, this is a monster bird table, you know the ones, side trays, four hanging points and a collection of goodies to attract even the most timid of creatures.

The owner, who I’ll call Mr B spends a fortune on bird food to attract them, he had tried the cheap stuff and now spends £40 a bag on the really expensive bird feed, some special seeds of some form and takes delight in after a hard days work, watching the birds come from all around to feast on the banquet through the kitchen window.

Mr B has really got into bird watching and now in his office he has started to collect a library of books to help him identify the different species of birds that arrive at his table. For over a year that bird table has been the hub of all bird activity for the row of houses where I live.

We put a small one up ourselves, but due to the cats we have, the peanuts & half-hearted attempt we made, we’ve only seen one bird on it in maybe 6 years. No competition for the all-mighty table that Mr B has.

And Then…

We had a new next-door neighbour arrive, Mr A a few months back and Mr A popped an equally large and luxurious bird table. I’m going to label this as “The Competition”.

But Mr A, had put his table in the wrong place, it was in the clearing between two large shrubs and very few birds actually visited the table & it’s not so luxurious offerings. The little birds like a lot of cover to keep safe (mainly from our two cats, as they like to eat little birds if given half a chance) and the table being in the middle gave them no cover.

Now Mr B, could have thought “Bastard Mr A, he’s nicking my birds”. After all Mr B’s table has been the hub of all bird activity in the street for quite some time, he’d taken the extra step to research the different species of birds that come to the table and spends in my mind, an excessive amount on bird food, watches them each night after work and its developed into a pleasant past-time.

Working Together

Mr B, gave Mr A some advice on where to place his table, after all those little birdies need to feel safe when feeding and even gave him some of his expensive bird food. Mr A’s table was moved nearer to one of the shrubs and Mr A gave it a little more interest than he had been doing previously.

If Mr B had looked at the situation differently, well from the point of view of “He’s nicking my birds”, then I doubt that Mr A’s newer table would have had so many birds frequenting it the table and its delicious snacks this morning without Mr B’s advice.

So What did Mr B Know?

Mr B is a smart cookie, Mr B knows that for the short-term at least, the number of birds that will go to his table will decrease. There is only a finite number of birds available to feast on his offerings and now it’s potentially been halved by Mr A’s new table. Bad thing right?

Little birdies (as you can tell I’m not really into birds, I’m a big child and laugh at some of their names) when given enough time will multiply with offspring and become fatter birds.

This could take a while to happen, but the combination of the original table & delicious snacks on offer, combined with Mr A’s new banqueting table and some coaching from Mr B will mean that next year, there should be more birds and possibly a great variety too.

Mr B really could have thought “he’s nicking my birds” and pushed the table over drunk one night, but instead decided to take a different approach and help Mr A with his table with some advice and even offered some of his expensive bird food to help attract birds to his table, so Mr A could enjoy them too.

Mr B and Mr A like birds. Together they’re stronger together than just one of them by themselves, after all we’d like to have more birds and possibly some fat ones too.

I’ve spent the past 6-8 months reading a single book. It’s called “On Competition” by Michael Porter, a Harvard business review book, see the Hardback & Kindle versions (both aff links).

It’s taken me so long to work my way through the book as I’ll read two pages and then relate it back to real life. There are some topics in here I had never even considered such as the competitive advantages that nations have and how fragile diversification is when a company expands outside their core competencies.

In this absolute monster of book Michael covers the topics of “Clusters & Competition”, how the Italian footwear and fashion is clustered by location, how the inter-related businesses from the California wine cluster join together to create a competitive environment and how that by competition in a cluster (Michael uses location for this in the physical sense, but this easily ports to marketplaces as the location) can provide competitive advantage through clustering the businesses together.

So bringing this back to the original bird table owned by Mr B and the new table from Mr A, they are stronger together and will complement each other, MR A certainly is not going to spend £40 on some seeds and will offer a different food source and while crudely the new table could have been seen as competition for Mr B’s original table, together they have a more compelling case to attract more birds from the local area.

My Table, Come Snack at it

I have a bird table like Mr B’s & Mr A’s table, but it needs you to come and snack on the potential goodies from it. You can find out more and see how you can get involved in 3 steps and the forums are here.

Tesco Marketplace Now Partly Live – Already Showing Signs of Flaws

Tesco has soft-launched the redesigned Tesco Direct website with two “Marketplace” sellers and guess what…we’re already seeing that there has been little learned by looking at the core rival Amazon.

The Tesco marketplace have two merchants live on the platform already, Crocus & Maplins and its the latter merchant that is making it clear that Tesco haven’t really worked out that Data is the life blood of an eCommerce business just yet.

 

Product Page – Tesco Owned Item

Tesco Marketplace Product Page 1I’ll be back to that topic in a few moments, but for now let’s have a drill down of the features of a 3rd party item and a Tesco owned item. There are going to be a few comments I’m not going to make, the reason is sat in the previous articles here regarding the Tesco Marketplace.

To the right is a screenshot highlighting some key points on the product detail page, if you click on the image it’ll open in a full sized window or you can view the live item here.

My first observation is the catalogue number, its base ten and not base 36.

If I’ve lost you already let me explain. We work in base 10 from 0 to 9 (that’s our fingers which caused that), base 36 is from zero (0) all the way to Z, so numbers and letters.

Why’s that important? Base 10 has a very low number variations for products, well in fact 7^10 = 282,475,249 possible variations. Yes, that’s 282 million variations, but we’re dealing with products and as they are potentially opening the platform up to 3rd parties, then 282 million SKU’s is nothing given enough time.

A quick flip to Amazon’s ASIN’s (ASIN’s are Amazon’s unique identifier for each product, see here) and an example is B005890FU. Taking this to the ultimate limit of ZZZZZZZZZ in base 36, this is normal numbers from 0 to 9 is 101,559,956,668,415 or 102 Trillion variations give or take a few million for rounding :).

102 Trillion V’s 280 million = No comparison

Let’s go a little deeper for a moment, if I’m loosing you from the above section, this one is even more important. The product identifiers have a hyphen between them. In the case of the TV above the catalogue id is “210-7084”.

But what importance could an hyphen have? It means it’ll be parsed as a text string by a 3rd party system. If we count 1, 2, 3 etc… it makes sense, counting 210-7084, 210-7085, 210-7086 does not because they’re’s a hyphen in the way. So a sub-function that splits or removes the hyphen needs to be run, the number value then incremented and then inserts the hyphen back in.

That’s one way of doing it, it can be done with regex & other methods, but my point is, its an unnecessary and a carry-over from the catalogue side of Tesco.

After that, the rest is mustard.

We’ve got…

  • Titles that overflow the navigation
  • Customer reviews (nice)
  • Primitive bullet points
  • Poorly formatted descriptions
  • An ugly specifics table
  • Half hearted cross selling
  • I love the orange add to cart button, I really do. Have you tried green though?
  • And my last note, look at the top right, the wording has been added “Buy from *”, which changes between Tesco and the 3rd party merchant. But where is the link?

Wonky Product Data

There are two merchants live on Tesco’s Direct website, Crocus & Maplins. Nice touch on adding Crocus, I really want some onions with my TV.

My point, however is picking on one SKU, of which I assure you that if you cross compare the data between the two sites, it’s not alone. Take a look at this item on Tesco Direct. A screen shot is below.

Tesco-Marketplace-Product-Page-2

Can you see the issue?

Not spotted it yet? Take a look at the item from the Maplins site here. Look at the picture and read the title. Yep, that’s a purple product and a black title.

Dig around the other product data from Maplins on Tesco Direct for a few minutes and it’s not alone. Not to mention the pointless extra images in items such as this SKU or this SKU.

Tesco Seller Stores & ClubCard Points

I really like the idea of buyers being able to obtain “Club Card” points with 3rd party sales, there is a dedicated “Sellers at Tesco” page that you can read over here.

Tesco Seller Stores & ClubCard Points

I also like the fully customised store landing pages for both Maplins & Crocus, screen shots are below and if you click on them, it’ll take you to the pages:

Tesco Marketplace Maplins Store Tesco Marketplace Crocus Store

But to deliver this to a wider audience, that needs back-end tools in place and even Amazon have not even come close to the ~£81.4M that eBay take from eBay Shop owners every year in the UK alone and the eBay Shop is one of the most poorly supported product eBay have.

By the way if you think that number is obscene, I added up the USA & international eBay Shop revenues, you better brace yourselves for that in a later article, I did fall off my chair.

Summary

I’m going to leave this article at this point. Mainly because if I continue I’ll edge on the negative side and we’ve got to be fair here, Tesco have made a good crack at it so far with picking two unrelated merchants, even if one is odd and the other has data issues.

If let unchecked, then the Tesco Direct marketplace for Tesco is quickly going to go down the pan as far as duplicated & inaccurate data is concerned. To a data freak, this is alarming, but to be expected and I frankly did not expect it so early. It’s a nightmare/plague/cancer on Amazon with duplicates and just indicates that the process to check data needs some work.

Your Thoughts?

The grape-vine has already spilled that discussions have been made with 3rd party software providers a long time ago. So let’s run with a hypothetical question here.

  • What would you pay to gain access to the Tesco customer base?
    For both commission on sale & would you consider a start up fee?

You can let me know in the comments box below.

Delving into Niches with Multiple Websites – Part 1 Why & How

Hola! Welcome to the first part of a series of articles on how to run multiple niche websites and really tap into multi-channel eCommerce without eBay & Amazon.

Multiple eCommerce WebsitesI have been meaning to write this series for quite some time now and it’s going to take me a while to work through the different aspects I’d like to cover, hence breaking it up into multiple parts which will take me a few weeks to cover.

It’s my intention to start from the beginning in this article and cover the theory, then in the following articles work through turning the theory into practice to reach the final goal of you being able to run multiple web stores from a a single installation and really tap into the power of going niche.

I know I’m going to get distracted along the way, this is for good reason, I’m going to be focusing on a single open source eCommerce platform called “OpenCart” to deploy this concept with you and there are a couple of extensions that I’d like to include as part of this guide, this includes a free to use addon that will enable you to sell on eBay from OpenCart and also to delve into an Amazon integration as well.

To be completely up front with you, I have developed a complete integration from eSellerPro to OpenCart and while it would be handy if you have eSellerPro to power multiple websites from, I’d like to stress that this is not a requirement and I’ll be keeping this in mind throughout the series of articles as I delve into the how to power multiple nice websites with OpenCart.

So for now in this first article, let’s focus on the “Why” and start on the “How” parts.

 

Why?

I’m fully converse with deploying numerous selling persona’s on eBay & Amazon. I’ve done this previously with +15 accounts and I know of one company that has taken this & thrown it to the wall and has over 30 limited companies all specialising in niches just on eBay.

I previously wrote a pair of articles that desperately need a rewrite that covered why using multiple eBay accounts might be a good idea (you can read them here and here). As I mentioned, they need a rewrite and let’s summarise these, as the theory is straight forwards and comes back to a just three key factors,  these are:

  • Timing
  • Personal choice
  • External factors

For the vast majority of manufactured goods, you are not the only company selling them, thus every single day, customers choose your competitors over you. There are an infinite number of reasons for this, timing, colour scheme, layout, description, title are a few factors.

Also, an interesting set of factors that I delved into a while ago was that there is a limit to the exposure for a given sales platform on a given day. This was started because I could see no viable reason why eBay sales should stay consistent within a specific window of 20% on a single day.

So let me ask you two specific questions here, if the response is anything like the one I normally receive back, this is exactly why you need to carry on reading this series of articles:

  1. By midday, can you make an estimate within 10% on the total value of sales for that day? (if you’ve not tried this yet, try it)
  2. Look at the sales totals for each day over the past two weeks. Do they stay within a 20% window?

Yep thought so. I’ve found some business owners that use eBay & Amazon can estimate their daily sales figures to the nearest £100 quite accurately just using that morning sales and others that can be well within 1-3% window on daily sales values in excess of £15K per day. The thing is, that’s not natural.

It’s what lead me to write a pair of articles, the first called “Why do eBay Sales Stay Consistent?” and the second to explore a hypothesis, that why I cannot prove, but I’d bet money on it or a subset of what I cover being in place, because its exactly what I would do, the article is here and called “The eBay “Best Match” Position Bias Modifier Hypothesis“.

I know I’ve not fully answered the “why” part just yet, but I need to explore a sub-topic, around choices. That’s next up :)

Choices, Choices, Choices

Choices, Choices, Choices. Which Colour do you like?While timing can be pure fluke (when they find your product) and I’ve already made a case for external factors in the earlier section, the one factor that you can most easily influence is choice.

Buyers like choices, I like choices, but what influences my choice of which company to buy from, especially to what influences my partner to what she buys on eBay can vary greatly. Sometimes its just the way the product data is laid out, sometimes its gallery picture, sometimes it’s the sellers feedback, shipping prices, the colours used, the photographs, the list is almost endless.

The fact is here, is that I, as any of your potential customers may open your product listing and “not like it” and move to the next one. It could ironically be for the same product. It doesn’t matter, the point is, I have personal tastes on what I like and so do your customers.

This is one reason “why” you should consider multiple persona’s for your selling activities. For example you could one persona set up as a full professional looking business and the second the complete inverse, maybe one account that just uses variations, one that does not, one that as separate listings for each product variation and there are a whole host of possibilities, as soon as you break away from the “single business” approach.

And back to Why?

I wanted to cover the choices section in some detail, mainly because it’s the easiest to understand, I like black, but you may like blue, that means we will respond differently to different pages, it’s a quirk of being human, we have different tastes.

Going back to the three key points, Timing, Personal choice, External factors. Your product may be overlooked, it might even not be shown for a specific search and being at the right place at the right time can and does play a role in the ultimate goal of the customer buying your product. We’ve looked at personal choice in some depth and I’ve already hinted that when using marketplaces that external factors such as my hypothesis for when it comes to “best match” search results, the worrying part is that is exactly what I would do.

These are just some of the reasons why you should consider a multi-faceted approach to eCommerce and I’m sure you can think of more reasons why this approach makes good sense (if you have any you’d like to share, let me know in the comments box at the bottom).

I’m fully converse with deploying numerous selling persona’s on eBay & Amazon, but for websites, this can also be tough nut to crack, mainly because it can be expensive and the results take time to take effect, hence this article series.

Going Niche of Niche

WorldStores +70 StoresIf you have a wide range of products, then it can be relatively straight forwards to slice your products up into groups and create persona’s for each group.

I’m not going to be covering how to do this with eBay here, but instead focusing on a different way of approaching this through multiple eCommerce websites over a couple of articles.

An excellent example of this is in the real world is WorldStores, take a look at this page. That’s over 70 dedicated websites  Each site is niche site to a specific range of products and this is the opportunity & challenge I’m going to be tackling in this series of articles. How to go multi-channel with multiple websites, on a budget.

If you’d like a corporate example see shopdirect.com that are responsible for Littlewoods, Very, Isme (previously Marshall Ward), K&Co (previously Kays) and the other is thehutgroup.com, they have at least a dozen eBay accounts that I know of and if they had 30, I’d not be be surprised, let alone the assortment of highly specialised “Niche” websites.

Which website platform to use?

If we pick on a few examples Magento can be, sorry “is” a resource hog, to run multiple websites off Magento (or even one larger site for that matter) then you’re going to need specialised hosting, which costs, its far from a simple platform to use and as soon as you mention “Magento”, all costs go up a minimum of 60%.

If we look at the bespoke offerings from eSellerPro, then cost, features & time to deploy is a major factor here and if we look at the ASPdotnetStoreFront from ChannelAdvisor, ignoring the setup costs & design fees, the £200 a month is a non-starter for each niche website.

We need cheap, we need ease of use, some snazzy functions that don’t require massive amounts of processing power & can be run on a shared web hosting account, an arsenal of free or inexpensive themes, an extensions & addons base that is varied and equally inexpensive and that’s why I’m picking on one of my favourite open source website platforms called OpenCart.

If you’ve not seen OpenCart before, then I think its about time you did. You can see both the front end of the base installation of OpenCart and the administration panels through their demostration sites here.

For me OpenCart makes an excellent choice, the admin is easy and the front end is feature rich. It’ll happily run on shared hosting accounts, its free, the themes are super cheap and crucially…. get this!! It will run multiple webstores from a single installation!

Summary & Your Feedback Please!

We know that niche works, I’m in a niche, you’re in a niche. But there are so many sub-niches we can get into with a product based business, we just need a cost effective route to do so and that’s exactly what I’ll be digging into in this series of articles using OpenCart as a base.

My closing questions are below and you can let me know your reply in the comments box below.

  1. Have you considered creating niche websites before? What stopped you?
  2. Do you already have niche websites, what has been your experiences so far?
  3. What would you like to see in this series of articles?

I look forward to hearing from you :)

The First Bristol Multi-Channel eCommerce Meet Up 20th April

Bristol Multi-Channel eCommerce Meet Up

Hola! I’d like to invite you to the very first Multi-Channel eCommerce meet up on Friday 20th April in Bristol.

One of the biggest takeaways from working with the 6 businesses in the latter part of last year was that while we enjoyed the one-on-one time, there was really no replacement for meeting as a group and discussing the challenges that we face as a group. Some of the solutions were ingenious and meeting on common ground really worked well.

I’ve had a chat about holding such a meeting with a couple of businesses owners in and around the Bristol area that use eBay & Amazon as sales channels and the response has been really good. Well, they’ve all said yes so far :)

I’d like to try & keep it a small, personal affair and if you’re near Bristol on the 20th April, I’d like for you to join us for an hour or two. If anything to escape the office on a Friday morning for a few hours and “talk shop” with your peers, you’re welcome to join us.

 

Agenda

There is none. It’s the first meeting and while I’ll pencil in an agenda, I’m planning to just roll with it and see where the discussion goes.

Zero Providers Allowed

My role in this meeting is purely as a host and to meet the “cool” people.

I’m sorry this is intended to be a zero service or product provider meeting. Later on, we may invite you to join us. If you are interested in attending in an informal or formal capacity from a provider standpoint, contact me directly using the contact form here. But it won’t be for a few meetings in.

Location & Directions

Multi Channel eCommerce Bristol

The location I’ve chosen is my 3rd place, it’s a coffee shop that is sat right on the edge of the historic  Bristol harbour-side called “Cafe Gusto”.

Car parking is plentiful with two large car parks within a few minutes walk and there is free parking either within 15 minutes walk (Constitution Hill) or just over the water on Cumberland Road with a swish ferry ride for 70p.

For those who also cannot bear to be disconnected from the virtual world, there is free WiFi and a decent mobile signal. I use this cafe as my second office so I know the connectivity is excellent, although make sure your devices are fully charged there are no public power points.

Sat-Nav postcode: BS1 5JE
(this is for Jack’s which is just around the corner but will get you very close)
Start Time: 10:00 AM
Google Map URL: http://g.co/maps/sp3w9 

Parking
The map below shows the 3 nearest carparks in yellow/orange. The prices vary for these and I’m not sure on the actual prices. The green square at the bottom is for Cumberland Road which the parking is free, if you walk/follow the signs for the SS Great Britain there is a ferry that crosses the water for 70p.

Walking
Alternatively if you’re  prepared to walk a couple of minutes, the arrow in the top left is for Jacobs Well’s Road, there is meter parking either side and half way up is Constitution Hill for which the side roads are free.

Bus
If you’re travelling by bus, any route to the centre will do, its 10 minutes walk from the centre and walking directions are here http://g.co/maps/nx2v2 (you can short-cut along the waters edge).

Bristol eCommerce Meeting Directions

Will I be Seeing You There?

I would like to stress, if you’ve got to travel half the country to attend, then this is probably not for you. Well at least until we’ve had a couple of meetings and I’ve hammered the format out.

There is no cost to attending although you’ll want to bring a tenner or so for refreshments. The coffee served is my personal favourite, there is a soft drinks fridge and a selection of speciality teas,  and the panini’s are to die for.

If you’re in or around the Bristol area on the 20th and would like to attend let me know by leaving me a comment in the box below, I’ll send you my mobile number directly just in case you need guiding in on the day.

If you have any suggestions on topics that should be added to the agenda, they’d be welcomed.

Two Week Update & eSellerPro to BigCommerce Integration

This post is a mainly about what I’ve been up to for the past two weeks,  but you’ll soon work out its mostly just for you :)

BigCommerceI’ve now completed the full integration of eSellerPro to the Big Commerce website platform and are on the home run of the bug finding & eyeing up further customisation to the account it’s running from.

If you’ve not heard of BigCommerce before it’s a fully hosted website solution which isn’t expensive (especially as its in USD). The more I’ve played with it, the more I like it, its straight forwards, can be designed with bespoke designs and guess what… it just works :)

Give it a whirl, here is a demo account I created which is open for the next 15 days.

With the error trapping I’ve added in the 6 hour coding bender on Saturday, if it does go tilt (which it will do sooner or later[you won’t hear that from normal developers]) it’ll be obvious where it has gone Pete-Tong and as much as I’d love to boast about a few of the ways I’ve tackled some interesting features, I’m not going to and I’m just saying its “slick”.

This is the first time I’m publicly eluding to the fact that I’ve written API connectors from eSellerPro to 3rd parties and it’s not the first, more like the 4th now. I have CubeCartOpenCart & a web based EPOS solution next on my agenda for integration projects, oh and I have a sickly fast Magento integration.

Remember I’m aware the way and what data needs to flow between such tools and as I’m a perfectly capable coder in multiple languages, this is handy as I’m not BS’d by 3rd parties and also I’m realistic with timescales and what can and cannot be done.

If you’ve got a 3rd party integration requirement to eSellerPro/another provider or alternatively you’re interested in the eSellerPro to BigCommerce integration you can contact me here.

Internet Retailing Expo 2012

This year’s event was a weird one for me, I didn’t go to visit any stands, instead I attended to meet people and frankly if they didn’t know me already I didn’t pay them any attention. Instead, I got to speak to the cool people.

I did see one presentation though, it was the team from My1stWish & eSellerPro’s Eamonn, the recording is supposed to be released this week, I’ll pop it up as a post once it’s been made public.

After refusing to pay £34 to get home 2 hours earlier late on Thursday night, I grabbed a Sub & stacked up on more caffeine and there it hit me, the sickest idea I have had in years was conceived. I cannot believe it’s never been done before and you’ll facepalm when they see the finished product. I will be pushing for it to be released with a global free option for smaller businesses, more on this in the next few months.

Advanced eBay Listing Creation Tool Pending Upgrade

This one has been a programming nightmare for me, I didn’t know what was involved in getting this working until now & if I did I wouldn’t have started it.

The IF & IFNOT logic that powers the largest multichannel businesses is about to go mainstream and I’m only a few days away from adding it to the processing core of the advanced eBay listing builder.

If the IF & IFNOT logic testing is new to you, it’s a method to programmatically work with data to make the data you input such as images and bullet points show and hide if or if not they’re entered, which means you can break the listing data away from the template design that makes the listing look “pretty”.

An example is below, so that if {{Image1}} is blank it won’t bring through the image into the template.

[[IFNOT/{{Image1}}// <img src=”{{Image1}}” /> ]]

This is a basic example, as it’s normally better to load image URL’s into a JavaScript array, however, this will be available for ALL the data entry fields and I will be providing use-case examples shortly & support in the forums.

We’re due for some tutorials as well for the tool, the more people I talk to who cannot whose business does not warrant even the first stage tools, they need a tool like this to put the efficiency in their business for both data input and presentation.

I’ve not forgotten the integration into WordPress which will allow me to offer you some heavily customised features per user including customised listing templates, account defaults and… I now have the code finished for the killer feature that is missing from nearly ALL eBay listings which isn’t even a paid for addon by design companies and guess what it’s going to be… free. More on this as soon as the artwork is completed which will be under 2 weeks.

Summary

So a quiet two weeks for blogging, but I’m doing battle with a spoon, I can’t wait to explain what that means, maybe a video this week?

I’d like to thank those who have registered for the forums, if you haven’t yet, its free and you can register here and as you’ll see by the couple of recent threads, you’ll get quality replies back (amongst my gibberish :) ), see you there?

Advanced eBay Listing Creation Tool With Keywords

For a long time now that businesses that do not employ software tools that have keywords available to them are restricted by not being able to leverage them and simply their eBay listing process.

So I’ve created a simplified, yet advanced eBay listing generator that will allow you to use keywords in a standardised template that speed up your eBay listing process by enabling you to break your listing template away from the data you’re entering into it and use a simple tool to create eBay listings quickly.

If you’re not using 3rd party tools to list onto eBay then you may not have come across this concept before so I’ve included two extra sections to this article for you come up to speed with a way that will allow you to list more quickly & efficiently.

It also helps a few weeks back I created two videos in related articles that reverse engineer this process so that you can understand this process using a live eBay listing example and I’ve included the video’s in this article to help you.

What Are Keywords & Templates?

Instead of manually adding data such as item titles into each listing, in this process you create your template and leave a “keyword” behind such as {{Description}} where you would like your description to appear.

Then using the Advanced eBay Listing Creation Tool I’ve created, you just enter your description by itself, separate from the template and then press the huge button at the bottom and where you added the {{Description}}  keyword in your template, it’s replaced with your description.

Neat eh? This is exactly what larger businesses are using to list millions of items on to eBay each week, they’re separating their listing template from their data and using 3rd party tools to create those data rich listings.

So that’s exactly why I have made a simplified version for you to use that does not require the complexity or cost of using a 3rd party software tool.

An Introduction to Keywords & Templates By Example

In a two previous articles I reverse engineered both the eBay template being used and the data being used in that eBay template and I’ve included the video’s below for you to watch:

Reverse Engineering a Template Reverse Engineering the Data 

View on YouTube

View on YouTube

Keyword List:

To begin with I have created a common set of keywords for you to use, these are below.

Standard

  • {{Title}}
  • {{Description}}
  • {{Buttons}}
    This is a special keyword to create the buttons in your eBay listings for “Ask seller a question”, “Tell a friend”, “Watch this item” and “Add seller to favourites”. There is also another very special button I am working on and will be released once I’ve finished coding it.

Bullets

  • {{Bullet1}}
  • {{Bullet2}}
  • {{Bullet3}}
  • {{Bullet4}}
  • {{Bullet5}}

Images

  • {{Image1}}
  • {{Image2}}
  • {{Image3}}
  • {{Image4}}
  • {{Image5}}
  • And so on…
  • {{Image15}}

Future Additions

Now that I have got the tool beyond the proof of concept stage, I had to learn how JQuery & Ajax worked and also improve my PHP skills over the past two weeks, I’ll hand the project over to one of my developers and add in the additional keywords that I’d like to add.

Such as adding in your eBay shop link automatically, dynamic image galleries and wait for it…. logic testing (like in eSellerPro, see here for an example) so you can make eBay listings completely dynamic depending on what data you enter, plus CSV file exports for eBay File Exchange & Turbo Lister to make your eBay listing process as simple as possible!

While these are being developed, I’m going to work on integrating this listing generator more deeply into this site, so that as a registered user (free of course) you can set up a set of “default” options to make the listing process even faster for you and being supported in the multi-channel eCommerce forums I have also been developing.

eBay Listing Creation Tool

You can test the advanced eBay listing generator tool here.

Your Feedback

I know the current tool is basic currently (but it won’t stay like that for long), it has the potential to save you hours and help you create a standard listing process, so I have two questions for you:

  1. What do you make of the tool so far?
  2. Can you suggest any keywords that you’d like to see added?

Let me know in the comments box below

Will I be Seeing You at Internet Retailing Expo 2012 Next Week?

I’m excited about next week, I’ve blocked out two days in my calendar and the train is booked for IRX 2012!

What I would say is that I’m expecting the first day to be a little manic and I’ll be hitting the Cafe area around 12:00. On the second which should be a little more relaxed, I’ll be loitering there again and feel free to come over and have a chat. You won’t miss me and I’ll be standing out in orange.

If you would like to some quality one-on-one time, the second day is going to be better for myself (that’s the Thursday) and we’ll see if together we can make your multi-channel business rock! Bribery works wonders and I prefer my coffee black ;)

If you’ve not heard of the conference before, then it’s a free to register & attend event and out of the public conferences that I visited last year, it was by far the better one of them all. I added an article a few days ago for the event and you can read it here (and also see what I look like too). There is a whole host of workshops and presentations for both days the full list is here.

I’m really looking forward to seeing you there, pop over & say “hi” or “hola” or “howdy” I’d love to meet you :)

Will you be attending? Let me know in the comments box below:

Auto Creation of Logic Tested CustomFields in eSellerPro Using Excel

eSellerProCustomFields in eSellerPro is exceptionally useful, by their very title they’re “custom”. But to make the most from them, you’ll be needing to logic test them and hide the ones that are empty. That’s exactly what we’ll be doing in this guide.

I’ve created a CustomFields group called ‘Default’ and included a couple of standard fields. If you see the custom fields that are included, this really could be for any category of products that are used on eBay.

Group Name Name Display Field Type Display Order Visible Item Specifics
Default DF_Colour Colour 1 1 yes yes
Default DF_Dimension Dimension(cm) 1 1 yes yes
Default DF_Manufacturer Manufacturer 1 1 yes yes
Default DF_Material Material 1 1 yes yes
Default DF_MPN MPN 1 1 yes yes
Default DF_Type Type 1 1 yes yes
Default DF_Type_2 Type 2 1 1 yes yes
Default DF_Warranty Warranty 1 1 yes yes

 

Logic Testing

The issue is that when we list an item to eBay with these values, then eSellerPro is smart enough not to send the fields that have empty values, however in the description of your eBay listing (or Amazon profile or paragraph for that matter) so we need to logic test them.

Tip: Never use the CustomFields description tab to store descriptions, always use the paragraph builder.

To logic test them properly we need to wrap a statement around the fields.  There are three types of logic tests we can run these are:

  1. IF – If the value matches
  2. IFNOT – If the value does not match
  3. IFNOT/ELSE – If the value does not match and an alternative

I’m not going to cover how these logic tests work any further, I’ve already covered these in this article, so just roll with me on this one as I’ll be providing you an excel formula and example spreadsheet at the end of this article for you to use in your descriptions.

Using the table above as the example, if the colour is empty then ideally we’d not want to show it in the description area, so we would write the following:

{{IFNOT/[[CustomFields:Default:DF_Colour]]// {{CustomFields:Default:DF_Colour}} }}

Note: The “square brackets” are to stop forward slashes and other odd characters from breaking the value to check against.

That’s pretty easy to write one or two, but what happens when you have 10 or even 40 of them and how on earth do you cope with wrapping the contents into a table structure?

Easy, we use excel :)

Yep its really straight forwards in excel, but before we can do that, open your eSellerPro account and follow these steps:

  1. Go to Maintenance on the left menu
  2. Approximately 4-5 icons down click on “CustomFields”
  3. At the top there is an excel icon, press it
  4. Select the option called “Export all Custom Fields”
  5. Save the file to your desktop
  6. Open it

You’ll now have all the fields in your account. We are now going to edit this file and its really important that you do not import this sheet back into eSellerPro. Don’t do it, I’ve never tried it and I’d not like to do so either.

So in Cell I2, enter this formula:

=”{{IFNOT/[[CustomFields:”&A2&”:”&B2&”]]// {{CustomFields:”&A2&”:”&B2&”}} }}”

This will make something like this:

{{IFNOT/[[CustomFields:Default:DF_Colour]]// {{CustomFields:Default:DF_Colour}} }}

Sweet eh? Now grab the bottom right corner of cell I2 and drag it down. You now have the basic version which you can copy/paste to anywhere you like such as your eBay template, a paragraph, an Amazon template and so on…

Creating Tables

Creating tables using this method is a little more tricky but perfectly do-able. First we need to not that the following functions will not make the opening <TABLE> and closing </TABLE> tags, you’ll need to add these in afterwards, but hey the hard work is done by copy & paste :)

So this time instead of entering the formula above, we’ll use this formula in cell I2:

=”{{IFNOT/[[CustomFields:”&A2&”:”&B2&”]]//<tr><td class=’label’>”&C2&”</td><td class=’value’>{{CustomFields:”&A2&”:”&B2&”}}</td></tr>}}”

This will make:

{{IFNOT/[[CustomFields:Default:DF_Colour]]//<tr><td class=’label’>Colour</td><td class=’value’>{{CustomFields:Default:DF_Colour}}</td></tr>}}

If I spell out what the above is doing. If the value of DF_Colour is not blank, then bring in a table row (TR) and two table data cells (TD), the first with the display label and the second with the value.

Wrap these up in a table tag and we can end up with something that looks like this:

<table cellspacing=”0″ cellpadding=”0″ id=”customfields”>
{{IFNOT/[[CustomFields:Default:DF_Colour]]// <tr><td class=’label’>{{CustomFields:Default:DF_Colour}}</td></tr> }}
{{IFNOT/[[CustomFields:Default:DF_Dimension]]//<tr><td class=’label’>Dimension(cm)</td><td class=’value’>{{CustomFields:Default:DF_Dimension}}</td></tr>}}
{{IFNOT/[[CustomFields:Default:DF_Manufacturer]]//<tr><td class=’label’>Manufacturer</td><td class=’value’>{{CustomFields:Default:DF_Manufacturer}}</td></tr>}}
{{IFNOT/[[CustomFields:Default:DF_Material]]//<tr><td class=’label’>Material</td><td class=’value’>{{CustomFields:Default:DF_Material}}</td></tr>}}
{{IFNOT/[[CustomFields:Default:DF_MPN]]//<tr><td class=’label’>MPN</td><td class=’value’>{{CustomFields:Default:DF_MPN}}</td></tr>}}
{{IFNOT/[[CustomFields:Default:DF_Type]]//<tr><td class=’label’>Type</td><td class=’value’>{{CustomFields:Default:DF_Type}}</td></tr>}}
{{IFNOT/[[CustomFields:Default:DF_Type_2]]//<tr><td class=’label’>Type 2</td><td class=’value’>{{CustomFields:Default:DF_Type_2}}</td></tr>}}
{{IFNOT/[[CustomFields:Default:DF_Warranty]]//<tr><td class=’label’>Warranty</td><td class=’value’>{{CustomFields:Default:DF_Warranty}}</td></tr>}}
</table>

And the neat thing is that it took nothing more than a few minutes and copy/paste!

Reference File

I’ve uploaded examples of both of these to this file:

Useful?

Did you find this guide useful? Let me know in the comments below :)


Love Potions, Snake Oil & One Day Wonders

Multi Channel ConsultancyThis has been bugging me for a year or maybe more now for comment that was made in passing along the lines of “Matt, don’t make it sound like snail oil, you’re better than that“. So I have a short story to share with you.

That comment has stuck with me for well over a year now and I keep coming back to it.

The problem that I have is that unlike “traditional” consultancy where an individual or company will pimp themselves for a day and silly high rate, I know from experience that this just does not work.

The One Exception

I’ve only ever met one person called Andy who was able to take an obscene amount of information in and process it almost entirely in one hit.

This was a highly technical installation at eSellerPro back to back from 09:30 in the morning to completion at 17:30. The single reason the entire account didn’t go live was because we both decided that it was a better idea to not interrupt the weekend sales and to launch the following Monday, once everything had calmed down from the weekend sales.

Monday came and by that afternoon the entire business had moved across and I’ve just checked on Andy’s business and at a rough estimate, they’ve easily cleared at least 125,000 transactions in the last 12 months alone.

Out of the hundreds of people I’ve met & have had the pleasure of working with, that was the exception and even then it probably took an extra +30 hours to iron out the kinks which we created that day.

Information Overload

I “sponge out” after an hours instruction/discussion, most people are lucky to go for 40 minutes without hitting a limit to what they can take in. This why in reality, consultancy “days” are a complete fail for what I do. It takes time…

Time to thoroughly understand what actions need to be taken, to arrive at a process that is effective can sometimes take months to complete. If we throw in other skills that need to be learned by the parties involved, then…

this again doesn’t happen over night.

If I think about different Andy & a chap called Chris, we’ve spoken 20 or more times on a single project and they are (as am I) still working out the processes they need for their business and how to cope with variety effectively.

Last night I spent an hour with Paul to implement a new listing template, this has been in discussion for maybe 3-4 hours to arrive at the template version we deployed last night, but it doesn’t stop there, as the template is implemented we found that we needed to cover some image editing skills and also some basic HTML editing too.

One Day Wonders Fail

Acute issues can sometimes be solved in short amounts of time, sometimes with just a plaster to fix the issue. However plasters only go so far and rarely solve the underlying issue that caused it in the first place.

Let’s think about your eCommerce business for a few moments, could replicate the last 12 months work in a single day?  I bet it took, well 12 months to get to where you are now, some hefty long hours and if you’re anything like me enough coffee to drink Jamaica dry.

Multi Channel Consultancy PlasterAnd that’s is exactly why a single day or sticky plaster with a princess on it is a road to failure. If you’re thinking that a half day or even a full days consultancy might work for your business, I wholeheartedly suggest you walk away. The moment that door closes, the conversation is over, but the challenges that you face are continuous and ever changing.

It’s why I point blank refuse to work with businesses for a “day”, it doesn’t feel right and I know it’s not right because things change, they always do. Anyway, after 40 minutes, you’d be thinking of lunch, I know I would be too ;-)

  • So could you replicate even last week in a single day?
  • What are your thoughts on single days of consultancy?
  • Have you employed someone in the past in this manner, how did you find the experience?

Let me know in the comments box below.

Work With Matt to Maximise Your eBay Shop For FREE

Last year I offered the opportunity for 5 businesses to work with me for free for two months, I was blown away by the response and it actually ended up being six and we had an excellent time with some outstanding results.

ebay Shops LogoThis time around I would like to extend another free invitation to you on the topic of eBay Shops for up to 5 businesses. Size does not matter, if you’re really small, just started or have been trading for years, I’d love to hear from you.

I have a couple of questions for you, if you are saying yes to any of them, the application form is at the bottom of this page & I’d love to hear from you.

  • Have you ever wondered how you can maximise your eBay shop to its full potential?
  • Maybe you set it up months ago and have it on your to-do list and would like to revisit it?
  • Would you find value in a personalised & group 101 session on maximising the potential of your eBay shop?
  • Are you about to hit the subscribe button and open your eBay shop for the very first time?
  • Do you have some free time in the evenings over the next two weeks to tackle these issues head on?

What Exactly I am Offering

I feel it really important to stress that I have no affiliations with any design company and will not try and sell you any products or services. I am solely interested in creating the best guide possible and I will be adding a video of the invitation just for you next week.

The invitation is to work with myself and the other selected businesses & individuals as a group to improve your the effectiveness & appearance eBay Shop. The course will span approximately three to four hours over a period two weeks in a schedule similar to the below:

  • Meeting 1 – Introductions & eBay Shop Discussion
    You’ll not be asked to complete any silly introduction games. We’ll meet as a group & introduce ourselves to each other, have a chit-chat, identify common issues, questions, and concerns and note them for action in the next two meetings.
  • Meeting 2 – One on One Time
    This is where we get to work together one-on-one and address any questions you may have around your eBay shop and work together to action them.
  • Meeting 3 – Strategy
    With the basics addresses, set up a guide for you to follow. Remember there is no magic bullet, just hard work on both our parts. I am working on a creating a guide for us to follow for this.
  • Meeting 4 – Final Call
    Meeting as a group again, to re-evaluate our progress as a group and to share our experiences.

Our time together will really be what you make of it, I’ll do my best to help you where ever I can in relation to your eBay Shop. The meetings will span two or so weeks and obviously you’ll need to be available to join in for the two group meetings and the two meetings directly with myself.

I will be asking you to complete a short questionnaire before we start, with questions like who you are, what your business does and how you currently feel about your eBay Shop. This will give us the base to work from and a reference point to come back to at the end of the course, where I’ll ask you to complete another short questionnaire.

The Purpose

Let’s be very clear here, I am writing a guide titled “The Ultimate Guide to eBay Shops” and would like several case studies to included.

It’s not going to be of those crappy half-cut affairs, its really going to be the de-facto-standard for setting up and leveraging the eBay Shop as a sales platform.  The guide is going to have my name and face attached to it, so obviously I have a strong desire that it’s of the highest standards as possible, after all, it’s going to be directly representing myself & abilities.

The guide will be given away free on this site and my aim is that there will be zero advertising included, any tools or applications included will be free or based upon merit, not paid inclusion.

Restrictions & Terms

There are a couple of restrictions and terms, they’re pretty straight forwards, but need saying:

  • UK, USA & AU businesses welcome!
    The invitation is only open to companies and individuals that have UK, USA or AU based eBay Shops
  • Its not a replacement for bespoke design requirements
    This is not a replacement for bespoke custom design services. I will help if I genuinely can, however the design element is only one part of the eBay shop setup.
  • Sorry no REALLY big businesses
    This invitation is not open to businesses that are either enterprise or strategic eBay accounts
    (If you have no idea what these are, it doesn’t apply to you)
  • No need if you’re an existing client of Matt’s
    Existing customers of mine need not apply, we’ll work through this as a matter of course.
  • Good Spoken English
    You must speak excellent English and have access to a computer that has a stable Internet connection and a headset/microphone or access to a phone line.
  • 4 Hours Total
    We could talk for hours on the eBay shop, so a sensible limit is 4 hours total, this includes group time as well.
  • Be available in the evenings 
    You need to be available in the evening around 19:00 GMT on weekdays (this is 14:00 EST)
  • You’re OK with this being used commercially
    You’re happy with your eBay shop being used in such a guide, both front end and backend views being included (obviously no financial information) and agree to sign a waiver to any rights to the included content that may be used commercially (this is just to cover my rear as I intend to create a specific version for the Kindle).

I am a Design Company That creates Designs for eBay Businesses & Would Like to get Involved

This part is just for design companies.

I understand that you may be interested in being featured in such a guide, however, my primary concern with this is that I do not wish for the guide to be biased in any shape or form. I will be including numerous examples and if your work is of mentionable “merit”, then it will be naturally included.

However, I do have one requirement that you may be able to help me with and that is the cover of the guide. The guide is being created in Word in A4 landscape and may be ported to In Design for the final stage before publication. If you feel that you will be able to assist me in creating the cover that such a guide deserves, then use the application form below.

Closing Date

The closing date for this opportunity is:

Friday 16th March at 17:00 GMT

I will work through the applications on that weekend. If the response is anything like the opportunity last years attracted, this will take me some time to work my way through them.

However I will reply to you personally and please don’t take personally if you’re not selected, remember the final guide will be given away on this site and you will be able to benefit even if you’re not selected.

Application Form

I’d done my best to keep it as simple as possible and there is an edit box where you can add any extra information you feel is important. I’ll ensure that the five businesses that are selected are from non-competing product areas, so that we can keep the barriers of competition as low as possible.

As we’ll be using GoToMeeting to host the calls & screen sharing where required, at no point will I need your login details to any account and please do not include these as they’re not needed. You will not be added to any mailing list and I will reply personally to each application.

[contact-form-7 id=”4245″ title=”eBay Shops Form”]

Looking Forward to Working With You!

I’m really looking forward to working with you, if you have any comments or suggestions on how to maximise your eBay Shop then I’d love to hear from you and let me know in the comments box below.