Easy Populate 1.2.5.4 support

[fairestcape]

This restricted use of special characters is discussed here:-

http://www.zen-cart.com/wiki/index.php/Easy_Populate

[fairestcape]

Ok so im having problem with easy populate 1.2.5.4 i upload all my products and everything works perfect except for my categories...it only uploads my products into my last subdirectory it makes no sense

i uploaded an example of my .txt (tab delimited file)

ADDITIONALLY, in v_status you have the word "Active"

The correct term to insert here is a DIGIT...

v_status
0
1
9

Where:-

0 = PRODUCT IS INACTIVE
1 = PRODUCT IS ACTIVE
9 = DELETE THIS PRODUCT FROM THE DATABASE

(All this and more is at:-
http://www.zen-cart.com/wiki/index.php/Easy_Populate )

[oddjob2000]

Whilst it did run for something like 12 hours, it ran flawlessly through and created 310,000 items for me. Yah!!

Now I've just got to figure how to get the product search down from 26 seconds for one item.

Oo err...

[rickiesdiscount]

This restricted use of special characters is discussed here:-

http://www.zen-cart.com/wiki/index.php/Easy_Populate

You can't use BACKSLASHES... Your category descriptions contain backslashes. These have a specific meaning in EP - namely, they indicate a DIRECTORY PATH.

You will have to re-name your categories to PLAIN ALPHA NUMERIC - don't use special characters or backslashes.

(See v_products_url for an example of when backslashes ARE used)

Yeah, but ive uploaded this exact file before i used the advanced version, but then i was having image problems...but that is fixed now and switched back and i had no problem at all the way the document is...i wonder if its because i had the advanced version installed and i did not delete everything...Anyway im not using backslashes under the category discription if u look its a foward slash...


As for the backslashes not sure what ur talking about ive had no problem with this before and that is the way the distributor gives me the information it cannot be changed i have 22,000 products from them it would take to long.

I really appreciate the help and advice though but im almost positive this isnt whats causing it.

[fairestcape]

Anyway im not using backslashes under the category discription if u look its a foward slash...

Forward Slash, Back Slash... term is irrelevant. These are restricted characters and are the cause of your categories problem.

that is the way the distributor gives me the information it cannot be changed i have 22,000 products from them it would take to long.

I get a similar list from my drop-shipper who ALSO describes the categories using slashes.

This is what I do:-

1. Open the list in excel.

2. Highlight the CATEGORIES COLUMN (where the backslashes/forwardslashes appear).

3. COPY to clipboard

4. Open MS Word

5. PASTE

6. (Now I have that column in a table in MS Word).

7. HIGHLIGHT THE WHOLE TABLE, then under MS Word menu "Table", select "Convert Table to Text.

8. Now I have the table as a list of "sentences" delimited by Paragraphs.

9. Use EDIT REPLACE - (tell MS Word to find / and relpace with ^t)

10. This replaces all slashes with a TAB.

11. Highlight all text, and go back to "Table" menu at the top, and now "Convert Text to table, using TABS to delimit columns.

12. I now have all my categories and sub-categories in their required columns

13. CTRL+A (select all) , the COPY

14. Go back to Excel and PASTE

15. Adjust excel columns and headers to suit EAsyPopulate...

For 22,000 products this will take about 20 minutes.

My list is routinely about 12,500 to 13,000 products and it takes me this amount of time to "repair" the layout.

I really appreciate the help and advice though but im almost positive this isnt whats causing it.

I'm sure it is what's causing it... sorry to disagree!

Good Luck.

[alvalong]

there is bugs to change or add subcategory? when i add a subcategory to existed products, these products be duplicated and move to new subcategory, but there is still products exist at parent category.

[fairestcape]

there is bugs to change or add subcategory? when i add a subcategory to existed products, these products be duplicated and move to new subcategory, but there is still products exist at parent category.

...and you will find that these are now LINKED products. This is a standard EP feature and Langer TELLS YOU THAT IT WILL HAPPEN !

Before you re-assign a product to a category, you must DELETE it from its old category (v_status for that product = 9), then run EP again to upload that product data to NEW category (v_status is then = 1).

You will have to re-upload the product image to its relevant images folder. This is the downside of v_status = 9 .

[veroned]

New questions...

I want to install the latest EP, but see reference to various versions and dates - some references to v1.2.5.4 look like they were in 2006. And a link to the "latest and greatest" would be very helpful.

Also, I see reference to EP Advanced Version 3.0.3 for $65. What if anything is different than the basic version? I don't mind paying for something that is markedly improved, though I am familiar with Excel, CSV and SQL so I am not scared of something basic so long as it works.

Thanks!
(New to EP)

[Veronika7747]

Is there a way to include "dual pricing/wholesale" fields in this mod?

Tx
Veronika

[dave_nextexit]

Hi, I tried to find an answer to this but havent had any luck. What I'm wondering is if its possible to add a column to Easy Populate that will automatically bullet a list of "product specs" when entered.

The problem im having is that when I go to add products from manufacturers' web sites, the formatting varies so much that its a huge pain to enter into Easy Populate...plus Easy Populate adds a bunch of code that screws up the formatting anyway.

I just want to be able to insert a plain list and have the output in the Zen Cart description be this same list but bulletted.

Can anyone tell me if this exists or an easy way to accomplish this? I would be so grateful!!

Thanks,

Dave