Hi Julian,

You probably test a previous version of the module with PayPal, then this order number was already used. By default, Store define the start order number to 1000, you can modify this value with a database tool like Enterprise Manager. If you database contains real data, MAKE A BACKUP FIRST!!!

For modify the starting counter value, open your database tool and connect to your database. Modify table definition of the table Store_Orders, replace the counter value with an higher value like 3000, save the table definition. The next order will be numbered 3001.

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.

Hi Keith,

This is not directly related to the Store module. PayPal DO NOT authorize to use a previously used order number. If you previously test an other store module/product with PayPal and used order number range from 1 to 1434 (as a sample), you have to use an order number higher than 1434! If you don't know what is the higher number is, ask the PayPal support.

If you can't use Enterprise Manager or similar db tool for modify the Store_Orders table as explained in my previous post, follow this:

Login to your web site as host. Then got to Host > SQL and paste this 3 lines in the text box:

DECLARE @OrderTable nvarchar(50)

SET @OrderTable = '{databaseOwner}{objectQualifier}Store_Orders'

DBCC CHECKIDENT(@OrderTable, RESEED, 2500)

Replace the number in bold red by your higher order number, check 'Run as Script' and click on 'Run'.

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.