Managing the Square Connector in NetSuite Connector
This section discusses the following about Square connector:
Square Connector
The Square connector and NetSuite integration ensures data synchronization by seamlessly connection, eliminating the need for manual data entry and maintenance between the two systems. It enables businesses to automatically sync their Square transactions, including sales orders, payments and refunds directly into NetSuite. It supports fulfillment processes by allowing for the efficient management of orders and provides inventory sync support from NetSuite to Square, ensuring that stock levels are accurately reflected across both platforms.
Square Connector Syncs
This section consists of the following topics:
Order Sync
The Square Order Sync retrieves all POS, online and invoice orders from Square into NetSuite. POS orders are saved as Cash Sale in NetSuite.
Order Sync Settings
S no. |
Setting |
Description |
---|---|---|
1 |
Default NetSuite Item For Gift Cards Received in Orders With Blank SKU |
If any gift cards in an order arrive without a SKU, NetSuite Connector uses the default item specified here when retrieving the order from Square. If you do not provide a value, NetSuite Connector uses the default SKU "WebOrderGiftCard." |
2 |
Default NetSuite Item For Service Fee Received in Orders With Blank SKU |
If NetSuite Connector receives any service fee in an order without a SKU, it uses the default item specified here when retrieving the order from Square. If you do not provide a value, NetSuite Connector uses its default SKU for blank service fees. |
3 |
Default NetSuite Item For Quick Charge Received in Orders With Blank SKU |
If NetSuite Connector receives any quick charge in an order without a SKU, it uses the default item specified here when retrieving the order from Square. If you do not provide a value, NetSuite Connector uses its default SKU for blank quick charges. |
S no. |
Setting |
Description |
---|---|---|
1 |
Post Online Square Orders as Sales Order |
NetSuite Connector posts all Square orders as cash sales by default. Enable this option if you want to post online store orders as sales orders. |
2 |
Post Square Open Invoices as Invoices |
NetSuite Connector posts all Square invoices as cash sales by default. Enable this option if you want to post open invoices as invoices. |
Fulfillment Sync
The Square Fulfillment Sync exchanges routing requests with Square for fulfillment. When the orders are fulfilled in NetSuite, the fulfillment information is sent to Square.
Product Sync
When setting up the product sync, you need to map the following items:
-
Flag Field – defines the NetSuite field to be used as flag field.
-
Category – maps the category to the flag field.
Other fields like product description, price, quantity can also be setup as per requirement.
Product Sync Mappings:
-
Log in to app.farapp.com.
-
Select Square connector and then select the relevant account.
-
Go to Square > Mappings > Products
-
Select the Sync Type:
-
Price and Quantity Only
-
Full Product
Note:You can select only one sync type at one time.
-
-
Click Add Mappings.
-
Select the required mappings from the Required drop down.
Storefront Field
NetSuite Field
ITEM-category_names
custitem_fa_product_flag_shop
ITEM-name
displayName
sku
itemId
description_html
purchaseDescription
ITEM-tax_ids
taxSchedule.name
ITEM_VARIATION-name
displayName
ITEM_VARIATION-upc
upcCode
present_at_location_ids
location.name
pricing_type
custitem_fa_sqre_prce_type
price
stock_quantity
Storefront Field
NetSuite Field
Flag Field (default)
custitem_fa_square_flag
CATEGORY
PRICE
sku
itemId
stock_quantity
purchaseDescription
-
Click Save.
Note:If you have to use only the Price/ Quantity sync, you must disable the category sync by switching the toggle button for the Full Product sync.
Refund Sync
The Square Refund Sync all refunds from Square into NetSuite.
Field |
Description |
---|---|
Import Refunds created after |
The date and time till which you want to capture refunds for orders in the storefront. |
Quick Charge Refund NetSuite Item |
SKU field for quick charge refunds. |
Order Types in Square Connector
S. no. |
Order Category |
Order |
Description |
---|---|---|---|
1 |
Online |
Online Pickup |
The Pickup order type is used when you place an order online (or through another channel) and choose to pick up the items in person at a retail location rather than having them shipped |
2 |
Quick Charge |
Quick Charge is a way to process payments by simply entering a custom amount for a sale, without needing to itemize individual products or services. It's a streamlined method for quickly charging you a specific amount, useful when the sale is not tied to a predefined item in your inventory. |
|
3 |
Appointments |
Square Appointments is an online scheduling and appointment management tool created by Square. |
|
4 |
Online Store with Shipment |
E-commerce platform offered by Square. |
|
5 |
Invoice |
An invoice is an itemized list that records the products or services provided to you. Invoices can be paid in one payment or in installments. You can even schedule multiple payments on a single invoice. |
|
6 |
POS |
POS |
Software and hardware that allow businesses to accept in-person payments and manage sales. |