Hi Square,
One of my clients is running into this issue, where when they imported a new .xlsx file to modify the item library, the inventory/stock count is not re-counted when the value is set to 0 in the new quantity column.
Here is an example:
Token | Current Quantity | New Quantity |
3UVIGMIAVFQZIILTPP2W5OW4 | 20 | 0 |
P3STX35EDOBQ5UAUXX75FURB | 17 | 5 |
KQXRWYISWB3MXWTQJZXCNGFP | 20 | 0 |
RFHUEK6HANJHFJXHSGP4JKYB | 20 | 0 |
X7GJYOODALHTPXQQBGJGU3CV | 20 | 0 |
ODTQ3VT5PTLM73ZRSBCRIZCN | 16 | 0 |
VXURIMWVSNMDOVQ7AX5V44CI | 20 | 24 |
P4VRNW34BAHJAGAIMZPRZC22 | 14 | 0 |
AXJANMWLZ2JKMIKRSKR5X2BS | 17 | 55 |
P5H3JP3P3BZMR3IBPSUD3EIP | 20 | 2 |
An interesting finding was that, when the value in the new quantity column was greater than 0, the item inventory/stock was properly updated. And these items in the example definitely had inventory tracking enabled, since their current quantity were already above 0 in the first place.
I am not too sure what other info I should provide other than the token numbers, but please let me know if you anything else to proceed with investigation.
Thanks!
Hey there, @justsqitco,
How long has this been happening? We can definitely take a look into this, or get you pointed in the right direction!
Hi Ellie,
Thanks for reaching out. This incident specifically happened on July 5th, 2022, so it's roughly been a month. I do not know if this problem is still happening since I have not done any product import since then, but it'd be great if your team can investigate on this issue, cause it can potentially screw up seller's inventory count.
Square Community
Square Products