Developer forum

Hi Yung,

Do you have a full code example we can see?

Best regards
Morten

And is the product in stock, published and have a price?

I am using Core 8.8.0.6

I made a function trying to get product info. The product has stock and price. When I tried Product.GetAllProducts() I am missing alot of products in my productcollection, how is that possible? If I use Product.GetProductByNumber, I am able to get the product, but other methods is giving me NULL reponse back. Product.GetProductsBySql("SELECT * FROM [EcomProducts]"); is also not getting all the products.

public static ProductStockModel GetResults(string productId, string variantId)
{
    Product product = Product.GetProductByID(productId, variantId);    
    ProductStockModel ProductResult = new ProductStockModel();

    if (product == null)
    {
        return ProductResult;
    }

    ProductResult.Number = productId;
    ProductResult.VariantId = variantId;

    ProductResult.Colors = GetVariantColors(product.VariantGroups);

    return ProductResult;
}

It could be language that is the issue. The call you have here uses eCommerce.Common.Context.LanguageID - and if the context is not the same as the data, you will get null.

Otherwise it looks fine.

If you still cannot find it, we need a URL and the parameters you call this method with - the product and variantid.

BR Nicolai

LanguageID is the same as my data: LANG1. I am currently still developing in local environment.

I will try to get this to an online test environment.

I put in on test environment and there I get the product back.

I think the development database data request/response is corrupt???

If I use the CMS management center and execute the SQL query I get the product also in development. What is going wrong in development backend?? Something is corrupt.

I have no clue... :-).
I would need to see your setup to locate the error - make sure the website, database and IIS matches what you think it should. Sometimes I get my things messed up so I cannot understand what happens...