thread Re: How can I add variations to better organize my shoe store inventory? in Archived Discussions (Read Only)

How can I add variations to better organize my shoe store inventory?

alanhalley — Sat, 27 Jul 2019 16:36:46 GMT

The title of this thread has been edited from the original: Shoes & Variations

I have 3,000 shoe items in Square without variations. How can I add variations to better organize my shoe store inventory?

Thanks for any ideas.

Alan

Re: How can I add variations to better organize my shoe store inventory?

Helen — Tue, 30 Jul 2019 18:03:33 GMT

Hello @alanhalley! We have a couple of folks who can help with inventory tips and tricks in the Community (👋@GlassDale @RHatch). Can you provide a bit more information about your current set up? Is it taking a long time to find items to ring up at your Point of Sale, or are you having a hard time tracking sales/inventory? Or both?

Re: How can I add variations to better organize my shoe store inventory?

alanhalley — Mon, 29 Jul 2019 17:23:37 GMT

Hi, Helen, @Glassware, @RHatch,

I just want to organize my inventory...

Re: How can I add variations to better organize my shoe store inventory?

RHatch — Tue, 30 Jul 2019 14:16:55 GMT

So what I would do is add your show style and then have the sizes and the variant

Example

Item: Black Dress Shoe

Variation 1 - Size 7

Variation 2 - Size 7.5

Variation 3 - Size 8

Etc.

This works even if you scan the boxes or not. If you are using POS and have buttons you will have a button for the item and then it will ask the size.

If you need further info let me know.

Re: How can I add variations to better organize my shoe store inventory?

alanhalley — Tue, 30 Jul 2019 19:15:55 GMT

I have a few thousand shoes in Square as items, no variations. Can I somehow reorganize the data into the item/variations structure?

Re: How can I add variations to better organize my shoe store inventory?

RHatch — Tue, 30 Jul 2019 19:32:27 GMT

Yes, You can do this by simply exporting your items and editing the spreadsheet and then loading it. However there are some things to know. The best thing to do is to edit one of your items in the dashboard first before you export it. That way you can see the difference.

To do this fine your item you want to start editing.

Let say you have Black shoe size 7 and Black shoe size 8, etc. (If you use a SKU or UPC you will need to delete the extra sizes first otherwise its going to say you already have that item.). So I would delete all the items except Black shoe size 7. In Black shoe size 7 I would:

Adjust the Name to Black Shoe - This will now be the name for all the variants.

Category, Description, Location, tax, should reflect accordingly. Now your variant probably says "Regular" that is the default. Change it to Size 7 or 7. The SKU and price and stock are the same.

Now click "Add Variation" Now put Size 8 or 8 and enter the SKU, Price and Stock for that size.

Repeat until you have all the sizes in for that item.

Then do it again, and again, and again.

As I mentioned you can now export your inventory and edit it in a spreadsheet. Using the one you just did you should be able to see the difference. I would do one and then try to upload it. You will then find your editing errors and learn from them. One thing I know is that the Description and Item name are the same for all Variations.

Hope that helps.

Re: How can I add variations to better organize my shoe store inventory?

alanhalley — Tue, 30 Jul 2019 19:42:48 GMT

Then do it again, and again, and again.

4,000 times! 😳

Thanks.