Ron's Editor for e-Commerce

Increasingly over the last few years we have noticed that a large portion of our customers are made up of people running e-commerce web sites. Usually these sites are a based on a commercially available e-commerce platforms such as one of those shown below.

We discovered that our customers are using Ron's Editor to maintain and upload their product lists to their e-commerce sites, and we began to notice the pattern as more and more requests and questions came to us for e-commerce related issues. More often than not people would start using Excel, which whilst an excellent spreadsheet, is not well suited to handing CSV files, which is the data format of choice for e-commerce platform upload.

Some Problems People Have With Product Upload

Many users are regularly confronted with errors and issues generated by the maintenance and the update of product or SKU (Stock Keeping Unit) lists, orders or customer lists, costing them a lot of time and energy.

Most of these issues can be either avoided or solved quickly by simply using a CSV Editor, like Ron's Editor. Ron's Editor is a CSV Editor that allows to manipulate data in small or large CSV files in an easy and flexible way.

Over time we have accumulated a list of the problems our customers used to have, and we have compiled a list below, along with the solution(s) possible with the Editor.

Errant Commas, and Illegal quoting

It goes without saying that a professional CSV editor can output properly formatted CSV text files.

Unusual Characters

Lines can often be rejected during upload for containing unusual characters:

  • Apostrophe ( ' )
  • Grave accent ( ` )
  • Parentheses ( )
  • Square brackets []
  • Hyphen (-)
  • Period (.)
  • Comma (,)
  • Colon (:)
  • Ampersands (&)
  • Quote Marks (")
  • Asterisks (*)

Ron's Editors toolbox contains tools to clean cells of all sorts of detritus, with live preview so you can see what will happen.

Duplicates

Duplicate codes and descriptions can cause rejects at upload time, and if they don't then they can make your site look a little unprofessional.

Ron's Editor can remove rows containing duplicates automatically, or the Summary View and Filtered View can be used for a more considered approach.

Blank/missing entries in required fields

Ron's Editor can remove rows containing blanks automatically, or again for a more considered approach, the Editor can quickly sort rows so that blank entries can be instantly seen, or, for a more sophisticated approach, the Filter View can be used to show all rows containing blank fields.

Columns Without Data

Columns can be deleted with a single mouse click, or easily filled with the same entry, or with more varied entries using some of the more powerful fill tools.

The Advantages of Using Ron's Editor

In addition to solving problems with stock lists the Editor has some nice features that stand out, and make life easier for e-commerce users (or any users for that matter).

It is a Text Editor

Ron's Editor is first and foremost a text editor, not a spread sheet, or other data manipulation tool. It just does text, so it understands text encoding (like UTF-8), and does not try and change your dates and numbers into other formats. In fact it does not change anything at all, unless told to.

Ease of Use

Its fast, and easy to use, making working with it actually pleasant. A lot of time has been spent making the power that it has easily accessible.

HTML Features

Over time we have added features to Ron's Editor that specifically help e-commerce activities:

  • External HTML cell editors can be configured and used
  • A cell preview window that can display HTML directly (in the cell) or links to external sites (good for checking)
  • Toolbox rule to remove the text from an HTML snippet

Export to Excel

If an e-commerce platform absolutely must use Excel for product list uploads, then Ron's Editor can of course export to a well formatted Excel spread sheet.

Why Do Our Customers Uses Ron's Editor?

Because it looks nice? Because it's fast? No!

It saves them hours, and hours, of their time.

We are also very interested in our customer's feedback, so if you have any ideas for enhancements, please contact us.

For a list of features see the Ron's Editor home page .

Ron's Editor - Ultimate CSV Editor

Learn more

Ron's Renamer - Powerful Batch File Renamer

Learn more

Ron's HTML Cleaner - Easy HTML Processing

Learn more