Hello Susan,

Here's how I would map your list with the current fields in Inventory:
  • attribute_set - I don't really know what an "attribute set" is, but perhaps a Report Group could be used to group like items together.
  • category_ids - We support unlimited Category codes
  • Name - Item description
  • image / small_image / thumbnail - We support a single image. A naming convention (such as appending "thumb" to the name would provide the rest
  • url_key / url_path - An optional field
  • manufacturer - An optional field
  • Color - Either an item segment or an optional field
  • Category specific attributes - I don't understand the type of information that would be stored here and what the relationship is to the item accounting for the item
  • long_description - Item notes, perhaps with a specific user id
  • short_description - Additional comments. 4 x 75 character fields in each item
  • product_name - Item description

External systems will always have item data that they are looking for. An alternative mapping is to take the fields in the external system and map them to the necessary information needed in Adagio Inventory. Then, the addition of an item in the external system results in a new item being imported into Adagio Inventory.

Defining these relationships is the role of your Adagio Consultant. It's one of the services they offer.
_________________________
Andrew Bates