Benefits of Shopify and Counterpoint POS Integration
Frequently Asked Questions
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.
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.
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.
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.
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 |
|
|
|
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.
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.
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.
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.
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.
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
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
Specialty Retail
Apparel
Jewelry
Wine & Liquor
Attractions & Museums
Lawn & Garden Center
Gift & Novelty
Tobacco & Vape
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.
Retail blog articles
Guide to Inventory Reporting for Your Retail Business
If you own a small business, then you might often neglect the significance that inventory reporting upholds. Inventory reports are the […]
Increase Your Business’s Profit Margins – 3 Tips for A Better Profitability
Keeping track of your business’s profit margin and your return on investments is one of the most crucial ways to determine […]
Restaurateurs Guide to Attracting Generation Z
Today’s generation and the younger ones growing up have never lived in a world sans Snapchat and hashtags. Social networking is […]