TurboNova Posted January 15, 2009 Share Posted January 15, 2009 (edited) I have a store www.efikits.com. We have been uploading products just fine for several months now. My server did some upgrades and I am wondering if this had an effect on the easypopulate mod. I can download the database with EP just fine and when I add something to it and re-upload the database it works also. The problems is when I delete something from the CSV file and send it back to the site it does not delete. I can both add and delete lines and the new products will add but the old products will not delete. We have been both deleting old products and uploading new products this way for months and it has worked just fine. Now it will only add them but not delete them. I can delete them one by one but that will take too long. Anyone have an idea? Edited January 15, 2009 by TurboNova Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 16, 2009 Share Posted January 16, 2009 Set the status to inactive. G Quote 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 More sharing options...
TurboNova Posted January 17, 2009 Author Share Posted January 17, 2009 I looked in the easypopulate.php and the setting is already is set to inactive. I checked that my temp directory is set to chmod 777 and it is now. I still can't upload and delete anything out of the database. Quote Link to comment Share on other sites More sharing options...
TurboNova Posted January 17, 2009 Author Share Posted January 17, 2009 here is an error I just got when trying to Create Complete tab-delimited .txt file in temp dir Warning: fopen(/hsphere/local/home/horsepow/efikits.com//tempEP2009Jan16-1907.txt) [function.fopen]: failed to open stream: Permission denied in /hsphere/local/home/horsepow/efikits.com/admin/easypopulate.php on line 603 Warning: fwrite(): supplied argument is not a valid stream resource in /hsphere/local/home/horsepow/efikits.com/admin/easypopulate.php on line 604 Warning: fclose(): supplied argument is not a valid stream resource in /hsphere/local/home/horsepow/efikits.com/admin/easypopulate.php on line 605 You can get your file in the Tools/Files under /tempEPEP2009Jan16-1907.txt Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 17, 2009 Share Posted January 17, 2009 How is your temp directory defined? Cant remember if it is in easypopulate.php or /admin/includes/configure.php. efikits.com//tempEP2009Jan16-1907.txt Is it /temp? Try temp/ Quote 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 More sharing options...
TurboNova Posted January 20, 2009 Author Share Posted January 20, 2009 Maybe I am just screwed up but wont easy populate also remove things out of the database. So say, I remove all but one product in the category CD's from the excel file then upload it. Shouldn't they not show in the store anymore? Or will Easy Populate just add and edit the database and not remove stuff. Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 20, 2009 Share Posted January 20, 2009 EP will edit the product record or insert it if it is not there in the categories on the record you upload. It is not psychic and can't guess that the one you have in another category needs to be deleted or amended so it just leaves it alone. Try it and see. G Quote 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 More sharing options...
tfbpa Posted February 25, 2009 Share Posted February 25, 2009 it IS possible to delete products from the database by using Easy Populate See easypopulate.php around line 141 // Set the v_status field to "Delete" if you want to remove the item from the system define ('EP_DELETE_IT', 'Delete'); so this means that all the way at the end of the excel file under "v_status" you have to overwrite "Active" with "Delete"! :D Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.