-
Re: Easy Populate support for Version 1.2.5.4
samgdaniel:
There seems to be a bug in EP when adding products to an empty store. I have not been able to completely nail this bug as to the cause myself, but to fix it do this:
After running your update go to: Tools > Store Manager
Now run:
Update ALL Products Price Sorter
and
Reset ALL Products Master Categories ID
This should fix your problem. If you are to look at the databases from within phpMyAdmin you should see the products there, just not showing up in your store.
-cj
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Scrat
samgdaniel:
What messages do you get when you import ? (ie Updated,New Product etc)
Are your products set to active?
As far as I can tell (I have only tested 1.2.5.5 myself) and it seems to work OK
Scrat, no error messages I even have the EP debugging set to True. My product is active.
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
chadderuski
samgdaniel:
There seems to be a bug in EP when adding products to an empty store. I have not been able to completely nail this bug as to the cause myself, but to fix it do this:
After running your update go to: Tools > Store Manager
Now run:
Update ALL Products Price Sorter
and
Reset ALL Products Master Categories ID
This should fix your problem. If you are to look at the databases from within phpMyAdmin you should see the products there, just not showing up in your store.
-cj
Chadderuski
I ran the Update All Products Price Sorter and Reset All Products Master Categories ID.
I ran the importer and it says it upload complete. But when I look at the product table through PHPAdmin and also through Zen Cart, I only see my original product that I've entered manually.
-
Re: Easy Populate support for Version 1.2.5.4
I am using 1.3.8
I just updated my easy populate support and now it has multiple listing (repeated) on the configuration tab. Any ideas as to what I did? How do I get the multiple (repeat) listings off?
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
samgdaniel
Chadderuski
I ran the Update All Products Price Sorter and Reset All Products Master Categories ID.
I ran the importer and it says it upload complete. But when I look at the product table through PHPAdmin and also through Zen Cart, I only see my original product that I've entered manually.
Sam,
What is your default language id? I think I remember seeing an issue if you use something other than english as your default language...
Ah! Wait. You are using the CSV version or the 1.2.5.4 TAB version? You will need to find the CSV support thread. My comments are for the 1.2.5.4 TAB version. Nor can I speak on the workability of 1.2.5.5 ... seems some people have problems with that.
-
Re: Easy Populate support for Version 1.2.5.4
I am having problem to load my items using easy populate. Currently I am using
easy populate 1.2.4
zen cart 1.3.8
My php configuration is:
max_execution_time = 45 ;
max_input_time = 60 ;
memory_limit = 96M ;
Server timeout = 10 seconds.
I constantly get HTTP Error 502 - Bad gateway error, even just load one item. I don't have problem to download from database.
It used to work before, but suddenly it's not working. I'm not sure if any server configure changed which affects on this.
Appreiate any help on this.
-
Re: Easy Populate support for Version 1.2.5.4
Anybody can help?
Thanks.
-
Re: Easy Populate support for Version 1.2.5.4
Having some problems adding new products via Easy Populate 1.2.5.4. and zc 1.3.8a
Everything works fine when i update my current products already in the DB.
Problem is when i try and add a new product.
Here are my steps on how i was doing it.
1: Download Complete tab-delimited .txt file to edit (Attributes Not Included)
2. open with Open Office
3. in the correct fields i add my v_products_model, v_products_image, v_products_name_1, v_manufacturers_name, v_categories_name_1, v_categories_name_2, v_categories_name_3, v_tax_class_title, v_status, EOREOR
4. save and upload back to easy populate.
Easy Populate gives me this error:
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer
my log file says this
Code:
MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)
VALUES (
'products/KLA161_1.jpg','KLA161',
'',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'1',
'',
'',
'',
'0',
'140',
'65')
any suggestions on what is wrong?
-
Re: Easy Populate support for Version 1.2.5.4
Do you have any completely empty columns in your tab-delimited text file ? (That is, a column WITHOUT a header and WITHOUT any further content).
If you "remove" unwanted content (on occasions where it need not be updated by EP) then it's no good to just delete the data in your spreadsheet. The entire column must go... no "blank" columns.
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
fairestcape
Do you have any completely empty columns in your tab-delimited text file ? (That is, a column WITHOUT a header and WITHOUT any further content).
If you "remove" unwanted content (on occasions where it need not be updated by EP) then it's no good to just delete the data in your spreadsheet. The entire column must go... no "blank" columns.
there arnt any that are completely empty. i use the one i DL from EZ Populate and just add a product# and catagory. everything else that was originally in the file uploads fine, just the new item
-
Re: Easy Populate support for Version 1.2.5.4
i tried doing this as well:
deleted all colums and only put an item number and a test catagory along with eoreor
i got 2 errors
Warning: explode() [function.explode]: Empty delimiter in /home/XXXXXX/public_html/XXXXX/includes/functions/extra_functions/easypopulate_functions.php on line 241
and
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer
in easypopulate_functions.php line 241 reads:
Code:
$date_bits = explode($separator, $excel_date[1]);
on the bottom of the page where it shows the updates it reads:
ADD NEW PRODUCT FAILED! - Model: abdef - SQL error. Check Easy Populate error log in uploads directory
No model field in record. This line was not imported |
and the error log reads this
Code:
MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)
VALUES (
'no_picture.gif','abdef',
'',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'',
'',
'',
'',
'0',
'171',
'NULL')
-
Re: Easy Populate support for Version 1.2.5.4
Are you sure you are using EP 1.2.5.4 ?
See my WIKI article:
http://www.zen-cart.com/wiki/index.php/Easy_Populate
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
schoolboy
hmm interesting. my admin page shows 1.2.5.4, but the file i downloaded and installed says 1.2.5.5
-
Re: Easy Populate support for Version 1.2.5.4
-
Re: Easy Populate support for Version 1.2.5.4
it has something to do with the values
Code:
MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)
VALUES (
'products/KLA160_1.jpg',
'KLA160',
'5',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'1',
'',
'',
'0.1',
'20',
'140',
'67')
12 colums and 14 vlaues
everything it finds is between '. so i am assuming where it says CURRENT_TIMESTAMP, is where the error it is coming from.
what do i do from here?
-
Re: Easy Populate support for Version 1.2.5.4
ok just found out that the 2 values with nothing in them are the msrp and cost fields.
how do i make it so that it does look for them when adding new products?
sure wish i could delete my older posts so people dont get confused. dont know why i can even edit them after a few minutes
-
EasyPopulate: No model field in record. This line was not imported
Langer,
When I try insert EP file in "Easypopulate",
It says:
No model field in record. This line was not importedMeradian2. | One Treatm | It is not | | | | | 60 | 0 | | 4/27/2009 | 2 | | Treatment | | | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
What I do wrong?:frusty:
Thanks a lot
-
Re: Easy Populate support for Version 1.2.5.4
fixed it.
needed to add msrp and cost around line 1921 in admin/easypopulate.php
all works now
-
Re: Easy Populate support for Version 1.2.5.4
I'm having problems when I load attributes. I exported the current attributes changed them and re-uploaded them. All works great except when a attribute has a negative value (That attribute should subtract from the price) When I put in a negative value it adds another negative sign in the attributes controller and so it because positive. I can't figure out how to get around that. Has anyone else had this issue?
-
Re: Easy Populate support for Version 1.2.5.4
Hi!
I have a query in regards to EasyPopulate and the updating of stock!
I have about 200 items, about 100 of which have attributes - I have gone through and added stock to each of the size attributes for the items that have attributes.
I now just need to add stock to those items that do not have attributes - just the product and stock.
If I use EP and add stock quantity to only the products that have no attributes will the items that have attributes retain the stock I have already added.
eg:
Currently:
Item 1 (Size 1) - I have qty 2
Item 1 (Size 2) - I have qty 2
(Added these manually as they have stock attributes Size 1 and 2)
If I use EP and change stock levels for say Item 2 which has no attributes, will Item 1 retain the stock I have already entered, or do I have to remove those items from the EP upload altogether.
-
Re: Easy Populate support for Version 1.2.5.4
esugrue & Outloudvinyl:
Attributes do not work correctly in EP. Sorry. This has yet to be updates/fixed.
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
chadderuski
esugrue & Outloudvinyl:
Attributes do not work correctly in EP. Sorry. This has yet to be updates/fixed.
In the meantime you can use the Bulk Attribute Creator in the downloads section.
Worked for me, but I cannot get it to hide option values.
In other words, when I select an option name I would like it to display only values related to it.
This it does not do.
-
Re: Easy Populate support for Version 1.2.5.4
-
Can't get dates to import correctly
I successfully imported nearly 20,000 items into my database, and then updated about 3,000 of them to reflect sale pricing. Yay!
The problem I'm having though is I can't get any dates to import. Every product ends up being dated 12-31-1969.
I've repeated the whole process many times. Date formats have been:
2009-05-29 08:49:14
"2009-05-29 08:49:14"
2009-05-29 00:00:00
"2009-05-29 00:00:00"
2009-05-29
05-29-2009
"05-29-2009"
No luck on any of these. Easypopulate is configured to use m-d-y and 09:00:00 as the defaults.
Any ideas what I'm doing wrong?
-
Re: Can't get dates to import correctly
Quote:
Originally Posted by
steve_cooper
I successfully imported nearly 20,000 items into my database, and then updated about 3,000 of them to reflect sale pricing. Yay!
The problem I'm having though is I can't get any dates to import. Every product ends up being dated 12-31-1969.
I've repeated the whole process many times. Date formats have been:
2009-05-29 08:49:14
"2009-05-29 08:49:14"
2009-05-29 00:00:00
"2009-05-29 00:00:00"
2009-05-29
05-29-2009
"05-29-2009"
No luck on any of these. Easypopulate is configured to use m-d-y and 09:00:00 as the defaults.
Any ideas what I'm doing wrong?
Ah, my guess is that you have listed year/month/date/time - not month/day/year and time. (reversed)
Mine looks like this:
27-05-2009 4:32:17 PM
-
Re: Can't get dates to import correctly
Quote:
Originally Posted by
elkbow
Ah, my guess is that you have listed year/month/date/time - not month/day/year and time. (reversed)
Mine looks like this:
27-05-2009 4:32:17 PM
Try 05/29/2009
It works for me.
-
Re: Can't get dates to import correctly
Please help, im new user of EP attempting to import products to zen cart, getting error when uploading to database with EP =
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
The only documentation I can find on this is that all v_products_model need to be unique , but this is already the case..
also getting error when attempting to import larger files = Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 20379 bytes) in ...\admin\easypopulate.php on line 1314
-
Re: Can't get dates to import correctly
I found resolution for "No Model Field in record." I think the tab delimited file i was using corrupted or somethjing..
I followed the directions from some guy named Andy Paton on another forum:
Open Excel.
Go to import external data>import data- browse for your folder the EP downloaded>open>.
Then (Step 1)use the "delimited option">(Step 2)Make sure "TAB" is the only one selected(Step 3) Make sure "Column Data Format" needs to be set to "Text".
Then press finish and select "OK" on the following box that comes up. your data will now be in the spreadseet.
Use your spreadsheeet to populate your products. Make sure you set Qty to at least 1 as this will make it active. Enable the product as "active".
(Make sure that you save it as a CSV. then open it and select a save as a "Tab Delimeted" file which you can then upload. No need to upload the CSV file.Hope this helps
--
except i didn't save as CSV from excel , just saved as tab delimited. --
I'm still stuck on uploading larger files getting to import larger files = Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 20379 bytes) in ...\admin\easypopulate.php on line 1314
-
Re: Easy Populate support for Version 1.2.5.4
I have downloaded the csv file for attributes in my test site.
It is huge and chaotic, and mostly useless.
I know I suggested the Bulk Attribute Creator, but this doesn't help much because although it can create all the attributes for a product at once, by holding down the Ctrl key and selecting, it does not associate anything with the attribute.
E.g. I have products with an average of 50 color attributes, some of these attributes are shared with many products, however I have to associate the image with the attribute every time.
It would be nice if the color attribute were inserted with the associated image, and other properties, in just one operation.
A binding would have to be created for the attribute and its properties.
This would speed up creation a lot.
Anybody know how to do this?
-
Re: Easy Populate support for Version 1.2.5.4
Hi All
How can I sort my products via the tab delimited file?
-
Re: Easy Populate support
I use EZ Populate and love it!!
A couple of questions please -
1. I know that I had seen a sql patch to set minimum quanities but now can't find it. I want to set the minimum order at .5 without manually changing everthing. Can someone help with this?
2. Also want to change Quanity Units so that people can order .25, .5, .75 etc with a minimum order of .5 - is this possible thru EP?
TIA
Mona
-
Re: Easy Populate support for Version 1.2.5.4
Im running easy populate 1.2.5.4 with ZC 138a
Every time I run my .txt products feed I get a error 500
No matter how small I make the file it gives me this error.
I thought it was my server so I switched to oscommerce just to test it out, oscommerce with easy populate loads up fast and fine so what can be wrong with my EP in zencart?
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Wizzard308
Im running easy populate 1.2.5.4 with ZC 138a
Every time I run my .txt products feed I get a error 500
No matter how small I make the file it gives me this error.
I thought it was my server so I switched to oscommerce just to test it out, oscommerce with easy populate loads up fast and fine so what can be wrong with my EP in zencart?
What are the permissions on your TEMP folder?
-
Quote:
Originally Posted by
Wizzard308
Im running easy populate 1.2.5.4 with ZC 138a
Every time I run my .txt products feed I get a error 500
No matter how small I make the file it gives me this error.
I thought it was my server so I switched to oscommerce just to test it out, oscommerce with easy populate loads up fast and fine so what can be wrong with my EP in zencart?
Interesting i didnt think ep1.2.5.4 for zencart would work with os ? Question : Are you using Langer's original version from modhole or a updated version downloaded for zencarts download section , as these seem to be buggy.
Posted via Mobile Device
-
Re: Easy Populate support for Version 1.2.5.4
Im running easy populate 1.2.5.4 CSV with ZC 138a
I am looking for help on getting an upload to work with easy populate....
I have the correct permissions on my "tempEP" folder and can read and write to that location without any problems.
I can download files without any problem.
I then
- copied two of the products I manually added through ZenCart (the entire row)
- then changed the "model" and "name" on the two new rows
This way I knew for format and field would match exactly as they were 'downloaded' via easy poplulate.
I uploaded via the browse button and inserted to DB and the new records were not in my data base.
I 'FTP'ed the files to the tempEP folder and imported from my tempEP folder and inserted in DB, still the new products were not there.
I tried saving from excel as tab delimited files and doing the same processes. Still no luck.
I tried downloading TXT files and converting to excel and resaving as tab delimited files. still no luck.
all of my attempts show in easy populate under the 'upload' section. I clicked import on each to try and see if that was necessary, still no luck.
I also wen to 'tools / store manager /' and tried the reseting as discribed in this thread. still no luck.
I am probably missing something very simple...
If any one can help, I would appreciate it. Thanks
-
Re: Easy Populate support for Version 1.2.5.4
I am getting followin error, when I go in to edit byte size I do not find anything on that line that would enable me to do that:
Creat Froogle:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 189
Creat cvs file:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 24 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 393
-
Re: Easy Populate support for Version 1.2.5.4
I have a problem and I cant determine if it is a easy populate problem or a zen-cart issue. When trying to load data feeds no matter how small the size I get a error 500
Now just to be sure it wasnt a server issue I used oscommerce with easy populate. The feeds load fast and with no trouble.
Does anyone have any suggestions as to what could be wrong?
Latest verions of Zen-cart and easy populate 1.2.5.4
-
Easy Populate Fatal error: Allowed memory size for V 1255csv2
I'm also getting the following error when trying to download or create the model/attributes file:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /easypopulate.php on line 1074
Has anyone encountered this error and found a solution.
Any help would be appreciated.
Zen Cart 1.3.8
Easy Populate V 1255csv2
Admin Profiles
-
Re: Easy Populate Fatal error: Allowed memory size for V 1255csv2
I was getting the Fatal error: Allowed memory size of 33554432 bytes exhausted error when I was saving the files incorrectly in EP 1.2.5.4 *Standard..
it's very important when using Excel and opening the tab delimented file to open as follows: Delimited -Next > Tab (checked) Next > Text (checked) - Finish . If you leave General checked rather than Text I dont think you are modifying the file as Text Delimited..
Now if you use 1.2.5.5.csv.2 you won't have to worry about as it supports CSV files ... http://www.zen-cart.com/index.php?ma...oducts_id=1240
NOTE : 1.2.5.5.csv.2 also supports updating Meta Files -!!
Before using 1.2.5.5.csv.2 , i upgraded to EP advanced which was the worst mistake ever.. advanced version is too complicated and too many errors ,, What a headache that program is !!
Wizard308, The 500 error referred to above is referring to the sql server timeing out trying to execute the code ..
Try going to version 1.2.5.5.csv.2 as suggested above..
This is how phazei promotes it in the zc addon page: "The biggest thing done was convert his file method from some wierd proprietary file he used, so use native php csv support. This eliminated a lot of junk code."
-
Re: Easy Populate support for Version 1.2.5.4
Thanks for the input. Ill give this a shot and see how it goes.
RuhRoh: Now I got this error showing.
Warning: array_flip() [function.array-flip]: The argument should be an array in /homepages/18/d201970486/htdocs/zencart/admin/easypopulate.php on line 1222
-
Re: Easy Populate support for Version 1.2.5.4
Ok while getting this error
Warning: array_flip() [function.array-flip]: The argument should be an array in /homepages/18/d201970486/htdocs/zencart/admin/easypopulate.php on line 1222
it isnt loading the feeds at all.. While getting the 500 returned it was loading the files. Any idea why the warning is being tossed out?
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Wizzard308
Ok while getting this error
Warning: array_flip() [function.array-flip]: The argument should be an array in /homepages/18/d201970486/htdocs/zencart/admin/easypopulate.php on line 1222
it isnt loading the feeds at all.. While getting the 500 returned it was loading the files. Any idea why the warning is being tossed out?
That array_flip error is because the fgetcsv function isn't returning the correct item. Could be a poorly formed csv. It won't work with the old format in 1.2.5.4
Could also be the wrong version of php, has to be 5.0+
Been a while so I'm not 100% sure.
I only had one project with ZenCart, so I haven't been around. Just checking up for v2, then I might play with it some more. I haven't found a single shopping cart that isn't slow and bloated. I might need to write my own on top of CodeIgniter if ZC2 fails.
-
Re: Easy Populate support for Version 1.2.5.4
Sorry if I'm just blind but, does Easy Populate csv 1.2.5.5.csv.2 have a spot for minimum quantity not just quantity available? If so, what is it called that's different?
-
Re: Easy Populate support for Version 1.2.5.4
Hi when I use an absolute url for the image location in easy populate it turns into
http://www.examplesite.com/images/ht....com/image.jpg
Any way to fix this?
Thanks.
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
phazei
That array_flip error is because the fgetcsv function isn't returning the correct item. Could be a poorly formed csv. It won't work with the old format in 1.2.5.4
Could also be the wrong version of php, has to be 5.0+
Been a while so I'm not 100% sure.
I only had one project with ZenCart, so I haven't been around. Just checking up for v2, then I might play with it some more. I haven't found a single shopping cart that isn't slow and bloated. I might need to write my own on top of CodeIgniter if ZC2 fails.
Ok I just installed php5 and now Im back to getting the Error 500 again.
So are you saying that the CSV files created for use in 1254 are not correctly formatted for version 1255 ? or that perhaps I have fouled the format maybe?
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
cpixi
Hi All... I have a similar problem, EZ Populate will not download files nor upload files, it just takes you to the admin login screen.
i am running ez 1.2.5.4 + zen 1.3.8.a + php5
seens some others had this problem but have not posted a fix in the general questions post.
any help would greatly be appreciated... I have installed and re-installed 3 times.
I'm having the same issue. I can't find a fix for this. Anyone know what's causing this?
-
Re: Easy Populate support for Version 1.2.5.4
Well I went back to EP version 1254 ZC138a
Im still getting error 500 but the products seem to be uploading. Im just not getting a report back.
This is weird because the first two files I uploaded gave me a report back with no error. All files after that return the 500 yet the product loads.
PS we really should be able to edit our posts so we can update them. It would make the forums much shorter to just update your current problem reports instead of making a whole new reply.
-
Re: Easy Populate support for Version 1.2.5.4
Hi, not sure if this it the right place to be posting,
I've just installed Easy Populate v 2.75a
I can go into zen cart admin, tools, easy populate - select the file to update, then click on insert in DB. but nothing happens apart from the page refreshes and products are not updated.
similarly when I try to use it to create an export file I can go through the motions of setting it up for export, I don't get any error messages but no file is created.
Anyone got an idea of what I'm doing wrong?
-
Re: Easy Populate support for Version 1.2.5.4
sorry, disregard that last post, I would delete it if I could
-
Re: Easy Populate support for Version 1.2.5.4
I have seen this posted elsewhere on this thread but have yet to see an answer. I have uploaded the files for version 1.2.5.5 I am working with zen 1.3.8. I have applied ths sql updates. I have done the installation per the install instructions. I can download the csv file.
I make changes to it and try to upload from hdd and I get no errors but I get no products added. I upload the file via ftp to the tempEP folder and add to db from that directory and get no errors but I get no products added.
I have unique names for the model, but it just doesnt seem to work. what am I doing wrong?
:frusty:
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
WilpackPackaging
I have seen this posted elsewhere on this thread but have yet to see an answer. I have uploaded the files for version 1.2.5.5 I am working with zen 1.3.8. I have applied ths sql updates. I have done the installation per the install instructions. I can download the csv file.
I make changes to it and try to upload from hdd and I get no errors but I get no products added. I upload the file via ftp to the tempEP folder and add to db from that directory and get no errors but I get no products added.
I have unique names for the model, but it just doesnt seem to work. what am I doing wrong?
:frusty:
Wil,
Go to Tools -> Store Manager and Run both:
Update ALL Products Price Sorter and
Reset ALL Products Master Categories ID
That should hopefully fix it.
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Go to Tools -> Store Manager and Run both:
Update ALL Products Price Sorter and
Reset ALL Products Master Categories ID
That should hopefully fix it.
I just tried that and still nothing. No additional products were added.
I tried doing the reset then re-uploading the file and then doing the reset again. Still not working.
-
Re: Easy Populate support for Version 1.2.5.4
Please read the title of this thread:
Easy Populate support for Version 1.2.5.4 namely Langer's version from Modhole not from ZC's download section.
The problem I am seeing is that with so many versions of EP floating about people are getting all sorts for issues and bugs and not being clear which version they are using.
Would it be an idea to start some new threads with the title of the versions of EP you are using ??
e.g
Easy Populate support for Version 1.2.5.4
Easy Populate support for Version 1.2.5.5.csv.2
Easy Populate support for Version 1.2.5.5
Easy Populate support for osc Version 2.77H
Just a thought :huh:
-
Re: Easy Populate support for Version 1.2.5.4
I've used EP to get items onto my site. Everything works great.
My issue is that I use the barcode numbers as the item number and when I download our current inventory to make price changes via EP, both excel and open office removes the zero off of the front of barcodes that then mess up my inventory on the reupload by adding duplicated products. How can I fix this?
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Scrat
Please read the title of this thread:
Easy Populate support for Version 1.2.5.4 namely Langer's version from Modhole not from ZC's download section.
The problem I am seeing is that with so many versions of EP floating about people are getting all sorts for issues and bugs and not being clear which version they are using.
Would it be an idea to start some new threads with the title of the versions of EP you are using ??
e.g
Easy Populate support for Version 1.2.5.4
Easy Populate support for Version 1.2.5.5.csv.2
Easy Populate support for Version 1.2.5.5
Easy Populate support for osc Version 2.77H
Just a thought :huh:
That is fine and dandy, however, in the download on the zencart site it references THIS THREAD! :censored:
-
Re: Easy Populate support for Version 1.2.5.4
Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?
I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.
my images are all in images/products/123456.jpg and I have verified they are there.
My csv file looks like this:
Code:
v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
yet when I upload and import the file I get images/no_picture.gif assigned to each item.
What am I missing?
JOhn ><>
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
stlnyc
I've used EP to get items onto my site. Everything works great.
My issue is that I use the barcode numbers as the item number and when I download our current inventory to make price changes via EP, both excel and open office removes the zero off of the front of barcodes that then mess up my inventory on the reupload by adding duplicated products. How can I fix this?
As you import into Excel set that column type as TEXT and it will leave it alone. This will not affect your import with the new prices.
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Stuff4Toys
Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?
I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.
my images are all in images/products/123456.jpg and I have verified they are there.
My csv file looks like this:
Code:
v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
yet when I upload and import the file I get images/no_picture.gif assigned to each item.
What am I missing?
JOhn ><>
When I export I get
Code:
v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,no_picture.gif,"PATRIOTIC PACHYDERM PR","With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,0,"0000-00-00 00:00:00","2009-06-11 15:22:19",999,,Americana,,,,,,,"Taxable Goods",1,0,0,0,0,0,,,
34190,no_picture.gif,"UNITED WE STAND WALL PLAQUE","Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,0,"0000-00-00 00:00:00","2009-06-11 15:22:19",999,,Americana,,,,,,,"Taxable Goods",1,0,0,0,0,0,,,
http://www.dahnkedulcimers.com/
JOhn ><>
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
stlnyc
I've used EP to get items onto my site. Everything works great.
My issue is that I use the barcode numbers as the item number and when I download our current inventory to make price changes via EP, both excel and open office removes the zero off of the front of barcodes that then mess up my inventory on the reupload by adding duplicated products. How can I fix this?
in excel: highlight the column(s), then "format cell" -> "number" tab -> custom -> now select the kind of number you'd like to show (i.e., use zeroes for the number of numbers in the UPC - mine all use 12, dvds).
I'm sure you can fiddle with excel and open office settings to default to this too, but I'm not sure how. using "text" should do it, but it didn't seem to work when I tested it.
I'm using office 2007, but it works similarly in earlier versions.
-
Re: Easy Populate support for Version 1.2.5.4
I've certainly messed with the format cells option in excel. But that is usually for new spreadsheets. When I open an EP file, it opens to excels default settings with the cells not formatted the way I want, and the beginning zero removed from the barcode.
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
stlnyc
I've certainly messed with the format cells option in excel. But that is usually for new spreadsheets. When I open an EP file, it opens to excels default settings with the cells not formatted the way I want, and the beginning zero removed from the barcode.
Yes, you are correct. The only way to get this done is to do a Data/Import into a new spreadsheet.
-
Re: Easy Populate support for Version 1.2.5.4
I am getting followin error, when I go in to edit byte size I do not find anything on that line that would enable me to do that:
Creat Froogle:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 189
Creat cvs file:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 24 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 393
Any ideas on how to fix this problem?
Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2
MySQL 5
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
WilpackPackaging
I just tried that and still nothing. No additional products were added.
I tried doing the reset then re-uploading the file and then doing the reset again. Still not working.
Okay... what is your default language? If it is not "1" for english, this also seems to cause problems. Are you running a multi-lingual store? If so, I think english still needs to be the default for ep to work correctly. I have not tested this, but this does come up from time to time.
Also. Jump into phpMyAdmin and check the databases manually to see if in fact NO data was imported.
-
Re: Easy Populate support for Version 1.2.5.4
stlnyc If you use OO and start with a fresh sheet (No data) and
> Insert
>Insert from Sheet
Choose the .txt file, then a new window opens with Fields,
Column Types - you can select the model column to open as a Column Type => Text
This should not change the format of your barcode number whether EAN, 2of5, or any other barcode format.
WilpackPackaging
Whats the :censored: about,
I am trying to be helpful it may save some one a lot of time, it was the original author (porter) of EP 1.2.5.4 who started this thread. The thing is that these new EP version work slightly different,
Version 1.2.5.4 is tried and tested (with a few know bugs) but it just works, these others seem to have bugs...
Sorry if I seem to have offended you ?
-
Re: Easy Populate support for Version 1.2.5.4
Ok, I still cannot get a EP file to open. In Excel, during the import all of the cells are jumbled but the barcode shows with the leading zero (as I want it to), and in OO the preview looks great but in the actual view the leading zero is gone but the other cells are all lined up.
-
Re: Easy Populate support for Version 1.2.5.4
stlnyc Any chance of a test file example ?
-
Re: Easy Populate support for Version 1.2.5.4
A test file can be found below. Each of the Item numbers listed are the items barcode and each one should start with a "0"
Without the zero, EP uploads the items as a new product, therefor duplicating the items currently in the database.
http://www.hillsideliquors.com/Full-EP2009.csv
-
Re: Easy Populate support for Version 1.2.5.4
Hi, is it possible to use absolute urls to images with easy populate? Thanks.
-
Re: Easy Populate support for Version 1.2.5.4
stlnyc By the looks of your test file its not OO or Excel which is your problem it is EP 1.2.5.5 csv as it looks as if it is stripping the '0' from the model field when it downloads the file from Zencart, if you open the file in just a text editor there are no leading '0', so it is not in the file to start with?
(Just a thought is the test file edited in OO or excel before saving or in a text editor, as if in OO or excel you will loose the '0' unless you open in the way i suggested earlier, if in a text editor (wordpad, gedit) it should remain original ?)
-
Re: Easy Populate support for Version 1.2.5.4
That test file was download through EP admin in ZC admin. I did edit the file a little, which maybe why it lost the zero. Here is my full file direct from my EP Temp Directory. And opening it in notepad shows the leading zeros.
http://www.hillsideliquors.com/tempE...Jun13-1705.csv
-
Re: Easy Populate support for Version 1.2.5.4
stlnyc
As opened in OO as suggested, no problems with fields merging or loosing '0's.
Quote:
v_products_model v_products_image
0783 DSC02309.JPG
9428 DSC01401.JPG
01007 DSC02337.JPG
235689 beauvigne_cab.JPG
08981972337 DSC02347.JPG
08682830001 DSC01458.JPG
01248599002 DSC02412.JPG
08088749396 DSC02479.JPG
08069692122 DSC02349.JPG
08069612122 corks.gif
08069691534 DSC02349.JPG
08069609642 bvnapa_cab.JPG
Which fields are getting
Quote:
during the import all of the cells are jumbled
?
-
Re: Easy Populate support for Version 1.2.5.4
Ok, sweet, finally got it working, although the pricing isn't in the file.
-
Re: Easy Populate support for Version 1.2.5.4
I'm running Easy Populate 1.2.5.5.csv 2
Every time I go and upload my new .csv file, none of the new products are added, but it says the old ones are updated. I am doing nothing different and everything is in the correct columns. My statuses are --none-- 1 0 0 0 0 0
, the same as they always were, but nothing new is being added. I've double checked my .csv and everything is correct, category names, etc.
Please help me figure out why it's doing this. If you need any other info just let me know, I don't really know what else to say.
Thank you.
-
Re: Easy Populate support for Version 1.2.5.4
Never mind that post, I'm re-doing everything and it's working now. I guess in the future I'll just upload it after every few products instead of adding a huge batch, for some reason that's not working..
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Kenichi
Never mind that post, I'm re-doing everything and it's working now. I guess in the future I'll just upload it after every few products instead of adding a huge batch, for some reason that's not working..
I was having the same problems and after fully reading the wiki for EP, you can remove columns from the complete EP file. As long as the item number is the same, only include the item number column and any of the other columns you are updating. Remove all the other columns that stay the same and you will have no problem no matter how many lines are in your spreadsheet.
-
Re: Easy Populate support for Version 1.2.5.4
I've only one problem with latest version of easy populate, after importing the csv file, i've the categories names in only one language, instead production description and title are rights in both languages i'm using. :huh:
example:
language 1 CATEGORY
language 2 CATEGORIA
after importing file
language 1 CATEGORY
language 2 (empty)
but product are rights in boths languages.
How i fix this? :shocking:
Thanks!
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
stlnyc
I was having the same problems and after fully reading the wiki for EP, you can remove columns from the complete EP file. As long as the item number is the same, only include the item number column and any of the other columns you are updating. Remove all the other columns that stay the same and you will have no problem no matter how many lines are in your spreadsheet.
Thanks! That works like a charm =)
-
display mode attribute?
I am currently running the cart in "display mode" for 2,000 products, however, I need to make the cart active for 250 products within a specific category.
Is it possible to control the cart's "display" mode via EP? Perhaps by adding an attribute?
Please advise - thank you!
-
Re: Easy Populate support for Version 1.2.5.4
Has anyone had success running this from the command line or from a "Read HTML page" type function?
I'd like to setup some automated exports but not having success....
-
Re: Easy Populate support for Version 1.2.5.4
EarlyFloyd Not with the current version of EP, this could be done with a SQL query tho'
MotoDelta If you have command line access, why don't you directly connect to Database using Python(very easy to learn using MYSQLdb module) or any other language and write an automated script to export data?
-
Re: Easy Populate support for Version 1.2.5.4
Doing some testing here before I make mass changes...
I've downloaded a Complete tab-delimited .txt file to edit. I made one change to one product which was to the v_products_name_1. I just changed the product name.
I then deleted all other product rows, leaving just the one row with the test product to change.
I saved file as a tab-delimited text file and uploaded it to the database with EP.
EP uploads the file but, I always get this error which baffles me because I am uploading the same data and all columns as I downloaded except for one change to the product name.
Now the product update actually worked but, I am not sure if this is something of concern or if it's normal.
UPDATED! - Model: my model number | imagefolder | productname | productdescripttion | | | | | price | 0 | | 3/1/2009 1 | 25 | | Catagory1 | Category2 | Category3 | | | | | Taxable Go | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Upload Complete
-
Re: Easy Populate support for Version 1.2.5.4
Crunch Check your file, have you got a carriage return on the end of your second row, normally you would get this error if you do ?:
PHP Code:
UPDATED! - Model: test | test | test | test | | | | | 137.02 | 1.2 | | 0000-00-00 | 200 | 1 | 2 | 3 | | | | | | Vatable Go | 1 |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | |
Upload Complete
May be as simple as that, if so remove/delete it
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
EarlyFloyd Not with the current version of EP, this could be done with a SQL query tho'
Could you please provide and example? I know how to run a query at this point, but not how to write from scratch yet. I would appreciate it!
-
Re: Easy Populate support for Version 1.2.5.4
EarlyFloyd
Please note I haven't tested this and use at your own RISK... as always TEST first before use on a live site and always BACK UP....
PHP Code:
UPDATE products SET products_status = '1' WHERE master_categories_id = 'x' and manufactures_id = 'y';
This should update the product status to active in all the products in the top level category down wards of your top category 'y' with manufacturer 'x'.
(y and x are the id numbers of the category and manufacturer which you can find in your database via phpMyAdmin in the products table)
A very good site for learning SQL for Mysql is tizag you just remove the ' $result = mysql_query(" ' to use pure sql in the Zen Carts SQL Query Executor, always end your SQL with ';'.
-
Re: Easy Populate support for Version 1.2.5.4
Thank you very much for the example and source for further knowledge. I will give it a go tomorrow. :smile:
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Scrat
Crunch Check your file, have you got a carriage return on the end of your second row, normally you would get this error if you do ?:
PHP Code:
UPDATED! - Model: test | test | test | test | | | | | 137.02 | 1.2 | | 0000-00-00 | 200 | 1 | 2 | 3 | | | | | | Vatable Go | 1 |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | |
Upload Complete
May be as simple as that, if so remove/delete it
I tested again and checked the tab delimited file and there was a carriage return after EOREOR which I deleted and saved. Still got the same error when I uploaded again. This error must be an odd quirk with the contribution.
-
Huge product update (30,000 items)
I have a product listing of over 30,000 items. I tried to upload a .csv to the datbase, via easypopulate, and it did import 13,000 or so of those items...then the server timed out. I seperated the master .csv into three smaller .csv's. Now they don't seem to be uploading at all. Should I TRUNCATE the table in phpMyAdmin before I try uploading again? Also, if I have to upload three different .csv's will they simply overwrite each other or will they add to the tables in the database?
Dale
:blush:
-
Re: Easy Populate support for Version 1.2.5.4
jdw1979 EP Version 1.2.5.4(langer) really works best with approx. 400 products at once, have you got the headers in each cut down file, as you do need these or EP would not know what it is uploading. Do you get any error messages - me thinks not as with over 400 products you usually do not.
As a test cut the original file down to say 10 products and the header row and try it if all seems well this is your problem.
-
Re: Easy Populate support for Version 1.2.5.4
I have continued to fool with this batch update and I have cut the file down to 5000 products per sheet. This seems to upload fine. Thanks for your help.
Dale
-
Re: Easy Populate support for Version 1.2.5.4
I dont really understand this.
7) If you have an Apple/MAC, then uncomment the line in the "configuration variables" section in the easypopulate.php
file that is in the admin folder.
Also when I download the Download Complete .csv file to edit (Attributes Not Included)
it crashes my excel I m on a mac
any ideas
-
Re: Easy Populate support for Version 1.2.5.4
touchclothing What version of EP are you using ? I don't use a MAC so not the best to advise, but i am sure i have read it some where in this forum that MAC file formats cause problems with EP and tab separated files, hence the
Quote:
uncomment the line in the "configuration variables"
OK Found this:
Quote:
Originally Posted by
jimmysflyshop
We are using Zen Cart 1.3.8 which I believe is the current program. We have been using Zen Cart for the last few months and have just recently launched our site. We have all the latest programs for Zen Cart. During the building process I was using a PC. I have just purchased an Macbook, and installed Microsoft Office so that I would be able to use Easy Populate with Zen Cart. Everything works okay except for one issue.
My issue is that when I download and update the .csv file and try to import it back to Zen Cart it is not properly updated. The new information that I have entered and saved on the .cvs file is not imported into Zen Cart. When I save the file to be imported I save it as a .csv file. I get a message that the import was successful but I don't receive any messages about the site being updated like I do on my PC.
Am I missing something here? I know I can't be the only one using an Apple to run Easy Populate. Any help would be appreciated. Hopefully I have given you enough information to help me, if not let me know.
Quote:
Originally Posted by
rstevenson
I'm on Mac (OS X v10.4.11) and I too use Excel and EZ Populate, but not often so my memory is a bit rusty on this. I recall that I had some sort of problem using the Excel-created file directly. Since I have a programmer's editor (the excellent BBEdit, see barebones.com) it was easy and quick to open the file in my editor, save it again and then upload it. I never trust MS products to do things simply, so I wouldn't expect the Excel file to be a plain text file. There'll be some junk in it somewhere, I'm sure.
Rob
-
Re: Easy Populate support for Version 1.2.5.4
EP is not updating my images file name and path. Is the problem the "/" in the file path? I need to get this working ASAP, I have over 5000 itmes to input.
Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?
I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.
my images are all in images/products/123456.jpg and I have verified they are there.
My csv file looks like this:
Code:
v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
yet when I upload and import the file I get images/no_picture.gif assigned to each item.
What am I missing?
JOhn ><>
-
Re: Easy Populate support for Version 1.2.5.4
Stuff4Toys As far as I was aware you will only get 'images/no_picture.gif' if no image is assigned to the product, so it would appear that the version you are using is not updating the database in someway properly.
When you edit the product manually is there a image assigned or is the image box empty.
Also I would try the Langer's version from Modhole as this is a tried and tested version that just works !
-
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Stuff4Toys
EP is not updating my images file name and path. Is the problem the "/" in the file path? I need to get this working ASAP, I have over 5000 itmes to input.
Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?
I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.
my images are all in images/products/123456.jpg and I have verified they are there.
My csv file looks like this:
Code:
v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
yet when I upload and import the file I get images/no_picture.gif assigned to each item.
What am I missing?
JOhn ><>
Its a problem with your directory. I think by default it chooses /images which means that your images should be in /images/products I think.
-
Re: Easy Populate support for Version 1.2.5.4
fsc09 EP takes the folder /images/ as default so their is no need to put this in the v_products_image, just the child folder to /images/. In this case that would be products/ - e.g products/33838.jpg.
What is strange, if EP had put the image in the 'products_image' you should not get 'images/no_picture.gif' appearing as ZC sees that the 'product_image' field is not 'null', therefore that is why I asked does the image details appear when you edit the product by ZC.
-
Re: Easy Populate support for Version 1.2.5.4
I am on Zen Cart v 1.3.8a
Does Easy Populate 1.2.5.5 work with that? The download page says it is for Zen Cart v 1.3.6
I just want to make sure as I am new to Zen Cart in the last month.
-
Re: Easy Populate support for Version 1.2.5.4
I uploaded quite a few products last night successfully. This morning I'm getting "Upload Complete", but nothing is being uploaded. I don't get the list of products added like I did last night - just the complete message (with temp file name, user filename, and size displayed). Any ideas?
-
Re: Easy Populate support for Version 1.2.5.4
Nevermind. I found it - I had saved the file as csv rather than txt (tab).
-
Re: Easy Populate support for Version 1.2.5.4
Referring to EP 1.2.5.5 csv2.
I installed this without a glitch following instructions in install.txt.
However, I was curious as to what the install.sql was doing in the install package.
I did not need this file to perform installation, did not use it.
I looked into the sql and saw it is intended for 1.2.5.4.
So, shouldn't it be removed from the install package for 1.2.5.5?
-
Re: Easy Populate support for Version 1.2.5.4
Will EP work with the MultiSite Module I have installed?