Import Table from LNS make sure that text fields are used for everything except for fields, make them Currency and make package quantity an integer
Import the UPC code table
Do a filter for Vendor in LightSpeed Inventory Search and export the records. 10000 at a time.
Import the LightSpeed tables. Pay close attention to the first import, making all fields Text except for the three Money fields, make them currency and Qty Integer
Make a duplicate empty table of the Lightspeed table
Make update table query append all records from the Lind N Sea import into the LightSpeed blank table... Expr1: [tblLandNSea2022].[PartNo] & ' - ' & [tblLandNSea2022].[Description]
New query, bring in the new table you just created and the UPC table, make a join to the Manufacturer SKU and the LNS Part No, do an update to add all the UPC codes to the new table
New update query to add systemID from LightSpeed table to new table
New query to show only items that only have a SystemID is not null
Make Table from above query
Make queries that have 10000 records at a time from the Inventory table
DeDupe the queries, check on SystemID
Export those tables to EXCEL
Make a query on the All Parts to show Is Null on on SystemID
Make a new ID Autonumber field on this new table and make 10000 item queries.
Export these new queries to Excel and Import them to LightSpeed
Make sure you have a "Vendor" field for the Additional Parts Export
Import the tables choosing "add new items"
When importing the table, be careful to put the cut lines in the right place so that you get the full price xxxx.xx
