Jump to content

lane

Members
  • Content count

    377
  • Joined

  • Last visited

Everything posted by lane

  1. lane

    Recover Cart Sales

    Your best bet would be to find an osCommerce developer to contract. I'm much too busy myself, and I'd read the osC forum rules before posting such a question.
  2. lane

    Recover Cart Sales

    Aha ... well, you are still left with trying to figure out when a cart is abandoned. You might be able to have a script that ran the the report and saved it to a file (maybe via lynx?). This could then be emailed to you on an hourly or daily basis. But doing so in real time, I have no idea how you could determine that. Inactivity could be abandonment or it could be I went to get my wallet, then had to go unload the car and then eat lunch before I could come back and finish the purchase (ie, not abandoned but simply delayed).
  3. lane

    Recover Cart Sales

    Not sure, It's been ages since I sent myself copies. How did you define your email address? The report should show orders that got "recovered" by having a purchase after an email is sent. It can be tricky to match orders to carts since orders don't exist at cart time and carts don't exist at order time. If you have specific examples of ones that did and didn't get matched maybe we could figure out why. I don't, but that's a good idea. I don't have any free bandwidth to look into this however, at least not any time soon. Welcome :) Anyone recommend a good way to have a "wish list" of items for a contribution? I could put one in the archive, but that's rather hard to read for most people (ie, while browsing this forum). Is there a bug tracker for osC contributions?
  4. lane

    Recover Cart Sales

    No, because there is no way to determine when a cart is abandoned...at least as far as I know. Besides, it's probably not a good idea anyway customer-relations wise. I usually do not send out notices to anyone who's cart is not at least 2 days old; I don't want to be pushy, but ask for help making the cart better. I get a useful information back (I couldn't tell your site was secure, the bank didn't accept my card, etc.) and occasionally I get sales I would have otherwise lost. I'd rather have a few less happier customers than a few more cranky customers. My rule of thumb; if I wouldn't appreciate an action then I don't perform it.
  5. lane

    Recover Cart Sales

    Glad you got that part sorted out. Not sure here, but I'd suspect either a bad SQL import or conflicting ID for the entires. These are the configuration SQL statements, and I tried to pick a unique ID, but that can't be guaranteed in the osC system. That said, my money's still on a bad import (or no import) of the configuration SQL statements. Use phpMyAdmin or similar to view the configuration table and verify that the RCS configuration entries are present. Sounds like you have the table already created, which is why creating the table would be an error. As for the primary and index, it should be only one of those so that warning is correct. I don't have this warning on my install.
  6. lane

    Recover Cart Sales

    This basically is saying that the file does not exist; most likely because "FILENAME_UPCOMING_PRODUCTS" is not defined (it should have been replaced by a real filename). Sounds like the setup data either got deleted or overwritten during an edit. While it could have occurred due to editing when installing RCS, these files are not part of RCS and the definitions should not have been touched during install. Assuming a correct install, the only thing I can guess at is one of a) the site wasn't working fully before the RCS install or B) there is a conflict between RCS and another component in the new install (although I've never heard of any conflicts). Hope that helps.
  7. lane

    Recover Cart Sales

    You can do this, but it will take some custom coding on your side. Best bet is to look at Step 9 in the installation instructions which deals with pricing. It won't address your specific needs, but that's the starting point, and you'd need to modify it for that particular contribution.
  8. lane

    Recover Cart Sales

    This may sound obvious, but it's often missed: make sure you are using the tool and not the report. Other than that, I'm not sure. My provider is still on PHP4, so I'm not sure on that and my 2.2rc1 is heavily modified (including the checkout code) so I can't always compare apples to apples.
  9. lane

    Recover Cart Sales

    I've never actually attempted to determine exactly when a shopping cart becomes available to RCS. You might need to proceed at least to the checkout page.
  10. lane

    Recover Cart Sales

    I haven't seen this issue before, so I don't have any immediate thoughts on how to solve it. My first step would be to confirm that the customer's orders are actually being put in the orders table in the DB, then check to see if their cart was actually emptied or not (and maybe check to see if there are duplicates). I'd also place an order and then see if my order showed up in the RCS tool list for emailing.
  11. lane

    Recover Cart Sales

    Thanks, much appreciated! Do you know if your modifications will still work on PHP4 systems?
  12. lane

    Recover Cart Sales

    All that RCS does is look for carts which are assumed to be "incomplete" orders. There is some logic and options to filter out duplicate orders, etc. Then it allows you to send emails to those customers with incomplete orders. (the purpose being to find out why your customers don't complete orders, and also to gently remind them about the order in the hopes they will complete it). RCS does not modify orders (unless you use the delete button), the only DB thing it does normally is to track what carts have been sent emails on. As for the inability to complete an order afterward, that is not something I've seen before; on our cart customers can always complete one of their incomplete orders. There's no need to clear out incomplete orders as far as I know.
  13. lane

    Recover Cart Sales

    Hmmm... I wonder if you could use the "delete" button in RCS to remove those carts? It's been so long since I was that deep into the code that I don't recall exactly what it does, so I'd experiment carefully. I _think_ it would delete the cart so that the customer no longer saw it. If it's an actual order, then you might have to do it manually... although that's sounding very tedious! Actually, I did work on this somewhat sometime ago, with the Fix Order Status Mod, might be worth checking out.
  14. lane

    Recover Cart Sales

    Thanks for sharing your solution, that will hopefully help others in the future.
  15. lane

    Recover Cart Sales

    From previous posts on the topic, it looks like you might need to have the "globals" contribution installed as well. I don't have a store on a server where this is possible as of yet, so I am unable to test this particular issue.
  16. lane

    Recover Cart Sales

    I get lots of good feedback from this, especially when something stops working that's not obvious (like postage for instance). I get these showing up in my store. These are "pending" orders and as such can be filtered in or out from incomplete orders. Look in your setup, in the "Configuration" section for RCS settings.
  17. lane

    Recover Cart Sales

    Could be a number of things; your RCS settings could be filtering your cart out (based on a previous matching order for instance), could be the date range, etc. Check the configuration panel for RCS and play with the settings. The way osC handles abandoned carts makes it tough to get a 100% match.
  18. lane

    Recover Cart Sales

    First, the scart table is only used to track which carts have had an email sent, it is not used to track the sales. Most likely the update to the osC code to handle mysql5 changed a table or some data that RCS is looking for, and that's why it's spinning. It might also be some type of interaction between the osC data and the old scart data, and I'd recommend just deleting all the scart table entries. (this is safe to do). In such a case, I'd start putting echo's to the screen in the web page to let me know how far into the logic I was getting, then I could narrow it down to exactly which database query was the issue.
  19. lane

    Recover Cart Sales

    Most likely this is a configuration issue. Sending emails is the most difficult part. I had to enable the logging options (might be labeled debug or logging in the RCS options), then look at the server logs to figure out my issues. These ranged from a wrong password to using the wrong connection type/information.
  20. lane

    Recover Cart Sales

    There is not an automated method, no. It's problimatic, as there would be a lot of emails sent to people who actually did purchase.
  21. lane

    Recover Cart Sales

    Hmmm... I am not sure but I'd look to make sure your 'products_options' table has a 'products_options_name' field. The problem is most likely a difference in databases (ie, dependency or changes by a contribution) or a bug in the code (ie, bad field name).
  22. lane

    Recover Cart Sales

    I'm not sure ... I only send or receive plain text email, so this is not something I will be much help on. However, I think you might be able to turn on "html email" option somewhere in the osCommerce config and it might do what you want. Other than that, it would be a pretty simple edit of the code that generates the email to modify it to produce the html you are looking for. Of course, people like myself that do not accept html emails (since nearly all spam is html and no necessary email is) would not get your stores emails.
  23. lane

    Recover Cart Sales

    Sounds like the https setting in your configure.php file... but I've never had osc on a proxy setup so I'm not sure.
  24. lane

    Recover Cart Sales

    I think adding a small calendar icon after the text entry box that when clicked on would bring up a calendar selection window would be a great idea. Be aware that you can't use the date itself, but will need to calculate the difference between the selected date at the current date.
  25. lane

    Recover Cart Sales

    I've never used Held Orders before, so I don't know what it does, nor what the Held Orders queue is. What I can say is that RCS doesn't modify any store data; all it does is look through the existing osC carts database table for carts w/o matching orders. It then displays these (this is done in the RCS Tool). You can then choose to send emails to the customers attached to each cart displayed; when yo do so an entry is added to the RCS only table 'scarts', that entry simply allows the tool to determine if the cart's customer was previously emailed or not. Very simple. The report tries to match orders to entries in the 'scart' table to give the store owner some idea of the impact of using RCS. (Which is very imprecise given the setup of osC and customer usage patterns). Anyway, that's the long way of saying I don't have an answer for you, but I don't see how RCS would interfere with any other contribution (however, another contribution could, and that interaction could result in improper results on either side).
×