Jump to content

lane

Members
  • Content count

    377
  • Joined

  • Last visited

1 Follower

Profile Information

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