If this is your first visit, check our documentation. To post, register or login.
Forums / Managing Customers and Orders / Refresh order details?

Refresh order details?

Locked

Started by reactiv on 13 May 2009, 11:42 PM · Views: 765

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
13 May 2009, 11:42 PM
#1
reactiv avatar

reactiv

New Zenner

Join Date:
Sep 2008
Location:
Melbourne
Posts:
4
Plugin Contributions:
0

Refresh order details?

I have a bunch of download products on my site, unfortunately one of the product attributes was not set correctly and I only discovered it after a customer placed an order for it. I have now fixed the product attributes but the order is still showing that its not a product download - is there a way I can refresh the order so it picks up that the product is a download?

17 May 2009, 1:56 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Refresh order details?

Several tables are involved in an order ...

orders
orders_products
orders_products_attributes
orders_products_download

If the attribute is on the order, then you just need to add the record to the orders_products_download table ...

If there isn't an attribute, then you also need to add a record to the orders_products_attributes record ...

The easiest way to fix it is to make an order yourself for this ... then compare the records for your order in these tables with the records for your customers order and make sure that they match up ...

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!