EasyPopulate 4.0 Support Thread

[chadderuski]

Hello!
Sorry to ask if it already has been but upon skimming this thread I couldn't see an answer.
I put my prices into easy populate with tax, so when I uploaded them into the website they added tax again. Is there a was to make the prices in easy populate the gross price, not the net?

Thanks
Kerry

Hi Kerry,

Hmmm. Yes, I never quite understood why EP 1.2.5.4 would allow you to upload price with tax, only to calculate the price without tax before inserting into the database, or why that would be useful. But I left this code in place. I figured this may help in other countries. In the US, better to calculate tax at checkout.

Go to Configuration -> Easy Populate 4 and set "Upload/Download Prices Include Tax" to true. Test that and let me know if that works for you as expected.

[caffeitalia]

Hi, thank you for replying!

I just typed a huge step by step guide to what I did and attached the file you requested. But Zen Cart website timed out on 'posting' the message and it was lost!

so in brief. I used open office, i did not make any changes to the .csv file.

Please find attached the .csv file i use. I have removed all the rows with exception of two products that failed to have their 'descriptions' fully uploaded. Happy to upload publicly so it may benefit the community as there is no sensitive data.

I have also just renamed the file now, to make sure I post the correct file. It was not renamed for the upload to the test 1.5 website.

[caffeitalia]

the .csv file failed to attach.

[chadderuski]

Please find attached the .csv file i use. I have removed all the rows with exception of two products that failed to have their 'descriptions' fully uploaded. Happy to upload publicly so it may benefit the community as there is no sensitive data.

I have also just renamed the file now, to make sure I post the correct file. It was not renamed for the upload to the test 1.5 website.

Hi! Thank you for posting the data. This makes trouble shooting much easier for me!

This is what the problem is: Smart Quotes! and you are moving from character set ISO-8859-1 to UTF-8 ...

This is not a perfect fix, but it will get your data into Zencart.

1) IMPORTANT: When you open your file with OO, be sure to select your Character Set "Western Europe (ISO-8859-1)
2) You will now be able to see your smart quotes around the word "green"
3) To make life simple, change these smart quotes to plain quotes or add some html formating like <i>green</i> if you want to offset them.
4) IMPORTANT: When you save, be sure to check "Edit filter Settings" and make sure your character set it UTF-8.

I am not sure how effective OpenOffice is with converting character sets. What I got was not perfect, but would import. Instead, you may want to convert the smart quotes manually.

[caffeitalia]

Awesome... you learn something new every day!
Thank you!

[davowave]

Hello chadderuski,

thanks for making easy populate work with 1.5!

At the moment I'm running 1.3.7 but I'm redesigning my site and upgrading to 1.5 at the same time. I clean installed 1.5 using the database upgrade so that my categories and products and descriptions would be intact, which they are. However, when I installed your version of easy populate and downloaded the csv in a few of the descriptions where I had used ... (dot dot dot) … appeared instead.

Whats going on and how do I fix it and stop it happening again?

[chadderuski]

Hello chadderuski,

thanks for making easy populate work with 1.5!

At the moment I'm running 1.3.7 but I'm redesigning my site and upgrading to 1.5 at the same time. I clean installed 1.5 using the database upgrade so that my categories and products and descriptions would be intact, which they are. However, when I installed your version of easy populate and downloaded the csv in a few of the descriptions where I had used ... (dot dot dot) … appeared instead.

Whats going on and how do I fix it and stop it happening again?

You have a similar situation as caffeitalia, but with ... (which is call "ellipsis").

Here is a good article on the problem:

http://www.toao.net/48-replacing-sma...ashes-in-mysql

You can do a manual edit and do a search/replace in a good PLAIN text editor and use the html equivalent which is &hellip;

These conversion issues are common when moving from iso-8859-1 to utf8. I have an update I'm posting soon that will help with some multi-byte character issues, but I'll have to look at these problematic characters more closely.

Hope this helps!
chadd

PS! Be sure to read the notes on using OpenOffice. OpenOffice will let you select your character set on import/export of your csv file. Excel will NOT!

[chadderuski]

Awesome... you learn something new every day!
Thank you!

Glad this helped. Be sure to read the above linked article - very useful info.

[chadderuski]

Concerning Curly Quotes, EmDash, Ellipsis, etc...

I have a solution that may help people deal with this. Will include in my next push to Github. Basically, I'm going to add an option to EP4's Configuration page that will let you choose whether to leave these characters as is at import, change to simplified versions, or replace with HTML equivalents (best choice in my opinion).

I hope to be able to push the next update withing the next couple of days.

-Chadd

[VideoStan]

Congrats Chadd on your success with EP4.

I had an indirect exposure to your work about a year ago when checking in with JRobeson on his project.

I am testing EP4 in a new install of ZC1.5 that must use attributes. Basic import of standard products/descriptions using EP4 seems to work fine.

My tests with attributes are not successful, until I change the filename beginning to your sample name: Attrib-EP-xxxx

I also used the file structure in the sample (single line per product, only the 4 columns, desired attributes in one column, separate by commas).

The results info at the bottom of the screen shows no updates/no adds, but the items do in fact update.

Adding price is critical. I'll test some of the other attrib options. Any other filename beginnings that should be used with other columns added?

Stan