Product Data

Introduction

Modern Retail's integration with the RICS point of sale system uses a JSON feed to get new products and product updates. This feed is used to create products in Shopify, BigCommerce, WooCommerce, and Magento, as well as, update the inventory and pricing of these products on your website. This article explains the data fields we get from RICS and which ones are used by Modern Retail's integration.

Product Feed

The table below is all the data we receive from the RICS JSON product feed. The items in GREEN are the fields used by our standard integration. The item in BLUE is not part of our standard integration but may be used. Finally, items in GRAY are not used.

NOTE: The data in this feed is combined with the data we receive in the Price and Inventory Feeds.

Field	Description	Data Type	Use	Notes
IntegrationID	Unique ID for every product variant.	Unique Identifier	Required	This unique identifier is a GUID.
Brand	Brand or Supplier Name	String	Optional
CustomData	Custom Data Field	Array	Optional	Not included in standard integration but may be used.
Category	Full Class Path	String	Optional	Not used
GridColumn	Product Variant	String	Optional	The size/width/color depending on RICS setup.
GridRow	Product Variant	String	Optional	The size/width/color depending on RICS setup.
DisplayOrder		Integer	Optional	Not Used
SKU		String	Required	Not Used
SKUStyle		String	Optional	Not Used
SupplierSKU	Stores parent/child relationship.	String	Optional	SupplierSKU ties products together, like an ALU.
UPC	Universal Product Code	String	Optional	The most recent UPC assigned to this variant.
ShortDescription	Short Description	String	Optional
LongDescription	Long Description	String	Optional
Color	Variant Color	String	Optional
Price		Decimal	Required	Not Used. See Price Feed.
RetailPrice		Decimal	Optional	Not Used. See Price Feed.
ListPrice		Decimal	Optional	Not Used. See Price Feed.
ProductId		Unique Identifier	Required	Unique ID for the SKU. Not Used.
QuantityOnHand	Inventory	Integer	Optional	Not Used. See Inventory Feed
AllUPCs		String	Optional	A list of all UPCs assigned to this size. Not Used.

Price Feed

This is the Price Feed we receive from the RICS JSON API.

Field	Description	Data Type	Use	Notes
IntegrationID	Unique ID for every product variant.	Unique Identifier	Required	This unique identifier is a GUID.
Brand		String	Optional	Not Used
GridColumn		String	Optional	Not Used
GridRow		String	Optional	Not Used
SKU		String	Required	Not Used
SupplierSKU		String	Optional	Not Used
UPC		String	Optional	Not Used
Prices		Array	Required	Not Used. See Price Feed.
PriceType	Type of the price.	Integer	Required	Retail Price and Sale Price.
Amount	Dollar Amount	Decimal	Required
StartDate	Start date of retail or sale price.	Decimal	Optional
EndDate	End date of retail or sale price.	Decimal	Optional

Inventory Feed

This is the Inventory Feed we receive from the RICS JSON API.

Field	Description	Data Type	Use	Notes
IntegrationID	Unique ID for every product variant.	Unique Identifier	Required	This unique identifier is a GUID.
Brand		String	Optional	Not Used
GridColumn		String	Optional	Not Used
GridRow		String	Optional	Not Used
SKU		String	Required	Not Used
SupplierSKU		String	Optional	Not Used
UPC		String	Optional	Not Used
QOH	Quantity on Hand	Integer	Required	Not Used. See Price Feed.
StoreItems	Inventory Information	Array	Required
StoreCode	Store Location	Integer	Required
OnHand	Location Quantity	Integer	Required

You can read more about our integration with the RICS POS system on our website.

Please submit a Support Request in the Admin Panel if you have any questions. Thank you.