Easy Populate 1.2.5.4 support

Yes! I found the error.

My Bad.

I suspect I typoed in the column headings (ie v_products_model etc) but never could find it. In the end I copied the headings that were exported by EP and pasted them into my data.

The resulting file worked perfectly.:smile:

Darrel

i POSTED THIS FOR HELP ON THE 29TH MARCH BUT NO HELP YET, MAYBE IT WAS MISSED .

Hi friends,

I need help on 2 issues which would make things easier for me. 1. Download and upload the database using a semicolon";" instead of a comma "," separating the columns. in Spain we use the comma to separate the decimals in the prices, eg. (€11,50) so when I open the database it gives me the price in 2 separate columns, and also the description field commas create problems.
2. I use wholesale and retail prices and have the dual price module installed, when I downloaded the database with the langer module there was a column for the wholesale prices v_price_w , but this new version does not include it, how can I add this field to may downloads.Thanks for your help.

I need help on 2 issues which would make things easier for me. 1. >

2. Download and upload the database using a semicolon";" instead of a comma "," separating the columns. in Spain we use the comma to separate the decimals in the prices, eg. (€11,50) so when I open the database it gives me the price in 2 separate columns, and also the description field commas create problems.

3. I use wholesale and retail prices and have the dual price module installed, when I downloaded the database with the langer module there was a column for the wholesale prices v_price_w , but this new version does not include it, how can I add this field to may downloads.

Thanks for your help.

Roshlin,

1. It sounds like you have the new CSV version loaded and not the TAB delimited version of Langer's 1.2.5.4. If you use the original version, you will need to work with your files using OpenOffice's software. This will edit and export the file correctly for upload. This is no different than having commas in product descriptions.

2. I am not familiar with this mode, but if the value is stored in the products database, you can modify the 1.2.5.4 version to export and import it.

I thought it was the same thread and it would be easy to add the field.
Thanks for your help, chadderuski, I'll see if there is another post for the new mod.

I'm get this error when I try to debug my easy populate

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

I went into the file and this is what I following stated:

Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
522:9d463c36b9022977ea2d7102bcd1018d
518:e62ac0b3cc2b3e3e0795a91090ab86eb
79:21d3bb393a1c2b670780c5eddb7f2ac1
501:10da19d05a601a4bc1cfe0c4f7bf40d2
536:dbcf6c5cafc54e71b0ef542095bb455f
It is recommended that you delete this corrupted data using phpMyAdmin.

So I logged into my cpanel and went into my phpmyadmin...but I don't know where to go to delete the information....can someone guide me on where I would find this information to delete in my phpMYadmin to loose the error message at the top?

divaboutiques:

I'm get this error when I try to debug my easy populate

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

I went into the file and this is what I following stated:

Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
522:9d463c36b9022977ea2d7102bcd1018d
518:e62ac0b3cc2b3e3e0795a91090ab86eb
79:21d3bb393a1c2b670780c5eddb7f2ac1
501:10da19d05a601a4bc1cfe0c4f7bf40d2
536:dbcf6c5cafc54e71b0ef542095bb455f
It is recommended that you delete this corrupted data using phpMyAdmin.

So I logged into my cpanel and went into my phpmyadmin...but I don't know where to go to delete the information....can someone guide me on where I would find this information to delete in my phpMYadmin to loose the error message at the top?

I have found that this can be caused if a product is deleted and was in a shopping cart or visa-versa, the user is deleted and he had items in his cart.

So a good place to start is in zen_customers_basket (or zen_customers_basket_attributes), hopefully you might see it there.

If not, try to remember what was deleted shortly before you saw the error pop up. If it was a category, try zen_product_to_categories, etc. It's kinda like playing Sherlock Holmes in the db!

chadderuski:

Roshlin,

1. It sounds like you have the new CSV version loaded and not the TAB delimited version of Langer's 1.2.5.4. If you use the original version, you will need to work with your files using OpenOffice's software. This will edit and export the file correctly for upload. This is no different than having commas in product descriptions.

2. I am not familiar with this mode, but if the value is stored in the products database, you can modify the 1.2.5.4 version to export and import it.

2. I use wholesale and retail prices and have the dual price module installed, when I downloaded the database with the langer module there was a column for the wholesale prices v_price_w , but this new version does not include it, how can I add this field to may downloads.

I also use wholesale and retail prices. I have only been able to load one and then have to go in to each product for discounted price. How did you get it to work to load two different prices for one product? Where and what did you add?

Thanks, Kim

Hi Kim,

I am unfamiliar with the Dual Pricing Mod. If this mod directly changes the products database, then you can easily change Easy Populate the handle this added field. I am unfortunately (or should that be fortunately?!) involved in a large print project and 2 full eCommerce projects, so I don't have time to do this for you :(

But, this is what you need to do. If the Mod had an SQL patch, take a look at it. Did it update the products database? If so, what fields did it add? Open up easypopulate.php, and search on v_products_price. At each line reference (doing a search), add your new field, say "v_products_price_w"

Also note that the new CSV version is not quite the same as the TAB delimited version.

Wish I had time to help more, but just too busy... But this is not hard to do. Just make sure you BACKUP your databases first!

-cj

Hi,
Ive been "playing" with my zen cart and mythsngifts.com since about October, and although i have had a couple of orders, I just cannot get it right :(

My latest problem is that ep 1.2.5.4 works great for uploading and downloading products, but everytime I try to download or upload an attributes file, the screen goes blank. I have tried to d/u to my temp folder but nothing appears, I have removed and reinstalled ep but still get exactly the same problem. Is this likely to be an admin issue or could I have done something in mysql thats causing the prob :oops:

My next resort is to completely start from scratch, but it will mean my site is down yet again and I should really be promoting it by now.

Any help would be soooooooo much appreciated thankyou!

Hi.
Appologies if this is a newby question or that there is an obvious answer but I have been at this for over 20 hours now and I cant see the wood for the trees.

I have a clean install of the latest zencart with the template ZJ Black 2 and the latest Easy Populator.

My problem is I am trying to input 1268 products but Easy Populator says all are done but when you go to the shop only a few are.

So I restricted to doing just 12 just incase it could not handle the number, but it still only installs some and not others here is what I am trying to install.

v_products_modelv_products_imagev_products_name_1v_products_description_1v_products_url_1v_specials_pricev_specials_date_availv_specials_expires_datev_products_pricev_products_weightv_date_availv_date_addedv_products_quantityv_manufacturers_namev_categories_name_1v_categories_name_2v_categories_name_3v_categories_name_4v_categories_name_5v_categories_name_6v_categories_name_7v_tax_class_titlev_statusv_metatags_products_name_statusv_metatags_title_statusv_metatags_model_statusv_metatags_price_statusv_metatags_title_tagline_statusv_metatags_title_1v_metatags_keywords_1v_metatags_description_1kx125 test2kx125 testtest desk5400000-00-00 00:00:0015/04/2009 13:411KawasakiKX125Taxable Goods100000KX125KX125 2001 Rear Sprocket 49T Talon KX 125 2122KX125 2001 Rear Sprocket 49T Talon KX 125 21222200000-00-00 00:00:0015/04/2009 13:411KawasakiKX125Taxable Goods100000KX125KX125 2002 Rear Brake Caliper Carrier KX 125 161KX125 2002 Rear Brake Caliper Carrier KX 125 16114500000-00-00 00:00:0015/04/2009 13:411KawasakiKX125Taxable Goods100000YZF125YZF125 2004 Main Frame YZF 125 133YZF125 2004 Main Frame YZF 125 1332000000-00-00 00:00:0015/04/2009 13:411YamahaYZF125Taxable Goods100000KX500KX500 1987 Chain Adjusters KX 500 120KX500 1987 Chain Adjusters KX 500 1207500000-00-00 00:00:0015/04/2009 13:411KawasakiKX500Taxable Goods100000RM250RM250 2001 Right Side Radiator RM 250 1972RM250 2001 Right Side Radiator RM 250 19721300000-00-00 00:00:0015/04/2009 13:411SuxukiRM250Taxable Goods100000CR250CR250 2002 Gear Lever CR 250 1000CR250 2002 Gear Lever CR 250 10002500000-00-00 00:00:0015/04/2009 13:411HondaCR250Taxable Goods100000KTM125KTM125 2004 Rear Brake Lever KTM 125 6124KTM125 2004 Rear Brake Lever KTM 125 61242500000-00-00 00:00:0015/04/2009 13:411KTMKTM125Taxable Goods100000KTM125KTM125 2004 Front Wheel Axle KTM 125 6131KTM125 2004 Front Wheel Axle KTM 125 61314000000-00-00 00:00:0015/04/2009 13:411KTMKTM125Taxable Goods100000KTM125KTM125 2004 Silencer KTM 125 6117KTM125 2004 Silencer KTM 125 61171500000-00-00 00:00:0015/04/2009 13:411KTMKTM125Taxable Goods100000KTM125KTM125 2004 Fuel Tap KTM 125 6110KTM125 2004 Fuel Tap KTM 125 61107500000-00-00 00:00:0015/04/2009 13:411KTMKTM125Taxable Goods100000

Fairly simple I thought
This is what gets added.

v_products_modelv_products_imagev_products_name_1v_products_description_1v_products_url_1v_specials_pricev_specials_date_availv_specials_expires_datev_products_pricev_products_weightv_date_availv_date_addedv_products_quantityv_manufacturers_namev_categories_name_1v_categories_name_2v_tax_class_titlev_statusv_metatags_products_name_statusv_metatags_title_statusv_metatags_model_statusv_metatags_price_statusv_metatags_title_tagline_statusv_metatags_title_1v_metatags_keywords_1v_metatags_description_1KX125 no_picture.gifKX125 2002 Rear Brake Caliper Carrier KX 125 161KX125 2002 Rear Brake Caliper Carrier KX 125 161145030/11/1999 00:0001/01/1970 01:001KawasakiKX125Taxable Goods100000kx125 test2no_picture.gifkx125 testtest desk54030/11/1999 00:0001/01/1970 01:001KawasakiKX125Taxable Goods100000YZF125no_picture.gifYZF125 2004 Main Frame YZF 125 133YZF125 2004 Main Frame YZF 125 13320030/11/1999 00:0001/01/1970 01:001YamahaYZF125Taxable Goods100000KX500no_picture.gifKX500 1987 Chain Adjusters KX 500 120KX500 1987 Chain Adjusters KX 500 12075030/11/1999 00:0001/01/1970 01:001KawasakiKX500Taxable Goods100000RM250no_picture.gifRM250 2001 Right Side Radiator RM 250 1972RM250 2001 Right Side Radiator RM 250 197213030/11/1999 00:0001/01/1970 01:001SuxukiRM250Taxable Goods100000CR250no_picture.gifCR250 2002 Gear Lever CR 250 1000CR250 2002 Gear Lever CR 250 100025030/11/1999 00:0001/01/1970 01:001HondaCR250Taxable Goods100000KTM125no_picture.gifKTM125 2004 Fuel Tap KTM 125 6110KTM125 2004 Fuel Tap KTM 125 611075030/11/1999 00:0001/01/1970 01:001KTMKTM125Taxable Goods100000

If I have left anything out that you need to know please say as I'm not looking forward to inputting all products individually.

Thanks in advance for any help or pointers.

Hi - my site is clonecopies.com
I installed the ezpopulate and tested same. worked for uploading 2 items. tried 10 great result. Tried 100, 50 went great the other 50 will just not upload, I get the following message: SKIPPED! - Model: 11034NA - No category provided for this new product
I first used Excel with tabs, then I set up open office, downloaded a master list again, set up the 50 rejected items, set up tab file in Open Office - uploaded, nothing. Re-entered the category not by cut and paste but by typing, tried again - nothing.
And yet these are the same categories as the ones that worked.
Any suggestions would really be appreciated.
Rufus

i am trying to use easy populate to split my rather large inventory list and import it. I followed the instructions from the INSTALL file and read the read me, but when i go to browse and choose my tab deliminated .txt file, it goes through the long process of what i assume is uploading/splitting the file, but at the end i have nothing added to my product list and no option to import the split up files.

what i do have is a message underneath the create your own / upload your file that says "

Upload split files in turn

All done!

Upload Results

Upload Complete
"

but i have no options to do anything further and nothing is added to my store inventory. I hope someone can help me.

Hi - regarding my post earlier today re categories not showing up. Thanx to some-one whose name I cannot remember but in the forum suggested if the EZ file does not load up - look at it in Notepad++. Bingo; my vendor uses tabs in the description file which threw out the columns.
But one thing leads to another: 4 items loaded up, one crashed and at the top of the EZ Pop screen got this message:
Warning: explode() [function.explode]: Empty delimiter in /...../......./......../admin/includes/functions/extra_functions/easypopulate_functions.php on line 241
Can any-one tell me what this means
thanx

This may be a stupid question, but what is the layout for an Excel Spreadsheet in order to perform this? Is it exactly as the product window is?

What fields do I need to have in order for this to work properly? =/

Thank you!
~Indi

Not sure what kind of spreadsheet app your are using (if any) as I do not see any kind of formatting on what you have. I can't see any EOREOR at the end of any line, either. Also, it must saved is a tab-delimited text file.

You need to verify that in every v_model field, the data is unique. If any are repeated, the product will be overwritten with the info from the other one(s).

excel97 works for me but some do not care for it.

I suggest that you download a full text tab-delimited file from your install. Open it with the spreadsheet. Copy/Paste the EOREOR into every line in that column that you will need to upload.

Input your data into the correct fields and then sort (excel has a w/header row as a sort option. Verify that no v_model entry has been duplicated. Then save it to a tab-delimited text file and upload it. Until you are familar with how it all works, do not delete any unused columns.

If all of this is correct and it still fails, go back to the first entry on this topic and read the instructions.

BTW, I upload files with over 3000+ lines without any glitches, so the amount of products is NOT your problem.

My site is currently down on purpose. I'm purchasing a special template for it and I don't intend to work on the layout until the template is purchased. So, I'm trying to upload all of my products in the meantime.

You will not see any information up there at this time.

What I am asking is this:
My Excel Spreadsheet should look like?

Products ID# | Product Name | Product Type | Weight | IMG SRC

What fields do I need to have so that this works properly and in what order?

Sincerely,
Indi

I'd be willing to email someone the spreadsheet I currently have. It is not completed yet, but I want to make sure I have all of the fields of information necessary for it to upload properly.

So far my fields are:
Model No: | Series | Genre | Character | Color | Wholesale Price | Retail Price

Do I need to have the fields listed on the products form such as:
Date Available | Description | Quantity | Taxable Goods | etc.

Thank you for your time. =)
~Indi

uruharacosplay:

I'd be willing to email someone the spreadsheet I currently have. It is not completed yet, but I want to make sure I have all of the fields of information necessary for it to upload properly.

So far my fields are:
Model No: | Series | Genre | Character | Color | Wholesale Price | Retail Price

Do I need to have the fields listed on the products form such as:
Date Available | Description | Quantity | Taxable Goods | etc.

Thank you for your time. =)
~Indi

Mine looks like this if you are using the Langler version and not the cvs one.

Attributes don't do very well using ep.

If you downloaded a complete tab-delimited text file from your site, the fields will look like the ones in the above image. Some can be left out but it's not a good idea if you are a newbie.

Cookie Monster:

i am trying to use easy populate to split my rather large inventory list and import it. I followed the instructions from the INSTALL file and read the read me, but when i go to browse and choose my tab deliminated .txt file, it goes through the long process of what i assume is uploading/splitting the file, but at the end i have nothing added to my product list and no option to import the split up files.

what i do have is a message underneath the create your own / upload your file that says "

Upload split files in turn

All done!

Upload Results

Upload Complete
"

but i have no options to do anything further and nothing is added to my store inventory. I hope someone can help me.

Send me a PM with your email address, I will contact you and then you can attach the first 4 lines of your file to your reply.

Just like to say thanks for your help guys I'm sure I making newby mistakes.

I'm going to leave it till after the weekend and see if going at ti with a fresh mind and the information you have supplied makes a differance.

It'll probably be realy obvious when I find what I'm doing wrong.:shocking:

Any way thanks for not getting the A:censored: with my stupid questions.
:bigups: