Easy Populate 1.2.5.4 support

I have EZP 1.2.5.4/ZC 1.3.8a installed on Godaddy shared hosting. When it works, it works great! My problem is, it only works 10% of the time!

I only have about 6000 items in the database. I have been working on this for days and am getting nowhere. I currently have PHP.ini timeouts set at 300. Admin->My Store->Max Execution time = 300. Split count set to 100. These are all set well within range of EZP. But no matter what they are set to, the problem is still the same. Here is the problem:

**I click "Split File" to upload my 1.73mb file over a 6MB connection. It sits for about 2 minutes before returning:

"Internet Explorer cannot display the webpage"

So I tried uploading the split files myself via FTP and processed them them manually. I get the same result. Sometimes it imports, most the time it says "cannot display page".**

I have tried every setting I can think of. Tried Firefox. Tried different computers. Still it is completely random. Last night it worked 80% of the time... Today I tried again and have not been able to get it working even once all day!

What is going on here? Any suggestions PLEASE! I have a client waiting on this site but I have to get EZP working before I can deliver it.

OK so I did a little reading on this thread (sorry I was searching easypopulate instead of easy populate so I missed the previous explanations of this problem) but I am still concerned.

I read that EZP does not show the success report screen if there are over X number of products. But it DOES still work I have read. Here are my questions now:

**Approximately what is X?

Does X stand for number of products CURRENTLY on site or number contained inside the uploaded spreadsheet? Because I never had this problem during initial population. Its only been happening now that I am trying to update/add more products.

EZP will not return a success screen even when uploading using the "Split File" function?

When importing the split files one at a time will I still not get a success screen even tho the files only have 100 products each?**

This is all going to be automated so the success screen is not required but I need to make SURE it works 100% of the time anyway. From what I read it will. Is this correct? TIA!!

Any one know if Easy Populate is compatible with "Multisite module"?
What kind of problem s vcan be expected?

marksu:

Any one know if Easy Populate is compatible with "Multisite module"?
What kind of problem s vcan be expected?

It works fine. Ideally, you need to add the site name to the product description (see multisite mod info) in your upload file. If not you would need to edit every item in ZC.

Jeff

I'm really sorry in advance for not reading 81 pages of a closed thread and 180+ of this one, but I cannot find the answer anywhere so far...

So I've installed Easy Populate 1.2.5.4 and it seems to be functioning correctly, I think I just don't understand how to use it... :frusty:

I download the .txt, open with excel, add my own stuff, upload, get error.
Fine.
I copy the .txt to my temp, ftp it down, open with excel, change items in stock number, get nothing.

How am I supposed to edit or whatever the hell the files so that I can import items into my zen cart? When I add items, I get this:

No model field in record. This line was not importedsecurity_1 | Surveillan | | | | | | 99 | 0 | | 9/12/2008 | 10 | | Surveillan | | | | | | | --none-- | 1 |
No model field in record. This line was not importedsecurity_2 | Surveillan | | | | | | 99 | 0 | | 9/12/2008 | 10 | | Surveillan | | | | | | | --none-- | 1 |
No model field in record. This line was not importedsecurity_3 | Surveillan | | | | | | 99 | 0 | | 9/12/2008 | 10 | | Surveillan | | | | | | | --none-- | 1 |
No model field in record. This line was not importedsecurity_4 | Surveillan | | | | | | 99 | 0 | | 9/12/2008 | 10 | | Surveillan | | | | | | | --none-- | 1 |
No model field in record. This line was not importedvideo_1.jp | DVR System | | | | | | 199 | 0 | | 9/12/2008 | 10 | | Sound \ Vi | | | | | | | --none-- | 1 |
No model field in record. This line was not importedvideo_2.jp | DVR System | | | | | | 199 | 0 | | 9/12/2008 | 10 | | Sound \ Vi | | | | | | | --none-- | 1 |
No model field in record. This line was not importedvideo_3.jp | DVR System | | | | | | 199 | 0 | | 9/12/2008 | 10 | | Sound \ Vi | | | | | | | --none-- | 1 |
No model field in record. This line was not importedvideo_4.jp | DVR System | | | | | | 199 | 0 | | 9/12/2008 | 10 | | Sound \ Vi | | | | | | | --none-- | 1 |
No model field in record. This line was not importedvideo_5.jp | DVR System | | | | | | 199 | 0 | | 9/12/2008 | 10 | | Sound \ Vi | | | | | | | --none-- | 1 |
No model field in record. This line was not importedaccess_1.j | Access Con | | | | | | 49 | 0 | | 9/12/2008 | 10 | | Access Con | | | | | | | --none-- | 1 |
No model field in record. This line was not importedaccess_2.j | Access Con | | | | | | 59 | 0 | | 9/12/2008 | 10 | | Access Con | | | | | | | --none-- | 1 |
No model field in record. This line was not importedaccess_3.j | Access Con | | | | | | 69 | 0 | | 9/12/2008 | 10 | | Access Con | | | | | | | --none-- | 1 |
No model field in record. This line was not importedaccess_4.j | Access Con | | | | | | 79 | 0 | | 9/12/2008 | 10 | | Access Con | | | | | | | --none-- | 1 |
No model field in record. This line was not importedweb_1.jpg | Web Servic | | | | | | 299 | 0 | | 9/12/2008 | 10 | | Web Servic | | | | | | | --none-- | 1 |
No model field in record. This line was not importedweb_2.jpg | Web Servic | | | | | | 399 | 0 | | 9/12/2008 | 10 | | Web Servic | | | | | | | --none-- | 1 |
No model field in record. This line was not importedweb_3.jpg | Web Servic | | | | | | 499 | 0 | | 9/12/2008 | 10 | | Web Servic | | | | | | | --none-- | 1 |
No model field in record. This line was not importedweb_4.jpg | Web Servic | | | | | | 149 | 0 | | 9/12/2008 | 10 | | Web Servic | | | | | | | --none-- | 1 |
No model field in record. This line was not importednetwork_1. | System Net | | | | | | 249 | 0 | | 9/12/2008 | 10 | | Systems Ne | | | | | | | --none-- | 1 |
No model field in record. This line was not importednetwork_2. | System Net | | | | | | 349 | 0 | | 9/12/2008 | 10 | | Systems Ne | | | | | | | --none-- | 1 |
No model field in record. This line was not importednetwork_3. | System Net | | | | | | 449 | 0 | | 9/12/2008 | 10 | | Systems Ne | | | | | | | --none-- | 1 |
No model field in record. This line was not importednetwork_4. | System Net | | | | | | 549 | 0 | | 9/12/2008 | 10 | | Systems Ne | | | | | | | --none-- | 1 |
No model field in record. This line was not importednetwork_5. | System Net | | | | | | 899 | 0 | | 9/12/2008 | 10 | | Systems Ne | | | | | | | --none-- | 1 |
No model field in record. This line was not importedphone_1.jp | Phone Syst | | | | | | 129 | 0 | | 9/12/2008 | 10 | | Phone Syst | | | | | | | --none-- | 1 |
No model field in record. This line was not importedphone_2.jp | Phone Syst | | | | | | 149 | 0 | | 9/12/2008 | 10 | | Phone Syst | | | | | | | --none-- | 1 |
No model field in record. This line was not importedphone_3.jp | Phone Syst | | | | | | 89 | 0 | | 9/12/2008 | 10 | | Phone Syst | | | | | | | --none-- | 1 |
No model field in record. This line was not importedphone_4.jp | Phone Syst | | | | | | 149 | 0 | | 9/12/2008 | 10 | | Phone Syst | | | | | | | --none-- | 1 |
No model field in record. This line was not importedservice_1. | Service Pa | | | | | | 499 | 0 | | 9/12/2008 | 10 | | Services a | | | | | | | --none-- | 1 |
No model field in record. This line was not importedservice_2. | Service Pa | | | | | | 599 | 0 | | 9/12/2008 | 10 | | Services a | | | | | | | --none-- | 1 |
No model field in record. This line was not importedservice_3. | Service Pa | | | | | | 699 | 0 | | 9/12/2008 | 10 | | Services a | | | | | | | --none-- | 1 |
No model field in record. This line was not importedservice_4. | Service Pa | | | | | | 1299 | 0 | | 9/12/2008 | 10 | | Services a | | | | | | | --none-- | 1 |
No model field in record. This line was not importedaldelo_edc | Aldelo EDC | | | | | | 599 | 0 | | 9/8/2008 2 | 10 | | Aldelo | | | | | | | --none-- | 1 |
No model field in record. This line was not importedaldelo_liq | Aldelo For | | | | | | 499 | 0 | | 9/8/2008 2 | 10 | | Aldelo | | | | | | | --none-- | 1 |
No model field in record. This line was not importedAldelo-Log | Aldelo For | Ideal POS | | | | | 899 | 0 | | 9/8/2008 2 | 10 | | Aldelo | | | | | | | --none-- | 1 |
No model field in record. This line was not importedcomcash_sc | Comcash So | The new SQ | | | | | 849 | 0 | | 9/9/2008 0 | 10 | | Comcash | | | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | 

Now, all these items were created by me one-by-one. I was trying to change the item quantities to 10 (from mostly 0) and could not do that.

How, also, can I add new items into new categories?

thanks in advance,

-Tim

Tim,

EP requires a model number to work. There MUST be a column with a UNIQUE model number for each item. Column heading must be v_products_model.

You need to be careful. If you have the same model number on more than one line it will overwrite info from the prior one.

If you do not have model numbers, simply create a sequential number in Excel for that column. When updating or adding, be carefull to always use the same number for the same product and do not reuse numbers or you will end up with duplicate or missing product.

Jeff

I just installed easy Populate and get the following errors:

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information

Page: /shop/admin/easypopulate.php?dross=delete

and when trying to create a file I get this error:

Page: /shop/admin/easypopulate.php?download=tempfile&dltype=fullTime: 19-Sep-2008 2:47:39 EDTThank-you! File Full-EP2008Sep19-0202.txt successfully exported! The file is ready for download in your /temp/ directory.

There is NO file in the temp folder. ;0(

Tina

Hi everyone!
Until a few days ago easy populate was working completely fine on my site. But I've had to do something a bit complicated I guess....
My supplier gives me data feeds for stock levels which are I guess for osCommerce, not Zen cart. So whenever I download a new one I have to change it to make it compatible with easy populate.
This feed contains the model number, product name and stock level.

The supplier sells around 3000 products and I only sell 2500 of those, so what I thought of was, I'll add a category field to the stock feed with a new category for all the products. Then after updating the database I delete the new category and am left with updated data for the products I wish to sell.

Now I noticed that I was having problems with: Descriptions and manufacturer data. All of which either copied previous item's data or were made completely blank.

Luckily I had a back up so I fixed the problem but I have no idea how to update my stock levels without messing everything else up!

As far as I can tell the problem is caused by: My supplier's feed does not contain descriptions or manufacturers. And even if it did I would much rather rewrite them and use my own so I do not want to update them with my supplier's data!
Because my supplier has more products in the feed than what I actually resell, I cannot just add the stock levels column into my own easy populate file and assume it matches.

Is there anyone else out there in a similar situation?

After all the posts and threads I've read, I just can't figure it out!

Easy Populate works great as far as quick up loading of products, prices and the like.

Here's the deal! I do custom product descriptions ( to long for product description section in Easy Populate). I use a basic description on the description area of EP upload it and then add on to the description after it is uploaded.

Every time I upload new prices in a category, all the custom descriptions disappear.

I have tried removing the description section on the .txt sheet, uploaded and it still removes what description I have already there.

How to you save and leave descriptions not editable so when you upload massive price changes the descriptions stay in tack.

Can an editable table be add to the products_infomation_display.php and if so, how would you access it to load product descriptions?

Figuring this out will save all store operators a great deal of time and money.

What does anybody think or know?

:frusty:
Can someone let me know if I can add shipping prices in a spreadsheet that will work with easypop? Basically my suppiler gives me a spreadsheet with shipping prices for each product, so I would like to have a shipping price per unit and I would like to do it in a spreadsheet, I have oever 2000 products.

Thanks:

evil_grrrl666,

I would suggest you initially make an Excel file with the items that you do not sell. Then each time you receive a new file you could use the Excel function to remove the items from the new file that exist in the 'not wanted' file. Sorry, but that I don't know how to do, but I know it can be done.

I am pretty sure manufacturer is not required in EP so having it blank should not cause a problem. You might have to test that. Alternatively you could just add one in Excel.

As to descriptions, I'd suggest an approach similar to above. Using a current file from the vendor, add the description column and your descriptions. (You can format the text using standard HTML tags.) Save as a template for later use. When a new file is received from the vendor, Excel has a function/feature that will allow you to fill a column with data from another sheet if a certain column (model in this case) matches. Once again, I know Excel can do it, but I don't know the steps.

johnnylazerball:

( to long for product description section in Easy Populate).
I've used some pretty long description in EP with no problems. How long are your descriptions? Also, are you aware you can format your descriptions in excel by adding html tags?

Every time I upload new prices in a category, all the custom descriptions disappear.
If you cannot fit you descriptions in Excel, you need to change easypopulate.php.

Duh, I just realized this will probably time out before I get the code. I will post the code in a few minutes.

johnnylazerball:

Find this around line 2060. Its actually on several lines. ```php
"UPDATE ".TABLE_PRODUCTS_DESCRIPTION." SET products_name='" . zen_db_input($name) . "', products_description='" . zen_db_input $v_products_description[$key]) . "',";

I don't know the exact syntax, but add a wrapper something like this:
```php
if ($v_products_description[$key] > '') {
      (existing code)
}

I'm not sure of the exact way to code this in php, but this is what you need.

Disclaimer: always backup before testing. I believe this is the correct section but cannot be sure without actually trying it. I've done several things like this, so it's an educated guess we're in the right place.

Jeff

jgg1974:

:frusty:
Can someone let me know if I can add shipping prices in a spreadsheet that will work with easypop? Basically my suppiler gives me a spreadsheet with shipping prices for each product, so I would like to have a shipping price per unit and I would like to do it in a spreadsheet, I have oever 2000 products.

Thanks:

That's probably going to be a tough one. I don't think ZC has a place to store shipping cost per product, therefore EP has no place to put the data.

My first though was to make shipping an option, set it required and it would be added. But your problem there is sales tax would be added to shipping, which is not done in many (most?) jurisdictions.

Jeff

I am not sure exactly what you mean.

This is a sample of the short description that I upload with easy populate
Acetyl L-Carnitine is also known by other names such as Alcar, Acetyl Carnitine, N-Acetyl L-Carnitine, Acetyl L-Carnitine

This is a sample of what I add to the product description

(part of this is table that doesn't show here because of text only)

Acetyl L-Carnitine 500mg 120 Vcaps

SUPPLEMENT FACTS
Serving Size: 1 Vcap
Servings Per Container: 120

Amount Per Serving

% Daily Value

Acetyl L-Carnitine (Kosher Certified)

500 mg

*Daily value not established.

Other Ingredients: Rice Flour, Cellulose, Magnesium Stearate (Vegetable Source), Silic

Storage: Keep this product in a cool dry place.

Contains No Added: Free of Sugar, Starch and Sodium. No Artificial Colors or Preservatives.

Suggested Use: As a dietary supplement take 1 to 2 capsules once or twice daily with a glass of water and food or as directed by a health care professional. Take consistently each day for best results.

Warning: Do not use if tamper resistant seal is missing or broken. Seek the advice of a health care professional before using. Consult your physician prior to use if you are pregnant or nursing.

I have manage to add a table to the product_display_information.php but I am not a coder so after I put in the table, I still don't have any idea how to add content to it or how to make it useful for 800 different products.

I have seen many users having problems with attributes. I found a workable solution.

I posted it to the wrong topic. You can find it here.
http://www.zen-cart.com/forum/showpost.php?p=614245&postcount=562

Is there a way to move postings?

Jeff

Johnny,

It looks like I had some wrong or incorrect information. I tried to paste a table into an Excel cell with no success. There might be a way to do it, but I could not figure it out.

I tried creating a table in an HTML editor, copying and pasting into a cell. Something caused it to go into multiple cells.

You can put multi-line descriptions in using <br> tags for line feeds. You could have something like:

Acetyl L-Carnitine 500mg 120 Vcaps<br>SUPPLEMENT FACTS<br>Serving Size: 1 Vcap<br>Servings Per Container: 120

The <br> acts as a line feed in web pages.

That's about all I can offer for now.
Hopefully someone else can add to this.

Jeff

Quick last question for me. Can any one help me with getting URL;s to work, displaying images ? All my images are from a third party web site and I need then when i download my spreadsheet, for the images to show my images on my webapge. So basically I have heard that when using images, they have to be on my directory and that they have to be in a kdfi.jpg format, pointing to my image folder, but this isnt what I need. I need to be able to read from the URL, I have like over 20,000 products and all the images are from my suppliers webpage, and no , he doesnt have any images files to give to me, and no, I just need this to work this way , be it I have over 20,000 products. I dont want to mess with the spreadsheet, I would rather Thanks so much if any1 can help . make some mod to my backend to make it work or the like,

I have searched the high seas with no answer.

Every time i upload records via EP the products do show up on the site nicely, however, when I try to edit them in the Admin panel i get this error message:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.products_price_sorter, p.master_categories_id fr' at line 25
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.browse_by_make p.products_price_sorter, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = '55' and p.products_id = pd.products_id and pd.language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

any idea how to fix it? :cry:

Jeff,

Thanks for working with me.

Please understand, I can add all of the lengthy description via category/ product page in Zen Cart.

The problem is when I upload new price adjustments via Easy Populate, all the description I have built reverts back to the short one I started with.

You can view the page at
http://www.greasedlightning.info/motherearthworks/acetyl-lcarnitine-500-mg-30-vcap-p-1167.htm

All I need to figure out is how to save all the lengthy description or insert a new (accessible and editable) text box or table.

You will notice in the web page, that I have manage to add a table but not being a coder I don't know how to make it editable.

Please get back to me!
Johnny