thread Managing Inventory with variants in Archived Discussions (Read Only)

Managing Inventory with variants

toysafari — Wed, 01 Nov 2017 23:28:30 GMT

We have a large inventory, which was originally made digital on a different point of sale and we recently switched to square. One improvement that is coming with square is the option to have variants for one item, variants with different prices and SKUs.

So i have a couple of questions regarding this:

Is there a way to convert items from individual items into one item with multiple variants that is more efficient than going one by one through our inventory?

what is the best way to enter new items when i want to create those items with variants, is there template that i need to follow?

Re: Managing Inventory with variants

RHatch — Thu, 02 Nov 2017 12:50:10 GMT

You can edit or add your items and inventory via a .csv or excel spreadsheet. I would enter one item into the system manually and then export the sheet. This way you will be able to see how it works.

Things to know. Any item name that is the same on your sheet the system puts together as a variant. You must then have a different variant name for each. If there is no variant they system will add the work Regular in the variant cell.

Item Name: Variant:

T-Shirt Small

T-Shirt Medium

T-Shirt Large

Each varient and item must have a different UPC/SKU. You have a separate price for each, can be the same or different.

Also because this is a new upload make sure your quantity is in the "New Quantity Column or it will not add it.

Re: Managing Inventory with variants

Tom — Sat, 04 Nov 2017 20:47:33 GMT

Thanks for helping out with this, @RHatch. Additional information on this is available in our Support Center: Import Items Online.

Adding inventory to several variations at once

NathalieCo — Mon, 28 Dec 2020 20:47:10 GMT

Is it possible to add inventory quantities to several variations of an item at the same time? For instance, if I get in 2 of each size, is there a way to just add 2 to all of the variations at one time instead of going in and adjust stock on each variation?

Re: Adding inventory to several variations at once

JustinC — Tue, 29 Dec 2020 19:09:56 GMT

The fastest way is to add stock amounts on a spreadsheet and uploading it to the Item Library.

I found a thread that will help! I moved you so your can learn more. @NathalieCo