Jump to content

Chachits

Members
  • Posts

    11
  • Joined

  • Last visited

Profile Information

  • Location
    France
  • Activity
    Developer

Chachits's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Thanks for all bellini13, I mark solved this topic. See you soon on the board.
  2. Hi bellini13, How are you? Thanks for this code I made all tests I need yesterday and all is done. Thanks for all. I have just one questions about require(dirname(__FILE__).'/config/config.inc.php'); This code include all classes of Prestashop ?
  3. Hi all, Thank for all your answers... This line solve on problem, the class ObjectModel was found now. But at the execution of the script the function doesn't work, this is my code for test : <?php require_once('../config/config.inc.php'); require_once('../classes/stock/StockAvailable.php'); echo'OK1'; StockAvailable::updateQuantity((int)16,(int)51,(int)50,null); //StockAvailable::updateQuantity(16,51,50,null); echo'OK2'; StockAvailable::update(); echo'OK3'; ?> The script doesn't pass the function StockAvailable::updateQuantity(), "OK2" is never executed... I have tried this anyone show an error in the script ?
  4. Take my exemple : ps_product table : The product A have 16 for ID and have 0 for advanced_stock_management. ps_product_attribute table. The product A have 6 different combination . A1, A2, ..., A6. The id_product_attribute of item is 12, 13, 14, 15, 16, 17. When I update the quantity field in ps_product_attribute table the quantity never update in my website. I hope find a solution with you
  5. Hi Prestashopconnector, Thanks for your answer. Your query it's great and run but the problem isn't solve. For example I have a product which ID 1. This product have 3 colors different with 3 EAN distinct. So in the product_attribute table i have 3 ID 11, 12, 13 which represent the 3 product different. This is this quantity in product_attribute table that I can't modify. Have you any ideas? I have read i must use the fonction that I speak in my previous post but it is not possible to run them. If anyone have an idea or a solution
  6. Yes I know this parameters but when I'm create a test.php in a folder placed in the root of my directory I've got an error <?php require_once('../classes/stock/StockAvailable.php'); StockAvailable::setQuantity((int)16, 0, (int)50); ?> The error is : Fatal error: Class 'ObjectModel' not found in /homepages/16/d395607993/htdocs/temp/classes/stock/StockAvailable.php on line 33 And when I'm require_once('../classes/ObjectModel.php'); I've got an error too. Any one to help me ?
  7. The X_product_attribute_shop doesn't contain field for quantity. This is the structure of the table : id_product_attribute id_shop wholesale_price price ecotax weight unit_price_impact default_on minimal_quantity available_dat Anyone have an idea to use this method, it seem the solution is here but I don't make run this function : <?php require_once('../classes/stock/StockAvailable.php'); StockAvailable::setQuantity((int)16, 0, (int)50); ?>
  8. To update the X_product_attribute table I use UPDATE X_product_attribute SET quantity = quantity + [number] WHERE ean13 = "myProductEAN"; And I update the X_stock_available table with UPDATE X_stock_available SET quantity = quantity + [number] WHERE id_product = myProductID; The values are OK in the database but the modification doesn't appear in the shop.
  9. Hy all, News in the Prestashop community, I am meeting a problem wich a specific development for my new online shop. I would develop a function to update quantity stock of my website with my shop ERP. When I execute directly the request in the database the quantity are not change. I have read several posts over the net and I have read the solution is use the class StockAvailable with the updateQuantity function. But I didn't make run this function. Can someone help me please? Regards PS : I use the 1.5.6.2 version of Prestashop.
  10. Bonjour à tous, Nouveau sur la communauté Prestashop je rencontre actuellement un soucis pour le développement spécifique d'une fonction de ma nouvelle boutique en ligne. Je suis en train de créer une fonction pour coupler la boutique en ligne avec mon ERP. Je souhaite mettre à jour directement les stock de la boutique en ligne avec ceux de ma boutique physique. En visualisant la base de données je ne vois pas ou sont enregistré les quantités dans la base de données. La table X_stock_available possède la quantité totale des objets disponible mais les champs quantity des tables X_product et X_product_attribute sont tous à 0. Ma question est la suivante : comment mettre à jour les quantités en stock via des requêtes SQL ou via le WebService. Merci de votre aide. PS : J'utilise la version 1.5.6.2 de Prestashop.
×
×
  • Create New...