June 18, 2011 - Comments Off on Database import tool

Database import tool

This tool presents the pre-processed product information we provide our members in a sortable, filterable way.

One click will bring a product into their site.

Toy data Import Tool - larger image

Newest items are at the top, which shows our clients that we've been busy on their behalf.

Columns to sort and filter by:

  •     Date (sort by Date, filter by Year) - The Importer is sorted by date by default, so you see the newest added products at the top.
  •     SKU (mfg prefix, + item number) - Filter by partial SKUs to get a range ("dj" in SKU and "Hotaling" in Brand shows all Djeco products).
  •     Product Name - Filter by partial name to see similar items. "Smen" in Product Name shows Smencils and Smens Pens, for example.
  •     Brand - Sort or Filter by manufacturer name.
  •     Category - Categories can be "mapped" to local site category names with the Import Mapping tool.
  •     UPC / ISBN / EAN (all in the same filter box) - UPC is the most common, ISBN is books, EAN is euro-UPC.

Kristopher Ives made this version of the Import Tool, based on his Inline Product Editor, Don Hays is the reason there's any data to import, and I made the help pages.

 

Published by: Philip Williamson in UX/UI

Comments are closed.