Easy Populate 1.2.5.4 support

[Scrat]

Schoolboy Hi (how's the rewrite of EP going ?, I've gone down the remote access route), matter of interest by ftp'ing the file did you get a report of product status' 'updated' etc in EP's screen.

jvalich says that the split file does update the database, if it was a format fault it wouldn't update the new data ?

[schoolboy]

Schoolboy Hi (how's the rewrite of EP going ?, I've gone down the remote access route),

...slowly...

matter of interest by ftp'ing the file did you get a report of product status' 'updated' etc in EP's screen.

Oh yes... all 6500 products showed up as "new product added". Took a while to load the page, but EP behaved as it should.

jvalich says that the split file does update the database, if it was a format fault it wouldn't update the new data ?

Without seeing the actual TXT file, I can't comment. All I can say is that if EP works loading 1 product (as a test), then it will load MANY products. My WIKI tutorial goes through some of the key processes, as well as common pit-falls.

[Serious]

Serious
1. What version are you using ?
2. EP works the best if you upload max 300 products at once,split your file.
3. Did you enter any products into ZC before you used EP
4. Have you done a 'complete' download and edited your file so there is only 3-4 products in it, edit some changes and then upload via EP and see if that changes the products.
5. If you are uploading hundreds of products EP will not do a report at the end of the upload the screen will be just blank. If you do get a report, what are the results. Like I suggest reduce your file in size and then you would see results of the upload and it may give you some idea of whats going on

EP 1.2.5.4 works

EP1.2.5.4

I finally got everything deleted by a combination of things.

Broke down the product txt file into 11 seperate files of just under 1k each.
FTP'd to the TEMP folder
Ran each file through the EP upload process and was able to delete al but 750 products that way. I have no idea why these wouuld not delete.

I even created a Complete Tab Delimiyed txt file via Admin>Tools>EP and went through it line by line to see why these productswould not delete. Changed the Status from1 to 9 and tried to delete the remaining files 1 last time.....no luv.

Went into the Category/product page and deleted all Categories.

FTP'd my new product list and attempted to load it from the TEMP directory....Internal Server error message.......[sigh]

Tried loading via Browse>upload to DB from my local drive....work just fine.

Just need to add Categoriy and Sub-Cat images and I'll be okay.

[chadderuski]

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.

[geeker]

Is there a way to attribute multiple styles in ep? In other words is I had an item that comes in three colors and wanted to provide a color select box on the product page, how would I do this with ep?


Also how would I make an item from one subcategory be a linked item in another subcategory via the upload?

Thanks in advance.

[stumpyhead123]

hi

i wonder if somebody would be kind enough to help me. I have installed easy populate 1.2.5.7.csv i am using zen v1.3.9f (i know i should upgrade) php5.3

i can manage to upload the csv file and all the categories list correctly, however, none of the categories have products in them???

All i get is this message:
There are no products to list in this category. please help me i am pulling my hair out; any help would be so appreciated.

Thank you kindly in advance

regards

[misty]

I have installed easy populate 1.2.5.7.csv

USE Easy Populate Version 1.2.5.4..otherwise try another similar module i.e. Apsona

[Serious]

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.

[schoolboy]

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.

In my experience, doing a STATUS = 9 on an EP upload will ALSO delete the products' images.

When I do a STATUS = 9, I backup the images folder (usually by just renaming it to images-bak, and then create a new empty images folder with nothing in it (all this done via FTP client).

Then, after I have used EP to do the mass-delete, I remove the empty images folder and re-name the images-bak to its original name (ie: images).

[Boatersplanet]

I'm writing in hopes that someone may be able to quickly resolve the issue I am having. I have been working with developers to upload a suppliers catalog (in the form of excel spreadsheet) of 65,000 products into our database using EP.

Initially they uploaded all the products to MasterCategory=0. I then created a Misc. Category (ID#730) and a subcategory (#838) in which I want this particular catalog to go to. I then had them re-upload the products into the database with a MasterCategory ID#838 which is the subcategory I would like all the products to appear under.

The store shows that there are 65,000 products but on the site it only shows a short list of newly added products. In the admin side of ZenCart when clicking the miscellaneous category, the subcategory then disappeared. I tried adding a new subcategory and going into the database to change that category ID back to 838 so the products would appear but alas, no luck. Anytime I change the category ID to 838 the category then disappears although the products and the product_to_category ID relationship is established in the database...... Any suggestions??