Using ProductCart - exporting gift certificate codes

Print Page | Close Window

exporting gift certificate codes

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2887
Printed Date: 28-February-2025 at 12:03am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: exporting gift certificate codes

Posted By: caughlan
Subject: exporting gift certificate codes
Date 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

Replies:

Posted By: Greg Dinger
Date 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?

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: caughlan
Date 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...

Posted By: Greg Dinger
Date 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?

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: ProductCart
Date 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 - 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.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: Guests
Date 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.

Posted By: ProductCart
Date 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.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: Greg Dinger
Date 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?

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: ProductCart
Date Posted: 21-July-2009 at 5:08pm

Hi Greg,

No, you don't need to retain the orders.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: caughlan
Date Posted: 22-July-2009 at 6:20am

Thanks - I'll give that a shot!