CHECK STOCK BEFORE ORDER

 

 

Some products warehoused at importers -we deliver to your door direct from  their warehouses. Some products warehoused/ imported by us to view

 

CLICK HERE to CHECK STOCK before order if order is:

Internet banking transfer from website
Internet banking transfer (Please send me a MANUAL INVOICE with banking details )
MOBICRED
Credit card online from website
Cash deposit to your own account then bank transfer
 

VIEW STOCK We keep in JHB and Capetown
These can viewed or ordered online with no need to check beforehand.

 

 

1327 - Undeclared variable: MAX_DISPLAY_ARTICLES_XSELL

select distinct p.products_id, p.products_image, pd.products_name from articles_xsell ax left join products p on ax.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id where ax.articles_id = '8' and pd.language_id = '1' and p.products_status = '1' order by ax.sort_order asc limit MAX_DISPLAY_ARTICLES_XSELL

[TEP STOP]