EasyPopulate 4.0 Support Thread

I've installed Easy Populate CSV on a Zencart v1.5.3 system without success.
I have copied all the files. I go to Admin -> Tools -> EasyPopulate.
It prompts to install by pressing click here (as expected) once I click it I get:-
WARNING: An Error occurred, please refresh the page and try again.

This is a freshly installed version of Zencart, no additional mods at present.

syncunlimited:

I've installed Easy Populate CSV on a Zencart v1.5.3 system without success.
I have copied all the files. I go to Admin -> Tools -> EasyPopulate.
It prompts to install by pressing click here (as expected) once I click it I get:-
WARNING: An Error occurred, please refresh the page and try again.

This is a freshly installed version of Zencart, no additional mods at present.

Please goto the logs directory of the site, and without providing your admin directory path, please provide the error log(s) generated when attempting to perform this install... Also please identify the php version as identified in the admin panel when accessing the link version at the top right of the screen.

On second thought and reread of the post, easypopulate csv was installed, that is covered by a different forum thread. This thread is for EasyPopulate v4. The software can be downloaded by the link provided in post 1 of this thread.

Hi Everyone,

I hope this hasn't been asked before (but hope there is a solution)

as many people I have Dual Pricing operating and its working great with Easy Populate 4 for product imports and exports.
my issue is with Product Options.
Dual Pricing adds a field (pretty sure its called v_options_values_price_w) for wholesale pricing on the options of a product.
however when I export the Detailed Products Attributes the wholesale pricing column is not there.

can anyone guide my through on how to import & export the products attributes / options with wholesale pricing using easy populate 4?

PS using zen cart 1.5.4, dual pricing 2.1.5 & Easy Populate 4.0.28 - Beta 01-03-2015

Thanks,

mydanilo:

Great, was enough of a pointer, just edited language table with phpMyAdmin SET languages_id = '1'. Now it all works together better. Thank you.
Turns out just setting SET languages_id = '1' did not work out on one store. No more products are showing, they just disappeared. Any idea what other tables are affected by setting another language? I'm happy to open another thread but EP is the only mod showing me the _2 language id where it matters. Not sure how to ask somebody that does not use EP when talking field names exported by EP only ;)

OK, I've created anther thread on this here: http://www.zen-cart.com/showthread.php?216579-Default-Language-2-English-revise-to-1-English&p=1276401#post1276401

HugoStiglitz:

Hi Everyone,

I hope this hasn't been asked before (but hope there is a solution)

as many people I have Dual Pricing operating and its working great with Easy Populate 4 for product imports and exports.
my issue is with Product Options.
Dual Pricing adds a field (pretty sure its called v_options_values_price_w) for wholesale pricing on the options of a product.
however when I export the Detailed Products Attributes the wholesale pricing column is not there.

can anyone guide my through on how to import & export the products attributes / options with wholesale pricing using easy populate 4?

PS using zen cart 1.5.4, dual pricing 2.1.5 & Easy Populate 4.0.28 - Beta 01-03-2015

Thanks,

I don't recall seeing it asked, and looking through the code, I do not yet see that functionality included...

If you could help out a little in one way or another, that functionality could find its way into the code... The "easiest" on my side would be for you to identify to what table(s) and what specific field(s) are added to those tables (as viewed possibly through phpmyadmin) to support the Dual Pricing plugin.

Otherwise, to ensure accuracy, please provide the link to the download location of the software being used to provide the Dual Pricing options...

It appears that the information would be captured in one of the tables to apply to each specific value option of an option name... (Don't recall the correct specific table at the moment.) Thus allowing each option value to have a modified/unique price applied to it.

The expectation then if that is the case is that the code/field would be incorporated into the detailed attribute export/import... That way each attribute could have its unique piece of information applied to it... This would affect the admin/includes/functions/extra_functions/easypopulate_4_functions.php (specifically ep_4_set_filelayout function), possibly the admin/easypopulate_4_export.php and possibly the admin/easypopulate_4_import.php files.

If that is not sufficient information to get one started, then definitely the additional information requested above would get things kicked off...

mc12345678:

If you could help out a little in one way or another, that functionality could find its way into the code... The "easiest" on my side would be for you to identify to what table(s) and what specific field(s) are added to those tables (as viewed possibly through phpmyadmin) to support the Dual Pricing plugin.

It's in the options_values_price_w column of the table products_attributes

jeking:

It's in the options_values_price_w column of the table products_attributes

Hi MC & Jeking,

thanks for the replies, jeking has it right "options_values_price_w" is defiantly the missing column. thanks for finding the table its from.

also further to this

I have just noticed that when doing an attribute export, changing the price (v_options_values_price) and importing again
it does not change the price of the options, even tho it says it completes and shows the new price in IMPORT RESULTS of EP4

Regards

HugoStiglitz:

also further to this

I have just noticed that when doing an attribute export, changing the price (v_options_values_price) and importing again
it does not change the price of the options, even tho it says it completes and shows the new price in IMPORT RESULTS of EP4

Regards

Are you sure that you font have two entries for the same model # and that the first one was changed, but the second was not and therefore overwrote the original?

yeah pretty sure
I also noticed it does not seem to work adding new items into the CSV, the don't show up in options name or value manager, or in the attribute controller

a pic of my import file is attached

Attachment #15068

What is the filename?

Better way to ask is how is the filename different from when it was downloaded?

the export file is Attrib-Detailed-EP2015Mar18-100702.csv
I then modified this file and resaved it as WebsiteImportOptions.csv, uploaded and imported

HugoStiglitz:

the export file is Attrib-Detailed-EP2015Mar18-100702.csv
I then modified this file and resaved it as WebsiteImportOptions.csv, uploaded and imported

Therein lies the. Rub...

There are prefixes to some filenames that must remain intact when renaming the file for EP4 to know how to properly process the file. This is one of those filetypes. Rename the file so that it begins with at least: Attrib-Detailed-EP and try again...

Although the provided instructions do not go in great detail, this is one of those things that is discussed.

MC thanks a lot,
that's fixed it. sorry about that.

any news on the v_options_values_price_w issue?

Hello, I have a question regarding updating quantities.

If I have 10,000 products in my catalog, it would be painstaking to search for every single item and update the quantity one-by-one. I exported a Model/Price/Quantity and tried to update the easiest way possible. I entered, at the bottom, the model and new quantity for an existing item. When I imported it, the quantity updated in my catalog, but the item name got deleted.

Why would the item name get deleted?? That isn't even one of the editable fields when doing Model/Price/Qty. I can understand if I left the required field blank, but the field isn't even there.

Is there a simple way to update mass product quantities? Shouldn't new data overwrite old, and same data remain untouched?

Jenovee:

Hello, I have a question regarding updating quantities.

If I have 10,000 products in my catalog, it would be painstaking to search for every single item and update the quantity one-by-one. I exported a Model/Price/Quantity and tried to update the easiest way possible. I entered, at the bottom, the model and new quantity for an existing item. When I imported it, the quantity updated in my catalog, but the item name got deleted.

Why would the item name get deleted?? That isn't even one of the editable fields when doing Model/Price/Qty. I can understand if I left the required field blank, but the field isn't even there.

Is there a simple way to update mass product quantities? Shouldn't new data overwrite old, and same data remain untouched?

Looks like you found an error... Hmm.. Now to call the correction a new version or just fix it... Been working on a few changes/additions... How about this, I provide the correction location and soon should have an update (especially since trying to get the v_options_values_price_w field addressed in addition to some of the other things...

line 589 of admin/easypopulate_4_import.php of version 4.0.28 currently reads:

 $row2 = ($ep_uses_mysqli ? mysqli_fetch_array($result) : mysql_fetch_array($result2)); 

and should read:

$row2 = ($ep_uses_mysqli ? mysqli_fetch_array($result[B]2[/B]) : mysql_fetch_array($result2)); 

That will resolve your issue, and may resolve some of the issues identified recently by others...

Hello. Thanks for the reply, mc. I changed the code as you stated (just the number "2") and tried it again. No, it's still doing the exact same thing. It imports everything fine, but still deletes the product name.

I logged out and back in also, just in case it needed to "refresh" in some way. But same thing over and over. :(

mc12345678:

Looks like you found an error... Hmm.. Now to call the correction a new version or just fix it... Been working on a few changes/additions... How about this, I provide the correction location and soon should have an update (especially since trying to get the v_options_values_price_w field addressed in addition to some of the other things...

line 589 of admin/easypopulate_4_import.php of version 4.0.28 currently reads:

$row2 = ($ep_uses_mysqli ? mysqli_fetch_array($result) : mysql_fetch_array($result2));

> 
> and should read:
> 
> ```
$row2 = ($ep_uses_mysqli ? mysqli_fetch_array($result[B]2[/B]) : mysql_fetch_array($result2)); 

That will resolve your issue, and may resolve some of the issues identified recently by others...

Jenovee:

Hello. Thanks for the reply, mc. I changed the code as you stated (just the number "2") and tried it again. No, it's still doing the exact same thing. It imports everything fine, but still deletes the product name.

I logged out and back in also, just in case it needed to "refresh" in some way. But same thing over and over. :(

So, what was the filename of your modified file with just quantity modified? What version is being used currently? What fields are in the file? What if any custom fields are used?

I took a "risk" and after downloading the file that was created from the section that says import/export for model/price/qty. I modified the file to change just the number of quantity for a product. I intended to delete all but the one row, but I uploaded all of the rows and had no loss of the product name. I did see the change of quantity that I uploaded, but didn't experience the issue described by following the above process...

For this, I'm following the same method as when I export the complete products and add new products. I export the file, edit, then upload the same exact file. The filename never gets changed. The latest filename is -- "PriceQty-EP2015Mar30-043833.csv". I've exported it multiple times during this problem, and the filename is always named the same way.

The version of EP is 4.0.28 - Beta 01-03-2015. The ZC version is v1.5.4.

No custom fields on this. Just the standard -- v_products_model v_status v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_quantity

I'm wondering if something is wrong with my installation then. I'll keep testing different ways to see if I can figure this out.

mc12345678:

So, what was the filename of your modified file with just quantity modified? What version is being used currently? What fields are in the file? What if any custom fields are used?

I took a "risk" and after downloading the file that was created from the section that says import/export for model/price/qty. I modified the file to change just the number of quantity for a product. I intended to delete all but the one row, but I uploaded all of the rows and had no loss of the product name. I did see the change of quantity that I uploaded, but didn't experience the issue described by following the above process...