Author |
Topic |
|
DouglasEverett
Starting Member
6 Posts |
Posted - November 19 2009 : 07:56:58
|
We are slowly developing a site so the client can assume day-to-day management. It is up and functioning well. We have about 2,700 products in an Access database (soon converting to sql.) And we have about 200 categories.
Yesterday we added 200 products to the database product table (from an excel spreadsheet) and added a new category to the category table. All is OK. We loaded the database and tested. The new category is there but no products are in the category. We checked and ccategory is populated for each product. We checked in the VPASP admin screen and see all the products and the category. I added an additional product via the admin screen add product and it works. But the 200 products from the Access database do not. They are there but not via a browser.
For some reason these new products are not visible. Any clues or suggestions what I need to do to make it work? |
|
DouglasEverett
Starting Member
6 Posts |
Posted - November 19 2009 : 08:23:37
|
And they are not in the hide mode |
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
Posted - November 19 2009 : 08:26:47
|
We've got a help topic on that:
How can I import products using multiple categories/branches? - http://www.bigyellowzone.com/support/issue_view.asp?ID=224
Basically, it's the prodcategories table that you need to fill-in, not just the products.ccategory value, and you can do that by using something like level3 to store the list of categoryids and then run a secured version of convertproducts.asp after the import.
Make sure your cstock value is set to something relevant too if you're using stock-level config options.
I think that the hide value for products needs to be an explicit false/zero too (ie don't leave it null)
products.hide must be false/zero for it to be seen as not-hidden
but, categories.cathide, conversely, needs to be set to anything not-null to hide it and a null to not hide it.
so, usually for showing: products.hide would be 0, and categories.cathide would be null
and for hiding: products.hide would be 1, and categories.cathide would be "Yes"
Simon Barnaby Developer [email protected] www.BigYellowZone.com Web Design, Online Marketing and VPASP addons |
Edited by - devshb on November 19 2009 08:35:06 |
|
|
DouglasEverett
Starting Member
6 Posts |
Posted - November 19 2009 : 08:44:40
|
Hi Simon, Thanks for the pointer.
But the VPASP database manual states that:
prodcategories---Lists all categories for a specific product. Used only if the products in multiple categories is used
Each of my products is in a single category. |
|
|
DouglasEverett
Starting Member
6 Posts |
Posted - November 19 2009 : 13:49:28
|
Problem solved thanks to VPASP wizard Angelo.
The solution is: "After you have successfully imported your products from an Excel spreadsheet, please run the convertprducts.asp script. This script will read through the products table and synchronizes the links between categories and products in the prodcategories table.
To run the script, you would need to enter the page directly in your web browser's address field. Please use the following format:
http://www.yourdomain.com/convertproducts.asp
Please also ensure that the script file is already uploaded into your shopping cart's folder.
|
|
|
|
Topic |
|