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
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Problems and bugs
 Imported products and category
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

28 Posts

Posted - April 14 2006 :  23:48:18  Show Profile  Reply with Quote
I imported 2700 products in v6 and sql server from a csv file. I cant get the products to show up in the category that i had entered in the csv file. It just show each product as having no category.

Any ideas?

I ran shopconvertproducts.asp and now categories show assigned to each product, but they will still not show from the website, all categories are empty

Edited by - gazzaca on April 14 2006 23:52:29


4263 Posts

Posted - April 14 2006 :  23:50:39  Show Profile  Visit support's Homepage  Reply with Quote
Please see the follwling help note on doiung bulk imports into the system.

You may need to run the convertproducts.asp file after each import.



VP-ASP Support
Go to Top of Page

Senior Member

United Kingdom
1898 Posts

Posted - April 15 2006 :  18:50:28  Show Profile  Visit devshb's Homepage  Reply with Quote
We created a general topic on that too:

What we do is we use the level3 field to hold only the bottom-level category of each branch, use the ccategory field to hold the first branch's top-level categoryid, and then run an amended (security-added) convertproducts.asp, and then run our "prod/cat check/fix" tool to fill in the missing gaps; that way we don't need to add all the higher-levels of each branch into level3.

Relevant links/addons you might find useful for that aspect are:

Admin Category Tree:

Prod/Cat Check/Fix Tool:

Simon Barnaby
[email protected]
Web Design, Online Marketing and VPASP addons
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000