Syncing Your Products with Square

If you have both a Square account and a BigCommerce account, you can use our Square Point of Sale integration to bring over your products and stock levels. Our integration allows you to import Square products into BigCommerce, export BigCommerce products into Square, and utilize automatic two-way syncing to keep accurate inventory count.

 

Can I use Square as a payment gateway? If you want to allow your customers to check out using Square Payments, you can do so by following these steps. However, you do not need to be using Square Payments in order to sync your inventory with Square.

How does it work?

This integration lets you export products from BigCommerce into Square and import products from Square into BigCommerce. Only products that don't already exist in the receiving platform will be created.

The following product details will be brought over:

  • Product name
  • Image
  • Description
  • Category (since Square does not support nested categories, only the top-level category will be passed to Square)
  • Price
  • Inventory/stock level
  • Options (including stock level and price) - must be associated with SKUs

A maximum of 25,000 SKUs can be transferred between BigCommerce into Square at a time. Note that stores importing or exporting more than 5,000 SKUs will experience significant delays.

Note that UPCs will not be exported into Square from BigCommerce, because Square does not have a dedicated UPC field.

Inventory Syncing

The Square integration features real-time stock level syncing between BigCommerce and Square. Here's a quick guide to how the stock level syncing works.

  • Order-based stock level changes in BigCommerce will update Square's stock levels in real-time
  • Order-based stock level changes Square will update BigCommerce's stock levels in real-time
  • Manually updating stock levels in BigCommerce will update Square's stock levels in real-time
  • Manually updating Square's stock levels will NOT update BigCommerce's stock levels

Requirements before Syncing

Product names — Before starting, make sure none of the products already in your BigCommerce store have the same name as the products you're importing from Square. Having products with duplicate names may result in product information coming over in a manner you don't intend.

Variation names — Variation names are required in Square in order to import SKUs into BigCommerce.

Currency — Currently our integration works with CAD, EUR, GBP, NZD, and USD. If you are using a different currency, please visit our Ideas site and request this feature in your currency.

Connecting to Square

1. Go to Store SetupPoint of Sale.

2. Click Connect.

Connect button

3. You will be asked to sign in to your Square account. (If you don't have one, you can create one from here too.) If you have more than one location with Square, you'll be asked to pick which location you want to connect with BigCommerce. Currently only one location can be linked per Square account.

4. Click Allow to allow BigCommerce to access your Square data.

Permissions

5. Your Square account is now linked to BigCommerce.

Importing and Exporting Your Products

1. Click Import/Export.

Square Import/Export

2. You'll be asked whether you want to do an import (products from Square will be added to BigCommerce) or an export (products from BigCommerce will be added to Square). Select one, then click Continue to begin the sync.

Import Export action

3. The import or export will begin. Depending on how many products you have, this might take a while. Feel free to navigate away; the process will keep running in the background.

4. Once you're done, you'll see a success message.

Success message

5. To enable real-time inventory syncing between Square and BigCommerce, turn on the Stock Updates toggle. You can activate or deactivate this setting at any time.

Stock Update toggle

6. Go to ProductsProduct Categories. Check to see if you have a category called Uncategorized Square Items. If so, follow the instructions in Categorizing Square Products.

Categorizing Square Products

After your import, go to ProductsProduct Categories. You may find a category for Uncategorized Square Items, which contains any products from Square that did not have a category specified. If you have this category, follow the steps below.

1. Click ActionProducts. This will take you to a view of all of your products in the Uncategorized Square Items category.

  • If you have several products and would prefer to recategorize them with an Import/Export, see Updating with Import/Export
  • If you prefer to quickly recategorize them in bulk through the control panel, continue to Step 2.

2. Select your products by clicking the checkbox at the top left. Click Choose an ActionBulk Edit Selected, then click Confirm. You will be taken to the bulk edit page.

Bulk Edit Selected

3. Under the Category column, select the product's new category in BigCommerce. Once you’ve made all of your changes, click Save and Exit.

Bulk Edit Categories

Recategorizing with Import/Export

1. From the ActionProducts screen, select all of your products by clicking the checkbox in the top left.

2. Click Choose an ActionExport These Products, then click Confirm.

Export these products

3. Export the products using the Bulk Edit template. You can see full export instructions here.

4. Go through the Category column to recategorize your products. For more information about entering category information into a CSV, take a look at the Categories field in Importing Products.

5. Import your revised CSV file. The products will be reassigned to their new categories.

Disconnecting your Square Account

If for any reason you want to disconnect your Square account from BigCommerce, you can use the following steps. Note that if you disconnect your Square account, you will need to reimport and export your products to reactivate stock level syncing.

1. Go to Store SetupPayments and click on the Square tab.

3. On the Square setup page, click Disconnect Square Account. You can reconnect again later by completing the steps above.

Disconnect Square

Video Walkthrough

https://www.youtube.com/embed/pOaLt4_kPTA

Was this article helpful?