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.
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.
the .csv file failed to attach.
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.
Last edited by chadderuski; 23 Jan 2012 at 07:02 PM. Reason: typo
Awesome... you learn something new every day!
Thank you!
I will check with my web hosting company to see about the php version getting upgraded. In the mean time here is a copy of the csv file I was trying to upload.