EasyPopulate 4.0 Support Thread

[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?

[mc12345678]

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($result2) : 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.

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($result2) : mysql_fetch_array($result2));

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

[mc12345678]

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...

[Jenovee]

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.

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...

[Jenovee]

Also, just so we are clear on how I am doing this. I am doing my edits the same way someone would add new products. At the bottom (end) of the spreadsheet, I add the product information as if it were a new product. From my understanding, it should just overwrite whatever information has been changed. It seems to work fine, since it edits the quantity and doesn't create a doubled product. BUT it deletes the product name.

Now .... when I specifically go to a current item .... if I merely change the qty and import, everything is fine. Qty gets updated and everything is in tact. The filename only gets wiped when the method is like I'm adding a new product.

[Thannaree]

Does this plugin allow exporting products images as well?

[mc12345678]

Also, just so we are clear on how I am doing this. I am doing my edits the same way someone would add new products. At the bottom (end) of the spreadsheet, I add the product information as if it were a new product. From my understanding, it should just overwrite whatever information has been changed. It seems to work fine, since it edits the quantity and doesn't create a doubled product. BUT it deletes the product name.

Now .... when I specifically go to a current item .... if I merely change the qty and import, everything is fine. Qty gets updated and everything is in tact. The filename only gets wiped when the method is like I'm adding a new product.

This is a process different than tested... Seems that if the model# is known, it could be just as easily searched for as compared to retyped, unless I am missing something... Will still look at the process to see why "adding" the product anew in the list has a different affect than modifying the item in the list. Would almost suggest in this scenario that all other line records be removed from the list other than the one instance of the model#(s) being revised.

For further clarification when stating:

The filename only gets wiped when the method is like I'm adding a new product.

the term filename refers to the product name correct? And that is the only data that the code removes or unexpectedly modifies in this scenario?