Shopify to Counterpoint Integration2020-08-06T19:01:06+00:00

Shopify and NCR Counterpoint Integration SyncApp by POS Highway

Unify your eCommerce and point of sale with POS Highway’s SyncApp. No time-consuming double entries, human input errors, just automation!

shopify-to-counterpoint-pos-integration
Download Shopify and NCR Counterpoint Integration BROCHURE

Request a Quote or Demo

Benefits of Shopify and Counterpoint POS Integration

Frequently Asked Questions

Does Shopify supply the whole end-to-end integration solution to NCR Counterpoint or is there something else that needs to be acquired.2020-05-26T20:47:41+00:00

CompuTant/POS Highway developed a custom integration between Counterpoint and Shopify, which communicates with the Shopify API. The end-user will need to purchase POS Highway’s SyncApp, along with professional services (setup, data migration, testing, and training).

As the end-user, you will also want to have someone to design your website, as well as a Shopify expert to assist in setting up the eCommerce platform and payment gateway. CompuTant/POS Highway does not currently provide these services, but we have partners who can assist with development. Contact us today to learn more.

How does the integration work? Are there any software components that need to exist on our user laptops, register, database server, etc?2020-05-26T20:47:36+00:00

With your Counterpoint and Shopify stores fully configured, POS Highway will install our SyncApp on your local or cloud-based server that hosts your SQL database. The SyncApp is a custom solution that allows Counterpoint’s database to connect with your Shopify store. Software components such as Counterpoint eCommerce module and Shopify SyncApp needs to be installed and configured on the CP SQL server.

Can items be transferred from Shopify to Counterpoint or it can only be done one way from Counterpoint to Shopify?2020-05-26T20:47:31+00:00

We recommend you make Counterpoint inventory your primary database, however, you can add products in Shopify, and new products from Shopify will be added into Counterpoint item/inventory. Our CP-Shopify SyncApp is a two-way synchronization application.

Is there any “master sheet” needed in order to transfer all the data between Shopify and Counterpoint?2020-05-28T19:07:38+00:00

No, you do not need a “master sheet” for CP-Shopify integration. Our SyncApp will handle the data synchronization and mapping between Counterpoint and Shopify.

When we transfer items from Counterpoint to Shopify, what information will be used?2020-05-26T21:54:21+00:00

Here is a list of Counterpoint product and online sales date/information our CP-Shopify SyncApp will transfer between Counterpoint and Shopify.

Item/Product Data

Customer/Contacts

All sales orders/invoices will sync from Shopify to CP

  • Additional Description 1
  • Item images
  • HTML description
  • Price-1
  • Regular price
  • Last cost
  • Vendor
  • Category
  • Collection 1 to 5 > Custom fields
  • Item grids (variants)
  • Qty-on-hand
  • Customer name
  • Last name
  • First Name
  • Address1,2,3
  • City
  • State
  • Zipcode
  • Email address 1
  • Phone 1
  • Ship-to address
  • Update tickets
  • Inventory
  • On-hand quantity
  • Customer purchase history
  • Sales reports
  • Inventory reports
How do syncing on-hand quantities happen if items are being purchased from both Shopify and our brick-and-mortar store? Do all quantity on-hand amounts move from Shopify to CP or just the sale item quantities where CP subtracts from its on-hand quantities?2020-05-26T21:54:16+00:00

The Shopify web store needs to be configured in Counterpoint as another store, let’s call it an “eCommerce” store. Inventory locations can be connected to your brick and mortar store inventory or you can set up a separate inventory location for Shopify. Either way, Shopify – CP sync app will post online and in-store sales/return/inventory transactions to the right location.

Is there a common frequency rate on the sync (i.e. 1, 5, 15, 30-minute intervals)?2020-05-26T21:41:44+00:00

The most common frequency is every three to five minutes. We can configure the data sync to your preference, but most clients prefer real-time or as close to real-time as possible.

Is the integration set up for CP or Shopify to be the system-of-record for consolidated sales reporting?2020-05-26T21:54:09+00:00

Shopify does not have the capability to manage your in-store sales, inventory, purchasing, and consolidated reporting. Therefore, Counterpoint is your primary system for all purposes outside of selling products online.

Is the integration set up for CP or Shopify to handle shipping/order fulfillment?2020-05-26T21:54:04+00:00

Online sales processing, credit card authorization, picking, packing, shipping, shipping labels printing, fulfillment will be handled via Shopify. POS Highway’s SyncApp will transfer completed invoices from Shopify to Counterpoint. The SyncApp will update sales, inventory, and all reports in Counterpoint as soon as the daily end of sales posting is completed.

What if I already have Shopify or Counterpoint (or both) fully configured?2020-05-26T21:53:47+00:00

For existing Counterpoint customers with new Shopify store: Initially, all items and customers data will be uploaded from Counterpoint to Shopify. Then after the initial upload, it will sync only new or updated/modified records from Counterpoint to Shopify moving forward. All orders/invoices will sync from Shopify to Counterpoint moving forward.

For existing Shopify store and new Counterpoint user: Initially, all items and customers will push down from Shopify into Counterpoint. Then it will only sync new, updated/modified records from Counterpoint to Shopify moving forward.

shopify-counterpoint-pos-controls

NCR Counterpoint and Shopify Control Module Screenshot

The most powerful Shopify to Counterpoint integration on the market

  • Designate eCommerce inventory location, store, station, and drawer
  • Control which entities sync, and how they sync
  • Control sync based on your fulfillment practices

Over 40+ Mappable Fields

Keeping data consistent is important, especially between two parallel systems. We ensure your Shopify data makes it to Counterpoint, and vice versa, so both systems are always in-sync.

Sync from Counterpoint to Shopify eCommerce:

  • Item #
  • Item name
  • Department/Category Name
  • Manufacturer
  • Description
  • Image
  • Price – Regular and Sale
  • Sales price
  • Color
  • Size
  • Quantity
  • Style Matrix
  • Collections
ecommerce counterpoint

Sync from Shopify eCommerce to Counterpoint:

  • Order Number
  • Customer Bill To name
  • Bill to Address
  • Customer Ship To Name
  • Ship to Address
  • Email address
  • Phone Number
  • Item code and variants
  • Item quantity
  • Item Price
  • Discount Amount
  • Row total
  • Gross Total and Tax

Our Clients

Testimonials

We are now in love with the features of Counterpoint, and are always planning what to do next with all the features that are available.

We can offer over $100,000 in discounts yearly because of Counterpoint’s extensive report library, giving us a competitive edge.

Counterpoint enables you to track real-time sales and analyze how items are moving at each store.

Mike Spitzer, Bohme

Retail blog articles

Go to Top