https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 03:49:18 +0000 Wed, 22 Jul 2009 06:20:05 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2887 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10719.html#10719 Author: caughlan
Subject: 2887
Posted: 22-July-2009 at 6:20am

Thanks - I'll give that a shot!]]> Wed, 22 Jul 2009 06:20:05 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10719.html#10719 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10712.html#10712 Author: ProductCart
Subject: 2887
Posted: 21-July-2009 at 5:08pm

Hi Greg,

No, you don't need to retain the orders.
]]> Tue, 21 Jul 2009 17:08:20 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10712.html#10712 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10710.html#10710 Author: Greg Dinger
Subject: 2887
Posted: 21-July-2009 at 4:05pm

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?]]> Tue, 21 Jul 2009 16:05:32 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10710.html#10710 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10709.html#10709 Author: ProductCart
Subject: 2887
Posted: 21-July-2009 at 3:41pm

We have a script that decrypts customer passwords with the "old" key (the one used in the original store) and encrypts them again with the "new" key (the one used in the new store). We can certainly send it to you, if you need it.]]> Tue, 21 Jul 2009 15:41:01 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10709.html#10709 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10708.html#10708 Author: Guests
Subject: 2887
Posted: 21-July-2009 at 3:35pm

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.
]]> Tue, 21 Jul 2009 15:35:43 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10708.html#10708 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10707.html#10707 Author: ProductCart
Subject: 2887
Posted: 21-July-2009 at 3:25pm

As Greg says, if you have some basic SQL skills, you can do so directly using the Import/Export tools in MS SQL. Here is an FAQ about how Gift Certificates are stored in the database: http://www.earlyimpact.com/faqs/afmviewfaq.asp?faqid=342

One thing to point out: to properly populate the "pcGC_IDproduct" field, create a Gift Certificate product in the new store database, then use that product ID for that field when you import the purchased Gift Certificate into the new store.]]> Tue, 21 Jul 2009 15:25:56 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10707.html#10707 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10699.html#10699 Author: Greg Dinger
Subject: 2887
Posted: 20-July-2009 at 10:51pm

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?

]]> Mon, 20 Jul 2009 22:51:22 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10699.html#10699 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10698.html#10698 Author: caughlan
Subject: 2887
Posted: 20-July-2009 at 10:18pm

Hi Greg
I'm adding a store and intend to honour the g'c from the first store...]]> Mon, 20 Jul 2009 22:18:50 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10698.html#10698 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10697.html#10697 Author: Greg Dinger
Subject: 2887
Posted: 20-July-2009 at 9:02pm

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?
]]> Mon, 20 Jul 2009 21:02:37 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10697.html#10697 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10696.html#10696 Author: caughlan
Subject: 2887
Posted: 20-July-2009 at 8:54pm

I'm moving my store to a new database/url and would like to bring over the gift certificates people have purchased - any idea how to export these?

Or do I have to create new ones and track down the customers that have received them in the past...

thanks!
stacelynn


]]> Mon, 20 Jul 2009 20:54:16 +0000 https://forum.productcart.com/exporting-gift-certificate-codes_topic2887_post10696.html#10696