Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / gift certificate - referenced to wrong order

gift certificate - referenced to wrong order

Locked

Started by heavenlynights on 20 Sep 2006, 10:50 PM · Views: 2,920

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
20 Sep 2006, 10:50 PM
#1
heavenlynights avatar

heavenlynights

Zen Follower

Join Date:
Jan 2006
Location:
Australia
Posts:
303
Plugin Contributions:
0

gift certificate - referenced to wrong order

Hi

I am in the process of testing my upgrade to zen 1.3.5. Did a test purchase for a gift certificate and paid via paypal which went fine.

I refunded paypal payment and that went fine.

I then cancelled this order and this is where it fell apart.

According to admin even after cancelling order through order status, I still have a gift certificate to release. but even stranger is that the gift certificate is referring to an entirely different order no which was not an order for a gift cerficate and was not a test order i created. It was referring to a legitimate order for a customer,

admin screen (gift certificate release cue)

Customer
My testing user name (Correct)

Order No.
17 (incorrect)

GC Value
25.00 (correct)

Date Purchased
21 Sept & time (correct)

Also there is no option to cancell this gift certificate.

Can anyone help?

Cheers Heavenlynights
http://www.heavenlynightslingerie.com.au
Warning: Adult Content - Zen 1.3.8a

21 Sep 2006, 12:44 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: gift certificate - referenced to wrong order

The coupons_gv_queue has a reference to the orders_id

If you delete the order and reset the orders_id ... but do not delete the GV in the coupons_gv_queue then you will get a mixed reference ...

As GVs are cash, there is not a way to delete these easily ...

We will be building in something in a future release to manage the GVs and allow a method to mark a GV as unusable with explination, but not a total kill ... as there needs to be some sort of safe checks and balance on these ...

You can manually delete the coupons_gv_queue if your tables are out of synch from testing etc. via phpMyAdmin ...

Note: your signature has a typo ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

21 Sep 2006, 1:46 AM
#3
heavenlynights avatar

heavenlynights

Zen Follower

Join Date:
Jan 2006
Location:
Australia
Posts:
303
Plugin Contributions:
0

Re: gift certificate - referenced to wrong order

Thanks Ajeh

I didn't actually delete this order, I just marked it as cancelled, that is all! It still shows in the admin!

Note: your signature has a typo ...

Which typo...? Are you meaning the capital H or do my eye need testing (too much screen!!) :lol:

Cheers Heavenlynights
http://www.heavenlynightslingerie.com.au
Warning: Adult Content - Zen 1.3.8a

21 Sep 2006, 1:58 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: gift certificate - referenced to wrong order

Somewhere you have your URL ... thought it was in your signature ... must of been just in the post ... :unsure:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

21 Sep 2006, 2:06 AM
#5
heavenlynights avatar

heavenlynights

Zen Follower

Join Date:
Jan 2006
Location:
Australia
Posts:
303
Plugin Contributions:
0

Re: gift certificate - referenced to wrong order

Huh.

Did you want a url for the store?

Cheers Heavenlynights
http://www.heavenlynightslingerie.com.au
Warning: Adult Content - Zen 1.3.8a

21 Sep 2006, 2:16 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: gift certificate - referenced to wrong order

nope ... I figured that out ... I just thought you had a boo-boo in your signature and did not look a second time to notice otherwise ... :lamo:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

21 Sep 2006, 2:47 AM
#7
heavenlynights avatar

heavenlynights

Zen Follower

Join Date:
Jan 2006
Location:
Australia
Posts:
303
Plugin Contributions:
0

Re: gift certificate - referenced to wrong order

no worries. Thanks Linda.

Cheers Heavenlynights
http://www.heavenlynightslingerie.com.au
Warning: Adult Content - Zen 1.3.8a