Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
Clau123

Stock Inventory report with export function

Recommended Posts

This is the forum for the Contrib Stock Inventory report with export function.

 

 

HI , have problem this....

 

1054 - Unknown column 'p.products_cost' in 'field list'

 

select p.products_id, p.products_quantity, p.manufacturers_id, pd.products_name, p.products_model, p.products_weight, p.products_cost, p.products_price, p.products_status, pr.manufacturers_name from products p inner join products_description pd on p.products_id = pd.products_id left outer join manufacturers pr ON (p.manufacturers_id = pr.manufacturers_id) where pd.language_id = '4' group by pd.products_id order by pd.products_name ASC limit 0, 200

 

 

to solve?

 

Thank's

Share this post


Link to post
Share on other sites

Claudia, excellent Contrib!

 

I was a little hesitating installing the Margin Reports contrib, since it has so much code to change.

 

Everything just works, saves me a lot of time, especially dec 31st/jan 1st.

 

Groeten uit Apeldoorn.

 

Rene

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×