Easy Populate 1.2.5.4 support

[gxjenkins]

Just an update. I have gotten Open Office to upload items. Most times the upload will time out, and it comes back with just a blank page, but the items are being uploaded. Another problem is that it will not split large files. That I have to do manually. So, it comes down to it's not as quick as using Excel, but I do get the full description, but I have to check to make sure it uploads the entire file.

I was able to get the files that would not upload to upload by making sure the Row Height was set to the default height. During the copy operation from one sheet to another some of the row heights were changed. Making sure the Roe Height hasn't changed, and splitting the myself seems to have this working.

I'm using Excel 2000, and Open Office 2.2

[vampke]

Hi guys,

I have installed the latest version of the mod (v1.2.5.4) on the latest version of zencart (1.3.7) and it seems to be working more or less
however i am hesitant to run the script, since my shop is live and i REALLY don't want to mess things up.

I have downloaded the "Complete tab-delimited .txt file to edit" and want to add data to it.

2 questions:
1. do I leave the data that is already in the txt file? Or can I remove it.
2. where in this file can I add the category where the items should be under?

I have these fields in the downloaded file: v_products_model v_products_image v_products_name_2 v_products_description_2 v_products_url_2 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_tax_class_title v_status EOREOR

category does not seem to be here

thanks in advance!

[misty]

vampke.. you have some missing options..should come after
v_manufacturers_name
i.e
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 EOREOR

[vampke]

vampke.. you have some missing options..should come after
v_manufacturers_name
i.e
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 EOREOR

okay thanks, apparently while trying to redownload the file, they were there!
not sure what happened there...

[gxjenkins]

Is there any way to use EP to change "Always Free Shipping" from no, to yes?

If not, do you know of any other way to update that setting for 4000 items?

Thanks.

[rikko101]

When I upload my tab delimited file to the database, I seem to be losing some of my product names and desciptions. Of the 9000 products that I upload, I'm missing about 2000 name and desciptions. All the rest of the information is there. BOTH the name and description is missing from each product with missing data, not some descriptions here and some names there. Any ideas?

[chadderuski]

Rikko:

A couple things come to mind:

1) you have a strange character in the text file like and escape character or sequence

2) your do not have the eofrec (i don't remember what the right name it off hand) field filled-in in every record. This is a MUST or the program doesn't konw it should move to the next record and will try to stuff everything into one record.

3) possibly an empty field that is not gettig tab delimitted

I made errors myself that related to all three of these. You should make sure your file is of type txt and NOT rtf. You want a plain ascii file.

I have not used the product much yet, but this is my experience to date. Hope this is helpful

[Scrat]

rikko101 - I would think you are trying to upload too many products at once and you are experiencing a time out, as qouted from the Readme.txt in EP...

TIMEOUTS: You may experience timeouts when adding/updating large numbers of products. If you have a large file that times out, you can use the "Split EP File" option. This will create multiple files containing a maximum of 300 records (default - you can change this in Admin). Thus, 1000 products will produce 4 files. These files are created in your /temp/ folder, from where you can upload each in turn after they have been split. If 300 is too many or too few for your circumstances, adjust it in Admin -> Configuration -> "Easy Populate".

gxjenkins - No EP standard will not change "Always Free Shipping" from no, to yes? you could use a SQL statement.

mafiasam - If you upload the Full-EP file with your stock qty in the v_products_quantity field this should update your stock qty.

[gxjenkins]

Thanks, I'll look into constructing a statement to change that setting.

[SirBuck]

Here's my problem..

I have used EP to upload about 3500 products.
When I look in the admin-> Catalog-> Catagories/Products... Its show the correct number of active products. However, when I go in to view them, they aren't there.. They are also not showing up from the user side in the store.

Has anyone run in to this problem before?

thanks,