Does Easy Populate let you import your data from an excel spreadsheet into your mysql database?
Thank you
LadyDee
OK, I have gotten most of this to work by using the documentation that schoolboy created. However when I download the file that was created for my temp directory there is not much in there. There are 668 rows in my file and I only get two returned. I do not know what I am doing wrong. I have read the directions two times or more and made any changes it recommended.
Could someone please help with this problem. My data for each manufacturer is quite large like 600 products for 20 manufacturers. It would be very time consuming to import this manually.
you can use excel, however you should be importing comma or tab delimited files, as easy populate will not recognise the excel file format. the two lines that were returned in the temp file are probably just the first attempt (and subsequent failure) to read this file.
you can save your excel file when it is ready for importing by using the file->save as... function, and choosing the file type "*.csv". you'll lose your formatting, but that is of little consequence except when it comes to dates and numbers so be careful how you format those columns (can sometimes take a little playing around to get it right depending on how much info you're uploading).
I have tried what you stated already. If I do a save as and let the window box open, I same it as a text file with tab delimited. There are three types of cvs files that it can be save in and they are cvs comma delimited (new not to used that one) cvs (macintosh) and cvs (ms-dos). I am only geting the headers, like v_products_model, etc. I even cut the file down to 100 rows and still get the same. Also I have tried it with EOREOR at the end of every line and at the end of only the last line, I aways get the same thing.
hmmm, i know i had some trouble with the version originally submitted by langer, however came across a "patched" or enhanced version by phazei, which worked for me quite well. i'll have a look at my file formats, but may not be able to help much more if the versions are different with respect to file format variations. will have a look now and get back to you shortly.
I have also tried this one EP_v2_75a_Zen-Cart_1_2 but according to the documentation that schoolboy did we should not be on that version don't know. Anyway when I had that version installed I did not have the documentation so, my excel sheet did not have the correct headings and I was not using cvs.
so sorry, but it looks like my version is somewhat different.
i use comma separated values for my imports, which are clearly defined in the easypopulate file that resides in my admin directory. the version i am using is unfortunately v1.2.5.5, meaning i'm not comparing "apples with apples". perhaps if i get time over the next few days i'll be able to have a closer look, in the meantime hopefully someone else may be able to help.
I have a quick question. I am thinking about trying easy populate, I now use a inventory source to load my store for me, Does easy populate add the images and descriptions all in one upload, or do you have to add images and descriptions seperate?
Also where can I find instructions on using easy populate, as far as where you upload the easy populate.php file and things like that?
instructions will come with the download, and irrespective of the version you get they are comprehensive from what i've seen. i've used 3 different versions, and none have handled images natively. it is possible to upload binary data to your database, or your server, however this is not something that i've seen handled well or with any degree of flexibility within easy populate itself.
other than this though i've found it to be extremely useful as it does all descriptions, categories, manufacturers, multi-level pricing, discounts, specials, features, new products etc.
re: images, one option here might be to use a standard naming convention. for many businesses, traditional or online, the product code is unique by definition. although i don't think zen-cart requires it to be, you could simply enforce this policy and use it to name your images. this facilitates at least some automation with your import file, however can become confusing if you don't upload files to match the databases filenames as zen-cart will fail-over to the standard "no picture" without warning you during the import.
i have done a substantial amount of work getting my version of easy populate to work in harmony with some local scripting however, that extract data i've already entered into my financial/stock management software, prepares the data for upload and fills in the blanks based on some logic i came up with to ensure everything still looks good. this allows me to enter and maintain over 2,000 products in my own system, run my business and maintain ALL product information at a few clicks of a button. the script throws warnings into a log file during the import procedure to notify the user of any inconsistencies, and while it took several weeks to get this working properly, it saves ooooooodles of time long-term, so i can vouch for the fact that it is not only do-able, but very desirable!
Thank you for your input, I was trying to find ways to cut cost, I pay 50.00 a month for inventorysource to upload all of this for me, If I could save 600.00 a year that would be great:)
bdodd42
Moderation
Destination thread ID and reason are required when shown.
Report Post
Tell staff why this post should be reviewed.
Manage cookie preferences
Our cookie policy has been updated, so we need you to review your preferences and consent again.
