ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - Select All
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Select All

 Post Reply Post Reply Page  12>
Author
Message Reverse Sort Order
ACTMARK View Drop Down
Newbie
Newbie


Joined: 01-April-2007
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote ACTMARK Quote  Post ReplyReply Direct Link To This Post Topic: Select All
    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.
Back to Top
ACTMARK View Drop Down
Newbie
Newbie


Joined: 01-April-2007
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote ACTMARK Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 7:30pm

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'.

Back to Top
ProductCart View Drop Down
Admin Group
Admin Group

ProductCart Team

Joined: 01-October-2003
Status: Offline
Points: 135
Post Options Post Options   Thanks (0) Thanks(0)   Quote ProductCart Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 6:18pm
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.
The ProductCart Team

Home of ProductCart shopping cart software
Back to Top
ACTMARK View Drop Down
Newbie
Newbie


Joined: 01-April-2007
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote ACTMARK Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 6:00pm
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.
Back to Top
katharina View Drop Down
Senior Member
Senior Member
Avatar

Joined: 25-October-2005
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote katharina Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 4:03pm
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
*******************
Back to Top
ACTMARK View Drop Down
Newbie
Newbie


Joined: 01-April-2007
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote ACTMARK Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 3:40pm
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? 
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 3:28pm
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.
Back to Top
katharina View Drop Down
Senior Member
Senior Member
Avatar

Joined: 25-October-2005
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote katharina Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 3:23pm
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
*******************
Back to Top
ACTMARK View Drop Down
Newbie
Newbie


Joined: 01-April-2007
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote ACTMARK Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 3:11pm
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.
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post Posted: 01-April-2010 at 2:14pm
Depending on what you try to do, if you try to process 30k SKUs all at once you may run into timeout issues.
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.063 seconds.