I have a very odd issue, when exporting the catalog with wholesale prices, some wholesale prices come out as 0 .... Although the info shows in the backend as. I have a basic SQL query to pull up the catalogue with wholesale prices. Most of them are coming out fine but plenty of values in the wholesale column come out as 0-0000 although the wholesale price is properly set and showing properly in the admin ...
How can this happen knowing this is pulled out from the database.
I am also putting here the SQL query
Thanks in advance
SELECT
p.id_product 'Product ID',
p.reference 'Reference',
pl.name 'Product Name',
p.price 'Price',
p.wholesale_price 'Wholesale Price',
s.quantity 'Quantity'
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category and cl.id_lang=2)
LEFT JOIN ps_stock_available s ON (p.id_product = s.id_product)
GROUP BY p.id_product
ORDER by p.reference
