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 |