URGENT HELP NEEDED with spreadsheet upload!

[Guest buttondeli.com]

I just uploaded a spreadsheet directly into phpAdmin that contains about 500 products. The spreadsheet contains prices, categories, taxes, etc. When I look at the database table, all the information loaded correctly. When I go into CC admin, all the products seem to have loaded properly also and in the correct categories. But when I go to my actual Web site, the products do not display. To make them display, here's what I have to do:

1. Go in to the CC control panel.

2. Open a product and reassign it to a new category.

3. Save the change.

4. Open the product again, and then reassign it to the correct category.

I'm thinking there's something I need to refresh??? Either in CC or in phpAdmin....I don't know, I'm learning as I go and I'm happy I got this far.

Any help you can provide is appreciated I don't want to manually reassign all the products one at a time. The Web site URL is: http://www.buttondeli.com/shop.

Thanks,

Andrea

[Guest foreknowapparel]

I just uploaded a spreadsheet directly into phpAdmin that contains about 500 products. The spreadsheet contains prices, categories, taxes, etc. When I look at the database table, all the information loaded correctly. When I go into CC admin, all the products seem to have loaded properly also and in the correct categories. But when I go to my actual Web site, the products do not display. To make them display, here's what I have to do:

1. Go in to the CC control panel.

2. Open a product and reassign it to a new category.

3. Save the change.

4. Open the product again, and then reassign it to the correct category.

I'm thinking there's something I need to refresh??? Either in CC or in phpAdmin....I don't know, I'm learning as I go and I'm happy I got this far.

Any help you can provide is appreciated I don't want to manually reassign all the products one at a time. The Web site URL is: http://www.buttondeli.com/shop.

Thanks,

Andrea

Not sure how to help but I wanted to say cool layout where did you find it? Also, if you need anyone to design you a new topHeader I can do something up for you and anything else design related you need done like image changes, maybe in exchange for some buttons! And don't forget to change the Homepage under Site Documents it still says Welcome To Cubecart.

[Guest buttondeli.com]

Nevermind, I just found then answer in the forum messages and it solved my problem. In case you need instructions, visit this topic: http://www.cubecart.com/site/forums/index....showtopic=26353.

Thanks!

Andrea

buttondeli.com/shop

I just uploaded a spreadsheet directly into phpAdmin that contains about 500 products. The spreadsheet contains prices, categories, taxes, etc. When I look at the database table, all the information loaded correctly. When I go into CC admin, all the products seem to have loaded properly also and in the correct categories. But when I go to my actual Web site, the products do not display. To make them display, here's what I have to do:

1. Go in to the CC control panel.

2. Open a product and reassign it to a new category.

3. Save the change.

4. Open the product again, and then reassign it to the correct category.

I'm thinking there's something I need to refresh??? Either in CC or in phpAdmin....I don't know, I'm learning as I go and I'm happy I got this far.

Any help you can provide is appreciated I don't want to manually reassign all the products one at a time. The Web site URL is: http://www.buttondeli.com/shop.

Thanks,

Andrea

Hey, thanks for the offer. I'd love to do some buttons for you.

I can't find the URL of where I found the skin, but I'll post it as soon as I go through my files.

Andrea

http://www.buttondeli.com/shop

Not sure how to help but I wanted to say cool layout where did you find it? Also, if you need anyone to design you a new topHeader I can do something up for you and anything else design related you need done like image changes, maybe in exchange for some buttons! And don't forget to change the Homepage under Site Documents it still says Welcome To Cubecart.

[Guest jamie750]

Nevermind, I just found then answer in the forum messages and it solved my problem. In case you need instructions, visit this topic: http://www.cubecart.com/site/forums/index....showtopic=26353.

Thanks!

Andrea

buttondeli.com/shop

I just uploaded a spreadsheet directly into phpAdmin that contains about 500 products. The spreadsheet contains prices, categories, taxes, etc. When I look at the database table, all the information loaded correctly. When I go into CC admin, all the products seem to have loaded properly also and in the correct categories. But when I go to my actual Web site, the products do not display. To make them display, here's what I have to do:

1. Go in to the CC control panel.

2. Open a product and reassign it to a new category.

3. Save the change.

4. Open the product again, and then reassign it to the correct category.

I'm thinking there's something I need to refresh??? Either in CC or in phpAdmin....I don't know, I'm learning as I go and I'm happy I got this far.

Any help you can provide is appreciated I don't want to manually reassign all the products one at a time. The Web site URL is: http://www.buttondeli.com/shop.

Thanks,

Andrea

Hey, thanks for the offer. I'd love to do some buttons for you.

I can't find the URL of where I found the skin, but I'll post it as soon as I go through my files.

Andrea

http://www.buttondeli.com/shop

Not sure how to help but I wanted to say cool layout where did you find it? Also, if you need anyone to design you a new topHeader I can do something up for you and anything else design related you need done like image changes, maybe in exchange for some buttons! And don't forget to change the Homepage under Site Documents it still says Welcome To Cubecart.

thats a skin by paula baker parkin, was on the old org site here: http://www.cubecart.org/forums/index.php?showtopic=5271

[Guest]

Run these two commands in PHPMyAdmin:

TRUNCATE TABLE CubeCart_cats_idx;

INSERT INTO CubeCart_cats_idx (productId, cat_id) SELECT productId, cat_id FROM CubeCart_inventory;

Then run fixCatCount which will correct your category product counts. You can find fixCatCount by doing a simple Google search for that term.

:w00t:

[Guest charleycrowe]

How did you upload the products into phpmyadmin? I have spent the last 3 days trying to get an excel spreadsheet imported. I have tried everything, csv, comma delimited, tab delimited (which actually put the rows in but left all the information out. I have tried converter programs, online searches etc. I always get this error: invalid field count at line 1. I know there is a mod but I am already about a grand into my site and cannot afford another mod.

thanks,

charley

titledvd.com

[vokf]

How did you upload the products into phpmyadmin? I have spent the last 3 days trying to get an excel spreadsheet imported. I have tried everything, csv, comma delimited, tab delimited (which actually put the rows in but left all the information out. I have tried converter programs, online searches etc. I always get this error: invalid field count at line 1. I know there is a mod but I am already about a grand into my site and cannot afford another mod.

thanks,

charley

titledvd.com

Did you export the invertory table to a .csv first? Remember to include field headers.

Once you have the current invertory table open in your spreadsheet, use "paste special" to copy your new product data into the uploaded sheet.

Save the new sheet as .csv and import using phpMyAdmin. If it imports ok, then follow Sir Williams instructions.

I use OpenOffice as my Spreadsheet, but I think Excel should also work.

Jason

[Guest buttondeli.com]

OK, I found it.... I purchased the skin from this Web site: http://cc3.biz/cubecart-skins/red-skins/sw...n/prod_162.html.

Let me know if you are still interested in trading buttons for design work. Please contact me at aflowers "at" buttondeli.com.

Andrea

http://www.buttondeli.com/shop

Not sure how to help but I wanted to say cool layout where did you find it? Also, if you need anyone to design you a new topHeader I can do something up for you and anything else design related you need done like image changes, maybe in exchange for some buttons! And don't forget to change the Homepage under Site Documents it still says Welcome To Cubecart.