EasyPopulate 4.0 Support Thread

EasyPopulate 4.0 (EP4) Beta Support Thread. For Zencart 1.38/1.39/1.5

Download from at Github:
https://github.com/chaddro/EasyPopulate-4.0

https://github.com/mc12345678/EasyPopulate-4.0

Look for the "ZIP" button to download. To install, upload all files to your admin directory maintaining directory structure.
Also upload the additional files for your version of Zencart - be sure to put thes in their correct folder.

Next login to your Admin, and go to Tools -> EasyPopulate 4.
At the top of the screen will be a couple warnings for your upload folder, and configuration keys missing... click the "Please install your configuration by clicking here" to install the configuration keys.

Now navigate to Configuration -> EasyPopulate 4
Be sure to set your "Uploads Directory" to a folder that exists. I recommend changing from from the default "temp/" to something obscure to frustrate hackers.
You may also need to check folder permissions. Default for most servers is 755, but you may need to set permissions to 777.

I recommend that you first enter a couple Categories and Products through the normal Zencart Admin. This will help you understand the exported file formats.

Things of Import:

1) EP4 works only with CSV data files, and for best cross platform compatibility please use OpenOffice to Export your CSV file.
You should select the Comma as your field delimiter, and the Double Quote as your text delimiter. You may not get proper results using Excel.

2) You MUST use products_models to distinguish your products for import.

3) Categories are handled differently from other versions of EP. You can now import mult-lingual categories (Like Products Names, etc.).
To achieve this, each v_categories_names_1, v_categories_names_2 correspond to a language installed in your system, and individual category names are separated by the Carat "^" symbol. For Example: Bar Supplies^Glass Washers^Brushes

Bar Supplies will be your Top level Category, with Glass Washers as a sub-directory, and Brushes as a sub-directory of Glass Washers.

Be careful when creating your category names. "Bar Supplies" is not equal to "BAR Supplies" ... this will result in two category entries.

As of 4.0.17, your lowest defined language (by language id) is needed to when creating categories. In the future I'll change this to the defined default language, but that
will take some additional work.

4) Work flow is somewhat different than other version of EP. With EP4 you first either upload your file, then click on Import. Optionally you can also Split an import file if it is too large. You can set the number of records to split on in the configuration settings. Default is 2000. If you have a powerful server, you can up this significantly. Testing on a VPS with an import file of 900,000 records, I broke into 50,000 segments. Import of each 50,000 records took about 250 seconds.

Also NO streaming upload or download. Sorry if you liked this feature. A lot of effort has been put into improving the code's performance and streaming the data was a real memory hog. To download your exported file, you will need to "right-click, save-as". You may be able to set your browser to automatically download CSV files. I'll come up with a better solution in due time.

5) File names act as a switch inside the script for Importing. Namely: PriceBreaks-EP, CategoryMeta-EP, and Attrib-EP ... thes import files must have names that start with these names.

6) Basic Attribute Import. Please read the notes in the Readme.txt file carefully for how to use this. I am still working on completing this feature. Currently, you can at Import create your products_options_name (your attribute name, ie. color) , products_options_type (checkbox, downdown, etc) and , products_options_values_name (red, green, blue).

Be sure to backup you data before importing your files. Remember, this is still "beta". I have made every attempt to make this a solid bug free product, but it does require more testing. I have added a lot of error trapping, but I'm sure I've missed things.

Finally, EasyPopulate 4 is an amalgamation of code and ideas from earlier versions of EP. All due recognition is given to these earlier works and those author's efforts.
Langer for bringing us 1.2.5.4 from OsCommerce, Phazie for his efforts to move to CSV, jbcholdings for his ideas in Attributr, and all the forum participation over the years from users ... Scrat, Elkbow, Schooboy... too many to mention!

I also want to thank all my Beta testers to date for given my version a try!

-chadderuski

@chadderuski, would you please package this up into a zip file (with a GPL License and instructions) and submit it to the Free Software Add Ons at the top left of this page? We try to encourage people to go to one single place to get mods, rather than have them scattered around.

Quote:

---

Originally Posted by swguy

@chadderuski, would you please package this up into a zip file (with a GPL License and instructions) and submit it to the Free Software Add Ons at the top left of this page? We try to encourage people to go to one single place to get mods, rather than have them scattered around.

---

I had asked Dr. Byte if it was okay to keep on github while in "beta" and was told yes. I will add the GPL License (forgot about that, this is my first contrib). Once I finish rounding out the attributes and finish the docs, I'll make it an official submission.

Thank you! Developing, collaborating and testing off-site is great, but once it's really ready, this is the best place for it.

Right. Please package and upload new zips here (addons section) when you want people to use them or become aware of new features or milestones.

chadderuski,

Thanks for keeping this mod stable and viable, I think you've made a much needed and professional contribution to ZenCart!

I do need some help though. :)

I've got the mod installed and I've exported all of my product data to see what kind of formatting I need to use for the import process. My client currently has 5,000 products which were manually entered but has access to far more than that. They have been provided a massive amount of product data and I can manipulate that data in whichever way is needed for importing, but apparently I am missing something.

I tried a simple test by entering some mock data into what I [think] is a properly formatted CSV file but the product was not inserted into the database as expected.

I uploaded what I thought to be a properly formatted CSV file and then imported it. My results were as follows:

"Import Results

Filename: Test----NOW.csv"

What did I do wrong? Thanks!

Hi Keezee,

Did you use OpenOffice to export the CSV file?

Also, maintain the file naming convention: "Full-EP"+some text+.csv

You could also attached a sample of your data. Top dozen lines with headers.

-chadd

Hey chadd,

Wow, fast reply! Thanks.

I did try exporting with Open Office, but my file name was way off. I used a file name of ''Test----NOW.csv'

I changed that to "Full-EP2012TEST.csv"

Sadly, that did not work either. Can I use EP4 to simply add one product or will my upload always need to include all of my products?

My test file had only one line aside from headers as a quick test. Here is the top 12 lines of my original export:

Sample CSV file is attached, thanks again! Attachment 10012

I'll take a look at your file now.

No, I regularly use EP4 to export single sub-categories, modify and upload corrections/changes. Yes, you can just use 1 line of data. If fact, that is the very best first thing to do when you want to ensure your data is importing correctly.

Also, be sure you are doing a backup of your data first before running an import. There is an update MySQL database backup tool that work fine on most databases.

BRB

When using OpenOffice:

1) Select File -> Save As
2) Ensure File type: is Text CSV (.csv)
3) check the Edit Filter settings box
4) click save

In the Export of text Files box,

Select your Character set. Probably UTF-8 is you are on zen 1.5 now.
Field delimiter: Comma ,
Text delimiter: Double quote "
you can leave the save cell contents as show box checked.

Even so, your sample data imported to my server just fine.... so I do not know what you could be missing. It looks correct to me.
What version of zencart are you using?

Okay, tested your data on another server. Both 1.39h and 1.5 are pulling your data in okay.

What version of PHP are you running?

Thanks for all the help and tips.

I actually just tried to import the same file I sent to you and it didn't work in my end, odd! I'm using v1.3.9d

The only message I see after uploading and selecting 'import' is:

Import Results

Filename: Full-EP2012TEST.csv

I get no other information. I have idea where to start to fix this.

EDIT: Trying to confirm the version of PHP, but it should be up-to-date.
EDIT 2: ... PHP Version: PHP 4.x

Quote:

---

Originally Posted by Keezee

EDIT 2: ... PHP Version: PHP 4.x

---

couple things:

1) I don't have a server running php 4... that's getting really out dated. It may be one of the functions I'm using will only work correctly in php 5.

2) Can you check your /cache folder to see if you have any error logs.

Your on to something...

Quote:

---

[01-Jan-2012 22:11:09] PHP Fatal error: Call to undefined function: memory_get_usage() in /home/content/b/i/k/bikeral/html/admin/easypopulate_4_export.php on line 295

---

Ah, that function is only available in php 4.3.2 and above and php 5. This is part of the diagnostic code so you can see how much memory is being used by the script.
In some instances certain php setting need to be adjusted (php.ini) to allow more memory usage and/or longer execution time. We should be able to do a work around for you.

Hey chadderuski

Installed EP4 with no problems , Very easy :-)

I am currently looking at writing a little app with Autoit and Open office to add my products to a csv file for importing via EP4

Mostly my store is sells PDF's so I current have an Autoit script that adds products via a web browser and uploads the PDF's . It adds all the Product description and Attributes . Being downloads the attributes are important part of the process.


What I would like to do is add products thru EP4 . What Im wondering is it possible (once you finish the import side) to add product description and product attributes in the one file and then import. Or do you have another way of doing it ?

I'm guess the file needs the correct column headers and it will then import correctly . If this i the case I can code my little Autoit app in anticipation of your fully working script


Also doing a script to convert your output to a turbo lister import file


Thanks for your effort in working on EP4 :-)

Paul

Quote:

---

Originally Posted by Hasher

Hey chadderuski
I am currently looking at writing a little app with Autoit and Open office to add my products to a csv file for importing via EP4

Mostly my store is sells PDF's so I current have an Autoit script that adds products via a web browser and uploads the PDF's . It adds all the Product description and Attributes . Being downloads the attributes are important part of the process.

What I would like to do is add products thru EP4 . What Im wondering is it possible (once you finish the import side) to add product description and product attributes in the one file and then import. Or do you have another way of doing it ?

I'm guess the file needs the correct column headers and it will then import correctly . If this i the case I can code my little Autoit app in anticipation of your fully working script

Paul

---

Hi Paul,

Currently, you will need to have two files. One to update products descriptions, and another to create and assign attributes. This process is much like what you would do in the Admin. Add a new product, then create your attributes, and assign them to the product.

Performing all three at once really complicates the code. Add to the mix proper multilingual support and its that add much more complex. So for right now it will have to remain a two-step process.

What kind of attributes are you creating and assigning to your downloadable products? You may have some detailed attribute information that I'm not addressing as yet. But it should be quite doable.

I will be working hard on the attribute importing code in the days/weeks to come.

-cj

hey cj

With downloading the 'Detailed Products Attributes' it seems to have most fields i use.

Im not sure how the zencart database works but in phpmyadmin I can see a table called 'products_attributes_download` which has 3 fields which I do use:

products_attributes_filename - name of media to d/l and sub folder eg /folder_sub/test.zip . This one seems important one your missing

products_attributes_maxdays and products_attributes_maxcount , These normal fill out to defaults in the attributes admin screen but may need to be added if doing thru the database directly


I think its fine doing a separate Product and attributes import file but Im wondering how your going to match Product description and attributes lines . Assign a products ID or match line for line.

Hope this helps :-)

Paul

Quote:

---

Originally Posted by Hasher

hey cj

With downloading the 'Detailed Products Attributes' it seems to have most fields i use.

Im not sure how the zencart database works but in phpmyadmin I can see a table called 'products_attributes_download` which has 3 fields which I do use:

products_attributes_filename - name of media to d/l and sub folder eg /folder_sub/test.zip . This one seems important one your missing

products_attributes_maxdays and products_attributes_maxcount , These normal fill out to defaults in the attributes admin screen but may need to be added if doing thru the database directly


I think its fine doing a separate Product and attributes import file but Im wondering how your going to match Product description and attributes lines . Assign a products ID or match line for line.

Hope this helps :-)

Paul

---

Hi,

Please note that the attributes downloads links in EP are what I'm using to examine and understand the data's structure. There is no corresponding import of these fields - yet! Yes, there is ANOTHER table 'products_attributes_download' in addition to the products_attributes, products_options, products_options_names, products_options_type, and products_options_values_to_products_options.

These all work together to do your attributes! Now I'm sure the original designers of the attributes features understood them inside out, but I'm reverse engineering my understanding and their relationships so it's been... complex. Additionally, translating this into a functional way to creating/modify/update at import has been a real challenge. I'm on the right track, but it will take some dedicated time to complete this.

Langer had originally attempted to solve this by including every column for every combination of options names and values. If you had 30 attributes with 5 options each that'd be 150 columns. Not what I considered a practical solution.

My solution drastically simplifies the process. If you look at the sample Attrib-EP.csv file you'll see what I mean. Adding the other columns with be easier once I have the BASIC import <> export working correctly. I need to first make the BASIC export match my import file where the product, attribute type, option name, and option values export on line line.

I don't want to promise a solution date, but I will be working on this!

Thanks cf , understand what your trying to do now much better :-)

Hi All,
I have a fresh install of latest version (1,5) on which I've installed EP4. I have imported some products from an oscommerce shop
and I'm trying to move products from one category to another and I get this warning messages in the proccess :

WARNING! - Model: .... - Products name: ".................΄΄" exceeds max. length: 64
SKIPPED! - Model: ..... - Category name: ".................." exceeds max. length: 32

can I change the setting for max length somehow ?

thanks in advance

on second review it has something to do with utf8 categories and product names because none of the above categories or products exceeds the given length (the category is 22 chars and the size in the database is 32 so the length is not the problem). Perhaps someone expert in php can enlighten us?

Quote:

---

Originally Posted by stepgr

on second review it has something to do with utf8 categories and product names because none of the above categories or products exceeds the given length (the category is 22 chars and the size in the database is 32 so the length is not the problem). Perhaps someone expert in php can enlighten us?

---

I have not come across this issue myself and have tested on both 1.5 (UTF8), and 1.39h with/without UTF8. How are you creating your CSV file?

very much appreciate this mod, brilliant :D

Quote:

---

Originally Posted by chadderuski

I have not come across this issue myself and have tested on both 1.5 (UTF8), and 1.39h with/without UTF8. How are you creating your CSV file?

---

from within EP4 I produce a Complete products (with meta tags) and
then I edit the file in libre office and I only change the category
of some products.

just wondering when im trying to import products that are on special that it seems to state that they are products that are not available till 01.09.2012...
yet the other products i import(with the same date) show available from 09/01/2012...
does the specials part use a different date format??

Quote:

---

Originally Posted by stepgr

from within EP4 I produce a Complete products (with meta tags) and
then I edit the file in libre office and I only change the category
of some products.

---

I am unfamiliar with Libre Office. Could you try using Open Office, and refer to an earlier post with instructions on exporting the CSV? OO will let you choose your character encoding on export.

Quote:

---

Originally Posted by spid3r1987

just wondering when im trying to import products that are on special that it seems to state that they are products that are not available till 01.09.2012...
yet the other products i import(with the same date) show available from 09/01/2012...
does the specials part use a different date format??

---

Date handling "should" be the same... can you try using the "Model/Price/Qty (with Specials)" and see if there is a difference? There shouldn't be.

Quote:

---

Originally Posted by spid3r1987

just wondering when im trying to import products that are on special that it seems to state that they are products that are not available till 01.09.2012...
yet the other products i import(with the same date) show available from 09/01/2012...
does the specials part use a different date format??

---

Spid3r,

Under Configuration -> EasyPopulate 4
What is your "Upload File Date Format" set to?

Quote:

---

Originally Posted by chadderuski

I am unfamiliar with Libre Office. Could you try using Open Office, and refer to an earlier post with instructions on exporting the CSV? OO will let you choose your character encoding on export.

---

It's open office actually and I did it also as in the previous post

Quote:

---

Originally Posted by stepgr

It's open office actually and I did it also as in the previous post

---

For some reason it doesn't like spaces in categories (and maybe product names but I'm not sure yet about this). For example I have two languages: Greek and English. When I try to import to a category named various (διάφορα in Greek) it doesn't complain at all, so it's not a utf8 problem either. On the other I hand I have a category named brass parts (ορειχαλινα εξαρτήματα in Greek ) and there is where the problem is shown when I try to import the file.

Quote:

---

Originally Posted by Hasher

Also doing a script to convert your output to a turbo lister import file

---

Paul... this is very interesting and exciting! Would you make this mod available in the free add-ons at some point? I know there would be a lot of interest in it.

Quote:

---

Originally Posted by stepgr

For some reason it doesn't like spaces in categories (and maybe product names but I'm not sure yet about this). For example I have two languages: Greek and English. When I try to import to a category named various (διάφορα in Greek) it doesn't complain at all, so it's not a utf8 problem either. On the other I hand I have a category named brass parts (ορειχαλινα εξαρτήματα in Greek ) and there is where the problem is shown when I try to import the file.

---

Hi Stepgr!

Spaces should NOT be a problem is you are using the Caret ^ delimiter between category names.
Could you post a sample of your data with the problems? Or you can PM me if you'd like.
Also, how are your languages set up? Is english 1 and greek 2? And what is your default language?

It is possible you found something I've missed on the multilingual category import! It WAS quite the challenge!

-chadd

Quote:

---

Originally Posted by chadderuski

Hi Stepgr!

Spaces should NOT be a problem is you are using the Caret ^ delimiter between category names.
Could you post a sample of your data with the problems? Or you can PM me if you'd like.
Also, how are your languages set up? Is english 1 and greek 2? And what is your default language?

It is possible you found something I've missed on the multilingual category import! It WAS quite the challenge!

-chadd

---

I will PM you the file and yes English is 1 and Greek 2 , default is Greek

Quote:

---

Originally Posted by stepgr

I will PM you the file and yes English is 1 and Greek 2 , default is Greek

---

Okay, I know WHAT the problem is ... php's strlen() is NOT mulit-byte aware. So when checking the length, it is count all byte ...

working on a solution now...

For some reason I am having problems with my Easy Populate

http://www.zen-cart.com/forum/showth...34970&page=354


So I am thinking aboout installing Easy Populate 4

I just have a few questions

Will it over write my Easy Populate or will I have 2 options?

Also

Looking at your sample files. I am confused. I understand attributes are in 2 files but where are all the options? Price? Qty? Do you have Minimum Purchase options Order by Qty and all of that?

Milo

Hi Milo,

Quote:

---

Will it over write my Easy Populate or will I have 2 options?

---

You will have 2 options. Easy Populate 4 installs independently of EP 1.2.5.4 and others. Please read first post in this thread for more details.

Quote:

---

Looking at your sample files. I am confused. I understand attributes are in 2 files but where are all the options? Price? Qty? Do you have Minimum Purchase options Order by Qty and all of that?

---

Sorry for the confusion. The sample files are only to show what is currently achievable with attributes importing. Your standard FULL import has everything that 1.2.5.4 has, and much much more.

-Chadd

Thanks for the quick reply....

Please review this following link

http://www.allforyourwedding.com/aut...r-p-16959.html

I work VERY heavy with attribute's.

Will it be able to handle this kind of work?

Quote:

---

Originally Posted by milobloom

Thanks for the quick reply....

Please review this following link

http://www.allforyourwedding.com/aut...r-p-16959.html

I work VERY heavy with attribute's.

Will it be able to handle this kind of work?

---

Milo,

You may become my best beta tester for attributes if willing! LOL! It looks like the vast majority of your attributes are clear cut, and most of this looks importable now. However, I am still working on this feature. I need to make the import/export work smoothly, and right now my importing is a special case. But it does work logically!

Once I have basic attributes settings working correctly, I'll expand into the advance attributes settings. It's proving quite complicated especially when you add multiple language support!

EP 4 Does support Quantity Discounts, so that may be very helpful for you also.

BTW, very nice site!

Sure Thing

What I do is work on 1000's of products at a time...
I try my best to sort them by simular types and attributese
Copy 1 and use the admin side to copy all attributes to categories.

I will install Easy Populate 4 on the site tonight since there is no risk.

I am going NUTS because I cannot get my other easy populate to work. But if I can get the job done and have a way to do attributes then I am very excited to work on this mod to work with you.

Milo

Quote:

---

Originally Posted by milobloom

Sure Thing

What I do is work on 1000's of products at a time...
I try my best to sort them by simular types and attributese
Copy 1 and use the admin side to copy all attributes to categories.

I will install Easy Populate 4 on the site tonight since there is no risk.

I am going NUTS because I cannot get my other easy populate to work. But if I can get the job done and have a way to do attributes then I am very excited to work on this mod to work with you.

Milo

---

Great! Just be sure to read all the notes! EP4 uses Comma delmited CSV files .... 1.2.5.4 uses TAB delimited TEXT, and categories are handled differently. Don't forget to backup your store or use on a testing database until your are familiar with this version.

Quote:

---

Originally Posted by schoolboy

Paul... this is very interesting and exciting! Would you make this mod available in the free add-ons at some point? I know there would be a lot of interest in it.

---

Well Im using Autoit to create this script and it works just fine but I think that anyone using it will need to edit it for their own purposes.

Also I am automating Excel to convert the CSV. As chadderuski says Open office is a better program . Autoit doesnt have great librarys for Open office as yet. Saying that I only have 100 products in my store at the moment so its not a great test but it is faultless in importing products.

Guess there is two important points .This script wont be perfect for everyone and I wont post in this thread as it will cause thread drift .Happy to start another thread

Going to improve it today as i only done a days work on it and I'm by no means a programmer.

If you have a larger file to test with that would be great. Also Im only interested in working with EP4 , not he legacy EP.

Paul

I will be working Dedicated CRON support.

Just a heads up, but I cannot promise as to when I'll get to it! I have another programmer that's interested in working on this too, so may-hap this will arrive sooner than later!
This is actually one of the reasons I've broken the script's files up into import/export so that it would be easier to make a direct call on the script like I've seen
some cron job do. I've never written a cron job before, so this is new territory for me.

Feel free to express your ideas. PM me if you have code to offer.

-chadd

Hi, have zencart 1.5 installed and added EP4.0. Works fine however need to add in my extra fields I have planned for my new site so that they will be downloaded and uploaded via EP4.0. I had this working using the old EP (using info on thread 116061) however cannot get the old EP to work on zencart 1.5.

I have looked at the easypopulate_4_import.php and easypopulate_4_export to try and apply the same logic however the files are totaly different to the previous easy populate data. Presumably these would be the correct files to add in the extra field names.

Any assistance in the location to add extra code for the addition of my extra fields to enable ep4.0 to upload and download them automatically would be much appeciated. Even if its just which php files and line numbers.

Sorry if this does not make sence but have only just started with php code, websites and sql.

Many Thanks

Quote:

---

Originally Posted by dkwwkd

Hi, have zencart 1.5 installed and added EP4.0. Works fine however need to add in my extra fields I have planned for my new site so that they will be downloaded and uploaded via EP4.0. I had this working using the old EP (using info on thread 116061) however cannot get the old EP to work on zencart 1.5.

I have looked at the easypopulate_4_import.php and easypopulate_4_export to try and apply the same logic however the files are totaly different to the previous easy populate data. Presumably these would be the correct files to add in the extra field names.

Any assistance in the location to add extra code for the addition of my extra fields to enable ep4.0 to upload and download them automatically would be much appeciated. Even if its just which php files and line numbers.

Sorry if this does not make sence but have only just started with php code, websites and sql.

Many Thanks

---

It's actually much easier than the old EP. What field names are you adding? And are they only in the products database?

Thanks for quick responce, I have about 8 or 9 that I am adding. Yes they are all in the products database - the same table as product weight etc. some of them are product_pack, product_author, etc

Quote:

---

Originally Posted by dkwwkd

Thanks for quick responce, I have about 8 or 9 that I am adding. Yes they are all in the products database - the same table as product weight etc. some of them are product_pack, product_author, etc

---

The main work is in the includes/functions/extra_functions/easy_populate_4.php file

Go down to the function ep_4_set_filelayout() function. You are going to add layout entries to the "full" case.

Look a the entries for:

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}

And a little further down:

$filelayout_sql = 'SELECT ....
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}

Basically you are going to create your own mod, and add your file layout and sql statements here.

You will need to define your mod in the easypopulate_4.php file, and then there are a number of additional edits to the easypopulate_4_import.php file.

If this is beyond your php knowledge, PM me a list of the field names as they appear in your products table and their field types. Verify them with phpMyAdmin.

But you should be able to puzzle it out easily enough... $ep_supported_mods[] is how I switch on entries for these mods. So they are found pretty easily.

-chadd

**** BUG REPORT **** as of 4.0.17

OKAY, if you are using a multi-byte language (say, greek), the categories will NOT import correctly!

I'm working on a solution, and this has highest priority right now.

Sorry for the inconvenience! I haven't had many people from "way yonder" to help beta test other languages.

-chadd

U have used an easypop4 template that I downloaded from my zen admin.

I modified it and added more products

After adding more products I saved and uploaded back to the site

the site said upload successful, but it did not add any new items or update the one that existed.

any Idea as to how I can get this to work and start loading my items?

Quote:

---

Originally Posted by ediscs

U have used an easypop4 template that I downloaded from my zen admin.

I modified it and added more products

After adding more products I saved and uploaded back to the site

the site said upload successful, but it did not add any new items or update the one that existed.

any Idea as to how I can get this to work and start loading my items?

---

Hi ediscs,

1) Which version of EP4 do you have?
2) Can you attach a sample of your data with headers intact?
3) Did you use OpenOffice to create your CSV file using the instructions at the start of this thread.
You need to use a comma delimited file. Some people have been trying to use data from ep 1.2.5.4
which is NOT directly compatible.
4) Are you sure setup your categories correctly?
5) Did you receive any errors or warnings?

Thanks!

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_product_is_call v_products_sort_order v_products_quantity_order_min v_products_quantity_order_units v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_tax_class_title v_status v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1


Downloaded EP4 from the link at the begining of this thread.
Downloaded spreadsheet from the EP setting in my admin after creating one item to use as a template.
I am sure it is setup correctly, even have an uninstall in the upper right of the admin easypop tab
No errors or warnings at all just Green highlight that says File uploaded successfully: Full-EP2012Jan11-161557.csv

Ediscs,

That is just the headers. Can you attach the Full-EP2012Jan11-161557.csv file?

Quote:

---

Originally Posted by chadderuski

Hi ediscs,

1) Which version of EP4 do you have?
2) Can you attach a sample of your data with headers intact?
3) Did you use OpenOffice to create your CSV file using the instructions at the start of this thread.
You need to use a comma delimited file. Some people have been trying to use data from ep 1.2.5.4
which is NOT directly compatible.
4) Are you sure setup your categories correctly?
5) Did you receive any errors or warnings?

Thanks!

---

csv attached as zip

Ediscs,

Curious.... Did you upload the file and THEN click the Import Link? I was able to import your data fine on my end.

-Chadd

That is what I was missing, I knew I had to be over looking something. thanks.

Just a question is there anyway to track qty on variations so that when a certain amount of them are gone the variation disappears?

Quote:

---

Originally Posted by ediscs

That is what I was missing, I knew I had to be over looking something. thanks.

Just a question is there anyway to track qty on variations so that when a certain amount of them are gone the variation disappears?

---

That would be a question for the general forum. It is possible to setup your store so that when a product reached zero quantity, that it is mark sold out, among other settings. You would also need to explain what you mean by "variations" (which sounds like attributes to me).

chadderuski,
What I meant was I know that there is a way to do it in Zen, there is a sport yo just qty on your variations. I was wondering if there was some variable heading such as v_product_variation_qty that could be added to achieve the same results without going and doing everything manually which takes forever.

Sweet work Chad. I know you have been working for a long time on this. Just installed and updated some prices. Works great so far.

Quote:

---

Originally Posted by mydanilo

Sweet work Chad. I know you have been working for a long time on this. Just installed and updated some prices. Works great so far.

---

Thanks! I have another update coming very shortly. I had to fix the multilingual stuff to handle mult-byte languages for the new UTF8 support in zencart 1.5.

Quote:

---

Originally Posted by ediscs

chadderuski,
What I meant was I know that there is a way to do it in Zen, there is a sport yo just qty on your variations. I was wondering if there was some variable heading such as v_product_variation_qty that could be added to achieve the same results without going and doing everything manually which takes forever.

---

It may be possible, but I will have to know more about this "variations" thing. If you could point me to the exact area where you add or edit this.
Also, is it part of a mod you installed and not the default installation?

Thanks!

Quote:

---

Originally Posted by chadderuski

It may be possible, but I will have to know more about this "variations" thing. If you could point me to the exact area where you add or edit this.
Also, is it part of a mod you installed and not the default installation?

Thanks!

---

If I am not mistaken it was a mod called Stock by Attributes

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,
Great comments and great Add-On!
However, I am having difficulty understanding how to upload new categories. I understand the use of "^" as a separator to show the destination category of a product, —once the categories are present— but I'm not sure how to upload the categories initially.
Which template is used? (I'm assuming it's the 'CategroyMeta-EP2012')
Do I need to add more "v_categories_names_1, 2, 3, etc? Or do I simply put the string with the "^' separator under the "v_categories_names_1" column and let EP4 do the rest?
Do I need to assign v_categories_id?

Sorry, for being so thick, but I don;t quite understand from your instructions.

"Categories are handled differently from other versions of EP. You can now import multilingual categories (Like Products Names, descriptions, etc.).
To achieve this, each v_categories_names_1, v_categories_names_2, etc. correspond to a language installed in your system, and individual category
names are separated by the Carat "^" symbol. For Example: Bar Supplies^Glass Washers^Brushes"

Different Top categories have different depths of sub-categories.

Thanks

Gordo

Hi,

Just discovered this mod. Fantastic effort on creating an improved version for 1.5 but I have a tiny problem. I don’t know if this is specific to me, or if others have had the same issue.

Product Descriptions that are lengthy are not fully uploading.

What I Did:-

1) Installed on EP4 a 1.3.9h site.
1.1) downloaded CSV of products.
1.2) checked data and all was goooood, nothing missing.

2) Installed EP4 on a 1.5 site.
2.1) uploaded said CSV file.
2.2) checked data and all seemed goooood, but on products that have long descriptions, only the first few words of the description uploaded.

No error messages were returned during upload. No errors in my cache folder.

Quote:

---

Originally Posted by Nostragordus

Hi,
Great comments and great Add-On!
However, I am having difficulty understanding how to upload new categories. I understand the use of "^" as a separator to show the destination category of a product, —once the categories are present— but I'm not sure how to upload the categories initially.
Which template is used? (I'm assuming it's the 'CategroyMeta-EP2012')
Do I need to add more "v_categories_names_1, 2, 3, etc? Or do I simply put the string with the "^' separator under the "v_categories_names_1" column and let EP4 do the rest?
Do I need to assign v_categories_id?

Sorry, for being so thick, but I don;t quite understand from your instructions.

"Categories are handled differently from other versions of EP. You can now import multilingual categories (Like Products Names, descriptions, etc.).
To achieve this, each v_categories_names_1, v_categories_names_2, etc. correspond to a language installed in your system, and individual category
names are separated by the Carat "^" symbol. For Example: Bar Supplies^Glass Washers^Brushes"

Different Top categories have different depths of sub-categories.

Thanks

Gordo

---

Hi Gordo.

The CategroyMeta-EP file is not used to create new categories, but to allow you to edit and upload your meta tags for existing categories. I'll have to check, but I thought my documentation was clean on this.

You don't have to create your categories in advance. When you add a new product, you simply define the path that you want it to be in, and EP4 will create that category structure on import.

Quote:

---

Originally Posted by caffeitalia

Hi,

Just discovered this mod. Fantastic effort on creating an improved version for 1.5 but I have a tiny problem. I don’t know if this is specific to me, or if others have had the same issue.

Product Descriptions that are lengthy are not fully uploading.

What I Did:-

1) Installed on EP4 a 1.3.9h site.
1.1) downloaded CSV of products.
1.2) checked data and all was goooood, nothing missing.

2) Installed EP4 on a 1.5 site.
2.1) uploaded said CSV file.
2.2) checked data and all seemed goooood, but on products that have long descriptions, only the first few words of the description uploaded.

No error messages were returned during upload. No errors in my cache folder.

---

Did you install EP4 on the 1.3.9h site?
Did you re-save the CSV that was exported from the 1.3.9h site after checking it?
If you edited the CSV (or resaved an open one), did you use OpenOffice to do this? MS Excel is not the best to use for making CSV files.

It sounds like you may have a character in your descriptions that is confusing the script. This can happen if the v_products_descriptions_1 column is not properly delimited when you edit and re-save the CSV file in excel depending in which version of CSV you pick (native/dos/windows). OpenOffice will properly encapsulate all fields when you save your CSV.

If you can post or PM me a few rows of your data file with the problematic data, I'll be able to help better.

You should be able to Export a CSV and turn around and Import the same CSV with no error (you never opened the file).

-chadd

Quote:

---

Originally Posted by kezerb

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.

Quote:

---

Originally Posted by caffeitalia

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.

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

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?

Quote:

---

Originally Posted by 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?

---

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!

Quote:

---

Originally Posted by caffeitalia

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

---

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

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

Congrats Chadd on your success with EP4. :clap:

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

Quote:

---

Originally Posted by VideoStan

Congrats Chadd on your success with EP4. :clap:

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

---

Hi Stan! How have ya been?

Yeah, Johnny has some awesome stuff in his code. Haven't been in touch for some time. I don't know what he thinks of 1.5. I think zenmagik will have to catchup before he considers supporting 1.5. When I complete attributes for EP4 I'll give him another poke to see if he interested in the code. We had different ideas on how to solve the issue. His were more along the lines of what langer does in his 3.03 version. I have a rant about that somewhere :) ....

You are correct. I do NOT have any nice stats to the attribute import yet. I added the stats so you could turn off "verbose" output for better performance, but since I'm still working hard on the import code so I haven't added stats yet. What "price" are you referring to?

Yes, for Attribute import to work you need to follow naming convention of the file.

I am going to be back on attributes very soon. I got sidetracked fixing the UTF8 multi-byte character handling for multi-lingual categories which I'm going to try to push to github tonight. Then it's back to giving myself monster headaches with attributes!

-chadd

I need to price by attribute. Adding the attributes is good, but have to edit each one to add pricing. All the other attribute issues (default, etc) would be the same, so could set as global (I think).

Looking at your full export, I think it is v_options_values_price.

Quote:

---

Originally Posted by VideoStan

I need to price by attribute. Adding the attributes is good, but have to edit each one to add pricing. All the other attribute issues (default, etc) would be the same, so could set as global (I think).

Looking at your full export, I think it is v_options_values_price.

---

Yes. My plan is to allow simple and complex attribute creation. Simple to create the basic entries and assign to products, complex to make fine adjustments and settings. Trying to do everything at once is very complicated when you take error checking and multiple languages into consideration.

Chadd

is there a way to move products from one category to the other ? I don't want to have
double items in the catalog and I haven't figure out if there is way to do so ?

Quote:

---

Originally Posted by stepgr

is there a way to move products from one category to the other ? I don't want to have
double items in the catalog and I haven't figure out if there is way to do so ?

---

There is currently no built-in support to achieve this. If you add the product with a new category, it will get added as a linked product.

Also note that because of the way the EP4 works, there is no support for DUPLICATE products (i.e. two products with the same model number) or Products missing a Model number...

Having said that, it may be possible to do, but would have wait unfil after I finished attributes.

So you will need to do this from within the admin.

WORK-AROUND: If you are not running a store with order history, you could perform a "move" by creating your sheet with the products listed first with status "9" (delete) and then again below with the new category with status 1. Remember, this will be a "new" product and products_id in the products table will be different. I don't know how this would affect orders, order history, or other mods that may use the products_id instead of the products_model. For a new installation this should be fine. However, you will need to re-upload the images for these files as the zencart function for deleting a product also deletes the associated image if not used by another product.

Update v.4.0.18 - Beta 1-27-2012 Posted on Github

This update fixes several issues with UTF8 multi-byte characters, and adds a new configuration variable for dealing with "curly quotes" (aka smart quotes), En-Dash, Em-Dash and the Ellipsis (three dots like ...). Also added support for products_msrp mod.

To Update:
1. First make note of your settings under Configuration -> Easy Populate 4
2. Uploading the new files to your website's admin folder maintaining directory structure
3. Navigate to Tools -> Easy Populate 4 and select "Un-Install EP4" (this will remove the configuration variables)
4. You will now have 2 warnings at the top. Click the "[ here ]" to install new configuration variables.
5. Navigate to Configuration -> Easy Populate 4. At the bottom is a new setting: Convert Curly Quotes, etc. Choose one of the following:

0 = No Change (will not convert your characters)
1 = Replace with Basic Characters (will replace a curly quote with simple quote, etc.)
2 = Replace with HTML (will replace with HTML equivalants)

As always, please be sure to backup your data before doing imports. Test first with just a couple rows of data.

I'm also looking for sample data for Greek, Russian, Simplified Chinese, etc. or people that can test and verify these language are being handles correctly.

NOTE: I've made every effort to correctly support zen 1.5's UTF-8 character set. This should not affect 1.38/39 users who have not converted to UTF-8. If you find an issue, please post sample data (I only need a few lines showing the problem), and specify which version of zencart you are using, and the character set (UTF-8 vs ISSO-8859-1) you are using on your website. If you have other languages installed, also include those.

When installing multiple languages, it's best to leave english as the first installed language. Remember, the 1, 2, 3, etc. under Installed Languages refers to THAT language.
Example: 1=english, 2=spanish, 3=dutch, then you will have v_products_name_1, v_products_name_2 and v_products_name_3... one for each language.

This also applies to v_categories_names_1, etc. You MUST include v_categories_names_1 (the lowest defined language), but the others are optional - they will default to the first defined language. v_categories_names_1 is very important if you plan to support categories in multiple languages as all category matching and creation is based on this column.

Thanks again to everyone who is testing and providing feedback!

... I'm back to the attribute grind stone ...

Quote:

---

Originally Posted by chadderuski

Having said that, it may be possible to do, but would have wait unfil after I finished attributes.

So you will need to do this from within the admin.

WORK-AROUND: If you are not running a store with order history, you could perform a "move" by creating your sheet with the products listed first with status "9" (delete) and then again below with the new category with status 1. Remember, this will be a "new" product and products_id in the products table will be different. I don't know how this would affect orders, order history, or other mods that may use the products_id instead of the products_model. For a new installation this should be fine. However, you will need to re-upload the images for these files as the zencart function for deleting a product also deletes the associated image if not used by another product.

---

Thanks anyway Chadd. The workaround you provide is also good
for a new installation so it's OK by me anyway!

This is a great improvement for many users whose uploads fail for all those "odd" reasons!

... I'm back to the attribute grind stone ...

Go Chadd go!

Chadd
Thanks so much for this - it's such an improvement.
Can't wait for the attributes to work.

Sarah
www.shop4costumes.co.uk

In my excitement I forgot to actually type what I intended to....we have come across something strange which may be related to the mod, or it could be a problem with our server.

Our test site is on a separate server to the live site, and the hosting co strangles the processing time.
I exported the data from our live site. No problem. File created. (Different hosting co with more bandwidth).

I wanted to import this to our test site. Tried to import but timed out.

To get around this I split the files - that worked fine - but then when I tried importing one of the split files it still timed out. The file size doubled. when I download the now larger split file it has duplicate entries - so rather than 2000 it now has 4000.
So I deleted all EP files and then changed the no of items to 500.

My original file then split to 8, I imported the first file witha file size of 389k. It still timed out, but then the size of every one of my split files doubles. I checked the file sizes on the server too.

When I look at the content all items seem to have duplicated.

If I try again, same happens again. and all records duplicate again.

The csv files just increase in size each time.
Each time they appear to add the records again, so after 2 failures each file contains 3 identical lines of data for each item.

There is clearly an issue with the server which is why we are only keeping our test site on it. But the behaviour may be something you need to be aware of.

I'm sorry I'm not a techie so dont know if that's enough to help or not. And it may be nothing to do with your mod.

Thanks
Sarah
www.shop4costumes.co.uk

Hi, me again, I really dont know if the problem above was due to to EP4 or to due to our hosting co.
I got around this problem by importing my original database into the test site. Happy to try testing any new developments but I will need to do it on the live site.
Thanks again
Sarah
www.shop4costumes.co.uk

Quote:

---

Originally Posted by shop4costumes

Hi, me again, I really dont know if the problem above was due to to EP4 or to due to our hosting co.
I got around this problem by importing my original database into the test site. Happy to try testing any new developments but I will need to do it on the live site.
Thanks again
Sarah
www.shop4costumes.co.uk

---

Hi Sara,

Seems you've found a bug!

When you run the split the FIRST time, and the number of records set in configuration is LESS then the number to split on, it duplicates the file. This is okay, and expected behavior.

However, if you then run SPLIT on the original file AGAIN, the target split file is being APPENDED instead of being OVERWRITTEN. My bad!

The FIRST time you SPLIT will be okay. But you'll need to delete the split files before attempting to split again. How many records do you have in your original data file? Try setting your split value to half this number.

To help with timeout, you can also set your "Script Execution Time" to something larger than 60 ... but I don't think that will help if your testing server is that strangling.

I'll try to get this fixed right away! Very sorry for the inconvenience!

-chadd

FILE SPLITTING BUG

To fix open /admin/easypopulate_4_split.php

On line 34 change:

PHP Code:

---

        $split_handle = fopen($split_location, "a") or die("can't create split file"); 


---

to:

PHP Code:

---

        $split_handle = fopen($split_location, "w") or die("can't create split file"); 


---

Thank you Sara for making me aware of this!
-chadd

Github has been updated with this latest fix for file splitting: Easy Populate 4.0.19 - Beta 1-28-2012

I am having an issue loading my prices.. Everytime I load the prices it always makes all the products the same price as item #1 .. I am using the v_products_price column to price it.. Any ideas on how to fix this? Thanks in advance

Quote:

---

Originally Posted by worp

I am having an issue loading my prices.. Everytime I load the prices it always makes all the products the same price as item #1 .. I am using the v_products_price column to price it.. Any ideas on how to fix this? Thanks in advance

---

Hi Worp,

Could you send me a PM and attached your CSV file? Which Import file are you using? The Full or one of the Pricing Imports? Which version of Zencart are you using? I'll need to see your data in order to identify what's going on.
Are you using the lastest beta 4.0.19?

Thanks.

Quote:

---

Originally Posted by worp

I am having an issue loading my prices.. Everytime I load the prices it always makes all the products the same price as item #1 .. I am using the v_products_price column to price it.. Any ideas on how to fix this? Thanks in advance

---

Thanks for PMing the data file.

You have a very simple (but often common) problem. Your v_products_price column has a space at the end of it=> ...,v_products_price ,...
Remove that space from your Import file, and it will work correctly. This is easy to miss, and hard to see when viewing your worksheet.

This same kind of problem (trailing spaces) can affect important columns like v_products_model, v_manufacturers_name, and v_categories_names
resulting in what appears to be duplicate entries.

Having an odd issue here.

After having uploaded the file, and products imported, the products are showing under Categories/Products. However, upon entering/editing the product, there's no info within each of the products. The product info can be seen on the page, but not when I tried to edit the product within zen cart.

Hi
I have uploaded my .csv file.
I can not see any import button to click??
The only mention of imports I see is at the bottom of the page relating to the files I have downloaded?
Cheers Steve

Quote:

---

Originally Posted by dlt1

Hi
I have uploaded my .csv file.
I can not see any import button to click??
The only mention of imports I see is at the bottom of the page relating to the files I have downloaded?
Cheers Steve

---

You first Upload your file, and then click the Import hyperlink to Import the file.

Quote:

---

Originally Posted by kin0kin

Having an odd issue here.
After having uploaded the file, and products imported, the products are showing under Categories/Products. However, upon entering/editing the product, there's no info within each of the products. The product info can be seen on the page, but not when I tried to edit the product within zen cart.

---

You can see the products_description when you view Online Catalog, but you cannot see you descriptions when you edit them? Are you sure you didn't mistype the 'v_products_description_1' column?

Which version of zencart and EP4 are you using?
Do you have multiple langugages installed?
Attach or PM me a portion of your data file.

-chadd

Chadd,

Thanks for your help can't believe I overlooked it.. Now in the status screen I see that the product has pricing but when I go back to the actual cart the old pricing is still set the issue I had it loading at 30.99.. How do I force it to update the pricing from the file I am currently loading? Thanks

Quote:

---

Originally Posted by worp

Chadd,

Thanks for your help can't believe I overlooked it.. Now in the status screen I see that the product has pricing but when I go back to the actual cart the old pricing is still set the issue I had it loading at 30.99.. How do I force it to update the pricing from the file I am currently loading? Thanks

---

Did you refresh the page, or clear your browser cache? You can see the correct price when viewing from within the admin Catalog -> Category/Pricing?

Alternately, navigate to Tools -> Store Manager and run 'Update ALL Products Price Sorter'

I cleared the cache & also reset the products price manager.. And even when I go into the product price manager it shows the price still at the 30.99 and not the newly updated pricing.