Forums / All Other Contributions/Addons / Stock by Attributes : Display "Stock ID" in order/invoice details?

Stock by Attributes : Display "Stock ID" in order/invoice details?

Locked

Views: 2,436

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
22 Jan 2008, 1:11 PM
#1
damian7 avatar

damian7

New Zenner

Join Date:
Apr 2006
Posts:
3
Plugin Contributions:
0

Stock by Attributes : Display "Stock ID" in order/invoice details?

With the "Stock by Attributes" mod installed on Zen v1.3.8..

Please can anyone advise how i might get the "Stock ID" from (Admin->Products with Attributes Stock) to display in the product line in a customer's order/invoice?

ie.

Products Model

1x Zen T-shirt ZT001
Colour: Red
Size: XL
Stock ID: 100 <--- Like this!

29 Jan 2008, 4:12 PM
#2
absolute avatar

absolute

Totally Zenned

Join Date:
May 2005
Location:
Bath, Somerset
Posts:
1,054
Plugin Contributions:
2

Re: Stock by Attributes : Display "Stock ID" in order/invoice details?

You would need to query the database table, with the atribute ids, and the product id. There is no function built in to the module, but you could certainly add one.

The attribute options are stored as a comma separated list, so you would need to implode() these, and then add tehm to your SQL statement, along with the products_id.

Absolute

Back, after a 4 year absence! Did you miss me?
Absolute Web Solutions Ltd
Interested in our work? Take a look at one of our sites - The Tech Store