Get attribute id from orders_products table

[mgraphic]

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?

[Ajeh]

They are in the orders_products_attributes table ...

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 ...

[rapidsci1]

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-

[der Hund]

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

[Ajeh]

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

[kobra]

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