![]() |
Select All |
Post Reply ![]() |
Page 12> |
Author | |
ACTMARK ![]() Newbie ![]() Joined: 01-April-2007 Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() Posted: 15-April-2010 at 8:14am |
Actually, my developer came up with a quick and easy fix. On the search screen, you can select how many search results to display on each page. He simply added a selection for 10,000 which essentially covers all search results.
|
|
![]() |
|
ACTMARK ![]() Newbie ![]() Joined: 01-April-2007 Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
I use the export for reimport feature and I select all fields and all SKUs. I've also tried just the fields that are automatically selected and it still times out. I was told by support to export 1,000 at a time as a workaround solution. I'm just a little suprise since I spoke with 2 web hosting companies (not GoDaddy) and they both said 7,000 SKUs is not consider a large database and it shouldn't do that. I've never use Product Cart before so I'm just not sure if this is the norm. Ultimately, once my database is completely built, I would like to be able to export and update by category or by vendor or brand and that's where I run into the problem of the select all which is really more of a 'select all on this page'. |
|
![]() |
|
ProductCart ![]() Admin Group ![]() ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
![]() ![]() ![]() ![]() ![]() |
ACTMARK: can you clarify exactly which feature is timing out?
Please provide the exact steps that you are taking, since features like "Export for Re-import" behave completely differently depending on which selections you choose. |
|
![]() |
|
ACTMARK ![]() Newbie ![]() Joined: 01-April-2007 Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
I'll try a different connection but the speed issue seems to be on the database server side since the download file only happens at the end when the database base finishes its download plus I'm using ultra high speed cable, i think it's about 8mb download speed. It's fast. I'll have to try downloading 4,000 SKUs at at a time and see if it works.
|
|
![]() |
|
katharina ![]() Senior Member ![]() ![]() Joined: 25-October-2005 Location: United States Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
We have over 4000 skus, but what really kills us running sales reports. We can only do monthly and at high sales season 2 weeks worse at a time. At the club we were able to download an entire year! It took some time, but did not timeout. Can't remember how big the file was. All I wanted to point out that it may not be the hosting company, but your connection to the Internet.
|
|
Katharina
******************* www.GermanPlaza.com ******************* |
|
![]() |
|
ACTMARK ![]() Newbie ![]() Joined: 01-April-2007 Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
I've already switched actually. I thought it was a GoDaddy issue but when I switched over to Jolt, I'm experiencing the same problem. Thanks for the tip on where the code is to adjust the download size. I may play with that, however, even at a 1000, it's pretty slow and actually timed out on me once. I also, often times get a error message at the bottom left corner of my browser after a few minutes of download. Katharina, when you say you've downloaded some pretty big files, how many SKUs are we talking about. As I said, I always timed out with 7,000 SKUs at GoDaddy and at Jolt. This is using a ultra high speed cable modem. Also, does your store lock while it's downloading about 1,000 SKUs?
|
|
![]() |
|
Greg Dinger ![]() Certified ProductCart Developers ![]() ![]() Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
![]() ![]() ![]() ![]() ![]() |
NoDaddy is an inferior host and not suitable for hosting a serious store. You should read the notice on the following page as well as various posts (rants) here in the forum:
At the top of ReverseImport_step1.asp you will find this statement.
pcv_intExportSize = 300
You can experiment with that value and cause different chunk sizes of products to be defined for the download selection criteria.
A revision could certainly be created to support export by brand, and perhaps also limited to workable chunks of data.
If tweaking the above value does not help, I'd suggest you strongly consider moving to a better host as a next step, then look at custom programming if those do not resolve the issue.
|
|
![]() |
|
katharina ![]() Senior Member ![]() ![]() Joined: 25-October-2005 Location: United States Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
We have timeout issues hosted on webhost4life.com
I'm not sure if it can really be blamed on the hosting co alone. The dialup or other provider has to be blamed to. We use directv which seems to be a big culprit. We do better when using AOL dialup, but it is not a solution at all. We did once try the direct connection at a club. They were nice enough to let us use their system by giving us access to it. That was wonderful, but they are 6 hours away from here. I did some big downloads in no time and no timeouts either. So there is something else to look at. |
|
Katharina
******************* www.GermanPlaza.com ******************* |
|
![]() |
|
ACTMARK ![]() Newbie ![]() Joined: 01-April-2007 Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
No, I'm running into time out issues now with 7,000 SKUs. I thought it was just a GoDaddy issue but apparently not. Right now I can run 1,000 SKUs at a time (farily slow) but one time when I did it, it still timed out on me. Also, my store basically freeezes whenever I download. Definitely I wouldn't want to download 30,000 SKUs all at once, which is why I was interested in the ability to download by brand except I would have to go through hundreds of pages and click select all for each page, which kind of renders that feature useless for me.
|
|
![]() |
|
Greg Dinger ![]() Certified ProductCart Developers ![]() ![]() Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
![]() ![]() ![]() ![]() ![]() |
Depending on what you try to do, if you try to process 30k SKUs all at once you may run into timeout issues.
|
|
![]() |
Post Reply ![]() |
Page 12> |
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |