2

We have an internal system for assigning three digit numbers to the various accounts where we accept donations. These are set in stone and cannot be changed. If we could match these three digit numbers to the entry_id that would make a several things better: -url would have the account number and not a different number when donating -carthrob uses the entry_id to send info to the gateway, but that is meaningless to us. If it matched our account numbers that would be very useful.

I know I can go in and muck around the database and change these, but is that asking for trouble? What happens if we have 300 entries and we've set one of these accounts with an entry ID of 301? Will EE skip 301 or create two 301s...or just crash in a blaze of white screen?

THe site will be live tomorrow or Friday. It is not very content heavy. Maybe 30 pages, 20 members right now (using Zoo Visitor so they are in a Channel), and the 75 accounts stored in the CartThrob product channel. The entry ID count is nearly 300 with all the test orders we've placed to test the donate function.

Anyone do this and want to talk me off the ledge? Or is it safe to jump?

4

That's very much asking for trouble. I recommend just adding a new field to the channel or to store the internal id. We do this for a number of clients who need information to correlate to some other database or system. You can create a field called: account_number and use that and it will store the data safely.

If you adjust the entry number manually, you have to adjust it everywhere, titles, data, category, member_id, etc. Don't do it.

Custom fields are your friend.

| improve this answer | |
  • This (Storing an external id in a dedicated channel field) is the preferred approach. If you really need the entry_id to match, then in a clean install you can setup the channel and generate 999 entries (three digit is mentioned) to begin with. (and set status to closed by default for instance) – GDmac Dec 20 '12 at 9:42
  • Definitely use a custom field for this. Since it will be a plain text field you can even use the search parameter in your channel entries to find results in that field. – CreateSean Dec 20 '12 at 14:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.