Sync inventory, pull sales information, sync products to and from Square. Square can also be used just to process payments without managing inventory.
- Familiarity with the Processing a Sale process (necessary)
- Familiarity with Products and Product Management (necessary)
- Square Integration Setup
- Orders and Sales
- Operation Logs
Square Integration Setup
First you must connect DEAR to your Square store.
It is possible to link several Square stores to a single DEAR account. Each linked store has independent catalog, logs and settings.
To connect Square to DEAR:
- Navigate to Integration -> Square
- Click the + to connect a new store.
- Click Connect to Square to be directed to the Square website and log in.
- You will asked to connect your Square account to DEAR Inventory and allow access.
- Once permissions have been allowed, you will be redirected back to DEAR.
- Repeat these steps to connect as many Square accounts as you require
Square can be used in two ways - to Load Sales and Process Payments or Process Payments alone. If Process Payments alone is selected, many of the following settings are not present, see below:
If the Square integration is set to Load Sales and Process Payments, many more integration settings can be customised in the Setup tab.
This option specifies when a Square Order will be captured: when it is created or when it is paid in Square. This setting is also taken into account when downloads of historical orders from Square are triggered.
DEAR - Square Integration allows two options for order consolidation.
No Consolidation indicates that sales will be captured from Square as they occur. Daily Consolidation will consolidate all orders from that day into a single order. When Daily Consolidation is chosen, an additional setting becomes available: Consolidation Time. This is your local time when all pending orders aggregated during the day will be processed.
See Pending Order Processing section for more details below.
For the pending order processing to be successful, an existing customer must be selected.
When Consolidation Type is Daily Consolidation, this customer is used to create a new sale task which will combine all daily sales. A customer can be created in DEAR just for this purpose.
Choose which Price Tier to use as the default price when DEAR syncs products with Square.
Pick, Pack and Ship Processing Mode
When pending orders are processed by DEAR new sale tasks are created. This setting tells DEAR if it should try to Auto Pick, Auto Pack and Auto Ship these tasks. If there is not enough stock on hand to pick the full quantity of products in an order, then pick will remain in Draft state and Pack and Ship won’t be completed.
DEAR does not pick up shipment information from Square if auto-ship is selected and will not create fulfilment in Square in this scenario (if Auto Ship is enabled).
Square does not allow use of multiple warehouses. Each Square store can have a dedicated Location within DEAR which can be selected from the drop down menu. Selecting a particular warehouse will limit the availability of stock in Square to that location. The default option, All Locations, will display consolidated stock quantities across all of your locations.
You can control Invoice Status for Sale tasks created as a result of pending order processing. By default, Invoice will not be authorised and will be in Draft state, adjustable and waiting for authorisation. However if this setting is changed to AUTHORISED the invoice will be automatically authorised and pending sync will be created for it to sync with accounting application of your choice.
Gift Card Liability Account
DEAR will use this Liability account instead of a Revenue account for Gift Card sales. This account should have ability to accept payments. If a sale is made which contains a gift card, this sale will remain in the Pending Orders area until Gift Card Liability Account is specified.
Optional revenue account
Revenue account to be used for all sales downloaded from Square. This will override settings at the Product/Customer level and any other Account mapping.
Sales Representative Name
This option allows the shop name to be used as Sales Representative.
Update Stock Levels in Square
You may choose to disable automatic stock level update in Square performed by DEAR at the time available product quantity changes in DEAR. This may be useful if you are managing stock level in Square manually and do not want DEAR to change it. Please ensure you have the correct stock quantities entered in DEAR before you turn on this option as these values will override the stock quantities in Square.
Sync product categories with Square
You can enable DEAR to push category and brand information to Square and update DEAR with Square category information.
Tax Rule Mapping
When pending order is processed by DEAR, a sale task is created. Each order and invoice line is assigned a tax rule. The tax rules specified in these settings will be used to create these lines.
DEAR does not apply the tax rule to recalculate tax and is simply using the actual tax amount from the Square order. This means that if certain products are not Taxable or with varying tax in Square, all data and totals in DEAR will look identical to Square, but with DEAR tax rule name selected in this setting.
In case of tax recalculation Tax amount will be overwritten with value calculated by DEAR Taxation rule.
IMPORTANT: Orders will be skipped on download if Taxation mapping not finished!
Payment Account Mapping
DEAR can capture payments made against orders in Square and is able to automatically add payments to a created sale invoice. To do this, Payment Account Mapping must be completed on this integration settings screen. You must choose an account which is able to receive payments from the chart of accounts.
This setting is not mandatory - if payment mapping is not completed, orders are still captured and downloaded from Square, but payments must be manually added to invoices in DEAR. Some customers prefer to keep invoices open and then reconcile them with payouts from Square.
Disconnect from Square store
When you disconnect from Square store, DEAR removes all associations between DEAR objects and Square, including Log and Product Catalog.
The DEAR Square Catalog page allows user to Download products from Square, break the link between a DEAR product and its Square listing and update quantities in Square according to DEAR available stock.
Products can be loaded from Square to DEAR in the Catalog tab by clicking Load Products. This operation may take some time.
There are two types of product in Square: simple product and product with options (these have child SKUs).
DEAR will not create a Product Family when loading Square products as Square products are lacking information regarding option names/values.
If products are already created/linked with Square then DEAR updates existing products instead of creating new versions. In Square SKU is an optional product field whereas in DEAR it is mandatory. DEAR requires all SKUs to be specified for all Square products and variations. All products with missing SKUs will be skipped (not loaded) from Square.
When a product is created or updated in DEAR during download process, a link is established between product and variant unique Square ID and DEAR unique product ID. This link is used when products are matched against sale order lines in Square and when subsequent product downloads occur.
When downloading products, DEAR tries to match existing products first to avoid creating duplicates.
During product download DEAR automatically creates required product categories.
Data mapping for products between DEAR and Square is as follows:
|Family Name||Product Name|
|Product Name||Product Name + Variation Name (unless Variation Name already contains Product Name)|
|Price Tier. Default is Price Tier 1||Price|
|Image (first default image). Existing images won't be deleted. ||Image (existing image won't be overwritten).|
|Track Inventory (DEAR will enable it for new products created by DEAR. It won’t change thesetting for existing products)|
There are two possible statuses for products in the Catalog: Not Listed and Listed.
NOTE: Updating products from the catalog will update the stock level in Square regardless of the related Quantity update setting status.
To list a product on Square:
- Click on the product in the Catalog tab.
- You can enable or disable stock level syncing at the individual product level.
- Click List on Square
- Save your changes
To unlist a product on Square:
- Click on the product in the Catalog tab.
- Click Unlink
- Save your changes
To remove a product from Square:
- Click on the product in the Catalog tab.
- Click Remove from Square
- Save your changes
As well as listing products individually, products can be listed in bulk.
To list products on Square in bulk:
- Go to the Bulk Listing tab
- Select products to upload in bulk. You can select products by Category, Family, Product Tag, Price Tier, Listing Status and through manual search.
- Click Start to upload all selected products.
Orders and Sales
Processing Pending Orders
When a Square store is connected to DEAR, automatic notifications are triggered when orders are created or modified.
Depending on the Order Capture setting selected, DEAR will capture a Square Order and save it as pending order when the Order is created or paid.
Whenever a sale is captured from Square it is first placed into Pending Orders, and stock is allocated immediately. DEAR imports new orders immediately as individual sale orders (if No Consolidation is selected in the Integration Settings) or once a day as a consolidated sale order (if Daily Consolidation is selected).
If No Consolidation is selected, each Square sale is converted into an identical sale in DEAR, keeping the same customer and shipping information. If Daily Consolidation is selected, the single daily sale task will use the customer selected in the integration settings, and customer, billing and shipping information imported from Square will be ignored.
When processing orders, the logic is identical to that of the DEAR UI. DropShipping, Kitting and other important scenarios are implemented in the same was as through the DEAR UI.
Pending Orders can be processed manually by clicking Process. They can then be viewed in the Log tab.
Downloading Orders and Payments
Orders are automatically downloaded if their status in Square is changed (for example, a customer pays for an order).
NOTE: Generally, you do not need to trigger manual order download, however if an order was not captured by DEAR or to load historical sales you can use manual Load Order option.
Any imported order is saved to the Pending Orders section. It is a temporary storage of all sales and payments in DEAR. If an order already has an entry in the Log (i.e. was imported previously) it will be skipped. This guarantees that no duplicate sales will be created by DEAR.
While saving orders, DEAR captures customer information, billing and shipping addresses. All line items are captured together with quantities, prices and totals. Total order discounts are applied as are additional charges to the whole order, without distribution by lines to reduce the chance of discrepancy.
Tips and gift card sales are also saved as additional charges in Sale invoice. Square has special Tax Rules for these additional charges and you can also link these with DEAR Tax Rules on Setup tab.
If a Payment Account has been specified in the Integration Settings, DEAR will always assign associated payments to the captured Square orders.
When a Square order is cancelled, DEAR automatically finds and voids the corresponding sale task if already created as a Sale Order or just removes the associated pending order if not yet processed.
The final step in the order download is to trigger update of stock levels in other Square stores and other connected eCommerce channels.
Updating Fulfilment in Square
When Shipment is authorised in DEAR and the carrier specified, DEAR will try to create order shipment information in Square. This will only work in No Consolidation processing mode.
Each captured Square order once saved to Pending Orders creates a Log entry to track the link between the Sale in DEAR and in Square. This eliminates the possibility of creating duplicated orders when capturing the same order several times during manual order load.
Each Log entry has a link to the sale task in DEAR. Depending on the settings selected by the user in the Setup tab, this sales task could be draft or authorised, one or more of the Pick, Pack and Ship tabs could be authorised, and payment could have been applied to the invoice.
Log entries allow you to see which Sale task reflects a particular Square sale. You also have the option to delete a Log entry manually. This will allow to reprocess an order if required. Deleting a log entry will not void or delete its associated sale task.
Reloading Orders from Square
If for any reason you need to reload an order from Square, this can be managed from DEAR.
To reload an order from Square:
- Void the sale task. A record of this will be kept in DEAR for reconciliation purposes but the transactional data will be deleted.
- Return to the Square integration Log tab and delete the Log entry. This will allow the order to be recaptured from Square.
- Navigate to the Pending Orders tab and click Load Orders, making sure the date is set to before when the order to reload was made.
Each time when user or DEAR downloading sales appropriate record added to operation log. It also contains information about results of downloading, including the count of processed, skipped or cancelled orders.