Item code not sync with SKU

Viewing 4 reply threads
  • Author
    • #1454

      I have uploaded all products and matched the SKU with the inventory item codes in Xero but when i place an order, Xero generated new inventory items instead of syncing the stock quantity. I set the sync inventory master to Xero. Do i need to adjust any other settings?

    • #1455
      Peter Lloyd

      No that should work. It uses the SKU codes in Woo to find the matching product in Xero and will only generate a new code if that SKU doesn’t exist. Do they match exactly? Are there any spaces or special characters in your codes? Is it a variable product as each variation needs a match? Does it happen with all products or just certain ones?

    • #1457

      Hi Peter,

      Thank you for the quick reply. I just ran another test again and it added an extra inventory item in Xero even though the SKU is matched with anitem.

      Below is my test case:

      1. I setup Item A (Item code 111) in Xero with 0 quantity
      2. I made a product Item A (SKU 111) in the site with 10 quantity
      3. I placed an order for 1 product of Item A and paid for it using Paypal.
      4. The order is generated in the backend and Xero generated an invoice
      5. A new Item A appear with a different Item code (112) in Xero without any detail info
      6. The admin email received Back Order notification.
      7. The stock level of Item A in Woocommerce backend become -1

      The SKU seems to work only for Woocommerce side, the stock quantity in Woocommerce has been updated but the inventory items were not updated in Xero.

      I can send you some screenshots if you need them.

      I download the version 2.0.4 from the Download page.

      Please get back to me as soon as possible because we have already received some orders and it is messing up our inventory on Xero.

      Thank you!

      Kind Regards,

    • #1458

      FYI, I purchased the premium licence yesterday.

    • #1459
      Peter Lloyd

      Hi Owen

      You have Xero set as the inventory master but with no inventory. Xero won’t permit you to have backorders. You have various options for handling the stockouts – please read the article here

      What do you have as the price master? To check it is working properly pls set inventory synch to none and add stock to your Xero test item and repeat the test. If that doesn’t work then try with Woo set to be the Price master. Then you can test it with Xero as the inventory master.

      Let me know the results.

Viewing 4 reply threads
  • The forum ‘Xeroom Support Forum’ is closed to new topics and replies.