ebay module NOT updating zero qtys

[Jack Gill]

We have inserted 230 items on ebay using this module, all is working fine except for when the item quantity becomes zero (out of stock!),ebay is NOT updated!!!

 

We are using a program what inserts quantities directly into the database, module will update ebay with all positive qty changes (i.e. greater than 0), but when the qty goes to zero, our website (www.micro-logic.com) will show correctly (ie "This product is no longer in stock") , but ebay still shows the last positive quantities!

 

Our ebay store = http://stores.ebay.co.uk/Micrologic-Computers/Other-/_i.html?_fsub=1

 

Has anyone else come across this error/ issue?

 

when '9' inserted into database >> website shows qty '9' >> ebay updated to qty '9'

 

when '4' inserted into database >> website shows qty '4' >> ebay updated to qty '4'

 

when '0' inserted into database >> website shows qty '0' >> ebay still shows qty '4' !!!! (NOT updated)

 

If we manually change the qty in BO from a positive to zero - ebay will update to '0' and remove the product from sale.

 

Please help as we are selling items we cannot supply!

 

 

 

 

[Prestalia]

verify if your sistem change the quantity in ps_product ( the table of prestashop 1.4) and the new table for 1.5 ps_stock.....

 

regards

[Jack Gill]

We have the following statements in our program ;

 

$sql_update_1="UPDATE `mlc_product` SET `active`='0',`quantity`='0' WHERE supplier_reference='".$prod['SuppierRef']."'";
      echo $prod['SuppierRef']," = ", $prod['StockQty']," >> Stock set to zero and de-activated!","<br />";
 
      if  ( ! $sql_update_1=mysql_query($sql_update_1))
      {
                            echo mysql_error();
                            exit;
                        }

 

 

     $sql_update_2="UPDATE `mlc_stock_available` SET `quantity`='0' WHERE id_product IN (select id_product from mlc_product WHERE supplier_reference='".$prod['SuppierRef']."')";
                         if  ( ! $sql_update_2=mysql_query($sql_update_2))
       {
                             echo mysql_error();
                             exit;
                         }

 

Our website quantities are correct!! - ebay is correctly updated with postive qtys, ebay is not updated when item has a zero quantity (out of stock)!!!!

Edited February 10, 2014 by Jack Gill (see edit history)

[danivh]

Hi Jack Gill

We are facing the same problem as you stated.

Have you found any solution?

Thanks!

[irrelevant]

What version of the module are you using?

 

Try adding a record into ps_ebay_product_modified as well - I think that should force an update of the product on next sync.