Jump to content

ebay module NOT updating zero qtys


Jack Gill
 Share

Recommended Posts

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!

 

 

 

 

Share this post


Link to post
Share on other sites

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 by Jack Gill (see edit history)

Share this post


Link to post
Share on other sites

  • 7 months later...

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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More