CheckIn has the ability to integrate with your existing, or newly created Shopify website. Currently, CheckIn's Shopify integration supports the following:
  • Automated syncing of Products from CheckIn -> Shopify
  • Automated Collections and Tags syncing from CheckIn -> Shopify
  • Automated Order pulldowns from Shopify -> CheckIn. Orders fulfilled on your Shopify site will then be converted into Invoices in CheckIn, adding any payments made on the order.
  • Automated pulldown of Customer information on Orders from Shopify -> CheckIn. This requires a non-Basic Shopify plan. See the next section for details.
There are only three basics steps to going live with Shopify in CheckIn, all outlined in this document:
  1. Setting Up Your Your Shopify Integration Settings
  2. Product Pulldown
  3. Activating Shopify Sync
Things to Consider Before Proceeding
The integration setup process is very simple, however there are a few things to consider and discuss before moving forward. 

For example, the onboarding process may differ depending on whether you are new to Shopify or already have an existing Shopify store. For a new Shopify store, it is as easy as setting up the integration and selecting which products to sync up to Shopify.

However, if you have an existing store, CheckIn has the ability to do a one-time pulldown of all your products AND collections from Shopify to CheckIn. This process will take all of your Shopify products and create them in CheckIn. If a product already exists in both Shopify and CheckIn, it will "link" them together for future syncing. Therefore, it is important that your data in Shopify is as cleaned up as possible before starting this Product pulldown process. It is recommended that you delete as many Archived products as you can. (if they won't be sold again) This also applies to Collections. See Pulling Down Products and Collections section for more details on this process.

Another consideration is which Shopify Plan you will be using. CheckIn's integration with Shopify works no matter which plan you have. However, please note that if you are subscribed to the Basic plan, due to Shopify's API limitations, any Orders that are synced from Shopify into CheckIn will NOT include customer information and you will need to enter that manually. Aside from that, it is up to you which plan is more convenient for you.Image Placeholder
Depending on your business, selling in fractional units is something else that needs to be considered. For example, if you are a quilt shop, you might input your fabric as yards into CheckIn, but may want to sell that fabric online in 1/8th yard increments. See Selling in Fractional Units on Shopify through CheckIn for more information.

Finally, consider your future workflow when fully integrated. Once Shopify integration is activated in CheckIn, all new Products and Collections must be created exclusively in CheckIn and synced with Shopify. Any modifications to Products must also be done from CheckIn. In Shopify, the focus should be limited to fulfilling and processing orders and letting those sync into CheckIn. See Utilizing Shopify Integration with CheckIn for a more in-depth view on the Checkin -> Shopify workflow.

Please contact CheckIn Support at support@checkinpos.com if you are considering integrating with Shopify or if you have any questions about the setup process.

Setting Up Your Shopify Integration
To begin, log into your Shopify store admin page. If you are are a new Shopify user, you will have to create a new store and subscribe to a Shopify plan.

Next, navigate to your Shopify Settings and get your Shopify store name. This will typically be the name of your store, but sometimes it will be a random set of letters and numbers.

Image Placeholder
Next, navigate to the company setup screen. Insert your store name in the Shopify Store Name field, located in the Shopify tab.
Image Placeholder
Then, return to Shopify to continue the configuration.

You must now create a CheckIn Developer App within Shopify to obtain an API Access Token by doing the following:

  • In Shopify, go to the Settings page. Click on Apps and Sales Channels.
  • At the top right of this section, click on Develop Apps.
  • Click the Create An App button. Enter the name CheckIn and then click Create App.
  • You should now be in the App Development -> CheckIn App screen
  • Click on the Configuration tab.
  • Click on the Configure button for the Admin API Integration.
  • Now select EVERY access scope available. There will be about 38 to click on. When done, click on Save.
  • Navigate to the API Credentials tab and click the Install App button you see in the first section called Access Tokens.
  • Click the Install button on the window that pops up.
  • Now in the Admin API Access Token section at the top, click Reveal Token Once in order to see your token. You can only reveal this token ONCE. If you do not copy it the first time you reveal it, you won't be able to see it again. This will result in you having to repeat the steps above.
  • Copy the token.
  • Go back to CheckIn's Company Settings section and go to the Shopify tab. Paste the token into the API Access Token field.
  • Enter 2024-01 in the API version field. (see screenshot above for example)
  • If the Log API Calls checkbox is selected, click to uncheck it. This feature is used by the CheckIn development team to debug any issues that may arise with Shopify.
  • If you want the Cost and Price of Products updated in Shopify any time you change them in CheckIn, make sure the Update Cost/Price checkbox is checked.
  • Click on Test Access. Expand the pop-up box to see the full message. You should receive a pop-up with information about your store, such as the store name, address, etc. If you receive an error please contact Checkin Support.
  • Next, ensure that each of your CheckIn Store Locations match the locations specified in Shopify by clicking on the Click Here To Do That button in CheckIn.
Image Placeholder

Make sure that you have a matching location in Shopify for each location you have in CheckIn.

Click on the Check Shopify Locations. If all is setup correctly, you will see that Shopify Location IDs are now present in CheckIn

Image Placeholder
Once all of that is populated, you have completed the first step of your Shopify Integration. Next, you will handle pulling down your products and activating your Shopify sync. Please reach out to CheckIn support before beginning the next step to ensure the pulldown is as smooth as possible.

Pulling Down Products and Collections
If you have an existing store, CheckIn has the ability to do a one-time pulldown of all your products AND collections from Shopify to CheckIn. This process will take all of your Shopify products and create them in CheckIn. If a product already exists in both Shopify and CheckIn, it will "link" them together for future syncing.

Depending on your product count, this process can take several hours. Typically, this process will pulldown about a thousand products per hour. During this time, you will not have the ability to use CheckIn from the computer you have triggered the Product Pulldown from. To check the number of products on your Shopify, click the Get Product Count button. Keep in mind that this process will pull down ALL products, regardless of whether it is sec to Active, Draft, or Archived, so it is important to clean up as many of your products on your online store as possible.

NOTE: IF YOU SELL IN FRACTIONAL UNITS ON SHOPIFY, BEFORE PULLING DOWN PRODUCTS, make sure you define your Default Base Selling Unit in the corresponding department in CheckIn. Failure to do this will result in product cost, pricing and stock to be incorrect. If you use Sew Much Commerce on your Shopify site, this also applies to you and you MUST set the Default Base Selling Unit for each department that will be sold as fractional units. See Selling in Fractional Units on Shopify through CheckIn for more information.

To start the pulling down process, click the Pull Down Shopify Products button. You will be prompted for the starting product id. On the first go, you will simply enter 0.

When pulling down products from Shopify, the integration will do the following:

First, it will check to see if the product has been downloaded from Shopify already. It does that by looking for the Shopify primary key in CheckIn. If it's not found, it's safe to assume that the product hasn't been pulled from Shopify. 

Despite that, the product still might exist in CheckIn. So CheckIn does check to see if the product can be found by searching Product_Code, Barcode_UPC and Old Barcode Field. If it finds an exact match, Checkin will link the Shopify product to that product in CheckIn. 

Once your CheckIn Products have finished pulling down, you can begin pulling down your collections by clicking the Pull Down Collects button. This can only be done once your product pulldown has completed. Please note that Smart Collections will not pull down with this process.

Setting up CheckIn to Sync with Your Shopify

The most powerful feature with CheckIn's Shopify integration is the syncing of Products, Collections, Customers and Orders. 

To activate the syncing, CheckIn uses a server-side script that runs every 15 minutes. This process will automatically trigger CheckIn to find products in CheckIn that have changed or are new and push those changes to Shopify. It will also push up any Collections created in CheckIn. Lastly, it will pull down Orders and the customers on the orders into CheckIn. 

There are a couple of things you must do prior to turning on the activation. 

IMPORTANT - If you are integrating a Shopify store that has been active, you need to specify the Last Order Pulled in the Shopify Settings. To get the last order id that was pulled, you need to login to Shopify, go to orders and click on the most recent order. 

When you do this, the url at the top of your browser will reveal the order id. Please see image below:

Image Placeholder
Copy this number and paste it into the Last Order Pulled field in CheckIn. See image below:

Image Placeholder

Activating the Shopify Syncing for CheckIn. 

Go to your CheckIn server computer and log in to the Claris FileMaker Server Admin Console and perform the following steps:

  • After logging in, click on Configuration and then on Script and Verify Schedules.
  • Next, click on Create Schedule
  • For Schedule Type, leave it at FileMaker Script
  • For Schedule Name, enter Shopify Sync
  • For Database, select CheckIn. For Account, click on Account Name and Password. Enter in your CheckIn Account name and Password.
  • For FileMaker Script, select the serverside_Shopify_sync
  • For Scriptparameter, enter the Store ID of the location/store you want to Sync. NOTE: If you have multiple stores, you will need to setup a schedule for each store
  • For Repeat, select Daily. Leave Start Date as is. Under Time, select Between and specify the time range you want CheckIn to be syncing with Shopify. Lastly, for Repeat Every, enter in 15 minutes. 
  • Click Save
Checkin is now set to automatically sync with Shopify. 

Flagging Products to be synced to Shopify

When you create a product in CheckIn, it is not automatically flagged to be on Shopify. You must tell CheckIn that you want the product on Shopify. 

To set up a product to be on Shopify, do the following. 

Go to the Product in CheckIn. You should see a Shopify button on the top right. Click on it. 

To flag the product to be on Shopify, click the Put on Shopify check box. 

Upon doing this, you will see that several fields are automatically filled in. 

Adjust the information to fit what you want to see on Shopify. IMPORTANT, if you want the product to be available to order from customers on Shopify, make sure you change the Status to Active

Unfortunately, you cannot specify Collections until the product has been added to Shopify. 

Creating Collections

Collections are a way to group products on Shopify. Collections should be managed in CheckIn. 

To create a Collection, go to the Product Dashboard, click More and then click Define Collections. A list of Collections will appear. 

Click on a Collection to modify it. 

Click on New Collection to create a new collection. 

Make sure the Publish on Shopify checkbox is selected. 

NOTE: A collection cannot be selected for a Product until after the Product is created on Shopify. 

Adding Multiple Products to a Collection

There is a super powerful way to add multiple products to a Shopify Collection. To do this, simply perform a search to find the products you want to add to a collection.

For Instance, find all Products that are in the Fabric Department and are on Shopify:
Image Placeholder
After performing the Find, you will have a list of Found Records. 

Click on Options > Assign Foundset to Existing Shopify Collection

Image Placeholder

You will then be presented with a window where you can select the Collection. 
Image Placeholder

When you select the Collection and click the Add to Foundset, CheckIn will go through each product record in the foundset and add the collection. These products will then be flagged to update on Shopify.

Please allow up to 15 minutes for you to see the changes on Shopify. 
 
Processing Orders in Shopify

Orders placed on Shopify will be pulled down into CheckIn, however, you will not be able to process the order from within CheckIn. 

You will need to use Shopify's interface to process your orders. 

The the Checkin Syncing integration will update the downloaded orders in CheckIn as you process them in Shopify. 

Things to Know

Gift Cards/Certificates are NOT synced. If you have a gift certificate/gift card that was sold in CheckIn, it can NOT be used on your Shopify web site at this time. Inversely, if a gift certificate/card is purchased in Shopify, it cannot be used in CheckIn. 

To remove a product from Shopify, simply change the status in CheckIn to Draft or Archived

Do NOT add products or collections via the Shopify interface if you are using the CheckIn-to-Shopify integration

Taxes are calculated in Shopify, however, a product is flagged as taxable or not in CheckIn

Shipping is calculated in Shopify, therefore, it is important to specify product weight in CheckIn

You can jump right to products or orders in Shopify via buttons that appear in CheckIn once the product is added and once the ordered is pulled down. 

Changes that happen in CheckIn to products should automatically flag your product to be updated on Shopify. Remember that it may take up to 15 minutes before the change gets pushed to Shopify. 

When receiving an Order in Shopify, if the products on that Order are not in CheckIn, the Order will not be pulled down into CheckIn.

If you want to see Shopify and/or PayPal payments in your End of Day report, please add those as payment buttons. Example:

Image Placeholder