I am getting 2 of each product on entity.grid.xml.config? How do I correct this?
example
http://www.lightingsayu.com/c-50-island-lighting.aspx
I am getting 2 of each product on entity.grid.xml.config? How do I correct this?
example
http://www.lightingsayu.com/c-50-island-lighting.aspx
have you modified your storeproc ? This is due to storeproc changes.
Hi storedeveloper, No, the only stored procedure I have modified is added MSRP to aspdnsf_ProductInfo. Which sp should I look at?
What version you are on? Do you have multiple category mappings on that particular product?
ML 8.0.1.2/8.0.1.2. Yes the products are in 2 categories.
please check the storeproc aspdnsf_getproducts which returns all the product with the running category.
What should I change on aspdnsf_getproducts. This sp has not been modified since the software was installed.
I think you have same product in manufacturere and category. you need to modified your storeprocedure. in the aspdnsf_getproducts at very bottom there is a join for the manufacturere. please remove this line and the excute storeproc and then check.
i think it works. if not then we have to check your xmlpackage and db.
Thanks
Good morning! I commented out
/*left join dbo.ProductManufacturer pm with (NOLOCK) on p.ProductID = pm.ProductID
left join dbo.Manufacturer m with (NOLOCK) on pm.ManufacturerID = m.ManufacturerID */
I get errors
Msg 4104, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 372
The multi-part identifier "m.ManufacturerID" could not be bound.
Msg 4104, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 373
The multi-part identifier "m.Name" could not be bound.
Msg 4104, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 374
The multi-part identifier "m.SEName" could not be bound.