Help & Resource Center

API Product Data Fields

Overview

Modern Retail has been integrated with Tri-Technical Systems AIM since 2012.  The initial integration with AIM was done by moving XML and CSV files back and forth over FTP.  However, with the release of AIM v12, the integration is now done using their Application Programming Interface (API).  This article describes the product fields we get from AIM using this approach.

AIM Product API

Modern Retail gets products from AIM by using their GetActiveE3PartyRequest call, which you can find here:

As you can see, this call has a lot of data values that have been added over the years to support different services.  Obviously, not all of these data points are being used by Modern Retail.

Product Data Fields

The following product data fields are being used with Modern Retail's integration between AIM and your Shopify, BigCommerce, WooCommerce or Magento website.

  • Model
  • Sku
  • Desc
  • Barcode
  • Color
  • Size
  • MPN
  • LocationQtys
  • Qty_Available
  • Cost
  • Our_Price
  • Retail
  • Min_Price
  • Price_A
  • Price_B
  • Price_C
  • AE_Sale_Price
  • Weight
  • WCost

These are all the product data fields Modern Retail currently pulls and maps to your website.

Please submit a support request in the Admin Panel if you have any questions.  Thank you.