Re: Using EP4 to update existing products
Quote:
Originally Posted by
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...
Re: Using EP4 to update existing products
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.
Quote:
Originally Posted by
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...
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
Does this plugin allow exporting products images as well?
Re: Using EP4 to update existing products
Quote:
Originally Posted by
Thannaree
Does this plugin allow exporting products images as well?
This plugin is a database related plugin and will export the path to the base image (please read the applicable FAQ for additional images). It does not export the actual image itself. It is generally considered that ftp be used to export the file that is the image (or "right" clicking the image and saving it when it is displayed onscreen).
Re: Using EP4 to update existing products
Quote:
Originally Posted by
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.
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:
Quote:
Originally Posted by
Jenovee
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?
Re: Using EP4 to update existing products
Quote:
Originally Posted by
mc12345678
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.
Yes, it would be error-free doing it by search and edit method. The reason I am doing it this way is because I am trying to sync my quantities with those of a dropshipper. I would have to manually search for every product to edit, which would take hours. But this way, I can simply import all the data within a few minutes. Even products I don't carry can be imported without sorting, since EP will simply ignore it with: "SKIPPED! - Model: CGG3333333333 - No category provided for this new product"
Since there is no dropshipper module that I can find, this is the easiest and fastest method I currently see.
Quote:
Originally Posted by
mc12345678
For further clarification when stating:
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?
Yes, I'm sorry. I was typing faster than I was thinking. I meant to say the product name; and only the product name.
Re: Using EP4 to update existing products
Quote:
Originally Posted by
Jenovee
Yes, it would be error-free doing it by search and edit method. The reason I am doing it this way is because I am trying to sync my quantities with those of a dropshipper. I would have to manually search for every product to edit, which would take hours. But this way, I can simply import all the data within a few minutes. Even products I don't carry can be imported without sorting, since EP will simply ignore it with: "SKIPPED! - Model: CGG3333333333 - No category provided for this new product"
Since there is no dropshipper module that I can find, this is the easiest and fastest method I currently see.
Yes, I'm sorry. I was typing faster than I was thinking. I meant to say the product name; and only the product name.
No problem, just double checking...
So back to my earlier suggestion, how do things work if the file is "blank" of products listed and just the dropshipper's data populates it? (Headings still in place and assuming that the dropshipper's data has the model listed once only. If listed more than once, could setup a quick calc column to show a duplicate and then delete the desired duplicate before saving for uploading.)
Re: Using EP4 to update existing products
Quote:
Originally Posted by
mc12345678
No problem, just double checking...
So back to my earlier suggestion, how do things work if the file is "blank" of products listed and just the dropshipper's data populates it? (Headings still in place and assuming that the dropshipper's data has the model listed once only. If listed more than once, could setup a quick calc column to show a duplicate and then delete the desired duplicate before saving for uploading.)
Ahhhhhh, I was able to try it just now. I did everything exactly the same, but then I deleted ALL my products. I imported just 1 line of data. Everything seems good! The item name is fine, and all other data seems intact.
I will keep testing it, but this method seems to work. Thank you MC. :smile:
Re: Using EP4 to update existing products
Quote:
Originally Posted by
mc12345678
This plugin is a database related plugin and will export the path to the base image (please read the applicable FAQ for
additional images). It does not export the actual image itself. It is generally considered that ftp be used to export the file that is the image (or "right" clicking the image and saving it when it is displayed onscreen).
Thank you