A quick overview:
We run a manufacturing facility/warehouse, and 4 retail locations in Colorado, and an office/warehouse in Ohio.
Currently all online and wholesale orders are shipped from the Colorado Warehouse. If someone orders online or via a sales rep from Ohio, we manually send those orders, and manually create shipping labels, so our sole employee in Ohio can ship them, or in some cases manually deliver them. Occasionally our main store gets a phone order, if so they just fill it and ship it from there.
Currently our website only sells products that are in the warehouse, it does not include the specifics of the retail stores full inventory.
We use shipstation to ship.
In shopify, we have each location running shopify POS and having its own inventory per store and the warehouse and even ohio office have their own inventory in shopify backend.
What I would like to do is slowly add products we sell in our main retail store to the website, but I dont want to purchase extra and keep it at the warehouse. So i would like customers to order, and IF the order contains an accessory or item thats only in the main retail store, that the order go to them in some sort of automatic fashion, ideally via shipstation.
The retail store carries everything thats in the warehouse, but the warehouse doesnt carry everything in the store, which is why we are currently limited.
so if a customer orders base product #1 which is in the warehouse, cool warehouse gets the order. If they order base product #1 and #7(only a retail item) the whole order comes to the retail store to ship.
is this possible?