Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
eBay Title Character Count
Richard Meldner
Miami/Ft. Lauderdale Area
Member
August 16, 2014 - 7:32 pm
Member Since: May 3, 2014
Forum Posts: 325
sp_UserOfflineSmall Offline

We know that M2E Pro will adjust the eBay title to 80 characters if it is too long. If you import products via CSV, it is very easy to run a quick Excel formula counting the length of the eBay title field column, but what if you enter some product by manually.

So I found this handy little extension for Google Chrome.

https://chrome.google.com/webstore/detail/word-count-tool/ibjgdahgcdkpdlbkadidojhfddflblcm?hl=en

With it you can highlight the text, right click on the text and use the context menu to select the extension and it will give you a quick character and word count in a pop up box.

Here is a quick video about it

http://youtu.be/SwvtMQbWN_A

You have to start with a plan to know what you will be deviating from.

Managing Petty Tyrant: mdiperformance.com

Joe Mills

Excellent
August 17, 2014 - 4:11 pm
Member Since: January 28, 2014
Forum Posts: 48
sp_UserOfflineSmall Offline

That’s a great find Richard. I use notepad++ for my ebay descriptions as I usually combine about 3 different methods and notepad++ will highlight when I’ve used the same word twice, so it helps me avoid duplications.

Avatar
Dave Furness

Founder
August 17, 2014 - 6:58 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey Richard,

Nice find, I know before now I have seen an if/if not rule used in excel to highlight when e eBay title field was over 80 chars.

In fact sounds like something Matt may have shown me years and years ago.

Dave

Every expert was once a beginner

Richard Meldner
Miami/Ft. Lauderdale Area
Member
August 17, 2014 - 7:25 pm
Member Since: May 3, 2014
Forum Posts: 325
sp_UserOfflineSmall Offline

I often have created eBay titles in bulk from product attributes in Excel.

In Excel, my favorite way to check length is a adding a column next to the eBay title with this formula.

=if(len(cell))>80,”WARNING “&len(cell),len(cell))

cell being the cell reference like B3, D3, etc.

Since I often dealt with hundreds or even thousands of listing titles, I would then use the Excel filter function to show only the rows that had the word WARNING and adjust those titles to fit. That is why I added the length of the cell (title) after the word WARNING so that I would know how many characters I had to manually trim from the title.

I also used this method to sort or show low title length numbers. This way if for example my title length was below 60 characters, I would manually extend the title with phrases like “Authorized Dealer”, “Free US Ship”, or other descriptive product attributes not used by my Excel title generation formula.

Richard

You have to start with a plan to know what you will be deviating from.

Managing Petty Tyrant: mdiperformance.com

Avatar
Dave Furness

Founder
August 18, 2014 - 10:27 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

From memory Richard that is exactly what I was thinking of :)

Dave

Every expert was once a beginner

Dima

Excellent
December 20, 2015 - 12:23 pm
Member Since: April 13, 2015
Forum Posts: 26
sp_UserOfflineSmall Offline

How about using this extension Attribute Character Limit?
http://www.magentocommerce.com…..limit.html

Badeth - UE
Member
December 22, 2015 - 6:08 am
Member Since: October 23, 2015
Forum Posts: 513
sp_UserOfflineSmall Offline

Thanks for sharing, Dima

Dima

Excellent
December 22, 2015 - 11:41 am
Member Since: April 13, 2015
Forum Posts: 26
sp_UserOfflineSmall Offline

I actually would like to find some kind of programmatical solution for that problem.
There are many magento users out there who list on ebay with m2e pro but can’t buy a 30$ extension for every simply issue that occurs!
All we want is to count or limit one attribute field to 80 characters,and counting it with google app is not a good practice.
There are many php code examples that can help but can you tell me to what file on my FTP server should i add them?
Where do i find the attribute files?
Thank you

Badeth - UE
Member
December 26, 2015 - 4:06 pm
Member Since: October 23, 2015
Forum Posts: 513
sp_UserOfflineSmall Offline

Hi Dima,

I understand that some people don’t want to spend money for a single extension that solves a simple issue.

Here’s a related forum thread https://understandinge.com/forum/ebay-integration-questions/ebay-title-attribute-script-to-limit-characters-to-80/

Can you give Stephen Maguire’s suggestions a try?

Badeth

aw tech
Guest
December 27, 2015 - 1:21 pm

If that was just a form field in a file you could add maxlength to limit it

If your attribute code was ebaytitle in the source it would look like

<td class="value">
<input id="ebaytitle" name="product[ebaytitle]" value="" class="input-text" type="text">
</td>

this should limit it to 80

<td class="value">
<input id="ebaytitle" name="product[ebaytitle]" value="" class="input-text" type="text" maxlength="80">
</td>

But when looking at magento this same input is used for every attribute that is text, so for me if I edited it with maxlength I would limit about 40 fields (including the standard magento name field)

this is a bad example because I didn’t need anything fancy just wanted to see how hard it was.. but finding the input later to set the attribute seems to work fine

document.getElementById("ebaytitle").setAttribute("maxlength", "80");

this would find the ebaytitle input and add maxlength 80, just needs to be somewhere towards the bottom of that page after the form, I put it at the end of

app/design/adminhtml/default/default/template/catalog/wysiwyg/js.phtml

because I found it loading on the product edit/create page in our magento dev toward the bottom

I changed

//]]>
</script>

to

document.getElementById("ebaytitle").setAttribute("maxlength", "80");
//]]>
</script>

And I couldn’t enter more than 80 in that input field. Again a crude example that may not even work outside of our magento install but hopefully gives you an idea of the complexity of the task.

Badeth - UE
Member
December 30, 2015 - 5:59 am
Member Since: October 23, 2015
Forum Posts: 513
sp_UserOfflineSmall Offline

Aw Tech, it’s nice of you helping Dima
@Dima, Have you tried those suggestions?

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
19 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5223

Posts: 27502

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606