How to make the mod work for digital download product?
I think some modification would be required to set download location, file type etc
Thanks in advanced
Printable View
How to make the mod work for digital download product?
I think some modification would be required to set download location, file type etc
Thanks in advanced
Way beyond me. I suggest search the forum for object_array or post in the general questions area.PHP Code:reset($object_array);
while (list($key, $value) = each($object_array))
I have no experience with digital product, but I have found that if you have moderate programming skills, you could add any fields you need to EP. The core logic is there for updating most files associated with products.Quote:
Originally Posted by ebookba
The upload code doesn't begin until pretty far down in the program, but each section has some notes that proved helpfull along with reading the code logic.
Jeff
From my experience, if an item is anywhere on the site, it has to be somewhere in the Admin->Products/categories.Quote:
Originally Posted by jgg1974
Great module! Two questions though:
1. How to I import images hosted on a third party site? In my upload text file, I set the v_products_image to something like: http://www.othersite.com/image.jpg. However, when it imports it into my store, I believe it's saving that long string as the actual image name, so that in my store, it tries to load: http://www.MyStore.com/images/http:/....com/image.jpg
I use Image Handler 2, by the way. So I would like to know if EP can import the image from this other site and save it directory into my Images folder, stripping off the URL and only storing the image name in the database so that Image Handler can pick it up?
2. How can I modify the EP php file so that it won't import a product if the v_products_model value matches ANY PART of an existing record? For example, let's say that I have an existing record called "ITEM123 - A" and in my import file, I have a new item called "ITEM123". I do not want to import this new record. Where can I edit in the EP php file to see if any part of the string matches, to simply skip it and don't import it?
[QUOTE=Jeff G;616661]PHP Code:reset($object_array);
while (list($key, $value) = each($object_array))
Well Line 28 had // in front of if (!is_array($object_array)) return;
i deleted the // and i am not getting the errors - however, when i click to edit the product all of the feilds are BLANK, even though i see the products listed on the front page.. :eek:
everything goes back to normal when i change the product id back to 1.
not sure how to fix it, i'll keep looking. i'm thinking i might just use product id 1 as a workaround then run the sql patch to update things to music product.
Would anyone please let me know what the appropriate "v_products..." would be for "record company" and "music genre" so i can add these 2 fields to the EP file?
For the record, I was able to address this issue:
The way I did that was to do the following:Quote:
2. How can I modify the EP php file so that it won't import a product if the v_products_model value matches ANY PART of an existing record? For example, let's say that I have an existing record called "ITEM123 - A" and in my import file, I have a new item called "ITEM123". I do not want to import this new record. Where can I edit in the EP php file to see if any part of the string matches, to simply skip it and don't import it?
1. Line 1877 - CHANGE:
$result = ep_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_model = '" . zen_db_input($v_products_model) . "')");
TO THIS:
$result = ep_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_model LIKE '%" . zen_db_input($v_products_model) . "%')");
Then I commented out Line 1941 to Line 1978, which is the block of code that updates existing orders. The reason I have this need is because I am not planning to update anything, but rather, ADD new items only.
I still need some help with this one outstanding issue though:
Quote:
Originally Posted by Jeff_Mash
I have looked in the download section but cant find owt that says Easy Populate??Quote:
Originally Posted by Jeff G
ok think i found the right 1 but when i upload my products it comes up with this error::
Warning: move_uploaded_file(/home/truliebl/public_html/temp/export_attributes_20080920.xls) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/truliebl/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpnL3RVf' to '/home/truliebl/public_html/temp/export_attributes_20080920.xls' in /home/truliebl/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: file(/home/truliebl/public_html/temp/export_attributes_20080920.xls) [function.file]: failed to open stream: No such file or directory in /home/truliebl/public_html/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /home/truliebl/public_html/admin/easypopulate.php on line 1301
Help any1?:no:
credenscel,
From your post it sounds like you changed the default of products_id, not products_type. Products_id should not be in the EP file. It is either found by EP when updating, or assigned automatically for new product.
Give that a check.
Jeff
At top of this page click "free software add ons". Then search for "easy populate free from langer". DO NOT use the one from OSC.Quote:
Originally Posted by TrulieBliss
I just saw your new post after writing this. It sounds like you might have missed a step. You must create the "temp" folder at the root of your store (same level as admin/includes/images/etc.)
Jeff
I think you have the right solution for issue 2. One thing though, I don't know sql that well, but based on you solution I assume % is a wild card. If thats the case, wouldn't you just want it on the end?Quote:
Originally Posted by Jeff_Mash
For issue 1: ZC does not support images that are not local to the site, so this will not work. If you only want images on the product info page, and don't care about listing/featured/special/etc, you can add an <a href=...> to your product description.
Jeff
On the image link issue,
Several (at least you and one other :D) people have asked about doing this. If someone is pretty good at php, it would probably not be too difficult to write a program that reads a list of image URLs and copies them to your local drive or image folder.
Might be some legal issues there though.
Just a thought.
Jeff
Thanks for the comments. As for the image thing, this was addressed before right here: http://www.zen-cart.com/forum/showth...age#post514583
So what I have done is contacted the company from which I am importing their products, and they are going to send me a DVD with all their images on it. That way, I can simply upload them all to my images directory, and then run the EP program on there to insert all the items.
Thanks again for the help!
Or download Langer's release version 1.2.5.4 from his site atQuote:
Originally Posted by Jeff G
http://modhole.com/modhole/index.php...11034d58f7ea8d
Jeff,Quote:
Originally Posted by Jeff G
Below is the image showing what i am changing am i doing it wrong? please let me know
http://i33.photobucket.com/albums/d5...cel/type-1.jpg
I don't see any changes in the image. The second line reads "products_type" with a default of "1". Change the default to "2".
Also, I think I mentioned this before - there are several files for music that make using the music type meaningful. Unless you mod EP to update those files, I don't think you gain anything by changing to type music.
yes, i am setting it to ID 2. It doesnt work. :cry:
At this point i dont know how else i can tweak this. If anyone can help figure out a solution for EP to work for music products please let me know i'm willing to pay for your efforts.
In software work, language is very important.
You refer to "ID 2". Is that what you are doing? Or did you mean something else?
We never discussed ID. You should not be doing anything with ID.
sorry i mean i am switching 1 to 2. not product id. but the product type.
I used easy_populate free from langer modhole_v1-2-5-5.
All worked fine for me until when i uploaded the .txt data file to another cart.
All categories/products were impoted correcltly but when i switch to the french language none of them shows in the category tab.
But all of them shows in the all products,featured products link.
The category tab remains blank.
But all is working fine in English.
You can see through this link :http://lockdownsurveillance.com/
would you please let me know where you got the 1.2.5.5. version?Quote:
Originally Posted by dhanesh
Can someone guide me in the right direction on how to use easy populate on the attributes, Basically i have edited all the descriptions and changed the price but the attributes were not included, so I seperatly downloaded the attributes but it didnt really make any sense to me. Thanks
I've read in the many posts in this thread about language problems. I do not use any other than english, but the upload code for languages is around line 1660 in easypopulate.php. It appears to be somewhat documented in the code.Quote:
Originally Posted by dhanesh
Jeff
I'm working on a site with lots of option names and values. I could not get it to work without heavy mods to the code.Quote:
Originally Posted by ben harry
My workable (for me) solution is 2 files. File 1 is everthing except the options. File 2 is only options.
You need to stop the main loop from updating when doing file 2. I did "if v_desc is null" type of thing.
I also put each option name/value combination on a separate line. So if a product has 4 options with 4 values each, I have 16 lines for that product in file 2. Code mods needed for this need to remove assumption that each line is not the only.
Some issues I have are when updating options. Currently no way to delete existing before creating new.
It was not a trivial task for someone that does not know php. Mostly trial and error.
Hope this gets you in the right direction.
Jeff
Hi - I am having the same problem as credenscel, above.
I created a new product type, a chemical, based on the book mod. Which works. I used the free EP to test load 5 items. Which worked. BUT altho they appear in the store, in admin/editproduct, the data does not appear, and I get this error:
Warning: reset() [function.reset]: Passed variable is not an array or object in /home/capralog/public_html/storefront/admin/includes/classes/object_info.php on line 29
Warning: Variable passed to each() is not an array or object in /home/capralog/public_html/storefront/admin/includes/classes/object_info.php on line 30
I changed, manually with phpadmin, the product type to be '7' which is what it is. (Easy populate brought them in as '1'.) Is there anywhere else that product type needs to be changed so these products appear in the edit screen?
Hi All,
The latest version from the downloads section is v1.2.5.5 is this ok for version 1.3.8?
Cheers
Brett
When i upload the EP file from another cart i get this message:
Warning: file(/home/lockdown/public_html/temp/Full-EP2008Oct03-0808.txt) [function.file]: failed to open stream: No such file or directory in /home/lockdown/public_html/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /home/lockdown/public_html/admin/easypopulate.php on line 1301
Can anybody suggest why this happens?????
an almost-solution to my post, #1928, above.
The reason I was getting that error was because EasyPopulate does not add its products to the product-book-extra table.
(background: I made a new product type, not a book but based on the book product type info. Then I used EP to load the data. Products did show in the store, not in the back-end admin within the new product type page.) Reason was it was never loading in the collect_info.php program - because that file's SELECT statement failed because it was looking for data in product_book_extra - and lo - EP never wrote anything to there, of course, and nothing was there.
Because I'm not a php wizard, instead of modding EP to write even a product_id# to product_book_extra, I used phpadmin to load a csv file of the product-id's (generating that file by exporting it using phpadmin).
I hope this is somewhat clear and helps someone who is wondering why their custom product-type products aren't showing up in the admin edit product screen.
would you PLEASE let me know how exactly you load a csv file to make EP work with alternate product types? I dont know how to create/load a csv file and your help will be much appreciated!
I am using music product type and have been looking for a solution for some time now.
Did anyone figure out what DJMagicCards did wrong or needs to do to get this to work?Quote:
Originally Posted by DJMagicCards
I get the same error when I tried to do this??
Any help will be appreciated.
Mack32
Anything above line 1270 does not matter for the upload.
This looks right. The new column in your sheet should have heading 'v_products_quantity_order_max'PHP Code:line 1290
'v_products_price',
'v_products_quantity',
'v_products_quantity_order_max',
This looks OK.PHP Code:line 1444
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.products_quantity_order_max as v_products_quantity_order_max,
These 2 sections look right and should give a successful insert of a new item includeing the new columnPHP Code:line 1919
products_weight,
products_quantity,
products_quantity_order_max,
line 1933
'".zen_db_input($v_products_weight)."',
'".zen_db_input($v_products_quantity)."',
'".zen_db_input($v_products_quantity_order_max)."',
Here's your problem! I think this would not do a proper update. I believe the line should be...PHP Code:line 1970
', products_last_modified=CURRENT_TIMESTAMP' .
', products_quantity="' . zen_db_input($v_products_quantity) .
', products_quantity_order_max="' . $v_products_quantity_order_max .
The zen_db_input says it is a variable and was left out. The quote mark at the beginning is needed to close the quote from the above line.PHP Code:'", products_quantity_order_max="' . zen_db_input($v_products_quantity_order_max) .
Give it a shot!
Jeff
Thank you jeff
That did it. I uploaded a small file to see and it works.
Thank you soooo muuuuch! :clap:
Mack32
Glad to help when I can.
ok, I installed EP, exported list, updated weights, now, do I simply Upload EP File? Will it overwrite the current database? I just want to make sure it will not double our DB or have some other strange problems. Just need some re-assurance that this is as simple as it seems.
You need to make sure that the model numbers for the items you're updating match up with the ones already in your system.
Otherwise, EP will treat them as new items.
If something goes wrong, you can always download the new catalog tab-delimited file, and change v_status from 1 or 2, to 9, and that will delete whatever is in that row. Change v_status to 9 for all items you wish to get rid of.
-Tim
Tim,Quote:
Originally Posted by yelow
thanks for your quick reply!
the only thing we changed was the weights so they will work with shipworks.
also, we have 3000 products, so I don't want any issues... so do you think we are good to go?
Hi There
I have just downloaded the complete Full-tab delimited.txt file and it appears not to have extracted all the information from the database. The v_products_url_1 field is empty. Is this field meant to be empty or should it show the url for each of the products.
I do recall way back, when I first downloaded the mod that when I did an upload of only a few new products, the system didn't generate a product url. All other information was created as I could see the products in the admin but couldn't actually navigate to the products on the storefront, as there was no product url allocated for each of the new products.
Does anyone have any idea as to what may have went wrong or advise me as to how ep is suppose to work so that I have a better understanding.
TIA
Just be sure to go to tools/backup mysql database before loading every new EP file.Quote:
Originally Posted by keylesslocks
Do you mean that you want an external link to the manufacturer of each of your products??Quote:
Originally Posted by heavenlynights
A URL is not required for you to find a product within your own store. On your EP Full file do you have unique model numbers for each product?
products_url is a field in ZC that allows you to have a link to another page, like the manufacturers web site. It is not your local url.
So unless you added that field, blank is correct.
I was wondering if anyone had a fix for the bug with the no Manufacture, i tried setting it to --none-- and also 'none' but it just made new manufactures by those names, what i need easy populate to do is realise that there is nothing in the field and reset the field to "empty".
Thanks for responding elkbowQuote:
Originally Posted by elkbow
No not external url ie: manufacturer. So the txt file isn't meant to show product url?
All my products are general products and have their own unique model number.
I will try another upload of a couple of new products to see what happens
Thanks
I would back up your db before uploading the text file. If it does not look right, just restore that backup. If you use the status 9 to delete the products, you will also delete the images for those products.Quote:
Originally Posted by keylesslocks
Well I did another upload and the outcome is as below.Quote:
Originally Posted by heavenlynights
- I opened a recently downloaded complete tab delimited file into MO excel which automatically opened up the text import wizard. I changed the "file origin" to Unicode (UTF-8) (not sure what the file origin should be). Then I just clicked next, then next again then finish. I left the the "column data format" as general.
- I then keyed in 1 new product being very careful as to category names and so on
- I then deleted all other products from the file to leave only the new product that I was importing.
- I then saved the file as a new txt file.
- I went into easy populate and proceeded to upload the newly named file containing only one product.
- Upload results are as shown in below screenshot
http://www.heavenlynightslingerie.co...ges/screen.jpg
Product shows up in admin however, if I try to edit it by clicking on admin>categories> product edit symbol or clicking on the product name, it takes me to google.com.au (very weird) same thing applies, if I click on all other symbols except for attribute and image handler symbols.
In regard to the actual store front, I can see the product in the product listing http://www.heavenlynightslingerie.co...1&keyword=7786 but when you click on the product it takes you to the page not found where the sitemap is showing.
So! not sure what to make of all of this, especially the google thing :wacko:
One other thing, in the admin >tools>easy populate page there appears to be indicate that there are 5 partially deleted products somewhere in the database.. i click on the link to delete them, but it fails every single time.
http://www.heavenlynightslingerie.co...es/screen2.jpg
Could this have anything to do with my problems.
Any help would be much appreciated
TIA
ok, so I chose my new file, inserted into DB and then it says:
Upload Results
File uploaded.
Temporary filename: /tmp/phpokpXbQ
User filename: spread sheet update.xls
Size: 2006528
Upload Complete
But when I check the products, none of the new wieghts that are in the new EP file are included for the products, is there another step I need to take?
I was reading the wiki and realized, it should be a .txt, so I uploaded a txt and updated all our products it was looking great the results, but all my weights remain the same, this is the only thing I need the new info to really update, but it isn't?
ok, some things are updated and some are not, I am really confused....
in the upload results it says:
UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Whirlpool | Whirlpool | | | | | 14.95 | 0.25 | | 2/19/2008 | 999 | Whirlpool | Washing Ma | Whirlpool | Whirlpool | | | | | Taxable Go | 1 |
UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Roper Wash | Roper Wash | | | | | 14.95 | 0.25 | | 2/19/2008 | 1000 | Roper | Washing Ma | Roper Wash | Roper Wash | | | | | Taxable Go | 1 |
UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | KitchenAid | KitchenAid | | | | | 14.95 | 0.25 | | 2/19/2008 | 1000 | KitchenAid | Washing Ma | Kitchen Ai | KitchenAid | | | | | Taxable Go | 1 |
UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Kenmore Wa | Kenmore Wa | | | | | 14.95 | 0.25 | | 2/19/2008 | 999 | Kenmore | Washing Ma | Kenmore Wa | Kenmore Wa | | | | | Taxable Go | 1 |
but when I check the 3364290 on the site, only 1, the kenmore, is coming up with the weight .25 the other 2 are coming up 1 pound... but the updated results says they all should be .25
something wierd is goin on.... if products have linked items, they right and but the others are not, see pichttp://midwestapplianceparts.com/images/weights123.jpg
here is another example... also, another VERY funny thing is I NEVER link products, so why does it show all of these products with links, something is definitely not right,....
http://midwestapplianceparts.com/images/weights1234.jpg
ok, EP definitely made a linked product for each product, this item is only just 1, now it has 1 and a linked product:
http://midwestapplianceparts.com/ima...ights12345.jpg
diving deeper I thought it was duplicating everything, but now I see only some and don't know why, see thishttp://midwestapplianceparts.com/ima...ghts123456.jpg
The first thing I see is the Unique Model Number is the same for all of the items shown above. try changing the 3364290 toQuote:
Originally Posted by keylesslocks
3364290A, 3364290B, 3364290C. Since you have different named sub categories and the same model number is the linked problem.
I was reading these posts because I am trying to figure out Easy Populate as well, but when I went to your site http://lockdownsurveillance.com/ I saw something else I would like to know how to do. When you rollover your mouse on an image it brings up a larger image. How is it done?
Newbie here.
Image Handler 2 available in Free Software Addons.Quote:
When you rollover your mouse on an image it brings up a larger image. How is it done?
hmmm....Quote:
Originally Posted by elkbow
2 questions:
1. a lot of my UMN are maxed out the characters from ZC admin when I added them, if I go over the amount limited will it be ok?
2. I have 3000 items... how can I find all the ones that are duplicated? shouldn't it be replacing by some kind of unique number other than the model number?
Sorry for bumping, but I really need some help with this problem!!
ThanksQuote:
Originally Posted by heavenlynights
can I just increase the max characters for this field:
Products Model
so then when I import the EP file again,. I don't have to worry about the field being too big
Hi
well I have a problem OO Calc won't let me import the file I have completely, it will cut off some columns. Even tried uniCSVed and CSVed, no luck either.
I got to add 100 products but all have different attributes, e.g. a bra that has different sizes.
My client does not want to go through editing tons of lines over and over again. What would be the fastest way to add attributes to a product relatively quickly?
Does EP advanced have a GUI? That would be a feature.. you just select the attributes that are already stored into zencart and you can mass-add it to any product. That system would be fool-proof ;)
Thanks for your help and suggestions :)
Hmm I just realized that I can copy attributes via zencart :oops:Quote:
Originally Posted by warefare
But if I just want to add 3 attributes and the others should be "default" attributes what would I have to do ?
Anyone got an example file how I would add three simply attributes to a product?
I know that I can just export the EP attributes file but there are way too many attributes in there and I just want to add three.
Maybe I am wrong but if I want to add three attributes shouldn't that just be 6 columns ? The ID and the name ..
once everything is in there where do I go from there? everything is uploaded , imported and all and that's it - there's no interface to connect anything.
If the upload shows no errors, your should see all your products in admin and the live site.Quote:
where do I go from there
Hello all, quick question, can anyone tell me where when I Split EP Files, where does that save to ??? I thought it would save to my Temp file , but its not there?? :blink:
Thanks 4 any help...
I also had a few EP questions. I have it installed and working and was wondering if there was a way that anyone new that would allow me to upload the UPC. I already downloaded the module that allows me to add UPC/ISBN individually. This would be a great help to me in listing DVD's.
Would adding in v_products_UPC in my upload work? Or is this something that I would need to pay for teh advanced version to make work?
Thanks in advance!
Guess SUndays are kinda qiet in here.. :lamo:Quote:
Originally Posted by jgg1974
I have not used the split feature much, but if you have not changed the code, the files should be in your temp folder. I believe it might change the file name.Quote:
Originally Posted by jgg1974
Make sure you are looking at the right temp folder. It should be at the same top level as admin & includes.
From what I've read, the advanced version does not have extra fields (but I could easily be wrong here).Quote:
Originally Posted by jlosee
You started right with adding the column (probably best to use all lower case though). You need to find the INSERT and UPDATE sections starting around line 1650 and add the new field definitions.
Jeff is correct-- Image of Temp Directory in the root folder of your store.Quote:
Originally Posted by Jeff G
http://archeryshop.com/temp_dir.gif
I uploaded by txt file. It shows it as it went thru fine - it does show up in my temp file. However, it does not show up in the catalog. What step am i missing?
Uploads to Easy Populate should not be in txt format..Quote:
Originally Posted by ella33
need to be converted first to tab delimited .csv by i.e
Open Office program.
OK, after much frustration and very close examination of the products table in phpMyadmin, I found where my problem was and that was that the EP complete download was missing a field "v_products_ type" and was therefore defaulting to 0, where type should have been 1. As soon as I edited the table by replacing the 0 to 1 in the products_type within phpMyadmin, I was able to access product page on my storefront and I was also able to access all product features ie: edit, copy, move etc within the store admin without being re-directed to google.comQuote:
Originally Posted by heavenlynights
My questions are now.
has anyone else had this problem, or is it just an isolated incidence with my downloaded file and if so what would have caused the omission.
and
if the "v_products_type" field is not meant to be included as part of the downloaded file, where would be the best place to add this field in the csv file for uploading so that I don't have this problem again.
Thanks
Hi again. ok I am just trying to work out how to fix above quoted problem.Quote:
Originally Posted by heavenlynights
I have looked at the ep_debug_log to establish what went wrong and below are the 5 files/products that i cannot delete.
I have looked in the phpmyadmin and cannot find any reference to these products within the products table. Where else in phpmyadmin, should I look?Quote:
Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
326:f4f3fa30b5e879c74e5fd6ae0609f81e
612:5ef342d2d56e0dbf6183a95d959ee3d4
353:745fb41191f898509f15959a3df40815
611:fd62356a05335753c6aa2951e4351e86
640:3ea24ff30ee1b11931289aa335e2ff83
It is recommended that you delete this corrupted data using phpMyAdmin.
TIA for any help on this
I had the same quirk and had to access the db to remove the snips of data. My incident was due to deleting my test user without emptying his cart beforehand. It might also happen if a product is deleted in admin after being selected by a user, so I would check anything and everything that has to do with a users shopping cart. Good luck!Quote:
Originally Posted by heavenlynights
I am uploading my inventory right now to Easy Populate, but it does not show the attributes at all. Do I have to upload those in a different text file? Is there anyone to upload everything at once? Also, with images what do you use to upload all of your inventory images at once?
I installed Easy Populate and can't get it to work.
It installed perfectly. I went to Tools-->Easy Populate and chose 'Create complete Tab-Delimited text file in temp dir'
I opened the file in Open Office and only Two Categories and Sub Categories show up out of 5 categories/sub-categories I manually put in in Zencart.
I also tested trying to add a new category/sub-category/product...but NOTHING shows up in my Zencart site.
Thanks for that. Done a quick search in database and found all problem files. deleted them. problem solved :clap:Quote:
Originally Posted by awhfy99
Greetings all,
Has anyone with a large store (e.g., 20,000 products) had success with Easy Populate? If so, would you mind posting or PMing me your host. My host upgraded MySQL, and I am being told that I have to use SSH (instead of Easy Populate) to update the database. I have been trying to get it figured out for months...to no avail:shocking:. So, I am hoping to find advice on an alternative host which can handle Easy Populate for large stores.
Thanks in advance...and don't forget to vote!
Maxim
Are you uploading the file to import to the temp directory and importing from there? If so I'd think you'd be OK.
I have nearly 50,000 stamps on mine and have little to no problems except that the confirmations do not show. I use a US firm of TCH (Total Choice Hosting), if I am allowed to say that here.Quote:
Originally Posted by maxim
We have a couple of large stores (10,000 + products) and I generally run Easypopulate updates in "tranches" - by manually splitting the tab-delimited files to more manageable numbers.
In our big store (15,650 products) I generally split the main spreadsheet into three section (roughly 5,000 products each), then run each of these through EP.
It takes a bit longer - but it generally avoids errors.
... and I ALWAYS do the EP from the temp folder in the site itself - never via a remote upload.
ok, I have adjusted our spreadsheet now and added A, B, C to products with the same model number...Quote:
Originally Posted by elkbow
so now, can I upload the spreadsheet? what will happen? will it make this spreadsheet our new DB? what I don't want to happen is it leaves the old ones and adds these on top...
Me too! Did you ever find a way to make easy populate create the categories or sort products to the appropriate category without specifying "v_master_categories_id" I've labeled the appropriate category names in "ptc_categories_index_path".Quote:
Originally Posted by ebaobao
Hi All,
Langer said to make specials_price "0" to delete the special from the product. I have done just that and it says 15 products successfully updated but the prices remain the same. The products still have specials on them. Where am I going wrong here?
Thanks,
John
Hello. I apologize if this has been covered already, but I have been scouring the forums for two days and couldn't find it. I am setting up a clothing retail store on Zen 1.3.8a. I have quite a few products from different companies. Each company names their colors differently, so I have ended up with 169 colors to add into my attributes. I added them into the option value controller, but when I try to download the file from EP (v. 1.2.5.4), the file is too long (too many columns) to open with Open Office or Excel. Is there a way of splitting the file so I don't have to enter these colors into each product individually? Any help is GREATLY appreciated!
Quote:
Originally Posted by awhfy99
I just want to say a big "THANKS" to all who responded to my issue. I will try out the various suggestions.
Much love, maxim
Ok after waiting so long for an answer re: adding field to csv and not getting one LOL, i decided to try it anyway and I can confirm that adding the "v_products_type" field to the file and setting it to 1 does NOT work.Quote:
Originally Posted by heavenlynights
Anyone got any suggestions, because if I can't figure this out it would be pointless using EP if i have to physically go into phpmyadmin to change the settings of each new product that i upload via EP to product type "1"
TIA
It looks like you somehow modified the structure of the products table. The default setup is for products_type to have a default value of 1.Quote:
and was therefore defaulting to 0, where type should have been 1
As it appears that EP only supports standard products (type 1), it does not need products_type column and the update just uses the default ("1").
Jeff
thanks Jeff but Gee how would I have done that without knowing and where would i have done that, store admin or through phpmyadmin? (although i don't normally fiddle with the database in phpmyadmin only now because I have had to, with EP.Quote:
Originally Posted by Jeff G
Any idea on how to set the default back to 1?
Thanks
ok here is a snippet from phpmyadmin for product types
Edit Delete 1 Product - General product 1 Y 2006-01-30 22:01:54 2006-01-30 22:01:54
Edit Delete 2 Product - Music product_music 1 N 2006-01-30 22:01:54 2006-01-31 19:32:34
Edit Delete 3 Document - General document_general 3 N 2006-01-30 22:01:54 2006-02-27 12:14:34
Edit Delete 4 Document - Product document_product 3 N 2006-01-30 22:01:54 2006-01-31 19:34:12
Edit Delete 5 Product - Free Shipping product_free_shipping 1 Y 2006-01-30 22:01:54 2006-01-30 22:01:54
does everything look ok or not?
In phpMyadmin,
1. find table products
2. click box next to products_type
3. click pencil (edit)
4. "default" should be "1", if not, change it and "save"
I just saw the second part of your post. It has nothing to do with that table. It's only the "products" table.
I'll be around for another hour or so. Let me know how you make out.
Thanks Jeff. Turned out default was set to 0. have now edited this bit to default to 1. Hopefully this will make a differnce.
Thanks so much for your help :thumbsup: :cheers:
Always glad to help when I can.
I'm trying to use the EP to adjust stock by attribute. I did a test on a few products and I screwed up something. Now all of my variants display this symble " : " instead of the name (i.e. instead of showing small, medium, large - each one showed : . The quantity was correct though)
Is there a quick and dirty guide to the stock by attribute template for EP? I did a thorough search of not only this forum, but google as well.
Hi again
Need a little more help. I have 3 new columns in the products table that I need extracted into the Full EP file when I run EP.
These are:
products_height
products_length
products_width
Can anyone tell me what code I would need to add and to what file I would need to add it too. My guess I would need to add it to file easypopulate.php?
TIA
i've configured my zencart site to use iso-8859-2 encoding. my database zc1 is set to collate to utf-8.
when i add products via Admin -> Catalog -> ... new product, i use my language characters (čćžšđ) and they display ok on site.
i downloaded EasyPopulate's complete tab-delimited .txt file, edited it in notepad++ and saved using utf-8 encoding. then i go to EP, Upload EP File, select the file and hit insert into db. Everything ends ok, but when go to se the products on my site, the text is this "mi� cc��d" instead of this "miš čćžšđ".
What am I doing wrong?
When i click on:
Download Complete tab-delimited .txt file the file does not show v_categories_name_1 etc.. can someone help please
If its a new install, try adding a category and a product before downloading that file.Quote:
Originally Posted by loti29
If your store has products and they are priced by attributes, then good luck getting the download to look right. One I tried that way was really unusable.
If its a new install and it still looks funky after adding that catagory and product, I would reread the install instructions and try again.
Thank you.. i reinstalled and followed all the instructions and it worked great.
how can i make updates to my product list with EP?
basicly, i want to add my products first and later their description.
first, i want to insert a product list with product_id/model, name, price and category. then i want to insert a new file with almost same product_id/model but only description and weight. when i say almost same, i mean that first file has 40 models and second only 30 of those 40.
when i do it like this for 4 products, my category sidebox says 8 and shows only 4 (from the first file). also, the descriptions (second file) are not shown anywhere. also, EP says NEW PRODUCT when i upload my update.
what am i doing wrong? how can i do this?
this is my first file (+ is for empty tab):
1100 + prod_1 + + + + + 100 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
2200 + prod_2 + + + + + 200 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
4400 + prod_4 + + + + + 400 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
5500 + prod_5 + + + + + 500 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
this is my second file:
1100 + + desc_prod_1 + + + + 100 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
2200 + + desc_prod_2 + + + + 200 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
3300 + + desc_prod_3 + + + + 300 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
5500 + + desc_prod_5 + + + + 500 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR