This article will break down SKU IQ's Order Syncing feature and how you locate sync orders on your POS system.
Quick Navigation Menu
What synced orders look like and where to locate them
Overview
Order Sync is an optional feature offered by SKU IQ that allows you to send records of completed invoices from your eCommerce to your Point of Sale (or from Point of Sale to your eCommerce). This reporting feature can help you keep all of your data in one spot for easy reference.
Keep in mind that order syncing can only be enabled in one direction, meaning that we can only translate your order data from eCommerce to Point of Sale or vice versa.
This feature is currently available for POS connections such as Square, Clover, and Lightspeed R-Series, for eCommerce we can only support it on Shopify at the moment.
If you are using SKU IQ's TikTok Shop and Shopify integration, the information in this article will not apply to you, so check out this article for more information on how order sync works for social commerce.
Depending on the integrations, invoices can take up to 12 hours to sync across, so we do not recommend this feature for businesses looking to facilitate food delivery or pick-up in-store. Don't worry though, order sync works independently of stock quantity sync, so it will not affect real-time syncing for quantity changes!
How Does Order Syncing Work?
When an online order is marked as paid on your chosen platform, SKU IQ will identify the online order data and create a copy of that data on the other side. You'll find that copied invoice in the Orders section of your Point of Sale or eCommerce platform, though some terminology may be different, we'll break down the specifics for each integration later in this article.
For customers with multiple physical locations on their POS system, manual fulfillment will need to be enabled to facilitate order processing, please check this article for more information.
π¨NOTE: When order syncing is enabled, users must manually update quantities when a customer returns or exchanges an item, return or exchange invoices are also not synced across, so you'll need to manually cancel/refund the synced invoice.
If you are interested in enabling order syncing for your account, please contact Support as this feature is not enabled by default and requires different setup steps depending on which platforms you are using.
Check out the frequently asked questions section for more information.
What synced orders look like and where to locate them
Clover POS
When an online order is placed, SKU IQ will sync the data for that order over to your Clover Web Dashboard within 20 minutes. Unfortunately, you will not be able to see the Order on your Clover Terminal at this time.
SKU IQ sends the following data for each integration:
Data Field | BigCommerce | Shopify | Wix | WooCommerce |
Subtotal | β | β | β | β |
Total | β | β | β | β |
Discounts | β | β | β | β |
Taxes | β | β | β | β |
Date | β | β | β | β |
Line items | β | β | β | β |
Customer Data | β | β | β | β |
** Click the data field to go to an explanation of what that field is **
A typical order will look like this on your Clover Web Dashboard:
π‘Tip: SKU IQ will be unable to sync what type of payment method was used to Clover, it will simply say "External Payment". You will need to find the payment method information from your eCommerce website if that information is relevant for your account.
π‘Tip: Orders that have synced from your website will have the web tag on them - which is found just under the customer's name on the order details page.
β Jump back to the integrations table.
Lightspeed Retail R-Series
When an online order is created on your eCommerce website, SKU IQ will identify the online order data and copy it to the Sales History page on your Lightspeed Retail R-Series dashboard. You can find the Sales History information under the Sales tab. Orders can take up to 12 hours to sync.
In order to set up Order Syncing, we will need you to set up an Employee name to accept these orders (we usually suggest "ONLINE ORDERS" as the employee name) as well as a payment method to assign to the orders (e.g. credit card, debit card, PayPal, etc.).
SKU IQ sends the following data for each integration:
Data Field | BigCommerce | Shopify | Wix | WooCommerce |
Subtotal | β | β | β | β |
Total | β | β | β | β |
Discounts | β | β | β | β |
Taxes | β | β | β | β |
Employee | β | β | β | β |
Date | β | β | β | β |
Line Items | β | β | β | β |
Customer Data | β | β | β | β |
** Click the data field to go to an explanation of what that field is **
A typical order will look like this on your Lightspeed Web Dashboard:
π‘ Tip: SKU IQ will sync the payment method you have indicated will be used on your website (credit card, debit card, PayPal, etc.) only as the form of payment.
π‘ Tip: Web orders will be indicated by the Employee you have told us to assign to eCommerce orders.
β Jump back to the integrations table.
Square POS
When an online order is marked as paid on your eCommerce website, SKU IQ will identify the online order data and copy it to the Transactions page of the Square web dashboard. These orders can take anywhere from 1 to 30 minutes to sync.
SKU IQ sends the following data for each integration:
Data Field | BigCommerce | Shopify | Wix | WooCommerce |
Subtotal | β | β | β | β |
Total | β | β | β | β |
Discounts | β | β | β | β |
Taxes | β | β | β | β |
Date | β | β | β | β |
Line Items | β | β | β | β |
Customer Data | β | β | β | β |
** Click the data field to go to an explanation of what that field is **
A typical order will look like this on your Square Web Dashboard:
π‘ Tip: Payment information will not be synced from your eCommerce platform to your Square. Payment will say that it was collected at another location and that it was purchased with Debit or Credit. SKU IQ cannot send what type of credit card or debit card was used (e.g. Visa, Mastercard, etc.).
π‘ Tip: Orders from the web will be named by what items were purchased on that transactions. You will also be able to know where an order came from by taking note of the Order Source which will say SKU IQ when you click in to a transaction to see the full details.
Shopify eCommerce
Shopify has the unique ability to receive order data from your Point of Sale as well! We recommend that you choose to have your orders synced from your Shopify OR your Point of Sale - not both. Orders placed from your Point of Sale can take anywhere from 1 minute to 12 hours to sync.
SKU IQ sends the following data for each integration:
Data Field | Clover | Lightspeed Retail R-Series | Lightspeed Retail X-Series (Vend) | Square POS |
Total | β | β | coming soon | β |
Taxes | β | β | coming soon | β |
Discounts | β | β | coming soon | β |
Line Items | β | β | coming soon | β |
Shipping Address | β | β | coming soon | β |
Customer Data | β | β | coming soon | β |
** Click the data field to go to an explanation of what that field is **
A typical order will look like this on your Shopify Dashboard:
π‘ Tip: Payment method will not be synced to Shopify. The order will indicate that has been paid in full and that it has been fulfilled.
π‘ Tip: If Customer Name and e-mail address was not captured in the Point of Sale, that data will not populate in Shopify as it does not exist.
β Jump back to the integrations table.
Data Field Definitions
This section explains what each data field in the charts above means.
β Jump back to the integrations table.
Subtotal
This is the transaction's total prior to applying an discounts and sales tax(es).
Total
This is the transaction's final total after applying discounts and sales tax(es).
Discounts
Discounts are usually performed as a coupon code that you have provided the customer to use either via an email or a discount that would be applied throughout the site for free shipping, a percentage off throughout the site or on certain categories, etc.
Taxes
This is the sales tax field. It will show any applicable sales taxes for your area or where the customer purchased from.
Date
The date in which the order occurred.
Line Items
This is a list of all of the merchandise that was purchased on the transaction as well as the quantities of those items that were purchased.Customer Data
Customer data includes name, email address, and physical address if captured at time of purchase. When syncing an order, SKU IQ will attempt to locate the customer within your database (so that duplicates of customer data will not occur) and then associate the new transactions with that customer. In the instance of Shopify, only the name and email address are sent for this field.
Employee
This is a special field for Lightspeed Retail R-Series users. This field indicates that the order was made Online and assigns the employee field to which ever employee you've told SKU IQ to assign online orders to.
Shipping Address
This field is specific to Shopify. This is the customer's shipping address (not necessarily billing address).
Frequently Asked Questions:
These are some of the most commonly asked questions about order syncing.
β Jump back to the integrations table.
β Can I See These Synced Orders On My Point of Sale Terminal?
In some cases, you can see this data on your Point of Sale hardware, but that may rely on your POS's plan, hardware, and even user clearance. If that does not apply to you, you can check synced orders on your platform's online dashboard.
β Does a notification pop up on my Point of Sale when I get an order in?
We are unable to notify you via your Point of Sale terminal when you receive an eCommerce order. We recommend reaching out to your POS/eCommerce provider to explore their notification options.
β Why Can't I Sync Orders from my Point of Sale to my eCommerce?
We currently only support order sync to the Shopify eCommerce. This is due to limitations with the API clearance of BigCommerce, Wix, and WooCommerce. We hope to change this in the future though.
β Why do I have to manually adjust my inventory when I take a return when I have order syncing on?
This is due to limitations with the APIs of our partner platforms. We're working on a solution for future versions of SKU IQ, but do not have one ready quite yet.
β When I have order syncing on, do the orders it copies count double toward my order count for my subscription?
No! SKU IQ only counts the original order towards your total order count for your subscription.