Shopify B2B
Shopify B2B Connector
The Shopify connector also supports order syncs and fulfillments from Shopify B2B to NetSuite. It is intended for Business to Business (B2B) selling and supports the following functionalities:
-
Invoice Posting:
It automatically generates invoices in NetSuite upon order synchronization. It supports advanced configurations like pre-fulfillment invoicing, capturing deposits or partial payments based on Shopify settings. It provides detailed financial tracking by syncing terms such as Net 30, deposits, and payment milestones from Shopify into NetSuite.
-
Subsequent Payment Handling:
The payments processed in Shopify are automatically linked to the corresponding invoices in NetSuite. Future enhancements aim to incorporate bi-directional payment syncing for scenarios where payments originate in NetSuite.
-
Posting Customer Deposits:
If you enable the new PostCustomerDepositForShopifyB2B setting, the B2B orders from Shopify no longer create an invoice + payment in NetSuite at import time. Instead, the connector creates a sales order in a 'Pending Approval' status.
The connector posts a customer deposit for the exact amount you paid in Shopify. It leaves the remainder of the order un-invoiced so you can partially fulfill lines and invoice only when you ship.
The subsequent payments made in Shopify (for example, when additional items are fulfilled or as staggered payment terms hit) will generate further Customer Deposits in NetSuite. This aligns the order-to-cash process with standard B2B workflows-supporting Net 30/60/90 terms and partial shipments-and preserving end-to-end financial visibility.
Shopify B2B Syncs
Shopify B2B syncs the following data to NetSuite and NetSuite to Shopify B2B:
B2B Order Synchronisation
It exclusively syncs B2B orders from Shopify to NetSuite and enables differentiation from B2C orders. It has backward compatibility which enables you to sync B2B orders through existing configurations with specific backend flags if you are a legacy user.
Company Sync
This new sync enables the sync of customers that are in company section of Shopify B2B to NetSuite. Each of the companies listed have customers as buyers which are synced to the company and are synced to NetSuite as sub customers.
Integration with Payout Sync
The B2B Order Sync feature integrates seamlessly with the Payout Sync and ensures:
-
Accurate tracking of payment reconciliation.
-
Comprehensive financial visibility for B2B transactions across platforms.
Synchronizes financial data in tandem with order and invoice updates to maintain end-to-end data consistency.
Order Sync
It initiates order creation and creates customer record in NetSuite. It syncs order status and other order updates.
Reverse Order Edit Sync
It synchronizes B2B order updates from NetSuite to Shopify, allowing any changes such as item or quantity updates made in NetSuite to be posted back to Shopify B2B.
You must enable the following settings for the reverse order sync to work properly:
-
PostOrderModificationsToShopify (Account Detail)
-
AllowNetSuiteOrderCorrections (Control Value)
Fulfillment Sync
It syncs fulfillments and fulfillment orders with affiliated tracking information from NetSuite to Shopify B2B.
Product Sync
It syncs the data related to SKUs, price and updates product details across NetSuite and the Shopify B2B connector.
Refunds and Adjustments Sync
The sync initiates returns and exchanges record creation and updates for changes related to order statuses and inventory.
Inventory Sync
This sync enables the sync of inventory levels and the quantity of the order from NetSuite to Shopify B2B.
Reverse Payment Sync
The Reverse Payment sync automatically pushes the existing payments in NetSuite (whether applied to invoices or customer deposits) back to Shopify B2B to mark the corresponding Shopify invoices as 'Paid'.
The sync supports all payment types and includes error-handling and alerts so you can see is any payments fail to sync.
By default, only NetSuite transactions within the last 90 days are considered (to match common Net terms), with plans to introduce a configurable 'B2B Order Sync Window' setting. This sync closes the loop on financial reconciliation-ensuring Shopify accurately reflects payments captured or applied in NetSuite.
Catalog and Price List Sync
The Catalog & Price list sync feature allows B2B merchants to define item catalogs in NetSuite, assign price levels, and apply fixed price overrides. It automatically syncs catalogs to the Shopify B2B company accounts.
Prerequisites
To use the catalog and price list sync in Shopify B2B, you must complete the following prerequisites:
-
Enable the Shopify B2B allotment in your NetSuite Connector account.
-
Install and authorize the NetSuite Connector SuiteApp.
-
Configure the Shopify B2B connector.
For more information, see Integrating NetSuite Connector with Shopify
Setting up the Catalog and Price Sync
This section outlines the steps to set up the catalog and price sync in Shopify B2B:
Enable Catalog Sync
To enable catalog sync:
-
Select your Shopify connector and account.
-
Go to Shopify > Data Flows > Manage Data Syncs.
-
Locate the Catalog Sync card and click the catalog sync switch.
Create Custom Record Types in NetSuite
To create custom record types in NetSuite:
-
In your NetSuite Connector dashboard, go to Shopify > Data Flows > Manage Data Syncs > Catalog Sync > Settings.
-
Click Create Custom Records.
-
After the setup is complete, the system creates two custom record types in your NetSuite account:
-
NSC Catalog- This custom record defines items and pricing.
-
NSC Fixed Price- This custom record defines item-level price overrides within a catalog.
-
Create a Catalog Record
To create a catalog record:
You can add multiple catalogs for different companies or price tiers. If item selections overlap across catalogs, the system merges them.
Catalogs are assigned at the company level and applied to all company locations. Per-location catalog assignment is not supported.
-
In NetSuite, go to Customization > Lists, Records, & Fields > Record Types.
-
Open the NSC Catalog custom record.
-
Click New.
-
Select the individual items or choose an Item Saved Search in the Items field.
-
Select the B2B company that this catalog applies to in the Company field.
-
Select a NetSuite price level in the Price Level field.
-
Click Save.
Add Fixed Price Overrides (Optional)
To add fixed price overrides:
-
In NetSuite, go to Customization > Lists, Records, & Fields > Record Types.
-
Open the NSC Fixed Price custom record.
-
Click New.
-
Select the Item you want to override.
-
Select the Price Level or enter a specific price for that item.
-
Click Save.
-
Go back to your NSC Catalog record and attach this Fixed Price record.
Map the Catalog to a Shopify Storefront
To map the catalog to a Shopify storefront:
The system skips catalogs without a mapping and does not post them to Shopify.
-
In your NetSuite Connector dashboard, go to Shopify > Settings > Catalog > Mappings.
-
Select your catalog from the list.
-
Choose the target Shopify storefront/account.
-
Click Save.
Sync the Catalog
To sync the catalog:
-
Go to Shopify > Data Flows > Manage Data Syncs > Catalog.
-
Click Retrieve to load the latest data.
-
Click Post to push the data to Shopify.
Verify in Shopify
To verify in Shopify:
-
In Shopify, go to B2B > Catalogs.
-
Open the synced catalog.
-
Confirm that items are present and that prices reflect the correct price level.
-
For items with fixed price overrides, verify that the price adjustment percentage matches the configured override.
Default Mappings in Shopify B2B Connector
This section lists the default mappings for the Shopify B2B syncs.
|
Storefront Field |
NetSuite Field |
|---|---|
|
Terms |
Terms |
|
P/O Number |
PO# |