Prestashop products inserted by db not showing












0















I'm making a script for Prestashop 1.7.2 which one auto insert feed of data taken by an api, I create the products, categories (linking them), but when I go to the back office is not showed, I think about a field in database with wrong value or empty, this is my first script for PS and I´m learning the structure of the database. Any clue is helpfull.



Here you have the insert code. 



INSERT into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) 

VALUES (".$id_nova." ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')


Also I insert this for the name and description.



INSERT into ps_product_lang ( id_product, id_shop, id_lang, description, description_short, link_rewrite,  name )

VALUES ('".$id_nova."', '1', '".$x."', '".$contenido."', '".$contenido."', '".str_replace(" ","-",$nombre)."', '".$nombre."')"





php mysqli prestashop-1.7







share|improve this question

























  • Do you have a table named ps_category_product ? In 1.6 it was here that the link between category and product was made, but I don't know for 1.7

    – Fanie Void
    Nov 21 '18 at 16:27











  • Can you have a look in your database ? Does your data is here ?

    – Fanie Void
    Nov 21 '18 at 16:32
















0















I'm making a script for Prestashop 1.7.2 which one auto insert feed of data taken by an api, I create the products, categories (linking them), but when I go to the back office is not showed, I think about a field in database with wrong value or empty, this is my first script for PS and I´m learning the structure of the database. Any clue is helpfull.



Here you have the insert code. 



INSERT into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) 

VALUES (".$id_nova." ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')


Also I insert this for the name and description.



INSERT into ps_product_lang ( id_product, id_shop, id_lang, description, description_short, link_rewrite,  name )

VALUES ('".$id_nova."', '1', '".$x."', '".$contenido."', '".$contenido."', '".str_replace(" ","-",$nombre)."', '".$nombre."')"





php mysqli prestashop-1.7







share|improve this question

























  • Do you have a table named ps_category_product ? In 1.6 it was here that the link between category and product was made, but I don't know for 1.7

    – Fanie Void
    Nov 21 '18 at 16:27











  • Can you have a look in your database ? Does your data is here ?

    – Fanie Void
    Nov 21 '18 at 16:32














0












0








0








I'm making a script for Prestashop 1.7.2 which one auto insert feed of data taken by an api, I create the products, categories (linking them), but when I go to the back office is not showed, I think about a field in database with wrong value or empty, this is my first script for PS and I´m learning the structure of the database. Any clue is helpfull.



Here you have the insert code. 



INSERT into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) 

VALUES (".$id_nova." ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')


Also I insert this for the name and description.



INSERT into ps_product_lang ( id_product, id_shop, id_lang, description, description_short, link_rewrite,  name )

VALUES ('".$id_nova."', '1', '".$x."', '".$contenido."', '".$contenido."', '".str_replace(" ","-",$nombre)."', '".$nombre."')"





php mysqli prestashop-1.7







share|improve this question
















I'm making a script for Prestashop 1.7.2 which one auto insert feed of data taken by an api, I create the products, categories (linking them), but when I go to the back office is not showed, I think about a field in database with wrong value or empty, this is my first script for PS and I´m learning the structure of the database. Any clue is helpfull.



Here you have the insert code. 



INSERT into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) 

VALUES (".$id_nova." ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')


Also I insert this for the name and description.



INSERT into ps_product_lang ( id_product, id_shop, id_lang, description, description_short, link_rewrite,  name )

VALUES ('".$id_nova."', '1', '".$x."', '".$contenido."', '".$contenido."', '".str_replace(" ","-",$nombre)."', '".$nombre."')"





php mysqli prestashop-1.7




php mysqli prestashop-1.7






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 21 '18 at 17:16









Fanie Void

1619




1619










asked Nov 21 '18 at 16:04









Jose CastilloJose Castillo

213




213













  • Do you have a table named ps_category_product ? In 1.6 it was here that the link between category and product was made, but I don't know for 1.7

    – Fanie Void
    Nov 21 '18 at 16:27











  • Can you have a look in your database ? Does your data is here ?

    – Fanie Void
    Nov 21 '18 at 16:32



















  • Do you have a table named ps_category_product ? In 1.6 it was here that the link between category and product was made, but I don't know for 1.7

    – Fanie Void
    Nov 21 '18 at 16:27











  • Can you have a look in your database ? Does your data is here ?

    – Fanie Void
    Nov 21 '18 at 16:32

















Do you have a table named ps_category_product ? In 1.6 it was here that the link between category and product was made, but I don't know for 1.7

– Fanie Void
Nov 21 '18 at 16:27





Do you have a table named ps_category_product ? In 1.6 it was here that the link between category and product was made, but I don't know for 1.7

– Fanie Void
Nov 21 '18 at 16:27













Can you have a look in your database ? Does your data is here ?

– Fanie Void
Nov 21 '18 at 16:32





Can you have a look in your database ? Does your data is here ?

– Fanie Void
Nov 21 '18 at 16:32












3 Answers
3






active

oldest

votes


















1














Finally I desist doing this by queries, now im using prestashop clases, and they work in good way and realy easy, just I dont know why all is working fine but the stock isnt updated, I post the code that worked for my inserts.



Code here



Some fields arent taken, so I update them with queries, and also I´m having troubles with the rewrite_link field, the class cant validate it sometimes but I have created the products and also the image attachment.






share|improve this answer































    0














    you have missing ' in your first query, try this :



    insert into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) VALUES ('".$id_nova."' ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')





    share|improve this answer



















    • 1





      I tried, just same result the first field is type int so it takes also with no 'x', but waht i mean is that the queries insert the data into de data base but prestashop cant list products i think i need to insert in ps_product_shop also. Thanks Hamed.

      – Jose Castillo
      Nov 22 '18 at 8:42



















    0














    You need to insert also to ps_product_shop. Adding products by SQL is not good idea becouse there is many dependencis. Better way is use API or CSV import. In product class you have $definitons array it is kinda of map for DB.



    https://devdocs.prestashop.com/1.7/development/database/objectmodel/






    share|improve this answer

























      Your Answer






      StackExchange.ifUsing("editor", function () {
      StackExchange.using("externalEditor", function () {
      StackExchange.using("snippets", function () {
      StackExchange.snippets.init();
      });
      });
      }, "code-snippets");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "1"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53416054%2fprestashop-products-inserted-by-db-not-showing%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      3 Answers
      3






      active

      oldest

      votes








      3 Answers
      3






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      1














      Finally I desist doing this by queries, now im using prestashop clases, and they work in good way and realy easy, just I dont know why all is working fine but the stock isnt updated, I post the code that worked for my inserts.



      Code here



      Some fields arent taken, so I update them with queries, and also I´m having troubles with the rewrite_link field, the class cant validate it sometimes but I have created the products and also the image attachment.






      share|improve this answer




























        1














        Finally I desist doing this by queries, now im using prestashop clases, and they work in good way and realy easy, just I dont know why all is working fine but the stock isnt updated, I post the code that worked for my inserts.



        Code here



        Some fields arent taken, so I update them with queries, and also I´m having troubles with the rewrite_link field, the class cant validate it sometimes but I have created the products and also the image attachment.






        share|improve this answer


























          1












          1








          1







          Finally I desist doing this by queries, now im using prestashop clases, and they work in good way and realy easy, just I dont know why all is working fine but the stock isnt updated, I post the code that worked for my inserts.



          Code here



          Some fields arent taken, so I update them with queries, and also I´m having troubles with the rewrite_link field, the class cant validate it sometimes but I have created the products and also the image attachment.






          share|improve this answer













          Finally I desist doing this by queries, now im using prestashop clases, and they work in good way and realy easy, just I dont know why all is working fine but the stock isnt updated, I post the code that worked for my inserts.



          Code here



          Some fields arent taken, so I update them with queries, and also I´m having troubles with the rewrite_link field, the class cant validate it sometimes but I have created the products and also the image attachment.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 22 '18 at 13:55









          Jose CastilloJose Castillo

          213




          213

























              0














              you have missing ' in your first query, try this :



              insert into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) VALUES ('".$id_nova."' ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')





              share|improve this answer



















              • 1





                I tried, just same result the first field is type int so it takes also with no 'x', but waht i mean is that the queries insert the data into de data base but prestashop cant list products i think i need to insert in ps_product_shop also. Thanks Hamed.

                – Jose Castillo
                Nov 22 '18 at 8:42
















              0














              you have missing ' in your first query, try this :



              insert into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) VALUES ('".$id_nova."' ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')





              share|improve this answer



















              • 1





                I tried, just same result the first field is type int so it takes also with no 'x', but waht i mean is that the queries insert the data into de data base but prestashop cant list products i think i need to insert in ps_product_shop also. Thanks Hamed.

                – Jose Castillo
                Nov 22 '18 at 8:42














              0












              0








              0







              you have missing ' in your first query, try this :



              insert into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) VALUES ('".$id_nova."' ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')





              share|improve this answer













              you have missing ' in your first query, try this :



              insert into ps_product (id_product, id_category_default, ean13, quantity, price, reference, width, height, depth, weight, id_supplier, id_shop_default, id_tax_rules_group, available_for_order, state) VALUES ('".$id_nova."' ,'".$categoria."', '".$ean."', '".$cantidad."', '".$precio."', '".$referencia."', '".$ancho."', '".$altura."', '".$profundidad."', '".$peso."', '0', '1','1', '1', '1')






              share|improve this answer












              share|improve this answer



              share|improve this answer










              answered Nov 21 '18 at 16:29









              HamedHamed

              262




              262








              • 1





                I tried, just same result the first field is type int so it takes also with no 'x', but waht i mean is that the queries insert the data into de data base but prestashop cant list products i think i need to insert in ps_product_shop also. Thanks Hamed.

                – Jose Castillo
                Nov 22 '18 at 8:42














              • 1





                I tried, just same result the first field is type int so it takes also with no 'x', but waht i mean is that the queries insert the data into de data base but prestashop cant list products i think i need to insert in ps_product_shop also. Thanks Hamed.

                – Jose Castillo
                Nov 22 '18 at 8:42








              1




              1





              I tried, just same result the first field is type int so it takes also with no 'x', but waht i mean is that the queries insert the data into de data base but prestashop cant list products i think i need to insert in ps_product_shop also. Thanks Hamed.

              – Jose Castillo
              Nov 22 '18 at 8:42





              I tried, just same result the first field is type int so it takes also with no 'x', but waht i mean is that the queries insert the data into de data base but prestashop cant list products i think i need to insert in ps_product_shop also. Thanks Hamed.

              – Jose Castillo
              Nov 22 '18 at 8:42











              0














              You need to insert also to ps_product_shop. Adding products by SQL is not good idea becouse there is many dependencis. Better way is use API or CSV import. In product class you have $definitons array it is kinda of map for DB.



              https://devdocs.prestashop.com/1.7/development/database/objectmodel/






              share|improve this answer






























                0














                You need to insert also to ps_product_shop. Adding products by SQL is not good idea becouse there is many dependencis. Better way is use API or CSV import. In product class you have $definitons array it is kinda of map for DB.



                https://devdocs.prestashop.com/1.7/development/database/objectmodel/






                share|improve this answer




























                  0












                  0








                  0







                  You need to insert also to ps_product_shop. Adding products by SQL is not good idea becouse there is many dependencis. Better way is use API or CSV import. In product class you have $definitons array it is kinda of map for DB.



                  https://devdocs.prestashop.com/1.7/development/database/objectmodel/






                  share|improve this answer















                  You need to insert also to ps_product_shop. Adding products by SQL is not good idea becouse there is many dependencis. Better way is use API or CSV import. In product class you have $definitons array it is kinda of map for DB.



                  https://devdocs.prestashop.com/1.7/development/database/objectmodel/







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Nov 27 '18 at 22:11

























                  answered Nov 27 '18 at 22:05









                  Marcin JaworskiMarcin Jaworski

                  757




                  757






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Stack Overflow!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid …



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53416054%2fprestashop-products-inserted-by-db-not-showing%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      -

                      Popular posts from this blog

                      Costa Masnaga

                      Image
                      .mw-parser-output .avviso .mbox-text-div>div,.mw-parser-output .avviso .mbox-text-full-div>div{font-size:90%}.mw-parser-output .avviso .mbox-image div{width:52px}.mw-parser-output .avviso .mbox-text-full-div .hide-when-compact{display:block} Questa voce o sezione sull'argomento Lombardia non cita le fonti necessarie o quelle presenti sono insufficienti . Puoi migliorare questa voce aggiungendo citazioni da fonti attendibili secondo le linee guida sull'uso delle fonti. Segui i suggerimenti del progetto di riferimento. Costa Masnaga comune Localizzazione Stato   Italia Regione Lombardia Provincia Lecco Amministrazione Sindaco Sabina Panzeri (Al centro il cittadino) dall'08/06/2009 Territorio Coordinate 45°46′N 9°17′E  /  45.766667°N 9.283333°E 45.766667; 9.283333  ( Costa Masnaga ) Coordinate: 45°46′N 9°17′E  /  45.766667°N 9.283333°E 45.766667; 9.283333  ( Costa Masnaga ) Altitudine 318 m s.l.m...
                      Read more

                      Fotorealismo

                      Image
                      Guerrino Boatto, Venice's St. Barnaba Church and canal Il fotorealismo è un genere di pittura basato sull'uso di una o più fotografie dalle quali l'artista prende le informazioni necessarie da utilizzare poi nel processo della creazione dell'opera, in genere ad olio o ad acrilico, al fine di avere un aspetto finale il più simile possibile alla fotografia. Indice 1 Storia 2 Lista dei fotorealisti 3 Note 4 Voci correlate 5 Altri progetti Storia | Il fotorealismo è un movimento che nasce negli Stati Uniti d'America alla fine degli anni sessanta [1] sulla scia della Pop Art [2] [3] [4] , e insieme condividono il carattere reazionario verso la travolgente ascesa dei media, che alla metà del ventesimo secolo si trasforma in un fenomeno di massa talmente imponente da minacciare il valore dell'immagine nell'arte. [5] [6] Ne consegue così che, colto il gesto d'inizio che fu della Pop Art, i fotorealisti aprono ad un ...
                      Read more

                      Sidney Franklin

                      Image
                      Questa voce sull'argomento registi statunitensi è solo un abbozzo . Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Sidney Franklin, foto di Carl Van Vechten Oscar alla memoria Irving G. Thalberg 1943 Sidney Franklin , all'anagrafe Sidney Arnold Franklin , (San Francisco, 21 marzo 1893 – Santa Monica, 18 maggio 1972), è stato un regista, produttore cinematografico e attore statunitense. Il 20 giugno 1963, si sposò con l'attrice australiana Enid Bennett. Il matrimonio durò fino alla morte dell'attrice, il 14 maggio 1969 [1] Indice 1 Filmografia 1.1 Regista 1.2 Aiuto regia (parziale) 1.3 Produttore 1.4 Attore (parziale) 2 Note 3 Altri progetti 4 Collegamenti esterni Filmografia | Regista | The Baby , co-regia Chester M. Franklin (1915) The Rivals , co-regia Chester M. Franklin (1915) Little Dick's First Case , co-regia Chester M. Franklin (1915) Her Filmland Hero , co-...
                      Read more