Item Data Import File Format


The column headers in your import file must match the Edge fields you wish to update.  If you started with an Edge item export, then your file is already formatted properly.  However, if this data is coming from another source, you will need to rename the column headers to match the schema of our database.

The import data must contain either the Edge item number with the column header itKey or the vendor and vendor style with the column headers itVendorID and itVendStyleCode.

When importing data and matching on Edge item number it will be a one to one update meaning each row in your import file will update one specific item in the Edge.

When importing data and matching on vendor / vendor style it will be a one to many update meaning each row in your import file will update all items in the Edge that share that same vendor / vendor style combination.

The following fields can be updated:

itDesc Description from the General tab
itMetalColor Metal Color
itMetalFinish Metal Finish
itMetalType Metal Type
itSize Size
itStyle Item Style
itRetailPrice Retail Price
itLowestPrice Lowest Price
itCurrentPrice Current Price
itMfg Manufacturer
itLength Length
itMillimeter Millimeter
itFolioNumber Folio Number
itVendBarCode Vendor Barcode
itSerialNumber Serial Number
imTitle Web Title
imMetaTitle Web Meta Title
imMetaKeywords Web Meta Keyword
imMetaDescription Web Meta Description
imDescription Web Description
imWebTags Web Tags
itDetail_1 – 16 Custom details, see the export documentation for more information
imDetail_1 – 8 Custom details, see the export documentation for more information

Example - Item Key

This example would update the web title, web description, and web tags on these three specific items.

itKey imTitle imDescription imWebTags
001-100-00001 Engagement Ring This is a ring. Ring
001-200-00001 Colored Stone Ring This is a ring. Ring
001-300-00001 Pearl Ring This is a pearl ring. Pearl

Example - Vendor/Vendor Style

This example would update all Edge items for vendor ABC that have vendor style Bracelet-123 with new pricing information.

itVendorID itVendStyleCode itRetailPrice itLowestPrice itCurrentPrice
ABC Bracelet-123 750 500 750

 

Updated on Fri, 20 Oct 2023 by Angela Chiaravalle

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?