NopInventoryImport: Difference between revisions

From Prodigix Wiki
Jump to navigation Jump to search
No edit summary
Tag: Manual revert
No edit summary
Line 4: Line 4:


In the NOP Administration Dashboard, go to catalog > products > and click the import button at the top and use the excel file.
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

Revision as of 22:51, 26 March 2024

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.

Retrieved from "https://wiki.prodigix.com/index.php?title=NopInventoryImport&oldid=363"