thread Re: Current Quantity vs New Quantity in Archived Discussions (Read Only)

Current Quantity vs New Quantity

NailedItDIY — Fri, 16 Nov 2018 12:00:19 GMT

Hello all,

I am preparing to do an upload to modify my item list and add SKU numbers. I am not sure though what exactly to do with the New Quantity column. Do I need to copy my Current Quantity into the New Quantity, or if I leave New Quantity blank will it just keep the current quantity in the system? Last time I messed with these columns in an upload I accidentally duplicated all of my items. I'm trying to make sure that doesn't happen again.

Thanks for your help!

Re: Current Quantity vs New Quantity

Tom — Sat, 17 Nov 2018 20:56:41 GMT

👋Hey @NailedItDIY, welcome to the seller community!

When you do a bulk update, your Item Library will reflect the values that are entered (or not entered) into the template. For further clarification:

New Quantity: Enter the current stock count here. This count will replace any existing stock count.

Current Quantity: This is the current quantity of an item defined as in stock. Changes to this field are ignored on import.

Hope this clears things up! Please let me know if you have any further questions.

Re: Current Quantity vs New Quantity

NailedItDIY — Tue, 20 Nov 2018 19:06:05 GMT

Thank you for helping me with my question, Tom! Just so I'm sure I understand, if I don't enter a value in New Quantity, does Square maintain the Current Quantity or does it set everything to 0?

Re: Current Quantity vs New Quantity

Helen — Tue, 20 Nov 2018 23:21:54 GMT

Helen here stepping in for Tom today! If you don't enter a different value or any value to New Quantity it doesn't change your Current Quantity (and won't set everything to 0).

Re: Current Quantity vs New Quantity

NailedItDIY — Wed, 21 Nov 2018 12:16:50 GMT

Thanks for your help!

Re: Current Quantity vs New Quantity

stuffedpretzel — Thu, 10 Aug 2023 22:05:24 GMT

So I have an additional question about these two fields

So if my import includes rows that already exist in square that have current stock values >0.

So if I leave Current Stock blank and enter a value in New stock will those two values be added together... ie Current stock is 2 and I update the record to have a New stock of 3 will it show a total of 5 or will it overwrite it to be 3??

Re: Current Quantity vs New Quantity

Candlestore — Fri, 11 Aug 2023 14:53:35 GMT

@stuffedpretzel ;

New Stock will be whatever you put in.

So Current Stock of 3 Received 2 and Enter 2 as New Stock this will have your Stock at 2. Think of New stock as a total Recount not adding to your Current stock or Stock Received.