Select All

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   On several pages of the Control Panel, (e.g. the export for reimport feature, Manage Suppliers, Manage Categories, etc) you have the option of select all to delete or move, etc.  However, when you click on that the select all only it only selects what's on the existing page.  This becomes a bit of nuisance when I'm trying to delete or move all products from a specific category.  I literally have to go thorough all the pages to complete the task.  When I tried to manager by brand (delete or export, etc), I have over 200 pages that I would have to go through in order to complete the task.  Did I overlook something?  Is there a way around this?

Thank you.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ACTMARK Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01-April-2007 Status: Offline Points: 0	Post Options Post Reply Quote ACTMARK Report Post Thanks(0) Quote Reply Topic: Select All Posted: 30-March-2010 at 6:57pm
	On several pages of the Control Panel, (e.g. the export for reimport feature, Manage Suppliers, Manage Categories, etc) you have the option of select all to delete or move, etc. However, when you click on that the select all only it only selects what's on the existing page. This becomes a bit of nuisance when I'm trying to delete or move all products from a specific category. I literally have to go thorough all the pages to complete the task. When I tried to manager by brand (delete or export, etc), I have over 200 pages that I would have to go through in order to complete the task. Did I overlook something? Is there a way around this? Thank you.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 01-April-2010 at 1:08am
	You can set the results to be shown on the page (e.g. Export for Re-import), and if you set it to 100, that would be go pretty quick, no?
	The ProductCart Team Home of ProductCart shopping cart software

ACTMARK Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01-April-2007 Status: Offline Points: 0	Post Options Post Reply Quote ACTMARK Report Post Thanks(0) Quote Reply Posted: 01-April-2010 at 1:25pm
	Yes, it is quick to download 100 SKUs but not if you have 30,000 SKUs which we are building up to. Also, when we update our database, it is generally done on a vendor or brand by brand basis. It is difficult for me to figure out where those sit in the database in order to use the download by 100 SKU feature. I just wanted to know if there was something I was missing that prevents me from using the select all button in order to select everything that came on the search as oppose to just the page you are on. It appears that there is no other way around it so I'll have my web developer add a view all feature on the search result page so that the select all feature will work on all the SKUs from the search. Thank you.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply 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.

ACTMARK Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01-April-2007 Status: Offline Points: 0	Post Options Post Reply Quote ACTMARK Report Post Thanks(0) Quote Reply 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.

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply 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 *****************

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply 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: http://wiki.earlyimpact.com/quickstart/godaddy 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.

ACTMARK Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01-April-2007 Status: Offline Points: 0	Post Options Post Reply Quote ACTMARK Report Post Thanks(0) Quote Reply 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?

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply 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 *****************

ACTMARK Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01-April-2007 Status: Offline Points: 0	Post Options Post Reply Quote ACTMARK Report Post Thanks(0) Quote Reply 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.