Jump to content

PVK

Members
  • Content count

    256
  • Joined

  • Last visited

Profile Information

  • Real Name
    Patrick
  1. PVK

    Recover Cart Sales

    Pfew, happy i'm not alone with the problem :D , but seriously, anyone who would know how to accomplisch this would be the hero of the day . It would be the icing on the cake of this great contribution!
  2. PVK

    Recover Cart Sales

    PS, would it be an idea to be able to make a choice to skip carts which have been place for a certain couple of days (for instane 30 days) so that the tool would select abandoned carts dating back lobger thatn 30 days. I ask this because my customers place stuff in their carts and wait x amount of days for new items (which come in daily) .Then aftre say 24 days they decide to purchase their cart. It is a bit silly to mail those who only have their carts filled in the last 2 days . Would appear to me (if i was a customer) that i was a bit pushy.
  3. PVK

    Recover Cart Sales

    Hello lane, well i'm sorry but still haven't figured it out yet. i have been busy deleting them manually from the admin side, but it takes ages to load the complete page again when you set the date , say to 500 days, and then when you delete one......well waiting ages again. My result now, is that i have become a coffe addict because of all the waiting :-" and have only deleted a couple of dozen , and i have hundres more to go, so i have stopped doing it this way, since it is crazy to continue like this. I guess i have to ask you (or anyone) friendly to give me my proposed sql querie option for the main cleaning part after which i can use you contribution on a regular base (say every 30 days or so) Please help as i am going :blink: Thanks ( i really love the contrib but can;t make use of it as yet and reaally want it bad :rolleyes: )
  4. PVK

    Recover Cart Sales

    Yes i already know that :-) However i have abandoned carts dating back more than 2 years, so i would be busy for days by deleting them manually with the tool. Therefore i would like to make a selection using phpmyadmin to delete those abandoned carts which are older than say 6 months. But thanks anyway :thumbsup:
  5. PVK

    Recover Cart Sales

    I just installed this great contribution and run it , and i was baffled by the sheer amount of unsold carts. Our shop runs very good, but still it is great to find our why some customers never finish the transaction. I have a question though. I want to mail those with unsold carts, but it is a bit silly to mail customers who still have items in their cart from say 1 year or longer ago. Does anyone know what sql commando i can do to clear all unsold carts longer than 6 months ago? (I will than be able to mail all those customers with carts younger than 6 months and use the tool on a frequently base from now on) Thanks in advance
  6. PVK

    Order IP Recorder v1.0

    All seems to work as supposed to untill i try to do a status update. Then i am presented with the following error: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from orders where orders_id = '59808'' at line 1 select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, from orders where orders_id = '59808' [TEP STOP] I also saw that in the contribution section someone had the same problem, but he did not put it here. Anyway, does anyone know what i have to do to remove the error as now i can not update any orders without this error. I am running a live shop so anay fast reply would be greatly appreciated
  7. Great mod! I have 2 questiosn. 1 : Would it be possible to let this contribution only show the products which status is (for instance) payed instead of purchased (because some customers order, but never pay, which makes a purchased list alone a bit unreal since it doesn't actually display the products which have really been payed for) 2: would it be possible to redesign it so, that you can display the products that HAVEN't been sold (which would give me an insight which ones that are so i can delete them OR make some more promotion for those) Thanks
  8. PVK

    [Contribution] Admin Notes

    I have a question. Although the contribution works fine i have a comment. Maybe i have done something wrong(doubt it because the install is pretty simple), but i have noticed that when you create you are able to choose a category, but you can only set a marker of your choice when you have first made a new note and then you have to edit it again to set the marker. Isn't it a far better plan to be able to set the marker also when you create a new note? Can someone shed a light in this case?
  9. PVK

    [Contribution] Admin Notes

    DOH,..... just saw that the mistake was caused by me....i apparently overlooked that one sentence which actually was in the file. :blush: sorry, my bad Anyway, thanks again for the great contribution!
  10. PVK

    [Contribution] Admin Notes

    Unbelievable, i havent been here for a while since our shop is running like a charm with no problms wha's so ever and now i was thinking, lets see what's new. I found this great contribution (thank you very much), with just a small hickup (forgot to add that step in your zip file). I place my question and yet again carine comes to save the day for me :thumbsup: Carine, thanks once again, you seem to be my lucky angel :blush: Do you ever take a day of hehehe? BTW, everything now works again thanks to the both of you
  11. PVK

    [Contribution] Admin Notes

    I have installed everything as suggested in the zip file.[version 2.0 clean] Everything seems to work when i edit and add some comments in the customer field, however when i click on the tools button in the admin section and choose admin notes it comes up with this: 1146 - Table 'testshop.TABLE_ADMIN_NOTES_TYPE' doesn't exist select type_name from TABLE_ADMIN_NOTES_TYPE order by type_name [TEP STOP] :'( When i check in my database with phpmyadmin the table is there however [which is logical since i copy pasted the codes from the zip file ] Anyone any idea what the problem is???? Thanks
  12. @ druide, yes i know that there is a contribution for a paypal method, but i wasn't [and still am] not sure if this will conflict with the specific IPN contribution which i am currently running since this is a completely different one then the one from the IPN version. Does anyone know if you can still safely install this one over the IPN version???? And @ozcsys: I didn't even know that really. Besides, i figued that it shouldn't be a poblem if you clearly let it be known to your customers that the are being charged an extra amount for the handling costs.
  13. I have my paypal IPN up and running [and working!!!], but now i was wondering if it is also possible to add a certain amount [or even better: a set percentage] to the order amount to cover the costs of the handling by paypal ??? Thanks
  14. PVK

    Paypal IPN

    Yep thats right, if you are reading this you either : Know the solution or you are just like me . Have the contribution up and running, working in test mode, but in real life NO IPN is added [the orders do come trough via the site) If you recognice this situation you are prolly insane by now [just like me] If you know what we do wrong [a setting in paypal perhaps?] , PLEASE HELP us out of our misery. I have spend days to get the thning working , but now the last step is failing. .... ..... ..... somebody help....please....
×