Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

I am having an issue where whenever I upload my CSV file it seems the v_products_image does not load the link.

 

It takes me to /images/ folder.

 

Any suggestions?

Did you upload your image files via FTP the /catalog/images directory?

If so are premissions correct on them?

 

Did you put references to those images in the v_products_image column?

 

v_products_image

someimage.jpg

otherimage.jpg

prettypicture.jpg

Edited by velvetpixel
Link to comment
Share on other sites

Hello all,

 

I am not so experienced in working with the OSC, but still manage to make it what I intended:)

 

Now I have a problem, I do not know if it is possible through the "Excel populate" and insert the special prices in addition to the ordinary price.

 

I need just to insert following data:

 

Name

Picture

Regular price

Special price

 

Thanks in advance.

 

Boki

Link to comment
Share on other sites

Hey guys,

 

for some reason i have a csv that works but when i use the exact same format i get a weired error on this. an i havent done anything different from any other time should this be reinstalled?

 

here is the error

 

No products_model field in record. This line was not imported: | que Soluti | 05,,,24,1, | SCB | 508,Inacti | 05,,,24,1, | SCB | 510,Inacti | SCB | 511,Inacti | 07,,,24,1, | SCB | 512,Inacti | 02,,,24,1, | SCB | 600,Inacti | 11,,,24,1, | SCB | 601,Inacti | SCB | 602,Inacti | 99,,,24,1, | SCB | 603,Inacti | SCB | 604,Inacti | 10,,,24,1, | SCB | 605,Inacti | 06,,,24,1, | SCB | 606,Inacti | 06,,,24,1, | SCB | 700,Inacti | 05,,,18,1, | SCB | 701,Inacti | 03,,,18,1, | SCB | 800,Inacti | 99,,,18,1, | SCB | 801,Inacti | 00,,,18,1, | SCB | 802,Inacti | 00,,,18,1, | SCB | 803,Inacti | 05,,,18,1, | SCB | 804,Inacti | 11,,,18,1, | SCB | 900,Inacti | 11",,,24,1 | SCB | 901,Inacti | 11,,,24,1, | SH | 001,Inacti | SR | 012,Inacti | 07,,,199,2 | SR | 012F,Inact | 07,,,112,3 | SR | 012R,Inact | 07,,,112,1 | SS | 001,Inacti | 11,,,99,2, | SS | 002,Inacti | 08,,,90,2, | SS | 003,Inacti | 11,,,90,2, | SS | 004,Inacti | 2009,,,90, | SS | 005,Inacti | 11,,,99,2, | SS | 006,Inacti | 11,,,99,2, | SS | 007,Inacti | 11,,,117,2 | SS | 008,Inacti | 11,,,117,2 | SS | 009,Inacti | 11,,,99,2, | SS | 010,Inacti | 07,,,72,2, | SS | 011,Inacti | 2001 Impre | SS | 012,Inacti | IX 2001 | 2006,,,99, | SS | 013,Inacti | 2007,,,99, | SS | 014,Inacti | 08,,,99,2, | SS | 015,Inacti | SS | 016,Inacti | SS | 017,Inacti | 2008,,,31, | SSBB | 017,Inacti | 2008,,,45, | SSK | 001,Inacti | 11,,,143,1 | SU | 006,Inacti | SU | 011,Inacti | SU | 012,Inacti | 2011 WRX / | 2009 Legac | SU | 0124,Inact | 11,,,29,1, | SU | 0125,Inact | 11,,,36,2, | SU | 012L,Inact | 2011 WRX / | 2009 Legac | SU | 015,Inacti | 2007 Impre | SU | 0154,Inact | SU | 015L,Inact | 2007 Impre | SU | 111,Inacti | SU | 123,Inacti | 2011,,,436 | SU | 200,Inacti | 11,,,202,4 | SU | 250,Inacti | 2011,,,364 | SU | 300,Inacti | 2011,,,162 | SU | 500,Inacti | 2011 WRX), | SU | 501,Inacti | SU | 502,Inacti | SU | 503,Inacti | SU | 504,Inacti | SU | 507,Inacti | SU | 600,Inacti | 2007 , For | 08",,,35,1 | SU | 666,Inacti | 11,,,27,1, | SU | DSB,Inacti | SU | PSK,Inacti | 2007, Suba | 2007",,,31 | SU | PSK2,Inact | 2011,,,31, | SU | Rear,Inact | 2011 WRX / | TC | 001,Inacti | 10,,,117,1 | TC | 002,Inacti | 12,,,117,3 | TM | 350,Inacti | 2009 Nissa | UNI | 001,Inacti | UNI | 002,Inacti | UNI | 003,Inacti | UNI | 004,Inacti | UNI | 005,Inacti | XB | 002,Inacti | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

Link to comment
Share on other sites

Hey guys,

 

for some reason i have a csv that works but when i use the exact same format i get a weired error on this. an i havent done anything different from any other time should this be reinstalled?

 

here is the error

 

No products_model field in record. This line was not imported: | que Soluti | 05,,,24,1, | SCB | 508,Inacti | 05,,,24,1, | SCB | 510,Inacti | SCB | 511,Inacti | 07,,,24,1, | SCB | 512,Inacti | 02,,,24,1, | SCB | 600,Inacti | 11,,,24,1, | SCB | 601,Inacti | SCB | 602,Inacti | 99,,,24,1, | SCB | 603,Inacti | SCB | 604,Inacti | 10,,,24,1, | SCB | 605,Inacti | 06,,,24,1, | SCB | 606,Inacti | 06,,,24,1, | SCB | 700,Inacti | 05,,,18,1, | SCB | 701,Inacti | 03,,,18,1, | SCB | 800,Inacti | 99,,,18,1, | SCB | 801,Inacti | 00,,,18,1, | SCB | 802,Inacti | 00,,,18,1, | SCB | 803,Inacti | 05,,,18,1, | SCB | 804,Inacti | 11,,,18,1, | SCB | 900,Inacti | 11",,,24,1 | SCB | 901,Inacti | 11,,,24,1, | SH | 001,Inacti | SR | 012,Inacti | 07,,,199,2 | SR | 012F,Inact | 07,,,112,3 | SR | 012R,Inact | 07,,,112,1 | SS | 001,Inacti | 11,,,99,2, | SS | 002,Inacti | 08,,,90,2, | SS | 003,Inacti | 11,,,90,2, | SS | 004,Inacti | 2009,,,90, | SS | 005,Inacti | 11,,,99,2, | SS | 006,Inacti | 11,,,99,2, | SS | 007,Inacti | 11,,,117,2 | SS | 008,Inacti | 11,,,117,2 | SS | 009,Inacti | 11,,,99,2, | SS | 010,Inacti | 07,,,72,2, | SS | 011,Inacti | 2001 Impre | SS | 012,Inacti | IX 2001 | 2006,,,99, | SS | 013,Inacti | 2007,,,99, | SS | 014,Inacti | 08,,,99,2, | SS | 015,Inacti | SS | 016,Inacti | SS | 017,Inacti | 2008,,,31, | SSBB | 017,Inacti | 2008,,,45, | SSK | 001,Inacti | 11,,,143,1 | SU | 006,Inacti | SU | 011,Inacti | SU | 012,Inacti | 2011 WRX / | 2009 Legac | SU | 0124,Inact | 11,,,29,1, | SU | 0125,Inact | 11,,,36,2, | SU | 012L,Inact | 2011 WRX / | 2009 Legac | SU | 015,Inacti | 2007 Impre | SU | 0154,Inact | SU | 015L,Inact | 2007 Impre | SU | 111,Inacti | SU | 123,Inacti | 2011,,,436 | SU | 200,Inacti | 11,,,202,4 | SU | 250,Inacti | 2011,,,364 | SU | 300,Inacti | 2011,,,162 | SU | 500,Inacti | 2011 WRX), | SU | 501,Inacti | SU | 502,Inacti | SU | 503,Inacti | SU | 504,Inacti | SU | 507,Inacti | SU | 600,Inacti | 2007 , For | 08",,,35,1 | SU | 666,Inacti | 11,,,27,1, | SU | DSB,Inacti | SU | PSK,Inacti | 2007, Suba | 2007",,,31 | SU | PSK2,Inact | 2011,,,31, | SU | Rear,Inact | 2011 WRX / | TC | 001,Inacti | 10,,,117,1 | TC | 002,Inacti | 12,,,117,3 | TM | 350,Inacti | 2009 Nissa | UNI | 001,Inacti | UNI | 002,Inacti | UNI | 003,Inacti | UNI | 004,Inacti | UNI | 005,Inacti | XB | 002,Inacti | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

 

This indicates the product model field is blank so it cant find which product to update.

 

Check your input file.

 

HTH

 

G

Edited by geoffreywalton

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 ======>>>>>.

Link to comment
Share on other sites

my csv file has the v_product_model field an for some unknown reason it just wont populate, i can build files and an it works jus fine, but when i go to import is jus says that there is No products_model field in record. which makes no sense like there is an issue with permissions or something.

 

here is a link to a a csv file

 

http://workaholicstudios.com/trans/csv.jpg

Link to comment
Share on other sites

Try changing it to v_products_model

 

HTH

 

G

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 ======>>>>>.

Link to comment
Share on other sites

I am having a problem. I have install the EP 2.77a and everything is ok. But when i am trying to create and download the file, when i am open it wjth excel there is only one collumn with everything inside. Is there any way to produce different collumns for every section?

Also same problem with 2.76i_2. I intall it now and have the same problem...

What am i doing wrong?

Edited by apolyshow

One amateur made the Arc, 5.000 pro made the Titanic...

Link to comment
Share on other sites

Hello,

 

 

Regarding V. 2.3 how do you add the 2nd larger image to Easy Populate? I am having the small issue. When I click on the thumbnail the image is huge, the 'fancybox' size is fine.

 

I understand that you need to upload the 2nd same image file to fix this problem, but, what if you have 1000 products. There has to be a way to upload all the 2nd larger images at once than uploading one by one.

 

Please help. Thanks. Here is a link to the exact issue I am referring to on my site:

http://damefatale.co...roducts_id=2507

 

 

Thank you.

Edited by Annisse
Link to comment
Share on other sites

Why not upload all the images directly into catalog/images directory?

 

I'm using Easypopulate 2.77 with OSC 2.3.1 and it works just fine. The only problem seems to be that it does not *delete* any products, only adds and/or updates. I'm fetching my suppliers product catalog (some 8000 items) daily with ftp and several products will have been removed every time. To disable the removed products showing up in the store I created a shell script that sets the value of product_quantity to zero, waits for me to run the EP imports and afterwards changes the product_status to zero for products that have their quantity as 0. Works but is a bit cumbersome.

 

Question: where should I put the database queries if I'd like to EP import processing to do the changes for product_quantity and product_status?

Link to comment
Share on other sites

Anyone??? sorry, so computer iliterate here. I really am stumped why my images are huge when you click on the thumbnail. How do I get the main image to resize? The fancy box window is fine by the way.

 

http://damefatale.com/catalog/product_info.php?products_id=2512

 

I am using OSC 2.3.1

 

 

Thank you!

 

 

Hello,

 

 

Regarding V. 2.3 how do you add the 2nd larger image to Easy Populate? I am having the small issue. When I click on the thumbnail the image is huge, the 'fancybox' size is fine.

 

I understand that you need to upload the 2nd same image file to fix this problem, but, what if you have 1000 products. There has to be a way to upload all the 2nd larger images at once than uploading one by one.

 

Please help. Thanks. Here is a link to the exact issue I am referring to on my site:

http://damefatale.co...roducts_id=2507

 

 

Thank you.

Link to comment
Share on other sites

have successfully install easypopulate 2.77 downloaded a csv file edited it upload it and it didn't work tried again still nothing. then i received some error messages telling me it couldn't upload and install the csv file i edited. error message as follows

 

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to access /home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv in /home/dcsstor1/public_html/shop/admin/easypopulate_functions.php on line 44

File uploaded.

Temporary filename: /tmp/phpGRCzRq

User filename: EP2012Jan16-2311.csv

Size: 513194

 

Warning: file() [function.file]: Unable to access /home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1191

 

Warning: file(/home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv) [function.file]: failed to open stream: No such file or directory in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1191

 

Warning: fopen() [function.fopen]: Unable to access /home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1216

 

Warning: fopen(/home/dcsstor1/public_html/shop/temp/EP2012Jan16-2311.csv) [function.fopen]: failed to open stream: No such file or directory in /home/dcsstor1/public_html/shop/admin/easypopulate.php on line 1216

##Can not open file for reading. Script will terminate.

 

All fixed temp folder in wrong spot.

Doug

Edited by Douglas-John Ramm
Link to comment
Share on other sites

Hi

 

I have download and installed the latest verison of easy Populate on my 2.3.1 site on XAMPP. Everything works except I cannot download under the complete .csv file under the quick links. I can download everything else (including the attributes fields)

 

Having said that, I can download a complete table under Export EP or Froogle Products File which is weird as surely thats the same thing. I have gone through all the php.ini settings:

 

max_execution_time = 300

max_input_time = 200

post_max_size = 4M

upload_max_filesize = 8M

memory_limit = 500M

session.gc_maxlifetime = 1400

 

and the easypopulate settings (attached). Please could anyone shed some light?

easypopulate.php

Debbie Harrison

 

Link to comment
Share on other sites

Also while I have your attention, I have a separate issue with the product images being fullsize on the product page. I have read in previous threads that this can be resolved using Easy Populate but on looking at the suggested contribution in the Support documentation http://addons.oscommerce.com/info/1032 I realise its only for 2.2. Is there a version for 2.3.1 or even another way to get my main images to resize?

 

Or can it still be used?

 

Please advise.

Edited by dvharrison

Debbie Harrison

 

Link to comment
Share on other sites

i'm not sure if this has been answered, but...how do i get the category images to display...all I'm seeling in the view source is /images...no picture even though I specified the correct path to the image. I'm trying to figure out what $categories['categories_image'] is defined as...help?

Link to comment
Share on other sites

Geoff

 

Have you uploaded the image to the images directory?

 

What did you actually put in the import file and what was the name of the column you put it in?

 

G

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 ======>>>>>.

Link to comment
Share on other sites

Not happy with this easy populate it will not upload the file propely if at all and if it dose it screws with the data base now i have read some of this tread but can not find a fix for this problem any help would be great.

 

Doug

 

If you are using a Mac make sure you are saving yoru CSV file in windows format.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...