NopInventoryImport

Run this on given client and copy the results to an excel file. This query is to put items in the "Others" category in NOP which doesn't exist by default. you will need to create the "Others" Category then upload on nop.

In the NOP Administration Dashboard, go to catalog > products > and click the import button at the top and use the excel file.

select i.inventoryid as ProductID, ISNULL(id.ItemDescription,) as Name, id.ShortDescription as ShortDescription, id.DetailedDescription as FullDescription, i.SKU, case when i.service = 0 then 'TRUE' else 'FALSE' end as IsShipEnabled, 'FALSE' as IsTaxExempt, 'TRUE' as Published, as TaxCategory, 'Manage Stock' as ManageInventoryMethod, 1000 as StockQuantity, i.RetailPrice as Price, 3 as Weight, 2 as Length, 2 as Width, 2 as Height, 'Others' as Categories, as Picture1, as Picture2, as Picture3 from inventory i inner join InventoryDescriptions id on id.InventoryID = i.InventoryID where status = 'a' and isnull(HasSubItems,0) = 0 and i.warehouseid = 1 and MasterInventoryID = 0 and id.LanguageKey = 1 --order by i.inventoryid union --FOR GROUP PRODUCTS IF NEEDED-- select i.GroupID as ProductID, ISNULL(id.ItemDescription,) as Name, id.ShortDescription as ShortDescription, id.DetailedDescription as FullDescription, i.SKU, case when i.service = 0 then 'TRUE' else 'FALSE' end as IsShipEnabled, 'FALSE' as IsTaxExempt, 'TRUE' as Published, as TaxCategory, 'Manage Stock' as ManageInventoryMethod, 1000 as StockQuantity, i.RetailPrice as Price, 3 as Weight, 2 as Length, 2 as Width, 2 as Height, 'Others' as Categories, as Picture1, as Picture2, as Picture3 from InventoryGroups i inner join InventoryDescriptions id on id.InventoryID = i.GroupID where status = 'a' and i.warehouseid = 1 and id.LanguageKey = 1 --order by i.GroupID