Help & Resource Center

CounterPoint Ecommerce Item & Integration Data

Overview

The objective of this article is to give you an understanding of the data that can be sent from CounterPoint to your Shopify, BigCommerce, WooCommerce, or Magento website.  Modern Retail will work with you during our onboarding process to "map" the CounterPoint data to the correct fields on your website.

To get started, it might be helpful to understand the overall process flow first.  If you take a look at the diagram below, you'll notice that Products move from CounterPoint to your Magento, Bigcommerce, Shopify or WooCommerce website.  You'll also notice that Orders & Customers move in the opposite direction from Magento, Bigcommerce, Shopify, or WooCommerce to CounterPoint.

The focus of this article is around Products, and which data is sent from CounterPoint to your website.

CounterPoint-Integration-Overview.png

Main Product Data

Modern Retail can send a variety of product data from CounterPoint to your website. Below you will see a variety of fields in yellow, which all be sent to "mapped" to fields in your Shopify, BigCommerce, WooCommerce or Magento website.

Ecommerce Item

Determining which products from CounterPoint get sent to your website is the job of the Ecommerce item flag.  Checking this box tells our CounterPoint Integrator that you'd like this item sold on your website.  You must check this box if you want to sell the product online.

ITEMS-ECOMMERCE.PNG

TIP: If you intend on sending most of your catalog to your website, you might want to talk with your CounterPoint reseller to automatically set this option by default.

Description Fields

The following Description fields can be sent from CounterPoint to your website. 

  • The Description field below is typically used to populate the Product Name on the website. 
  • The HTML description field shown above, or the Long description field shown below, are typically used to populate the description field on the website.  
    • While not as frequently used, we can also send the Short description, Additional description 1, Additional description 2, and Additional description 3 fields to your website.  We have the ability to send up to two of these description fields and map them to attributes on your website.

ITEMS-DESCRIPTION.PNG

Gridded Products

We also send over the gridded items from CounterPoint and create the associated product variants on your website.

ITEMS-GRID.PNG

The two most common variants are size and color, but our integration supports whatever values have been entered into CounterPoint, using up to 3 dimensions.

Quantity

The inventory sent to your website is taken from the Qty available field in CounterPoint.

CounterPoint-Quantity-Available.PNG

Prices

Of course, it would be very difficult to sell something if it didn't have a price, so those can be mapped as well!  CounterPoint supports 7 different prices, and typically at least 2 of the following fields will be mapped to your website pricing:

  • Retail Price
  • Sale Price
  • MSRP (optional)

However, any of these 7 pricing fields can be mapped to your website.  Therefore, if you wanted to use Price-6 as a special "web-only" sale price, no problem, we'll map that field to your website sale price.

ITEM-PRICES.png

As you would imagine, changing the price in CounterPoint will automatically change the price on the website as well.  Most websites show both the retail price and sale price together, and very often cross the Retail Price out when the item is on sale, like below.

 

Planned Promotions

Sale Prices can also be managed using CounterPoint's Planned Promos.  Planned Promotions give you the flexibility to specify a start and end for the items you want to put on sale on your website.

counterpoint-planned-promotions.png

Additional Product Data

Modern Retail supports a variety of additional fields from CounterPoint, which can all be mapped to attributes on your websites.

Inventory by Location

Sending inventory from your various locations is something Modern Retail has been doing for years, and is used in conjunction with our In-Store Pickup, Local Delivery, and Ship From Store features.  We can also send inventory for your various locations to certain ecommerce platforms, most notably Shopify.

CounterPoint-Inventory-by-Location.png

Non-Inventory Items

Non-Inventory items from CounterPoint can be sent to your website and have been useful in all kinds of situations such as the selling of classes, instructions or tickets.

CounterPoint-Non-Inventory-Items.png

Vendor Name & Number

If you sell a lot of brands or designers in your store, you may want to map the Primary vendor name or Vendor's item # to your website.  This can be helpful when merchandising these vendors on your website, like with a "shop by brand" section.

CounterPoint-Vendor-Name-Item-Number.png

Barcodes

Modern Retail's CounterPoint Integrator will also send the Barcodes from CounterPoint to your website.  Typically, these barcodes are used to store UPCs for your products and are vital for marketplaces such as Amazon or Google. Modern Retail will take these CounterPoint barcodes and map them to UPCs on your website.

ITEMS-BARCODES.PNG

Profiles

Profiles are a great way to extend the functionality of CounterPoint by allowing you to store valuable information that's unique to your store.  These Profiles can also be mapped to values on your website. Need to populate something specific from CounterPoint on your website?  No problem!  Just populate the Profile field and let us know where you'd like the value to be stored on your website.

ITEMS-PROFILES.PNG

Bin Locations

CounterPoint has four separate bin locations, which can all be sent and mapped to attributes on your website.  These bin locations are often useful for larger customers who operate a warehouse and need to use these bin locations to instruct people where to pick the item.  These bin locations can also be sent to 3rd party shipping tools, like ShipStation.

CounterPoint-Bin-Locations.PNG

Costs

Some customers have asked us to send one of the three cost fields from CounterPoint:

  • Average cost
  • Standard cost
  • Last Cost

Simply let us know which cost you'd like sent from CounterPoint, and where you'd like it mapped on your website.

CounterPoint-Costs.PNG

Account Code

We can also send the Item Account code from CounterPoint and map it to an attribute on your website.  

CounterPoint-Account-Code.PNG

As always, please don't hesitate to submit a support request in our Admin Panel if you have any questions.  Thank you.