Jump to content

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

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
  • 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...
  • 4 months later...
  • 3 months later...
  • 1 month later...

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
  • 7 months later...
  • 1 month later...

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