VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 update products seems very slow.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jrh
Starting Member

United Kingdom
20 Posts

Posted - October 28 2006 :  05:32:44  Show Profile  Reply with Quote
I expect I am getting this wrong but trying to update products seems very slow.

I go into everyday tasks
Click Bulk Update
Select products
Click on view
Find the item I require by selecting a field from a drop down
selecting a parameter
Typing in a search term

This give me a list of products to update.

I select Edit and update the record with new infomation.

If I then press "Back to Products"

It does not take me to the search list created but takes me back to to a page where all products are displayed but the search term is lost.

I wonder what I am doing wrong.

Can anyone please advise me, thanks John

stockman
Starting Member

8 Posts

Posted - October 29 2006 :  22:57:29  Show Profile  Reply with Quote
You do not need to select Edit and update the every record as you can update ccode,cname,cdescription and cprice for all products that displayed on Bulk update page at the same time. Just change all data you want for required products shown on shopa_editdisplaybulk.asp and then click Update Record at the bottom. It will update all products with new data.

However, if you want to update other product fields which are not shown on shopa_editdisplaybulk.asp you cannot do it by using bulk update functionality and in this case you need to click Edit for each product.
Go to Top of Page

jrh
Starting Member

United Kingdom
20 Posts

Posted - October 30 2006 :  02:14:57  Show Profile  Reply with Quote
Thanks for yor help,
Unfortunately on this occassion I want to update categories so unless I am mistaken the above routine applies and make the updating very slow.
Go to Top of Page

elammers
VP-ASP Super User

USA
256 Posts

Posted - October 30 2006 :  05:48:06  Show Profile  Visit elammers's Homepage  Reply with Quote
An alternative is to export your products, edit the data locally in the data dump file, and then import it back in.

Of course, if you are making category edits, don't forget to run the "convertproducts.asp" tool after the import.

Regards,

Eric in Maine
Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - October 30 2006 :  06:21:30  Show Profile  Visit devshb's Homepage  Reply with Quote
indeed; on that front, the following url might help, as it explains how to do that....
http://www.bigyellowzone.com/support/issue_view.asp?ID=224&CATE=8

and:
http://www.bigyellowzone.com/support/issue_view.asp?ID=442&CATE=8
(which explains how to import tab separated files)

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on October 30 2006 06:22:44
Go to Top of Page

jrh
Starting Member

United Kingdom
20 Posts

Posted - October 31 2006 :  04:55:48  Show Profile  Reply with Quote
Thanks elammers
I ran convertproducts.asp and got the following report
Products read=58
Products added to prodcategories table=0
Products already in prodcategories table=58
Subcategories added to prodcategories table=0
Subcategories already in prodcategories table=0
Products with bad category=0
When I look in the productcategories table it contains only two records, I have updated more.
I had records already in a db so in access I was able to cut and paste columns in easily.
Its the updating one at a time which seems cumbersome.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000