Never mind, false alarm - the system works as it should. Forgot I was testing from a different site where the invoice number was only 2, which is well below the current invoice number where I did most of my original testing on a different site.

That brings me back to the original advice

Quote::

The simplest fix for now is check the last known invoice number accepted by PayPal (orderID is the number after the #) and check that against the auto-increment value for the table cms_cart_orders - using phpmyadmin, I would increase that value to a number above the value indicated on the invoice.

You are generating order numbers below what PayPal has on record:
Either you have reset your orders table,
OR you are generating invoices with Storez on another site that has led to the problem,
OR you have another application somewhere generating invoice numbers for the same PayPal account.

Find your last known PayPal invoice number then reset auto-increment to that value + 1 for the cms_cart_orders table.

There is only one other way of encountering a duplicate invoice (in Storez anyway), and that is if someone has already actually paid for an order through PayPal and PayPal then refuses to process the duplicate order (one of the reasons for using invoice numbers).

I may have to make provision in Storez for people to add their own unique prefix to the order ID when generating an invoice, otherwise they will run into trouble if using Storez on multiple sites with the same PayPal account. This needs extra work since I then will have to truncate that prefix for Storez to accept the ID.

My paypal account is around 5 years old, I used emporium when I was on nuke and then had to change to the stand alone oscommerce, so there has been invoices generated by emporium previously.

I'll try your advice and see what happens as I have my store all set up the way I want it.

It appears to be sorted, I had to set it at 200 for it to start working.

hmm, makes sense - I will plan a modification for a custom invoice prefix because the same issue will happen if you used the module on more than one site.

I'm also revamping the IPN setup in Storez now that I have modified Treasury (not released yet) to be fully auto-return.

Where would I make suggestions for the module as I have a couple.

Is it possible to have the module automatically transfer you to paypal after you have completed the process as some users don't click the paypal link.

Also products appear to display backwards z, y, x, instead of a, b, c

Post suggestions in a topic in this forum. They may have been covered already since I lost a number of topics courtesy of my ex-host.

I'd rather not do a straight transfer - some things people need to do for themselves - either they want to buy or they don't. The process is designed for ordering and payment as separate entities - perhaps that can be made clearer.

Not sure what you mean by backwards?

By backwards I mean product display, for example three products say a, b and c, a should be first then b then c, instead its displaying c, b then a so its backwards.

You mean they display as most recent first?

Product orders and receipts will now display as indicated. This should avoid any uncertainty over whether they should click or not. Similarly, I shall re-phrase the order confirmation email.

Oh, and I now have full Auto Return working, so the system will accept eCheck and Refunds/Reversals. That now makes Storez compatible with the next version of Treasury which also does the same.

Optional invoice prefix (up to 3 chars) has now been tested and added to the system for PayPal - saves screwing around with "what number must I start with for this installation?".

I agree that it needs to be made clearer in the checkout process that the final click to order does NOT take you to paypal, but rather to the page where they can then click the paypal. it's a little confusing. I may add some documentation to it on my own....but it'd be nice to not have to.

it's not THAT bad, I would also wonder if it would be possible to combine the shipping and billing address pages, so people don't have to fill in information twice.

Well, it's difficult to make it much clearer than it is now. At best, I could change the initial "Order" word to Checkout, but then so can you

Regrettably, you need the flexibility of separate billing and shipping addresses because that can often be the case for non-paypal orders.

I think I added enough verbiage in the descriptive places of payment options that only idiots will not understand. Which means 20% of the orders I get will still not understand, lol. But at least I feel comfortable with it. I can add more to the e-mail info too I guess. I'll look at that for my needs and customer base.

I can understand the need to keep them separate...I just wonder if the selection/fill them out process can be one page instead of two. The fewer pages in a checkout process the better...especially for the skittish buyer. Every page gives a shopper another reason and opportunity to click something else.

To streamline is to increase orders.