Easy Populate 1.2.5.4 support

I have installed easy populate on 1.3.8a and created csv files with my products. Now I installed it also on new 1.3.9a and I am trying to import that product file into database only to get the following error:

Code:

---

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
SELECT
                        p.products_id as v_products_id,
                        p.products_model as v_products_model,
                        p.products_image as v_products_image,
                        p.products_price as v_products_price,
                        p.products_weight as v_products_weight,
                        p.products_last_modified as v_last_modified,
                        p.products_date_added as v_date_added,
                        p.products_tax_class_id as v_tax_class_id,
                        p.products_quantity as v_products_quantity,
                        p.manufacturers_id as v_manufacturers_id,
                        subc.categories_id as v_categories_id,
                        p.products_status as v_status,
                        p.metatags_title_status as v_metatags_title_status,
                        p.metatags_products_name_status as v_metatags_products_name_status,
                        p.metatags_model_status as v_metatags_model_status,
                        p.metatags_price_status as v_metatags_price_status,
                        p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS  FROM
                        Retail_products as p,
                        Retail_categories as subc,
                        Retail_products_to_categories as ptoc
                        WHERE
                        p.products_id = ptoc.products_id AND
                        ptoc.categories_id = subc.categories_id

---

I have checked the column headings and they are identical. I have one extra field - short_description, that shows on both headings, but I have no idea what should be in EASYPOPULATE_CONFIG_CUSTOM_FIELDS (which is empty)

Any help/suggestion would be appreciated!
Veronika

Quote:

---

Originally Posted by schoolboy

I got a similar response until I put back-quotes around the table and field names:

UPDATE `products` SET `products_qty_box_status` = '1'

---

This used to work. Now, I still get the 'failed' message. Something to do with the v139 change, perhaps?

I would really like to be able to use the model number for the zipcode. I have a dating site, and I would like someone to be able to enter in a zip code and see all the different results.

Is there no possible way for this? I have read that model number is a key field.

But on wiki I also read that as long as you have them in different categories it should work.

:frusty:

Quote:

---

Originally Posted by francesca_ph

The error message i get:

Warning: file(/home/musicalv/public_html/o-bean.com/temp/temp/) [function.file]: failed to open stream: No such file or directory in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1223

Warning: Invalid argument supplied for foreach() in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1301

---

Any Fix For this???:frusty:

admin/easypopulate.php on line 1301

m/admin/easypopulate.php on line 1223

Quote:

---

Originally Posted by pixelpadre

I would really like to be able to use the model number for the zipcode. I have a dating site, and I would like someone to be able to enter in a zip code and see all the different results.

Is there no possible way for this? I have read that model number is a key field.

But on wiki I also read that as long as you have them in different categories it should work.

:frusty:

---

OK I have a work around that I found after reading other posts.

Easy way is to use the Manufaturers name as zipcode. This allows you to have an unlimited number of products with the same zipcode/manufacturer name.

Of course now you will have to go to admin/tools/developer tool kit and search for every occurance of manufacturer and replace it with Zipcode. Do this carefully as you dont want to change variable names, just the values of variables. I had already done that for product model but now I will scrap that since I can only have one unique occurance of product model.

I have already instituted this without any problem.

Other option is to list your products as Music. This will give you three additional fields, Artist, Genre and company. Again, you will have to go to developers tool kit and search for each occurance and change them to reflect your needs.

Either one of these options works really slick. If you are not using manufacturer name, as most probably aren't, I recommend going that route. Of course that will only give you one additional field. Good enough for me.

Good Day, I've a bit problem :(

I've installed easypopulate 1.2.5.6 in my (test) zencart, but in admin panel I don't seen any choice for easypopulate.
I've (how specified in install.txt) copied all contents of directory admin of easypopulate into directory admin of my site but don't work :(
I've forgotten something?
I hope in your help :)
Thanks.

Quote:

---

Originally Posted by stefanoxjx

Good Day, I've a bit problem :(

I've installed easypopulate 1.2.5.6 in my (test) zencart, but in admin panel I don't seen any choice for easypopulate.
I've (how specified in install.txt) copied all contents of directory admin of easypopulate into directory admin of my site but don't work :(
I've forgotten something?
I hope in your help :)
Thanks.

---

It doesn't show up in the Tools menu?

Quote:

---

Originally Posted by mzimmers

It doesn't show up in the Tools menu?

---

Exactly!!!

There's not much that can go wrong here. EP consists of only two files. If you have both of those files in the correct directories, it pretty much has to work. Remember, you need to reload your admin page (hit "refresh") on the browser to see this after you upload it.

Is your admin directory named something different?

What version of ZC are you running?

Quote:

---

Originally Posted by mzimmers

There's not much that can go wrong here. EP consists of only two files. If you have both of those files in the correct directories, it pretty much has to work. Remember, you need to reload your admin page (hit "refresh") on the browser to see this after you upload it.

Is your admin directory named something different?

What version of ZC are you running?

---

In testing version of my zencart the admin directory isn't renamed.
I've copied from folder of easy populate /admin/easypopulate.php in directory /admin of my site and easypopulate.php from folder of easy populate /admin/includes/languages/english in same directory of my site.
My default language is Italian and I've too create directory admin/includes/languages/italian and copied easypopulate.php from english to it.
I'm running zencart 1.3.8

--
Stefano

Caro stefano

I would recommend that you reinstall for starters. Then Add one item in your store using the usual method. Then go to admin tools easypopulate and down load the csv file.

Then open the csv file in open office scalc. Then fill the fields with the appropriate information. Remember ALL product models must be unique. Save the file to a different name. Then go to admin tools easy populate and upload the csv file.

It must work.

Saluti
Don Stefano
www.1waytofindout.com

Quote:

---

Originally Posted by pixelpadre

Caro stefano

I would recommend that you reinstall for starters. Then Add one item in your store using the usual method. Then go to admin tools easypopulate and down load the csv file.

Then open the csv file in open office scalc. Then fill the fields with the appropriate information. Remember ALL product models must be unique. Save the file to a different name. Then go to admin tools easy populate and upload the csv file.

It must work.

Saluti
Don Stefano
www.1waytofindout.com

---

Sei Italiano?
In tal caso perchè non mi scrivi in italiano così mi capisco meglio?
Grazie :)

Translate:
Are you Italian?
Why you don't write me in Italian so I understand better?
Thanks :)

This is an English site.

You did install the database files correct?

Quote:

---

Originally Posted by pixelpadre

You did install the database files correct?

---

Wich database?

In install.txt is wrote:

Code:

---

1) Change the name of the "admin" directory in this package to suit your zencart installation
2) Upload all files in their respective directories.
3) If this mod gives you more time with your family or friends, and/or less customer headaches, please
  consider a donation and email me shafiqsa19######################

That's it!

---

In point one, I haven't renamed directory admin because in my installation have same name
In point two, I have correctly uploaded the files into respective directories, but I haven't seen istruction for installing database.

My testing installation of zencart work fine and I've installed other external modules that it work fine (eBay Exporter, CrossSell and Apsona-Shop-Admin).

I've re downloaded Easy Populate and remaked the installation, but it don't work.
I don't see any item "Easy Populate" in tool (Strumenti in italian) menù!

Thanks for help :)

Did you notice the .sql file?

you must cut and paste contents into your sql program. or go to tools admin sql patch and upload.

This is no doubt your problem.

Quote:

---

Originally Posted by pixelpadre

Did you notice the .sql file?

you must cut and paste contents into your sql program. or go to tools admin sql patch and upload.

This is no doubt your problem.

---

ahhhh!!!! ok thanks for your help, but in zip file that I've downloaded from http://www.zen-cart.com/index.php?ma...roducts_id=395, there isn't any .sql file.
Where I can to find it?
Thanks.

You are correct. Try the other versions.

Quote:

---

Originally Posted by pixelpadre

You are correct. Try the other versions.

---

Thanks :cheers:

Sorry for question (maybe was made): when my product have price with attributes, I export it (product and attributes) but when import it the price is 0.
Looks this: http://www.100asa.it/rotolo-etichett...900-p-416.html and then http://www.grandufficio.com/rotolo-e...900-p-416.html
I hope I'm clear. Thanks for reply

Hi guys,
I have installed Easypopulate (for the second time - it worked fine on another site a couple of years ago).
This time, all seemed well. I created one product, downloaded the csv file, added another 63 products to that file and re-uploaded. I get all the right signals - upload complete, file contents listed on Easypopulate page etc - but no products appearing on the site.
Tried installing the SQL patch via Tools but apparently it was already there.
What could be going wrong? Have read through this thread but can't get an answer.
Thanks...

Maybe a clue - the uploaded file is not appearing in the temp directory either. I have fixed the permissions to 777.

IGNORE THIS! It's there. Sorry. But still no products on the site.

hi .Is there anybody can help to solve this problem ?
Default Re: Easy Populate support for Version 1.2.5.4
face another problem again .

Today press the Create Complete tab-delimited .txt file in temp dir (Attributes Not Included)

after that I Download Complete tab-delimited .txt file to edit (Attributes Not Included)

but when i download it .it just 12KB( Before that it' 4MB FILE) and when I open it .It's a empty .txt file .

but when I try to down load the following file is ok

Model/Price/Qty tab-delimited .txt file to edit
Model/Category tab-delimited .txt file to edit
Froogle tab-delimited .txt file
Model/Attributes tab-delimited .txt file

Is there anybody can help told me what happen and how can i download my Complete tab-delimited .txt again .thanks

you must add one item to your store using the traditional method. After that you can use easy pop

If anyone's interested, I found what I did wrong - I didn't have "EOREOR" at the end of each record, just the first one. So it was only uploading the first record each time.

PIXELPADRE
You mean i must add one item to my store in the traditional method ?
just now i try .
but when i download it . it is still empty and the fille size is 0 M

Quote:

---

Originally Posted by pixelpadre

you must add one item to your store using the traditional method. After that you can use easy pop

---

Hi There,

I bought Easy Populate yesterday (the latest version) and I have uploaded everything as it said and I can see everything from the Tools option and the admin section.

But what I am having trouble with is uploading new product and changing products.

I have already 2000+ products online which were manually uploaded, zen cart version is 1.3.8 (not the latest version yet) but whenever i upload there are no problems and it even says that "priceQty_100517_09394.txt successfully uploaded to server" but when i go to the live site there are no changes.

Each product has the "EOREOR" but still this isn't working.

I would greatly appreciate any help.

Warm Regards,
Kev

Ok i installed ep to web and was zooming through items adding them right and left then as requested by zen cart I should rename admin file so i did and then all heck went wrong with ep I get
Connection Interrupted

The connection to the server was reset while the page was loading.

The network link was interrupted while negotiating a connection. Please try again.

Thinking file upload was to big i down to just 2 products and same thing. I tried to uninstall ep to reinstall and get
Easy Populate Configuration Missing. Please install your configuration

I reinstall by clicking were asked and shows
Easy Populate support & development by langer. Donations are always appreciated to support continuing development: [email protected]
Success Installation Successful! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products.
Success File Full-EP2010May26-0505.txt successfully exported! The file is ready for download in your /temp/ directory.

But in reality i am back to the beginning of connection interruption and if I follow as i did above this message i get same messages as before. Can anyone get me advise on what happen by just changing admin folder name..

Are you using EP 1.2.5.4... or the Commercially available version?

using EP_v1.2.5.4

using EP_v1.2.5.4

as too my preveous help i asked for looks like i can Download EP and Froogle Files and Create EP and Froogle Files in Temp Dir (temp/) but get the errors when only i go to insert into db again i am using EP_v1.2.5.4

i use /webspace/httpdocs/tempEP i think that is the defult , make sure you have chmod set to 777 or atleast 766 for the folder

I am trying to upload from my vendors csv file. using all the current versions of the software 1.3b and 1.2.5.5,

i got everything working but the Manufactuer field. it always comes up blank on the website.
i added the manuf to ZenCart, i checked that they exactly the same.

I am running out of ideas.

Any suggestions?

I have an EP file that does not reflect the actual inventory count. There are linked products in the store from where the file was downloaded. Does EP include an identical item twice; once for each category it's listed in? I'm thinking this is what is happening but would like clarification so I know for sure this is what is going on.

is there a way to add a new download to easy populate?? my product numbers are just numbers ie 1234, i would like a download for product number/product name/price only simulate to what you get as standard but with product name as well

Quote:

---

Originally Posted by buildingblocks

I have an EP file that does not reflect the actual inventory count. There are linked products in the store from where the file was downloaded. Does EP include an identical item twice; once for each category it's listed in? I'm thinking this is what is happening but would like clarification so I know for sure this is what is going on.

---

and

Quote:

---

Originally Posted by kitcorsa

is there a way to add a new download to easy populate?? my product numbers are just numbers ie 1234, i would like a download for product number/product name/price only simulate to what you get as standard but with product name as well

---

I would suggest Apsona ShopAdmin, which IMHO does a better job with these kinds of tasks.

Apsona
http://apsona.com

txcharms Changing the admin folder name should not impact on EP at all, EP really only connects to the database and reads a .txt file and inserts/deletes/updates each product in that file. The name of the admin folder has no baring as EP working and sits within that folder which can be called anything you would like. I would suggest it is a hosting issue if everything have been working OK. Cheap hosts do put limits on memory usage and this maybe the issue.

stantcb Firstly I would use version 1.2.5.4, as other versions have several bugs, if you search the forum you will see there is a thread for your version 1.2.5.5 who may be able to help as this is support for version 1.2.5.4.

buildingblocks EP works by inserting an product which has a unique model name/number (ie bag_of_sugar) in the 'products' table. From that the products_id is listed in the 'products_to_categories' table, so you could have the same product listed in several categories.

PHP Code:

---

in the 'products' table :
bag_of_sugar > products_id = 1

in the  'products_to_categories' table it would be :
products_id = 1 categories_id = 1
products_id = 1 categories_id = 2
products_id = 1 categories_id = 3
products_id = 1 categories_id = 4 


---

So you will see it is the same product for all the categories, EP is just inserting/linking the product to the category. So if you update bag_of_sugar in category 1 it will update all the categories the same. So if you are just updating the product you do not need to have all four in the .txt just one.

kitcorsa Sorry can you explain a little more? Where do you get the product name from if you just use numbers ? Please give an example.

kevinme EPA is a commercial product, I would suggest contacting the supplier. I have read there is not any activity on support, I do not know what warranties/support EPA comes with look into it.

Scrat thanks for responding


This file has 4500+ products where there are only 3600+ actual products.

I don't know of a way to exclude the linked items other than by excluding a category from EP and that wouldn't work because there are items in those cats that do need to be included.

buildingblocks Have a look at this file.

Please note this has no guarantees or warranties only use on a test site until you are totally happy it works as I HAVE NOT TESTED IT :no:
New Complete Download file without categories and no duplicates. Complete - No Categories
Very Important Note
If you upload a new product in this format it will not have a category, so you would need to set a category manually. As I have not tested it it may have other issues so TEST, TEST, TEST

File Location : admin/easypopulate.php

Quote:

---

Originally Posted by Scrat

buildingblocks Have a look at this file.

Please note this has no guarantees or warranties only use on a test site until you are totally happy it works as I HAVE NOT TESTED IT :no:
New Complete Download file without categories and no duplicates. Complete - No Categories
Very Important Note
If you upload a new product in this format it will not have a category, so you would need to set a category manually. As I have not tested it it may have other issues so TEST, TEST, TEST

File Location : admin/easypopulate.php

---

Thanks. I'll check it out.

On another note the descriptions in a working store contain simple html <br> tags. We exported these items to EP and we are encountering a problem that when importing this easy populate file into another store, the descriptions end up getting extra <br> tags inserted

When I look at the descriptions in open office calc they look just like this

HTML Code:

---

<b>Title:</b>
<br>
Magazine Ad For Sunkist oranges
<br><br>
Measures: 10x10
<br><br>
<b>More Information</b>
<br>
Womans Day Sunkist Lemons Ad June 1962 issue.
<br><br>
<b>Condition</b>
<br>
Vintage ad with some fade, light edge wear with torn edges on one side.

---

and when importing into zen cart this way, extra <br> tags are being added making large gaps between lines so the descriptons don't look nice.

But if I manually edit the descriptions and merge the lines like this:

HTML Code:

---

<b>Title:</b><br>Magazine Ad For Sunkist oranges<br><br>Measures: 10x10<br><br><b>More Information</b><br>Womans Day Sunkist Lemons Ad June 1962 issue. <br><br><b>Condition</b><br>Vintage ad with some fade, light edge wear with torn edges on one side.

---

and then import the file to zen cart, the description displays as it should. No extra <br> tags get added.

Any ideas how to get around this problem without having to manually edit each and every description?

buildingblocks By the looks of it you may have carriage returns '\n' and line breaks '<br>' in the descriptions. So when you import depending on the browser you will see two lines instead of one.

thanks again scrat. The \n was it.

Just thought I'd poke my head in and say hi. I've logged in for the first time in like 9months and had a number of PM's. I only had one client who used ZenCart, and I moved them over to the now defunct Chromium Cart which merged back into Open-Cart, which is nice and free too.

After the joke that was version ZenCart v2.0 I got sick of it.

I now work a lot on CS-Cart, which is really fabulous. It has a couple issues here and there, but it's 300% better than ZenCart, but not free.

So I don't really have any use to work on EP 1.2.5.5CSV anymore.

But to all you who still use ZenCart, you have my sympathy and condolences.

Thanks,
Adam

Hi -
Am using EP 1.2.5.4 which works just great.
However, I am trying to do a model no./attributes download, but every time I try the system crashes and I get a message
"[an error occurred while processing this directive] ".
Any suggestions as to what I can do?
Thanx in advance
Rufus

rufusclc If you have not changed any code I would suggest it is a server issue, whether Mysql or PHP.
Have you tried a download to /temp folder on the server ?

If you haven't changed any code and you are using Langer 1.2.5.4 version, I would have a word with your server support, as Mysql or PHP may need a restart.

Hi,

I got a "product debris" warning message from EP which suggested using phpmyAdmin to remove the debris.

however, i cannot find the product_id in phpmyAdmin.

in the store export file, i see 2 product_id's for 1 product_model. When i search in phpmyAdmin by product_model, it only shows 1.

How do i find that debris?

w2e This is a 'known' bug in V1.2.5.4 if you search this thread you will find out how to remove the warning

it's not a bug though.

my store export files do show 2 id with the same products...?

w2e Sorry I am a little confused...

Quote:

---

1. my store export files do show 2 id with the same products...?

---

Quote:

---

2. "product debris"

---

are to separate issues,
1. Give a example of your .csv, have you got this product in two catorgies ? If you have this is normal as if you look at the cat. that those product id's are in will be different.

2. 'Yellow bar'

Quote:

---

x.Number; partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances.

---

at the top of EP main page is a known bug in this version

Actually, only 1 product/item/category is supposed to correspond to this one product_model. I saw the "debris" warning a day ago and thought that the problem is because of the "debris."

The problem is my store (using the side-box "search" on my site) shows a product/item count of say 2000, while there are actually only 1000 items. The store export file shows 2000, with 1000 duplicates whose only differences are the product_ID's. These duplicate items' product_id's cannot be found in phpMyAdmin.

So how can I delete these duplicates?

Thanks for any help.

w2e The 'products_model' is unique to each product, thus you can only have 'one' product in the 'products' table with that 'products_model' ref. But you can have that same unique 'products_model' in all your categories, so if you have four categories you would have four products not one. If you look in your 'products' table you should see that you will have only one product, if you then look in the 'products_to_categories' table you will see the products_id to the categories_id.
I think you are getting a little confused around 'products_model' to 'products_id' as these are two entirely two different things.
I would suggest give us an example of your .csv export file and we can see what you are looking at, this would then be very clear to see what your problem is ?

These are the 2 duplicate items in my store export file:

v_products_id v_products_model v_products_type v_products_image v_products_name_en v_products_description_en v_products_url_en v_specials_price v_specials_date_available v_specials_expires_date v_products_price v_products_weight v_products_date_available v_products_date_added v_products_quantity v_manufacturers_name ptc_categories_index_path ptc_categories_destination_path ptc_categories_linked_path v_tax_class_title v_products_status EOREOR
1288246 IIS-BO2010A Product - General IIS/BO2010A-H0.jpg Muay Thai Boran Book - de Cesaris Muay Thai Boran by Arjan Marco de Cesaris. The martial art of Thailand. Endorsed by AITMA. History, techniques, training, interviews, and more. 207 pages. 7 in by 9.5 in. ISBN #9781897307502. 24.95 2 0000-00-00 00:00:00 06/28/10 02:00 AM 10 Martial Arts/Self Defense IIS 1 EOREOR
1294929 IIS-BO2010A Product - General IIS/BO2010A-H0.jpg Muay Thai Boran Book - de Cesaris Muay Thai Boran by Arjan Marco de Cesaris. The martial art of Thailand. Endorsed by AITMA. History, techniques, training, interviews, and more. 207 pages. 7 in by 9.5 in. ISBN #9781897307502. 24.95 2 0000-00-00 00:00:00 07/02/10 04:51 AM 10 Martial Arts/Self Defense IIS 1 EOREOR

w2e By the looks of it you are using EPA or a other version of EP (than 1.2.5.4).
From what I am seeing you have two entries in the database :

products_id => 1288246
products_id => 1294929

It looks as if the version you are using uses the v_products_id as the key not the products_model. Are you sure you have not got both these entries in the database ?

What version are you using ? (Always a good idea to specify as this save you time)

As you will see from the thread there are several version available of EP, the most reliable one is 1.2.5.4 all others have bugs...

is there a way that when i download my CSV file from easy populate that the prices in the price colum is the price INC VAT.

this would save me hours and hours of working out prices without vat on my calculator.

Quote:

---

Originally Posted by kitcorsa

is there a way that when i download my CSV file from easy populate that the prices in the price colum is the price INC VAT.

this would save me hours and hours of working out prices without vat on my calculator.

---

For example, in the UK VAT is 17.5%, so you make a new column in Excel (or OpenOffice calc) and in B2 you put =A1*1.1.75 (assuming your prices are in column A) and copy down the column.

If you want to copy back the VAT-inclusive prices, just select them all, then paste-special, and you want just values (otherwise you'll have a circular reference)

going to ask again but explain more as requested,

------

is there a way to add a new download to easy populate?? my product numbers are just numbers ie 1234, i would like a download for product number/product name/price only simulate to what you get as standard but with product name as well

------

when i click on admin>tools>EP and the download the Download Model/Price/Qty .csv file to edit button what i get is the model/price and the qty which would be great but my products dont have modelnumbers relevant to the item ie my iteams are just numbered (ie 12345), is there a way to add to this csv download so it would download the model/item name/price/qty so i know what item im chanign the price on. Downloading the complete file is just over kill and a nightmare working through just to update prices and stock

kitcorsa Yes anything is possible, but the difficulty is that ZC works its prices out from the 'net' amount applying the Tax appropriately, it would mean coding in EP to do this which would be a little in depth. I would go down the OO or excel route personally if you don't know php very well or seek a custom coder.

Quote:

---

Originally Posted by kelvyn

For example, in the UK VAT is 17.5%, so you make a new column in Excel (or OpenOffice calc) and in B2 you put =A1*1.1.75 (assuming your prices are in column A) and copy down the column.

If you want to copy back the VAT-inclusive prices, just select them all, then paste-special, and you want just values (otherwise you'll have a circular reference)

---

Thats alot of work to do and very complex for some with limited computer skils.... im trying to give work away to other members of staff and releve my time to do more important things.

I need it so my member of staff (prob a temp) can be given a CSV file which has the product model number, name, prices (inc vat) and qty and all they have to do is copy over the prices given to use via our suppliers (in an excell file) or go through them and change the price to suit (when we get prices changes emailed to us as text files ie product AA bats was £1.99 now £1.55 inc vat)

this VAT export would be great as well if it got the vat price from the default VAT code on the site as you all know the UK vat is going to change again soon.

Quote:

---

Originally Posted by Scrat

kitcorsa Yes anything is possible, but the difficulty is that ZC works its prices out from the 'net' amount applying the Tax appropriately, it would mean coding in EP to do this which would be a little in depth. I would go down the OO or excel route personally if you don't know php very well or seek a custom coder.

---

yeah i know that ZC doent store the vat prices in database... i knew this would be a pain but thought id ask anyhow...

just trying to figger oiut a quick way without having to teach or emply someone who knows how to us excell in depth

So far in excell i would have to..... add a new colum called price inc vat and write in all the prices inc vat down the colout to suit the item (this is there the product name would come in very helpfull in the model/price/qty download) type in the price including vat then in anohter colum minus the vat. use excell to minus the vat and once complete copy the minus colum and paste special into the EP price colum?? delete the 2 new colums and upload to the site?? this would have to be done everytime i want to update prices (about 5 times a week :S)

after studing the code ive managed to add the product name to the product model/price/qty download but adding the following at line 555

Code:

---

        foreach ($langcode as $key => $lang){
            $l_id = $lang['id'];
           
           
            $filelayout[] = 'v_products_name_' . $l_id;
                   
        }

---

and changing the line

Code:

---

<a href="easypopulate.php?download=stream&dltype=priceqty">Download <b>Model/Name/Price/Qty</b> .csv file to edit</a><br />

---

now at line 2263

looking into adding the vat now.... but this will need further testing as it will need to remove the vat on upload as well as add on download

Hi!

I have a question... if a product is fairly large and must ship in multiple boxes, how can I insert this information via Easy Pop?

Say one product ships in 3 boxes (must be assembled upon arrival) and the boxes weigh 30, 10, 40.

Here is what I would LOVE as a solution: under v_products_weight simply enter the weight of each box separated by a comma!

So for the example above v_products_weight = 30, 10, 40

The way I have been doing it is to simply put in the total weight (80) which is horribly inaccurate.

Any thoughts?

I know I can add fields to Easy Pop, but what fields would I need to add?

I am having an issue with my Easy Populate. I tried to upload some updates and on my Easy Populate module screen in my Zen Cart admin, I am receiving a message "Strange but there is no default language to work... That may not happen, just in case... ". I am also receiving an SQL Error. I looked in the log, and the SQL database that it is pointing to is not correct.

I uninstalled, removed all the files and reinstalled Easy Populate and that did not work. Is there a way to point it to the correct server?

Feznizzle No EP will not do what you are asking, I would have thought that you could arrange your shipping module to work on weights which would be more straight forward. so you have a particular weight for this product.

rscott91 Firstly which version of EP are you using as this makes a big difference (the only one to use is 1.2.5.4 langer original port)

Bug report, please fix.

Check this http://www.zen-cart.com/forum/showth...629#post908629

alvalong By the way double posting is frowned on ... :no: also you would need to state the version of mod's you are using, (note there are now several versions of EP 1.2.5.4,1.2.5.5 etc )

EP works well generally, but if you start using combinations of other mod's this can break any working mod.

I would suggest you give more detail in your original posting as this is not a bug in EP 1.2.5.4 it is a cause of using a combination. EP has nothing to do with Breadcrumbs, it just inserts data into the database, how 'ultimate seo url ' uses this data is what you need to be looking at...

Not sure if need to start new thread or just tag along here?, but am having trouble getting Easy populate to work on zc ver1.3.9d

Installed ez populateCSV ver1.2.5.7 (also tried v1.2.5.4) as far as I can tell, in the correct directories, as it does appear in Admin-Configure-Easy Populate, however, it does not show up under Admin-Tools. Any advice?

Also, whilst in Admin-Tools, following the Ez populate install instructions, attempted to upload the included SQL file (from my hard drive) with no luck, however I have now several more instances of Easy Populate under Admin-Configure. How do I remove the extras?

Jacksback2 I'm not sure if version 1.2.5.7 can do this but in v1.2.4.5 you can :

Quote:

---

To remove Easy Populate from your Zencart:
1. In your browser address bar in Easy Populate admin, type ?langer=remove after /easypopulate.php (eg. YOUR_ADMIN/easypopulate.php?langer=remove) to remove the Easy Populate configuration from your Zen Cart database
2. Delete each of the files that were uploaded to your web server

---

I would un-install and then reinstall all the files (step 1 should remove entries from the database, check you have the right files in the right folders, I haven't tried EP on 1.3.9d so I don't know any issues but I would have thought it should show in 'Admin-Tools' without issue.

Allright which version is the current one there's like 3 or 4 Easy Populates on the download area!
I use EP on an old cart and Im installing a new one and went to download and found several versions.???

http://www.zen-cart.com/index.php?ma...roducts_id=395

or

http://www.zen-cart.com/index.php?ma...oducts_id=1633

or

http://www.zen-cart.com/index.php?ma...oducts_id=1240

etc.

Quote:

---

Originally Posted by valnoren

Allright which version is the current one there's like 3 or 4 Easy Populates on the download area!
I use EP on an old cart and Im installing a new one and went to download and found several versions.???

http://www.zen-cart.com/index.php?ma...roducts_id=395

or

http://www.zen-cart.com/index.php?ma...oducts_id=1633

or

http://www.zen-cart.com/index.php?ma...oducts_id=1240

etc.

---

I assume it would be this one, since it's listed as supporting 1.3.9 and the others are listed as supporting 1.3.8

http://www.zen-cart.com/index.php?ma...oducts_id=1633

I just tested EP 1.2.5.4 on the following and no problems.

Version's
1.3.9
1.3.9a
1.3.9c
1.3.9d

Dear Zen Masters and Zen Padawans,

I was wondering if/how EasyPopulate could handle the data from Cross Sell... It would save a tremendous amount of time to so many of us if we could set the Cross Sell via Excel / EasyPopulate.

I figured how to add extra data in EasyPopulate, such as the Master Category ID...
I thought I had it for "xsell_id" and "sort_order", needed for the Cross Sell, but it ain't working...

I got about 0 php skills but here was my idea:

in admin/easypopulate.php i had:
Around line 384:

PHP Code:

---

// langer - specials added below
        
            $header_array = array(
            'v_specials_price'    => $iii++,
            'v_specials_date_avail'     => $iii++,
            'v_specials_expires_date'     => $iii++,
            'v_products_price'    => $iii++,
            'v_products_price_w'    => $iii++,
            'v_products_weight'   => $iii++,
            'v_xsell_id'   => $iii++,
            'v_sort_order'   => $iii++,
            'v_master_categories_id'   => $iii++,
            'v_date_avail'      => $iii++,
            'v_date_added'      => $iii++,
            'v_products_quantity'   => $iii++,
            ); 


---

Around line 467:

PHP Code:

---

$filelayout_sql = "SELECT
            p.products_id as v_products_id,
            p.products_model as v_products_model,
            p.products_image as v_products_image,
            p.products_price as v_products_price,
            p.products_price_w as v_products_price_w,
            p.products_weight as v_products_weight,
            xsell.xsell_id as v_xsell_id,
            xsell.sort_order as v_sort_order,
            p.master_categories_id as v_master_categories_id,
            p.products_date_available as v_date_avail,
            p.products_date_added as v_date_added,
            p.products_tax_class_id as v_tax_class_id,
            p.products_quantity as v_products_quantity,
            p.manufacturers_id as v_manufacturers_id,
            subc.categories_id as v_categories_id,
            p.products_status as v_status
            FROM
            ".TABLE_PRODUCTS." as p,
            ".TABLE_PRODUCTS_XSELL." as xsell,
            WHERE
            p.products_id = xsell.product_id
            ".TABLE_CATEGORIES." as subc,
            ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
            WHERE
            p.products_id = ptoc.products_id AND
            ptoc.categories_id = subc.categories_id
            "; 


---

Around line 1335:

PHP Code:

---

// langer - why not qry products table and use result array??
    $default_these = array(
        'v_products_image',
        // redundant image mods removed
        'v_categories_id',
        'v_products_price',
        'v_products_price_w',
        'v_products_quantity',
        'v_products_weight',
        'v_xsell_id',
        'v_sort_order',
        'v_master_categories_id',
        'v_date_added',
        'v_date_avail',
        'v_instock',
        'v_tax_class_title',
        'v_manufacturers_name',
        'v_manufacturers_id',
        'v_products_dim_type',
        'v_products_length',
        'v_products_width',
        'v_products_height'
    ); 


---

Around line 1488:

PHP Code:

---

// now do a query to get the record's current contents
        $sql = "SELECT
            p.products_id as v_products_id,
            p.products_model as v_products_model,
            p.products_image as v_products_image,
            p.products_price as v_products_price,
            p.products_price_w as v_products_price_w,
            p.products_weight as v_products_weight,
            xsell.xsell_id as v_xsell_id,
            xsell.sort_order as v_sort_order,
            p.master_categories_id as v_master_categories_id,
            p.products_date_added as v_date_added,
            p.products_date_available as v_date_avail,
            p.products_tax_class_id as v_tax_class_id,
            p.products_quantity as v_products_quantity,
            p.manufacturers_id as v_manufacturers_id,
            subc.categories_id as v_categories_id
            FROM
            ".TABLE_PRODUCTS." as p,
            ".TABLE_CATEGORIES." as subc,
            ".TABLE_PRODUCTS_XSELL." as xsell,
            WHERE
            p.products_id = xsell.product_id
            ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
            WHERE
            p.products_id = ptoc.products_id AND
            p.products_model = '" . zen_db_input($items[$filelayout['v_products_model']]) . "' AND
            ptoc.categories_id = subc.categories_id
            "; 


---

Around line 1984:

PHP Code:

---

$query .="'".zen_db_input($v_products_model)."',
                                    '".zen_db_input($v_products_price)."',
                                    '".zen_db_input($v_products_price_w)."',
                                    '".zen_db_input($v_db_status)."',
                                    CURRENT_TIMESTAMP,
                                    $v_date_added,
                                    $v_date_avail,
                                    '".zen_db_input($v_tax_class_id)."',
                                    '".zen_db_input($v_products_weight)."',
                                    '".zen_db_input($v_xsell_id)."',
                                    '".zen_db_input($v_sort_order)."',
                                    '".zen_db_input($v_master_categories_id)."',
                                    '".zen_db_input($v_products_quantity)."',
                                    '$v_manufacturer_id')
                                "; 


---

and finally around line 2029:

PHP Code:

---

$query .= '", products_weight="'.zen_db_input($v_products_weight) .
                        '", xsell_id="'.zen_db_input($v_xsell_id) .
                        '", sort_order="'.zen_db_input($v_sort_order) .
                        '", master_categories_id="'.zen_db_input($v_master_categories_id) .
                        '", products_tax_class_id="'.zen_db_input($v_tax_class_id) . 
                        '", products_date_available= ' . $v_date_avail .
                        ', products_date_added= ' . $v_date_added .
                        ', products_last_modified=CURRENT_TIMESTAMP' .
                        ', products_quantity="' . zen_db_input($v_products_quantity) .  
                        '" ,manufacturers_id=' . $v_manufacturer_id . 
                        ' , products_status=' . zen_db_input($v_db_status) . '
                        WHERE
                            (products_id = "'. $v_products_id . '")'; 


---

Obviously I'm off somewhere... (probably way off...)
Please php Gurus, don't laugh :blush:
Any help would be greatly appreciated.

Damien

Hello. Brand new to Zen cart and Easy Populate. I am running version 1.2.5.4 and Zen Cart v1.3.9b.

I had to pay to get EP installed but it I hope will be worth it. I have managed put together. I already had some products in my store and so I used a file pulled from the temp folder to add some new products to the store. I did so by clearing out all but 3 products and adding another 27. I saved it to my hardrive and inserted into the DB.
EP created the categories correctly but only downloaded 1 product.

Any reason for this? Thanks

Cecilsav

cecilsav Firstly EP works with unique Model numbers (v_products_model) THEY MUST BE DIFFERENT so check that first...

A good test for EP is insert some sample products in via ZC and download change some detail and upload to ZC. EP just works fine if you are using v1.2.5.4. Watch out for the end of line ref EOREOR and also the v_status column
1 = Add
9 = Delete

What result did you get at the bottom of the EP window when you imported as this will give the information to what EP is doing with your data ?

Have you checked your permissions to the /temp folder as if you are not able to write to that folder EP will not change the data in that file in the folder.

I have a few thousand products on my website which have no description but I need to add a description to each of them.

I have tried to upload an csv to EP with the headings v_products_model, v_products_description_1 but it didnt add the descriptions to the products on the site.

Any ideas? Or can it even be done this way?

Cheers

DB

dropbop What version are you using as it looks as you are using EPA by the column ref.

EP should do this easily, have you remembered to use the end of line EOREOR ?

Hello,

I'm curious as to whether or not anyone here has had success transferring products from MindBody to Zen Cart using Easy Populate. I've tried several times to import products from my MindBody store to my Zen Cart store to no avail, having followed all the instructions (literally nothing happens when I click "Insert into DB.")

I am wondering if I am doing something wrong or if it's just not possible to transfer this data, and it'd help to know how someone else exported their data from MindBody and imported it into Zen Cart.

Thanks for any help,

Kelly

KellyM You would need to give us more details to help you...

EP works well, but has some strange querks. You need a product in a category placed in ZC manually for EP to import correctly, if you try to import without any products EP does not work properly.

If you arrange your .txt file as in the wiki EP will work, but it does need that format.

I wonder why I cannot delete a subcategory?
c_categories_index_path=level1~level2
c_categories_status=9
EOREOR

says "
ERROR! - Action not implemented yet on row 2 - Deletion of categories is not implemented yet"

I tried adding category name, sort order, same results.

Please help.
thanks

Does Easy populate also export other fields like UPC , does it work with numinix additional fields?

hi, is it possible to add images with it? So far i have tried b ut unscuccessful so far .
also is it possible to add the order status to it?

Quote:

---

Originally Posted by shadowcast

hi, is it possible to add images with it? So far i have tried b ut unscuccessful so far .
also is it possible to add the order status to it?

---

if you are talking about adding category images, you can add a column "c_categories_image"

anybody can help with deleting categories?

its the product image

Quote:

---

Originally Posted by shadowcast

its the product image

---

the main product image is set with "v_products_image" (should be your 2nd column).

well it didn work, what im gonna try is to upload the images into the main directory first thought :).

Quote:

---

Originally Posted by shadowcast

well it didn work, what im gonna try is to upload the images into the main directory first thought :).

---

Hi,
Images cannot be loaded thru EP. You will need to FTP them into the "Images" folder.

anybody know how i can use EP to delete a category?

Quick question. Can more description columns be added to Easy Populate, such as v_products_description_2 and v_products_description_3? If so, how would I do that, just add and name the columns, or would I have to insert something into one of the php files?

This would be incredibly convenient as I have a few short paragraphs that I'm pasting to the end of my product descriptions, and to be able to put them in another column and fill down would be great!

Thanks!

How can I add product upc field in EP?

Quote:

---

Quick question. Can more description columns be added to Easy Populate, such as v_products_description_2 and v_products_description_3? If so, how would I do that, just add and name the columns, or would I have to insert something into one of the php files?

This would be incredibly convenient as I have a few short paragraphs that I'm pasting to the end of my product descriptions, and to be able to put them in another column and fill down would be great!

---

EP can use spreadsheets so you just need to google how to use a spreadsheet to do what you want to do. Will take seconds to complete the task using exist spreadsheet capabilities.

The more complicated and customized you make something the tougher to manage.

Quote:

---

How can I add product upc field in EP?

---

This one I am not so sure of but couldn't you just replace the model number generated by zencart with the UPC code and solve the problem?

I have not done that myself but I don't think that zencart determined number has any bearing on anything so swapping it for your UPC's should work.

Do a test run on a few skus and see what happens. The one issue there is your sales history on the altered model numbers would be lost and or have to be combined with the new UPC version.

Hi

I apologise if this question has already been answered, but I haven't yet been able to find what I'm looking for.

I have just recently duplicated a store and everything is working fine - except that Easy Populate doesn't seem to import category images and descriptions.

Is there any way I can get it to import these, as doing it manually would take ages.

Thanks,
Tija

Thanks Jimmy, I used numinix product fields and have UPC field, anyway to incorporate this into EP?

Is numenix an add on? Can you shoot a link on that thing as I am not familiar and this way I don't have to look it up.

I can view the packet and see what it is doing and see if EP can be practically altered for that use.

here you go http://www.zen-cart.com/index.php?ma...roducts_id=651

and

http://www.numinix.com/zen-cart-modu...48714ae61f99ad

can you see if that can be easily implemented

Thanks

Quote:

---

I have just recently duplicated a store and everything is working fine - except that Easy Populate doesn't seem to import category images and descriptions.

Is there any way I can get it to import these, as doing it manually would take ages.

---

To do this using EP you would need to add the relevant fields into an easy populate custom build. Which would take a while to build and would be custom such that you will have added hassle during all upgrades etc. BUT even if you did this you'd still need to manually install all your images unless you knoew the exact file names and even still you'd have to manually enter the file names anyway in the relevant line-items

Easier would likely be an image ftp and also a db copy of the relevant tables which would be pretty easy to do especially since the thing is an exact dup.

For that matter if it truly is a dup db then you could probably drop the entire table and then import the "other" working one into the "new" build.

Thats the direction I'd go first anyway as it would take only a couple minutes to accomplish. Here is how I'd do it...

1) take your current "new" db and copy it to a new new db for testing.

2) find the table in question and drop the relevant data

3) import the populated data from your "old" db

4) ftp the images into identical folder en masse

test to see if it worked. Pretty sure this logic would work if you monkey around with the method a bit to your exact needs

With a brief glance I'd say it can be implemented by adding fields to EZpop. I say this by only looking at the free zen download. Hopefully these two links are same file.

I will look at it more closely Monday if it takes me ten minutes or less I will do it then and add it to the ez pop I have in the downloads section so it can have ongoing support for you as things change with zen. If it's a PIA then that's a different story.