exporting gift certificate codes

Hi Stacylynn,

Could you please explain what you are doing in a touch more detail?

If the store is transferring to a new URL, and you are abandoning the old URL, you should be able to make a few configuration changes after copying the site pages to the new domain, and retain the entire database.

If you are adding a store and intend to honor g/c's from the first store, that might be another issue.

So could you please explain what you are doing so we might guide you?

Ok, we'll need someone from EI to chip in but here's my initial thoughts which may be useless.

I might consider cloning the complete database for the new store. 

If you are using the same products, keep them.  If not, delete all but the gift certificate products and run the task that physically purges them from the db.

Then write a query that identifies the orders containing gift certificates.  If I recall, you are somewhat technical, so perhaps you can tackle this. Or get a developer to assist.  This would give you a list of orders that have GC's on them.  Then delete all the other orders.

Next you may also want to nuke customers who are not on those remaining orders, or retain them at your preference.

The one issue I can see is that I believe the license key is used in the data encryption mechanism.  Not sure how to resolve that - EI may need to assist here as well as provide their views on the above.

This is nothing I have ever done, so I'm simply "winging it" in terms of coming up with a proposed solution - but I guess that's what you were hoping for, short of someone having actually done this.

Does this help?

Greg Dinger wrote: The one issue I can see is that I believe the license key is used in the data encryption mechanism.  Not sure how to resolve that - EI may need to assist here as well as provide their views on the above.

Hi Greg,

"Winging" it a bit here myself, but I do understand that PC does use the license key in the encryption; however, there are functions within PC to encrypt a bit of data and to decrypt it. Theoretically should be able to write a script to connect to the old database and then run data through the decryption then run it through the encryption function for the new store's database. I haven't looked at these functions yet, though.

EI - is it practical that ONLY the GC products and the GCs themselves could be migrated, or am I correct that you would also need to retain the orders on which the certs were purchased?

Thanks - I'll give that a shot!