Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Easy popu?ate


Recommended Posts

when i click Download Complete tab-delimited .txt file to edit

i get this error




1054 - Unknown column 'p.products_master' in 'field list'


SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_master as v_products_master, p.products_master_status as v_products_master_status, p.products_listing_status as v_products_listing_status, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id



Link to comment
Share on other sites

found out that i was working with a wrong version

fixed that problem

But still problems

When i try anything to download to the temp dir ( that is chmod to 777)

i get this error


Warning: fopen(/home/tfhbe/public_html/shop/catalog//catalog/temp/EP2004apr24-1402.txt): failed to open stream: No such file or directory in /home/tfhbe/public_html/shop/catalog/admin/easypopulate.php on line 597


Warning: fwrite(): supplied argument is not a valid stream resource in /home/tfhbe/public_html/shop/catalog/admin/easypopulate.php on line 598


Warning: fclose(): supplied argument is not a valid stream resource in /home/tfhbe/public_html/shop/catalog/admin/easypopulate.php on line 599

You can get your file in the Tools/Files under /catalog/temp/EPEP2004apr24-1402.txt

Link to comment
Share on other sites

if you repost this into the main easy populate thread then it would probably get an answer.


posting outside of the threads makes it hard for those of us who have it bookmarked.


i know you have to search for it, but well worth it to read all the errors people have posted, you will find the majority of your answers

Link to comment
Share on other sites

have you the correct path to the temp folder that you are using. looks like the wrong path may be the issue check what is in easypopulate.php I have used the directory easypopulate for one of mine and so this is in easypopulate.php


$tempdir = "easypopulate/";

$tempdir2 = "easypopulate/";

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

i have it working now

but i don't thrust it

i edit the txt file that it makes in excell

but the file seems to get smaller in bytes everytime i edit it

The products i added does not seems to appear on the counter in the main catalog

it screws up the dates that the products are added

When i add 67 new products there seems only about 20 to get in the database

do i do something wrong


I don't want to loose any of the products that ive added manualy


any hints

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.

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