Product 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

------------------------------------------------

1. Login to integrator.io
2. Click on Netsuite - Shopify Integrations
3. Open the NS to Shopify Flow (https://integrator.io/integrations/5f400afa2aeb686432f1e12c/flowBuilder/5f400b7ce1547023522bf8da)
4. To Manually Sync Products - 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.
5. To Manually Sync Products into Shopify, run the following online command -
   https://lighthouse-prod.txtcon.io/gem_management/kickoff-products
6. Click the SYNC button to just run a SYNC
7. Please give the system 60 mins to fully run this sync.

NOTE - SCHEDULED TO RUN DAILY at 110am


Required SQL Table Data Creation (gemlux)

CREATE TABLE [dbo].[gemlux](
 [_id] [int] IDENTITY(1,1) NOT NULL,
 [shopifyId] [bigint] NOT NULL,
 [variantID] [bigint] NOT NULL,
 [inventoryItemId] [bigint] NOT NULL,
 [NSID] [varchar](50) NOT NULL,
 [NSName] [varchar](200) NULL,
 [DisplayName] [varchar](max) NULL,
 [StoreDescription] [varchar](max) NULL,
 [productType] [varchar](100) NULL,
 [onlinePrice] [decimal](18, 2) NOT NULL,
 [weight] [decimal](18, 3) NOT NULL,
 [weightUnits] [varchar](10) NOT NULL,
 [drawingFile] [varchar](max) NULL,
 [imageSRC] [varchar](max) NULL,
 [pageTitle] [varchar](max) NULL,
 [UPC] [varchar](max) NULL,
 [storeDisplayImage] [varchar](max) NULL,
 [StoreImage2] [varchar](max) NULL,
 [StoreImage3] [varchar](max) NULL,
 [StoreImage4] [varchar](max) NULL,
 [StoreImage5] [varchar](max) NULL,
 [NS3dFile] [varchar](max) NULL,
 [NSInstallation] [varchar](max) NULL,
 [NSWebStoreDes] [text] NULL,
 [NSProductMaterialList] [varchar](max) NULL,
 [NSLength] [varchar](50) NULL,
 [NSWidth] [varchar](50) NULL,
 [NSHeight] [varchar](50) NULL,
 [NSCutout] [varchar](50) NULL,
 [NSMountingStyle] [varchar](300) NULL,
 [NSFastenerSize] [varchar](300) NULL,
 [NSLocking] [varchar](300) NULL,
 [NSCompLatchBackingPlate] [varchar](300) NULL,
 [NSComprLatchCam] [varchar](300) NULL,
 [NSComprLatchShaftLength] [varchar](300) NULL,
 [A1] [decimal](18, 2) NOT NULL,
 [A2] [decimal](18, 2) NOT NULL,
 [A3] [decimal](18, 2) NOT NULL,
 [ABA] [varchar](300) NULL,
 [Clearance] [varchar](200) NULL,
 [OEM1] [decimal](18, 2) NOT NULL,
 [OEM2] [decimal](18, 2) NOT NULL,
 [OEM3] [decimal](18, 2) NOT NULL,
 [R2Online] [decimal](18, 2) NOT NULL,
 [Available] [int] NOT NULL,
 [NSType] [varchar](200) NULL,
 [onSpecial] [decimal](18, 2) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO