[Module] Stock Check V4.0 Export Products To An Editable Page - Ps 1.2/1.7

[shacker 1,050]

heck Stock is a configurable module that lets you export in a HTML page, the products selected in one or more categories.
You can set the minimum stock for export, image size, categories, etc.
The design can be configured directly in the PHP file (productlist.php, you can edit in dreamweaver).
The column fields can be translated in the module configuration.
Features[/size]:[/size]

• Easy to install
• Cross browser

• Multilingual

• Multistore

Link

http://catalogo-onlinersi.net/en/back-office-prestashop-modules/183-check-stock-prestashop-module.html

 

Video

 

Do not forget to add your site to www.directory-stores.com. Free Directory prestashop
*support ps 1.4
*support ps 1.5
*support ps 1.6
v2.9 - Translations of the titles in the module
v3.0 - support bootstrap +ps1.6
v3.1-solved issue in ps 1.4

v3.2-solve image problems + better code

v4.0-compatible PS 1.7
 

 
v3.0 stockcheck.zip
 
v3.1 stockcheck.zip

 

v3.2 stockcheck.zip

 

v4.0 stockcheck.zip

Edited April 2, 2017 by shacker (see edit history)

[ysco 77]

Seems to be a very useful module shacker

Thanks buddy will try it later tonight and let you know the results.

Thanks for sharing it again with the community.

Best regards,


ysco..

[shacker 1,050]

Seems to be a very useful module shacker

Thanks buddy will try it later tonight and let you know the results.

Thanks for sharing it again with the community.

Best regards,


ysco..

Thanks buddy. the best is the posibility to modify directly the php file to adapt to print, or what you want

[DATO 0]

thank you for the great post. but where can i find the download link.

[shacker 1,050]

http://www.catalogo-onlinersi.com.ar/back-office-prestashop-modules/183-check-stock-prestashop-module.html

[shacker 1,050]

Can be combined with url2pdf to export as PDF

[Lisa G 0]

Hi there,

just tested this with PrestaShop version 1.3.2 and works perfect. Set up was a snap. Easy to rework the css to customize the look and feel of the generated html file to match my site. Thanks a lot for developing this really useful module. Will make my work a lot easier.

Kind regards,
Lisa

[shacker 1,050]

Thanks for use This module Lisa.
Best regards

[shacker 1,050]

Updated to PS 1.4 version of presta

[shacker 1,050]

added ps 1.4.4.1 support

[akhen 1]

Hola, muy wapo, lo unico malo q veo es q los acentos, y caracteres especiales se sustituyen con interrogaciones, cosa que deja el catalogo poco profesional, hay alguna forma de evitar esto?

 

gracias y saludos

[shacker 1,050]

added support ps 1.4.4.1 and UTF 8

 

ya lo hemos solucionado, descargalo de nuevo

[akhen 1]

ahora no se me ven las imagenes , otra sugerencia si no te importa ya que estoy, es que molaria que se vieran tambien las combinaciones de los precios a mi muchos se me kedan a 0€ por esto.

 

Un saludo compa

[shacker 1,050]

no soporta combinaciones, que version de presta tienes?

[akhen 1]

hola, la 1.4.3

 

Saludos crack

[msk69 18]

What about a supplier and manufacturer filter, that would be awesome!

[shacker 1,050]

pasame la url de tu sitio.

 

"What about a supplier and manufacturer filter, that would be awesome! "

I try to add these feature

[akhen 1]

pasame la url de tu sitio.

 

es la de mi firma aunque tengo 2 y el mismo problema en las 2

 

http://evilseeds.es

http://alicantegrow.es

 

Saludos

[shacker 1,050]

mira si es presta 1.4.4.1, ya que tiene un bug con las imagenes. deberas usar el nuevo sistema de imagen para que funcione

[DenisDenis 2]

I was wondering how do i make it generate a list?

If i click on the image on the bottom of the page where you can configure the module, it only shows the design with nothing in it and not even the picture of my shop, what am i doing wrong?

 

I'm using prestashop 1.4.0.17 btw

[shacker 1,050]

you need to configure the module with the minim level of stock to show. The module shows the products with less stock

[DenisDenis 2]

I set the amount to 100, as i want it to show me all products, but nothing is shown...

[shacker 1,050]

i think is related with your version of prestashop. can you test in local with a high version?¿

[DenisDenis 2]

I will try that once i have more time on my hands, thank you for your time!

[shacker 1,050]

you can try enable display errors on config/config.inc.php to check if some errors are displayed in the module

[DenisDenis 2]

Fatal error: Call to undefined method Image::getImgFolderStatic() in /home/cafmbksr/domains/deepdevotion.be/public_html/modules/stockcheck/stockcheck.php on line 64

 

this is the error shown.

[shacker 1,050]

yes, its a problem with your version. I write an update and advise here so you can redownload

[shacker 1,050]

Redownload now. i updated the module

[DenisDenis 2]

Wow incredible, It works now!

Thank you so much for your time and help!

[shacker 1,050]

great. Your welcome

[shacker 1,050]

v 2.5 - better code and link to product page (ps1.2/1.5)

[shacker 1,050]

v2.5 - bugfix for image display and better code/added link to product

[creativity_spain 0]

Hi, I downloaded and installed easily, no problems, but when I click on view I see an empty table with my company logo but with the following 2 errors:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/s05536f1/public_html/modules/stockcheck/productlist.php on line 109

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/s05536f1/public_html/modules/stockcheck/productlist.php on line 199

 

I am using a quite old version of Prestashop: 1.2.2.0 I'm afraid. Hope that is not the problem - can you help?

[shacker 1,050]

have you selected a category in moduel configuration? i test on 1.2.5 and works

[TheToyBox 0]

Hi,

 

This is a nice module but I use a custom theme and the module looks for the product images in the original Prestashop folder such as medium/ etc. Could this be changed to look in the folder where my images are stored on my theme.

 

Also it would be nice to be able to select what I want to display, for example, I dont need the description for the stock take. Its a really good module but it good be really great!

[lisajef 1]

love it...but the images don't show up....using matrice theme

[lisajef 1]

...any idea what I can do to get the images to show? am using prestashop 1.4.4.1 and stock Check v.2.5

[innovaforniture 0]

hi,

the image dont show me....i use prestashop 1.5.0.17 and stockchek 2.5

 

anyone know the solution?

 

thanks

[shacker 1,050]

please redownload. I update the module

[innovaforniture 0]

thanks,

great module

only one question...cant it show combinations of the products?

[shacker 1,050]

at the moment dont support combinations

[lordrpg 0]

Hi

 

I tested your module I think is awesome but if you can take a look at my php result:

 

http://www.genuinetechnology.com.co/modules/stockcheck/productlist.php

 

It shows what I want but all the prices are missing. Whats wrong. Im using prestashop 1.4.7. WHat can I do?

[shacker 1,050]

what version of the module you have?

[lordrpg 0]

The version I have of the module is:

 

 

Compruebe archivo v2.6 by RSI

[shacker 1,050]

you have some special configuration for prices or products?

[carmadsu 3]

Buenos dias Shacker.

 

Te hago una consulta, resulta que estoy testeando el modulo con la ultima version de prestashop y me doy cuenta que no me traduce el contenido de los campos, o sea cuando genera la planilla lo hace pero siempre con el idioma de ingles y eso que el ID de idioma esta identificado el de español.

 

Que puede ser?

 

Mirando un poco el codigo llego a la siguiente consulta, pero no logro interpretarla ya que mis conocimientos en sql son escasos:

 

if(_PS_VERSION_ > "1.5.0.0")

{
 $sorgu = 'SELECT cp.*,p.*, pl.* , t.`rate` AS tax_rate, i.`id_image`, il.`legend`,sa.`quantity` AS `qa`
  FROM `'._DB_PREFIX_.'category_product` cp
  LEFT JOIN `'._DB_PREFIX_.'product` p ON p.`id_product` = cp.`id_product`
  '.$context->shop->addSqlAssociation('product', 'p').'
   LEFT JOIN `'._DB_PREFIX_.'stock_available` sa ON p.`id_product` = sa.`id_product`
  LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` '.Shop::addSqlRestrictionOnLang('pl').')
  LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
  AND tr.`id_country` = '.(int)Context::getContext()->country->id.'
  AND tr.`id_state` = 0)
  LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`)
  LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
  LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.intval($langs).')


  WHERE cp.`id_category` IN ('.$skipcat.') AND p.`active` = 1 AND sa.`quantity` < '.$title.'
  GROUP BY cp.`id_product`
  ORDER BY '.$sort.' ASC
  LIMIT '.$nb.'';


 }

 

tambien he notado que si bien existe la posibilidad de elegir el tamaño de la imagen su valor esta predeterminado en 'home'

 

/**/
$legacy=Configuration::get('PS_LEGACY_IMAGES');
  $newlink = new Link;
if(_PS_VERSION_ < "1.4.3"){
  $linki = $veri['link_rewrite'];
$legend = $veri['legend'];
$id_image = $veri['id_image'];
$images = $newlink->getImageLink($linki, $veri['id_product'].'-'.$id_image, 'home');
 }
 else{
 $linki = $veri['link_rewrite'];
$id_image = $veri['id_image'];
if($legacy==1){
$images = $newlink->getImageLink($linki, $veri['id_product'].'-'.$id_image,'home');
}
else{
$images = $newlink->getImageLink($linki, $id_image,'home');
}
}
/**/

 

reemplaze la ".'-'.$id_image, 'home');" por ".'-'.$id_image, '-'.$type.'.jpg');"

 

/**/
$legacy=Configuration::get('PS_LEGACY_IMAGES');
  $newlink = new Link;
if(_PS_VERSION_ < "1.4.3"){
  $linki = $veri['link_rewrite'];
$legend = $veri['legend'];
$id_image = $veri['id_image'];
$images = $newlink->getImageLink($linki, $veri['id_product'].'-'.$id_image, '-'.$type.'.jpg');
 }
 else{
 $linki = $veri['link_rewrite'];
$id_image = $veri['id_image'];
if($legacy==1){
$images = $newlink->getImageLink($linki, $veri['id_product'].'-'.$id_image, '-'.$type.'.jpg');
}
else{
$images = $newlink->getImageLink($linki, $id_image,'-'.$type.'.jpg');
}
}
/**/

Edited October 25, 2012 by carmadsu (see edit history)

[Bejo 11]

can this module doing export to csv or excel format?

[carmadsu 3]

Hey, look at this link seems quite practical.

http://www.prestashop.com/forums/topic/37900-module-product-export-module-v10-updated-for-14-free/

[shacker 1,050]

can this module doing export to csv or excel format?

Nop, becouse the idea is to export to html page. You can check the modules in the uppert post

[shacker 1,050]

v2.7 - Multistore / new image system added in ps 1.5

[Bazzspazz 0]

Hi, I can't get the images to show correctly, no matter what size I choose in the module the output is always small size, please does anyone know how to fix this?

[shacker 1,050]

have you configure the image size (not image type)

[shacker 1,050]

v2.8 - updated ps 1.5.3.1 - bug fix

[Dead2010 5]

hello, translated module in version 1.4.9.

 

not appear in the description of products, some mistake?, you can do an upgrade?

 

and how it translates fields, name, price, etc?

 

respects

[shacker 1,050]

the translation are into the module, you can change on it, not in translations tab

[Dead2010 5]

hello, you can show where changes?

[shacker 1,050]

redownload from our site, i put the options now

 

v2.9 - Translations of the titles in the module

[Dead2010 5]

hello, good afternoon, already translated, but still does not appear the translation done.

view images.

 

respects

[shacker 1,050]

in the front office you select the pr language?

[Dead2010 5]

the language is pt

[Dead2010 5]

ok, I get it, I had to change the ID of the language,

another question, because the description does not appear?

 

thanks

Edited March 29, 2013 by Speed2010 (see edit history)

[shacker 1,050]

this is what i mean

regards

[Sharmi 0]

Hi, I'm a french IT student and I'm doing an internship.

Your module is an excellent stock check module.

My Boss asked me to find an inventory module and I find yours.

He also asked me to add columns available_now and available_later, what I did.

The result is :

http://www.lestablesdefranck.fr/modules/stockcheck/productlist.php

 

But I have another problem.

I want to have the results for each combinations I did for a product and I dont't know how to do that in the query. Maybe in product_attribute ?

Thanks to give me an idea. And sorry for my english

Regards,

Sharmi

Edited April 19, 2013 by Sharmi (see edit history)

[shacker 1,050]

in the php, use something like this

 

 

<?php $i = 1;

do{

?>

 

 

 

<?php

$sorgu4='SELECT * FROM `'._DB_PREFIX_.'product_attribute_combination` GROUP BY id_product_attribute';

$resultado4 = mysql_query($sorgu4);

$veri4= mysql_fetch_array($resultado4);

?>

 

 

 

<div style="clear:both; width:100%; height:auto">

<?php

do{

 

$sorgu3='SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name,

a.`color` AS attribute_color, pa.`id_product_attribute`, pa.`quantity`, pa.`price`, pa.`ecotax`, pa.`weight`, pa.`default_on`, pa.`reference`

FROM `'._DB_PREFIX_.'product_attribute` pa

LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`

LEFT JOIN `'._DB_PREFIX_.'attribute` a ON a.`id_attribute` = pac.`id_attribute`

LEFT JOIN `'._DB_PREFIX_.'attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`

LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON a.`id_attribute` = al.`id_attribute`

LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group`

WHERE pa.`id_product` = '.$veri["id_product"].' AND pac.`id_product_attribute` = '.$veri4["id_product_attribute"].'

AND al.`id_lang` = '.$langs.'

AND agl.`id_lang` = '.$langs.'

ORDER BY agl.`name`

';

$resultado3 = mysql_query($sorgu3);

$veri3= @mysql_fetch_array($resultado3);

 

if($veri3['group_name'] != NULL){

?>

 

<?php

do{

?>

 

<?php

 

echo '<strong>'.$veri3['group_name'].'</strong>: '.$veri3['attribute_name'];

?>

,<?php

}

while($veri3=mysql_fetch_array($resultado3));

?>

<br />

 

<?php

}

 

}

while($veri4=mysql_fetch_array($resultado4));

?>

[Sharmi 0]

Thank you for your response Shacker.

I tried to do what you said above. But I've done it in a different way.

With another query. Being a newbie in Prestashop and in website development I was wondering how to do that. Thank you for your help =D

Edited April 23, 2013 by Sharmi (see edit history)

[shacker 1,050]

your welcome

[mkrmitsolutions 0]

I hope someone still reads these.  I was wondering how do i make it a . instead of a , for the dollar amount.  see link below.  Instead of $75.00 it says $75,00

 

http://developer.mkrm-itsolutions.com/modules/stockcheck/productlist.php.

 

also where do i change where it looks for the picture at the top?

 

Thanks

MM

[shacker 1,050]

v3.0 - compatible ps 1.6+bootstrap

I hope someone still reads these.  I was wondering how do i make it a . instead of a , for the dollar amount.  see link below.  Instead of $75.00 it says $75,00

 

http://developer.mkrm-itsolutions.com/modules/stockcheck/productlist.php.

 

also where do i change where it looks for the picture at the top?

 

Thanks

MM

download the latest version

[Jardel2010 0]

Hello shacker,

 

installed version 3.0 on prestashop v1.4.11 is giving me this error.

Fatal error: Class 'HelperForm' not found in /modules/stockcheck/stockcheck.php on line 1080

you can solve?


best regards

Edited March 10, 2015 by Jardel2010 (see edit history)

[ezesuthering 0]

Hola shacker,  impresionante lo que hiciste, muchas gracias.

Te queria hacer una consulta, yo tengo 3 grupos de clientes con diferentes precios, se puede modificar un poco el código para que me salgan los precios de cada grupo? o ya es muy complicado? si me podes ayudar te agradeceria, muchas gracias igual por el modulo que esta muy bueno!

[TACS 10]

Im a little confused, the title of this thread reads "Stock Check V3.0- Export Products To An Editable Page - Ps 1.2/1.6"

 

if i'm reading this correct, the html page it exports to, I am meant to be able to edit it,... is that correct?.. because if so, its not working on my 1.6.0.9 BS.

[Jardel2010 0]

Hello shacker,

 

installed version 3.0 on prestashop v1.4.11 is giving me this error en backoffice when I go to configure the module

Fatal error: Class 'HelperForm' not found in /modules/stockcheck/stockcheck.php on line 1080

 

 

you can solve?


best regards

[rschwendeman 0]

Super super super useful module. Thanks!!!!!

[Jardel2010 0]

hello, anyone can resolve the error that gives me?
thank you
best regards

[shacker 1,050]

Hello shacker,

 

installed version 3.0 on prestashop v1.4.11 is giving me this error.

 

Fatal error: Class 'HelperForm' not found in /modules/stockcheck/stockcheck.php on line 1080

you can solve?

 

 

best regards

redownload 3.1 version, i solved that error

v3.1-solved issue in ps 1.4

[shacker 1,050]

Im a little confused, the title of this thread reads "Stock Check V3.0- Export Products To An Editable Page - Ps 1.2/1.6"

 

if i'm reading this correct, the html page it exports to, I am meant to be able to edit it,... is that correct?.. because if so, its not working on my 1.6.0.9 BS.

hi. Export in a php page, so you can edit the code ( in visual mode on dreaweaver for example)

[shacker 1,050]

Hola shacker,  impresionante lo que hiciste, muchas gracias.

Te queria hacer una consulta, yo tengo 3 grupos de clientes con diferentes precios, se puede modificar un poco el código para que me salgan los precios de cada grupo? o ya es muy complicado? si me podes ayudar te agradeceria, muchas gracias igual por el modulo que esta muy bueno!

no, ya que al ser generado desde el back office, no permite discriminar usuarios

[Jardel2010 0]

redownload 3.1 version, i solved that error

v3.1-solved issue in ps 1.4

hello,

nice work. thank you

best regards

[shacker 1,050]

hello,

nice work. thank you

best regards

iu welcome. rate the product in our site to help us

[samyzeze 1]

hello

 

thanks for this great module

i updte the module for my prestashop 1.6

but imahe not showing on export, the image link is wrong.

example : http://www.discountatoutprix.com/modules/stockcheck/www.discountatoutprix.com/8218-thickbox_leoasen_800x800/batterie-interne-li-ion-polymer-pour-iphone-6-plus-5-5.jpg

 

how can i solve this problem

[chucurulo 13]

saludos tengo un error utilizo PS 1.6.1.1

 

Forbidden

You don't have permission to access /modules/stockcheck/productlist.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

alguna idea de como solucionarlo?

[shacker 1,050]

hello

 

thanks for this great module

i updte the module for my prestashop 1.6

but imahe not showing on export, the image link is wrong.

example : http://www.discountatoutprix.com/modules/stockcheck/www.discountatoutprix.com/8218-thickbox_leoasen_800x800/batterie-interne-li-ion-polymer-pour-iphone-6-plus-5-5.jpg

 

how can i solve this problem

redownload, new version solve the issue

[shacker 1,050]

v3.2-solve image problems + better code

[esmokeplaza 0]

Hello,

 

i can't get the totalls in "stock" working     it's empty.

What am i doing wrong ?

[shacker 1,050]

site url?

[esmokeplaza 0]

site url?

Hi,

 site url  esmokeplaza.nl

 

thx

[shacker 1,050]

can be a issue with the ps version. wich version is? you use combinations?

[esmokeplaza 0]

Thx for reply shacker

 

PS Version 1.6.0.9

and yes   i use combinations. 

Your version i use is 3.20

 

Thx in advance

[shacker 1,050]

send me a pm with admin access and i solve

[vishalsingh119 2]

heck Stock is a configurable module that lets you export in a HTML page, the products selected in one or more categories.

You can set the minimum stock for export, image size, categories, etc.

The design can be configured directly in the PHP file (productlist.php, you can edit in dreamweaver).

The column fields can be translated in the module configuration.

Features[/size]:[/size]

• Easy to install
• Cross browser

• Multilingual

• Multistore

Link

http://catalogo-onlinersi.net/en/back-office-prestashop-modules/183-check-stock-prestashop-module.html

 

Video

 

 

Do not forget to add your site to www.directory-stores.com. Free Directory prestashop

*support ps 1.4

*support ps 1.5

*support ps 1.6

v2.9 - Translations of the titles in the module

v3.0 - support bootstrap +ps1.6

v3.1-solved issue in ps 1.4

v3.2-solve image problems + better code

 

 

v3.0 stockcheck.zip

 

v3.1 stockcheck.zip

 

v3.2 stockcheck.zip

This module is good ,but it is not showing how many product in stock.this option always showing blank.

What i do when i set minimum quantity 3,it show accordingly.

[One_Man 73]

Salut

 

Avant tout, merci pour ce super module.

 

J'aurais juste 2 questions :

 

1. Est t'il possible de mettre un lien sur "ExtraLeft" pour que les clients puisse eux aussi voir les produits ? VOIR IMAGE 1

 

 

2. Comment modifier le template de la liste ?  VOIR IMAGES 2 & 3

 

merci encore

[shacker 1,050]

V4.0-compatible PS 1.7

[shacker 1,050]

This module is good ,but it is not showing how many product in stock.this option always showing blank.

What i do when i set minimum quantity 3,it show accordingly.

Wich PS version? the products have combinations?