question about orders_id table

[magicpants]

We've arranged a special "import order" system to move orders from a business customer's site (using osCommerce) to our Zen site. It seems to work fine -- importing just 3 tables: orders, orders_products, orders_total.

The one problem I've discovered is the orders_id table - osCommerce doesn't seem to have it, so we need to make sure we add the orders_ids coming from him into this table, so the next order from another customer will be incremented correctly. I was planning on just manually adding the order numbers to the orders_id table -- but what about that session_id variable?

Does it matter if I just leave it blank? Does it need to match with something else?

And does anybody know of any other tables that we're missing like orders_id, that might cause problems? Thanks a lot!

[Ajeh]

Zen Cart doesn't have a table called:
orders_id

Are you sure of the name?

[magicpants]

Ah, thanks Ajeh -- so it must have been added from an installed module. Now, gotta figure out which one.

First thought, I did install "Improved Order Numbers" mod a long time ago, but didn't see anything in the README. And, of course, "Super Orders", but didn't look like that one did it either.

Anybody recognize where this came from, please let me know. I'll keep hunting.

[magicpants]

Found it: External Order Number Generator - we needed that for our payment module.

Now, gotta figure out if I can manually add to this table without messing anything up. Running out of time, kinda scary.

Thanks again for the help, Ajeh.