Importing products

[Rodien]

Has anyone tried importing 2000+ products into openstore?

I keep getting a timeout error.
I bump up the connection timeout in the connection string and the import improve a little bit but I still get the timeout error.

And if I import like 800 products, they do not show right away in the system. They show up like after 10 min or so.

Does openstore have a limit for importing products?

[leedavi]

I've imported 8000+ and it worked OK... but took a LONG LONG time!!!

You need to up all the timeouts in the web.config. I made them BIG and then lowered them after the import.

Look in you web.config for

executionTimeout="xxxxx"
maxRequestLength="xxxxxxxx"

There is also a report of products not going into the correct category. I have seen it on a site with about 1000+ products, that I imported from v3. So, keep an eye on that. I think the problem I had was related to data being corrupt, but I'm unsure.

[Rodien]

Repository

[leedavi]

OK, I got that invite. I remember this one. CSV import, I thought you meant the XML one.

There was some trouble with csvhelper.dll being an old version is your install. I sent an email about it. I think I completed the work by using the old version you were using. Maybe with an upgrade this clash has broken things. Or obviously something else.

This was written over 2 years ago. Has it been working up to the point you upgraded something? Or did it just stop ?

Contact me by email and we can try to work on a solution.

[Rodien]

I send you an email.

[ufoloko]

Hi Rodien, can yo please share again the import plugin, should be great. Thanks

[Rodien]

I'll talk to @leedavi to see how we can make the code available on the Openstore GitHub account > Hi Rodien, can yo please share again the import plugin, should be great. Thanks

[Rodien]

Hey David,

One more question😁

I am trying to make a scheduler for the import. This way I can avoid the httpcontext...

But "GategoryUtils.GetCategoryData" is throwing an Object reference not set to an instance of an object.'

Am guessing that it is throwing this error because I am not using http context anymore.

`// overload to support out of http context instantiations ie. when the scheduler runs NBrightDnnIdx
public ProductData(int productId, int portalId, String lang, Boolean hydrateLists = true, String typeCode = "PRD")
{
_portalId = portalId;
ResetData(productId, lang, hydrateLists, typeCode);
}

`

Does OpenStore has something similar as the above code but for the "GetCategoryData" method?

[leedavi]

It could be the cacheing.

Try

catData = new CategoryData(categoryId, lang);

And see if that works.,

[Rodien]

Ahh that did not work😌
Getting the same error "Object reference not set to an instance of an object."

I tried clearing the cache right before " var categoryData = new CategoryData(-1, culture); " but it did not have any effect.

I had this same error for productData = new ProductData(productid, culture); but supplying PortalID
ProductData(productid, PortalID, culture) fixed it for me

[leedavi]

I see. The scheduler does not have any portals.

You need to loop through all the portals in the install or pass the specific portalid.

[DNNMonster]

If you are able to upgrade, you may wish to re-test this with the recent changes to the Product save function. I think you'll find it's improved.

Don't expect warp speed but a noticed improvement should be there.