Customer Sync
Netsuite to Shopify (outbound sync) System Requirements:
- Netsuite Saved Search (https://1019389.app.netsuite.com/app/common/search/search.nl?id=9027)
- GEMLUX Azure Microsoft SQL Server Database Instance - gemlux.database.windows.net
- Text Connects Lighthouse Shopify App Integration
-------------------------------------------------------------------
- Login to integrator.io
- Click on Netsuite - Shopify Integrations
- Open the NS to Shopify Customers Flow
- To Manually Sync Customers - Click on the PLAY ICON on the top right of the flow
Note: This will only sync data with the internal Gemlux SQL Server, please follow the remaining steps. - To Manually Sync Customers into Shopify, run the following online command - https://lighthouse.txtcon.io/gem_management/kickoff-customers
- Click the SYNC button to just run a SYNC
- Please give the system 75-90 mins to fully run this sync.
Required SQL Table Data Creation (gemlux_customers)
CREATE TABLE [dbo].[gemlux_customers](
[_id] [int] IDENTITY(1,1) NOT NULL,
[NSID] [int] NOT NULL,
[recordType] [varchar](100) NULL,
[NSCustomerID] [varchar](100) NULL,
[NSName] [varchar](max) NULL,
[NSEmail] [varchar](max) NULL,
[NSOffice] [varchar](50) NULL,
[NSFax] [varchar](50) NULL,
[NSSalesRep] [varchar](255) NULL,
[NSPriceLevel] [varchar](255) NULL,
[Address1] [varchar](max) NULL,
[Address2] [varchar](max) NULL,
[AddressCity] [varchar](max) NULL,
[AddressState] [varchar](100) NULL,
[AddressCountry] [varchar](200) NULL,
[AddressZip] [varchar](100) NULL,
[Role] [varchar](max) NULL,
[taxable] [varchar](100) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]