If this is your first visit, check our documentation. To post, register or login.
Forums / Setting Up Categories, Products, Attributes / Get attribute id from orders_products table

Get attribute id from orders_products table

Locked

Started by mgraphic on 17 Nov 2006, 10:12 PM · Views: 3,885

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
17 Nov 2006, 10:12 PM
#1
mgraphic avatar

mgraphic

New Zenner

Join Date:
Oct 2005
Posts:
25
Plugin Contributions:
0

Get attribute id from orders_products table

Can I get attribute id from db field orders_products.products_prid? It appears to be a hash, what function is available to decode this?

17 Nov 2006, 10:50 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Get attribute id from orders_products table

They are in the orders_products_attributes table ... :smile:

The products_prid is there but that is a reference not a translation really ...

The other fields are also there:
products_options (text of products_options_id)
products_options_values (blob of text for the products_options_values_id)
products_options_id
products_options_values_id

among other assorted fields ...

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!

2 Feb 2007, 7:01 PM
#3
rapidsci1 avatar

rapidsci1

New Zenner

Join Date:
Dec 2006
Posts:
6
Plugin Contributions:
0

Re: Get attribute id from orders_products table

Ok, so I thought this post had what I wanted... but I am still confused. How is this HASH used and should I be concerned about it if I am creating orders from outside of zencart? **Can I just use the product_id here for the products_prid? **What would be the repercussions of doing this if any?

So, zencart is great because it is free but the documentation really is lacking. I guess you can't expect a whole lot from a free product. The basic notifier/observer tutorial is great, but I am really having a hard time figuring out some of the nuts and bolts of this system...

Any clarity on this HASH would be greatly appreciated.

Thanks-

27 Nov 2008, 4:07 PM
#4
der_hund avatar

der_hund

New Zenner

Join Date:
Aug 2008
Posts:
4
Plugin Contributions:
0

Re: Get attribute id from orders_products table

I whant to now also.
For what using this hash? And how can I generate it?

28 Nov 2008, 5:22 AM
#5
ajeh avatar

ajeh

Oba-san

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

Re: Get attribute id from orders_products table

The prid is randomly generated and has no real meaning other than to tie things together ...

If you look in the orders_products_attributes you will see the values for:
products_options_id
products_options_values_id

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!

28 Nov 2008, 5:51 AM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Get attribute id from orders_products table

should I be concerned about it if I am creating orders from outside of zencart?

...but the documentation really is lacking.
From what you are stating(highlighted) I surmise that you are not finding docs on how to break out functions/parts to be incorporated into other non_Zen Cart pages.....
This is because this is NOT how Zen Cart has been written nor how it it is to be used - mostly due to having to track sessions especially if you are attempting to take functions away from the core code.

You do have the correct individual responding in Ajeh though

Zen-Venom Get Bitten