I've been struggling for months trying to figure out what feels like should be a really simple thing. Here's the set-up:
- I primarily sell on Etsy
- I have a Shopify website
- Shopify and Etsy inventories are connected via Shuttle
- I have wholesale / commission products at a comic store brick & mortar. They don't order products - I just load up the display, send a spreadsheet with the item info and they import it to their Shopify.
- I want to keep online inventory separate from in person so I don't accidentally oversell online.
- On Shopify, I created inventories for the "Home Base (online)" and "Comic Store"
- At the end of every month, the Comic Store send a spreadsheet of items that sold. I create a draft order, send the invoice through Shopify and they pay online. When I fulfill the order, it defaults to "Home Base" so I change the inventory location to "Comic Store".
- But it keep messing up my "Home Base" inventory anyways. (IE: Comic Store sold 3 of 5 XYZ, invoiced / paid. "Comic Store" inventory will be correct at 2. But Etsy will show sold out, even when I have 3 XYZ sitting at Home Base)
- I currently have 170+ products with multiple variations on most items.
This feels weirdly complicated and it doesn't even keep the inventory numbers correct, which was the main goal. The Comic Store is a busy place - I'm happy they let me sell some products there and I don't want to create any extra work on their part. This only brings is a couple hundred a month, so I don't want to open a 2nd Shopify account. I feel like I'm just missing something that would make this all work.
I'm also using spreadsheets and a script my husband wrote to make QR codes for the products I sell in person. It feels like there should be a better way to do this through Shopify too.
This is all making me feel hella stupid and super frustrated. Can anyone point me in the right direction?