Easy Populate 1.2.5.4 support

[Happyworker]

Hi all,

Just a quick question before purchasing.
Does EP Advanced import and export attributes effectively?
I have many attributes for each item so it's not just the items that take time, it's all those attributes.
Thanks in advance.
Happyworker

[langer]

Does EP Advanced import and export attributes effectively?

Support for Easy Populate Advanced is not available from this site - sorry.

[Happyworker]

Okay thanks langer, I will try elsewhere. It was more just a question of will it help me with the attributes.
Thanks again,
Happyworker

[Warrior]

Hi.
Excel Populate is concurrent of Easy Populate. This is advanced version of easy populate. Generated file is in real Excel format. Products, attributes, categories, manufacturers in different Excel sheets. Find it here
http://www.advancewebsoft.com/

[milkyway]

Hi langer and all,

I have some problem here, I have an excel file containing datas of few hundred products. I tried to re-arrange them in EZ-populate format.

I face difficulties when it comes to product's description, because ZenCart use HTML format, while the description I have in hand is in plain text format. So when I upload them it will not displayed corcetly, because of no HTML tags such as <p>, <br /> to arrange them.

So it would be a huge task to edit the description one by one, do you have any idea how I can import the excel into ZenCart without having to edit the description into HTML?

Thanks

milkyway

[langer]

There is a smart tags option in Admin -> Configuration -> Easy Populate which converts newlines into html line breaks. This will preserve such rudimentary formatting.

[schoolboy]

Zencart is not recommended with PHP5. Go back to PHP4 (last release of 4).

Easypopulate is just that ... easy. Best is to dump one of the sample tab delimited text files (in the TEMP directory) into MS Excel and see the column headings.

Once you've got all your data into the spreadsheet (MAKE SURE YOU DID NOT FORMAT ANYTHING - eg: bullet points, indents, etc), save as a TAB-DELIMITED TXT file (NOT CSV). Exit Excel, declining its offers to preserve Excel formatting.

Depending on the size of the txt file, you can either upload from your hard drive, or ftp the thing into the TEMP (not TMP) folder that easypopulate "owns", then run the insert from the TEMP folder.

You can "FORMAT" using certain html tags. So if in your PRODUCT DESCRIPTIONS you want bullet points for example, proper use of <ul> <li> </li> and </ul> will render them properly.

[schoolboy]

Hi langer and all,

I have some problem here, I have an excel file containing datas of few hundred products. I tried to re-arrange them in EZ-populate format.

I face difficulties when it comes to product's description, because ZenCart use HTML format, while the description I have in hand is in plain text format. So when I upload them it will not displayed corcetly, because of no HTML tags such as <p>, <br /> to arrange them.

So it would be a huge task to edit the description one by one, do you have any idea how I can import the excel into ZenCart without having to edit the description into HTML?

Thanks

milkyway

I had a similar issue - with nearly 3000 products. I (partially) resolved it as follows...

As I wanted double line breaks after each sentence in the product description, I decided to use the "friendliness" that exists between MS WORD and MS EXCEL.

I highlighted the entire "Product Description" column in Excel, then Copied to clipboard.

I then Pasted the column into MS Word. I now had a single column "table" of all the product descriptions.

Then I converted TABLE to TEXT, with breaks selected as paragraphs (not tabs).

Doing "Search & Replace" I replaced all instances of ^p (paragraph) with $$$ . (This is just a unique string that I can easily find later to "reconvert" $$$ to ^p .)

Now I have a massive paragraph of sentences, broken at various intervals by $$$.

Then I did a "Search & Replace" for "fullstop + spacebar" (. ) - ie: the end of each sentence - and replaced it with .<br /><br /> (fullstop + tag + tag).

Now I had all my sentences properly tagged with the double <br /> html.

Then i did a search & replace for $$$, turning them back into ^p.

Finally, I highlighted all text and did a TEXT TO TABLE, with PARAGRAPH as the line break.

Before copying and pasting back into Excel, I created another column in Excel NEXT TO the original Product Description column.

I PASTE the altered column into this new column, and alongside is the original text. I can quickly do a random sampling to see if the text in both columns matches up. Check the first, last and several middle records. If they match up, you're pretty safe that your new column is identical to your old column, but now you have the <br /><br /> tags in place.

Delete the old column, remembering to shift its EP header over to the new column first.

------------------------------

I got quite brave with this technique and later used it to create tables within the product description field. Only this time I had a separate spreadsheet with alternating columns of description text and strings of html tags.

Using the CONCATENATE function in Excel, it was possible to merge all these strings of text together, and the results were excellent. I now had description fields with unique little tables and additional data patched in.

Take a look:-

http://www.schoolmarket.co.uk/pages-...and-shaft.html

...and use the NEXT button to see how it is configured for following products.

[kopythat05]

Hi.
Excel Populate is concurrent of Easy Populate. This is advanced version of easy populate. Generated file is in real Excel format. Products, attributes, categories, manufacturers in different Excel sheets. Find it here
http://www.advancewebsoft.com/

does this work with Zencart or just OSC.......and does it handle images?.....just by file name, then by FTP.......

Kopy

[Happyworker]

Hi there,

I'm having a bit of trouble with importing.

I'm trying to update my attributes but everytime I upload it back to the server, and I see that nothing has changed.

My v_products_model column is complete...so I'm curious why it's not working.

I'm not getting any errors either, the changes just aren't showing up.

??
I have used all the methods of importing without any luck.

Any help or suggestions on what I'm doing wrong would be appreciated.
Happyworker