Access Database Structure for Orders

[SpecTech]

Hi,

I know editing directly inside the database is always a bad idea however I have no other option and am simply trying to see if this script will work.

I am trying to import all orders and user accounts from one sellerdeck database into multiple sellerdeck databases. Now I know this is possible inside sellerdeck however I am importing orders that do not have products visible inside the new sites catalog (this is so users can see orders from all our sites using their log in on any of our sites) - I have already built a custom script that download's orders from all our sites into one actinic database.

I have managed to write some VBS that takes the Address, Buyer, Customer, Order, OrderDetail, OrderHistory, OrderMail, OrderTracking and Person tables (only visible ones I can see relating to orders) and copy's them from the original database into the destination database, but only if they don't already exist. (I am later coding for things like password/email changes etc)

Now this works nicely and it is importing the data fine, and sellerdeck isn't complaining and shows the new user accounts however the orders are still remaining blank. Is there something I am not updating to get it to refresh and show the new orders from the database? Maybe like a "lastordernumber" value somewhere.

Kind Regards,
Simon

[SpecTech]

Okay I have managed to get it working, it seems I didn't have the "persons" table mapped correctly. For anyone wanting to replicate this add the attached vba script to your originating database and change paths to the databases you are wanting to update. You can then run this daily or after doing an order download (possible to run the vba from batch which is what I will be doing next)