Jump to content
shacker

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

Recommended Posts

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

browsers.png

  • Multilingual

multilingual.png

  • Multistore

multistore.png

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
 
check-stock-prestashop-module.jpg
 
v3.0 stockcheck.zip
 
v3.1 stockcheck.zip

 

v3.2 stockcheck.zip

 

v4.0 stockcheck.zip

33078_Cy0oZWiG6X2S2kLJpZir_t

33079_7PKWZqOJgUYv9IjTAxRM_t

Edited by shacker (see edit history)

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

added support ps 1.4.4.1 and UTF 8

 

ya lo hemos solucionado, descargalo de nuevo

Share this post


Link to post
Share on other sites

ahora no se me ven las imagenes :wacko: , 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

Share this post


Link to post
Share on other sites

no soporta combinaciones, que version de presta tienes?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

pasame la url de tu sitio.

 

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

I try to add these feature

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
v2.5 - bugfix for image display and better code/added link to product

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

...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

Share this post


Link to post
Share on other sites

you have some special configuration for prices or products?

Share this post


Link to post
Share on other sites

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 by carmadsu (see edit history)

Share this post


Link to post
Share on other sites

can this module doing export to csv or excel format?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

post-512733-0-81486900-1364477843_thumb.jpg

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

redownload from our site, i put the options now

 

v2.9 - Translations of the titles in the module

Share this post


Link to post
Share on other sites

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

view images.

 

respects

Share this post


Link to post
Share on other sites

in the front office you select the pr language?

Share this post


Link to post
Share on other sites

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

another question, because the description does not appear?

 

thanks

Edited by Speed2010 (see edit history)

Share this post


Link to post
Share on other sites

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 :unsure:

Regards,

Sharmi

Edited by Sharmi (see edit history)

Share this post


Link to post
Share on other sites

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));

?>

Share this post


Link to post
Share on other sites

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 by Sharmi (see edit history)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by Jardel2010 (see edit history)

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

redownload 3.1 version, i solved that error

v3.1-solved issue in ps 1.4

hello,

nice work. thank you

best regards

Share this post


Link to post
Share on other sites

hello,

nice work. thank you

best regards

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

send me a pm with admin access and i solve

Share this post


Link to post
Share on other sites

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

browsers.png

  • Multilingual

multilingual.png

  • Multistore

multistore.png

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

 

check-stock-prestashop-module.jpg

 

v3.0 attachicon.gifstockcheck.zip

 

v3.1 attachicon.gifstockcheck.zip

 

v3.2 attachicon.gifstockcheck.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.

Share this post


Link to post
Share on other sites

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


post-920267-0-07262500-1471692156_thumb.jpg

post-920267-0-94678500-1471692156_thumb.jpg

post-920267-0-83370000-1471692157_thumb.jpg

Share this post


Link to post
Share on other sites

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?

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

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More