Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

Hi! I had an earlier version of EP installed and now I installed 2.76g.

Before and now too, I can't download the complete .csv file to edit. I did it a couple of times - I don't know how and why, I suppose because I did it at night, but now I can't at all - I get an error: Internet Explorer cannot display the webpage and that's it.

I have about 600 products and the details for EP are these:

 

EP vers: 2.76g-MS2

osCommerce 2.2-MS2

OS: Linux 2.6.12-1.1381_FC3smp

HTTP: Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2635

DB: MySQL 4.1.22-standard-log

PHP: 4.3.11 (Zend: 1.3.0)

 

Temp Directory:

/home/*****/public_html/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 300 records

Model Num Size: 16

Price with tax: true

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

Why isn't it working?

 

Thank you.


My Tiny Contribution - Romanian Buttons

Share this post


Link to post
Share on other sites
why, is this something that's been tried already, from that contribution? it already has an entry in the db in the products_attributes category, "options_values_weight" ..same place you get options_value_price and options_value_id. I'll mess around with it over the weekend...

I don't know of any that have tried it.

Share this post


Link to post
Share on other sites
how do you submit to google base?

It gives .csv. but.txt or .xml is required

please use a google base contrib. it is not correct in EP and will not be supported in the future.

Share this post


Link to post
Share on other sites

Hi. I managed this morning to download a custom .csv file, but I can't open it completely with Excel - it doesn't totally load. How do I solve this? I'm sure it's answered somewhere, but I can't find the solution.

 

Thanks.


My Tiny Contribution - Romanian Buttons

Share this post


Link to post
Share on other sites
Hi. I managed this morning to download a custom .csv file, but I can't open it completely with Excel - it doesn't totally load. How do I solve this? I'm sure it's answered somewhere, but I can't find the solution.

 

Thanks.

 

Can I look at the file?

Can you download partial files using the category/manufacturer filters I added?

Share this post


Link to post
Share on other sites

I am getting the following error message at the top when I try to upload my file back to my db.

 

Filename: EP2008Jun03-12124.csv

 

Warning: Invalid argument supplied for foreach() in /home/melsfire/public_html/catalog/admin/easypopulate.php on line 1185

 

Does anyone know more about this message?

Share this post


Link to post
Share on other sites

I managed this morning to download a complete csv file - I didn't use the category or manufacturer filter.

When I try to open the file with Excel I get this error :

 

"File not loaded completely"

"This error is usually encountered when an attempt to open a file with more than 65,536 rows or 256 columns is made. Excel is limited to 65,536 rows of data and 256 columns per worksheet. You can have many worksheets with this number of rows and columns, but they are usually capable of fitting into one workbook (file).  The number of worksheets you can have per workbook is limited only by the amount of available memory your system has. By default, Excel can manage 3 worksheets, more if there is available memory to support the quantity of data.

Truncation of rows or columns in excess of the limit is automatic and is not configurable. This issue can usually be remedied by opening the source file with a text editor, such as Microsoft Office Word, and then saving the file off into multiple files with row or column counts within the limits of an Excel worksheet. These files can then be opened or imported into Excel worksheets.

If you are using a data format that does not support use of a text editor, it may be easier to import the data into Microsoft Office Access and then use the export feature of Access to import the data to an Excel format. Other methods of importing large source material into multiple worksheets are available, but may be more complex than using either a text editor or Access."

 

But now, although I get this error the file loads completly and I can use it to upload data in another osc shop. I have no idea why yesterday it wasn't ok and now it is almost ok.... (if I had more attributes - more columns, the data wouldn't fit , because the Excel workshet suddenly ends somewhere on the right).

 

I still have a problem or two:

- On some rows the product description is messed up, actually the formatting: <FONT face='\"arial,' size=2 sans-serif\? helvetica,> and it gives an error when uploading. This is for about 20 prodcts out of 600. If I manually look for errors like this and correct them it's ok when uploading.

- For some products data appears not on one row, but on two, product_model ok, product_name ok, but then product description on two rows, in the columns for other data. Hard to explain...

 

I'd show you the file, how do I do that?

 

Anyway, with all the problems I have, this is a great contribution, it helps me a lot and I have to say a biiig Thank you! for it.


My Tiny Contribution - Romanian Buttons

Share this post


Link to post
Share on other sites
I managed this morning to download a complete csv file - I didn't use the category or manufacturer filter.

When I try to open the file with Excel I get this error :

 

"File not loaded completely"

"This error is usually encountered when an attempt to open a file with more than 65,536 rows or 256 columns is made. Excel is limited to 65,536 rows of data and 256 columns per worksheet. You can have many worksheets with this number of rows and columns, but they are usually capable of fitting into one workbook (file). The number of worksheets you can have per workbook is limited only by the amount of available memory your system has. By default, Excel can manage 3 worksheets, more if there is available memory to support the quantity of data.

Truncation of rows or columns in excess of the limit is automatic and is not configurable. This issue can usually be remedied by opening the source file with a text editor, such as Microsoft Office Word, and then saving the file off into multiple files with row or column counts within the limits of an Excel worksheet. These files can then be opened or imported into Excel worksheets.

If you are using a data format that does not support use of a text editor, it may be easier to import the data into Microsoft Office Access and then use the export feature of Access to import the data to an Excel format. Other methods of importing large source material into multiple worksheets are available, but may be more complex than using either a text editor or Access."

 

But now, although I get this error the file loads completly and I can use it to upload data in another osc shop. I have no idea why yesterday it wasn't ok and now it is almost ok.... (if I had more attributes - more columns, the data wouldn't fit , because the Excel workshet suddenly ends somewhere on the right).

 

I still have a problem or two:

- On some rows the product description is messed up, actually the formatting: <FONT face='\"arial,' size=2 sans-serif\? helvetica,> and it gives an error when uploading. This is for about 20 prodcts out of 600. If I manually look for errors like this and correct them it's ok when uploading.

- For some products data appears not on one row, but on two, product_model ok, product_name ok, but then product description on two rows, in the columns for other data. Hard to explain...

 

I'd show you the file, how do I do that?

 

Anyway, with all the problems I have, this is a great contribution, it helps me a lot and I have to say a biiig Thank you! for it.

What version of Office are you using?

 

no need to see the file, you told me what I needed to know. MS Office 2007 (and maybe Open Office) doesn't have the column limit. If you open the file like you have, and resave it, you may loose data.

 

If you see a description wrap down to a second row, that is OK. It means there is a [RETURN] embedded in the description. That version of EP should handle that, and it should not affect the import.

 

I have to say, I am a little surprised that some HTML is causing problems on the import. It may have something to do with country specific settings and your office. I would like see is a small portion of the export that contains the description causing the problem. You can put the file on your web-space and post or PM me the link to it.

Share this post


Link to post
Share on other sites
I am getting the following error message at the top when I try to upload my file back to my db.

 

Filename: EP2008Jun03-12124.csv

 

Warning: Invalid argument supplied for foreach() in /home/melsfire/public_html/catalog/admin/easypopulate.php on line 1185

 

Does anyone know more about this message?

 

welcome to the forums Jason. When posting a problem, you need to provide much more information for someone to help you. Info like the version of EP you are using, the PHP version, the EP settings you are using, and a sample of the file you are importing. The versions of EP I have uploaded have a section in the Docs called Support. It has instructions about how to ask for help. Also, be sure to read through the forum rules (link at top of page). It also has tips on how to organize a post that will generate a response.

Share this post


Link to post
Share on other sites

I am sure this has been answered but the search function is pulling up tons of links to everywhere but on this thread. If you are running the latest version of oscom, which version should i be using? Also im assuming this is the contrib i need in the first place. i am trying to lower a portion of my products price by 5% in one shot rather then doing them one by one, Is EP going to help me do that?

Share this post


Link to post
Share on other sites
I don't know of any that have tried it.

Well, now you can say you don't know of anyone that's tried it successfully :D . I do believe it can be done easily though...just not by me. I was trying to replicate the options_values_price into weight, which I do believe is the key, but there were too many other variables that I don't understand enough, messing me up.

I found someone from 2005 that says it would be easy to do, so I sent her a line, no response. probably moved on in life.

Too bad, it's really a valuable contribution that would be awesome to have work with this.

Oh well, Thanks.

Share this post


Link to post
Share on other sites
I am sure this has been answered but the search function is pulling up tons of links to everywhere but on this thread. If you are running the latest version of oscom, which version should i be using? Also im assuming this is the contrib i need in the first place. i am trying to lower a portion of my products price by 5% in one shot rather then doing them one by one, Is EP going to help me do that?

 

Chris

 

You would have to download your entire product range into a file using EP.

 

Then use a package such as excel to increse the price.

 

Then upload the file.

 

Another way is to use mysql to UPDATE the price field of every record by 5%.

 

www.w3schools.com has a good primer on mysql.


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites
Chris

 

You would have to download your entire product range into a file using EP.

 

Then use a package such as excel to increse the price.

 

Then upload the file.

 

Another way is to use mysql to UPDATE the price field of every record by 5%.

 

www.w3schools.com has a good primer on mysql.

I have been told about using my sql but i am a bit scared to try that, haha. Which version of EP should i get for php 4/mysql 4/ RC2a?

Share this post


Link to post
Share on other sites

I've just uploaded some products using Easy Populate and now have the letters thth appearing at the top left of some pages, can anyone tell me why. Here is the data I input:

 

v_products_model v_products_name_1 v_products_description_1 v_products_url_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_3 v_products_description_3 v_products_url_3 v_products_image v_products_price v_products_quantity v_products_weight v_date_avail v_date_added v_categories_image_1 v_categories_name_1_1 v_categories_name_1_2 v_categories_name_1_3 v_categories_image_2 v_categories_name_2_1 v_categories_name_2_2 v_categories_name_2_3 v_categories_image_3 v_categories_name_3_1 v_categories_name_3_2 v_categories_name_3_3 v_categories_image_4 v_categories_name_4_1 v_categories_name_4_2 v_categories_name_4_3 v_categories_image_5 v_categories_name_5_1 v_categories_name_5_2 v_categories_name_5_3 v_categories_image_6 v_categories_name_6_1 v_categories_name_6_2 v_categories_name_6_3 v_categories_image_7 v_categories_name_7_1 v_categories_name_7_2 v_categories_name_7_3 v_manufacturers_name v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_name_1_2 v_attribute_options_name_1_3 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_options_name_2_2 v_attribute_options_name_2_3 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_options_name_3_2 v_attribute_options_name_3_3 v_attribute_values_id_3_1 v_attribute_values_name_3_1_1 v_attribute_values_name_3_1_2 v_attribute_values_name_3_1_3 v_attribute_values_price_3_1 v_attribute_values_id_3_2 v_attribute_values_name_3_2_1 v_attribute_values_name_3_2_2 v_attribute_values_name_3_2_3 v_attribute_values_price_3_2 v_attribute_values_id_3_3 v_attribute_values_name_3_3_1 v_attribute_values_name_3_3_2 v_attribute_values_name_3_3_3 v_attribute_values_price_3_3 v_attribute_values_id_3_4 v_attribute_values_name_3_4_1 v_attribute_values_name_3_4_2 v_attribute_values_name_3_4_3 v_attribute_values_price_3_4 v_attribute_values_id_3_5 v_attribute_values_name_3_5_1 v_attribute_values_name_3_5_2 v_attribute_values_name_3_5_3 v_attribute_values_price_3_5 v_attribute_options_id_4 v_attribute_options_name_4_1 v_attribute_options_name_4_2 v_attribute_options_name_4_3 v_attribute_values_id_4_1 v_attribute_values_name_4_1_1 v_attribute_values_name_4_1_2 v_attribute_values_name_4_1_3 v_attribute_values_price_4_1 v_attribute_values_id_4_2 v_attribute_values_name_4_2_1 v_attribute_values_name_4_2_2 v_attribute_values_name_4_2_3 v_attribute_values_price_4_2 v_attribute_values_id_4_3 v_attribute_values_name_4_3_1 v_attribute_values_name_4_3_2 v_attribute_values_name_4_3_3 v_attribute_values_price_4_3 v_attribute_values_id_4_4 v_attribute_values_name_4_4_1 v_attribute_values_name_4_4_2 v_attribute_values_name_4_4_3 v_attribute_values_price_4_4 v_attribute_options_id_5 v_attribute_options_name_5_1 v_attribute_options_name_5_2 v_attribute_options_name_5_3 v_attribute_values_id_5_1 v_attribute_values_name_5_1_1 v_attribute_values_name_5_1_2 v_attribute_values_name_5_1_3 v_attribute_values_price_5_1 v_attribute_values_id_5_2 v_attribute_values_name_5_2_1 v_attribute_values_name_5_2_2 v_attribute_values_name_5_2_3 v_attribute_values_price_5_2 v_tax_class_title v_status EOREOR

981035 ARCHERS AQUA PEACH. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR

737447 ARCHERS AQUA PEACH. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR

981848 ARCHERS AQUA RASBERRY. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR

737546 ARCHERS AQUA RASPBERRY. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR

783510 CARIBBEAN TWIST MANGO/PASSION FRUIT. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR

110875 CARIBBEAN TWIST PARADISE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR

714594 CARIBBEAN TWIST PINEAPPLE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR

23515 FAT FROG. 24 x 275ML 31.60 Alcopops FAT FROG EOREOR

23494 FAT FROG. 1 x 70CL 3.42 Alcopops FAT FROG EOREOR

65643 MOJITO BLUE. 24 x 275ML 32.09 Alcopops MOJITO EOREOR

65708 MOJITO RED. 24 x 275ML 32.09 Alcopops MOJITO EOREOR

735739 RED SQUARE BLUE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

543516 RED SQUARE CHERRY ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

729734 RED SQUARE GREEN ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

722746 RED SQUARE PINK ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

713289 RED SQUARE RELOADED. 12 x 275ML 14.86 Alcopops RED SQUARE EOREOR

717638 RED SQUARE RELOADED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR

110787 RED SQUARE RELOADED BLUE. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR

717836 RED SQUARE WHITE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

534345 REDSQUARE RELOAD JUICED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR

738312 RED STAR BLUE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

749433 RED STAR LEMON. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

744416 RED STAR LIME. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

749136 RED STAR ORANGE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

574974 REEF ORANGE & PASSION FRUIT. 24 x 275ML 30.30 Alcopops REEF EOREOR

495756 BACARDI BREEZER BLUEBERRY HALF SUGAR. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

689719 BACARDI BREEZER BLUEBERRY HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

973355 BACARDI BREEZER COCONUT. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

973278 BACARDI BREEZER COCONUT 4PACK. 6 x 275ML 13.00 Alcopops RON BACARDI EOREOR

567543 BACARDI BREEZER LIME. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

567499 BACARDI BREEZER ORANGE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

744625 BACARDI BREEZER ORANGE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

567576 BACARDI BREEZER PINEAPPLE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

738345 BACARDI BREEZER PINEAPPLE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

518930 BACARDI BREEZER POMEGRANATE HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

568386 BACARDI BREEZER WATERMELON. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

738280 BACARDI BREEZER WATERMELON. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

718569 SHOT IN A TUBE . 72 x 55.78 Alcopops SHOOTERS EOREOR

268130 SIDEKICK TROPICAL FRUIT. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR

438650 SIDEKICK CHOCOLATE MINT 14.5%. 1 x 35CL 5.62 Alcopops SIDEKICK EOREOR

665661 SIDEKICK MIX CREAM 4PK. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR

712633 BOTTLES ICE. 24 x 275ml 36.44 Alcopops SMIRNOFF EOREOR

730482 SMIRNOFF BLACK ICE. 24 x 275ML 38.11 Alcopops SMIRNOFF EOREOR

919535 SMIRNOFF BLACK ICE. 1 x 70CL 3.92 Alcopops SMIRNOFF EOREOR

729592 SMIRNOFF ICE. 1 x 70CL 3.33 Alcopops SMIRNOFF EOREOR

240480 SMIRNOFF ICE PET. 24 x 275ML 36.25 Alcopops SMIRNOFF EOREOR

559544 SMIRNOFF ICE 6 FOR 4 PACK . 4 x 275ML 30.67 Alcopops SMIRNOFF EOREOR

280262 SMIRNOFF ICE P.E.T.. 24 x 275ML 37.18 Alcopops SMIRNOFF EOREOR

479022 SMIRNOFF ICE P.M 2.99 OR 2 FOR 5.00. 1 x 70CL 3.22 Alcopops SMIRNOFF EOREOR

979380 SMIRNOFF RED ICE 4PACK. 6 x 250ML 33.46 Alcopops SMIRNOFF EOREOR

978262 VS VODKA SORTED APPLE&KIWI. 1 x 70CL 2.18 Alcopops VS EOREOR

736187 VS VODKA SORTED BLUE. 12 x 275ML 9.28 Alcopops VS EOREOR

728946 VS VODKA SORTED BLUE. 1 x 70CL 2.18 Alcopops VS EOREOR

736275 VS VODKA SORTED IRN BRU. 12 x 275ML 9.28 Alcopops VS EOREOR

720830 VS VODKA SORTED IRON BREW. 1 x 70CL 2.18 Alcopops VS EOREOR

736121 VS VODKA SORTED LEMON. 12 x 275ML 9.28 Alcopops VS EOREOR

721222 VS VODKA SORTED LEMON. 1 x 70CL 2.18 Alcopops VS EOREOR

978273 VS VODKA SORTED TROPICAL ORANGE. 12 x 275ML 9.28 Alcopops VS EOREOR

978284 VS VODKA SORTED TROPICAL ORANGE. 1 x 70CL 2.18 Alcopops VS EOREOR

735937 VS VODKA SORTED WATERMELON. 12 x 275ML 9.28 Alcopops VS EOREOR

721475 VS VODKA SORTED WATERMELON. 1 x 70CL 2.18 Alcopops VS EOREOR

748272 BOTTLES BLUE . 1 x 275ml 3.94 Alcopops WKD EOREOR

744933 BOTTLES BLUE 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR

745084 BOTTLES IRON BREW 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR

830416 BOTTLES RED . 1 x 275ml 3.94 Alcopops WKD EOREOR

122629 BOTTLES RED 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR

744944 WKD BLUE 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR

748128 WKD BLUE 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR

569668 WKD IRON BREW. 12 x 275ML 18.58 Alcopops WKD EOREOR

744834 WKD IRON BREW 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR

747990 WKD IRON BREW 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR

748173 WKD IRON BREW 5%. 1 x 70CL 3.94 Alcopops WKD EOREOR

829362 WKD RED. 12 x 275ML 19.88 Alcopops WKD EOREOR

829999 WKD RED 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR

Share this post


Link to post
Share on other sites

i used Easy Populate 2.76g-MS2 (with attributes) from surfalot and using the new_field_everywhere contrib to add 3 extra fields author, isbn, and binding/publisher.

 

everthing working fine except one important function: the search function: I CANNOT SEARCH ON ANY OF THE 3 EXTRA FIELDS ADDED.

 

What is the issue? :(

 

 

Laurent

Share this post


Link to post
Share on other sites

The extra fields are not in the search.

 

How can the existing search code know which fields everyone who has added the contribution is using?

 

Guess you need to hack the code to do this or get someone to do it for you.


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites
i used Easy Populate 2.76g-MS2 (with attributes) from surfalot and using the new_field_everywhere contrib to add 3 extra fields author, isbn, and binding/publisher.

 

everthing working fine except one important function: the search function: I CANNOT SEARCH ON ANY OF THE 3 EXTRA FIELDS ADDED.

 

What is the issue? :(

I would wonder why you are asking about support for the contrib new_field_everywhere in the Easy Populate topic.

Share this post


Link to post
Share on other sites
I've just uploaded some products using Easy Populate and now have the letters thth appearing at the top left of some pages, can anyone tell me why. Here is the data I input:

 

v_products_model v_products_name_1 v_products_description_1 v_products_url_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_3 v_products_description_3 v_products_url_3 v_products_image v_products_price v_products_quantity v_products_weight v_date_avail v_date_added v_categories_image_1 v_categories_name_1_1 v_categories_name_1_2 v_categories_name_1_3 v_categories_image_2 v_categories_name_2_1 v_categories_name_2_2 v_categories_name_2_3 v_categories_image_3 v_categories_name_3_1 v_categories_name_3_2 v_categories_name_3_3 v_categories_image_4 v_categories_name_4_1 v_categories_name_4_2 v_categories_name_4_3 v_categories_image_5 v_categories_name_5_1 v_categories_name_5_2 v_categories_name_5_3 v_categories_image_6 v_categories_name_6_1 v_categories_name_6_2 v_categories_name_6_3 v_categories_image_7 v_categories_name_7_1 v_categories_name_7_2 v_categories_name_7_3 v_manufacturers_name v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_name_1_2 v_attribute_options_name_1_3 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_options_name_2_2 v_attribute_options_name_2_3 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_options_name_3_2 v_attribute_options_name_3_3 v_attribute_values_id_3_1 v_attribute_values_name_3_1_1 v_attribute_values_name_3_1_2 v_attribute_values_name_3_1_3 v_attribute_values_price_3_1 v_attribute_values_id_3_2 v_attribute_values_name_3_2_1 v_attribute_values_name_3_2_2 v_attribute_values_name_3_2_3 v_attribute_values_price_3_2 v_attribute_values_id_3_3 v_attribute_values_name_3_3_1 v_attribute_values_name_3_3_2 v_attribute_values_name_3_3_3 v_attribute_values_price_3_3 v_attribute_values_id_3_4 v_attribute_values_name_3_4_1 v_attribute_values_name_3_4_2 v_attribute_values_name_3_4_3 v_attribute_values_price_3_4 v_attribute_values_id_3_5 v_attribute_values_name_3_5_1 v_attribute_values_name_3_5_2 v_attribute_values_name_3_5_3 v_attribute_values_price_3_5 v_attribute_options_id_4 v_attribute_options_name_4_1 v_attribute_options_name_4_2 v_attribute_options_name_4_3 v_attribute_values_id_4_1 v_attribute_values_name_4_1_1 v_attribute_values_name_4_1_2 v_attribute_values_name_4_1_3 v_attribute_values_price_4_1 v_attribute_values_id_4_2 v_attribute_values_name_4_2_1 v_attribute_values_name_4_2_2 v_attribute_values_name_4_2_3 v_attribute_values_price_4_2 v_attribute_values_id_4_3 v_attribute_values_name_4_3_1 v_attribute_values_name_4_3_2 v_attribute_values_name_4_3_3 v_attribute_values_price_4_3 v_attribute_values_id_4_4 v_attribute_values_name_4_4_1 v_attribute_values_name_4_4_2 v_attribute_values_name_4_4_3 v_attribute_values_price_4_4 v_attribute_options_id_5 v_attribute_options_name_5_1 v_attribute_options_name_5_2 v_attribute_options_name_5_3 v_attribute_values_id_5_1 v_attribute_values_name_5_1_1 v_attribute_values_name_5_1_2 v_attribute_values_name_5_1_3 v_attribute_values_price_5_1 v_attribute_values_id_5_2 v_attribute_values_name_5_2_1 v_attribute_values_name_5_2_2 v_attribute_values_name_5_2_3 v_attribute_values_price_5_2 v_tax_class_title v_status EOREOR

981035 ARCHERS AQUA PEACH. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR

737447 ARCHERS AQUA PEACH. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR

981848 ARCHERS AQUA RASBERRY. 12 x 275ML 18.58 Alcopops ARCHERS EOREOR

737546 ARCHERS AQUA RASPBERRY. 1 x 70CL 3.94 Alcopops ARCHERS EOREOR

783510 CARIBBEAN TWIST MANGO/PASSION FRUIT. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR

110875 CARIBBEAN TWIST PARADISE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR

714594 CARIBBEAN TWIST PINEAPPLE. 1 x 70CL 3.18 Alcopops CARIBBEAN TWIST EOREOR

23515 FAT FROG. 24 x 275ML 31.60 Alcopops FAT FROG EOREOR

23494 FAT FROG. 1 x 70CL 3.42 Alcopops FAT FROG EOREOR

65643 MOJITO BLUE. 24 x 275ML 32.09 Alcopops MOJITO EOREOR

65708 MOJITO RED. 24 x 275ML 32.09 Alcopops MOJITO EOREOR

735739 RED SQUARE BLUE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

543516 RED SQUARE CHERRY ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

729734 RED SQUARE GREEN ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

722746 RED SQUARE PINK ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

713289 RED SQUARE RELOADED. 12 x 275ML 14.86 Alcopops RED SQUARE EOREOR

717638 RED SQUARE RELOADED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR

110787 RED SQUARE RELOADED BLUE. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR

717836 RED SQUARE WHITE ICE. 1 x 70CL 3.01 Alcopops RED SQUARE EOREOR

534345 REDSQUARE RELOAD JUICED. 1 x 70CL 3.42 Alcopops RED SQUARE EOREOR

738312 RED STAR BLUE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

749433 RED STAR LEMON. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

744416 RED STAR LIME. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

749136 RED STAR ORANGE. 12 x 275ML 9.02 Alcopops RED STAR EOREOR

574974 REEF ORANGE & PASSION FRUIT. 24 x 275ML 30.30 Alcopops REEF EOREOR

495756 BACARDI BREEZER BLUEBERRY HALF SUGAR. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

689719 BACARDI BREEZER BLUEBERRY HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

973355 BACARDI BREEZER COCONUT. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

973278 BACARDI BREEZER COCONUT 4PACK. 6 x 275ML 13.00 Alcopops RON BACARDI EOREOR

567543 BACARDI BREEZER LIME. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

567499 BACARDI BREEZER ORANGE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

744625 BACARDI BREEZER ORANGE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

567576 BACARDI BREEZER PINEAPPLE. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

738345 BACARDI BREEZER PINEAPPLE. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

518930 BACARDI BREEZER POMEGRANATE HALF SUGAR. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

568386 BACARDI BREEZER WATERMELON. 24 x 275ML 34.39 Alcopops RON BACARDI EOREOR

738280 BACARDI BREEZER WATERMELON. 1 x 70CL 3.65 Alcopops RON BACARDI EOREOR

718569 SHOT IN A TUBE . 72 x 55.78 Alcopops SHOOTERS EOREOR

268130 SIDEKICK TROPICAL FRUIT. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR

438650 SIDEKICK CHOCOLATE MINT 14.5%. 1 x 35CL 5.62 Alcopops SIDEKICK EOREOR

665661 SIDEKICK MIX CREAM 4PK. 6 x 3CL 18.21 Alcopops SIDEKICK EOREOR

712633 BOTTLES ICE. 24 x 275ml 36.44 Alcopops SMIRNOFF EOREOR

730482 SMIRNOFF BLACK ICE. 24 x 275ML 38.11 Alcopops SMIRNOFF EOREOR

919535 SMIRNOFF BLACK ICE. 1 x 70CL 3.92 Alcopops SMIRNOFF EOREOR

729592 SMIRNOFF ICE. 1 x 70CL 3.33 Alcopops SMIRNOFF EOREOR

240480 SMIRNOFF ICE PET. 24 x 275ML 36.25 Alcopops SMIRNOFF EOREOR

559544 SMIRNOFF ICE 6 FOR 4 PACK . 4 x 275ML 30.67 Alcopops SMIRNOFF EOREOR

280262 SMIRNOFF ICE P.E.T.. 24 x 275ML 37.18 Alcopops SMIRNOFF EOREOR

479022 SMIRNOFF ICE P.M 2.99 OR 2 FOR 5.00. 1 x 70CL 3.22 Alcopops SMIRNOFF EOREOR

979380 SMIRNOFF RED ICE 4PACK. 6 x 250ML 33.46 Alcopops SMIRNOFF EOREOR

978262 VS VODKA SORTED APPLE&KIWI. 1 x 70CL 2.18 Alcopops VS EOREOR

736187 VS VODKA SORTED BLUE. 12 x 275ML 9.28 Alcopops VS EOREOR

728946 VS VODKA SORTED BLUE. 1 x 70CL 2.18 Alcopops VS EOREOR

736275 VS VODKA SORTED IRN BRU. 12 x 275ML 9.28 Alcopops VS EOREOR

720830 VS VODKA SORTED IRON BREW. 1 x 70CL 2.18 Alcopops VS EOREOR

736121 VS VODKA SORTED LEMON. 12 x 275ML 9.28 Alcopops VS EOREOR

721222 VS VODKA SORTED LEMON. 1 x 70CL 2.18 Alcopops VS EOREOR

978273 VS VODKA SORTED TROPICAL ORANGE. 12 x 275ML 9.28 Alcopops VS EOREOR

978284 VS VODKA SORTED TROPICAL ORANGE. 1 x 70CL 2.18 Alcopops VS EOREOR

735937 VS VODKA SORTED WATERMELON. 12 x 275ML 9.28 Alcopops VS EOREOR

721475 VS VODKA SORTED WATERMELON. 1 x 70CL 2.18 Alcopops VS EOREOR

748272 BOTTLES BLUE . 1 x 275ml 3.94 Alcopops WKD EOREOR

744933 BOTTLES BLUE 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR

745084 BOTTLES IRON BREW 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR

830416 BOTTLES RED . 1 x 275ml 3.94 Alcopops WKD EOREOR

122629 BOTTLES RED 12/11. 12 x 275ml 17.58 Alcopops WKD EOREOR

744944 WKD BLUE 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR

748128 WKD BLUE 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR

569668 WKD IRON BREW. 12 x 275ML 18.58 Alcopops WKD EOREOR

744834 WKD IRON BREW 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR

747990 WKD IRON BREW 5%. 12 x 275ML 19.88 Alcopops WKD EOREOR

748173 WKD IRON BREW 5%. 1 x 70CL 3.94 Alcopops WKD EOREOR

829362 WKD RED. 12 x 275ML 19.88 Alcopops WKD EOREOR

829999 WKD RED 4 PACK. 6 x 275ML 35.32 Alcopops WKD EOREOR

When posting a problem, you need to provide much more information for someone to help you. Info like the version of EP you are using, the PHP version, the EP settings you are using, and a sample of the file you are importing. The versions of EP I have uploaded have a section in the Docs called Support. It has instructions about how to ask for help and how to post a useful sample of your data. Also, be sure to read through the forum rules (link at top of page). It also has tips on how to organize a post that will generate a response.

Share this post


Link to post
Share on other sites
Any one know this answer?

v2.76g is the most "fixed". But it is really the contributions you have installed that would make the most impact on the version you choose.

Share this post


Link to post
Share on other sites
v2.76g is the most "fixed". But it is really the contributions you have installed that would make the most impact on the version you choose.

 

are their any known major conflicts? i do not have to many other than to make the shop operate.

Share this post


Link to post
Share on other sites
What version of Office are you using?

 

no need to see the file, you told me what I needed to know. MS Office 2007 (and maybe Open Office) doesn't have the column limit. If you open the file like you have, and resave it, you may loose data.

 

If you see a description wrap down to a second row, that is OK. It means there is a [RETURN] embedded in the description. That version of EP should handle that, and it should not affect the import.

 

I have to say, I am a little surprised that some HTML is causing problems on the import. It may have something to do with country specific settings and your office. I would like see is a small portion of the export that contains the description causing the problem. You can put the file on your web-space and post or PM me the link to it.

 

Thank you for all your help. Indeed, I'm using Office 2003, I guess this is where the problem is coming from. I'll upgrade :)

As for the description on a second row, I'll show exactly how it looks like, I'll send you a PM with a link to a part of the ep file I downloaded. This way, you'll see the html problem problem, too.

 

Thank you so so much.


My Tiny Contribution - Romanian Buttons

Share this post


Link to post
Share on other sites

Hi,

I am using EP for more than year now, Recently I Updated with surflot new EP update.

All ok, just few things I need some help.

 

When I update products and set in Categories for some reason Images are not showing in Website Categories (i.e Images link to categories. Do i have to add IMAGE column for categories in all cateories as Before I was updating categories and not had any effect on category images.

 

Second if I have to delete Product from Date base I think with this new version I can write "delete" in Status and it will delete product but I tried this and product is not deleting ven it shows in ep that product delete updated.

 

Hope someone guide me to right thread or advise.

 

Regards

Thanks

Share this post


Link to post
Share on other sites

Here is a list of the Settings and Info:

Settings & Info

 

EP vers: 2.76g-MS2

osCommerce Online Merchant v2.2 RC2a

OS: Linux 2.6.22-19_1.BHsmp

HTTP: Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8g DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

DB: MySQL 5.0.45-community-log

PHP: 5.2.6 (Zend: 2.2.0)

 

Temp Directory:

/home/melsfire/public_html/catalog/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: off

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

 

When I upload my file back to Easy Populate I get this message at the top of the window:

 

Easy Populate 2.76g-MS2 - Default Language : english(1)

 

Filename: EP2008Jun03-12124.csv

 

Warning: Invalid argument supplied for foreach() in /home/melsfire/public_html/catalog/admin/easypopulate.php on line 1185

 

 

 

I hope this is the information you need, Thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×