Jump to content

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


shacker
 Share

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

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

  • 2 months later...

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

  • 2 months later...
  • 5 months later...

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

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

  • 3 months later...

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

  • 4 weeks later...

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

  • 2 weeks later...

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

  • 6 months later...
  • 3 weeks later...
  • 2 weeks later...

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

  • 2 weeks later...
  • 3 months later...
  • 4 weeks later...
  • 3 weeks later...

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

  • 2 weeks later...
  • 1 year later...

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

  • 2 weeks later...

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

  • 2 weeks later...

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

  • 1 month later...
  • 3 months later...

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

  • 4 weeks later...

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

  • 1 month later...
  • 2 weeks later...