Editing NopInventoryImport

Run this on given client and copy the results to an excel file.
 This query trist to put items in the "Others" category in NOP which ddoesn't exist by default.
you will need to creat 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