Welcome, Guest ( Customer Panel | Login )




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

gazzaca
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

support
Administrator

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

http://www.vpasp.com/helpnotes/shoptocdetail.asp?id=65&cat=Importing+Data

Thanks,
Cam

VP-ASP Support
Go to Top of Page

devshb
Senior Member

United Kingdom
1904 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:
http://www.bigyellowzone.com/support/issue_view.asp?ID=224&CATE=8

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:
http://www.bigyellowzone.com/shopexd.asp?id=31

Prod/Cat Check/Fix Tool:
http://www.bigyellowzone.com/shopexd.asp?id=74

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
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
0 Item(s)
$0.00