Quote Originally Posted by chadderuski View Post
Serious,

See this post on how to clear out your databases. Use with caution!

Also, you can use your zen_install to do this if you haven't removed it.

http://www.zen-cart.com/forum/showthread.php?p=1006332

Concerning your data:

1st SERIOUS error (no pun intendd ;P) you have a gap in your categories path, namely: you are skipping over category_name_3 (blank!) and putting a value in category_name_4.
I can only guess how much this will mess up your category tree.

You do this around records: 6353 - 6844, again 6845 - 6891, again 6892 - ... you get the idea. YOU MUST FIX THIS BEFORE ANYTHING ELSE!

2nd SERIOUS error: you have many duplicated v_products_model. Indeed, some of these look like dates "01/01/01" .... EP MUST ( I repeat MUST! ) use unique non-duplicate v_products_model identifers to populate your store, else you will have "duplicated" linked products that in no way have you intended to link (from their names/descriptions).

3rd SERIOUS error: BLANK v_products_name_1 .... this won't break your upload, but it will make for many headaches. I would not leave any products_name blank, ever. You are asking for trouble.

4th: products_name ... set to "0" ... set to all "EATON" "Detriot Locker" ... etc. Like you inadvertently put the manufacture there. At a minimum I'd pull this from your descriptions.

5th: To compound the 4th issue, you have the Manufacturer in the products_name, and then "........................." in the products description. You'll never know what is what!

6th: minor issue: many missing images


If I were in your position, I would first reset my databases using either of the above suggestions. Then install Dr. Bytes mysql backup tool. I consider this MANDATORY!

http://www.zen-cart.com/index.php?ma...products_id=81

Break your 10,000 products up into some logical/manageable order. Either master category, manufacturer or what makes sense to you. Carefully verify your data for completeness.
MANUALLY enter a few products from your spread sheet, do an export and compare your sheets to ensure you are doing things correctly.

Remember, you cannot mix products and categories! Your store will not work correctly. See some recent post where a new user was doing just that much to their grief.

Hope this helps get you on the right track.
i found a lot of that after I sent you the copy.

Spent a looooooooooooooooong time going trough the orginal spread sheet from my vendor cleaning up mis-named products, image files, blank fields...

I'm still ninding crap that needs to be fixed...it's a slow process.

I had made a lot of progress and opted to start removing products by changing the Status field from 1 to 9. I broke down the .txt file to multiple smaller files and deleted small groups of products that no one looked at.

Thought I had a handle on it till around midnight (last night) when I attemptd to add 10 part to one category. Upload went smoothly but now, none of the product images in that entire category are visible.....argh..NOt AGAIN!?!?!

All the image files are still in their original locations.
None of the image file names were changed on my EP txt file.